OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning » more reloads

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

more reloads [message #315079]

Fri, 18 April 2008 21:25

pramod_garre
Messages: 6
Registered: April 2008

Junior Member

Hi Gentlemen,

In my Database frequent reloads have been happening.My shared pool is of 1 GB and all sum o f sharable_mem of all sqls,packages ,triggers and everythin(collected from v$db_object_cache) is a mere 1 MB.In this case,how ageing has been happening and thus reolads??

Report message to a moderator

Re: more reloads [message #315080 is a reply to message #315079]

Fri, 18 April 2008 21:29

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Use sqlplus along with cut & paste to show us EXACTLY what you are doing & what you are seeing.

You make claims which nobody can reproduce or substantiate.

Report message to a moderator

Re: more reloads [message #315081 is a reply to message #315080]

Fri, 18 April 2008 21:38

pramod_garre
Messages: 6
Registered: April 2008

Junior Member

HI,

This is th output i have gathered.

SQL> select namespace,sum(sharable_mem)/1024 sharable_mem_in_K from v$db_object_cache group by namespace;

NAMESPACE SHARABLE_MEM_IN_K
---------------------------- -----------------
BODY 424.999023
CLUSTER 14.4619141
CURSOR 18936.7988
INDEX 47.4492188
PUB_SUB 9.12207031
TABLE/PROCEDURE 1964.96777
TRIGGER 8.65136719

=====
SQL> select sum(sharable_mem)/1024 from v$db_object_cache
2 ;

SUM(SHARABLE_MEM)/1024
----------------------
21955.0166

SQL> sho parameter shared

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
hi_shared_memory_address integer 0
max_shared_servers integer 20
shared_memory_address integer 0
shared_pool_reserved_size big integer 104857600
shared_pool_size big integer 1073741824
shared_servers integer 0
shared_server_sessions integer 0

=====

whith these settings,why i am getting reloads??

Report message to a moderator

Re: more reloads [message #315082 is a reply to message #315079]

Fri, 18 April 2008 22:11

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>whith these settings,why i am getting reloads??
After I reload, I can get off 15 shots before I need a new magzine.

Do you have a single shot musket?

Report message to a moderator

Re: more reloads [message #315099 is a reply to message #315081]

Sat, 19 April 2008 01:11

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

1/ There is no reload in what you posted
2/ 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 (See SQL Formatter) and align the columns in result.
Use the "Preview Message" button to verify.

Regards
Michel

Report message to a moderator

Previous Topic:	Rosco's Performance Tuning Guide
Next Topic:	Statspack Report

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jun 27 20:43:20 CDT 2024