1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Oracle dba: useful queries 2011-11-14

Oracle dba: useful queries

  1. sharon_gst
    1. How do you know the database name from normal user(connected) in the database
    2. How to find the user objects created by him/her in his/her schema
    3. showing the table structure
    4. sql which show you the allocated, Free and Used space in each of the datafiles
    5. Monitor long running operations using v$session_longops
    6. query can be used to monitor RMAN backup status
    7. how to find a session with high archive logs
    8. Query to find backupset sizes