Forgot your password?    
+ Post New Thread
Threads 1 to 39 of 39

Forum: Database Scripts


Most Viewed Topics
RMAN Script to take a HOT BACKUP of Database using Catalog
Script to get the list of sessions for a user currently in the Database
Script to take User Managed Hot Backup for an Oracle Database
Script to create a new user (with privs) like an existing database user
Script to get Current Sessions (SID,SPID) and SQLs for all Active Sessions
UNDO UTILIZATION for Tablespace and for Session
SORT SPACE Utilization Session Wise
Check Database Long Runing Sessions
Get the OS PROCESS ID from the SID for a Database session
SQL TEXT for a Particular Session SID/ users current sql
Script to find the session who is doing FTS(Full table scan)
Multiple SQLs to DIAGNOSE PGA issues at runtime
Scripts to list Scheduled and Running Jobs from DBMS_JOB
STATUS CHECK script for RAC Database
Script to find ASM Disk and Diskgroup Space Utilization , ASM Operations in Progress
Script to Find LOCKED OBJECTS in the Database - Particular session / all sessions
Script to find LOCKS - BLOCKING and WAITING sessions
Script Gives summary of the buffers in the SGA
Hit/Miss Ratios for SGA Components
Script to GENERATE CREATE DATABASE Script from existing Database
CREATE DATABASE Sample Script
Script to check the DB space
Quick Generation of EXECUTION PLAN for a SQL
Script to Generate and Analyze the EXECUTION PLAN for an SQL Statement
Detect Possibly Fragmented Objects - Reorg Candidates
Snapshot View of Tablespace Utilization for all tablespaces with Used and Free Space
Script to compile invalid objects in DB

    • Replies: 0
    • Views: 3,586
    07-22-2014, 10:31 AM Go to last post
    • Replies: 1
    • Views: 11,367
    11-13-2013, 09:50 AM Go to last post
  1. Customizing SQL Prompt

    Started by Amit‎, 09-01-2012 12:18 AM
    customizing, prompt, sql
    • Replies: 0
    • Views: 3,823
    09-01-2012, 12:18 AM Go to last post
  2. Display any long operations

    Started by devesh_ocp‎, 04-24-2012 10:41 PM
    • Replies: 0
    • Views: 1,388
    04-24-2012, 10:41 PM Go to last post
  3. Sessions sorted by logon time

    Started by devesh_ocp‎, 04-24-2012 10:39 PM
    • Replies: 0
    • Views: 1,162
    04-24-2012, 10:39 PM Go to last post
  4. Show all connected users

    Started by devesh_ocp‎, 04-24-2012 10:38 PM
    • Replies: 0
    • Views: 1,452
    04-24-2012, 10:38 PM Go to last post
  5. Script to Get Oracle Database info

    Started by shoaibansari‎, 02-14-2012 08:02 PM
    • Replies: 1
    • Views: 3,172
    02-14-2012, 08:09 PM Go to last post
    • Replies: 0
    • Views: 2,013
    02-06-2012, 09:17 PM Go to last post
  6. Determine SCNs applied on the LOGICAL STANDBY

    Started by Hemant‎, 02-03-2012 06:38 PM
    10g, applied, apply, database, determine, logical, logical standby, oracle, scn, standby
    • Replies: 0
    • Views: 1,677
    02-03-2012, 06:38 PM Go to last post
  7. Find Unsupported Tables to Create a LOGICAL STANDBY

    Started by Hemant‎, 02-03-2012 06:34 PM
    10g, create, find, logical, oracle, query, script, standby, table, tables, unsupported
    • Replies: 0
    • Views: 4,992
    02-03-2012, 06:34 PM Go to last post
    • Replies: 0
    • Views: 8,528
    01-23-2012, 10:35 PM Go to last post
  8. Script to check blocking lock in DB (9i and earlier)

    Started by RohitB‎, 01-10-2012 06:33 PM
    • Replies: 0
    • Views: 2,486
    01-10-2012, 06:33 PM Go to last post
    • Replies: 0
    • Views: 5,425
    01-10-2012, 06:22 PM Go to last post
    • Replies: 0
    • Views: 17,731
    01-02-2012, 12:46 AM Go to last post
    • Replies: 0
    • Views: 5,979
    01-01-2012, 04:59 PM Go to last post
    • Replies: 1
    • Views: 5,785
    01-01-2012, 03:50 PM Go to last post
    • Replies: 0
    • Views: 5,649
    01-01-2012, 01:40 PM Go to last post
    • Replies: 0
    • Views: 7,478
    01-01-2012, 01:33 PM Go to last post
  9. Create Database Script

    Started by Hemant‎, 12-25-2011 03:10 PM
    • Replies: 0
    • Views: 4,260
    12-25-2011, 03:10 PM Go to last post
  10. Script to analyze redo logs generation

    Started by Amit‎, 11-20-2011 09:22 AM
    analyze, database, generation, log, oracle, redo, redo log, script, session
    • Replies: 2
    • Views: 3,135
    11-20-2011, 09:23 AM Go to last post
  11. Script to find lock object

    Started by Amit‎, 11-04-2011 12:46 PM
    lock object
    • Replies: 0
    • Views: 1,721
    11-04-2011, 12:46 PM Go to last post
  12. Script to check the Database space

    Started by Amit‎, 11-03-2011 03:53 PM
    db space
    • Replies: 0
    • Views: 5,480
    11-03-2011, 03:53 PM Go to last post
  13. Script Gives summary of the buffers in the SGA

    Started by Amit‎, 11-03-2011 02:27 PM
    sga
    • Replies: 0
    • Views: 3,761
    11-03-2011, 02:27 PM Go to last post
  14. Script to compile invalid objects in DB

    Started by Amit‎, 11-03-2011 01:03 PM
    compile
    • Replies: 0
    • Views: 4,220
    11-03-2011, 01:03 PM Go to last post
  15. Check Database Long Runing Sessions

    Started by Amit‎, 11-03-2011 12:52 PM
    • Replies: 0
    • Views: 3,811
    11-03-2011, 12:52 PM Go to last post
  16. Hit/Miss Ratios for SGA Components

    Started by Amit‎, 11-03-2011 12:42 PM
    • Replies: 0
    • Views: 4,279
    11-03-2011, 12:42 PM Go to last post
  17. Health Check script for RAC DB

    Started by Amit‎, 11-03-2011 12:41 PM
    health shech, rac database, status check scripts
    • Replies: 0
    • Views: 4,902
    11-03-2011, 12:41 PM Go to last post
  18. Undo Utilization for Tablespace and for Session

    Started by Hemant‎, 11-02-2011 08:13 PM
    10g, 11g, database, for undo tablespace, how much, how to, oracle, query, script, session, session undo utilization, space, tablespace, undo, undo utilization, utilization
    • Replies: 0
    • Views: 5,611
    11-02-2011, 08:13 PM Go to last post
  19. Session Wise Sort Space Utilization

    Started by Hemant‎, 11-02-2011 08:07 PM
    10g, 11g, database, how to, oracle, query, script, session, session wize, sid, sort, sort area utilization, sort usage, sort_usage, space, utilization
    • Replies: 0
    • Views: 3,814
    11-02-2011, 08:07 PM Go to last post
    • Replies: 0
    • Views: 4,576
    11-02-2011, 08:05 PM Go to last post
  20. Quick Generation of Execution Plan for a SQL

    Started by Hemant‎, 11-02-2011 07:56 PM
    dbms_xplan, execution plan, generate, plan_table
    • Replies: 1
    • Views: 1,671
    11-02-2011, 07:56 PM Go to last post
    • Replies: 0
    • Views: 8,612
    11-02-2011, 07:41 PM Go to last post
    • Replies: 0
    • Views: 4,746
    11-02-2011, 07:39 PM Go to last post
    • Replies: 0
    • Views: 6,296
    11-02-2011, 07:29 PM Go to last post
  21. Multiple SQLs to Diagnose PGA issues at runtime

    Started by Hemant‎, 11-02-2011 07:24 PM
    diagnose, high pga sessions, issues at runtime, pga, pga usage
    • Replies: 0
    • Views: 4,102
    11-02-2011, 07:24 PM Go to last post
  22. Script to find locks - blocking and waiting sessions

    Started by Hemant‎, 11-02-2011 07:21 PM
    blocking, locks, script, waiting sessions
    • Replies: 0
    • Views: 6,009
    11-02-2011, 07:21 PM Go to last post
  23. Script to Assess Fragmented objects for Reorg

    Started by Amit‎, 11-02-2011 03:25 PM
    reorg tables
    • Replies: 0
    • Views: 6,488
    11-02-2011, 03:25 PM Go to last post
    • Replies: 0
    • Views: 4,704
    11-02-2011, 03:23 PM Go to last post
  24. Resize Datafiles to avoid alert

    Started by Amit‎, 11-02-2011 03:22 PM
    resize datafile
    • Replies: 0
    • Views: 1,223
    11-02-2011, 03:22 PM Go to last post

+ Post New Thread

Thread Display Options

Use this control to limit the display of threads to those newer than the specified time frame.

Allows you to choose the data by which the thread list will be sorted.

Order threads in...

Note: when sorting by date, 'descending order' will show the newest results first.

Icon Legend

Contains unread posts
Contains unread posts
Contains no unread posts
Contains no unread posts
More than 15 replies or 250 views
Hot thread with unread posts
More than 15 replies or 250 views
Hot thread with no unread posts
Closed Thread
Thread is closed
Thread Contains a Message Written By You
You have posted in this thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

DBA Lounge (P) Ltd. deals in Oracle Technologies on Consulting, Resourcing, Corporate Training


Online and corporate training available on Oracle Database 11g, Oracle 11g Real Application Cluster (RAC), Oracle Applications 11i/R12, Oracle Fusion Middleware 11g, Oracle Identity Management-OIM, Oracle Internet Directory 11g-OID, Oracle Business Intelligence Enterprise Edition-OBIEE, Oracle Golden Gate, Oracle Access Management-OAM, Oracle Internet Directory-ODS, Oracle Identity Analytics Architecture-OIA Statistics