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

Thread: Shutdown

  1. #1
    Join Date
    Feb 2002
    Posts
    267
    hi,
    Is there any view to find out abt my last shutdown.....

    ie., whether it was a normal shutdown or was it an shutdown abort.....
    regards
    sonia

  2. #2
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    It's recorded in the alert log, but I don't think it's recorded in any DD table.

    Regards
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  3. #3
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Oracle does not store the shutdown date/time but you can check the alert.log file.

    Why don't you create an event trigger and insert the information you need in a table?
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g
    email: ocp_9i@yahoo.com

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