Actually I don't think you can, I can't find maxdatafiles and
maxinstances in any V$ table
Do you know where I can Find think information?
Thanks
Mark
On Fri, Mar 23, 2001 at 10:06:55AM +0100, Mark Vandenbroeck wrote:
> Mark,
>
> Is this really necessary ? All you can find in the con
st, and tidy up
after itself. I'm sure you know how to do all that.
Having said all this, it will work, but for large files, it'll probably be
pretty slow.
Hope this helps,
Steve
-----Original Message-----
From: Mark Wagner [mailto:[EMAIL PROTECTED]]
Sent: Friday, 23 March 2001 8:47 AM
T
Mark,
Is this really necessary ? All you can find in the controlfile tracefile,
you can also find in the V$ views, and much easier : everything (and much
more) is there neatly organized and you can use simple SQL statements. Check
the "Server Reference" for more information.
Brgds,
Mark
Mark
Just thinking a bit more, if you are using 8i, you could use PL/SQL to read
the file, and insert into a table of type GLOBAL TEMPORARY, and then just
fetch from the table in a single array operation. Probably be much lighter
on the network. However, same caveats apply as to the entry in the
init
fish for an age.
- Original Message -
From: "Mark Wagner" <[EMAIL PROTECTED]>
To: "Steven Baldwin" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, March 22, 2001 1:46 PM
Subject: Re: Reading a trace file through Oracle? POSSIBLE??
> Can that be done through dbi?
Can that be done through dbi?
if so, would you mind giving me an example??
Thanks
Mark
On Fri, Mar 23, 2001 at 07:58:45AM +1100, Steven Baldwin wrote:
> Mark,
>
> If you use the PL/SQL utl_file package, this runs on the server, regardless
> of where it is executed from, so can read the trac
Mark,
If you use the PL/SQL utl_file package, this runs on the server, regardless
of where it is executed from, so can read the trace file. Furthermore, it
is executed as an 'oracle' owned process, so has the appropriate
permissions.
Let me know if you need any more help.
Cheers,
Steve
-