Classification: UNCLASSIFIED
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Johnson, Michael
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Classification: UNCLASSIFIED
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Johnson, Michael
INET: [EMAIL PROTECTED]
Fat City
Title: Capacity Planning Methods?
Just
lurking as usual, but Craig Schallahammer (sp) has a fairly extensive
technical
seminar on methods DBAs can use for capacity
planning.
Here
is the link to his web-site.
http://www.orapub.com/cgi/genesis.cgi
-Original Message-From: David
follow up on it and try and determine why this was the
case and your results ? There is very little information on Metalink
regarding this issue.
Thank you for your time in advance.
Mike
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Johnson, Michael
INET
on it and try and determine why this was the case
and your results ? There is very little information on Metalink regarding
this issue.
Thank you for your time in advance.
Mike
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Johnson, Michael
INET: [EMAIL PROTECTED
on Metalink regarding
this issue.
Thank you for your time in advance.
Mike
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Johnson, Michael
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing
subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Johnson, Michael
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
') 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: Johnson, Michael
INET: [EMAIL
Terrista,
Did you run the UTLXPLAN.sql
file so you can get a explain plan output ?
Check Metalink for an
explanation of all of this here is one link
http://metalink.oracle.com/metalink/plsql/ml2_gui.startup
Then .
SQL Set Autotrace
on
Then run those queries
and report
Teresita,
Usted tiene un nombre hermoso. Yo nunca he estado a Guadalajara, pero oigo es
muy agradable. La mayor parte de mi tiempo en México ha sido de Tiajuana
completamente al sur a Zijuantinajo. El País hermoso y muy entibiar a gente
Italia mucho más apreciando. Mi próximo viaje a México
). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Johnson, Michael
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California
First, Your english is
excellent or "Usted habla inglés muy bien. "
Assuming you are running
version 8i or better
Have you analyzed the tables
you are querying against ? You may not need
to force a rule as the CBO will
try to find the quickest way. It looks like
you are using the RBO
greatly appreciate
it.
Thanks For Your Time in Advance.
Mike
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Johnson, Michael
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list
Search
MetaLink ... Burleson has a good book "High PerformanceTuning with
Statspack" .. Tom Kytes Book "Oneon One" in Chapter 10 also
hassome good information.. Look in your
$ORACLE_HOME/rdbms/admin and depending on you version their is a sp*.doc or
st*.txt document in there to show you
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: Johnson, Michael
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San
Title: Precise Software Solutions
IMHO, Every DBA should own this book. It will change
your way of thinking about how to approach oracleperformance
problems.
Mike
-Original Message-From: Kent Mingus
[mailto:[EMAIL PROTECTED]Sent:
Wednesday, May 28, 2003 6:50 AMTo:
be.
Johnson, Michael
[EMAIL PROTECTED]To: Multiple
recipients of list ORACLE-L [EMAIL PROTECTED]
fmc.af.mil cc:
Sent by: Subject: RE: Oracle
Performance
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: Johnson, Michael
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858
: 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: Johnson, Michael
INET: [EMAIL PROTECTED]
Fat City Network Services
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: Johnson, Michael
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
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: Johnson, Michael
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
Title: Message
We
went thru this a couple days ago and Jonathan Lewis
provided some possible scenarios as to how things are
working beneath the radar.
Also,
page 166-167 on Guy Harrisons Book on SQL tuning
will
give you additional information.
Good
Luck. Mike
-Original
information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Johnson, Michael
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
ORACLE-L FAQ: http://www.orafaq.net
--
Author: Johnson, Michael
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
on col1, col2, col3.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Johnson, Michael
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
') 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: Johnson, Michael
INET: [EMAIL
for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Johnson, Michael
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Johnson, Michael
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
parms.
Select col1, col2, col3, blah1, blah2 from table order by col1, col2, col3;
Concatenate index on col1, col2, col3.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Johnson, Michael
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http
command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Johnson, Michael
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting
: http://www.orafaq.com
--
Author: Johnson, Michael
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE
Title: Oracle to Excel
there
is an ODBC driver you can set up to handle this as I recall.
hth.
mike
-Original Message-From: Burton, Laura L.
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, November 06, 2002
10:49 AMTo: Multiple recipients of list ORACLE-LSubject:
Oracle to
and everything is fine now.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Johnson, Michael
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Johnson, Michael
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California
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: Johnson, Michael
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California
Title: RE: Win2000/8.1.7.3.0/SQL
Update
... we dont see this problem if we rlogin to
the
server via a Sun Solaris client box.
-Original Message-From: Johnson, Michael
Sent: Friday, October 11, 2002 10:38 AMTo:
'[EMAIL PROTECTED]'Subject: Help on ORA-03113 error and 7445
Title: RE: Win2000/8.1.7.3.0/SQL
We are getting a intermittent problem that happens
both from a SQL prompt or if we execute off of a
package. We can telnet in or go through the TNS
side of things. It doesnt seem to matter.
Sun Solaris 2.8
Oracle 8.1.7.4
Here is the scenario
subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Johnson, Michael
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
on MySQL and what this RDBMS can do versus other
RDBMS's including Oracle ?
A Spec by Spec comparison is what I am looking for.
Thanks,
Mike
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Johnson, Michael
INET: [EMAIL PROTECTED]
Fat City Network Services
updates, it needs them to
avoid locks on the table.
If the table doesn't have many updates, it's not really
necessary, but it doesn't hurt either, and that way I
don't have to figure out if it's busy enough to warrant
the index. :)
Jared
On Thursday 26 September 2002 17:43, Johnson, Michael wrote
subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Johnson, Michael
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
column which
makes this foreign key index redundant.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Johnson, Michael
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting
subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Johnson, Michael
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Johnson, Michael
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
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: Johnson
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: Johnson, Michael
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538
FAQ: http://www.orafaq.com
--
Author: Johnson, Michael
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
studies on what happens to performance
as indexes keep getting added to tables
while inserting data ??
Thank You in advance for your time.
Mike
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Johnson, Michael
INET: [EMAIL PROTECTED]
Fat City Network Services
ORACLE-L FAQ: http://www.orafaq.com
--
Author: Johnson, Michael
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
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: Johnson, Michael
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego
Tim, more specifically could large SQL have
been passed across
the
net ? Stored procedures could help here.
FWIW.
Mike
-Original Message-From: Tim Gorman
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, August 21, 2002 12:03
AMTo: Multiple recipients of list ORACLE-LSubject: Re:
many
Anjo.
- Original Message -----
From:
Johnson, Michael
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, August 21, 2002 9:10
PM
Subject: RE: how to reduce SQL*Net more
data to client wait event
Tim, more specifically could
for your time in advance.
Mike
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Johnson, Michael
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Johnson, Michael
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
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: Johnson, Michael
INET: [EMAIL
). Tbe only workaround available is to turn it off for that app
or upgrade to 9i.
HTH!
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
-Original Message-
From: Johnson, Michael [mailto:[EMAIL PROTECTED
see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Johnson, Michael
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Johnson, Michael
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
') 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: Johnson, Michael
INET
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: Johnson, Michael
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California
to rewrite those literals.
FWIW. Mike
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Johnson, Michael
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
it out.
If anyone has any experience with this one
I would be curious to know what happened.
Mike
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Johnson, Michael
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego
!
FWIW.
Mike
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Johnson, Michael
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
(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: Johnson, Michael
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538
may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Johnson, Michael
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public
send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Johnson, Michael
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet
as everyone else.
FWIW.
Mike
-Original Message-
Sent: Monday, July 15, 2002 1:13 PM
To: Multiple recipients of list ORACLE-L
OT
On Mon, 15 Jul 2002, Johnson, Michael wrote:
Everyone should have been smart enough to sell stocks and
put their money into cash or better yet short stocks
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: Johnson, Michael
INET: [EMAIL PROTECTED]
Fat City Network
of positions coming out that require
a CURRENT Secret or Top Secret clearance. How can all these positions
be filled unless these company/entities start footing the bill for
people getting the clearances?!?
Johnson, Michael wrote:
That is not my understanding.
FWIW. Mike
-Original Message
FAQ: http://www.orafaq.com
--
Author: Johnson, Michael
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE
these positions
be filled unless these company/entities start
footing the bill for
people getting the clearances?!?
Johnson, Michael wrote
the bill for
people getting the clearances?!?
Johnson, Michael wrote:
That is not my understanding.
FWIW. Mike
-Original Message-
Sent: Wednesday, June 26, 2002 1:35 PM
To: Multiple recipients of list ORACLE-L
Actually no one who has been holds any SCI tickets
may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Johnson, Michael
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public
For a 24 X 7 system I would incorporate a hot
backup strategy
which can be executed without
taking the system down and
allows for a point in time
recovery. There are many scripts
floating aroundyou could "borrow" to set this
up.
Your performance issue is going
to require some time to
://www.orafaq.com
--
Author: Johnson, Michael
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from
to teach
sometimes the ability to teach is more important than how much they
know. I've known really smart people who can't make anyone understand
what they know
--- Johnson, Michael [EMAIL PROTECTED] wrote:
alright ... Ill buy that explanation.
-Original Message-
Sent: Thursday, June
ORACLE-L FAQ: http://www.orafaq.com
--
Author: Johnson, Michael
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
, 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: Johnson, Michael
INET: [EMAIL PROTECTED
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: Johnson, Michael
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858
' and col2 0
order by col1 desc;
returns 0 rows just by putting in the descending clause
anybody seen this happen before
new index has been added on the table, but
nothing else is new.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Johnson, Michael
INET: [EMAIL
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: Johnson, Michael
INET: [EMAIL PROTECTED]
Fat City Network Services
with several of the best of
Oracle instructors. I have also had the misfortune to take classes with
some of the less best
--- Johnson, Michael [EMAIL PROTECTED] wrote:
I would second these selections below
Stay away for the Oracle provided training, It is worthless.
fwiw !
Peace
: 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: Johnson, Michael
INET: [EMAIL PROTECTED]
Fat City Network Services
time strange behaviour.
No logging of any hardware/software error was found on UNIX nor Symmetrix
nor Oracle so we have given up for now.
Jack
Johnson, Michael
Michael.Johnson@oln-aTo: Multiple
recipients of list ORACLE-L [EMAIL
://www.orafaq.com
--
Author: Johnson, Michael
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from
://www.orafaq.com
--
Author: Johnson, Michael
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself
Title: RE: Diagnose Slow System
You
need to take a slice of the database when the
performance degrades. Capturing statistics at the end of the
day
before the database goes down is meaningless.
Consider setting up a 10046 event trace and
find
out what session and what wait eventis boggin
If you
are on Unix make sure your ORACLE_SID environment
variable is set to the database you want to
use.
-Original Message-From: Meomeo Nguyen
[mailto:[EMAIL PROTECTED]]Sent: Friday, June 07, 2002 3:28
PMTo: Multiple recipients of list ORACLE-LSubject:
Simple Oracle
for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Johnson, Michael
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
its on Metalink search on the error number or
on corrupted block.
-Original Message-
Sent: Wednesday, May 29, 2002 11:39 AM
To: Multiple recipients of list ORACLE-L
Hi,
very interesting. what is the URL for these utilities ?
Johnson, Michael wrote:
There is also a Pro*C
information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Johnson, Michael
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
sorts (memory)
0 sorts (disk)
1410 rows processed
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Johnson, Michael
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California
') 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: Johnson, Michael
on b.n1
there is a concatenated primary key index on a.f1,a.f2,a.f3
there is a non-unique index on a.f1
the query shows that the index is being used
on table b, but no indexes are being used on table a.
Mike
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Johnson
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Johnson, Michael
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
to wait.
Thanks for all you time on this.
Peace !
Mike
T
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Johnson, Michael
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access
-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: Johnson, Michael
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858
the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Johnson, Michael
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Johnson, Michael
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Johnson, Michael
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
100 matches
Mail list logo