Home » RDBMS Server » Performance Tuning » Performance tuning
Performance tuning [message #65576] Mon, 01 November 2004 20:29
Messages: 4
Registered: May 2000
Junior Member
Hi i need help with these questions

1/ INITRANS is a parameter that indicates the concurrency level of transactions when working inside a db block. Where is this parameter stored?

When and how can this be set/changed?

2/ I can find out if there are any chained rows in my database using the "select name, value from v$sysstat where 'table fetch by continued row';

If the number is not zero then there are rows chained. What I do not know is that which table or tables have this problem?

I am supposed to use ANALYZE TABLE tablename LIST CHAINED ROWS; to find out. But if I have 100 tables,

I do not want to run this command one by one against all my 100 tables. How do I figure out where my chained rows are?

3/ Data cache Read Efficiency (RE) is defined as percentage of data reads satisfied by the cache.

If N is total number of reads issued, M is the number of reads that were done against the disk, then N-M is the number that were satisfied by information in the cache.

Therefore, RE=(N-M)/100%. How do I get these stats? Is there a view that contains this information? Do I have to some type of analysis to get them?

4/ There is also a similar question on Procedure Cache efficiency. How do I get the RE for procedure cache.
Previous Topic: Does providing a Numeric value in Single quotes affects performance
Next Topic: oracle
Goto Forum:

Current Time: Sun Mar 03 19:17:51 CST 2024