RE: Statspack recomendations.
The bookpool is no doubt the best and clean site for tech books with low SH charges. For price comparison http://www.bestwebbuys.com/books/ is a good site... Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Fri, 14 Mar 2003 14:23:55 -0800 I alwasys use bookfinder.com to search for books; it queries quite a few sites and generally finds the best price for me (new and/or used). Another useful site is the ISBN locator at www.isbn.nu Good luck! Rich -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Metelsky Sent: Thursday, January 23, 2003 4:20 PM To: Multiple recipients of list ORACLE-L Subject: RE: Statspack recomendations. Go to bookpool.com. Best prices on tech books. I've ordered several books from them and have always been happy. Yes definetly... But this one Conducting the Oracle Job Interview Is not available at bookpool or amazon... (personally I like the buy used books from amazon) quite a few deals there Ive always been reasonably pleased with the service as well. Thanks bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky 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: Rich Holland 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). _ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: M Rafiq 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).
RE: Statspack recomendations.
I alwasys use bookfinder.com to search for books; it queries quite a few sites and generally finds the best price for me (new and/or used). Another useful site is the ISBN locator at www.isbn.nu Good luck! Rich -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Metelsky Sent: Thursday, January 23, 2003 4:20 PM To: Multiple recipients of list ORACLE-L Subject: RE: Statspack recomendations. Go to bookpool.com. Best prices on tech books. I've ordered several books from them and have always been happy. Yes definetly... But this one Conducting the Oracle Job Interview Is not available at bookpool or amazon... (personally I like the buy used books from amazon) quite a few deals there Ive always been reasonably pleased with the service as well. Thanks bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky 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: Rich Holland 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).
RE: Statspack recomendations.
I get the error on solaris 9 and 9.2.0.2 except it's 103 Connected.ERROR:ORA-00600: internal error code, arguments: [ktfthcf-1], [103], [], [], [], [], [], [] [EMAIL PROTECTED] 01/23/03 04:16PM BUT, I don't get the error on 9.0.1.0.0 on Solaris 5.8!-Original Message-Sent: Thursday, January 23, 2003 3:20 PMTo: '[EMAIL PROTECTED]'I just tried in on 9.2.0.1.0 on Solaris 5.8 and get the ORA-00600 error,except the 2nd arg is 252.-Original Message-Sent: Thursday, January 23, 2003 2:25 PMTo: Multiple recipients of list ORACLE-LI get the same results. Strange!?!?-Original Message-Sent: Thursday, January 23, 2003 1:14 PMTo: Multiple recipients of list ORACLE-LAnyone know a work around to joining v$tempfile and dba_temp_files by file#?I'm using 9.2.0.1.0 on XP and I'm issuing the statement:select a.file_name from dba_temp_files a, v$tempstat bwhere b.file#=a.file_id;I get an ora-0600 on this with a [ktfthcf-1] [202]Argument. I looked this up on Metalink and this appears to have been a bugdiscovered in 8i and fixed in 9i but alas, it's still here. I tried toimplement the work around, issuing the RULE hint, which removes the errormessage but gives me no results.Anyone experience this?RFRobert G. Freeman Technical Management ConsultantTUSC - The Oracle Experts www.tusc.com904.708.5076 Cell (it's everywhere that I am!)Author of several books you can find on Amazon.com!-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Freeman Robert - IL INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Eberhard, Jeff INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Fink, Dan INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: Statspack recomendations.
I also get it on 9.2.0.1 on Win2K, same error code as Robert: Connected to:Oracle9i Enterprise Edition Release 9.2.0.1.0 - ProductionWith the Partitioning, OLAP and Oracle Data Mining optionsJServer Release 9.2.0.1.0 - Production SQL select a.file_name 2 from dba_temp_files a, v$tempstat b 3 where b.file#=a.file_id;ERROR:ORA-00600: internal error code, arguments: [ktfthcf-1], [202], [], [], [], [],[], [] Though on 9.0.1.3.1 it works (same machine): Connected to:Oracle9i Enterprise Edition Release 9.0.1.3.1 - ProductionWith the Partitioning optionJServer Release 9.0.1.3.0 - Production SQL select a.file_name 2 from dba_temp_files a, v$tempstat b 3 where b.file#=a.file_id; FILE_NAMEC:\ORACLE\APP92\ORADATA\IASDB\DISCOTEMP1.DBFC:\ORACLE\APP92\ORADATA\IASDB\PTLTMP.DBFC:\ORACLE\APP92\ORADATA\IASDB\TEMP01.DBF Mark
RE: Statspack recomendations.
I found a bug in Metalink for this. It's fixed in 10i. See my previous message (and one from Jared) for a work around. RF Robert G. FreemanTechnical Management ConsultantTUSC - The Oracle Experts www.tusc.com904.708.5076 Cell (it's everywhere that I am!)Author of several books you can find on Amazon.com! -Original Message-From: John Shaw [mailto:[EMAIL PROTECTED]]Sent: Friday, January 24, 2003 7:45 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Statspack recomendations. I get the error on solaris 9 and 9.2.0.2 except it's 103 Connected.ERROR:ORA-00600: internal error code, arguments: [ktfthcf-1], [103], [], [], [], [], [], [] [EMAIL PROTECTED] 01/23/03 04:16PM BUT, I don't get the error on 9.0.1.0.0 on Solaris 5.8!-Original Message-Sent: Thursday, January 23, 2003 3:20 PMTo: '[EMAIL PROTECTED]'I just tried in on 9.2.0.1.0 on Solaris 5.8 and get the ORA-00600 error,except the 2nd arg is 252.-Original Message-Sent: Thursday, January 23, 2003 2:25 PMTo: Multiple recipients of list ORACLE-LI get the same results. Strange!?!?-Original Message-Sent: Thursday, January 23, 2003 1:14 PMTo: Multiple recipients of list ORACLE-LAnyone know a work around to joining v$tempfile and dba_temp_files by file#?I'm using 9.2.0.1.0 on XP and I'm issuing the statement:select a.file_name from dba_temp_files a, v$tempstat bwhere b.file#=a.file_id;I get an ora-0600 on this with a [ktfthcf-1] [202]Argument. I looked this up on Metalink and this appears to have been a bugdiscovered in 8i and fixed in 9i but alas, it's still here. I tried toimplement the work around, issuing the RULE hint, which removes the errormessage but gives me no results.Anyone experience this?RFRobert G. Freeman Technical Management ConsultantTUSC - The Oracle Experts www.tusc.com904.708.5076 Cell (it's everywhere that I am!)Author of several books you can find on Amazon.com!-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Freeman Robert - IL INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Eberhard, Jeff INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Fink, Dan INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: Statspack recomendations.
Don Burleson has a book called Oracle9i High-Performance Tuning with STATSPACK. Check out the link below. http://www.dba-oracle.com/books.htm Dave -Original Message- Sent: Thursday, January 23, 2003 8:44 AM To: Multiple recipients of list ORACLE-L List, I am looking for a recommendation on a book or web site covering statspack and it's use. A moderate level usage rather than an expert level literature is desired. Any recommendations please. Thanks, Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers 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: Farnsworth, Dave 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).
RE: Statspack recomendations.
Oracle9i High-Performance Tuning with STATSPACK Donald K. Burleson, Oracle Press http://www.amazon.com/exec/obidos/ASIN/0072190582/qid=996445780/sr=1-4/ref=s c_b_4/102-7596303-7878550 URL will be wrapped.. Also on Don's site: http://www.dba-oracle.com/art_statspack.htm HTH Mark -Original Message- Sent: 23 January 2003 14:44 To: Multiple recipients of list ORACLE-L List, I am looking for a recommendation on a book or web site covering statspack and it's use. A moderate level usage rather than an expert level literature is desired. Any recommendations please. Thanks, Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers 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: Mark Leith 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).
RE: Statspack recomendations.
I second that motion. Also, to get you started quickly, there is a whole load of white papers on Metalink and OTN. -Original Message- From: Vergara, Michael (TEM) [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 23, 2003 10:40 AM To: Multiple recipients of list ORACLE-L Subject: RE: Statspack recomendations. Get Don Burleson's book - I think it's called Oracle 9i High Performance Tuning with STATSPACK. -Original Message- Sent: Thursday, January 23, 2003 6:44 AM To: Multiple recipients of list ORACLE-L List, I am looking for a recommendation on a book or web site covering statspack and it's use. A moderate level usage rather than an expert level literature is desired. Any recommendations please. Thanks, Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers 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: Vergara, Michael (TEM) 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: Gogala, Mladen 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).
RE: Statspack recomendations.
Thanks to all who replied. I will look for the book at the local book store this weekend. Ron [EMAIL PROTECTED] 01/23/03 10:44AM Don Burleson has a book called Oracle9i High-Performance Tuning with STATSPACK. Check out the link below. http://www.dba-oracle.com/books.htm Dave -Original Message- Sent: Thursday, January 23, 2003 8:44 AM To: Multiple recipients of list ORACLE-L List, I am looking for a recommendation on a book or web site covering statspack and it's use. A moderate level usage rather than an expert level literature is desired. Any recommendations please. Thanks, Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers 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: Farnsworth, Dave 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: Ron Rogers 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).
RE: Statspack recomendations.
Get Don Burleson's book - I think it's called Oracle 9i High Performance Tuning with STATSPACK. -Original Message- Sent: Thursday, January 23, 2003 6:44 AM To: Multiple recipients of list ORACLE-L List, I am looking for a recommendation on a book or web site covering statspack and it's use. A moderate level usage rather than an expert level literature is desired. Any recommendations please. Thanks, Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers 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: Vergara, Michael (TEM) 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).
RE: Statspack recomendations.
List, There have been a lot of good suggestions and recommendations from all of you. I thank you very much. The information sources list information about a Unx / NT os and I need to read up on what happens when the creation scripts fail on OpenVMS. Hopefully the sources will supply some insight. Thanks again, Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers 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).
RE: Statspack recomendations.
Anyone know a work around to joining v$tempfile and dba_temp_files by file#? I'm using 9.2.0.1.0 on XP and I'm issuing the statement: select a.file_name from dba_temp_files a, v$tempstat b where b.file#=a.file_id; I get an ora-0600 on this with a [ktfthcf-1] [202] Argument. I looked this up on Metalink and this appears to have been a bug discovered in 8i and fixed in 9i but alas, it's still here. I tried to implement the work around, issuing the RULE hint, which removes the error message but gives me no results. Anyone experience this? RF Robert G. Freeman Technical Management Consultant TUSC - The Oracle Experts www.tusc.com 904.708.5076 Cell (it's everywhere that I am!) Author of several books you can find on Amazon.com! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL 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).
RE: Statspack recomendations.
Go to bookpool.com. Best prices on tech books. I've ordered several books from them and have always been happy. Robert G. Freeman Technical Management Consultant TUSC - The Oracle Experts www.tusc.com 904.708.5076 Cell (it's everywhere that I am!) Author of several books you can find on Amazon.com! -Original Message- Sent: Thursday, January 23, 2003 1:46 PM To: Multiple recipients of list ORACLE-L Don Burleson has a book called Oracle9i High-Performance Tuning with STATSPACK. Check out the link below. http://www.dba-oracle.com/books.htm Dave Unfortunatly the ordering feature dosnt work on that site. IE 6 or Mozilla 1.2.1 I was interested in Conducting the Oracle Job Interview bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky 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: Freeman Robert - IL 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).
RE: Statspack recomendations.
Don Burleson has a book called Oracle9i High-Performance Tuning with STATSPACK. Check out the link below. http://www.dba-oracle.com/books.htm Dave Unfortunatly the ordering feature dosnt work on that site. IE 6 or Mozilla 1.2.1 I was interested in Conducting the Oracle Job Interview bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky 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).
RE: Statspack recomendations.
Robert, Here's the script I use. Jared -- showdf8i.sql -- shows autoextend features -- displays sizes in meg clear computes clear breaks clear columns set pagesize 60 heading on col file_name format a30 col tablespace_name format a15 col bytes format 999,999.99 head BYTES|MEG col autoextensible format a4 head AUTO|XTND col maxbytes format 999,999.99 head MAX|BYTES|MEG col increment_by format 999,999.99 head INCR|BYTES|MEG col maxfree format 999,999.99 head MAX|MEG|FREE col cblocksize noprint new_value ublocksize set term off feed off select value cblocksize from v$parameter where name = 'db_block_size'; set term on feed on break on tablespace_name skip 1 on report compute sum of bytes on tablespace_name compute sum of bytes on report @@title 'Tablespaces and Data Files' 120 select ts.name tablespace_name, f.name file_name, f.status, round(f.bytes/1049576,2) bytes, s.maxfree, df.autoextensible, round(df.maxbytes/1048576,2) maxbytes, round((df.increment_by * ublocksize) / 1048576,2) increment_by, f.file# file_id from v$datafile f, ( select file_id, round(max(bytes/1048576),2) MAXFREE from dba_free_space group by file_id ) s, v$tablespace ts, dba_data_files df where f.file# = s.file_id(+) and f.name like '%' and ts.ts# = f.ts# and df.file_id = f.file# --and df.autoextensible = 'YES' union all select ts.name tablespace_name, t.name file_name, t.status, round(t.bytes/1049576,2) bytes, s.maxfree, dt.autoextensible, round(dt.maxbytes/1048576,2) maxbytes, round((dt.increment_by * ublocksize) / 1048576,2) increment_by, t.file# file_id from v$tempfile t, ( select file_id, round(max(bytes/1048576),2) MAXFREE from dba_free_space group by file_id ) s, v$tablespace ts, dba_temp_files dt where t.file# = s.file_id and t.name like '%' and ts.ts# = t.ts# and dt.file_id = t.file# --and dt.autoextensible = 'YES' order by tablespace_name, file_id / Freeman Robert - IL [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/23/2003 12:14 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Statspack recomendations. Anyone know a work around to joining v$tempfile and dba_temp_files by file#? I'm using 9.2.0.1.0 on XP and I'm issuing the statement: select a.file_name from dba_temp_files a, v$tempstat b where b.file#=a.file_id; I get an ora-0600 on this with a [ktfthcf-1] [202] Argument. I looked this up on Metalink and this appears to have been a bug discovered in 8i and fixed in 9i but alas, it's still here. I tried to implement the work around, issuing the RULE hint, which removes the error message but gives me no results. Anyone experience this? RF Robert G. Freeman Technical Management Consultant TUSC - The Oracle Experts www.tusc.com 904.708.5076 Cell (it's everywhere that I am!) Author of several books you can find on Amazon.com! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL 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).
RE: Statspack recomendations.
Go to bookpool.com. Best prices on tech books. I've ordered several books from them and have always been happy. Yes definetly... But this one Conducting the Oracle Job Interview Is not available at bookpool or amazon... (personally I like the buy used books from amazon) quite a few deals there Ive always been reasonably pleased with the service as well. Thanks bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky 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).
RE: Statspack recomendations.
Robert, It works in HP-UX 11 Oracle version Oracle9i Enterprise Edition Release 9.0.1.0.0 - 64bit Production SQL select a.file_name 2 from dba_temp_files a, v$tempstat b 3 where b.file#=a.file_id; FILE_NAME /a1/app/oracle/product/9.0.1/oradata/OEM/temp01.dbf Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thu, 23 Jan 2003 12:14:11 -0800 Anyone know a work around to joining v$tempfile and dba_temp_files by file#? I'm using 9.2.0.1.0 on XP and I'm issuing the statement: select a.file_name from dba_temp_files a, v$tempstat b where b.file#=a.file_id; I get an ora-0600 on this with a [ktfthcf-1] [202] Argument. I looked this up on Metalink and this appears to have been a bug discovered in 8i and fixed in 9i but alas, it's still here. I tried to implement the work around, issuing the RULE hint, which removes the error message but gives me no results. Anyone experience this? RF _ The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: M Rafiq 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).
RE: Statspack recomendations.
I get the same results. Strange!?!? -Original Message- Sent: Thursday, January 23, 2003 1:14 PM To: Multiple recipients of list ORACLE-L Anyone know a work around to joining v$tempfile and dba_temp_files by file#? I'm using 9.2.0.1.0 on XP and I'm issuing the statement: select a.file_name from dba_temp_files a, v$tempstat b where b.file#=a.file_id; I get an ora-0600 on this with a [ktfthcf-1] [202] Argument. I looked this up on Metalink and this appears to have been a bug discovered in 8i and fixed in 9i but alas, it's still here. I tried to implement the work around, issuing the RULE hint, which removes the error message but gives me no results. Anyone experience this? RF Robert G. Freeman Technical Management Consultant TUSC - The Oracle Experts www.tusc.com 904.708.5076 Cell (it's everywhere that I am!) Author of several books you can find on Amazon.com! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL 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: Eberhard, Jeff 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).
RE: Statspack recomendations.
Forgot to mention 9.2.0.1.0 on Win2000 I got data when I changed the join as follows: select a.file_name, b.* from dba_temp_files a, v$tempstat b where b.file#=to_number(a.file_id); --Jeff -Original Message- Sent: Thursday, January 23, 2003 1:14 PM To: Multiple recipients of list ORACLE-L Anyone know a work around to joining v$tempfile and dba_temp_files by file#? I'm using 9.2.0.1.0 on XP and I'm issuing the statement: select a.file_name from dba_temp_files a, v$tempstat b where b.file#=a.file_id; I get an ora-0600 on this with a [ktfthcf-1] [202] Argument. I looked this up on Metalink and this appears to have been a bug discovered in 8i and fixed in 9i but alas, it's still here. I tried to implement the work around, issuing the RULE hint, which removes the error message but gives me no results. Anyone experience this? RF Robert G. Freeman Technical Management Consultant TUSC - The Oracle Experts www.tusc.com 904.708.5076 Cell (it's everywhere that I am!) Author of several books you can find on Amazon.com! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL 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: Eberhard, Jeff 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).
RE: Statspack recomendations.
It's a bug in 9i as well, I finally found the entry for it. I ended up building this code to do what I wanted: select /*+ FULL(a) FULL(b) FULL(c) */ 'Temp Files', substr(c.fnnam,1,6), sum(b.kcftiopyr), sum(b.kcftioprt/100) Time/Reading, round((sum(b.kcftioprt)/100)/decode(sum(kcftiopyr),0,1,sum(kcftiopyr) ),3) Average RdTm/IO, sum(b.kcftiopwt), sum(b.kcftiopwt/100) Time/Writing, round((sum(b.kcftiopwt)/100)/decode(sum(kcftiopyw),0,1,sum(kcftiopyw)),3) Average WrtTm/IO, 0 Average IO/Seconds from x$kccfn c, x$kcftio b where b.kcftiofno (+) =c.fnfno and c.fntyp=7 and c.fnnam is not null group by substr(c.fnnam,1,6); Works fine, but you have to do the full table scans or you might still get the ora-600. RF Robert G. Freeman Technical Management Consultant TUSC - The Oracle Experts www.tusc.com 904.708.5076 Cell (It's everywhere that I am!) Author of several books you can find on Amazon.com! -Original Message- Sent: Thursday, January 23, 2003 3:25 PM To: Multiple recipients of list ORACLE-L I get the same results. Strange!?!? -Original Message- Sent: Thursday, January 23, 2003 1:14 PM To: Multiple recipients of list ORACLE-L Anyone know a work around to joining v$tempfile and dba_temp_files by file#? I'm using 9.2.0.1.0 on XP and I'm issuing the statement: select a.file_name from dba_temp_files a, v$tempstat b where b.file#=a.file_id; I get an ora-0600 on this with a [ktfthcf-1] [202] Argument. I looked this up on Metalink and this appears to have been a bug discovered in 8i and fixed in 9i but alas, it's still here. I tried to implement the work around, issuing the RULE hint, which removes the error message but gives me no results. Anyone experience this? RF Robert G. Freeman Technical Management Consultant TUSC - The Oracle Experts www.tusc.com 904.708.5076 Cell (it's everywhere that I am!) Author of several books you can find on Amazon.com! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL 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: Eberhard, Jeff 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: Freeman Robert - IL 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).
RE: Statspack recomendations.
I just tried in on 9.2.0.1.0 on Solaris 5.8 and get the ORA-00600 error, except the 2nd arg is 252. -Original Message- Sent: Thursday, January 23, 2003 2:25 PM To: Multiple recipients of list ORACLE-L I get the same results. Strange!?!? -Original Message- Sent: Thursday, January 23, 2003 1:14 PM To: Multiple recipients of list ORACLE-L Anyone know a work around to joining v$tempfile and dba_temp_files by file#? I'm using 9.2.0.1.0 on XP and I'm issuing the statement: select a.file_name from dba_temp_files a, v$tempstat b where b.file#=a.file_id; I get an ora-0600 on this with a [ktfthcf-1] [202] Argument. I looked this up on Metalink and this appears to have been a bug discovered in 8i and fixed in 9i but alas, it's still here. I tried to implement the work around, issuing the RULE hint, which removes the error message but gives me no results. Anyone experience this? RF Robert G. Freeman Technical Management Consultant TUSC - The Oracle Experts www.tusc.com 904.708.5076 Cell (it's everywhere that I am!) Author of several books you can find on Amazon.com! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL 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: Eberhard, Jeff 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: Fink, Dan 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).
RE: Statspack recomendations.
BUT, I don't get the error on 9.0.1.0.0 on Solaris 5.8! -Original Message- Sent: Thursday, January 23, 2003 3:20 PM To: '[EMAIL PROTECTED]' I just tried in on 9.2.0.1.0 on Solaris 5.8 and get the ORA-00600 error, except the 2nd arg is 252. -Original Message- Sent: Thursday, January 23, 2003 2:25 PM To: Multiple recipients of list ORACLE-L I get the same results. Strange!?!? -Original Message- Sent: Thursday, January 23, 2003 1:14 PM To: Multiple recipients of list ORACLE-L Anyone know a work around to joining v$tempfile and dba_temp_files by file#? I'm using 9.2.0.1.0 on XP and I'm issuing the statement: select a.file_name from dba_temp_files a, v$tempstat b where b.file#=a.file_id; I get an ora-0600 on this with a [ktfthcf-1] [202] Argument. I looked this up on Metalink and this appears to have been a bug discovered in 8i and fixed in 9i but alas, it's still here. I tried to implement the work around, issuing the RULE hint, which removes the error message but gives me no results. Anyone experience this? RF Robert G. Freeman Technical Management Consultant TUSC - The Oracle Experts www.tusc.com 904.708.5076 Cell (it's everywhere that I am!) Author of several books you can find on Amazon.com! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL 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: Eberhard, Jeff 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: Fink, Dan 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).
