Db Sequential Reads

[sanju456]

Hi,

I am having a lot of problems with DB SEQUENTIAL READS wait event in my statspack.
I came to know that it is due to single block reads.

a) What does a "Single block reads" means?
b) Ofcourse we can create any number of indexes on a table. But Is there any criteria like only 'n' number of indexes should be created on the Database due to performance issues?
c) Is this being caused due to suppressed indexes?

Please do help me.


Thanks in advance,
sanju

[akhadar]

check the following document
http://metalink.oracle.com/metalink/...T&p_id=34559.1

[sanju456]

Originally posted by akhadar
check the following document
http://metalink.oracle.com/metalink/...T&p_id=34559.1

I dont have a metalink.

Thanks Sanju

[akhadar]

Also read some books on performance tuning regarding the views mentioned in this document.

[abhaysk]

Originally posted by sanju456
Hi,

I am having a lot of problems with DB SEQUENTIAL READS wait event in my statspack.
I came to know that it is due to single block reads.

Sounds to me like you have all SQLs thirsty for indexes??..
Or you have too many indexes on your tables..

single block reads -> dosent the name suggest wat is the opeteration being done by Oracle/OS??

Abhay.

[davey23uk]

Originally posted by akhadar

]

posting metalink content is a breach of their copyright - should really stop doing it

[abhaysk]

Originally posted by davey23uk
]

posting metalink content is a breach of their copyright - should really stop doing it

Such an act might attract the Mods here to discontinue one's dbasupport ID ??