Re: v$sqlarea v$session

2003-03-12 Thread Tim Gorman
v$session.sql_hash_value = v$sqlarea.hash_value or v$session.sql_address = v$sqlarea.address - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, March 12, 2003 10:18 AM I'm suffering from a senior moment. The question is at the every

Re: v$sqlarea v$session

2003-03-12 Thread Denny Koovakattu
Join sql_address from v$session to address from v$sqlarea . Regards, Denny Quoting [EMAIL PROTECTED]: I'm suffering from a senior moment. The question is at the every bottom. SQL select sql_text from v$sqlarea sa where buffer_gets 1 SQL_TEXT

RE: v$sqlarea v$session

2003-03-12 Thread Jesse, Rich
Perhaps this is what you're looking for? select sql_text ,sid, username, osuser, logon_time from v$sqlarea sa, v$session ss where sa.buffer_gets 1-- that's a lot of gets! and sa.hash_value = ss.sql_hash_value; HTH! GL! :) Rich Rich Jesse

Re: v$sqlarea v$session

2003-03-12 Thread Andy Rivenes
How about: SELECT a.sid, a.username, c.disk_reads, c.buffer_gets, c.sorts, c.executions, c.rows_processed, c.sql_text FROM v$session a, v$sqlarea c WHERE a.sid = sessid AND a.sql_address = c.address -- AND a.SQL_HASH_VALUE =

Re: v$sqlarea v$session

2003-03-12 Thread AK
charlie I think sqlarea and session has no direct relationship . Same sql can belong to many sessions and columns like users_opening, users_executing suggests this. There should be one entry in sqlarea per hashaddress I guess . may user v$open_cursors to join with addess and sid . -ak -

RE: v$sqlarea v$session

2003-03-12 Thread Charlie_Mengler
: Subject: RE: v$sqlarea v$session 03/12/2003 11:06 AM

Re: v$sqlarea v$session

2003-03-12 Thread Stephane Faroult
[EMAIL PROTECTED] wrote: I'm suffering from a senior moment. The question is at the every bottom. SQL select sql_text from v$sqlarea sa where buffer_gets 1 SQL_TEXT SELECT RP.RELPART FROM

Re: v$sqlarea v$session

2003-03-12 Thread arivenes
How about: SELECT a.sid, a.username, c.disk_reads, c.buffer_gets, c.sorts, c.executions, c.rows_processed, c.sql_text FROM v$session a, v$sqlarea c WHERE a.sid = sessid AND a.sql_address = c.address -- AND a.SQL_HASH_VALUE

Re: v$sqlarea v$session

2003-03-12 Thread groups
Join sql_address from v$session to address from v$sqlarea . Regards, Denny Quoting [EMAIL PROTECTED]: I'm suffering from a senior moment. The question is at the every bottom. SQL select sql_text from v$sqlarea sa where buffer_gets 1 SQL_TEXT

Re: v$sqlarea v$session

2003-03-12 Thread Charlie_Mengler
: Sent by: Subject: Re: v$sqlarea v$session [EMAIL PROTECTED

Re: v$sqlarea v$session

2003-03-12 Thread Jonathan Lewis
Just as a passing note - when you query v$sqlarea like this it thrashes the heck out of the library cache latch. (And v$sqlarea is also an aggregate view of x$kglob - so for a large shared pool you could end up with a massive sort and thrash of the temporary tablespace as the view is