strange tkprof output for SQLs - II
Hello, I did 2 tests for PL/SQL and SQL statements. This is the test for SQL. Here are the steps: SQL alter session flush shared_pool; SQL alter session set sql_trace=true; SQL insert into test select * from test; SQL alter session set sql_trace=false; FROM DICTIONARY: SVRMGR select SQL_TEXT,DISK_READS,BUFFER_GETS,ROWS_PROCESSED,COMMAND_TYPE from v$sql where sql_text like 'insert into test select * from test%'; SQL_TEXT DISK_READS BUFFER_GET ROWS_PROCE COMMAND_TY - -- -- -- -- insert into test select * from test 345 1014 8192 2 1 row selected. FROM RAW TRACE FILE: PARSING IN CURSOR #1 len=36 dep=0 uid=5 oct=2 lid=5 tim=2795932206 hv=895761708 ad='5083d50c' insert into test select * from test END OF STMT PARSE #1:c=7,e=28,p=17,cr=42,cu=2,mis=1,r=0,dep=0,og=4,tim=2795932206 . other recursive statements. . . near end of file EXEC #1:c=28,e=258,p=328,cr=597,cu=373,mis=0,r=8192,dep=0,og=4,tim=2795932464 BUFFER GETS IN RAW TRACE FILE: cr: 597 + 42 = 639 cu: 373 + 2 = 375 Buffer gets = 639 + 375 = 1014, which is same as v$sql.BUFFER_GETS DISK_READS IN RAW TRACE FILE: p: 17 + 328 = 345, which is same as v$sql.DISK_READS. According to these test, results in dictionary and raw trace files are same. But tkprof formats as below: insert into test select * from test call count cpuelapsed disk query currentrows --- -- -- -- -- -- -- Parse1 0.00 0.02 17 42 1 0 Execute 1 0.12 1.86 91126 3568192 Fetch0 0.00 0.00 0 0 0 0 --- -- -- -- -- -- -- total2 0.12 1.88108168 3578192 DISK_READS = 108 BUFFER GETS = 168 + 357 = 525 Question: Which one is correct ? Dictionary/raw trace file or tkprof results ? My comment: I guess, tkprof substructs child recursive statements from parent user statement ? Why ? This is not a PL/SQL statement ? So, statistics are already not included in parent statement ? I guess statistics in raw trace files are inclusive statistics which include statistics of their child statements according to call orders of kernel calls. But is this expected behavior. Thanks in advance... -- Danisment Gazi Unal http://www.unal-bilisim.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
strange tkprof output for PL/SQLs
Hello, I did 2 tests for PL/SQL and SQL statements. This is the test for PL/SQL. I've enabled sql_trace from another session by DBMS_SYSTEM.SET_EV(). Here are my observations and questions: - The caller PL/SQL package are seen at the end of the raw file as below: PARSING IN CURSOR #1 len=19 dep=0 uid=5 oct=47 lid=5 tim=2882392980 hv=3659692972 ad='507cbd68' BEGIN pdoug; END; END OF STMT EXEC #1:c=0,e=0,p=3533,cr=5229,cu=132854,mis=1,r=1,dep=0,og=4,tim=2882392980 *** 2002-03-20 15:20:33.571 Here are the v$SQL results: select SQL_TEXT,DISK_READS,BUFFER_GETS,ROWS_PROCESSED from v$sql where upper(SQL_TEXT) like '%DOUG%'; SQL_TEXT DISK_READS BUFFER_GET ROWS_PROCE -- -- -- -- INSERT INTO DOUG VALUES ( :b1,:b2 ) 3533 138083 12 BEGIN pdoug; END; 3533 138083 1 Comparision of PL/SQL package with the raw trace file: Physical reads: --- Raw trace file: 3533 V$SQL : 3533 Logical IO: --- Raw trace file: 5229 + 132854 = 138083 V$SQL : 138083 As you see raw trace file and V$SQL are consistent for this parent PL/SQL statement. This is true for both enabling sql_trace from current session or other session. Here are the tkprof output for parent PL/SQL and its child SQL statement. Child recursive statement called from parent PL/SQL statement: INSERT INTO DOUG VALUES ( :b1,:b2 ) call count cpuelapsed disk query currentrows --- -- -- -- -- -- -- Parse0 0.00 0.00 0 0 0 0 Execute 83646 41.52 110.37218565 92483 83646 Fetch0 0.00 0.00 0 0 0 0 --- -- -- -- -- -- -- total83646 41.52 110.37218565 92483 83646 Parent statement calls its recursive SQL statement given above: BEGIN pdoug; END; call count cpuelapsed disk query currentrows --- -- -- -- -- -- -- Parse0 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00844 1279 40206 1 Fetch0 0.00 0.00 0 0 0 0 --- -- -- -- -- -- -- total1 0.00 0.00844 1279 40206 1 Here are the questions: 1- if recursive statements are included in the parent statement, why are the child statement's some statistics(cpu,elapsed,current) greater than the parent statement's statistics. Also, please have a look at parent statistics. is it possible for 1279+40206=41485 blocks to be processed in ZERO time and total elapsed time is ZERO too. 2- if recursive statements are not included in the parent statement, why tkprof output shows different values for disk and logical IO. Here are the comparisions between tkprof output and V$SQL for parent PL/SQL: Physical reads: --- Raw trace file: 3533 tkprof output : 844 Logical IO: --- Raw trace file: 5229 + 132854 = 138083 tkprof output : 1279 + 40206 = 41485 As a result, raw trace file is consistent with V$SQL for the parent statement. But tkprof reports different values. What is your comment ? Thanks in advance... -- Danisment Gazi Unal http://www.unal-bilisim.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
testtttttttttststststst
-- Daniþment Gazi Ünal http://www.unal-bilisim.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Ora-00600 running 64 bit and 32 bit databases error stack ...
Hello, Your problem is raised in Oracle's internal kzckini() function. This function is a function of Oracle's SECURITY LAYER. But, your trace doesn't include PROCESS STATE, CURSOR DUMP etc. Without them it's not possible to see what is happing. But you can search metalink by ORA-600 kzckini kscnfy hope this helps ... -- Danisment Gazi Unal http://www.unal-bilisim.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Oracle Tunning (DRPP)
Hello Mogens and others, Yes, You are right. But the current time based performance techniques still include errors. Prior to 80's(when I was a child), yes, ratio based measurements were the method. Then, wait-event based profiling appeared. In fact, this was an adaptation of Response Time Performance Profiling to Oracle. Unfortunately, there are significant errors in current response time based performance profilings. I've been working on a new performance profiling for 1 year. and now, I've almost completed my paper. The name is Deductive Response-time Performance Profiling (DRPP). It'll be available on my site after my seminar in Turkey. You can see the contents at http://www.unal-bilisim.com/resources/drpp_seminar.html . Also, Thanks to Jonathan Lewis, K Gopalakrishnan, and Tim Gorman for reviewing this paper for 1 year. regards... Mogens Nrgaard wrote: Commit; :-) In my opinion, you shouldn't spend your money on buying the Niemich book. It's full of errors (increase the buffer cache hit ratio, for instance) and the wrong approach (no time-based measurement method, just checklist after checklist). Buy 101 by Gaja. Then buy Tom Kyte's One-On-One book for general fantastic advise on anything. Then go to oraperf.com (Anjo), hotsos.com (Millsap), ixora.com.au (Steve Adams) and Jonathan Lewis' website (can never remember the adresse). Or go to MiracleAS.dk and find all these links, including the book links. Mogens Miracle A/S Denmark Farnsworth, Dave wrote: Binay, I totally agree with this recommendation from Jared for a tuning book. Read the first three chapters, stop and re-read them. And if you play your cards right you can even get a question answered by an author on this list. Cool, eh. Dave -Original Message- Sent: Tuesday, January 29, 2002 3:05 PM To: Multiple recipients of list ORACLE-L Start with 'Oracle Performance Tuning 101', available at an amazon.com near you. Jared On Tuesday 29 January 2002 09:10, [EMAIL PROTECTED] wrote: Hi Everyone Can anyone suggest me some very good book on Oracle Tunning. Please only mention those books which you think is really worth purchasing Binay Kumar Oracle Cerified DBA London --- The contents of this e-mail are confidential to the ordinary user of the e-mail address to which it was addressed and may also be privileged. If you are not the addressee of this e-mail you should not copy, forward, disclose or otherwise use it or any part of it in any form whatsoever. If you have received this e-mail in error please notify us by telephone or e-mail the sender by replying to this message, and then delete this e-mail and other copies of it from your computer system. Thank you. We reserve the right to monitor all e-mail communications through our network. -- Danisment Gazi Unal http://www.unal-bilisim.com
Re: Trace/Event Info (iOraDumpReader)
Hello, you can use itrprof (web based, and free) to analyze event10046 raw trace files. The product is at http://www.unal-bilisim.com/products/itrprof/itrprof.html. I'm currently developing a new web based product named iOraDumpReader. This tool will intreprete many Oracle trace files such as: - control file dump - file header dump - redo header dump - redo block dump - data block dump - rbs dump - etc. I'll lunch beta version next week. regards... Walter K wrote: Howdy! Is a document available somewhere that explains the different trace levels and also the commonly used events for tracing? For instance, I know to use event 10046 with level 4 to get the bind variable values in a trace, but why this particular combination of event and trace level? What are the different levels and how are they used? How are process state and system state dumps performed? I'm also interested in some info that explains how to interpret the various trace files that are produced, other than just looking for SQL in them. Etc... Thanks again! -w __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Danisment Gazi Unal http://www.unal-bilisim.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Trace/Event Info (iOraDumpReader)
Hi, I head meant 'launch'. Mohan, Ross wrote: I'll lunch beta version next week. || eating your own dog food,eh? Admirable! -Original Message- Sent: Thursday, January 24, 2002 1:39 PM To: Multiple recipients of list ORACLE-L Hello, you can use itrprof (web based, and free) to analyze event10046 raw trace files. The product is at http://www.unal-bilisim.com/products/itrprof/itrprof.html. I'm currently developing a new web based product named iOraDumpReader. This tool will intreprete many Oracle trace files such as: - control file dump - file header dump - redo header dump - redo block dump - data block dump - rbs dump - etc. I'll lunch beta version next week. regards... Walter K wrote: Howdy! Is a document available somewhere that explains the different trace levels and also the commonly used events for tracing? For instance, I know to use event 10046 with level 4 to get the bind variable values in a trace, but why this particular combination of event and trace level? What are the different levels and how are they used? How are process state and system state dumps performed? I'm also interested in some info that explains how to interpret the various trace files that are produced, other than just looking for SQL in them. Etc... Thanks again! -w __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Danisment Gazi Unal http://www.unal-bilisim.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Danisment Gazi Unal http://www.unal-bilisim.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Trace/Event Info (iOraDumpReader)
Hi Mohan and others, Thank you for your compliment. If a compiler has an option to compile or not to compile my products, I know I could never develop a product with my typo errors. Compilers would quit after the first attempt(joke...). I'm developing my products Mohan, Ross wrote: I know. It was a joke. Don't bite my head off! ;-) eating your own dog food is a compliment...meaning a company that uses its own products in doing its business. I will you and the business good luck! - Ross -Original Message- From: Danisment Gazi Unal (Unal Bilisim) [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 24, 2002 2:13 PM To: Multiple recipients of list ORACLE-L Subject: Re: Trace/Event Info (iOraDumpReader) Hi, I head meant 'launch'. Mohan, Ross wrote: I'll lunch beta version next week. || eating your own dog food,eh? Admirable! -Original Message- Sent: Thursday, January 24, 2002 1:39 PM To: Multiple recipients of list ORACLE-L Hello, you can use itrprof (web based, and free) to analyze event10046 raw trace files. The product is at http://www.unal-bilisim.com/products/itrprof/itrprof.html. I'm currently developing a new web based product named iOraDumpReader. This tool will intreprete many Oracle trace files such as: - control file dump - file header dump - redo header dump - redo block dump - data block dump - rbs dump - etc. I'll lunch beta version next week. regards... Walter K wrote: Howdy! Is a document available somewhere that explains the different trace levels and also the commonly used events for tracing? For instance, I know to use event 10046 with level 4 to get the bind variable values in a trace, but why this particular combination of event and trace level? What are the different levels and how are they used? How are process state and system state dumps performed? I'm also interested in some info that explains how to interpret the various trace files that are produced, other than just looking for SQL in them. Etc... Thanks again! -w __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Danisment Gazi Unal http://www.unal-bilisim.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Danisment Gazi Unal http://www.unal-bilisim.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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
Re: Performance analysis (enqueue and buffer busy waits)
Hello, It's Unal Bilisim. Ethan mentioned about itrprof SQL Analyzer, which is superior to tkprof. web: http://www.unal-bilisim.com/products/itrprof/itrprof.html Thank Ethan. regards... Babette Turner-Underwood wrote: What is unil-bialism ?? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, August 20, 2001 2:12 PM FYI, in a previous message I detailed some of the tuning efforts we have been working on in regards to getting a EDI sales order processing job to process 150,000 lines per hour. Well the major point of contention was freelists. We went from 250 lines per minute to over 1500 lines per minute simply by increasing freelists on some tables and indexes. We saw an unbelievable 20,000 commits per minute on a 12 CPU AIX box. Looked like we could actually achieve the client's goal until we turned on advanced pricing. It added 60% more overhead and increased user calls 3 fold which pegged all 12 CPU's at 100%. I have a detail trace file event 10046 level 8 to look at and see if I can improve any. Think I will give unil-bialism a try. Thanks, Ethan http://www.geocities.com/epost1 -Original Message- From: Jonathan Lewis [mailto:[EMAIL PROTECTED]] Sent: Monday, August 20, 2001 7:56 AM To: Multiple recipients of list ORACLE-L Subject: Re: Performance analysis (enqueue and buffer busy waits) Small rollback segments can be recycled without being written to disc. This can reduce the total write-load on the system and enhance your general use of the db_block_buffer. Jonathan Lewis Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html Author of: Practical Oracle 8i: Building Efficient Databases See http://www.jlcomp.demon.co.uk/book_rev.html For latest news of public appearances See http://www.jlcomp.demon.co.uk Screen saver or Life saver: http://www.ud.com Use spare CPU to assist in cancer research. [snipped] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Babette Turner-Underwood INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: URGENT PLEASE ! tns service deletion and recreation
Selam Bunyamin, If you don't want to remove them by installer, you can remove by manually. to remove( as I remember ), go to registry: - HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services - HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Services - HKEY_LOCAL_MACHINE\SYSTEM\ControlSet002\Services to create: - it's simple. just run "lsnrctl start" or "lsnrctlxx start". it will be automacticly create your listener services. "Bunyamin K. Karadeniz" wrote: OS: NT 4.0 I need to delete the TNS Listener service . and create a new one .How can I do that ? TIABunyamin
itrprof is now chart enabled
Hello List, itrprof, superior to tkprof, is now chart enabled. You can see the online demo at http://www.unal-bilisim.com/products/itrprof/itrprof_demo.html itrprof: http://www.unal-bilisim.com/products/itrprof/itrprof.html regards.. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: dba_data_files sizes disagree with Op. Sys?
Hello, If Oracle is not able to format the datablocks, it's possible to see size mismatch between dictionary and OS. When You attempt to use these unformated blocks, Oracle formats these blocks, and size problem disappear. If OS size and size in controlfile is different, you get an error. 8/8/01 05:41:08, James Damiano [EMAIL PROTECTED] wrote: Dear fellow DBAs, I have an Oracle Standard 8.1.6 database on Windows/NT 4. While doing a cold backup (database shut down and services closed) in which I FTP'd the datafiles over to a Unix machine, I noticed something peculiar: There appears to be a mismatch when it comes to the number of bytes Oracle reports to me with the dba_data_files view as the size of the datafiles in my database --- and the size they are known to be by the operating system. Specifically: SQL select substr(file_name,1,40) file_name, 2 bytes, 3 user_bytes 4from dba_data_files 5order by file_name; file_namebytes user_bytes --- -- ..\oracle\oradata\db00\indx1db00.ora 186378240186376192 ..\oracle\oradata\db00\rbs1db00.ora 179980288179978240 ..\oracle\oradata\db00\sys1db00.ora 53663744 53661696 ..\oracle\oradata\db00\tmp1db00.ora 134217728134215680 ..\oracle\oradata\db00\usr1db00.ora 219064320219062272 However, when I look at the actual number of bytes that are reported by either Windows Explorer, by FTP in doing the transfer, or by the Unix box which is the destination, I find the following: file_name bytes - ..\oracle\oradata\db00\indx1db00.ora 186380288 ..\oracle\oradata\db00\rbs1db00.ora 179982336 ..\oracle\oradata\db00\sys1db00.ora 53665792 ..\oracle\oradata\db00\tmp1db00.ora 134219776 ..\oracle\oradata\db00\usr1db00.ora 219066368 By the way, the block size for the database is 2048 and all the Bytes in these listings are divisible by the block size. Notice that the bytes from dba_data_files is one block bigger than user_bytes from dba_data_files. But, (and the heart of the matter is this) --- bytes as reported by Windows Explorer and Unix is one block greater than that! Does anybody know why there is this mismatch - or am I missing something obvious? Another bit of information, all the datafiles are AUTOEXTENSIBLE. Thanks very much, Jim Damiano -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Damiano INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: ORA-00600 on Production DB - Need advice
Thank you Kirti, I saw some incorrect usages of iOraBugFinder. So, I added more explanation to iOraBugFinder page. in fact, I wasn't going to analyze alert.log. because alert.log doesn't include detailed information. If alert.log is uploaded, it should be uploaded with Bug depth of 0. Bug depth of 0 is least selective. to narrow down returned bugs, select highest level bug depth and upload trace files instead of alert.log. Decrease Bug depth until you find your bug. Number of returned bugs depends on bugs status and your database support licence with Oracle. If bugs are not published or you don't have database support licence, you can not see the bugs. In this case, it's recommended sending iOraBugFinder results to your support services. This may reduce your response time from support. Some of Oracle support services have started to use iOraBugFinder. If you don't want to lose time on support, upload yourself first. if you can not find your bug, send iOraBugFinder results to support. iOraBugFinder has capability of sending emails. I'm planing some other web based db utils. if you have a product advice, don't hesitate to email me. 6/8/01 09:50:37, Deshpande, Kirti [EMAIL PROTECTED] wrote: David, The ulimit looks okay to me. The value shown is equivalent to 'unlimited'. While you are waiting for the OWS, try getting your alert.log analyzed for ORA-600 at http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html. It may find something that you may not have come across. Are there any other trace files that may tell you more? Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From:[EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent:Monday, August 06, 2001 12:58 PM To: Multiple recipients of list ORACLE-L Subject: ORA-00600 on Production DB - Need advice Mondays, gotta love em, they make Fridays worth the wait. I've got a production database (8.1.7, HP-UX 11.0 - 64 bit) that started throwing an ora-600 when users try to log in. I've created a TAR (3 hours ago), but haven't gotten any response. Here's the error: ERROR: ORA-00600: internal error code, arguments: [kzckini: nzdsi_i], [28750], [], [], [], [], [], [ Metalink has a couple of messages stating that this is an OS problem related to the ulimit size, availability of virtual memory, and the ability to create a pga. Suggested remedy is to increase the ulimit. My SA has dismissed this as a cause. I've knocked all the users off, but still can't log in. When I run ulimit I get the following: qe2n1: /u001/app/oracle/product/8.1.7/dbsulimit 4194303 Any suggestions? David A. Barbour Oracle DBA, OCP AISD 512-414-1002 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Rollback Segment needs recovery
Hello Kevin, yes, if The Rollback Segment itself was corrupted, it's the bad of bad. If it's not rbs, dropping object is more simple than other methods. But, If rbs header is not corrupted, there is still a chance. It's possible to identify uncomitted transactions and/or which corrupted blocks belong to which tx. Once you identify corrupted tx, you can recover until this SCN of corrupted tx. It's possible to re-apply tx after corrupted SCN. by extracting data from current redo-log dump, data after corrupted scn can be applied to db. This is the method of jumping from an SCN to other non-consecutive SCN. these are time consuming process. But other method requires rebuilding db. this is time consuming, too. and this method doesn't guarantee consistency even if you rebuild db. rebuilding db just makes dictionary consistent, not your own data. I think, the best solution is a good back-up. danisment... 28/7/01 12:00:58, Kevin Lange [EMAIL PROTECTED] wrote: n Danisment; When we had a problem that we needed the _corrupted_rollback_segments option added to the init.ora file. The Rollback Segment itself was corrupted. Not the objects using the Rollback Segment. If this is the case, dropping the objects will not do the trick because it will happen again when the Rollback Segment is accessed for another activity. -Original Message- Sent: Friday, July 27, 2001 2:17 PM To: Multiple recipients of list ORACLE-L Hello, It's bad problem. I think _offline_rollback_segments or _corrupted_rollback_segments should be last method. I'll recommend a tip for this error: If you can identify which objects need recovery and then drop them, Oracle doesn't try to recover them, so needs recovery goes away. Let's identify which object need recovery in corrupted rbs: - add following parameters to init.ora: event=10013 trace name context forever, level 10 event=10015 trace name context forever, level 10 Note that if there are more than 1 event in init.ora, they have to be consecutive. otherwise just last one will be active. Now, re-start db abd try to get same error. Oracle will dump recovery operation in alert.log. And you will be able to see object id. drop this object. That's all. You can paste recovery dumps in alert.log to identify your object, as well. regards... 27/7/01 08:37:06, Cale, Rick T (Richard) [EMAIL PROTECTED] wrote: Hi DBAs, Oracle 8.0.5/Windows NT4 I shutdown database normal and restarted ok. I tried to drop a rollback segment and getora-1545 rollback segment not available. When I select from dba_rollback_segs I get needs recovery. I want to drop rollback tablespace and all rollback segment then rebuild because I got datafile corruption error. I am in noarchive mode. Any ideas how to proceed? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Danisment Gazi Unal
RE: Rollback Segment needs recovery
Hello Kevin, I missed second part of your message: case, dropping the objects will not do the trick because it will happen again when the Rollback Segment is accessed for another activity. coruupted rbs immediately should be dropped after fixing errors. regards... 28/7/01 12:00:58, Kevin Lange [EMAIL PROTECTED] wrote: Danisment; When we had a problem that we needed the _corrupted_rollback_segments option added to the init.ora file. The Rollback Segment itself was corrupted. Not the objects using the Rollback Segment. If this is the case, dropping the objects will not do the trick because it will happen again when the Rollback Segment is accessed for another activity. -Original Message- Sent: Friday, July 27, 2001 2:17 PM To: Multiple recipients of list ORACLE-L Hello, It's bad problem. I think _offline_rollback_segments or _corrupted_rollback_segments should be last method. I'll recommend a tip for this error: If you can identify which objects need recovery and then drop them, Oracle doesn't try to recover them, so needs recovery goes away. Let's identify which object need recovery in corrupted rbs: - add following parameters to init.ora: event=10013 trace name context forever, level 10 event=10015 trace name context forever, level 10 Note that if there are more than 1 event in init.ora, they have to be consecutive. otherwise just last one will be active. Now, re-start db abd try to get same error. Oracle will dump recovery operation in alert.log. And you will be able to see object id. drop this object. That's all. You can paste recovery dumps in alert.log to identify your object, as well. regards... 27/7/01 08:37:06, Cale, Rick T (Richard) [EMAIL PROTECTED] wrote: Hi DBAs, Oracle 8.0.5/Windows NT4 I shutdown database normal and restarted ok. I tried to drop a rollback segment and getora-1545 rollback segment not available. When I select from dba_rollback_segs I get needs recovery. I want to drop rollback tablespace and all rollback segment then rebuild because I got datafile corruption error. I am in noarchive mode. Any ideas how to proceed? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Rollback Segment needs recovery
Hello, It's bad problem. I think _offline_rollback_segments or _corrupted_rollback_segments should be last method. I'll recommend a tip for this error: If you can identify which objects need recovery and then drop them, Oracle doesn't try to recover them, so needs recovery goes away. Let's identify which object need recovery in corrupted rbs: - add following parameters to init.ora: event=10013 trace name context forever, level 10 event=10015 trace name context forever, level 10 Note that if there are more than 1 event in init.ora, they have to be consecutive. otherwise just last one will be active. Now, re-start db abd try to get same error. Oracle will dump recovery operation in alert.log. And you will be able to see object id. drop this object. That's all. You can paste recovery dumps in alert.log to identify your object, as well. regards... 27/7/01 08:37:06, Cale, Rick T (Richard) [EMAIL PROTECTED] wrote: Hi DBAs, Oracle 8.0.5/Windows NT4 I shutdown database normal and restarted ok. I tried to drop a rollback segment and getora-1545 rollback segment not available. When I select from dba_rollback_segs I get needs recovery. I want to drop rollback tablespace and all rollback segment then rebuild because I got datafile corruption error. I am in noarchive mode. Any ideas how to proceed? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Help ! ORA-00600 : internal error code
Thank you Rajesh, Some of Oracle bugs are internal, you may not see all bugs. So, I've added email feature to iOraBugFinder. Now, you can send the results and uploaded file to Oracle support if iOraBugFinder doesn't return your bugs. Since trace files are analyzed, response time from Oracle support is reduced. Recommendations: - Don't upload alert file when bug depth = 0 - Upload trace file instead of alert - Use higher level bug to get close to your bug. If it doesn't return bug, select lower levels. regards.. 26/7/01 11:20:50, Rajesh Dayal [EMAIL PROTECTED] wrote: Earlier it used to mean Goto Oracle Support But now you have a choice. http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html And it works . most of the cases... HTH, Rajesh -Original Message- Sent: Thursday, July 26, 2001 10:31 AM To: Multiple recipients of list ORACLE-L Help ! What does this mean? ORA-00600: internal error cod, arguments : [733], [33719116], [pga heap], [], [], [], [], [] John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Reproduce ORA-0600
Hello, What was the first parameter of ora-600 ? We should unserstand if your ora-600 are cause or consequence. if it's consequence( I guess it's in your case), ignore it. 24/7/01 06:10:53, Lord, David - CS [EMAIL PROTECTED] wrote: Try upgrading to 8.1.6, its great at throwing 600's ;-) -Original Message- Sent: 24 July 2001 15:31 To: Multiple recipients of list ORACLE-L I had a production database become corrupt after an ORA-07445 and an ORA-0600 occurred. The instance would not come back up and had to be recovered. I can reproduce and correct the ORA-07445 (bad block) but it doesn't create the ORA-0600 or corrupt the database. I have tried adding rows, deleting rows, reading by the index by requesting all columns in the index, updating all columns in the index. Nothing seems to work. Any ideas on how I can reproduce the error? Ron Smith [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Lord, David - CS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: what do I tune?
Hi, itrprof SQL Analyzer can do what you asked. itrprof: http://www.unal-bilisim.com/products/itrprof/itrprof.html 24/7/01 06:56:29, Gene Gurevich [EMAIL PROTECTED] wrote: Hi all: I am trying to tune some queries. I ran them all in one stream (in sequence) and then ran them in several (up to 64) parallel streams. I got a snapshot of the system for each run. I see some of the waits went up significantly when I switched from 2 parallel streams to 64: buffer busy wait, db file seq read, enqueue waits, latch free waits and many more. Now some of this increases may be OK, some may be not. My question is how do I decide which of these waits are a problem and should be looked into and which are normal and can be safely ignored. Are there any quantative rules that I could use? thank you for any insight Gene = __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Gurevich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Tracing
Hello list, Following link explains all issues on sql/event10046 traces: http://www.unal-bilisim.com/products/itrprof/itrprof_user_manual.html#sql_trace 16/7/01 07:10:35, JOE TESTA [EMAIL PROTECTED] wrote: and dont do it and try to do an upgrade(which sql_trace=true) , a simple 1 hour upgrade ran like 16 hours, had me stumped for a while, thankfully the upgrade scripts can be run multiple time with no impact :) joe [EMAIL PROTECTED] 07/16/01 12:00PM Don't do this blindly. Turning sql_trace = TRUE on for the entire database will decrease performance. And it goes without saying do NOT do this in production! Session level tracing is more appropriate. Lisa Koivu Data Bored Administrator Ft. Lauderdale, FL, USA -Original Message- From: Ramasamy, Baskar [SMTP:[EMAIL PROTECTED]] Sent: Monday, July 16, 2001 11:46 AM To:Multiple recipients of list ORACLE-L Subject: RE: Tracing Best option would be turn on the sql_trace and timed_statistice parameter in init.ora and re-start the database. But makes ure you have enought space to write trc files in OS Baskar -Original Message- Sent: 16 July 2001 16:12 To: Multiple recipients of list ORACLE-L On Jul 16, 2001 at 06:45:36AM, Libal, Ivo wrote: Hello I would like to start tracing for different session than my one. How it is possible in 8.1.7 EE? I want to start tracing for different sessions with different levels (not necessary diff. levels). I found that it should be possible with dbms_support package, but i didnt find this package and I also didnt find creation script in my rdbms/admin directory (it should be dbmssupp.sql). Please help me where I can find it or how to do it. Ivo Libal dbms_system.set_ev(sid, serial, event, level, NULL); -- Vladimir Begun | Without freedom of choice there is no http://vbegun.net/ | creativity. http://vbegun.net/wap/ | -- Kirk, The return of the [EMAIL PROTECTED]| Archons, stardate 3157.4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Begun INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Ramasamy, Baskar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Re:Multiple Listeners
hello Edward, If I understand wrong, ignore this message. As I understand, listener listens requests of client processes, then passes them to server processes. When I client connects to server, It uses a random port on client and uses listener port number of server. After server receives requests on listener port, listener process creates new dedicated process and assigns a new random port number to new dedicated process. This is called redirection. After new port is assigned to dedicated server, this port number is transmitted to client process. Then, all subsequent requests of client are done between client's current port and new assigned server port, not listener port. Listener is no longer is used. That is why when a listener is stopped, active client processes keep running. That is why although listener port is registered in firewall definitions, users get problem since new assigned random port may not be registerd in firewall. This can be seen in sql*net level-16 traces. regards... 17/7/01 01:55:53, [EMAIL PROTECTED] wrote: Edward, One must ask, what benefit do you perceive you will obtain from having multiple listeners? The listener is only there to hear the end applications request for database service and pass them along to the appropriate dedicated server or dispatcher as required. Then it goes off to do other things. We have one HP with 9 different instances, one listener. Works fine all day. Dick Goulet Reply Separator Author: Edward W. Carr [EMAIL PROTECTED] Date: 7/16/2001 1:42 PM Hello All, I am currently running Oracle 816 64bit on a Solaris 8 box. I have three databases on the system with one LISTENER for all of them. Is it possible to configure multiple listeners, one for each database? We have tried in the past with no success... If there is a document on the web somebody could point me to, that would be great! I have searched for one but must not be searching correctly. TIA, -- Edward W. Carr UNIX Systems Administrator Qwest Communications Broadband Services Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Second RBS in system tablespace
Hello, SYSTEM rbs is reserved actions against the SYSTEM tablespace. There are some mis-conceptions against this issue. Actions against the SYSTEM tablespace can use non-SYSTEM rbs, too. For example, Recursive transactions,in other words: Oracle kernel transactions by SYS users, do not always have to use SYSTEM rbs. SYSTEM rbs is the last statation if there is no available slot in rbs in which current user transaction is assigned. So, Oracle kernel does not have to compete with user transactions. hope this helps... Kevin Lange wrote: As a guess I would think it was because the system tablespace is so active with all the queries against the catalog. -Original Message- Sent: Wednesday, July 11, 2001 12:03 PM To: Multiple recipients of list ORACLE-L Hi Everybody I'm running 8.1.7 and i just read that i should have a second rollback segment in the system tablespace. Can someone tell me why this is and how big should i create it? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: hp INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: 81714 aborted upgrade and core dumps on NT
Hello, you can email me with zipped core file. 10/7/01 07:51:51, Jeffrey Beckstrom [EMAIL PROTECTED] wrote: We have been running 8.1.7 for a couple weeks. The clients are 8.1.6 still [EMAIL PROTECTED] 7/10/01 11:55:59 AM Are you running the 8.1.7 sqlnet clients and odbc drivers. We did have some notablyunexplained errors connecting older versions to 8.1.7 - most with large objects. -Original Message- [mailto:[EMAIL PROTECTED]] To: Multiple recipients of list ORACLE-L Hi, I have just had the experience of upgrading to 81714, discovering a in our application that did not show up in any testing and having to go back to 815. have the 817 instance available for further troubleshooting.e and we still This is on NT4. With 817, we were getting ora-3113 in the forms application and in ODBC connections and also seeing ora-03121 as well. We got core dump files produced (under 817 they are produced on NT) but Oracle support does not seem to know how to interpret them on NT - has anyone had any experience with this? files were produced in the user dump directory.within the alert log and no When I turned sql trace on for the session running forms, the ora-3113 did not occur - has anyone seen behaviour like this where SQL Trace will cause an ora-3113 to stop occurring? All suggestions on what to look for or how to interpret NT core dumps are welcome. Thanks, [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Number of returned row(s) is greater than 0 while number of logical read
Hello, When "Number of returned row(s) is greater than 0 while number of logical read is 0", itrprof prompts error. Some of itrprof users encounter this error. here is a line from raw file: FETCH #3:c=1,e=0,p=0,cr=0,cu=0,mis=0,r=10,dep=0,og=3,tim=443263450 As you see, number of logical reads are 0, but number of returned rows are 10. how is that possible ? I guess this is bug. have you encountered some problem. have you ever seen same problem in tkprof output ? thanks in advance...
Re: large SORT_AREA_SIZE usefullness
Hello Johnson, There are great papers at http://www.fortunecity.com/skyscraper/oracle/699/orahtml/ But, I still disagree with you. Becasue, tuning SORT will not make benefit in your case. yes, you are right, it's not easy to generate good SQL if SQL is generated by end-users. I don't know your design, perhaps, you can add hidden indexed-columns to generated SQLs to make end-users to use indexes. regards... Johnson Poovathummoottil wrote: Hi Danisment Gazi Unal, Itprof's suggestion is valid that I should be able to use an index to speed up this query. But my objective here is to help sorting. Many users write adhoc queries to into my warehouse and all are not going to be tuned queries. Many go for full tablescans on some big fact tables and sort like hell. We do have some good indexes for often used queries. But it is the adhoc one which people cook up that hurt us bad. So my intention is to tune sorts. In that light could you give me an explanation for the query running slow because the sort_area_size was increased? __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson Poovathummoottil INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: large SORT_AREA_SIZE usefullness
Thank you Greg, We can discuss itrprof results in this great list. Greg Moore wrote: all the quries which used the larger sort_area_size actually ran slower Why don't you simply run a trace for the small sort_area_size, do the same with the larger sort_area_size, and then submit the trace files to that web site http://www.unal-bilisim.com/products/itrprof/itrprof.html to see what analysis and advice you get. I'm sure many of the people on this list are curious about this itrprof tool and would be interested in hearing if it helps you answer this question. You could probably put the output up to the list and get advice, especially since the guy who runs the site is on this list. I'd love to see a real-life example of this tool in action. - Greg -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
cursor 0 in sql_trace and event10046 raw trace files
Hello list, some of itrprof users encounter cursor 0. Since there is no parsed SQL statement which has a cursor number 0, itrprof prompts "itp-05 [x] : File corrupted." message. I examined raw trace files and could not see an SQL statement which has a cursor number 0. I think this is a bug. because, it's not possible for a kernel call to make a kernal call with non-existing cursor number. Since tkprof doesn't report this error, Oracle may have not fixed it. have you encountered same problem ? thanks in advance... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: how to find CPU utilisation at Oracle level
Hi Lisa, itrprof SQL Analyzer is a web based tool which analyzes SQL_TRACE and Event 10046 trace files of Oracle; finds bottlenecks and offers information on how to tune them. It's at http://www.unal-bilisim.com/products/itrprof/itrprof.html ---sorry list--- "Koivu, Lisa" wrote: Please excuse my ignorance... but what's itrprof? Not tkprof? Lisa Koivu Goddess of Inept Ninja-ettes -Original Message- From: Danisment Gazi Unal [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, June 20, 2001 3:06 PM To: Multiple recipients of list ORACLE-L Subject: Ynt: how to find CPU utilisation at Oracle level Hello, itrprof calculates CPU utilization for SQLs, total non-SYS SQLs and total sys SQLs. I guess I'll be a marketing employee. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]> Sent: Wednesday, June 20, 2001 8:49 PM > Hi > Is there any way to find which oracle process is taking much CPU except at > OS level.Is there any view available from which we can see the cpu > utilisation of particular user query. > Thanks in advance > -Seema > _ > Get your FREE download of MSN Explorer at http://explorer.msn.com > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Seema Singh > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > > 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.com -- Author: Danisment Gazi Unal INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists 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).
Ynt: SQL Trace ( Perl script help needed)
hello Siva, You can concatenate raw SQL_TRACE files as a single file, then upload this file to itrprof. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, June 19, 2001 2:30 AM Hello Gurus, I was trying to pull distinct sql's and their total execute count from a bunch of 250 trace output files(output from tkprof trace files). How can I achive this. What i need the cumulative sum of execute count from different files for each sql's. As u all know sql can extend more than one line so ! I know this can be handled using perl script. file1.prf . select * from tablename1 where col1=:1 and col2=:2 call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse5 0.00 0.00 0 0 0 0 Execute 5 0.02 0.02 0600 0 0 Fetch5 0.00 0.00 0 0 0 0 --- -- -- -- -- -- -- total 15 0.02 0.02 0600 0 0 ... select * from tablename2 where col1=:1 and col2=:2 call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse5 0.00 0.00 0 0 0 0 Execute 5 0.02 0.02 0600 0 0 Fetch5 0.00 0.00 0 0 0 0 --- -- -- -- -- -- -- total 15 0.02 0.02 0600 0 0 file2.prf select * from tablename1 where col1=:1 and col2=:2 call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse5 0.00 0.00 0 0 0 0 Execute 5 0.02 0.02 0600 0 0 Fetch5 0.00 0.00 0 0 0 0 --- -- -- -- -- -- -- total 15 0.02 0.02 0600 0 0 select * from tablename3 where col1=:1 and col2=:2 call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse5 0.00 0.00 0 0 0 0 Execute 5 0.02 0.02 0600 0 0 Fetch5 0.00 0.00 0 0 0 0 --- -- -- -- -- -- -- total 15 0.02 0.02 0600 0 0 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Valiveru, Siva INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: unal-bilisim INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Redo latch contention
Mogens, You are right. nothing is a performance problem unless there is a time contention. In general, it's very hard to see time spent in each latch. itrprof SQL Analyzer with waitgroup=(name,P1,P2) can report time spent in each latch. So, you can see time spent in A latch, time spent in B latch, etc. I'm not a very old dba, but I don't think many latches can be tuned by init.ora parameters. with waitgroup=(name,P1), you can see time spent in each enqueue such as 5 sec in (TX), 3 sec in (TM) etc. 'latch free' and 'enqueue' waits do not make sense themselves. You can drill-down these each waits by itrprof. a little marketing... Mogens Nrgaard wrote: First of all, if you don't see cumulated waits for the 'latch free' event in either v$system_event or v$session_event (for a specific session/job) there is absolutely no need to do anything about these ratios. It's about the only two latches mentioned in the reference books and it's about the only two latches that never really have a problem :). My guess is that this effort (increasing log_simultaneous_copies and log_small_entry_max_size) hasn't increased performance on your system whatsoever. If - only if - you have latch contention/waits in the system (high percentage of time_waited in the above-mentioned v$system_event/v$session_event, you should ignore all those calculations with gets and misses and insted just look in v$latch like this: select name, sleeps from v$latch order by 2; to find the latches with highest contention. But again: If your system or session is not really waiting for latches, why bother? Rajesh Dayal wrote: Hi All, I had some situation of Redo Allocation and copy latch contention as stated in following output. SQL SELECT substr(NAME,1,18) NAME, GETS,MISSES, IMMEDIATE_GETS, IMMEDIATE_MISSES FROM V$LATCH WHERE NAME LIKE '%redo%' / NAME GETS MISSES IMMEDIATE_GETS IMMEDIATE_MISSES -- -- -- -- redo allocation 74878 16 00 redo copy 114100 53756 232 redo writing30219 1 00 3 rows selected. Realizing small contention on redo allocation latch, I increased the value of "log_small_entry_max_size" from 80 to 90. But this would definitely overload (already suffering) redo copy latches, so I increased the value of log_simultaneous_copies from 2 to 6. This sorted out redo latch contention, but somewhere in FM it's mentioned that value of log_simultaneous_copies shouldn't be more than (2 * #_of_CPUs). Again I know that the CPU is "not" heavily used so far. So... 1. Is it OK to set log_simultaneous_copies higher than 2*CPU. What are the golden rules. I have seen some authers not mentioning this. 2. Why this parameter is missing from Oracle 8i?? Has Oracle changed the algorithm?? What is the new strategy to handle redo latch contention?? Interestingly, in Oracle 8i (Oracle 8.1.6) Tuning Manuals they still talk of these parameters(which are made obsolete)... Appreciate your inputs ;-) Cheers, Rajesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Venlig hilsen Mogens Nrgaard Technical Director Miracle A/S, Denmark Web: http://MiracleAS.dk Mobile: +45 2527 7100 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mogens =?iso-8859-1?Q?N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051
Re: Searching hard parses
Hello, First of all, let's notice that: - number of means AMOUNT - ratio means SPEED - time means TIME If you don't encounter time related events such as waits, CPU usages, It doesn't make sense What the values of AMOUNT and SPEED are. In you case, startting from parse count is not correct way. You should focus on parsing if parse time is high. use itrprof SQL Analyzer to see parse time, parse amount with their relavent SQLs. regards... Fernando Papa wrote: Hi everybody! I have this numbers for "parses": 1402684 parse count (hard) 9766294 parse count (total) 14,36 % of my parses are hard My database it's up since more than two days, with 943249 cumulative logons (oltp). The problem is two months ago the percentage of hard parses was about 12%... I try to find which sql sentences are forcing "hard" parses, but I don't know I can do it querying some v$ views or I need to examine directly all the sessions... Thanks in advance! -- Fernando O. Papa DBA El Sitio - Infraestructura (54-11) 4339-3854 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fernando Papa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Ora-600 : Internal error code.. Help!!!
Unal is my surname, Bilisim is a Turkish word which means Information relevant things. "Koivu, Lisa" wrote: OK. What is unal-bilisim, it sounds like it's kinda disgusting. But what do I know. -Original Message- From: Kevin Lange [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, June 12, 2001 4:25 PM To: Multiple recipients of list ORACLE-L Subject: RE: Ora-600 : Internal error code.. Help!!! There is a web site, http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html, that lets you upload your trace file and it will give you links to any relavant info it can find on the subject. You might want to try it. -Original Message- Sent: Tuesday, June 12, 2001 1:07 PM To: Multiple recipients of list ORACLE-L DBA's I am getting following error in alert.log once in two days. on Jun 11 09:26:11 2001 Errors in file /export/home/u01/app/oracle/admin/orcl/udump/orcl_ora_6342.trc: ORA-00600: internal error code, arguments: [12333], [111], [108], [44], [], [], [], [] Mon Jun 11 09:49:04 2001 LGWR: prodding the archiver The DB is 8.1.5 on Solaris 7. When I referered to metalink, it says there could be some problem with the network in OS level. I am not sure how to track the error or where to look for this in the OS. Could some one help me in finding the cause of this problem? Thanks Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Gopalan INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists 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.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists 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). -- Web: http://www.unal-bilisim.com * Questions and Answers: http://www.unal-bilisim.com/qa/discus/ * itrprof SQL Analyzer: http://www.unal-bilisim.com/products/itrprof/itrprof.html itrprof SQL Analyzer is a web based tool which analyzes SQL_TRACE/Event10046 trace files of Oracle, finds bottlenecks and offersinformation on how to tune them. * iOraBugFinder: http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html iOraBugFinder is a web based tool which scans Oracle's alert log files, ORA-600 and ORA-7445 trace files; extracts relevant information from them and generates URL links to relevant bugs, notes, forums at Metalink. *
Re: Export sizing
Hello, Yes you can. see http://www.unal-bilisim.com/qa/discus/messages/20/42.html?9923410 for Unix. I don't know NT. But, pipe mechanism is generic mechanism for Operating Systems Theory. There should be a way for NT to create pipes. By pipes, you can calculate. regards... "O'Neill, Sean" wrote: Is there some way to calculate or make a realistic guestimate as to what size an Export dump file will be for a given schema or indeed a whole database. I've not come across anything on this topic before. If result is dependant on O.S. I'm particularily interested in NT/W2K O.S. Sean :) Rookie Data Base Administrator [0%] OCP Oracle8i DBA [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA "Nobody loves me but my mother... and she could be jivin' too." - BB King -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Web: http://www.unal-bilisim.com * Questions and Answers: http://www.unal-bilisim.com/qa/discus/ * itrprof SQL Analyzer: http://www.unal-bilisim.com/products/itrprof/itrprof.html itrprof SQL Analyzer is a web based tool which analyzes SQL_TRACE/Event10046 trace files of Oracle, finds bottlenecks and offersinformation on how to tune them. * iOraBugFinder: http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html iOraBugFinder is a web based tool which scans Oracle's alert log files, ORA-600 and ORA-7445 trace files; extracts relevant information from them and generates URL links to relevant bugs, notes, forums at Metalink. * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: ORA-12545
These types errors are the errors which are casued by other errors. are there any other errors including alert.log ? [EMAIL PROTECTED] wrote: Hi Gurus! What can be wrong when I receive the following error message? ORA-12545: Connect failed because target host or object does not exist We use WinNT, Oracle 8.1.7 and Oracle Application Server. Any Idea? Thanks in advance Gyula -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Web: http://www.unal-bilisim.com * Questions and Answers: http://www.unal-bilisim.com/qa/discus/ * itrprof SQL Analyzer: http://www.unal-bilisim.com/products/itrprof/itrprof.html itrprof SQL Analyzer is a web based tool which analyzes SQL_TRACE/Event10046 trace files of Oracle, finds bottlenecks and offersinformation on how to tune them. * iOraBugFinder: http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html iOraBugFinder is a web based tool which scans Oracle's alert log files, ORA-600 and ORA-7445 trace files; extracts relevant information from them and generates URL links to relevant bugs, notes, forums at Metalink. * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: OT: Pin a CPU in Solaris
Hi, You can write a loop... Erik Williams wrote: Does anyone know how to pin a Solaris CPU at a high utilization? I am doing some testing and want to evaluate a system under a high CPU load. Thanks. Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Erik Williams INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Web: http://www.unal-bilisim.com * Questions and Answers: http://www.unal-bilisim.com/qa/discus/ * itrprof SQL Analyzer: http://www.unal-bilisim.com/products/itrprof/itrprof.html itrprof SQL Analyzer is a web based tool which analyzes SQL_TRACE/Event10046 trace files of Oracle, finds bottlenecks and offersinformation on how to tune them. * iOraBugFinder: http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html iOraBugFinder is a web based tool which scans Oracle's alert log files, ORA-600 and ORA-7445 trace files; extracts relevant information from them and generates URL links to relevant bugs, notes, forums at Metalink. * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Ora-600 : Internal error code.. Help!!!
Hello, did you run iOraBugFinder ? Raj Gopalan wrote: DBA's I am getting following error in alert.log once in two days. on Jun 11 09:26:11 2001 Errors in file /export/home/u01/app/oracle/admin/orcl/udump/orcl_ora_6342.trc: ORA-00600: internal error code, arguments: [12333], [111], [108], [44], [], [], [], [] Mon Jun 11 09:49:04 2001 LGWR: prodding the archiver The DB is 8.1.5 on Solaris 7. When I referered to metalink, it says there could be some problem with the network in OS level. I am not sure how to track the error or where to look for this in the OS. Could some one help me in finding the cause of this problem? Thanks Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Gopalan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Web: http://www.unal-bilisim.com * Questions and Answers: http://www.unal-bilisim.com/qa/discus/ * itrprof SQL Analyzer: http://www.unal-bilisim.com/products/itrprof/itrprof.html itrprof SQL Analyzer is a web based tool which analyzes SQL_TRACE/Event10046 trace files of Oracle, finds bottlenecks and offersinformation on how to tune them. * iOraBugFinder: http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html iOraBugFinder is a web based tool which scans Oracle's alert log files, ORA-600 and ORA-7445 trace files; extracts relevant information from them and generates URL links to relevant bugs, notes, forums at Metalink. * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Crash Recovery
Hi, In fact, in your case, adding larger TEMP is not the solution. Solution is the adding TEMP with larger extent size. Because, Oracle cleans up segments extent-by-extent. If you have more extents, cleaning-up them will make more dictionary look-up and this will eat CPU. regards... Charlie Mengler wrote: I've had something like this happen to me. My solution was to make TEMP larger; after enduring the LONG wait for recovery to complete. "Naik, Kevin K" wrote: Hi All, I have an interesting problem, on one of my databases, a data warehouse, a killed session was taking too long to rollback. It was time for the backup, and I had to do a shutdown abort. No its time to open the database, instance parallel recovery is taking place as normal, but the problem is, its being running for more than 20 hours and the database is still not open. Does any body have any clues, thoughts, ideas ?? Is there anyway I can see what exactly the dbms is up to ? The instance processes running are completely idle Thanx K Naik __ Disclaimer and confidentiality note Everything in this e-mail and any attachments relating to the official business of Standard Bank Investment Corporation(Stanbic) is proprietary to the company. It is confidential, legally privileged and protected by law. Stanbic does not own and endorse any other content. Views and opinions are those of the sender unless clearly stated as being that of Stanbic. The person addressed in the e-mail is the sole authorised recipient. Please notify the sender immediately if it has unintentionally reached you and do not read, disclose or use the content in any way. Stanbic can not assure that the integrity of this communication has been maintained nor that it is free of errors, virus, interception or interference. ___ -- Web: http://www.unal-bilisim.com * Questions and Answers: http://www.unal-bilisim.com/qa/discus/ * itrprof SQL Analyzer: http://www.unal-bilisim.com/products/itrprof/itrprof.html itrprof SQL Analyzer is a web based tool which analyzes SQL_TRACE/Event10046 trace files of Oracle, finds bottlenecks and offersinformation on how to tune them. * iOraBugFinder: http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html iOraBugFinder is a web based tool which scans Oracle's alert log files, ORA-600 and ORA-7445 trace files; extracts relevant information from them and generates URL links to relevant bugs, notes, forums at Metalink. *
Re: ORA-01555 error
Hello, There are about 4 cases for ora-1555. Add following event to init.ora: event = "1555 trace name errorstack, level 3" After that, whenever Oracle encounteres ora-1555, a trace file will be generated. Send trace file, let's look at what is happenning. regards... "Farnsworth, Dave" wrote: I got this error last night; SCT51 - FETCH FROM DRP DRIVER CURSOR FOR DRP PROCESSING FAILED. MSG = SCT SCP_DRP_DRIVERPRODDB ORA-01555: snapshot too old: rol lback segment number 15 with name "RB1 Do I just need to increase the size of the rollback segment to fix this or is there something else I need to be looking at? Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Web: http://www.unal-bilisim.com * Questions and Answers: http://www.unal-bilisim.com/qa/discus/ * itrprof SQL Analyzer: http://www.unal-bilisim.com/products/itrprof/itrprof.html itrprof SQL Analyzer is a web based tool which analyzes SQL_TRACE/Event10046 trace files of Oracle, finds bottlenecks and offersinformation on how to tune them. * iOraBugFinder: http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html iOraBugFinder is a web based tool which scans Oracle's alert log files, ORA-600 and ORA-7445 trace files; extracts relevant information from them and generates URL links to relevant bugs, notes, forums at Metalink. * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Crash Recovery
Hi, Oracle was doing full recovery in older version during crash recovery ( I guess pre 7.3, but I'm not sure). But now, Oracle does not do full database recovery during crash recovery. Some un-recovered blocks are recovered when a user tries to use them later. So, if your online log files are not to huge, recovery is not a problem in your case. I guess ( I dont't like estimation), SMON may be cleaning up TEMP segments. Add following event to init.ora to see what is happing during recovery: event="10013 trace name context forever, level 10" This will show stages of recovery in alert log. If, SMON is trying to clean-up TMP segments, add following event to init.ora to disable SMON Temp cleanup: event="10061 trace name context forever, level 10" You can remove Event 10061 from init.ora later. There should be an event that makes SMON clean-up TEMP segments part-by-part. By this event, SMON doesn't clean up all TEMP segments immediately. SMON cleans up some parts of TEMP segments. after a while, SMON cleans up remainder parts. But, I dont't remember this event now. NOT: Be sure these events are active. Run "show parameters event" in svrmgrl after STARTUP NOMOUNT. "Naik, Kevin K" wrote: Hi All, I have an interesting problem, on one of my databases, a data warehouse, a killed session was taking too long to rollback. It was time for the backup, and I had to do a shutdown abort. No its time to open the database, instance parallel recovery is taking place as normal, but the problem is, its being running for more than 20 hours and the database is still not open. Does any body have any clues, thoughts, ideas ?? Is there anyway I can see what exactly the dbms is up to ? The instance processes running are completely idle Thanx K Naik __ Disclaimer and confidentiality note Everything in this e-mail and any attachments relating to the official business of Standard Bank Investment Corporation (Stanbic) is proprietary to the company. It is confidential, legally privileged and protected by law. Stanbic does not own and endorse any other content. Views and opinions are those of the sender unless clearly stated as being that of Stanbic. The person addressed in the e-mail is the sole authorised recipient. Please notify the sender immediately if it has unintentionally reached you and do not read, disclose or use the content in any way. Stanbic can not assure that the integrity of this communication has been maintained nor that it is free of errors, virus, interception or interference. ___ -- Web: http://www.unal-bilisim.com * Questions and Answers: http://www.unal-bilisim.com/qa/discus/ * itrprof SQL Analyzer: http://www.unal-bilisim.com/products/itrprof/itrprof.html itrprof SQL Analyzer is a web based tool which analyzes SQL_TRACE/Event10046 trace files of Oracle, finds bottlenecks and offersinformation on how to tune them. * iOraBugFinder: http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html iOraBugFinder is a web based tool which scans Oracle's alert log files, ORA-600 and ORA-7445 trace files; extracts relevant information from them and generates URL links to relevant bugs, notes, forums at Metalink. *
Re: urgent !!
Thank you Bunyamin, This is the one of the solution of generic ORA-12571 error. Keep in mind that there are a lot of solutions for that. "Bunyamin K. Karadeniz" wrote: Thank you All , for the answersI have corrected the fault with your helps.By the way ,Let me give you a fix of a bug on NT .If you take a packet write failure errorr.ORA-12571. This mean you will enter a dword value in registry in HKEY_LOCAL_MACHINE/system/currentcontrolset/services/tcpip/parametersdword will be.maxdatatransmissions = 15 in decimal.I faced it and tested. - Original Message - From: Robertson Lee - lerobe To: Multiple recipients of list ORACLE-L Sent: Thursday, June 07, 2001 12:24 PM Subject: RE: urgent !! I would suggest that your init.ora file is not where it should beie. check thatD:\oracle\ora816\admin\uybs\inituybs.orais exactly where the parameter file is and that it is named correctly.CheersLee -Original Message- From: Bunyamin K. Karadeniz [mailto:[EMAIL PROTECTED]] Sent: 07 June 2001 09:15 To: Multiple recipients of list ORACLE-L Subject: urgent !! Hi all gurus..I want to create my database on NT but svrmgrl gives error ofSVRMGR> startup nomount pfile=D:\oracle\ora816\admin\uybs\inituybs.ora LRM-00109: could not open parameter file 'D:\oracle\ora816\admin\uybs\inituybs.ora' ORA-01078: failure in processing system parametersHow can I know which parameter causes the error?Here are my parameters Which one?db_name = UYBSinstance_name = UYBSservice_names = UYBSdb_files = 1024control_files = (D:\uyap_database\cf\control01.ctl, C:\uyap_database\cf\control02.ctl )open_cursors = 200 max_enabled_roles = 145db_file_multiblock_read_count = 16 db_block_buffers = 8192 db_block_size = 4096shared_pool_size = 22775808 large_pool_size = 734003200 java_pool_size = 0log_checkpoint_interval = 1 log_checkpoint_timeout = 1800processes = 715parallel_max_servers = 5log_buffer = 32768max_dump_file_size = 10240 # limit trace file size to 5M each log_archive_start = true log_archive_dest_1 = "location=D:\uyap_database\arc" log_archive_format = %%ORACLE_SID%%T%TS%S.ARC max_rollback_segments = 80 rollback_segments = ( RBS0, RBS1, RBS2, RBS3, RBS4, RBS5, RBS6, RBS7, RBS8, RBS9, RBS10, RBS11, RBS12, RBS13, RBS14, RBS15, RBS16, RBS17, RBS18, RBS19, RBS20, RBS21, RBS22, RBS23, RBS24, RBS25, RBS26, RBS27, RBS28, RBS29, RBS30, RBS31, RBS32, RBS33, RBS34, RBS35, RBS36, RBS37, RBS38, RBS39, RBS40 ) global_names = true oracle_trace_collection_name = "" background_dump_dest = D:\uyap_database\trace\bdump user_dump_dest = D:\uyap_database\trace\udump remote_login_passwordfile = exclusiveos_authent_prefix = ""distributed_transactions = 10 mts_dispatchers = "(protocol=TCP)"compatible = 8.1.0 sort_area_size = 65536 sort_area_retained_size = 65536 optimizer_mode=CHOOSE timed_statistics = true The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Web: http://www.unal-bilisim.com * Questions and Answers: http://www.unal-bilisim.com/qa/discus/ * itrprof SQL Analyzer: http://www.unal-bilisim.com/products/itrprof/itrprof.html itrprof SQL Analyzer is a web based tool which analyzes SQL_TRACE/Event10046 trace files of Oracle, finds bottlenecks and offersinformation on how to tune them. * iOraBugFinder: http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html iOraBugFinder is a web based tool which scans Oracle's alert log files, ORA-600 and ORA-7445 trace files; extracts relevant information from them and generates URL links to relevant bugs, notes, forums at Metalink. *
Re: dbsnmp package
Bunyamin, select * from dba_objects where object_name like '%DBSNMP%'; "Bunyamin K. Karadeniz" wrote: Hi all gurus,My question is how can I query the database for which packages are installed?I wonder if dbsnmp is installed?Thank you.Bunyamin -- Web: http://www.unal-bilisim.com * Questions and Answers: http://www.unal-bilisim.com/qa/discus/ * itrprof SQL Analyzer: http://www.unal-bilisim.com/products/itrprof/itrprof.html itrprof SQL Analyzer is a web based tool which analyzes SQL_TRACE/Event10046 trace files of Oracle, finds bottlenecks and offersinformation on how to tune them. * iOraBugFinder: http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html iOraBugFinder is a web based tool which scans Oracle's alert log files, ORA-600 and ORA-7445 trace files; extracts relevant information from them and generates URL links to relevant bugs, notes, forums at Metalink. *
Re: How to remove corrupted blocks from datafile.
Hi Uday, I don't know in which version dbv is stable; but, I know dbv was very buggy product. I recommend: - add event="10231 trace name context forever, level 10" to init.ora. This will eliminate corrupted blocks during full table scan. Note that this event is used while reading from disk. It does not effect cached blocks. - rebounce db. - create new table as select * from corrupted_table New table will not contain corrupted block. Following event should be used if blocks are accessed through index: event="10233 trace name context forever, level 10" udaycb wrote: Hi, I found some corrupted blocks in one of the datafile. I have created the temp table by select all the records (excluding the records in corrupted blocks) from corrupted table, and dropped the table, renamed the temp table back to original. After this when i run DBV on that file, it still shows there are some corrupted blocks in the file. i have two questions, 1 How do i calculate how many records i have lost? 2 How do i remove corrupted blocks from the blocks? Can anyone tell me ... Thanks in advance Uday Name: winmail.dat winmail.datType: DAT Dosyas (application/x-unknown-content-type-dat_auto_file) Encoding: 7bit -- Web: http://www.unal-bilisim.com * Questions and Answers: http://www.unal-bilisim.com/qa/discus/ * itrprof SQL Analyzer: http://www.unal-bilisim.com/products/itrprof/itrprof.html itrprof SQL Analyzer is a web based tool which analyzes SQL_TRACE/Event10046 trace files of Oracle, finds bottlenecks and offersinformation on how to tune them. * iOraBugFinder: http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html iOraBugFinder is a web based tool which scans Oracle's alert log files, ORA-600 and ORA-7445 trace files; extracts relevant information from them and generates URL links to relevant bugs, notes, forums at Metalink. * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: problems when running dbstart
Hello Mikael, Rename open_link parameter in paremeter file initsid.ora or init.ora to open_links. Mikael Granhed wrote: Hi, I have oracle 8.06 installed on Sun Solaris. I have problems starting the database after a system crash and I had to reboot the system. When i run dbstart I got the following error message: SVRMGR connected SVRMGR oracle instance shut down SVRMGR Server manager complete ... ... ... SVRMGR connected SVRMGR LRM-00101: unknown parameter name 'open_link' ORA-01078: failure in processing system parameters SVRMGR server manager complete It's probably a very simple error but I'm a newbie in this area. regards /Mikael -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mikael Granhed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Web: http://www.unal-bilisim.com * Questions and Answers: http://www.unal-bilisim.com/qa/discus/ * itrprof SQL Analyzer: http://www.unal-bilisim.com/products/itrprof/itrprof.html itrprof SQL Analyzer is a web based tool which analyzes SQL_TRACE/Event10046 trace files of Oracle, finds bottlenecks and offersinformation on how to tune them. * iOraBugFinder: http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html iOraBugFinder is a web based tool which scans Oracle's alert log files, ORA-600 and ORA-7445 trace files; extracts relevant information from them and generates URL links to relevant bugs, notes, forums at Metalink. * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: SV: problems when running dbstart
You should rename it to max_transaction_branches . It's a typo error. I do typo errors very frequently, too. Mikael Granhed wrote: Thanks for your help, now it doesn't complain about "open_links" when i rename it. Now it's problem with the "max_transaktion_bransches". Should I rename that variable too? /Mikael -Ursprungligt meddelande- Frn: Danisment Gazi Unal (Unal Bilisim) [SMTP:[EMAIL PROTECTED]] Skickat: den 6 juni 2001 15:01 Till: Multiple recipients of list ORACLE-L mne: Re: problems when running dbstart Hello Mikael, Rename open_link parameter in paremeter file initsid.ora or init.ora to open_links. Mikael Granhed wrote: Hi, I have oracle 8.06 installed on Sun Solaris. I have problems starting the database after a system crash and I had to reboot the system. When i run dbstart I got the following error message: SVRMGR connected SVRMGR oracle instance shut down SVRMGR Server manager complete ... ... ... SVRMGR connected SVRMGR LRM-00101: unknown parameter name 'open_link' ORA-01078: failure in processing system parameters SVRMGR server manager complete It's probably a very simple error but I'm a newbie in this area. regards /Mikael -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mikael Granhed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Web: http://www.unal-bilisim.com * Questions and Answers: http://www.unal-bilisim.com/qa/discus/ * itrprof SQL Analyzer: http://www.unal-bilisim.com/products/itrprof/itrprof.html itrprof SQL Analyzer is a web based tool which analyzes SQL_TRACE/Event10046 trace files of Oracle, finds bottlenecks and offersinformation on how to tune them. * iOraBugFinder: http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html iOraBugFinder is a web based tool which scans Oracle's alert log files, ORA-600 and ORA-7445 trace files; extracts relevant information from them and generates URL links to relevant bugs, notes, forums at Metalink. * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Mikael Granhed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Web: http://www.unal-bilisim.com * Questions and Answers: http://www.unal-bilisim.com/qa/discus/ * itrprof SQL Analyzer: http://www.unal-bilisim.com/products/itrprof/itrprof.html itrprof SQL Analyzer is a web based tool which analyzes SQL_TRACE/Event10046 trace files of Oracle, finds bottlenecks and offersinformation on how to tune them. * iOraBugFinder: http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html iOraBugFinder is a web based tool which scans Oracle's alert log files, ORA-600 and ORA-7445 trace files; extracts relevant information from them and generates URL links to relevant bugs, notes, forums at Metalink. * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 S
Re: export causes segmentation fault
r/local/ bin:/usr/java/bin:/usr/bin:/usr/ucb:/etc:/usr/sbin:/usr/bin:/usr/ucb:/et c:/usr/dt /bin:/usr/sbin:/usr/ccs/bin:/usr/openwin/bin:/usr/local/bin:. $ uname -a SunOS aleg 5.8 Generic_111459-01 sun4u sparc SUNW,Sun-Blade-1000 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, Long (ITS, Limestone Ave) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Web: http://www.unal-bilisim.com * Questions and Answers: http://www.unal-bilisim.com/qa/discus/ * itrprof SQL Analyzer: http://www.unal-bilisim.com/products/itrprof/itrprof.html itrprof SQL Analyzer is a web based tool which analyzes SQL_TRACE/Event10046 trace files of Oracle, finds bottlenecks and offersinformation on how to tune them. * iOraBugFinder: http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html iOraBugFinder is a web based tool which scans Oracle's alert log files, ORA-600 and ORA-7445 trace files; extracts relevant information from them and generates URL links to relevant bugs, notes, forums at Metalink. * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: ora-600
Thank you Deshpande, It's nice to hear good results. I genarally recommend search depth=1. Search depth=0 may return a lot of bugs and it may take time to find which one is yours. And, You may not see all bugs. It depends on your license and bug status. Many bugs are un-published(not only bugs, but also everythingl. This list has more internals than Metalink). If iOraBugFinder returns no hit, email Oracle support with HTML or URL returned by iOraBugFinder. Since Oracle support can see all bugs, That will reduce your support response time from Oracle support. I added new features on 1.0.1 version. It's now better to find bugs. If you have any recommendations, please feel free to contact me. "Deshpande, Kirti" wrote: Hi, It generally means Contat Oracle Support. You may try to have your alert log file scanned at http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html. Set Search Depth to 0. Very nice little tool from Unal Bilisim. I used it a few times with good results. HTH Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: Raghu Kota [SMTP:[EMAIL PROTECTED]] Sent: Monday, June 04, 2001 3:11 PM To: Multiple recipients of list ORACLE-L Subject: ora-600 Hi Friends What does it mean?? ORA-00600: internal error code, arguments: [17112], [33054472] Thanks Raghu. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Web: http://www.unal-bilisim.com * Questions and Answers: http://www.unal-bilisim.com/qa/discus/ * itrprof SQL Analyzer: http://www.unal-bilisim.com/products/itrprof/itrprof.html itrprof SQL Analyzer is a web based tool which analyzes SQL_TRACE/Event10046 trace files of Oracle, finds bottlenecks and offersinformation on how to tune them. * iOraBugFinder: http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html iOraBugFinder is a web based tool which scans Oracle's alert log files, ORA-600 and ORA-7445 trace files; extracts relevant information from them and generates URL links to relevant bugs, notes, forums at Metalink. * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: DBA_OBJECTS
Bunyamin, Why don't you use v$locked_object ? "Bunyamin K. Karadeniz" wrote: I want to select locked_objects in a view.I runCREATE OR REPLACE VIEW V_BUN_LOCKED_OBJECTS ASSELECT sn.username, m.sid, m.type, DECODE(m.lmode, 0, 'None' , 1, 'Null' , 2, 'Row Share' , 3, 'Row Excl.' , 4, 'Share' , 5, 'S/Row Excl.' , 6, 'Exclusive' , lmode, ltrim(to_char(lmode,'990'))) lmode, DECODE(m.request, 0, 'None' , 1, 'Null' , 2, 'Row Share' , 3, 'Row Excl.' , 4, 'Share' , 5, 'S/Row Excl.' , 6, 'Exclusive' , request, ltrim(to_char(request,'990'))) request, obj1.object_name objname, obj2.object_name objname FROM v$session sn, V$lock m, dba_objects obj1, dba_objects obj2 WHERE sn.sid = m.sid AND m.id1 = obj1.object_id (+) AND m.id2 = obj2.object_id (+) AND lmode != 4 ;and gives error or ora-942. Can not find dba_objects .But with the same user I can query dba_objects table since my user has dba privilege.The inside of view runs perfectly.Why can it be?? -- Web: http://www.unal-bilisim.com * Questions and Answers: http://www.unal-bilisim.com/qa/discus/ * itrprof SQL Analyzer: http://www.unal-bilisim.com/products/itrprof/itrprof.html itrprof SQL Analyzer is a web based tool which analyzes SQL_TRACE/Event10046 trace files of Oracle, finds bottlenecks and offersinformation on how to tune them. * iOraBugFinder: http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html iOraBugFinder is a web based tool which scans Oracle's alert log files, ORA-600 and ORA-7445 trace files; extracts relevant information from them and generates URL links to relevant bugs, notes, forums at Metalink. *
Re: Tkprof/explain plan errors
Note that tkprof's execution plan shows execution plan against current database connection to which tkprof is connected. So, execution plan in trace file and execution plan in tkprof output may be different. And, I guess, tkprof shows first execution plan. If your statement parsed more than once, Execution plans may be different. have you run itrprof at http://www.unal-bilisim.com/products/itrprof/itrprof.html . It reports execution plans in trace files(so, correct execution plans) and you can see all execution plan(s). regards... [EMAIL PROTECTED] wrote: I am trying to do some performance tuning on a users query by using tkprof. After running tkprof on the trace file (which was generated after using alter sessions set sql_trace true), I look at the results and they say error connecting to database using: / ORA-01017: invalid username/password; logon denied EXPLAIN PLAN option disabled. However, the correct username/password is being used. Not sure what is going on with Explain plan. Any suggestions - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Web: http://www.unal-bilisim.com * Questions and Answers: http://www.unal-bilisim.com/qa/discus/ * itrprof SQL Analyzer: http://www.unal-bilisim.com/products/itrprof/itrprof.html itrprof SQL Analyzer is a web based tool which analyzes SQL_TRACE/Event10046 trace files of Oracle, finds bottlenecks and offersinformation on how to tune them. * iOraBugFinder: http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html iOraBugFinder is a web based tool which scans Oracle's alert log files, ORA-600 and ORA-7445 trace files; extracts relevant information from them and generates URL links to relevant bugs, notes, forums at Metalink. * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: dbms_job query?
Hi Seema, - v$session.status="KILLED" is not enough to say that session is really killed. Check v$session.server column, too. If it's something other than pseudo i.e. dedicated,shared, it means that there are activities such as network I/O or rolling back a transaction, etc. - As I remember If an snp is killed, it wakes up after a while(but, I'm not sure) - If PMON has a lot of activities, it may take time to clean all resources allocated by killed session. - PMON can not remove session object. It is removed when a killed session tries to make kernel call (gets ora-28). - If a transaction is killed, current working statement is not killed immediately. for example: - insert - select ... - update 1000-- KILL here - update 5 If you kill during updating 1000 rows, Oracle will update 1000 rows, then session will be killed before updating 5 rows. what about SELECT (???) -- Web: http://www.unal-bilisim.com * Questions and Answers: http://www.unal-bilisim.com/qa/discus/ * itrprof SQL Analyzer: http://www.unal-bilisim.com/products/itrprof/itrprof.html itrprof SQL Analyzer is a web based tool which analyzes SQL_TRACE/Event10046 trace files of Oracle, finds bottlenecks and offersinformation on how to tune them. * iOraBugFinder: http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html iOraBugFinder is a web based tool which scans Oracle's alert log files, ORA-600 and ORA-7445 trace files; extracts relevant information from them and generates URL links to relevant bugs, notes, forums at Metalink. * ARUN K C wrote: we had these situations for this we had to break the job first and then kill the snp process after some time u will see the sid out of v$session. Even if you kill the snp it will be kicked back later on from pid or spid i think i am not sure but it works Try this out it should work Well there must be some better answers from the experts out here check it out From: "Seema Singh" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: dbms_job query? Date: Fri, 01 Jun 2001 14:11:10 -0800 Hi If status=KILLED in v$session and the process is SNP oracle background process corresponding to that sid and dba_jobs_running has the same sid,no entry corresponding in dba_jobs then how to kill that process. Thx -seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ARUN K C INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Export character set
hello Libal, Yes you can. But, it doesn't always work. Visit http://www.unal-bilisim.com/qa/discus/messages/33/34.html?991400274 to see internals of Oracle character conversions. "Libal, Ivo" wrote: Hello I would like to ask you if you know about possibility to change an export file made by exp to change reported character set. I heard that it was used as a trick when database character set was needed to be changed. I would like to use it to avoid character set conversion during import to avoid loosing of special characters. Could you give me some more informations about it? Thank you in advance Ivo Libal -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Libal, Ivo INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
OT: web page counter needed
Hello, sorry for this OFF-OFF-OFF... topic question. I'm looking for a counter which counts all visited pages, not just current page visited. thanks... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: deadlock error in oracle8.1.7 on sun solaris
Hi, It's most likely that you should change your code. If you need furher help, please attach trace file. -- Web: htpp://www.unal-bilisim.com Questions and Answers: http://www.unal-bilisim.com/qa/discus/index.html Seema Singh wrote: Hi Some time I am receiving the following information in alert logs. "ORA-60: Deadlock detected." and .trc file generated.Let me know what to do to prevent such error. Thanks -seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Database slowdown after 100 days uptime
Hi, There is an alert (Note:118228.1) ALERT: Hang During Startup/Shutdown on Unix When System Uptime 248 Days. But, you are using NT. do you have other errors in alert.log before crash or is there core.log ? "Reardon, Bruce (CALBBAY)" wrote: Hi, We're running Oracle 8.1.5.1.1 on NT 4. On Saturday our database started getting much slower - to me, there didn't seem to be any major events showing up in v$session_wait, v$session_event Restarting the database instance and service solved the performance problems. Today, when reviewing logs of the queries I noticed that the database had been up for 100 days when it started slowing. The 100 days uptime may be unrelated, but has anyone seen this behaviour on any platform? For information, the server itself has been up for 242 days (240 days when the problem started occurring). Thanks, Bruce Reardon mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Error Message - Database is Already Up
Hello Vivek, Check followings: - If I'm not wrong there should be lk* file 7.3.3 and onwards. remove it. - check shared memory/semaphores by ipcs. if They still exist, remove them by ipcrm if problem still exist, you are most probably hitting a bug. - debug your process by truss/trace in OS system call level. check last lines of truss/trace output. I'm not sure last system call is flushed to file. check it. - set event="error code trace name errorstack forever, level 10" in init.ora. re-produce error. then send us trace file created under udump. regards... VIVEK_SHARMA wrote: After Installing Additionally Only the PQO Component of ORA 7.3.4.5 , When Finally Attempting to RE-Link the Oracle Exe , Following Error Message ( of sorts ) is Displayed :- Database is Already Up . Shut it Down First . Hence Re-Link of Oracle Exe Failing NOTE - 1) NO Database whatsoever is UP 2) ORACLE_SID is NOT Set to Any Value 3) NO sgadef$ORACLE_SID File Exists in $ORACLE_HOME/dbs Dir 4) NO $ORACLE_SID_struct File Exists in $ORACLE_HOME/dbs Dir -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
OT: hosting forums
Hello, do you know an organization supplies web-forums hosting. I'll launch my FQA page, but I don't want to deal with setup/backup etc. thanks... *** Unal Bilisim http://www.unal-bilisim.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
OT: my site is available
Hello list, I don't know this is the correct way. my site http://www.unal-bilisim.com is ready to launch. you can use my web based database products, post questions and answers about my products and Oracle products. regards... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: cpu utilization on solaris
Hi, As I remember, there was a bug on Sun-A1000 with CPU utilizitation. There should be an article of Erhan Odok on metalink which gives Sun's bug number. regards... Jared Still wrote: Run 'top' and see what the CPU hogs are. If they are Oracle shadow processes, check with the user that owns the session. It may belong to someone whose PC crashed or the just shut it off, and you have a disconnected session consuming resources. If you discover a shadow process is consuming 100% of a CPU, it probably needs to be killed. Just be sure to find out if it's OK to do so first. Jared On Wednesday 23 May 2001 13:56, Nihar wrote: Hi gurus I am running oracle 8.1.6 on solaris 2.7. All of a sudden my cpu utilization reached 85-90%. I am also having Sun A1000 hardware RAId attached to the box. Can any body help me out in this. i am sending my report.txt file here after running utlbstat and utlestat. thanks -Nihar Content-Type: text/plain; charset="iso-8859-1"; name="report.txt" Content-Transfer-Encoding: quoted-printable Content-Description: -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: How to interpret an errorstack
Hi, interpreting errorstack doesn't make sense. I think you should examine process state. regards... Hatzistavrou Giannis wrote: Hi all, I am trying to run a procedure and it always return a 1861 oracle error. In order to check where the problem exists I have added an event in the init.ora parameter (event="1861 trace name errorstack level 10"). The trace file was produced ok but I don't have a clue what to look for. May some one of you help me find my way through! ora_60183.zip THANKS Hatzistavrou Yannis Name: ora_60183.zip ora_60183.zipType: Zip Compressed Data (application/x-zip-compressed) Encoding: 7bit -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
sorry for attaching large files: Ynt: ORA-600 and iOraBugFinder available
Hi list, I'm really sorry for attaching large files.I dit it accidently. .. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, May 20, 2001 12:50 PM I was unsuccessfully trying to analyze (on this URL) one of the traces generated due to ORA-600 by one of TEST Database. This ORA-600 looks very funny to me. I just changed the log_archive_dest parameter to a non-existing destination and ORA-600 was there to greet me. Platform TRU64 Unix 4.0F Oracle 8.1.6.0.0 Can someone try to simulate (at your own risk). However trace file is attached and sent separately to [EMAIL PROTECTED] If anybody is interested, I can send directly. Appreciate your opinion, suggestions and ideas Regards, Rajesh -Original Message- Gazi Unal (Unal Bilisim) Sent: Saturday, May 19, 2001 7:45 PM To: Multiple recipients of list ORACLE-L Hi Gurus, I developed a new web based product named iOraBugFinder. iOraBugFinder scans Oracle's alert log files and ORA-600/ORA-7445 trace files, extracts relevant information from them and generates URL links to relevant bugs, notes, forums at Metalink. It's at http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html regards... -- Use itrprof SQL Analyzer. itrprof SQL Analyzer is a web based tool which analyzes SQL_TRACE/Event10046 trace files of Oracle, finds bottlenecks and offersinformation on how to tune them. No download, no setup, just click http://www.unal-bilisim.com/products/itrprof/itrprof.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: unal-bilisim INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: ORA-600 and iOraBugFinder available
Hi, it's a a good news... and, It's not possible to suggest a bug number. but, bugs are ordered by metalink's score. to narrow down problem, select high level search depth and read high scores first. Rajesh Dayal wrote: Sorry for the delay. Yes you are quite right on this. SHMMAX had a value of 40 M, which I changed to suggested value and things are OK now. We would be benefited more, if these various levels are explained to list. I tried once more generating report through the Tool but it doesn't suggest me about any bug no. directly. Hope this will start working soon perfectly. I am sure this tool would be of great help in crisis. Good work done ;-)) Thanks again, Regards, Rajesh -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of unal-bilisim Sent: Sunday, May 20, 2001 4:15 PM To: Multiple recipients of list ORACLE-L Subject: Ynt: ORA-600 and iOraBugFinder available Hi, iOraBugFinder at level 3 generated following bugs: for ora_3858.trc: - 700613 PL/SQL PROCEDURE FAILS WITH ORA-600 [733] [11976048] [PGA HEAP] - 801644 INSTANCE FAILS TO RESTART (WITH ORA-600 [733]) AFTER UNCLEAN SHUTDOWN for ora_3912.trc: - same bugs your "alter database open" causes these errors. Bug#801644 matches your case. This bug occurs on Digital Unix. I'm pasting relevant part of this Bug#801644: *** It looks like we are hitting this alert because the value of SHMMAX is low (like 4 MB) in your machine. I understand that SHMMAX is 4 MB by default in DEC machine, and skgmqsubareasize() returns the value of SHMMAX. As this is smaller than the size requested by kcratr() who wants SSTTRBUF amount of memory ksm asserts 733. Please try to increase your SHMMAX and see if the problem goes away. *** 01/22/99 12:39 am *** (CHG: Sta-gt;92) Yep, increasing SHMMAX sorted the problem out. Thanks. A bit strange that the low SHMMAX value is only a problem after a shutdown abort, but there you go. *** - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, May 20, 2001 12:50 PM I was unsuccessfully trying to analyze (on this URL) one of the traces generated due to ORA-600 by one of TEST Database. This ORA-600 looks very funny to me. I just changed the log_archive_dest parameter to a non-existing destination and ORA-600 was there to greet me. Platform TRU64 Unix 4.0F Oracle 8.1.6.0.0 Can someone try to simulate (at your own risk). However trace file is attached and sent separately to [EMAIL PROTECTED] If anybody is interested, I can send directly. Appreciate your opinion, suggestions and ideas Regards, Rajesh -Original Message- Gazi Unal (Unal Bilisim) Sent: Saturday, May 19, 2001 7:45 PM To: Multiple recipients of list ORACLE-L Hi Gurus, I developed a new web based product named iOraBugFinder. iOraBugFinder scans Oracle's alert log files and ORA-600/ORA-7445 trace files, extracts relevant information from them and generates URL links to relevant bugs, notes, forums at Metalink. It's at http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html regards... -- Use itrprof SQL Analyzer. itrprof SQL Analyzer is a web based tool which analyzes SQL_TRACE/Event10046 trace files of Oracle, finds bottlenecks and offersinformation on how to tune them. No download, no setup, just click http://www.unal-bilisim.com/products/itrprof/itrprof.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 officia
iOraBugFinder available
Hi Gurus, I developed a new web based product named iOraBugFinder. iOraBugFinder scans Oracle's alert log files and ORA-600/ORA-7445 trace files, extracts relevant information from them and generates URL links to relevant bugs, notes, forums at Metalink. It's at http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html regards... -- Use itrprof SQL Analyzer. itrprof SQL Analyzer is a web based tool which analyzes SQL_TRACE/Event10046 trace files of Oracle, finds bottlenecks and offersinformation on how to tune them. No download, no setup, just click http://www.unal-bilisim.com/products/itrprof/itrprof.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Ynt: File size problem.
Hi, being able to create a file 2GB in OS does not mean being able to create file 2GB in Oracle. Oracle addressing technique may not match OS addresing capabilities. There should be a note on metalink which give oracle-platform matrixes regarding 2GB problem. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, May 18, 2001 1:41 PM Hi DBAs, We are creating a oracle 7.3.4 database on a sun machine with solaris 8 installed on it.The problem is that when we try to create a file thru the oracle then it does not allow us to crewate files bigger than 2000M size.whereas when we do it thru the OS it does create bigfiles created file thru the OS: - Now when we do a mkfile -v 3000M testfile it does create a big file of the required size.But then when i try to create a datafile thru oracle then it gives an error: creating file thru the oracle: -- SVRMGR create tablespace testb datafile '/db1/dbf/test01.dbf' size 3000M; create tablespace testb datafile '/db1/dbf/test01.dbf' size 3000M * ORA-01119: error in creating database file '/db1/dbf/test01.dbf' ORA-07358: sfccf: write error, unable to write to file. SVR4 Error: 2: No such file or directory what cud be the reason behind this... are there any OS specific parameters that need to be modified or could there be some problem with the installation??? please reply ASAP thanks in advance, Jothish -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Manivannan.M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: unal-bilisim INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Ynt: enqueue waits
Hi, you can find the time spent in each enqueu by itrprof. - Original Message - From: Diego Cutrone To: Multiple recipients of list ORACLE-L Sent: Tuesday, May 15, 2001 9:50 PM Subject: enqueue waits Hi List, I'm trying to identify the possible cause of contention in a database: Oracle 7.3.4.0.0 // HP-UX 10.20 // FINANCIALS As far I can see, event "enqueue" is on top (followed by some buffer busy waits) EVENT TIME_WAITED AVERAGE_WAITenqueue 854176 3746.39 (why is the average wait so high?)buffer busy waits 292770 1.53 Enqueue Stats -- TY GETS WAITS-- - -CF 68 0CI 11178 84CU 17970 12DL 109 0DR 102 0DX 6219 0IS 72 0MR 140 0RT 1 0SQ 2472 5SS 1 0ST 3207 34TM 278918 5TS 4655 0TX 210057 57UL 3500 0US 30496 0WL 10 018 rows selected. Now, in order to get further information about this wait, I've been tracing (for some reasonable time) some sessions (session in which I detected enqueue waits). This is a "sample" of what I got : /u02/oracle/admin/FNCL/udump/ora_26851.trc:WAIT #3: nam='enqueue' ela= 0 p1=1128857606 p2=0 p3=5/u02/oracle/admin/FNCL/udump/ora_26851.trc:WAIT #3: nam='enqueue' ela= 0 p1=1128857606 p2=0 p3=5/u02/oracle/admin/FNCL/udump/ora_26851.trc:WAIT #3: nam='enqueue' ela= 0 p1=1128857606 p2=0 p3=5/u02/oracle/admin/FNCL/udump/ora_26554.trc:WAIT #38: nam='enqueue' ela= 302 p1=1415053318 p2=196736 p3=52393 From this info I got the following summary: (a) (b) (c) 1 T[ 6 p2=983149 p3=6796 ela=175 2 T[ 6 p2=196736 p3=52393 ela=300 2 T[ 6 p2=393276 p3=50281 ela=300 3 CK6 p2=0 p3=5 ela=3 8 CK 6 p2=0 p3=5 ela=1 9 T[ 6 p2=983149 p3=6796 ela=301 12CK 6 p2=0 p3=5 ela=0 19T[ 6 p2=262223 p3=53352 ela=301 75T[ 4 p2=524391 p3=50022 ela=301 75T[ 6 p2=720923 p3=5194 ela=301104T[6 p2=196736 p3=52393 ela=301305T[ 6 p2=393276 p3=50281 ela=301 where (a) is the total amount of equal entriesin thedumps (number of times it appears the same entry in the dumps),say a "sort -nr | uniq -c"... ,(b) is the LOCK TYPE (CF,CI,etc) and (c) is the LOCK MODE (ej: MODE 6=Exclusive lock). Now, my questions are: 1) I couldn't find "T[ " LOCK TYPE. What is this? am I getting it wrong?, this is the query I used select chr(bitand(p1,-16777216)/16777215)||chr(bitand(p1,16711680)/63365) "Lock",to_char(bitand(p1,65535)) "Mode"from dual; 2) What does P2 and P3 mean? Can someone send me some information about it. 3) How would you interpret this information and what can be done in order to eliminate (or at least minimize) enqueue locks in this database? Thanks.
ora-600 ora-7445 trace file needed
Hi, I need ora-600 ora-7445 trace files. if possible, can you send these files to [EMAIL PROTECTED] regards... -- Use itrprof SQL Analyzer. itrprof SQL Analyzer is a web based tool which analyzes SQL_TRACE/Event10046 trace files of Oracle, finds bottlenecks and offersinformation on how to tune them. No download, no setup, just click http://www.unal-bilisim.com/products/itrprof/itrprof.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
OT: idle and non-idle waits on Unix
Hi, do you know how to seperate non-idle waits from idle-waits in OS level. For example, we can accept cron waits as idle waits because of nothing to do until expiration; we can accept IO waits as idle because of waiting something to do. or, can you send me a direction such as links, forums about this case. thanks in advance... -- Use itrprof SQL Analyzer. itrprof SQL Analyzer is a web based tool which analyzes SQL_TRACE/Event10046 trace files of Oracle, finds bottlenecks and offersinformation on how to tune them. No download, no setup, just click http://www.unal-bilisim.com/products/itrprof/itrprof.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Installing Multiple Oracle Clients
Hi, It's not used by many people. But, If you have many clients, you can install client softwares on application server or different home on database server. do followings: - map a server in which client softwares will be installed, such as 'L:' - install client softwares to 'L:' - export Oracle registry - import registry to other clients according to my test in previous years, Oracle just creates windows programs folders on client boxes which is not defined in registry. this is not important. during connection, client software is copied to client from server. if performance is acceptable, you can use these configuration without installing to many clients. Jay Hostetter wrote: We are preparing to upgrade our Oracle client installation on our NT workstations. For the most part, we are still running the 7.3 Oracle client. We are preparing to install 8.1.6, 8.0.5, and possibly 8.0.4 versions of the Oracle client. Unfortunately, we have various 3rd party applications that are only certified with specific versions of the client - and of course they are not all the same Oracle client versions. The 8.1.6 client will be the default Oracle home, then we will install 8.0.5 and 8.0.4 on those PCs that require it. We will use .bat files for those applications that need the 8.0.4 or 8.0.5 version of the client. The .bat files will change the PATH and ORACLE_HOME, then call the application. It looks like we are going to have to visit each PC to do a local install of the appropriate Oracle client(s). I am looking for input in two areas: 1) What is the easiest way to do these local installations? With the old 16-bit version of the Oracle client, you could do a network install, then have the workstations reference that installation by changing ini files. I don't think that the 32-bit version of the client supports network installs. Has anybody had success with response files? What is the trick to getting them to work? Anyway, I'm looking for an alternative to visiting each workstation. 2) Is there an alternative to using .bat files for referencing a different Oracle client? Do many folks take the risk of using a newer version of the Oracle client for an application, even though that application is not certified with that version of the Oracle client? Thanks for the input. Jay Hostetter Oracle DBA D. E. Communications Ephrata, PA USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Use itrprof SQL Analyzer. itrprof SQL Analyzer is a web based tool which analyzes SQL_TRACE/Event10046 trace files of Oracle, finds bottlenecks and offersinformation on how to tune them. No download, no setup, just click http://www.unal-bilisim.com/products/itrprof/itrprof.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Oracle9i block structures
Thank you, Yes, you are rihght. it was broad question. I meant all block structures. and I mean, not only data in block structures, but also data offsets in block structures. [EMAIL PROTECTED] wrote: Unal, What part of the block sturcture? Segment Header, Datablock Header? There are things in the blocks that are no different than they where in 6,7,8 or 8i. However with some of the new features such bitmap freelists, low highwater mark, high high waterwater, and changes to pctfree. There are some modifications to the block header and the segment header. They way rows are stored in the block pretty much remain the same. This is pretty much what I have learned to this point. Scott Hi, Do you know if Oracle9i block structures are modified ? thanks in advance... -- Use itrprof SQL Analyzer. It formats SQL_TRACE/Event10046 traces and gives tuning advises. It's web based, no download, no configuration. Just click http://www.unal-bilisim.com/products/itrprof/itrprof_index.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Use itrprof SQL Analyzer. It formats SQL_TRACE/Event10046 traces and gives tuning advises. It's web based, no download, no configuration. Just click http://www.unal-bilisim.com/products/itrprof/itrprof_index.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: SQL Tuning question?
Hello, I think, there are 3 factors in performance tuning: - Time - Amount - Speed Most imporatnt factor in performance tuning is the time. Of course others are important, too. But, others are indirect indicator. For example: - 1 block 1000 ms - 1000 block 1 ms As we see above, second one takes less time although it gest more blocks. we can't say that problem is in second one(if there is a problem in one of them). And, speed is indirect indicator, too. nobody asks the speed of cars in formula races, but asks time spent in races. I think, time is the most important factor. itrprof is based on time. you can run itrprof to see bottlenecks. it's at http://www.unal-bilisim.com/products/itrprof/itrprof.html regards... Seema Singh wrote: Hi Gurus When I run one complex query I get the following statistics. Statistics -- 832 recursive calls 4 db block gets 98502 consistent gets 0 physical reads 0 redo size 995 bytes sent via SQL*Net to client 4306 bytes received via SQL*Net from client 1 SQL*Net roundtrips to/from client 427 sorts (memory) 0 sorts (disk) 0 rows processed Is this statistics good for executed sql statment?After looking the above statistics what we can say? Thanks -SEEMA _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Use itrprof SQL Analyzer. It formats SQL_TRACE/Event10046 traces and gives tuning advises. It's web based, no download, no configuration. Just click http://www.unal-bilisim.com/products/itrprof/itrprof_index.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Oracle9i block structures
Hi, Do you know if Oracle9i block structures are modified ? thanks in advance... -- Use itrprof SQL Analyzer. It formats SQL_TRACE/Event10046 traces and gives tuning advises. It's web based, no download, no configuration. Just click http://www.unal-bilisim.com/products/itrprof/itrprof_index.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: import from corrupted export file.
Hi, first of all, be sure that export file is not copied in ASCII mode. if so, You can do: - take a look at import log. find where it's cancelled - I guess internal data structers in export file is not so big. It's so likely that corruption occured on your data. modify binary export file by an binary editor. there may be a note in metalink which explains some structures in expor files. hope this helps... Mohit Goyal wrote: hi all, how to take an import from a corrupted export file. the error message is abnormal end of expoort file. Thanks, Mohit -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohit Goyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Use itrprof SQL Analyzer. It formats SQL_TRACE/Event10046 traces and gives tuning advises. It's web based, no download, no configuration. Just click http://www.unal-bilisim.com/products/itrprof/itrprof_index.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: TAR 1354616.996 (trace generated during database startup)
Hi, please attach trace, and results of: - debug process by oradebug of oracle, - trace process in OS level by conterpart of truss in unix, - attache core.log if generated Sonja ehovi wrote: Hi all! Oracle 8.1.7. EE on WinNT. Oracle trace is generated during the database startup (something like warning). There are no errors that should cause that problem. We had that problem since database creation (cca 1 month). It's been few weeks since we loged an iTAR ane still no responce. Any opinions (experinces) with such problem? TIA, Sonja -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-2?Q?Sonja_=A9ehovi=E6?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Use itrprof SQL Analyzer. It formats SQL_TRACE/Event10046 traces and gives tuning advises. It's web based, no download, no configuration. Just click http://www.unal-bilisim.com/products/itrprof/itrprof_index.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
OFF-TOPIC: comp.databases.oracle.server
Hi, As I understand, deja had been acquired by a company. How to read/post messages to new usenet including web based or Netscape Messenger ? I could not read by Netscape Messenger. thanks... -- Use itrprof SQL Analyzer. It formats SQL_TRACE/Event10046 traces and gives tuning advises. It's web based, no download, no configuration. Just click http://www.unal-bilisim.com/products/itrprof/itrprof_index.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: ORA-07445
Hi, ora-7445 error are not always OS errors. If Oracle can not catch exceptions(ORA-600), OS catch and Oracle throws ORA-7445. If possible, attach trace file. let's examine it. regards... Sajid Iqbal wrote: Hello All This message is appearing in the alert log periodically.. anyone know hat it means and how I can get rid of it ORA-07445: exception encountered: core dump [kkects()+64] [SIGSEGV] [Address not mapped to object] [8] [] [] Thanks -- Sajid Iqbal Database Team Leader -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sajid Iqbal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Use itrprof SQL Analyzer. It formats SQL_TRACE/Event10046 traces and gives tuning advises. It's web based, no download, no configuration. Just click http://www.unal-bilisim.com/products/itrprof/itrprof_index.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
a minor clarification: SQL tuning is not a problem anymore ?
Hi, I would like to add a minor clarification. I saw some non SQL/event10046 trace files are uploaded. let's note that it's not possible to analyze SQLs if they are not traced by SQL_TRACE/Event10046. for report.txt, you can use Anjo's page at www.oraperf.com regards... unal-bilisim wrote: - Original Message - From: Danisment Gazi Unal (Unal Bilisim) To: Multiple recipients of list ORACLE-LSent: Saturday, April 28, 2001 12:16 AMSubject: SQL tuning is not a problem anymore ? Hi gurus, I developed a web based tool which formats SQL and Event10046 traces. This tool is superior to tkprof but It works on WEB and formats Binds variables and Waits for SQLs in trace files. and gives tuning advises and costs of SQLs. You can compare these costs with other SQLs (unlike in Oracle). so, you can easly see improvements in your SQLs after re-writing it. You can not only see waits, but also sub-waits. For example, you can see: - time waited on specific Enqueue suchs as (TX), etc. - time waited on specific latch such as "latch wait list", etc. - time waited on specific file - time waited on specific block Product is at http://www.unal-bilisim.com/products/itrprof/itrprof_index.html And, I would like to thank to my dear friends Gopal, Young and people in Turkey for their interests about itrprof. Thank you friends... you can ask your any questions and send recomendations... hope You enjoy
Re: monitoring listener.log
Hi again, Note that listener is only used while creating shadow processes on server side. Once shadow processes are created by listener, listener is never used. in other words, listener process is not a bridge between user process and server process during data transmissions. So, scanning listener.log only is not a good way to catch sql*net errors. to catch sql*net errors after connections are established, set sql*net server trace. then scan them. But, it's not be efficient. there will be a lot of trace files. rgrds... "Danisment Gazi Unal (Unal Bilisim)" wrote: Hi, Typical errors in sql*net traces are like this: nserror: nsres: id=0, op=67, ns=12571, ns2=12560; nt[0]=533, nt[1]=57, nt[2]=0 Means: You get protocol error 57. If you are using TCP/IP, check winsock errors, if I'm not wrong it should be 20057 or 10057. This error causes sql*net 533 error. 533,12560 and 12571 are result. Saurabh Sharma wrote: hey can u elaborate how do u scan each log file, and convert it in email msg.how do u do this.. saurabh sharmadba - Original Message - From:NGUYEN Philippe (Cetelem) To: Multiple recipients of list ORACLE-L Sent: Wednesday, April 25, 2001 9:10 PM Subject: monitoring listener.log Hi list, We have a script wich monitor the alert.log for each database. This script scan the alert.log file and send an email if an ORA-xxx error occured Now, we want to write a script monitoring the listener.log file : wich kind of message or variable indicate a network problem (ORA-xxx, ...) ? ...then we 'll have the same question for the log file made by OEM ! TIA
Re: monitoring listener.log
Hi, Typical errors in sql*net traces are like this: nserror: nsres: id=0, op=67, ns=12571, ns2=12560; nt[0]=533, nt[1]=57, nt[2]=0 Means: You get protocol error 57. If you are using TCP/IP, check winsock errors, if I'm not wrong it should be 20057 or 10057. This error causes sql*net 533 error. 533,12560 and 12571 are result. Saurabh Sharma wrote: hey can u elaborate how do u scan each log file, and convert it in email msg.how do u do this..saurabh sharmadba - Original Message - From: NGUYEN Philippe (Cetelem) To: Multiple recipients of list ORACLE-L Sent: Wednesday, April 25, 2001 9:10 PM Subject: monitoring listener.log Hi list, We have a script wich monitor the alert.log for each database. This script scan the alert.log file and send an email if an ORA-xxx error occured Now, we want to write a script monitoring the listener.log file : wich kind of message or variable indicate a network problem (ORA-xxx, ...) ? ...then we 'll have the same question for the log file made by OEM ! TIA
Re: oraCore.log
Hi, I'm not sure if the name is oraCore.log. But, core log is generated if an exeception is occured. It includes stack traces, registers etc. You can understand where error is occured by register values, especially CodeSegment/InstructionPointer registers. Saurabh Sharma wrote: hi everyone,can anyone help me in understanding the contents iof the above file...i.e. oraCore.log in orahome\rdbms##\trace\what does this file contains and when it is created, which process controls it.thanks in advance.saurabh sharma
SQL tuning is not a problem anymore ?
Hi gurus, I developed a web based tool which formats SQL and Event10046 traces. This tool is superior to tkprof but It works on WEB and formats Binds variables and Waits for SQLs in trace files. and gives tuning advises and costs of SQLs. You can compare these costs with other SQLs (unlike in Oracle). so, you can easly see improvements in your SQLs after re-writing it. You can not only see waits, but also sub-waits. For example, you can see: - time waited on specific Enqueue suchs as (TX), etc. - time waited on specific latch such as "latch wait list", etc. - time waited on specific file - time waited on specific block Product is at http://www.unal-bilisim.com/products/itrprof/itrprof_index.html . And, I would like to thank to my dear friends Gopal, Young and people in Turkey for their interests about itrprof. Thank you friends... you can ask your any questions and send recomendations... hope You enjoy
Re: Physical Data Layout
Hi, I think, "don't use RAID for..." is not a good approach. If there is no IO related wait event or there is no huge CPU cycles for software raids, it's not a problem to use RAID or not to use. There is an excellent paper of Carry Millsap who is a philosopher of Oracle+ComputerSciences. You can download it at www.hotsos.com Stefan Jahnke wrote: Hi, I'm also looking for RAID / SAN / NAS technology used with databases. Do you know any recommended readings ? Saumya99 schrieb: Hi Chris, The concern is the putting datafile on RAID system. Oracle documentation recommends not to put datafiles on RAID because reading from a RAID device is slower whereas writing is a faster process. Particularly when you are thinking of Performance benefit, you can give a consideration here. -Saumyajit - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Wednesday, April 25, 2001 1:22 AM Hello all, We are moving our production database onto new disks to improve performance. It is a high transction OLTP environment using Oracle8i on a SPARC Solaris box. We are divided about which parts of Oracle to put where for the best performance. We have come up with two basic designs. A-C are SCSI controllers, 0-18 are 36GB hard disks. B C each are connected to hardware RAID controllers. A has two disks mirrored through software. SETUP I: A0: Solaris Oracle Software A1: A0 soft mirror B[RAID 0+1]2-9: DATA, SYSTEM, REDO logs C[RAID 0+1]10-17: INDEX, TEMP, Archived REDO logs, TOOLS, ROLLBACK (extra disks used in other systems) SETUP II: A0: Solaris Oracle Software A1: A0 soft mirror B[RAID 0+1]2-7: DATA B[RAID 1]8-9: REDO logs, SYSTEM C[RAID 0+1]10-15: INDEX, TEMP, Archived REDO Logs, TOOLS C[RAID 1]16-17: ROLLBACK Or is there an even better way to arrange the data? Thanks, Chris -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Chris Rezek INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Saumya99 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: ORA-12500
Hi, ora-12500 is not a good error to diagnose. is there any error in alert.log ? Rajesh Dayal wrote: Hi All, I have seen the error-manual for above Error message, but it really doesn't state anything clearly. Env is Oracle 8.0.5 on NT 4.0. This problem is not persistent and it comes intermittently. And it has come when I try to shutdown a Production through an automated script before backup (of course automated). Due to this, the backup doesn't happen and also Media recovery is required further to open the database. I have checked the env. variables, they look OK to me(most of the times it work). The similar script works fine with Demo Database. Any experience on this issue? Please suggest some solution. TIA, Rajesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: AW: db link hangs
I don'k like comment without trace files. But, I know a bug. Workaround is: - don't use tns alias in dblink definition. Create dblink with "(DESCRIPTION = ...". Haunschmidt Andreas VASL/FAS wrote: Hi! We have the same problem using database links between two 8.1.6 instances on NT. The frequency it happens ( from 2-3 times a day to weekly ) seems to depend on the amount of data affected on the remote site. As we use DBMS_JOB for regularly starting our tasks we encounter no max processes overflow, but the bad thing is, that the local session keeps waiting forever for a response from the remote partner session, thereby preventing the next scheduled job to start. This was quite embarrassing, because we're using the dblink to load a huge amount of data into a data warehouse, and the hangs occurred mostly during the weekends, when nobody was in. Our DBAs contacted Oracle, who told us, they could neither reproduce this strange behaviour, nor provide a solution. Our quick and dirty approach uses a "watchdog" ( a shell script using SQL*PLUS and PL/SQL ) started periodically by the cron scheduler on a Linux machine. ( Sure, you on MS platforms you could use the AT command. Even a special Oracle job could be used for this, but we wanted to avoid the risk of getting the "watchdog" procedures/packages invalid / paralyzing our little guard. The Linux machine has got an uninterruptible power supply too and LINUX HYPE keeps running and running and running stable /LINUX HYPE ) Using v$session ,v$sesstat and v$statname we collect and compare each job's individual execution count statistics. If a statistic value remains unchanged ( indicating a "hang" in our case) over a certain period ( loop with delay using DBMS_LOCK.sleep) , we use the hanging job's SID and SERIAL# to execute an ALTER SYSTEM KILL SESSION. To ensure that no other (e.g.: interactive idle ) session will be killed, we tagged the jobs with a special string ( e.g. '@@@watchdog@@@' ) using the Oracle supplied package DBMS_APPLICATION_INFO procedures to get and set the tags for those "watched" sessions. So eventually after a timeout period, the hanging jobs get killed, thereby enabling the next scheduled job to be started. In case someone is interested in getting the script, just reply and I'll post it. HTH Andreas -- Von: [EMAIL PROTECTED][SMTP:[EMAIL PROTECTED]] Gesendet: Mittwoch, 18. April 2001 14:45 An: Multiple recipients of list ORACLE-L Betreff: db link hangs AIX 4.3 RDBMS 8.1.6.x We have a problem using a db link. The listener-side server port (1521) is hanging. This happens about once a week - and ends up crashing the far database because queries through the link just hang and don't return - then we die with a max processes error. Has anyone else had any problems with this? How did you solve it? Can I (should I) get the Oracle listener to listen on more than one port? What are some other ways to solve the problem? PS: I can connect and query the table when logged in locally. Other connections (not using 1521) work to the server. netstat (and telnet to 1521) shows only connections thru 1521 are a problem. thanks, ..tom -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Haunschmidt Andreas VASL/FAS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists -
