RAC, gv$ views, and the AWR

From: <ryan_gaffuri_at_comcast.net>
Date: Sun, 11 Nov 2007 02:16:55 +0000
Message-Id: <111120070216.15039.47366617000CC36600003ABF2213539653079D9A00000E09A1020E979D@comcast.net>

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

---

---

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,

---

---

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.  

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

Received on Sat Nov 10 2007 - 20:16:55 CST