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

Thread: db admin

  1. #1
    Join Date
    Mar 2003
    Posts
    34

    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
    Posts
    85
    boy, you need to read some book dont you?

    or the fashion word RTFM

  3. #3
    Join Date
    May 2002
    Posts
    2,645
    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