Home » RDBMS Server » Server Administration » How much memory taken from SGA when connect a User
How much memory taken from SGA when connect a User [message #64416] Mon, 24 January 2005 19:51 Go to next message
Ahmar Nishat
Messages: 3
Registered: December 1999
Junior Member
How much memory taken from SGA when connect a User. This user is not doing any thing except got the connect from Oracle. How much memory will Oracle allocate for the connection. Any hard n fast rule.

Thanks.

Report message to a moderator

Re: How much memory taken from SGA when connect a User [message #64433 is a reply to message #64416] Fri, 28 January 2005 06:31 Go to previous message
jack
Messages: 123
Registered: September 2000
Senior Member
If the user just connect to the instance, he will use no memory from SGA. The Oracle instance just allocate PGA for the connection.

Report message to a moderator

Previous Topic: sys tables
Next Topic: oracle8i problem
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jan 10 03:40:52 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.