Categories

JAVA DATEBASE
Technology Network Community
Oracle Database
Fusion Middleware
Development Tools
Java
Desktop
Server & Storage Systems
Enterprise Management
Berkeley DB Family
Cloud Computing
Big Data
Business Intelligence
Architecture
Migration and Modernization
E-Business Suite
Siebel
PeopleSoft Enterprise
JD Edwards World
Industries
JD Edwards EnterpriseOne
User Productivity Kit Pro (UPK) and Tutor
Governance, Risk & Compliance (GRC)
Master Data Management (MDM)
Oracle CRM On Demand
On Demand: SaaS and Managed Applications
AutoVue Enterprise Visualization
Primavera
ATG
Agile PLM
Endeca Experience Management
Fusion Applications
Archived Forums

 



Tags

General Questions


datacache hitratio


Dear All,        Our users are complaing about performce problem reagrding some reports then i check Hit ratios  of main  buffer pool (shared pool,database buffer,library cache...etc) , but Buffer cache Hit ration is around 61.15% then i have just enable Automatic shared memory management by increasing SGA_TARGET size & STATISTICS_LEVEL to typical  after doing this Data buffer Hit ration  is 49.48% even i rebuild all indexes of the schema whose facing performance problem  , so please some one suggets me to increase the peromance of the database. quick response  will be higly appreciated. thank

Trace the report sessions and analyze the SQL trace. Trying to tune instance would be the step AFTER you have tuned all SQLs for a given report.

user11153253 wrote: Dear All,         Our users are complaing about performce problem reagrding some reports then i check Hit ratios  of main  buffer pool (shared pool,database buffer,library cache...etc) , but Buffer cache Hit ration is around 61.15% then i have just enable Automatic shared memory management by increasing SGA_TARGET size &#38; STATISTICS_LEVEL to typical  after doing this Data buffer Hit ration  is 49.48% even i rebuild all indexes of the schema whose facing performance problem  , so please some one suggets me to increase the peromance of the database. quick response  will be higly appreciated. thank  If you have problem with some reports so some SQLs then it is not mean you have to refer investigating buffer cache hit ratio(BHR) < also  increasing or decreasing of BHR is not give you idea about performance problems.So you do not need see only looking BHR,it is give you some inf about overall system.But in your case firstly investigate your SQLs which long running,investigate  execute plan(see how CBO estimate cardinality and compare they with real rows),in additionally  you can get AWR(or ASH) report and can get more information.

See here: http://jonathanlewis.wordpress.com/statspack-examples/  Start with the Diagnosing Performance Bottlenecks using Statspack

If your reports use functions, packages try to pin them


Related Links

recover a deleted record in NOARCHIVELOG mode?
Cant connect enterprise manager.
DB startup error
What should be wrong with documentation of ORA-00980 ?
SQL Plus question
how to create a procedure of Data pump
Oracle pipe timeout
logically grouping the procedures
oracle 8i installation ora-12560
Ora- 12535: operation timed out error.
Configuring ASM in Win2k3
Undo tablespace Issue
data guard, network disconnect error
Refresh a materialized view partition
export of a user from sys user
Rebuild or Re-Create Local Partitioned Bitmap Indexes?