DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: db admin

  1. #1
    Join Date
    Mar 2003

    db admin

    Please answer me the following points:

    1. Want to know the script which when run from the cmd prompt will report the db Space usage info & will alert when the db is reaching its limit. I dont want to use the statspack or built in scripts.

    2. What is the difference between rebuilding & coalesceing an index & when to use each one of them.

    3. On unix os all the filesystem are 90% full. In that case I cannot perform a full db exp. In that case how will I know what will be the size of the Dump file created if I try to take a full db exp.

    4. The temp ts is showing some space missing. Where it might have gone.

    5. How will I know if the temp ts is fragmented.

    6. The db is running in archive mode. I have taken hot backup of users ts on mon, rbs ts on tue & system ts on wed. On thu the whole db is crashed. How will I recover the db & bring it up, will all ts I need to restore.

    7. When I try to insert a rec in emp table in users ts I get insufficient space error for the system ts. What can be the reason & in which ts I need to add space.

    8. I have an emp table in users ts. I want to imp it into another db in data ts.

    9. If I add the system rbs name in the rollback_segment para list in init.ora, what error will I get.

    Have a nice time.

    Thank you.

  2. #2
    Join Date
    Feb 2003
    boy, you need to read some book dont you?

    or the fashion word RTFM

  3. #3
    Join Date
    May 2002
    This is not a homework forum either.

Posting Permissions

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

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.