Q
Problem solve Get help with specific problems with your technologies, process and projects.

I/O stats on a table or index

Is there way to determine the I/O stats on a table and/or index? I have the I/O stats by file but would like to narrow it down even more.

It all depends on your Oracle version. If you are using pre-Oracle 9i, then the only way to get this information is to place the index or table in a separate tablespace and monitor V$FILESTAT for that tablespace. This is not an ideal method to be sure.

If you are using Oracle 9i, then look at the new V$SEGMENT_STATISTICS view for the segment (table or index) in question. There are lots of statistics about the I/O of that segment in this view.

For More Information


Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close