Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Help: libaray cache and dictionary tunning
We are using oracle 8.1.7.2 on solaris. I am so new to the performance
tuning. All I know is if the hit ratio is not big enough, increate
shared_pool_size.
The following is my report from our database using statspack,could somebody give me some advice so I can learn the in depth tuning on a real case study. (is our database correctly tuned? Even though the overall hit ratio for dictionary and library cache are very high, is there any room for improvement?)
Thanks
Library Cache Activity for DB: TEST Instance: test Snaps: 330 -343
->"Pct Misses" should be very low
Get Pct Pin Pct Inval Namespace Requests Miss Requests Miss Reloads dations ----------- -------------- -------------- ------ ---------- -------- BODY 1,019 0.1 1,019 0.8 6 0 CLUSTER 327 0.0 295 0.0 0 0 INDEX 22,268 0.2 22,282 0.3 0 0 OBJECT 0 0 0 0 PIPE 1,775 0.0 1,998 0.0 0 0 SQL AREA 715,631 0.1 2,252,042 0.1 309 919 TABLE/PROCEDUR38,132 0.3 3,193,023 0.0 111 0 TRIGGER 101 1.0 101 1.0 0 0 ---------------------------------------------------------
Dictionary Cache Stats for DB: TEST Instance: test Snaps: 330 -343
->"Pct Misses" should be very low (< 2% in most cases)
->"Cache Usage" is the number of cache entries being used
->"Pct SGA" is the ratio of usage to allocated size for that cache
Get Pct Scan Pct Mod Final Cache Requests Miss Request miss Req Usage SGA ----------------------------- ------ -------- ----- -------- --- dc_constraints 674 39.0 0 674 599 98 dc_database_links 28 0.0 0 0 6 86 dc_files 0 0 0 0 0 dc_free_extents 4,619 3.5 122 0.0 394 333 92 dc_global_oids 1,809 0.0 0 0 70 85 dc_histogram_data 0 0 0 0 0 dc_histogram_data_valu 0 0 0 0 0 dc_histogram_defs 4,892 10.3 0 1,587 1,028 97 dc_object_ids 19,917 0.3 0 66 935 97 dc_objects 37,874 0.3 0 371 1,883 99 dc_outlines 0 0 0 0 0 dc_profiles 99 0.0 0 0 1 6 dc_rollback_segments 2,199 0.0 0 0 15 75 dc_segments 5,797 0.8 0 254 746 95 dc_sequence_grants 0 0 0 0 0 dc_sequences 30,756 0.0 0 30,750 41 98 dc_synonyms 172 0.6 0 0 86 97 dc_tablespace_quotas 149 0.7 0 143 26 58 dc_tablespaces 1,552 0.0 0 0 12 57 dc_used_extents 157 77.7 0 157 584 63 dc_user_grants 34,953 0.0 0 0 25 53 dc_usernames 2,555 0.1 0 0 37 90 dc_users 39,722 0.0 0 5 36 64 ifs_acl_cache_entries 0 0 0 0 0 -------------------------------------------------------Thanks
-- Sent by dbadba62 from hotmail in area com This is a spam protected message. Please answer with reference header. Posted via http://www.usenet-replayer.com/cgi/content/newReceived on Mon Jan 21 2002 - 15:51:59 CST