Ian" wrote:
Hi there fellow Oracle people,
I am hoping that some of you can help me and/or provide details etc.
for
my situation I find myself in. So if you bear with me I will describe
the situation.
I currently support an Oracle 9i (just moved from 7.3.4), windows,
tuxedo, client server applicatio
Hi there fellow Oracle people,
I am hoping that
some of you can help me and/or provide details etc. for my situation I find
myself in. So if you bear with me I will describe the
situation.
I currently
support an Oracle 9i (just moved from 7.3.4), windows, tuxedo, client server
ing this, subscribe to the new list. This one's days are
limited
to about 10.
<[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
01/23/2004 08:44 AM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
I
think he lucked out and didn't do this on a highly visible system.
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of
[EMAIL PROTECTED]Sent: Friday, January 23, 2004 1:14
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
Help -
Yes,
but how do I fix it? Do I need to reinstall?
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of
[EMAIL PROTECTED]Sent: Friday, January 23, 2004 1:14
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
Help - 9ias broke - hostname was
o about 10.
<[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
01/23/2004 08:44 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: RE: Help - 9ias broke - hostname was changed
Help
utility?
On 01/23/2004 11:44:26 AM, [EMAIL PROTECTED] wrote:
Help
System Admin. got a wild hair and changed the hostname on us for a
9ias v2 server.
Now none of the processes work and getting all kinds of unhandled
java
exceptions regarding hostname
Have the
SysAdmin change the hostname back. Haven't used 9iAS but in the past, the
hostname was embedded in the install config files. You can put in a DNS
alias for your old hostname for a work around.>>>
[EMAIL PROTECTED] 01/23/04 11:44AM >>>
Help
System
Adm
Title: Message
Help
System
Admin. got a wild hair and changed the hostname on us for a 9ias v2
server.
Now
none of the processes work and getting all kinds of unhandled java exceptions
regarding hostname
oracle.ias.repository.schema.SchemaException:Unable to connect to
Directory
LOL!!
Ok, Ashish, the problem is you sent 'help' to the list address.
Send HELP to [EMAIL PROTECTED] and all will be well.
Ok, now back to work everyone.
Jared
"Odland, Brad" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
01/21/2004 07:59 AM
Abandon hope, all ye who enter here
(Dante Alighieri)
On 01/20/2004 10:24:27 AM, Bill Gentry wrote:
help
Get advanced SPAM filtering on Webmail or POP Mail ... Get Lycos
Mail!
http://login.mail.lycos.com/r/referral?aid=27005
help
Get advanced SPAM filtering on Webmail or POP Mail ... Get Lycos Mail!
http://login.mail.lycos.com/r/referral?aid=27005
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Bill Gentry
INET: [EMAIL
OVE yourself from this mailing list, send an E-Mail message
:->to: [EMAIL PROTECTED] (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
:->
f from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).
ng services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of
EMAIL PROTECTED] (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).
elf from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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 othe
b hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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 ma
#x27;) 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).
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, January 07, 2004 11:45 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: another OCP question -- help me guys
>
>
>
> > Hi list , sorry to pe
--
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name
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).
> Hi list , sorry to pester you with questions regarding
> boson OCP questions . i have scheduled for #1Z0-031 exam
> and so desperately need help from this list .
> please bear with me for while . look at the 2 questions below .
Don't apologize Prem, who else are you gonna ca
Author: Thater, William
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REM
MOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (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 H
EMAIL PROTECTED] (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 O
Title: RE: Re[2]: another OCP question -- help me guys
brutal, absolutely brutal...
Rachel, can ya out-source your sacrificial lamb for our use as well:-)
-Original Message-
From: Rachel Carmichael [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 07, 2004 11:54 AM
To: Multiple
is 28 years old, have anything to do with current
> programming
> > and database work?
>
> Believe it or not, a college degree in art history really does help
> in two ways.
> First, people exposed to sufficient quantity of art tend to be nobler
> and more
> spiritual,
s mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).
Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and i
rk?
Believe it or not, a college degree in art history really does help in two ways.
First, people exposed to sufficient quantity of art tend to be nobler and more
spiritual, according to the popular beliefs, then cynical mathematicians and
computer geeks like me. Being noble and spiritual mea
-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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
858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).
elling 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).
Title: RE: Re[2]: another OCP question -- help me guys
Uh No one can be at Rachel's level. She's the DBA Goddess
-Original Message-
From: Ryan [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 07, 2004 8:55 AM
To: Multiple recipients of list ORACLE-L
Subje
-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).
ing list and web hosting services
> > -----
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, incl
web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the messag
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).
t.net/mailman/listinfo/oracle-article,
> or send email to [EMAIL PROTECTED] and
> include the word "subscribe" in either the subject or body.
>
>
> Wednesday, January 7, 2004, 6:24:24 AM, Prem Khanna J
> ([EMAIL PROTECTED]) wrote:
> PKJ> Hi list , sorry to peste
to pester you with questions regarding
PKJ> boson OCP questions . i have scheduled for #1Z0-031 exam
PKJ> and so desperately need help from this list .
PKJ> please bear with me for while . look at the 2 questions below .
PKJ> -
y, January 07, 2004 9:24 PM
> Hi list , sorry to pester you with questions regarding
> boson OCP questions . i have scheduled for #1Z0-031 exam
> and so desperately need help from this list .
> please bear with me for while . look at the 2 questions below .
>
> ---
Hi list , sorry to pester you with questions regarding
boson OCP questions . i have scheduled for #1Z0-031 exam
and so desperately need help from this list .
please bear with me for while . look at the 2 questions below
to rebuild it again to get the required report output
can somebody please help me out of this
thanks
regds,
Rohan
From: [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Subject: starting/stopping trace in session
Date: Fri, 02 J
stics to true (on session level). But I doubt it'll
help in current case anyway.
Tanel
__
Do you Yahoo!?
Find out what made the Top Yahoo! Searches of 2003
http://search.yahoo.com/top2003
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Au
Hi!
Statistics level ALL means TYPICAL + row source execution stats +
timed_os_statistics.
If you want to switch to ALL for performance reasons, you can switch only
row source stats on with parameter setting _rowsource_execution_statistics
to true (on session level).
But I doubt it'll he
lt;[EMAIL PROTECTED]>
> Date: 2003/12/30 Tue PM 01:29:25 EST
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: Re: help with estimate row count from asktom
>
> Don't be afraid to access v$ views, just beware of the bug that throws a o
anyone have a better way to do this? im going to post what you said wolfgang on asktom
and see what he has to say.
>
> From: Wolfgang Breitling <[EMAIL PROTECTED]>
> Date: 2003/12/30 Tue PM 12:09:33 EST
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
; functionality. It's built-in to Intermedia.
-Mark
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tue 12/30/2003 1:19 PM
To: Multiple recipients of list ORACLE-L
Cc:
Subject:Re: Re: help with estimate row count from asktom
im concerned
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).
:09:33 EST
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Re: help with estimate row count from asktom
>
> v$sql_plan_statistics (and consequently v$sql_plan_statistics_all) only
> have data to show if statistics_level is set to ALL. You can set that a
nd an E-Mail message
to: [EMAIL PROTECTED] (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).
Wolfgang Bre
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).
.uk/faq/ind_faq.html
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, December 26, 2003 6:59 PM
> I figured it out. I need some help with query re-write. Im not sure its
possible.
>
> My materialized view joins 3 tables o
materialized view needs to be reloaded. This could take a little while.
>
> From: [EMAIL PROTECTED]
> Date: 2003/12/26 Fri PM 02:09:27 EST
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Re: please help with materialized view question
>
> Warnin
Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: Re: please help with materialized view question
I figured it out.
I have another problem. I create my materialized view. I now want to write a query that joins it to a transactiona
I figured it out. I need some help with query re-write. Im not sure its possible.
My materialized view joins 3 tables on the primary key/foreign key. I have a query
that would join that materialized view to a third transactional table, but that join
is not on any primary key or foreign key.
I
TED]>
Sent by: cc:
ml-errorsSubject: please help with materialized
view qu
removed from). You may
also send the HELP command for other information (like subscribing).
ntaining: 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).
REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (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 se
age
to: [EMAIL PROTECTED] (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).
t you want to be removed from). You may
also send the HELP command for other information (like subscribing).
m> cc:
Sent by: Subject: RE: Help on tkprof output
-Mail message
to: [EMAIL PROTECTED] (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 s
istGuru') 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).
27;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.net
--
Author
, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the messa
;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).
#x27;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).
Wolfgang Breitling
Oracle7, 8, 8i, 9i OCP DBA
Centrex Consulting Corporation
ht
-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a
l message
to: [EMAIL PROTECTED] (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).
ervices-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> ---
> --
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTE
---
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).
aining: 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).
: Looking for help - sql*loader and truncate
In that case you could create a procedure owned by the data owner that does
the truncate, grant execute on the procedure to the data loader, and use
SQL*Plus to call the truncate procedure before the SQL*load starts.
> -Original Message-
>
-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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
er <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
11/13/2003 07:09 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: More help with TKPROF
List:
My apologies. Seems like I&
parses and the times waited on "sql*net message to
client". Is this coincidence, or can I make some
correlation here?
Thanks so much for your patience and your help.
Database is 8.1.7.4 on Solaris 8.
Barb
SELECT PAPER, PAGE, PAGENAME, PAGENO, COLUMNS,
COLWIDTH, COLSPACE, HEIGH
---
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).
tween the number
of parses and the times waited on "sql*net message to
client". Is this coincidence, or can I make some
correlation here?
Thanks so much for your patience and your help.
Database is 8.1.7.4 on Solaris 8.
Barb
SELECT PAPER, PAGE, PAGENAME, PAGENO, COLUMNS,
COLWIDTH, COL
o the load.
Stefan
-Ursprüngliche Nachricht-
Von: Rachel Carmichael [mailto:[EMAIL PROTECTED]
Gesendet: Mittwoch, 12. November 2003 18:45
An: Multiple recipients of list ORACLE-L
Betreff: Re: Looking for help.
yeah but...
if you attempt (as I do) to isolate the schema owner from the users
err, should be Win2k, even though it feels like Win0.5k sometimes ;).
Stefan
-Ursprüngliche Nachricht-
Von: Nelson, Allan [mailto:[EMAIL PROTECTED]
Gesendet: Mittwoch, 12. November 2003 14:49
An: Multiple recipients of list ORACLE-L
Betreff: RE: Looking for help.
Windows 3000
EMAIL PROTECTED]
Gesendet: Mittwoch, 12. November 2003 18:24
An: Multiple recipients of list ORACLE-L
Betreff: Re: Looking for help.
There are two options to replace all data in the table: REPLACE and TRUNCATE
which are equivalent to truncate and delete sql statements. If you have
staging tables witho
Title: Re: Multi-threaded server - will it help in this case
No, thanks for helping bust the myth. I’m always so surprised by the gap between what I thought I said and what I apparently communicated... :-)
Still, it is an interesting distinction. A separate TNS listener certainly isn’t
Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).
ADMIN)
> >
> > Rows Row Source Operation
> > ---
> >
> ---
> > 82 SORT UNIQUE
> > 82 NESTED LOOPS
> > 83INDEX RANGE SCAN (object id 395118)
> > 82TABLE
yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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 inf
: http://www.orafaq.net
> --
> Author: Daniel Fink
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting
services
>
051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru&#
-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelli
, 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.net
--
Author: Ron Rogers
INET: [EMAIL PROTECTED]
Fat C
ABLE ACCESS BY INDEX ROWID CLASS
> > 164 INDEX UNIQUE SCAN (object id 395113)
> >
> > Rows Execution Plan
> > ---
> >
> ---
> > 0 SELECT STATEMENT GOAL: CHOOSE
> > 82 SORT (U
ED LOOPS
> > 83INDEX RANGE SCAN (object id 395118)
> > 82TABLE ACCESS BY INDEX ROWID CLASS
> > 164 INDEX UNIQUE SCAN (object id 395113)
> >
> > Rows Execution Plan
> > ---
> > -
tGuru') 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).
gt; ---
> 82 SORT UNIQUE
> 82 NESTED LOOPS
> 83INDEX RANGE SCAN (object id 395118)
> 82TABLE ACCESS BY INDEX ROWID CLASS
> 164 INDEX UNIQUE SCAN (object id 395113)
>
>
> R
PS
83 INDEX GOAL: ANALYZED (RANGE SCAN) OF
'I_CLO1' (NON-UNIQUE)
82 TABLE ACCESS GOAL: ANALYZED (BY INDEX
ROWID) OF 'CLASS'
164 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
'I_CLA1' (UNIQUE)
Thanks for any help.
Barb
STED LOOPS
> 83 INDEX GOAL: ANALYZED (RANGE SCAN) OF
> 'I_CLO1' (NON-UNIQUE)
>
> 82 TABLE ACCESS GOAL: ANALYZED (BY INDEX
> ROWID) OF 'CLASS'
> 164 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
> 'I_CLA1' (UNIQUE)
>
>
--
> 0 SELECT STATEMENT GOAL: CHOOSE
> 82 SORT (UNIQUE)
> 82NESTED LOOPS
> 83 INDEX GOAL: ANALYZED (RANGE SCAN) OF
> 'I_CLO1' (NON-UNIQUE)
>
> 82 TABLE ACCESS GOAL: ANALYZED (BY INDE
1 - 100 of 2363 matches
Mail list logo
