Hi List,
I have one Oracle Application database (Version 8.1.7.4 on Sun Sparc Solaris 2.6, instace name CRPHR). I have a table HR_LOCATIONS_ALL in HR schema and there is synonym HR_LOCATIONS_ALL in APPS schema forthis table.
I am trying to create a snapshot inother database ( Version 9.2 on
Dennis,
This is our actual distribution:
Datafiles belonging to data in a separate disk, name it /baandata
Datafiles belonging to index in a separate disk, name it /baanindex
And 3 redolog files, two of them in another two separate disks, and the third
Have you updated your cursor to add the new column?
John
-Original Message-
Sent: 03 April 2003 21:54
To: Multiple recipients of list ORACLE-L
I added a column using alter table add ...
i can see it from sql . can select it from sql . But if I try to use it in a pl/sql
block or
No problem with the archive log management scripts, I back up archived log
files daily, no matter how many of them we have.
-Mensaje original-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de Reardon,
Bruce (CALBBAY)
Enviado el: viernes, 04 de abril de 2003 3:28
Para:
Sorry, that wasn't clear enough:
I meant the backup time for one individual redo log will increase. Of course
your right, ... the overall bytes to be backed up don't increase.
Stefan
Stefan Jahnke
Consultant
BOV Aktiengesellschaft
Voice: +49 201 - 4513-298
Fax: +49 201 - 4513-149
mailto: [EMAIL
Hi Pete,
Stop using my favourite answer :)
I'm not suggesting this is particularly scientific but here's a quick
test on dropping a moderate number of extents (9.2 on XP):
SQL create tablespace biggish
2 datafile 'c:\bowie\biggish01.dbf' size 2000M
3 uniform size 16K;
Tablespace created.
hi, see inline comments below ...
There are some other effects I can think of.
Up to you if these are important / significant to your users.
If you make them bigger and you have a standby database then the standby
might end up being further behind production (unless you have a script to
Has anyone ever seen - and resolved - a database hang at shutdown when the
message SHUTDOWN: waiting for active calls to complete. appears in the
alert log.
We get this occasionally and no matter how long we wait the shutdown never
completes. A new connection to do an abort is not possible as
Its not really a particular redo log that is the
issue. You've used up redo's (say) 1, 2, 3 and you
want to cycle around to 1 but the checkpoint that
would free up redo 1 is not yet finished.
Thus its not a single redo log that is the problem -
the IO rate of the checkpoint is not sufficient
Ok, I'll go for something controversial and lets see
if it can be shot down...
On the assumption that every system's maximum physical
I/O is a common divisor or multiple of the Oracle
setting for SSTIOMAX (which is 1m in most relevant
versions), then every extent for every segment should
be 1m
So do you think the following distribution will contribute to a better
performance:
data datafiles - device a
index datafiles - device b
redolog1 - device c
redolog2 - device d
redolog3 - device c
instead of:
data datafiles -
There have been a number of emails on this thread a few months ago. Check
the archives.
Some people [including me] are comfortable with SHUTDOWN ABORT,STARTUP
RESTRICT, SHUTDOWN NORMAL
while others are NOT comfortable with the SHUTDOWN ABORT.
It depends on your experiences with SHUTDOWN ABORT
I count that as 127 thousand extents dropped in 6seconds.
The CREATE TABLE + EXTENTS took 49seconds.
No, I am not trying to draw any conclusions, just making an
observation. I am comfortable with thousands of extents
but wouldn't look at a million extents.
Hemant
At 12:23 AM 04-04-03 -0800, you
Another question
Is the procedure selecting from a view on the table ? Or a synonym to a
view on the table ?
-- the view not having been recreated to include the new column.
Hemant
At 12:23 AM 04-04-03 -0800, you wrote:
Have you updated your cursor to add the new column?
John
-Original
On Thu, Apr 03, 2003 at 06:58:37PM -0800, Connor McDonald wrote:
All this discussion on shutdown does motivate me to
ask why is everyone shutting down so frequently?
--
Here are my reasons this past year:
oracle security patches
sun kernel patches
power issues
static configuration change
8i
Title: RE: dbshut script - why shutdown so much???
Your reasons beat ours, Ray. We just reboot the box every weekend because we do and we always have. It is AIX, too. We don't even reboot our Win 2K machines as often.
April Wells
Oracle DBA/ Oracle Apps DBA
-Original Message-
From:
rumor hath it (as I've never actually had an object hit that high a
number) that when you exceed 4K extents it's time to resize. This came
from one of the instructors in Oracle University, one who is well-known
to actually have more than a clue. He said this at the Data Internals
class, before 9i
On Thu, Apr 03, 2003 at 06:33:53PM -0800, Ray Stell wrote:
I went to look at the matrix today and found it dramatically
changed. I found only 9.2.0 and Redhat AS. All the other
free linux versions are gone as well as all 8i versions.
Do you find the same, maybe the webmeister is messing
Would you please?
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, April 03, 2003 3:28 PM
Sorry, the attachments didn't make it, though they were only text.
I can put them some accessible via the
Anyone using this
configuration?
Since I would like to avoid raw
partitions, I was thinking of recomending Veritas File
system...
Is it certified / working? Anyone working
with such combo?
I will fire metalink page soon, but would
like to have some input from listers!
Thanks,
Vladimir
Quick question, I want to submit statspack.snap at 10:00am and 14:00pm through dbms_job, it's friday afternoon and my head is hurting me from a heavy night and the manuals are as clear as mud.
ThanksYahoo! Plus - For a better Internet experience
There's another thread on this list this week regarding shutdown.
You should probably read it.
Barring that, you should start using 'shutdown immediate' at the very least.
If that doesn't work, use 'shutdown abort'.
As for being unable to make another connection, the state of the
database
I once read an article in an IT publication (several years ago) in which
the author stated that if you are still rebooting your Unix servers
routinely, your Unix admins don't know what they're doing. Yes, the
language was that harsh.
I thought this was ludicrous for 2 reasons:
1) The author
Title: PL/SQL- cursors and commits
I've been 'experimenting' with the following code in 8.1.5 and it seems to work fine. However,
my ORACLE PL/SQL book from O'REILLY (Steven Feuerstein Bill Pribyl 1997) leads me to
believe that it should not work. They state As soon as a cursor with a FOR
What you see is correct. 9.2.0 is only supported on PAY versions of linux.
8.1.7 is still supported on various free versions. (funny how open only
includes
We just went through hoops trying to find a combination of free Linux and
Oracle that
we could run OEM OMS and names on...
We settled on
All our unix servers (+-25) are AIX 4.3.
We reboot only if there is a problem.
Stephane
-Original Message-
Landrum
Sent: Friday, April 04, 2003 9:29 AM
To: Multiple recipients of list ORACLE-L
I once read an article in an IT publication (several years ago) in which
the author stated
[EMAIL PROTECTED] wrote:
Your reasons beat ours, Ray. We just reboot the box every weekend
because we do and we always have. It is AIX, too. We don't even reboot
our Win 2K machines as often.
there's also run away processes from poorly written third party
software, or internally written for
Fermin,
The checkpoint incomplete message is a statement that your DBWR is not
keeping up with the pace of redo generation. You can try to paint over the
problem by adding redo log files. This works when you create enough redo
log file space that your peak redo generation event concludes before
Oh joy! The ABORT argument again! ;)
Is there a way to flush table monitoring counts before the ABORT, either in
8i or 9i?
Rich
Rich JesseSystem/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
-Original Message-
If you're talking about the RMAN cloning process, I've never tried it
but it should be possible, at least in theory. RMAN cloning needs
a) Valid backup
b) The AUX instance.
c) RMAN catalog.
Now, I know that 8.1.7.1 RMAN executable can use the catalog created with
9.2.0.3
(tested personally), and
On Fri, 4 Apr 2003, Darrell Landrum wrote:
I once read an article in an IT publication (several years ago) in
which the author stated that if you are still rebooting your Unix
servers routinely, your Unix admins don't know what they're doing.
Yes, the language was that harsh.
I thought this
yes I added that column in to cursor . varified everything . There was a
synonym . I dropped and recreated synonym , but it doesn't work . Finally I
removed the default clause in newly added column and recreated sysnonym ,
which worked .
This was weired .
-ak
- Original Message -
To:
Hi Madhavan,
You are always welcome. I had to write a similiar one
some time back and I remember it was quite a task then.
Thankfully I had a head start this time !. Hope you get
the stuff sorted out. Glad to be of help ...
Regards,
Jayadas
-Original Message-
Sent: Thursday, April 03,
which means query data dictionary for table defination , but why go to db
blocks ?
-ak
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, April 03, 2003 8:13 PM
There are perfectly valid reasons for querying
a table when no rows are
as has been pointed out to me privately (and it's really okay to
correct me publicly!), it is not delete that would release blocks but
truncate or drop.
Resolution: do not post before at least two cups of coffee.
My apologies to anyone I might have confused.
--- Rachel Carmichael [EMAIL
Fermin
I would definitely go for your second configuration. I don't think there
is a problem with several redo logs on the same device, since Oracle is only
writing to one log at a time. Actually, if I could devote two devices to
redo logs, I would mirror the redo logs. You can easily recover
Kurt:
It appears that you are committing inside the loop in the same inner block
that the update is in. The commit is freeing up the rows. I find it a good
practice sometimes to do commits inside the inner block like that, on long
transactions.
What it doesn't write are the blocks that are not allocated to any
extent. RMAN doesn't go into the logical structures, like tables and
indexes,
it looks into the tablespace header and reads the information from the
bitmap information there. It cannot go into tables/indexes because it
should also
Thanks ,
That's what I guessed . But was feeling lazy to do 10046 tracing .
N E way thanks for the info .
-ak
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, April 03, 2003 5:40 PM
Ak,
I think what you're seeing is the result of the
thanks for the reply .
-ak
- Original Message -
From:
CP
To: Multiple recipients of list ORACLE-L
Sent: Thursday, April 03, 2003 5:28
PM
Subject: Re: oracle job question
Yes, the value for JOB_QUEUE_PROCESSES should be 0 for any
scheduled jobs to
Title: Re: submitting statspack.snap through dbms_job
var jnr number
exec dbms_job.submit(job=:jnr, what='statspack.snap(5);',
next_date=trunc(sysdate)+10/24, interval='trunc(sysdate)+10/24');
exec dbms_job.submit(job=:jnr, what='statspack.snap(5);',
next_date=trunc(sysdate)+14/24,
In 9i Release 2 :
exec dbms_stats.flush_database_monitoring_info
Nothing of the sort in earlier releases...
- Kirti
-Original Message-
Sent: Friday, April 04, 2003 9:09 AM
To: Multiple recipients of list ORACLE-L
Oh joy! The ABORT argument again! ;)
Is there a way to flush
I seriously advise against the Intel Itanic machines. If you
need 64 bits you can either wait for the Clawhammer or switch to
something else that already supports 64 bits. One little HP superdome
would be a nice decoration in my living room. Intel Itanic has hit an
iceberg.
-Original
Title: PL/SQL- cursors and commits
As the
book says, it fails with following error(9.2.0.1 on
Win2k).
declare*ERROR at line
1:ORA-01002: fetch out of sequenceORA-06512: at line 12
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of Wiegand,
Hi List,
We all need to kill the user sessions in the situations of locking or sometime on end
user / application support person's request . I would like to know best practices
followed before killing a session , Any of you collect some information/statistics
before kill ??
Please share your
Hello
list,
In Oracle 9.2.0.1,
you can now order by using a single-row subquery
Here is an
example:
SELECT emp.deptno, empno, enameFROM empORDER
BY (SELECT deptnoFROM
deptWHERE dept.deptno = emp.deptno
);
Thequestion I
have is what is theusefulness of this?Under which
circumstances
Hey all,
Fighting with a lot of ORA-1555s lately on 8.1.7.4 on HP/UX. Most of them
are now coming from long-running Business Objects (B.O.) queries against our
OLTP DB. I think I need to recreate the RBS tablespace (currently 1MB
extents in LMT), but until I can get time to do that, I'd like to
This is accurate and far more correct than my quickly written statement was.
I actually say this almost word for word in the book. This is why even a
table truncate will not reduce RMAN space usage. Sorry, I'll endevor in the
future to be more susinct! :-)
RF
-Original Message-
To:
This matches the data I have collected, with the following addition:
RMAN will backup any blocks that have ever had data in them, even if the
extent has been deallocated or the object dropped.
Keith
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent:
Jesse, Rich wrote:
Hey all,
Fighting with a lot of ORA-1555s lately on 8.1.7.4 on HP/UX. Most of them
are now coming from long-running Business Objects (B.O.) queries against our
OLTP DB. I think I need to recreate the RBS tablespace (currently 1MB
extents in LMT), but until I can get
Title: Re: why ?
Oh, Oracle KNOWS that where 1=2 is always false, so it knows that the
resultset will be empty. But it has to come up with a plan, so I assume it
just takes the simplest plan it knows - a full table scan - knowing full
well that it does not actually have to do the
Rich
For what it's worth, here would be my priorities:
1. Ask the users to run the report at a different time. Maybe plot the
transactions over a 24-hour period to display better time. They won't like
this, and you may want to soften it with until we get the application
modified.
2.
A zip file of the run_stats scripts can be downloaded from
http://www.cybcon.com/~jkstill/download/run_stats.zip
Jared
Igor Neyman [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
04/04/2003 06:08 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL
Title: RE: Things to validate / collect before Killing a session
I always check to see how much rollback they have in case I want to watch
it rollback and I always make sure I get the pid for the associated UNIX
process in case I decide I need to kill it. Of course, I always almost
It's worth noting that even in the execution path
you get a clue that the table isn't actually visited:
Note the FILTER line -
FILTER means too many things, but one of the
meaning is:
I'm not really going to do the child bit
because I know that the result set will
be empty
This
[EMAIL PROTECTED] wrote:
I seriously advise against the Intel Itanic machines. If you
need 64 bits you can either wait for the Clawhammer or switch to
something else that already supports 64 bits. One little HP superdome
would be a nice decoration in my living room. Intel Itanic has hit an
I apologize, I shouldn't be trying to teach the master.
-Original Message-
Sent: Friday, April 04, 2003 12:09 PM
To: Multiple recipients of list ORACLE-L
This is accurate and far more correct than my quickly written statement was.
I actually say this almost word for word in the book.
You've also been to Scott Gosset's classes in NYC in the year 2001? He had
a whole series of those classes. It was a very rare event indeed, given that
he
lives in Peoria, Il. I was very, very impressed with him and his knowledge.
He warmly recommended Steve Adams book, which has really surprised
Wow !
I didn't realise that was possible - I'll have to
see what Oracle can do with the execution plan.
Your example could, of course, be rearranged
to join emp to dept in order to order by some
column of dept - and that might give us a clue
why this could be useful.
Pure hand-waving here - not
Don't really know but couldn't it be useful if you had
ORDER BY ( SELECT deptname FROM dept
WHERE dept.deptno = emp.deptno)
-Original Message-
Sent: 04 April 2003 17:34
To: Multiple recipients of list ORACLE-L
Hello list,
In Oracle 9.2.0.1, you can now order by using
I think you ought to refine your test:
Create two tables at one extent each,
then alternately allocate one extent
to each table until you get to a very
large number of extents. THEN try
dropping one of them.
Remember to set tablespace quotas
for the user creating the table.
It still won't
Stephane,
Three things I don't need to tell you about
your example:
Prior to CPU-costing in 9, the order of
single table predicates can have a dramatic
impact on CPU without changing the amount
of logical I/O.
Logical I/O should always include the statistics
buffer is pinned count - it's just
Bill,
Welcome back!!! I haven't read you in a long time. Hope all is well.
Ron
[EMAIL PROTECTED] 04/04/03 12:29PM
[EMAIL PROTECTED] wrote:
I seriously advise against the Intel Itanic machines. If you
need 64 bits you can either wait for the Clawhammer or switch to
something else that
I have always been puzzled by the expression
context switch when talking about sql and pl/sql.
To me, a context switch is something that happens
at the O/S level when a process is suspended by the
scheduler and a different process is resumed. If a
trigger fires on an insert/update/delete, this
Rich,
The overcommiting is a definite suspect and is worth
looking into. ALso, do you by chance have OPTIMAL set
on your rollback segments? If so, I'd suggest you
remove the OPTIMAL clause and try again. In my
experience, I have had my share of hassles with
OPTIMAL. Even when it was sized
Title: RE: Things to validate / collect before Killing a session
Thanks Kurt
!!!
All,
what Actually Oracle
will do when we kill the JOB by " kill -9" , instead of "Alter System
". What about the Rollback
??
Any PARALLEL parameters in init.ora has any effect if
Most of your cost there comes from the fact that
the triggered approach turns an array process into
a single row process. If you want a fairer comparison
you need to ensure that your raw bulk load is only
processing one row at a time.
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Vladimir,
You can either use Sun Cluster 3.0 using raw devices
only with Veritas's Cluster Volume manager to manage
the devices.
or
You can use Veritas's DBE/AC 3.5 edition and use the
Veritas Cluster manager and Cluster File Systems
(includes Cluster Volume Manager by Default) or raw
devices.
Actually it was Bethesda a few years earlier but yes, Scott Gossett's
classes. He is indeed impressive.
I took Scott Heisey's class on 8i new features in Chicago in '96 or
'97. Also a great instructor.
I've never taken a class with Cary (I'm hoping to kinda change that at
the Hotsos Symposium
Don't worry about the fact that it is inefficient,
worry about the fact that it simply doesn't work
Person 2 inserts a row into table ''ApplicationFormCriteria''
but doesn't commit. The 'pseudo-RI' trigger fires and finds
the parent row in 'ApplicationForm' so the row is deemed
okay.
Person 1
One more foot in the grave of us diehard IMMEDIATE fans (nee anti-ABORT).
Good to know that it's an option! Now if I can just get all of our various
software vendors to support anything above 8.1.7.2.0...
Rich
Rich JesseSystem/Database Administrator
[EMAIL PROTECTED]
Hello friends,
I'm a new member, my name is Dory Edson, and I live
in Brasil.
My question is about Oracle EnterPrise
Manager
I have installed Oracle 8.1.17i, and I can't start
the Oracle EnterPrise Manager. (it can't find the service our
server)
Irealized that
the service
Hello friends,
I'm a new member, my name is Dory Edson, and I live
in Brasil.
My question is about Oracle EnterPrise
Manager
I have installed Oracle 8.1.17i, and I can't start
the Oracle EnterPrise Manager. (it can't find the service our
server)
Irealized that
the service
Which version of 8i ?
They didn't appear until 8.1.6.
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
The educated person is not the person
who can answer the questions, but the
person who can question the answers -- T. Schick Jr
One-day tutorials:
Title: RE: Sub-query in order by clause
Why would you do that instead of
SELECT emp.deptno, empno, ename
FROM emp a, dept b
WHERE dept.deptno = emp.deptno
order by dept.deptname ;
-Original Message-
From: Nicoll, Iain [mailto:[EMAIL PROTECTED]]
Don't really know but couldn't it
Deepak
You may also wish to consider not using catalog(s) -- control file
backups. This might make it easier to add and remove databases in your
environment. I'm presuming most databases are on their own server.
If you want to be able to run a single query that will report any backup
Title: RE: Do triggers cause a context switch between SQL PL/SQL
Jonathan
it is switching from SQL context to PL/SQL context and vice versa.
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views
We are in the process of moving from traditional hot
backups to one using RMAN. Total databases are around
200+. Should we be using 1 or few RMAN catalogs, or 1
catalog per database?
Thanks,
Deepak
__
Do you Yahoo!?
Yahoo! Tax Center - File
List - As I mentioned earlier, a new manager came from a site that regularly
rebuilt tables. I protested the value of this, but his response was well,
at least you could test it. So on a test instance I've been doing a CTAS to
create a reorganized copy of the table in the same tablespace (LMT with
Hello,
Oracle 8.1.7.4
HPUX 11.11
App is Famis Maintenance Management System
I have 3 instances TEST, TRAIN, PROD and I am trying to refresh the whole
famis schema on TRAIN with the famis schema on TEST.
Every time I try to do the import, I get compilation errors for 4 triggers
(out of 75). I
Teach me? Hell, there is more stuff in the world I don't know than I know
of! I've been wrong before and I'll be wrong again and and I hate this,
I FORGET STUFF. Easy stuff, simple stuff stuff I kick myself all over
creation because I forgot it.
Me the master, na Thats where
Rachel,
At a recent past job, under 8.1.6 on Win2k we had tables with out-of-line
CLOB segments of 30,000 extents (1MB each). Every month we dropped one to
make room for another (6 months of CLOB documents online). It always just
took a few seconds for the drop. These were in DMTs.
Later we
[EMAIL PROTECTED] wrote:
Bill,
Welcome back!!! I haven't read you in a long time. Hope all is well.
Ron
just got a 3 month contract after being out of work since the end of
june. guess that's the end of my afternoon naps, and my afternoon beer,
for a while.;-)
--
--
Bill Shrek Thater
In general, you don't need to do this in
recent versions of Oracle. Oracle knows
that all the data in the tablespace MUST
have been committed before the tablespace
was switched to read-only (you can only
switch a tablspace to readonly when there
are no active transactions that started before
[EMAIL PROTECTED] wrote:
These guys are why I think I know nothing!
yes my goddess, what ever you say my goddess.;-)
you are the reason i think i don't know anything. so guess how far
behind those guys i am.;-)
--
--
Bill Shrek Thater ORACLE DBA
[EMAIL PROTECTED]
Title: RE: RMAN Catalog: 1 vs. many - Opinions
I have setup a server for just rman catalog backed up to tape with clones offsite for DR. It makes it easier as scripts are parameterized to keep aware of backup statuses = etc. Having this on a centralized management server and can't believe
Scott, can you run this command in sqlplus and e-mail the results out to
us...
show errors trigger triggername
[EMAIL PROTECTED] 04/04/03 02:14PM
Hello,
Oracle 8.1.7.4
HPUX 11.11
App is Famis Maintenance Management System
I have 3 instances TEST, TRAIN, PROD and I am trying to refresh the
Excellent advice, Gaja! Yes, we do have OPTIMAL set. From the docs I don't
see a way to remove the OPTIMAL setting once used. I assume this means new
RBSs?
Rich
Rich JesseSystem/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
Jonathan,
It's just being used in a different context.
Jared
Jonathan Lewis [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
04/04/2003 11:23 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re: Do
Hi all,
Oracle 8172 with dedicated connections.
I've not played that much with database links.
Users from application A will accessed data from another database B with a
dblink.
Real time access is needed so no snapshot, tables and stored proc are
accessed.
There are 300 users in application A
Jacques,
As I believe has been pointed out already it may possibly be more efficient
if dept is very small and emp is very large (especially if there are filters
and a join would be done before a filter was applied). Alternatively it may
be that Oracle believe it is more intuitive to people
[EMAIL PROTECTED] wrote:
Teach me? Hell, there is more stuff in the world I don't know than I know
of! I've been wrong before and I'll be wrong again and and I hate this,
I FORGET STUFF. Easy stuff, simple stuff stuff I kick myself all over
creation because I forgot it.
yup, simple stuff
So I have DB (9.2.0.1) running on Win2K, with db_cache_size of 32M.
Windows Task Manager shows 600+ MB of free physical memory. ALTER
SYSTEM SET DB_CACHE_SIZE=50248000 SCOPE=BOTH fails with ORA-00384:
Insufficient memory to grow cache.
I'm going to try ...SCOPE=SPFILE, then bouncing the
Which way is faster? The subselect(nested select) or the join?
Thanks.
--
Lyndon Tiu
Quoting Jacques Kilchoer [EMAIL PROTECTED]:
Why would you do that instead of
SELECT emp.deptno, empno, ename
FROM emp a, dept b
WHERE dept.deptno = emp.deptno
order by dept.deptname ;
-Original
1. Dial 1-0-0-4-6.
2. Look at the latching and pinning statistics promoted at asktom, ixora,
and jlcomp.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Hotsos Clinic 101 in Chicago, London, Reykjavik, Ottawa, Denver
- Visit www.hotsos.com for schedule details...
Hey
1. you dont need to do anything with redologs either backup or restore.
2. you can use the current control file(in which case you dont have to do
anything) or use old control file.
Incase, If you use old control file with combo of current relo logs then you
need to use
They make you work in the afternoon
--Walt Weaver
Bozeman, Montana
-Original Message-
From: bill thater [mailto:[EMAIL PROTECTED]
Sent: Friday, April 04, 2003 2:29 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: linux intel support matrix
[EMAIL PROTECTED] wrote:
Title: RE: Sub-query in order by clause
I see your point. The answer to my question why would you do that instead of ... is, of course, because the other way might be faster.
Read Jonathan Lewis' earlier post, he had (as always) some good insight.
-Original Message-
From: Lyndon
Scott Stefick wrote:
Hello,
Oracle 8.1.7.4
HPUX 11.11
App is Famis Maintenance Management System
I have 3 instances TEST, TRAIN, PROD and I am trying to refresh the whole
famis schema on TRAIN with the famis schema on TEST.
Every time I try to do the import, I get compilation errors
Scott:
My first thought is to ask if there are any external references (other
schemas, SYS packages, etc.) in the triggers that may not exist in TRAIN
that do exist in TEST
Rick Weiss
-Original Message-
Sent: Friday, April 04, 2003 13:14
To: Multiple recipients of list ORACLE-L
Hello,
1 - 100 of 128 matches
Mail list logo