Home » RDBMS Server » Server Administration » About Oracle instance
About Oracle instance [message #55984] Fri, 28 February 2003 01:07 Go to next message
Dhiren
Messages: 43
Registered: July 2002
Member
Hii,

I would like to know the exact amount of memory been allocated when user connects to the Oracle server.

My problem is, I got my Oracle server hang when more than 100 users connect simultaneously. Can I increase the size of SHARE_POOL_SIZE parameter in Parameter file ?

Thanx,

Dhiren

Report message to a moderator

Re: About Oracle instance [message #56007 is a reply to message #55984] Fri, 28 February 2003 15:57 Go to previous message
Trifon Anguelov
Messages: 514
Registered: June 2002
Senior Member
Per your request, scripts to calculate how much memory each user's session takes:

UGA & PGA
UGA & PGA

Hope that helps,

clio_usa
OCP - DBA

Visit our Web site

Report message to a moderator

Previous Topic: can't create second database instance
Next Topic: Archive logswitch every minute (Oracle 8.1.7)
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Dec 28 20:54:44 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.