Home » RDBMS Server » Performance Tuning » Is there enough SGA
Is there enough SGA [message #185119] Mon, 31 July 2006 01:41 Go to next message
Messages: 315
Registered: June 2002
Senior Member

I'm running a Oracle process in a development server, the process is running very slow.

Can anybody tell me how to check is there enough SGA available.

Or what other checks I have to perform.

Re: Is there enough SGA [message #185151 is a reply to message #185119] Mon, 31 July 2006 04:19 Go to previous message
Messages: 619
Registered: July 2006
Senior Member

IMHO you have first to tune your SQL statements, before increasing the SGA.
Previous Topic: High parse count over db_link from 9i to 9i?
Next Topic: Indexing question
Goto Forum:

Current Time: Mon Aug 21 03:19:29 CDT 2017

Total time taken to generate the page: 0.04138 seconds