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

Pagination using scrollable result set and with Oracle JDBC implementation
Lru vs Checkpoint Queue
Upgrade information required
Unable to Login into database
Certified HDW
export on physical standby database ?
Developer roles
Damage in database
client TNSNAMES in dataguard
All 'Perform prerequisit checks' fail while installing 11.2.0.2
Issue in Upgrading database
SQL Injection and Java Regular Expression: How to match words?
RMAN Recovery Error - attempting to NoArchivelogs
How to reduce table size after deleting data in table
Scrollable resultsets
Temp space getting full, wht is the solution