Re: RAC, gv$ views, and the AWR

instead of:

4 and b.sid = '<myuser>';

you probably mean:

4 and b.username = '<myuser>';

On Nov 11, 2007 3:16 AM, <ryan_gaffuri_at_comcast.net> 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.
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

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