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
Brayan
Messages: 315
Registered: June 2002
Senior Member
Hi,

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.

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

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 Dec 04 18:31:11 CST 2016

Total time taken to generate the page: 0.09815 seconds