| session PGA memory [message #169979] |
Mon, 01 May 2006 06:45 |
venkii_g
Messages: 1
Registered: May 2006
Location: INDIA
|
Junior Member |
|
|
Hi,
We are running the oracle 8.1.7.4.1 db in MT/shared server. when i login to the database from clients, the client session takes 12MB sesssion pga memory. these session are just connected to db ie. idle sessions.
SELECT s.VALUE / 1024 / 1024 mb, sess.SID, p.pid, bg.NAME, sess.program,
sess.osuser, sess.username, status, server
FROM v$sesstat s,
v$statname n,
v$session sess,
v$process p,
v$bgprocess bg
WHERE n.statistic# = s.statistic#
AND s.SID = sess.SID
AND sess.paddr = p.addr
AND p.addr = bg.paddr(+)
AND n.NAME IN ('session pga memory')
ORDER BY 1 DESC
MB SID PID NAME PROGRAM OSUSER USERNAME STATUS SERVER
11.84 91 32 TOAD.EXE c0059 TOTALPLANT INACTIVE NONE
MB SID PID NAME PROGRAM OSUSER USERNAME STATUS SERVER
12.44 87 31 aspnet_wp.exe ASPNET TRACKER INACTIVE NONE
Please let me why is happening like this?. Is there any parameter related with this.
Thanks and Regards
Venkatesh
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
