Re: Table recovery from RMAN backup

an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Andy Rivenes

Re: Table recovery from RMAN backup

heard some positive comments about Robert Freeman's book. Thanks Sami Andy Rivenes Email: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Andy Rivenes INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

Re: Configuring Veritas Netbackup Question

successful file osmtab01.dbf is on volume 520102 sbtopen for input successful file was created by this program; seed=3079447437, bufsize=16384, bufcount=100 sbtread successful, read 100 buffers sbtclose successful after sbtread sbtremove successful *** The SBT API test was successful *** Andy

Re: 10046 level 8 trace - help required with 'direct path

Looks sort spillage to disk due to the where clause. Andy Rivenes [EMAIL PROTECTED] At 06:44 AM 10/30/2003 -0800, Tim Onions wrote: Gurus I've applied many of the things I've learnt from this list over the years and today I tried a 10046 trace for the first time on a reported slow transaction

Re: RMAN: SVR4 Error: 27: File too large

that you don't have any datafiles larger the 2GB as well. Andy Rivenes [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Andy Rivenes INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: 10046 level 8 trace - help required with 'direct path

Hi John, don't know other than what you have speculated on. We would have to have more info to investigate further. Andy Rivenes [EMAIL PROTECTED] At 10:39 AM 10/30/2003 -0800, you wrote: Tim, As you have seen, this is due to writes to and reads from the TEMPORARY tablespace of that user

RE: full recovery

the restorebackuppiece statement for each backup piece in the backup set. END; / After you have successfully restored the control file, you can mount the database and perform restore and recovery operations.” Andy Rivenes [EMAIL PROTECTED] At 12:24 PM 10/24/2003 -0800, you wrote: AK Since extracting

RE: download metalink articles - save target as

And easier way is to use a Netscape browser and the Save Frame As... option. Andy Rivenes At 04:24 AM 9/23/2003 -0800, Boivin, Patrice J wrote: The grueling method is... grab the header, copy paste it into notepad.exe. That strips the weird formatting out of it. Grab the body text, but not all

Re: How to find the session holding the library cache pin.

send the HELP command for other information (like subscribing). Andy Rivenes Email: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Andy Rivenes INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

Re: strange library cache lock/ping wait event

You can try this script and see if it works for your situation. We had an elusive problem like this that we were able to gain more information about using this query: -- FILE: libcache_lock.sql -- -- AUTHOR: Andy Rivenes -- -- DATE: 01/22/2003 -- -- DESCRIPTION: -- Query

Re: Oracle E-Business Suit 11 i /Oracle Financials upgrade to

of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Andy Rivenes Email: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ

Re: Script to check for errors

to run often, but only email when an error is found. I've got something that does a bit of that and runs twice a day, but always sends out. Thanks. Maks. Andy Rivenes Email: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Andy Rivenes INET: [EMAIL

Re: v$sqlarea v$session

moment. The question is at the every bottom. So exactly how do I join V$SQLAREA to V$SESSION? Andy Rivenes [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Andy Rivenes INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: ``SQL*Net message to client`` Wait event with no SQL*Net

that misapprehension :) Jay Andy Rivenes [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Andy Rivenes INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: access to oracle $ tables in 9.2.0

. How about a fountain of intelligence? Andy Rivenes Email: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Andy Rivenes INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

RE: RMAN Reporting?

could get this info out of the RMAN tables but it's looking like that's just wishful thinking. -w Andy Rivenes [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andy Rivenes INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http