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: 611
Registered: July 2006
Senior Member

IMHO you have first to tune your SQL statements, before increasing the SGA.
Previous Topic: Dilemma on Loading and querying.
Next Topic: Collecting Stats taking long to execute in PL/SQL code
Goto Forum:

Current Time: Sun Oct 23 18:57:36 CDT 2016

Total time taken to generate the page: 0.04552 seconds