| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: SQL*Plus blowing up on query on V$AQ...
I had never heard of that bug, but I checked it out on MetaLink and took it for a spin myself:
SQL*Plus: Release 8.1.7.0.0 - Production on Thu Aug 1 21:26:16 2002
(c) Copyright 2000 Oracle Corporation. All rights reserved.
Connected to:
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
SQL> select * from v$aq;
ERROR:
ORA-00604: error occurred at recursive SQL level 1 ORA-01001: invalid cursor ORA-00604: error occurred at recursive SQL level 1 ORA-01001: invalid cursor
no rows selected
Confirms what you're saying, along with what is documented in bugs #2092731 and #2131687. But, then what about this here?
Oracle Server Manager Release 3.1.7.0.0 - Production
Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
SVRMGR> connect internal
Connected.
SVRMGR> select * from v$aq;
QID WAITING READY EXPIRED TOTAL_WAIT AVERAGE_WA
SVRMGR>
So, it is happening in Server Mangler as well. Let's just say that Server Manager gets a little further along than SQL*Plus, for what that's worth. Still, it would seem that it's not a problem particular to SQL*Plus, but rather a problem either in OCI or the RDBMS. Sure, it could be a problem in both SQL*Plus and SVRMGR only, but since these products were developed separately, I'm guessing not. If I had a "C" compiler, I'd compile up the OCI demo program "cdemo2" and see if it blows up also. My money is that it is AQ itself, which uses OO features within the RDBMS. I did a SQL Trace level 12 on the statement and there is an awful lot of recursive object-oriented stuff going on behind the scenes when you do a simple query of V$AQ...
...in summary, I'm not surprised that it blows up -- I'm more surprised that it ever works at all... :-)
Thanks April! That was cool...
> <Snip>
> The functionality for Server Manager command-line was migrated in it's
> entirety into SQL*Plus (near as I can tell, including ORADEBUG), so Oracle
> eliminated svrmgrl not so much as a way of deprecating command-line
> utilities in general, but rather to consolidate redundant products...
> </snip>
>
> Except you still can't select from V$AQ in sqlplus even in 9i... just a
> teeny little thing... but (per a dozen hits on metalink) it only works in
> server manager...
>
> ajw
>
>
> -----Original Message-----
> Sent: Tuesday, July 30, 2002 12:45 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Tim:
>
> I take exception to the age thing here. Yes, I remember rewriting the MVS
> procs for Oracle's MVS implementation because they never checked to see if
> MPM was running in the background task manager of SDSF. Add to it that I
> wrote (helped Oracle) a complete TSO Dialog Manager interface to all of the
> Oracle tools that ran on the mainframe.
>
> GUI tools hide the "work" involved in solving the problem Go Command
> Line!!!
>
> Thank You
>
> Stephen P. Karniotis
> Product Architect
> Compuware Corporation
> Direct: (248) 865-4350
> Mobile: (248) 408-2918
> Email: Stephen.Karniotis_at_Compuware.com
> Web: www.compuware.com
>
> -----Original Message-----
> Sent: Tuesday, July 30, 2002 12:38 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Guys: Is this worth $1,749 for 8 year Oracle veteran
> DBA
>
> GUI tools are simply a front-end presentation layer for SQL commands. GUI
> tools do not "bypass" the SQL command-line layer; they only abstract it.
> Command-line tools (such as SQL*Plus) use the same API as the GUI tools, but
> simply do a lot less abstraction on the presentation. Command-line tools
> will never "go the way of the dodo", because they are part of the diagnostic
> process for GUI tools, if nothing else. Also, since the days of ISPF and
> JCL (anybody recognize those), on platforms from OS/360 through Windows, it
> has proven impossible to wean users away from command-line, especially for
> "batch" processing...
>
> The functionality for Server Manager command-line was migrated in it's
> entirety into SQL*Plus (near as I can tell, including ORADEBUG), so Oracle
> eliminated svrmgrl not so much as a way of deprecating command-line
> utilities in general, but rather to consolidate redundant products...
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Tuesday, July 30, 2002 9:20 AM
>
>
> Yes, i seem to recall whilst on the crashes, dumps and corruptions seminar
> that it was mentioned that Oracle are moving away from command line tools in
> favour of GUI tools in much the same way that server manager is no longer
> available - does anyone know if this is truly the case? Will command line
> tools go the way of the dodo? I do 99% of my work (be it serious or not)
> from the command line and would truly miss the choice if it were taken away.
>
> Lewis Bishop
> ---
> Barclays Enable/ISS/OPTS - Oracle OCP Database Consultant
> Phone - 020 8298 3418
> Mobile - 07950 380857
> Email - lewis.bishop_at_woolwich.co.uk
>
>
> -----Original Message-----
> Sent: 30 July 2002 15:28
> To: Multiple recipients of list ORACLE-L
>
> This header confirms that this email message has been swept for the
> presence of computer viruses.
>
> Corporate IT
> THE WOOLWICH
> ----------------------------------------------------------------------
>
> Oracle's politic is to make us using GUI tools. This is reflected in OCP
> exams, so I can conclude that for newbies exams become easier while hardcore
> DBAs might never use GUI tools.
>
> Alexandre
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Tuesday, July 30, 2002 3:03 PM
>
>
> > When people pass exams they tend to say the exam was "easy".
> >
> > When they fail the exam they tend to say either "I didn't study enough" or
> > "It was hard, that one!"
> >
> > Regards,
> > Patrice Boivin
> > Systems Analyst (Oracle Certified DBA)
> >
> > Systems Admin & Operations | Admin. et Exploit. des systèmes
> > Technology Services | Services technologiques
> > Informatics Branch | Direction de l'informatique
> > Maritimes Region, DFO | Région des Maritimes, MPO
> >
> > E-Mail: boivinp_at_mar.dfo-mpo.gc.ca
> >
> >
> > -----Original Message-----
> > Sent: Monday, July 29, 2002 6:28 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: Guys: Is this worth $1,749 for 8 year Oracle veteran
> > DBA
> >
> > Funny, I just heard a seasoned Oracle consultant say
> > that the 9i exams were considerably more difficult
> > than the 8i exams.
> >
> >
> > --- "McBain, Neil SITI-ITDSEL314"
> > <Neil.N.McBain_at_is.shell.com> wrote:
> > > I have just completed my Oracle 8i OCP DBA using
> > > only ten years of
> > > experience and the Sybex books (thoroughly
> > > recommended, except Backup &
> > > Recovery does not cover enough RMAN syntax). I
> > > believe if you sit the 9i OCP
> > > exams then you do have to attend one Oracle course
> > > (except if you had sat an
> > > Oracle 9i exam prior to a certain date this year),
> > > however you can sit the
> > > 8i exams and then the 9i upgrade exam without
> > > requiring the course (or I
> > > hope this is true, since I am studying for the
> > > upgrade exam now). Also heard
> > > an Oracle trainer say that the 9i exams are easier
> > > then the 8i exams but do
> > > not now if this is true or not.
> > >
> > > Hope this is of help,
> > > Neil.
> > >
> > > -----Original Message-----
> > > Sent: 25 July 2002 23:08
> > > To: Multiple recipients of list ORACLE-L
> > >
> > >
> > > Also, isn't Oracle now REQUIRING you to go to THEIR
> > > classes to get your
> > > certification?
> > >
> > > On Thu, 2002-07-25 at 14:19, DENNIS WILLIAMS wrote:
> > >
> > > Paula - I'm skeptical whether a boot camp could
> > > cover all the material
> > >
> > > involved in the OCP tests. I could see where you
> > > might come out tuned up
> > >
> > > enough to whip out a couple of tests, but once you
> > > got past them, you'd
> > >
> > > probably have to do the other tests the hard way --
> > > study for them. I would
> > >
> > > rate the individual classes as more likely to help
> > > you through the OCP, one
> > >
> > > test at a time.
> > >
> > > Dennis Williams
> > >
> > > DBA, 20% OCP
> > >
> > > Lifetouch, Inc.
> > >
> > > dwilliams_at_lifetouch.com
> > >
> > >
> > >
> > > -----Original Message-----
> > >
> > > Sent: Thursday, July 25, 2002 12:54 PM
> > >
> > > To: Multiple recipients of list ORACLE-L
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > Guys,
> > >
> > > I have been working hard on Oracle systems at
> > > various levels - various
> > >
> > > platforms, etc. for 8 years. It has been a long
> > > time since I have taken a
> > >
> > > course. Would like to go to IOUG. Reading e-mails
> > > I have made up my mind -
> > >
> > > I think it gives me more options to get certified.
> > > Problem has been I work
> > >
> > > and have 2 small kids. Also, I am a consultant who
> > > has been steadily
> > >
> > > applied - not a problem but it means I am either
> > > working on systems or with
> > >
> > > my kids. I am thinking this is a way to save myself
> > > the time I don't have
> > >
> > > and force the commitment - is it worth it? I know
> > > an unfair question but by
> > >
> > > taking this and the exams will I indeed completed
> > > what it takes to become
> > >
> > > certified for 9I?
> > >
> > >
> > >
> > > -----Original Message-----
> > >
> > > <mailto:Support_at_OraKnowledge.com> ]
> > >
> > > Sent: Thursday, July 25, 2002 8:26 AM
> > >
> > > To: Paula_Stankus_at_doh.state.fl.us
> > >
> > >
> > >
> > >
> > >
> > > Hello,
> > >
> > >
> > >
> > > Tomorrow (Friday July 26th) is the last day of our
> > > Summer Promotion that
> > >
> > > entitles
> > >
> > > you to save 50% off our Oracle8i / 9i DBA eBoot
> > > Camp. That's right, save
> > >
> > > $1,749.
> > >
> > >
> > >
> > > We have only a handful of remaining seats for our
> > > Live, Online,
> > >
> > > Instructor-led
> > >
> > > course, so call us and register today!!
> > >
> > >
> > >
> > > In case you have lost the previous email I sent,
> > > here's the facts:
> > >
> > >
> > >
> > >
> > >
> > > Because the classes must go on...whether there are
> > > only 5 or as many as 15
> > >
> > > students enrolled...we've decided to allow you the
> > > opportunity to register
> > >
> > > for a
> > >
> > > seat in one of our upcoming courses for 50% OFF.
> > > That's right, instead of
> > >
> > > the
> > >
> > > normal $3,499 registration fee for our Oracle8i / 9i
> > > DBA eBoot Camp, you can
> > >
> > >
> > >
> > > register for only $1,749.
> > >
> > >
> > >
> > > Here's what you get:
> > >
> > >
> > >
> > > - A 5 week blended eLearning program that includes
> > > Instructor Led Training
> > >
> > > in our Virtual Classroom environment. That's
> > > right, you simply need to
> > >
> > > login to
> > >
> > > the Virtual Classroom at the designated time to
> > > receive Live, Instructor
> > >
> > > Led
> > >
> > > Training...without having to leave your home or
> > > office!
> > >
> > >
> > >
> > > - The course includes training for all 5 Oracle8i
> > > OCP DBA exams, plus as a
> > >
> > > FREE BONUS we are including our Oracle9i New
> > > Features for Administrators
> > >
> > > course that will prepare you for the Oracle9i
> > > Upgrade exam. That's a
> > >
> > >
> > === message truncated ===
> >
> >
> > =====
> > Pete Barnett
> > Lead Database Administrator
> > The Regence Group
> > pnbarne_at_regence.com
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Yahoo! Health - Feel better, live better
> > http://health.yahoo.com
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Peter Barnett
> > INET: regdba_at_yahoo.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Boivin, Patrice J
> > INET: BoivinP_at_mar.dfo-mpo.gc.ca
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> >
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Alexandre Gorbatchev
> INET: alexandre.gorbatchev_at_avermann.de
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
>
> The information, attachments and opinions contained in this message are
> those of its author only and do not necessarily represent those of The
> Woolwich and or any other members of the Barclays Group and are intended
> solely for the use of the individual or entity to whom they are addressed.
> The sender may not be authorised to give financial advice, and nothing in
> this message should be construed as offering such advice.
>
> The message may contain privileged and confidential information and you may
> not copy, distribute or take any action in reliance on it. If you have
> received this email in error please notify the Information Security Manager
> at ADMINISTRATOR_at_WOOLWICH.CO.UK
>
> Replies to this email may be monitored for operational or business reasons.
>
> Woolwich plc. Registered in England Number : 3295699.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Bishop Lewis
> INET: Lewis.Bishop_at_woolwich.co.uk
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Tim Gorman
> INET: Tim_at_SageLogix.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
>
>
> The contents of this e-mail are intended for the named addressee only. It
> contains information that may be confidential. Unless you are the named
> addressee or an authorized designee, you may not copy or use it, or disclose
> it to anyone else. If you received it in error please notify us immediately
> and then destroy it.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Karniotis, Stephen
> INET: Stephen_Karniotis_at_compuware.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: April Wells
> INET: awells_at_csedge.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Gorman INET: Tim_at_SageLogix.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Fri Aug 02 2002 - 00:08:21 CDT
 |
 |