My interpretation of this information is one or more of the following:
maheswara.rao@xxxxxxx wrote: -- //www.freelists.org/webpage/oracle-lThank you Dan and Joe. I checked dba_tables. The query result shows 101 rows. >From v$sysstat, I am getting 2,327,441. Does v$sysstat contains other info when query for 'table fetch continued row'? Please see below queries. 1 SELECT owner, table_name, chain_cnt 2 FROM dba_tables 3* WHERE chain_cnt > 0 SQL> / OWNER TABLE_NAME CHAIN_CNT ------------------------------ ------------------------------ ---------- REPORTER REP_AUDIT_SEVERITY 18 REPORTER REP_AUDIT_ACK 83 = = = = SQL> SELECT name, value FROM v$sysstat WHERE name = 'table fetch continued row'; NAME VALUE ---------------------------------- -------- table fetch continued row 2327441 |