Very Curious ???????
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Very Curious ???????

  1. #1
    Join Date
    Jun 2000
    Posts
    179

    Talking

    I noticed that from time to time one of my databases ( I use NT 4 SP 6 with 5 instance running on it Oracle server ver 8.0.4 ) keeps the server's hard disk working like hell even if there is no one connected to any other instance at all.

    Could be this from the SMON ( defragmenting for instance ) , it does not return any error messages but it keeps working like this for 2 or 3 days continously then it gets back to its normal status.

    Also performance degradation happens during this process.

    What could be the cause ??

    Thank You
    Hisham Nagia
    IT Manager For Development
    Oracle Consultant - OCP

  2. #2
    Have you checked Memory usage?
    Maybe it's beyond physical memory so the disk activity is swapping/paging.
    Another thing: I don't know if in 8.0.4 you can, but try to create your TEMPORARY tablespace with the TEMPORARY clause, not PERMANENT.
    Ramon Caballero, DBA, rcaballe@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