Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: RAC, gv$ views, and the AWR

Re: RAC, gv$ views, and the AWR

From: goran bogdanovic <goran00_at_gmail.com>
Date: Sun, 11 Nov 2007 14:03:01 +0100
Message-ID: <6d0a3ba80711110503y4626db5ar841ef452e16255a1@mail.gmail.com>


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
Received on Sun Nov 11 2007 - 07:03:01 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US