Viraj,
Do please read the manual on Outer Join theory.
Also be consistent with your Column Alias usage.
Martin
-Original Message-
Luthra
Sent: 29 November 2001 06:35
To: Multiple recipients of list ORACLE-L
not being found
Okay I am answering my own problem, but for the :-
1st
Viraj,
I actually wrote this query yesterday for a collection for our tool:
select s.sid SID,
s.serial# SERIAL,
s.username USERNAME,
a.address ADDRESS,
a.buffer_gets BUFFER_GETS,
a.executions EXECUTIONS,
t.piece PIECE,
t.sql_text
Hello all,
I am running the following query :-
SELECT a.username, sql_text, executions ,
a.user_id,machine,terminal,program,
a.username,osuser, sid, process,
ROUND(((disk_reads * 100) / DECODE(executions, 0, 1,
executions)))
FROM
Okay I am answering my own problem, but for the :-
1st Query, I modified the query to :-
SELECT r.username, b.sql_text, executions , serial#
r.user_id,machine,terminal,program,a.username,osuser, sid,
process,ROUND(((disk_reads * 100) / DECODE(executions, 0, 1,