Home » RDBMS Server » Performance Tuning » more reloads
more reloads [message #315079] Fri, 18 April 2008 21:25 Go to next message
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??
Re: more reloads [message #315080 is a reply to message #315079] Fri, 18 April 2008 21:29 Go to previous messageGo to next message
BlackSwan
Messages: 25035
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.
Re: more reloads [message #315081 is a reply to message #315080] Fri, 18 April 2008 21:38 Go to previous messageGo to next message
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??
Re: more reloads [message #315082 is a reply to message #315079] Fri, 18 April 2008 22:11 Go to previous messageGo to next message
BlackSwan
Messages: 25035
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?

Re: more reloads [message #315099 is a reply to message #315081] Sat, 19 April 2008 01:11 Go to previous message
Michel Cadot
Messages: 64103
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
Previous Topic: Rosco's Performance Tuning Guide
Next Topic: Statspack Report
Goto Forum:
  


Current Time: Sat Dec 03 18:32:08 CST 2016

Total time taken to generate the page: 0.04548 seconds