Re: Cary's query, on oracle 9.2

  • From: Thomas Day <tday6@xxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 25 Feb 2004 08:25:30 -0500

On Win NT:

SQL> show release
release 902000100
SQL> select count(*) from v$event_name;

  COUNT(*)
----------
       361

Wonder which 2 I'm missing.

On AIX Regatta:

SQL>  show release
release 902000300
SQL> select count(*) from v$event_name;

  COUNT(*)
----------
       399

On Win 2K:

SQL>  show release
release 902000300
SQL>  select count(*) from v$event_name;

  COUNT(*)
----------
       397

Seems as if windows versions don't have two events.

timer in sksawat
scginq AST call




                                                                                
                                                       
                      "Arghadeep                                                
                                                       
                      Chatterjee" <dba         To:      
<oracle-l@xxxxxxxxxxxxx>                                                       
                      @magma.co.in>            cc:                              
                                                       
                      Sent by:                 Subject: Re: Cary's query, on 
oracle 9.2                                                
                      oracle-l-bounce                                           
                                                       
                                                                                
                                                       
                                                                                
                                                       
                      02/25/2004 01:31                                          
                                                       
                      AM                                                        
                                                       
                      Please respond                                            
                                                       
                      to oracle-l                                               
                                                       
                                                                                
                                                       
                                                                                
                                                       




Jaffar,
Thanks man I am.
Deep
----- Original Message -----
From: Syed Jaffar Hussain <sjaffarhussain@xxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Sent: Wednesday, February 25, 2004 11:40 AM
Subject: Re: Cary's query, on oracle 9.2


> Deep,
>
> I think you are using release 902000100
> not release 902000400
>
> this is could be difference
> ----- Original Message -----
> From: "Arghadeep Chatterjee" <dba@xxxxxxxxxxx>
> To: <oracle-l@xxxxxxxxxxxxx>
> Sent: Wednesday, February 25, 2004 9:04 AM
> Subject: Re: Cary's query, on oracle 9.2
>
>
> > I am running HP-UX 11.11 with Oracle 9.2 I checked the V$event_name I
> found
> > only 363 of them.Why am I missing so any of them .The Reported fig
seems
> to
> > be 404.
> > Deep
> > ----- Original Message -----
> > From: Kirtikumar Deshpande <kirtikumar_deshpande@xxxxxxxxx>
> > To: <oracle-l@xxxxxxxxxxxxx>
> > Sent: Wednesday, February 25, 2004 1:18 AM
> > Subject: RE: Cary's query, on oracle 9.2
> >
> >
> > > Pete, do you have a very heavy door!!! ;)
> > >
> > > - Kirti
> > >
> > > --- Pete Sharman <peter.sharman@xxxxxxxxxx> wrote:
> > > > I must say I'm VERY disappointed that Kirti isn't documenting each
and
> > every one of those 808
> > > > events in his book!  :)
> > > >
> > > > Pete
> > > >
> > > > "Controlling developers is like herding cats."
> > > >
> > > > Kevin Loney, Oracle DBA Handbook
> > > >
> > > > "Oh no, it's not.  It's much harder than that!"
> > > >
> > > > Bruce Pihlamae, long-term Oracle DBA
> > > >
> > > >
> > > > -----Original Message-----
> > > > From: oracle-l-bounce@xxxxxxxxxxxxx
> > [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Mladen
> > > > Gogala
> > > > Sent: Wednesday, February 25, 2004 6:32 AM
> > > > To: Multiple recipients of list ORACLE-L
> > > > Subject: Cary's query, on oracle 9.2
> > > >
> > > > Just for fun, I counted the events in 9.2. Here's the result:
> > > >
> > > > SQL> show release
> > > > release 902000400
> > > > SQL>  select count(*) from v$event_name;
> > > >
> > > >   COUNT(*)
> > > > ----------
> > > >        401
> > > >
> > > > SQL>
> > > >
> > > > In 10g, there are 808 different events. Wow, more then double! It's
> > going to be interesting.
> > > > ----------------------------------------------------------------
> > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > > ----------------------------------------------------------------
> > > > To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
> > > > put 'unsubscribe' in the subject line.
> > > > --
> > > > Archives are at //www.freelists.org/archives/oracle-l/
> > > > FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
> > > > -----------------------------------------------------------------
> > > >
> > > > ----------------------------------------------------------------
> > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > > ----------------------------------------------------------------
> > > > To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
> > > > put 'unsubscribe' in the subject line.
> > > > --
> > > > Archives are at //www.freelists.org/archives/oracle-l/
> > > > FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
> > > > -----------------------------------------------------------------
> > >
> > >
> > > __________________________________
> > > Do you Yahoo!?
> > > Yahoo! Mail SpamGuard - Read only the mail you want.
> > > http://antispam.yahoo.com/tools
> > > ----------------------------------------------------------------
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > ----------------------------------------------------------------
> > > To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
> > > put 'unsubscribe' in the subject line.
> > > --
> > > Archives are at //www.freelists.org/archives/oracle-l/
> > > FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
> > > -----------------------------------------------------------------
> >
> > ----------------------------------------------------------------
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > ----------------------------------------------------------------
> > To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
> > put 'unsubscribe' in the subject line.
> > --
> > Archives are at //www.freelists.org/archives/oracle-l/
> > FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
> > -----------------------------------------------------------------
> >
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------




----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: