Re: RAC, gv$ views, and the AWR
- From: "goran bogdanovic" <goran00@xxxxxxxxx>
- To: ryan_gaffuri@xxxxxxxxxxx
- Date: Sun, 11 Nov 2007 14:03:01 +0100
instead of:
4 and b.sid = '<myuser>';
you probably mean:
4 and b.username = '<myuser>';
On Nov 11, 2007 3:16 AM, <ryan_gaffuri@xxxxxxxxxxx> wrote:
> 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.
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
Other related posts:
