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

Forum: Oracle Database Administration 10g and 11g

Sub-Forums Threads / Posts  Last Post

  1. To be Active from 1st Sep 2014

    Forum Actions:

    Forum Statistics:

    • Threads: 18
    • Posts: 24

    Last Post:

    Oracle Database 11g... Go to last post

    by Vijay Reddy

    06-05-2013, 04:28 PM


  2. 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

    Forum Actions:

    Forum Statistics:

    • Threads: 39
    • Posts: 45
  3. Interview questions to prepare and test yourself for Oracle Database.

    Forum Actions:

    Forum Statistics:

    • Threads: 5
    • Posts: 16
  1. Moved: Script to Get Oracle Database info

    Started by shoaibansari‎, 02-14-2012 08:02 PM
    •  
    •  
  2. Moved: Oracle Database V$ Views

    Started by Pradeep‎, 12-14-2011 05:04 AM
    •  
    •  

+ 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