Re: RAC, gv$ views, and the AWR

From: Nigel Thomas <nigel_cl_thomas_at_yahoo.com>
Date: Sun, 11 Nov 2007 03:44:14 -0800 (PST)
Message-ID: <629878.55053.qm@web58809.mail.re1.yahoo.com>

Ryan, see inline

Regards Nigel

Original Message ---- From: "ryan_gaffuri_at_comcast.net" <ryan_gaffuri_at_comcast.net> To: oracle-l_at_freelists.org Sent: Sunday, November 11, 2007 2:16:55 AM Subject: RAC, gv$ views, and the AWR

10.2.0.1
Redhat 5.0 OS

I have 3 questions in this one

why would I get an error on a data dictionary query?

SQL> select a.*
2 from gv$session_wait a, gv$session b 3 where a.sid = b.sid
4 and b.sid = '<myuser>';
select a.*
*
ERROR at line 1:
ORA-12801: error signaled in parallel query server PZ99, instance racdb01)
ORA-01722: invalid number

==>

The query looks wrong. If you are passing a string in, it is implicitly getting converted to_number (and if it really is the username, will fail...) Why join to gv$session if you are using a.sid=b.sid and b.sid = 'constant'? Looks like you should have said and b.username = '<myuser>'

2.
I run both awrrpt and awrrpti
and i get the following error. I checked to make sure I put in the correct dbid?

Using the report name ryan.txt
select output from table(dbms_workload_repository.awr_report_text( :dbid,

==> sorry, what's the question?

3.
I make an SSH connect to db01 and log into the database Someone else is logged into another server that only has an Oracle client. He logs into the database using tnsnames.

I run the following query:
select username,count(*)
from gv$session
group by username;

I do not see the user he is logged in as in this query at all. I do not see anyone with that username.

==> are you sure he has commected to the correct database/instance? and to the username you expected?

--
http://www.freelists.org/webpage/oracle-l

Received on Sun Nov 11 2007 - 05:44:14 CST