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

Thread: database hung

  1. 04-24-2003, 10:03 AM #1
    mike2000
    mike2000 is offline Senior Member
    Join Date
    Sep 2002
    Posts
    411

    database hung

    what could cause the database hung???? I don't know the reason why it hung b/c there are no errors on the log file, neither the trace files.

    the database is 8i version running Windows 2000 and I know a lot of peers in here will say "it's b/c windozzzz"

    any thought????

    p.s no archive log mode on this database.
    Reply With Quote Reply With Quote
  2. 04-24-2003, 10:06 AM #2
    Mr.Hanky's Avatar
    Mr.Hanky
    Mr.Hanky is offline X-Mas poo
    Join Date
    Jan 2001
    Posts
    3,134
    It must be Italian

    Can you see and long running sessions in OEM?
    Can you re-boot it?
    Windows does need to be re-booted every once in a while.

    MH
    I remember when this place was cool.
    Reply With Quote Reply With Quote
  3. 04-24-2003, 10:10 AM #3
    DaPi's Avatar
    DaPi
    DaPi is offline Old Cranky Philosopher
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    What do windows perf mon and task manager say about it? Any disk activity? Really hung or just a query that takes forever?
    "The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman
    Reply With Quote Reply With Quote
  4. 04-24-2003, 11:32 AM #4
    mike2000
    mike2000 is offline Senior Member
    Join Date
    Sep 2002
    Posts
    411
    really hung and reboot the server fix the problem, but this happen three times in two weeks.


    no errors were generated.

    any other thoughts???
    Reply With Quote Reply With Quote
  5. 04-25-2003, 05:23 AM #5
    Giani's Avatar
    Giani
    Giani is offline Oracle DBA
    Join Date
    Nov 2002
    Location
    Dublin, Ireland
    Posts
    133
    Hi Mike,

    "it's b/c windozzzz"

    Well, I am thinking of your virtual memory... What's your max paging file size? and how many of them? I think you should look there because if your paging file/s filled to max size on the same drive
    of your audit_file_dest (your drive might filled to 100%) then no connect internal is possible and database could hung... that's explain why you did not get any error message.
    Other possiblilities: I know you said your database was not on no archive log mode in general try to put audit_file_dest, log_archive_dest and ORACLE_HOME away from paging drive.

    HTH

    Regards,
    Giani
    Reply With Quote Reply With Quote
« Previous Thread | Next 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
  •  

Forum Rules

Click Here to Expand Forum to Full Width