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.

Report message to a moderator

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: 621
Registered: July 2006
Senior Member
Hi.

IMHO you have first to tune your SQL statements, before increasing the SGA.

Report message to a moderator

Previous Topic: Dilemma on Loading and querying.
Next Topic: Collecting Stats taking long to execute in PL/SQL code
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 12 05:54:21 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.