RE: may not be necessary -- was RE: Oracle DB Backups on SAN

2003-03-29 Thread Hemant K Chitale
Chris, What I plan to do is to issue the series of ALTER TABLESPACE BEGIN BACKUP commands, to cover all the tablespaces, _before_ the Snaphshot is created and then issue the ALTER TABLESPACE END BACKUP commands, without using the ALTER SYSTEM SUSPEND. I will be referring to

Archive of all our postings at BlackSheepNetworks

2003-03-29 Thread Hemant K Chitale
Guys, Are you aware of the archives of all our postings to ORACLE-L at http://www.blacksheepnetworks.com/security/resources/oracle-mailinglist/author.html Hemant K Chitale My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net --

Re: optimal set up of tablespaces on disks??

2003-03-29 Thread Peter R
Thank you Jared!! Mine is OLTP, I need to more room for Data/indexes. I had that book, May be I need to refer again to understand more. Thanks again. From: Jared Still [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re:

Re: Archive of all our postings at BlackSheepNetworks

2003-03-29 Thread Stephane Faroult
Hemant K Chitale wrote: Guys, Are you aware of the archives of all our postings to ORACLE-L at http://www.blacksheepnetworks.com/security/resources/oracle-mailinglist/author.html Great resource for spammers. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author:

Re: Archive of all our postings at BlackSheepNetworks

2003-03-29 Thread Jared Still
Archives of this list are and have been posted at several places. Not much you can do about it. Jared On Saturday 29 March 2003 08:48, Hemant K Chitale wrote: Guys, Are you aware of the archives of all our postings to ORACLE-L at

Where's my trace file?

2003-03-29 Thread Daniel W. Fink
Tired of wading through the long list of trace files to find yours? Here is a quick script to find your sessions process id, which is part of the trace file name. select s.sid, s.serial#, s.username, s.osuser, p.spid from v$session s, v$process p where s.sid = (select sid from v$mystat where