Home » RDBMS Server » Server Administration » database hang + page file (oracle 10gr2, windows server 2003 standard edition)
database hang + page file [message #346292] Mon, 08 September 2008 02:18 Go to next message
vijaychauhan
Messages: 106
Registered: December 2005
Senior Member
hi!
I am using windows 2003 standard edition, the RAM on the server is 4gb, the database is 10g release 2. the virtual memory is 7.5 gb. there is an oracle database on the server which is having 1.7 gb memory configured(sga + pga). The value of proceess=150 and sessions=170 in spfile. The database hangs when the v$sessions shows number of session around 150, what can be reason for database hanging, The page file usage is around 3 gb, there are no other applications running on the server, what can be the reason for such high usage of page file.
thank you
Re: database hang + page file [message #346349 is a reply to message #346292] Mon, 08 September 2008 05:36 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

what can be reason for database hanging

many reason.

did you check "alertsid.log" file?
Previous Topic: ORA-04031: unable to allocate 4192 bytes of shared memory
Next Topic: Migrating to 10.2.0.3
Goto Forum:
  


Current Time: Thu Nov 14 04:05:51 CST 2024