Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Where can I find the chain rows?

user318649Feb 19 2007 — edited Feb 20 2007
Hi,

I took a query as follows,

select name, value
from v$sysstat
where name = 'table fetch continued row';

name value
------------------------------- ------
table fetch continued row 1306

And then, I looked at dba_tables

select table_name from dba_tables where chain_cnt > 0;

no rows returned

How (which view) can I find the rows (1306)?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 20 2007
Added on Feb 19 2007
10 comments
504 views