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??
|
|
|
|
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??
|
|
|
|
Re: more reloads [message #315099 is a reply to message #315081] |
Sat, 19 April 2008 01:11 |
|
Michel Cadot
Messages: 68711 Registered: March 2007 Location: Saint-Maur, France, https...
|
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
|
|
|