Re: Reading a trace file through Oracle? POSSIBLE??

2001-03-28 Thread Mark Wagner
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

RE: Reading a trace file through Oracle? POSSIBLE??

2001-03-25 Thread Steven Baldwin
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

Re: Reading a trace file through Oracle? POSSIBLE??

2001-03-23 Thread Mark Vandenbroeck
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

RE: Reading a trace file through Oracle? POSSIBLE??

2001-03-22 Thread Steven Baldwin
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

Re: Reading a trace file through Oracle? POSSIBLE??

2001-03-22 Thread Michael A. Chase
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?

Re: Reading a trace file through Oracle? POSSIBLE??

2001-03-22 Thread Mark Wagner
PROTECTED]] > Sent: Friday, 23 March 2001 4:21 AM > To: [EMAIL PROTECTED] > Subject: Reading a trace file through Oracle? POSSIBLE?? > > > I am working on making a tool with perl DBI/DBD Oracle to document Oracle > Databases... One of the things I want to do is back the contro

RE: Reading a trace file through Oracle? POSSIBLE??

2001-03-22 Thread Steven Baldwin
rs, Steve -Original Message- From: Mark Wagner [mailto:[EMAIL PROTECTED]] Sent: Friday, 23 March 2001 4:21 AM To: [EMAIL PROTECTED] Subject: Reading a trace file through Oracle? POSSIBLE?? I am working on making a tool with perl DBI/DBD Oracle to document Oracle Databases... One of the things

Reading a trace file through Oracle? POSSIBLE??

2001-03-22 Thread Mark Wagner
I am working on making a tool with perl DBI/DBD Oracle to document Oracle Databases... One of the things I want to do is back the control file up to the trace file then read the trace file. But heres the *hard* part: I am not running this locally so using sql*net to connect to Oracle with perl