Re: RAC, gv$ views, and the AWR
- From: Nigel Thomas <nigel_cl_thomas@xxxxxxxxx>
- To: ryan_gaffuri@xxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Sun, 11 Nov 2007 03:44:14 -0800 (PST)
Ryan, see inline
Regards Nigel
----- Original Message ----
From: "ryan_gaffuri@xxxxxxxxxxx" <ryan_gaffuri@xxxxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
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
**********************
1.
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?
Other related posts:
