Home » RDBMS Server » Performance Tuning » SGA related queries
SGA related queries [message #558627] Mon, 25 June 2012 04:48 Go to next message
charuamit
Messages: 121
Registered: January 2009
Senior Member
Dear Friends

I have a couple of questions...I started reading about SGA and am little confused .

My init.ora :

java_pool_size=62914560
large_pool_size=41943040
shared_pool_size=125829120

SQL> show parameter pfile;

NAME TYPE
------------------------------------ --------------
VALUE
------------------------------
spfile string
G:\ORACLE\PRODUCT\10.1.0\DB_1\
DATABASE\SPFILEORCL.ORA

SQL> show parameter sga;

NAME TYPE
------------------------------------ -----------------
VALUE
------------------------------
lock_sga boolean
FALSE
pre_page_sga boolean
FALSE
sga_max_size big integer
1002438656
sga_target big integer
838860800

Before we had manual memory management.
Later i made it automated by setting the sga_target and sga_max_size.
But i didn't make the settings for java pool , large pool and shared pool 0 in init.ora ...

Doubt 1 :
Should I make them zero in init.ora or it doesnot matter as spfile is used for instance startup in my case ?

Doubt 2 :

My SGA size is 800 MB.
Now :

sql > 1 select pool,sum(bytes) from v$sgastat
2* group by pool
3 /

POOL SUM(BYTES)
------------ ----------
java pool 62914560
large pool 29376164
shared pool 205520896
538187180

that blank column is for what ? Is it the Null pool (means the redo and data buffers )


SQL> select sum(bytes) from v$sgastat;

SUM(BYTES)
----------
835998800
means approx 797.8 MB

where my SGA is 800MB ...does that mean I very little free space left in SGA ....do i need to do something or is it fine..

Sorry for asking a lot !!
But need clarifications to make my concepts clear.

Thanks and Regards.

Re: SGA related queries [message #558636 is a reply to message #558627] Mon, 25 June 2012 05:12 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
From a previous topic from you:
Michel Cadot wrote on Sun, 14 February 2010 09:48
Please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version with 4 decimals.

Use SQL*Plus and copy and paste your session WITH LINE NUMBERS.
...


So repost accordingly and maybe we will have a look to your post.

Regards
Michel
Previous Topic: what's the relationship between the number of blocks and consistent gets ?
Next Topic: performance improvement of clob data
Goto Forum:
  


Current Time: Fri Mar 29 02:16:12 CDT 2024