Check Appendix C of the Reference Manual. Look at 'table scans'. select decode(class, 1,'User', 2,'Redo', 4,'Enqueue', 8,'Cache', 16,'OS', 32,'Parallel Server', 64,'SQL', 128,'Debug' ) class_name ,name ,value from v$sysstat where upper(name) like '%TABLE%' order by class_name, name
"Dilip" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 08/07/2003 10:19 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: statpack & v$sysstat - stat# 140 Hi List, While reading statpack book, came across a script which is using stats$sysstat to estimate FTS. The statistic# used is 140 which is 'transaction lock foreground requests' (Ver.8.1.7.4) The value for this statistic# in v$sysstat is zero. Is there a way to find out FTS from v$sysstat ? If yes, what is the statistic# name ? Thanks, ~Dilip Get Your Private, Free E-mail from Indiatimes at http://email.indiatimes.com Buy The Best In BOOKS at http://www.bestsellers.indiatimes.com Bid for for Air Tickets @ Re.1 on Air Sahara Flights. Just log on to http://airsahara.indiatimes.com and Bid Now ! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dilip INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).