RE: Trace output

Title: RE: Trace output Satheesh, "Row source operation" is the run time execution plan. The "execution plan" is added when you run tkprof and you use parameter "explain=user/password    Connect to ORACLE and issue EXPLAIN PLAN" and this is "theoretical plan". In version 9.2 those two plans

RE: HOTSOS Conference

Title: RE: HOTSOS Conference I will be there as well primarily listening and also speaking. It is a great idea for a list dinner. Joze -Original Message- From: Jared Still [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 06, 2004 2:59 AM To: Multiple recipients of list ORACLE-L Su

RE: STATSPACK interpretation

Title: STATSPACK interpretation Using dbms_application_info package also causes that there are several versions of same statement - but they share same execution plan. You can check if this is the case by querying  v$sqlarea (module and action columns).   Regards,   Joze -Original Mes

RE: for security patches - going to 9.2.0.4

Title: RE: for security patches - going to 9.2.0.4 Paula, I had also bad experience when we upgraded one of our applications from 8.1.7 to 9.2.0.1 There were some queries that executed significantly slower then on 8.1.7. What we have done was: 1. We gathered system statistics with dbms_sys

RE: Finding SID of current session

Title: RE: Finding SID of current session You can use also this approach: select * from v$session_event where sid = (select sid from v$session where audsid = userenv('SESSIONID')) Regards, Joze -Original Message- From: George Leonard [mailto:[EMAIL PROTECTED]] Sent: Tuesday, Dece

RE: ** find whether table or index being accessed

Daniel,   it will work but indexes are present in buffer cache also because of updates. The only possibility is to store each index in question in separate tablespace and monitor the i/o. If number of reads will be equal or little bit greater than the number of writes than this is a candidat

RE: LF and CR (chr(10)||chr(13)) problem

n (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joze Senegacnik   INET: [EMAIL PROTECTED] Fat City Network Services    -- 858-538-5051 http://www.fatcity.com San Diego, California    -- Ma

RE: LF and CR (chr(10)||chr(13)) problem

list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joze Senegacnik INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com S