Maximum sga size per session

monoj Feb 10, 2013 10:46 PM

Currently Being Moderated

Dear all,

Can any one tel me maximum sga a session can consume max.

I want to set session parameter value as 1500 so want to know maximum sga will be requiring to support 1500 session.

Please help me out to short out the above problem.

Thanks and Regards
Monoj Das

1. Re: Maximum sga size per session

monoj Feb 10, 2013 10:57 PM (in response to monoj)

Currently Being Moderated

In my production database dynamic sga has been enabled

SGA_TARGET=5344M
SGA_MAX_SIZE=5344M and

My sga_max_size is almost 5.3GB

Do i need to increase the size to support 1500 session..

Please give some example of your calculation and You link is not working.

Thanks and regards
Monoj
Report Abuse

Like (0)
2. Re: Maximum sga size per session

Osama_Mustafa Feb 10, 2013 10:59 PM (in response to monoj)

Currently Being Moderated

You post this thread before ,
Maximum sga_max_size amd sga_target to support 1500 session

Close this one please , don't duplicate your thread
Report Abuse

Like (0)

Go to original post

Actions

Legend

Correct Answers - 10 points
Helpful Answers - 5 points