Dear list,
I found something rather interesting on MetaLink today.
While doing a little research on UTL_FILE, I came across
document # 1050919.6. This document deals with how to
dump a table to an ascii file.
Title: Can't create job...
Hi!
I'm experiencing a weird problem here... Why can't I create this job???
SQL variable jobno number;
SQL begin
2 dbms_job.submit(:jobno, 'PROBLEM_MELDUNG', sysdate, 'sysdate+1/3600');
3 commit;
4 end;
5 /
begin
*
ERROR at line 1:
ORA-06550: line 1, column
I've learned that those two emotions are not mutually exclusive.
If you name's not in Oracle's source code somewhere, then I'd suggest
you write someone at Oracle a note. It's an easy problem for them to
solve.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
-
Jared,
You should feel upset as well as flattered. In my view you have a strong
case against Oracle for some form of compensation, as a minimum you should
be credited in the article.
Whether you can win against a big corporation is another matter of course.
I and many others can confirm that the
Reminds me of a famous quote
'Copying from one author is plagiarism, and copying from multiple authors is
research'
:-)
Naveen
-Original Message-
Sent: Thursday, October 10, 2002 12:43 PM
To: Multiple recipients of list ORACLE-L
Dear list,
I found something rather interesting on
THX
Investigation revealed that this one directory belonged to root(?).
Jack
-Original Message-
Sent: Wednesday, October 09, 2002 7:14 PM
To: Multiple recipients of list ORACLE-L
Are privileges of the oracle user and the directory where the alert log goes
the same for all three
Title: Can't create job...
Like
the previous mail, add a semi-colon at the end of the PROBLEM_MELDING (i.e.
'PROBLEM_MELDING;')
-Original Message-From: Daiminger, Helmut
[mailto:[EMAIL PROTECTED]]Sent: Thursday, October 10,
2002 10:58 AMTo: Multiple recipients of list
Ian,
You need TDP installed on all target nodes, however you don't need TDP
installed on the node where the catalog resided. Also, you need only one
tdpo.opt per node, but don't need one for the catalog ('cos TDP will not be
installed there).
We have always used the default of adsmorc for
There is a Metalink note (73431.1) which talks about
the rman version compatibility, but it also states:
Ensure that the RMAN executable version matches the
version of the target database that it is backing up
which I presume to mean that you need to run rman from
each target and push to the
Just tell them you'll happy with a small amount of
acknowledgement...say, a 4-node Tru64 cluster with 9.2
rac and a year's free support.
Cheers
Connor
--- Jared Still [EMAIL PROTECTED] wrote:
Dear list,
I found something rather interesting on MetaLink
today.
While doing a little
Hello
all,
I have a client who will
be doing the data capture and give me the data in a flat
file.
what i need to do in
oracle is load from that flat file to my database.
any scripts
available ?? please send me across. ASAP
Thanks and regards,Santosh
so if it's waiting for any active transaction, I guess you could put
the database in restricted mode until existing transactions complete.
Of course, that sort of defeats the purpose of putting it in read-only
so other people can access it.
um, 9ir2 has an export parameter of tablespace, if you
Joshua,
There are papers on the internet, I have two papers on my site (not done
by me, so I can advertise). But one thing I should point out to you: the
size of the database is not important for buying storage. It is the
number of users and the number of I/O operations per second that the I/O
you put the code out in the world without a comment in it about copying
is not allowed and you've made it free for the taking.
Compensation isn't likely. Credit is definitely due and should be
given.
--- [EMAIL PROTECTED] wrote:
Jared,
You should feel upset as well as flattered. In my view
Lookup SQL*Loader
-Original Message-
Sent: 10 October 2002 11:59
To: Multiple recipients of list ORACLE-L
Hello all,
I have a client who will be doing the data capture and give me the
data in a flat file.
what i need to do in oracle is load from that flat file to my database.
At least they TOLD me that if I ever get our Unique configuration for
Apps to work they expect me to write thier documentation for them
April
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 10/10/2002 2:13 AM
Dear list,
I found something rather interesting on
Santosh.
Putting a subject on your e-mails is useful to everyone
I suggest you look at sqlloader. There are some good pages on the FAQ
associated with this site
http://www.orafaq.com http://www.orafaq.com
HTH
John
-Original Message-
Sent: 10 October 2002 11:59
To: Multiple
Title: RE: DROP DEVELOPER not working
(taking a cue from RMAN syntax)
drop developer developer_name from third_floor position upside_down immediate
/
works for me all the time ... (sorry couldn't resist ... I have been a developer too for 8+ years)
BTW 10046 will write the sql statement
Does anyone know if it is possible to create a user who only has rights to
Shutdown a database?. I'm thinking about scenario that if the password for
this user were ever compromised, e.g. seen in a script then worst case
scenario would be database might be shutdown. Indulge me on this please as
We are in the midst of a big move to RMAN. We use EMC's EDM to do
backups, and the SAs have been pushing us towards RMAN for a while now,
cause the EDM interface intergrates w/ RMAN seamlessly. It really is a
nice backup solution. (We started the process by upgrading all our EDM
units to 5.0)
is there any strategy from oracle in bioinformatics?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: [EMAIL PROTECTED]
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web
Sean,
The role sysoper is already provided
Details are
There are two main administrative privileges in Oracle: SYSOPER and SYSDBA
These are special privileges as they allow access to a database instance
even when it is not running and so control of these privileges is totally
outside of the
You have got SQLLoader example scripts on your PC/laptop on which Oracle is
installed.
Check out C:\ORACLE\ORA81\RDBMS\DEMO on your Windows Installation. You will
find scripts names UTCASEn.CTL.
Edit these scripts to relfect your destination table, fields and you will be
done.
Moses Moya
Why don't you just to a consistant export? That will not take any
transaction after the start of the export, at leasst this is how I
understand it.
Ruth.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, October 09, 2002 4:48 PM
I am
Russ - What do you have in mind? Oracle stores numbers in its own format in
its own datafiles. Are you looking to hack the Oracle datafiles? Or do you
have an input file in packed decimal format that your are looking at loading
into Oracle? If you could tell us the objective you are seeking to
Henry - One idea for you to try is to nice the import job when you start
it. Check your O.S. documentation for available values. This has helped me
on some jobs that have tended to overwhelm the online users. Just a thought.
Good luck, sounds as if you may have other system problems.
Dennis
On Wed, Oct 09, 2002 at 09:18:30PM -0800, Joshua Becker wrote:
INDEX ORACLE-L
indexing here won't help...
-
ListGuru GENERAL Command HELP
-
This help file
Anjo,
I'm pretty sure Jared would let you advertise papers you wrote as well
as papers written by others!
We are installing new servers, new data center, new apps, new
databases. I have been given NO input into the decision-making process,
other than to tell them how large my databases will
Jared,
I think you have a case for at the very least getting credit for your work.
It's one thing for someone to see what you've done and use the functionality
like you did.
It's completely something else for someone to lift all the code verbatim
without even changing a comment. It just shows
Well, our new Oracle Press Oracle9i RMAN Backup and Recovery book is
at the printer. We have a sample chapter available and TOC for you all
to look at if you like. Here is the URL:
http://shop.osborne.com/cgi-bin/osborne/0072226625.html
Enjoy!
Robert
Robert G. Freeman - Oracle OCP
Oracle
Or, if money is no object, then you can use Shareplex from Quest. It can
replicate from one platform to another.
Gerardo
-Original Message-
Sent: Wednesday, October 09, 2002 8:04 PM
To: Multiple recipients of list ORACLE-L
One needs to use export/import while changing hardware
Title: Message
Hello all
HELP - and I am not an idiot.
Oracle 8.1.6.3.4 on NT.
We have a problem that the datafile for the
application tables autoextended from 3.9 GB to 4.1 GB.
We are getting ora-01115 errors and the datafile is
offline.
We tried export but it gets the same error.
The
Not interested in compensation. Just a litte irritated that
the only change to the script was to remove my name.
Jared
On Thursday 10 October 2002 04:08, Rachel Carmichael wrote:
you put the code out in the world without a comment in it about copying
is not allowed and you've made it free
Jared,
Should you be irritated? I've had some of the things I published on the
list put out as gospel elsewhere with my name attached it's been a real pain
in the ^^$. I don't know. I think I'd feel flattered and relieved that no one
knows where it came from.
Dick Goulet
how 'bout a reverse bitmap hash-partition leading-edge index?
-Original Message-
Sent: Thursday, October 10, 2002 9:39 AM
To: Multiple recipients of list ORACLE-L
On Wed, Oct 09, 2002 at 09:18:30PM -0800, Joshua Becker wrote:
INDEX ORACLE-L
indexing here won't help...
Please forgive the cross postings, but I am hoping that someone in all of
the sets of eyes that see this might have an idea I haven't thought of.
***
Facts
**
aix 4.3.3
oracle 9.0.1.3
new instance, up for 2 weeks
locally managed tablespaces
nothing with
It is not the export per se that causes the problem. It is the copying of
the datafile that is the issue. The tablespace must be made read only so
that the datafile can be copied in a consistent version. I can understand
(and support) no active tx in the tablespace, but why the whole (*#(*$#
Title: Message
Note #
148894.1 on Metalink has a possible solution...
NT has a limit of 4GB for the file size :(
-
Kirti
-Original Message-From: Yechiel Adar
[mailto:[EMAIL PROTECTED]]Sent: Thursday, October 10, 2002 10:08
AMTo: Multiple recipients of list ORACLE-LSubject:
BITMAP INDEX ORACLE-L TABLESPACE LOST_IN_SPACE STORAGE (INITIAL 1M NEXT 1M)
-Original Message-
From: Joshua Becker [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 10, 2002 1:19 AM
To: Multiple recipients of list ORACLE-L
Subject: Index Oracle-l
INDEX ORACLE-L
Henry,
I had a similiar situation occur recently on HPUX, Oracle 817. CPU was
pegged out and users were complaining of taking over 5 minutes to quey one
record (usually took 5 seconds). It was a matter of statistics not being
present on certain schema. A quick analyze cleared it all up. Just
Raj,
I'll take OTS's point of view on the subject, namely if the duhveloper can
drop the table via SQL*Plus then he needs to call the vendor of the third party
application. The database responds to a command the same way no matter where
the command is issued from if it is complete and
That would be one option, but we are trying to avoid the overhead of the
import process as we move the data to a new database. This process will
happen daily and transporting a tablespace and plugging in a datafile is
perceived to be faster (has not been tested yet).
Dan
-Original
Unfortunately, our company is large enough that no one
ever really has to admit to anything because it is
simply too difficult to run down the perpetrators.
The listener did start. Some users could connect to
the databases from one server but not another. We
think it was related to an
Title: RE: DROP DEVELOPER not working
I hear
that they are enhancing that command in 10i. You know have the option of naming
the employment position:
drop
manager
drop
user
drop
cow-worker
etc...
I
recall that in Unix, the trace file is written right away, but NT waits for the
process
Congratulations, Robert!!
Looking forward to receiving my copy...
- Kirti
-Original Message-
Sent: Thursday, October 10, 2002 9:59 AM
To: Multiple recipients of list ORACLE-L
Well, our new Oracle Press Oracle9i RMAN Backup and Recovery book is
at the printer. We have a sample
April:
I'm just guessing here, but is it a journaling file system?
Could the journal be eating up your available space?
HTH,
Mike
-Original Message-
Sent: Thursday, October 10, 2002 8:14 AM
To: Multiple recipients of list ORACLE-L
Please forgive the cross postings, but I am hoping
DROP COW-WORKER only works here in the Dairy State... ;)
Rich
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
-Original Message-
Sent: Thursday, October 10, 2002 11:09 AM
To: Multiple recipients
Wow! That's the way to have your name remembered for eternity!
Having your name carved in stone is one thing, but having your name
embedded into the oracle source code is something much better.
Jared, in a few millenniums, with Oracle 256(i?) you'll be one of
the most celebrated individuals in
And I Used oradebug at level 12 and set the file size to unlimited, and I
am not running out of space in the udump destination. So, why dont I see
the execution plan?
- Forwarded by Rajesh Rao/CHASE on 10/10/02 11:22 AM -
Santosh,
The Oracle Utilities manual is not bad either, it explains sqlldr and
export and import, all database utilities that come with the database.
Find it at the Oracle web site if you don't have a copy.
I suggest you look at sqlloader. There are some good pages on the FAQ
associated
More than separate ORACLE_HOMEs, you might also consider individual oracle
software owner accounts and dba and oper groups for each database...
Folks often install all Oracle distributions under a single account,
oracle, specifying a single SYSDBA group (dba) and a single SYSOPER
group (oper).
Title: RE: DROP DEVELOPER not working - 10046 trace
execution plan comes at the end ... that's why ...
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't
Good morning,
if it is good, which I doubt...
It is not Oracle database problem, unfortunately is showing within Oracle, so...need I
say more?
I wonder if any of you had a misfortune (which I truly hope one had) of running into
the PC set-up problem, which generates the error:
FRM-9:
But can you know for sure if an open txn will hit your tablespace until the
txn is closed?
Henry
-Original Message-
Sent: Thursday, October 10, 2002 11:39 AM
To: Multiple recipients of list ORACLE-L
It is not the export per se that causes the problem. It is the copying of
the datafile
Jared,
Yes, you should be both.
Well, this not a legal advise, just my personal view:
I would find a layer, who specialises in the intellectual property laws, sue Oracle
... and settle.
Add a clause to the header, which will allow for usage of your scripts the way you
mean it.
For all those
Which files were being reported in the ORA-01114s? Could you provide more
info as to the exact architecture of the db files and file system. For
example, is it a single file system and ALL database files (including redo
logs/archived logs/temp files/...) are stored on it. Are the control
Title: Message
Looks
like your stuck... Maybe someone else can help... Good luck...
Doc
ID:
Note:148894.1
Subject:
ALERT: Problems with Datafile AUTOEXTEND/RESIZE on Oracle8i on
As I was investigating more on this issue, I took a close look at the
select statement which runs just before the drop. Isnt this select
statement supposed to have a STAT with the execution plan in the 10046
trace file. Why dont I see it here? The entries in the trace file are :
PARSING IN
Title: Message
This is interesting. I had a vendor do an install on
one
of our NT servers, and they set the files to autoextend
to
8GB. When I modified that limit down to 2GB (our
company
standard) they clouded up and rained all over
me! They said
there was no physical reason to limit the
Actually, Oracle 256i is slated for a June, 2012 release.
-Original Message-
Sent: Thursday, October 10, 2002 11:39 AM
To: Multiple recipients of list ORACLE-L
Wow! That's the way to have your name remembered for eternity!
Having your name carved in stone is one thing, but having
Is journaling, but journal isn't in that file system, just on the raw part
of the volume group
April Wells
Oracle DBA
Keep yourself well oiled with life, laughter, new ideas and action.
Otherwise you will rust out. _Anonymous
-Original Message-
Sent: Thursday, October 10, 2002 11:29
Execution plan is not generated by using event 10046 for tracing.
If you using 8i+, there is a way to prevent owner of the table from
performing ddl.
Here's a post by Joe Testa quite some time ago.
And I have used this process successfully.
HTH,
- Kirti
On Thu, 6 Jan 2000, Joseph Testa
Are you sure an index is appropriate? Will it actually reduce the LIOs or
will it artifically inflate the BCHR? This is just the kind of thinking that
Cary is trying to eradicate!
-Original Message-
Sent: Thursday, October 10, 2002 9:14 AM
To: Multiple recipients of list ORACLE-L
how
Dick,
the difference is that Oracle is a corporation that is making money on
someone else's work. they are quick to hammer the people we work for over
license issues and, in this case, use someone elses work as a part of their
software suite.
it's not right.
Tom Mercadante
Oracle Certified
Are you using tempfiles ?
Just a hypothesis: Tempfiles are created sparse, so
you ask for 100M, but in reality only 1M might be
allocated. As people sort, you actually start needing
the 100M and kapow!
hth
connor
--- April Wells [EMAIL PROTECTED] wrote: Please
forgive the cross postings,
I hope it meets everyone's expectations. We worked like dogs to get this one
done by OOW.
RF
Robert G. Freeman - Oracle OCP
Oracle Database Architect
CSX Midtier Database Administration
Author of several Oracle books you can find on Amazon.com!
Londo Mollari: Ah, arrogance and stupidity all in
Position: Oracle Financials DBA
Location: New York, New York
Industry: Financial Institution
Salary Range: Up to 120K-depends on experience.
* This company may consider candidates outside the Greater New York City area
who have the skills outlined below and are willing to pay thier own
April - This is what I hear you saying:
- The database was set up on a file system, and there was room to spare.
- The file system ran out of space.
- Don't know what occurred to take up space, there should have been
nothing.
- The situation is fixed now. HOW??
If the above is true, I
CACHE 20 is the default, so if you remove the clause, it
will have absolutely no impact on performance or anything else...
...of course, I get the feeling that that wasn't the gist
of your question, was it?
- Original Message -
From:
April Wells
To: Multiple recipients
SQL*Loader understands how to translate PACKED and
ZONED DECIMAL format; pretty sure that PRO*Cobol does as well, though I
don't do Cobol...
If you're interested in conversion routines, I've a
"C" function named "ptof()" that converts packed-decimal to
floating-point; wrote it 10 years ago
Probably due to tempfiles in your TEMPORARY tablespace...
Tempfiles are sparsely populated files (not certain if that is the correct
term). That is, if you display them with the command ls -l, you'll see
them apparently consuming the full amount of space you specified when you
created them.
That's interesting. I'd heard it was for OpenWorld '07.
John P Weatherman
Database Administrator
Replacements Ltd.
-Original Message-
Sent: Thursday, October 10, 2002 1:04 PM
To: Multiple recipients of list ORACLE-L
Actually, Oracle 256i is slated for a June, 2012 release.
Anything reported in the system logs?
Can you get the SAs to run the 'errpt' report to make sure there were no
disk related problems.
Do the permissions on the mount point directory keep others away?
Once I had a smart developer(and a newbie DBA), who pointed his vi
'directory' to one of the
Forehead Slap D'OH!
You are absolutely correct. I completely overthought the issue and missed
the obvious.
Thanks Henry
-Original Message-
Sent: Thursday, October 10, 2002 11:09 AM
To: Multiple recipients of list ORACLE-L
But can you know for sure if an open txn will hit your
I am not talking of the execution plan for the drop table statement, but
for the select that's run prior to it? I opened a TAR for it, and Metalink
states: sql trace messages are not in sync with the session. Some
messages will only dump to trace when the cursor is closed, or the program
Thanks Dennis! I'm sitting here dying because one of my stereo headphone
speakers i do ng t is t m ri gt n w.
ARRRUUU.
Robert G. Freeman - Oracle OCP
Oracle Database Architect
CSX Midtier Database Administration
Author of several Oracle books you can find on Amazon.com!
Londo
May I offer my Oracle9i New Features book as one source of preparation.
While it does not cover 100% of the 9i OCP objectives (nor was it intended
too), I think you will find it a
good introductory guide to 9i and the new features you will need to know
about.
I also agree with others here that
From Oracle's Terms of Use on Metalink...
Confidentiality
---
Except for information in Web sites controlled by third parties that are
accessible via hyperlinks from the MetaLink Web site, the information
contained in the Materials is the confidential proprietary information of
ah! transportable tablespaces? you did't SAY that
--- Fink, Dan [EMAIL PROTECTED] wrote:
It is not the export per se that causes the problem. It is the
copying of
the datafile that is the issue. The tablespace must be made read only
so
that the datafile can be copied in a consistent
[EMAIL PROTECTED] wrote:
We have a developer here, installing a third party application, who claims
one of his delete campaign process is hanging. I looked at the wait
events, saw nothing, and asked him to politely to go look at the code.
After much analysys, the developer now complains,
Thanks Kirti. While I cannot stop drops completely, I am thinking I could
use dbms_system with the scripts, to write to the alert log whenever a
drop statement is executed.
And by the way, I did a level 12 trace, and for the statements it does put
in the execution plan :
PARSING IN CURSOR #3
Oh good... isn't that special...
du -k says they are 3401728 k... not 'quite' 4000 meg... that makes sense.
anywhere I can look this up to do more research (ie... is there a friendly
manual)?
April Wells
Oracle DBA
Keep yourself well oiled with life, laughter, new ideas and action.
Otherwise
2007 would not give enough time to complete the class time for the more rigorous OCP
256i requirements. Quit spreading false rumours.
-Original Message-
Sent: Thursday, October 10, 2002 2:28 PM
To: Multiple recipients of list ORACLE-L
That's interesting. I'd heard it was for
Robert,
If you don't mind , both books are good as I passed my 9i upgarde with the
help of both books and I shall give credit to you and Daniel for writing
these books. However, yours was the first one which I bought sometime in
Jan'2002 and his book was released end March, 2002.
Thanks
Yes,Let me know is any other way except EXPORT/import I can do ?
Thx
-Seema
From: Deshpande, Kirti [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: SOLARIS to linux
Date: Wed, 09 Oct 2002 19:03:41 -0800
One needs to use
I agree! Stick it to 'em. They do it to us all the time. Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, October 10, 2002 3:24 PM
From Oracle's Terms of Use on Metalink...
Confidentiality
---
Except for information
At the OS level, the files are 4000 meg. If they are created sparse, would
it show at the OS level?
April Wells
Oracle DBA
Keep yourself well oiled with life, laughter, new ideas and action.
Otherwise you will rust out. _Anonymous
-Original Message-
Sent: Thursday, October 10, 2002
Hi list
Can anyone explain me what exactly does the WAIT
I/O column of the sar -u output mean?
Does it represent the % of CPU used by the kernel
processes to perform I/O?
As far as I know the waiting processes do no wait
actively when they ask for an I/O. right? The OS uses
the SLEEP
Sorry, I did not pay attention to what level trace you were generating... :(
- Kirti
-Original Message-
Sent: Thursday, October 10, 2002 2:25 PM
To: Multiple recipients of list ORACLE-L
Thanks Kirti. While I cannot stop drops completely, I am thinking I could
use dbms_system with the
is there any strategy from oracle in bioinformatics?
Oracle has application software they call Oracle Clinical. Apparently it is
designed to support clinical trials of new drugs.
If you find out more on this topic I hope you'll post it to this list.
--
Please see the official ORACLE-L FAQ:
That is it EXACTLY... thank you.. it was created sparsely, du -ak gives what
df -k believes, but ls -al gives what Oracle thinks it is... Now if I can
just find the manual to research the logic behind why.
Okay... Oracle's answer was it can't happen, therefore it didn't happen and
it therefore
Seema
Perhaps you can give us some idea of why export/import is unsatisfactory
for your purposes. Too much data? If so, how much data? Too small an amount
of time for production to be down?
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Thursday,
Whoa Stephane You might be onto something here. The developer
confirmed that they do use Pro*C and cursors in the process. Will
investigate.
Thanks a ton
Raj
Pablo - I posted the following paragraph yesterday:
3) I looked in Oracle Performance Tuning 101 to see what Gaja has to say.
He points out that the Solaris sar -q command has a %wio column, a measure
of processes that are currently using the CPU, but are waiting for I/O
requests to be serviced
How about a database link?
--Walt (RTFM are my middle initials) Weaver
Bozeman, Montana
-Original Message-
Sent: Thursday, October 10, 2002 2:04 PM
To: Multiple recipients of list ORACLE-L
Yes,Let me know is any other way except EXPORT/import I can do ?
Thx
-Seema
From:
Raj,
This reminds me of a similar situation I encountered several years
ago, perhaps there will be something in it that will help...
A 3rd party app was periodically committing only 2 of 3 changes that
were required. The most likely explanation of the problem was that there was
an
That information is not relevant and should be ignored. I would expect YOU
to know as much!
-Original Message-
Sent: Thursday, October 10, 2002 1:25 PM
To: Multiple recipients of list ORACLE-L
ah! transportable tablespaces? you did't SAY that
--- Fink, Dan [EMAIL PROTECTED] wrote:
Dennis:
Thanks for answering, what do you mean by, or may
be what do you think Gaja means by:
He points out that the Solaris sar -q command has a
%wio column, a measure of processes that are
currently using the CPU, but are waiting for I/O
requests to be serviced and hence are not making
Dennis:
Thanks for answering, what do you mean by, or may
be what do you think Gaja means by:
He points out that the Solaris sar -q command has a
%wio column, a measure of processes that are
currently using the CPU, but are waiting for I/O
requests to be serviced and hence are not making
The STAT lines are emitted into the trace file only when a cursor
closes. I wish the kernel would emit them right after the plan is
constructed, but it's just not the way it works.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Hotsos Clinic, Oct 15-17 Dallas,
1 - 100 of 130 matches
Mail list logo
