Re: Stored procedure memory problem

to be taken into account when doing this? Thanks in advance! Venu G. -- -- Mark J. Bobak Oracle DBA [EMAIL PROTECTED] It is not enough to have a good mind. The main thing is to use it well. -- Rene Descartes -- Please see the official ORACLE-L FAQ

Re: sql tuning help

| 190 | 12K| 2 | | | | TABLE ACCESS FULL|PHY_BOARD | 443K|5M| 3008 | | | -- -- Mark J. Bobak Oracle DBA [EMAIL PROTECTED] It is not enough to have a good mind. The main

Re: ORA-1653: unable to extend table - Why?

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). -- -- Mark J. Bobak

Re: image storage confusion ??

web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- -- Mark J. Bobak Oracle DBA [EMAIL PROTECTED] It is not enough to have a good mind. The main thing is to use it well. -- Rene Descartes -- Please see the official

RE: ORA-1653: unable to extend table - Why?

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). -- -- Mark J. Bobak

RE: raw versus Mounted File Systems

. Bobak Oracle DBA [EMAIL PROTECTED] It is not enough to have a good mind. The main thing is to use it well. -- Rene Descartes -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark J. Bobak INET: [EMAIL PROTECTED] Fat City

RE: move USERS tablespace to locally managed

are the steps I need to take? John John Dunn Sefas Innovation Ltd 0117 9154267 www.sefas.com -- -- Mark J. Bobak Oracle DBA [EMAIL PROTECTED] It is not enough to have a good mind. The main thing is to use it well. -- Rene Descartes

RE: Is nothing sacred? (Oracle vs The Experts)

=== __ Do you Yahoo!? U2 on LAUNCH - Exclusive greatest hits videos http://launch.yahoo.com/u2 -- -- Mark J. Bobak Oracle DBA [EMAIL PROTECTED] It is not enough to have a good mind. The main thing is to use it well

Re: Space management failures on autoextend datafiles

it, no problems. Anyone else heard of this behavior? I can't find anything on Metalink that fits the problem definition. Dan Fink -- -- Mark J. Bobak Oracle DBA [EMAIL PROTECTED] It is not enough to have a good mind. The main thing is to use it well

RE: Unix Q: Substring-ing an output.

how to cut the last field then pipe it to your awk command. Ok I'm getting somewhere! Rgds, Ross -Original Message- From: Mark J. Bobak [mailto:mark;bobak.net] Sent: Monday, 28 October 2002 13:54 To: Multiple recipients of list ORACLE-L Subject: Re

Re: can clustering help INSERTS ?

of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- -- Mark J. Bobak Oracle DBA [EMAIL PROTECTED] It is not enough to have a good mind. The main thing is to use it well

Re: Unix Q: Substring-ing an output.

is not consistent. As you can see I've just restarted RMAN and now it only has 8 fields as compared to 9 for the others. Any suggestions? Or another way of doing it? Using KSH on Solaris 8. Thanks. Ross -- -- Mark J. Bobak Oracle DBA [EMAIL PROTECTED] It is not enough to have a good

RE: Unix Q: Substring-ing an output.

how to cut the last field then pipe it to your awk command. Ok I'm getting somewhere! Rgds, Ross -Original Message- From: Mark J. Bobak [mailto:mark;bobak.net] Sent: Monday, 28 October 2002 13:54 To: Multiple recipients of list ORACLE-L Subject: Re: Unix Q: Substring-ing

Re: SQLPROMPT

the new user name and database as prompt eg : RR@BKPconn test/test@o8 Connected. RR@BKP Can anyone suggest a method to do this. Thanks, Deepa -- -- Mark J. Bobak Oracle DBA [EMAIL PROTECTED] It is not enough to have a good mind. The main thing is to use it well

Re: Database Creation(RANTING)

). __ Do you Yahoo!? Y! Web Hosting - Let the expert host your web site http://webhosting.yahoo.com/ -- -- Mark J. Bobak Oracle DBA [EMAIL PROTECTED] It is not enough to have a good mind. The main thing is to use it well. -- Rene

Re: ALTER SESSION SET EVENTS '...'

from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Y! Web Hosting - Let the expert host your web site http://webhosting.yahoo.com/ -- -- Mark J. Bobak Oracle DBA [EMAIL PROTECTED

RE: what is purify

(216) 781-4204 -- -- Mark J. Bobak Oracle DBA [EMAIL PROTECTED] It is not enough to have a good mind. The main thing is to use it well. -- Rene Descartes -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark J. Bobak INET

RE: Installation

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). -- -- Mark J. Bobak Oracle DBA [EMAIL PROTECTED] It is not enough to have a good mind. The main thing is to use it well

RE: Installation

list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- -- Mark J. Bobak Oracle DBA [EMAIL PROTECTED] It is not enough to have a good mind. The main thing is to use it well. -- Rene

Re: HP-UX11/Oracle 8.1.6/Constraint Question

--- === Michael P. Vergara Oracle DBA Guidant Corporation -- -- Mark J. Bobak Oracle DBA [EMAIL PROTECTED] It is not enough to have a good mind. The main thing is to use it well. -- Rene Descartes -- Please see the official ORACLE-L FAQ: http

RE: interview question ???

). __ Do you Yahoo!? Faith Hill - Exclusive Performances, Videos More http://faith.yahoo.com -- -- Mark J. Bobak Oracle DBA [EMAIL PROTECTED] It is not enough to have a good mind. The main thing is to use it well. -- Rene Descartes

Re: Interpretation of TKPROF output

] -- -- Mark J. Bobak Oracle DBA [EMAIL PROTECTED] It is not enough to have a good mind. The main thing is to use it well. -- Rene Descartes -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark J. Bobak INET: [EMAIL

RE: Re[2]: sequence numbers

class=841194713-09102002here is neither good nor bad, but thinking makes it so. -Shakespeare/SPAN/FONT/SPAN/P/BLOCKQUOTE/BLOCKQUOTE/BODY/HTML -- -- Mark J. Bobak Oracle DBA [EMAIL PROTECTED] It is not enough to have a good mind. The main thing is to use it well

Re: RMAN and TSM

and Sport to Email and Music Charts http://uk.my.yahoo.com -- -- Mark J. Bobak Oracle DBA [EMAIL PROTECTED] It is not enough to have a good mind. The main thing is to use it well. -- Rene Descartes -- Please see the official ORACLE-L FAQ: http

Re: Re[2]: sequence numbers

NewTSPAN class=841194713-09102002here is neither good nor bad, but thinking makes it so. -Shakespeare/SPAN/FONT/SPAN/P/BLOCKQUOTE/BLOCKQUOTE/BODY/HTML -- -- Mark J. Bobak Oracle DBA [EMAIL PROTECTED] It is not enough to have a good mind. The main thing is to use it well

Re: Raw versus Mounted File-systems

? Thanks -- -- Mark J. Bobak Oracle DBA [EMAIL PROTECTED] It is not enough to have a good mind. The main thing is to use it well. -- Rene Descartes -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark J. Bobak INET: [EMAIL

Re: Performance monitoring

: P.O.Box 321, FIN-00045 NOKIA GROUP, FINLAND Internet: [EMAIL PROTECTED]Mobile: +358-50-486 8043 - -- -- Mark J. Bobak Oracle DBA [EMAIL PROTECTED] It is not enough to have a good mind. The main thing is to use it well

Re: Does the case of an Oracle query statement affect query

Will there be any difference in the execution time of the same queries in Scenario 1 vs 2? Thanx in advance, Shantanu. -- -- -- Mark J. Bobak Oracle DBA [EMAIL PROTECTED] It is not enough to have a good mind. The main thing is to use it well

Re: Perl::DBI problems after charset change

to try and debug this without affecting the production systems, but has anyone encountered this before? TIA! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- -- Mark J. Bobak Oracle DBA [EMAIL

Re: Cheap table lock?

is closed. __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com -- -- Mark J. Bobak Oracle DBA [EMAIL PROTECTED] It is not enough to have a good mind. The main thing is to use it well

Re: Explain plan of a table you do not own

Managing Director ANDES Consulting BVBA www.andes-consulting.be -- -- Mark J. Bobak Oracle DBA [EMAIL PROTECTED] It is not enough to have a good mind. The main thing is to use it well. -- Rene Descartes -- Please see the official ORACLE-L FAQ

RE: Lost ofall redo logs

(or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- -- Mark J. Bobak Oracle DBA [EMAIL PROTECTED] It is not enough to have a good mind. The main thing is to use it well

RE: Lost ofall redo logs

]http://www.upf.br : -- -- Mark J. Bobak Oracle DBA [EMAIL PROTECTED] It is not enough to have a good mind. The main thing is to use it well. -- Rene Descartes -- Please see

Re: count(*)

-- -- Mark J. Bobak Oracle DBA [EMAIL PROTECTED] It is not enough to have a good mind. The main thing is to use it well. -- Rene Descartes -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark J. Bobak INET: [EMAIL

Re: Best method to move Filesystems to RAW Devices.

let me know, if any of you went through this exercise and any suggestions and tips will be more beneficial, Thanks in advance, -- -- Mark J. Bobak Oracle DBA [EMAIL PROTECTED] It is not enough to have a good mind. The main thing is to use it well

RE: count(*)

can somehow keep a trak of the count(*) of a table in its header somewhere. And yes I have tries count(1) , count(indexed_column) etc. Thanks In Advance. R.h -- -- Mark J. Bobak Oracle DBA [EMAIL PROTECTED] It is not enough to have a good mind. The main thing is to use it well

RE: ORA-04031

[mailto:[EMAIL PROTECTED]] Sent: Thursday, September 12, 2002 2:18 PM To: Multiple recipients of list ORACLE-L Subject: Re: ORA-04031 its 8.1.7.4 From: Mark J. Bobak [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED

Re: oracle sysdate problem ??

J. Bobak Oracle DBA [EMAIL PROTECTED] It is not enough to have a good mind. The main thing is to use it well. -- Rene Descartes -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark J. Bobak INET: [EMAIL PROTECTED] Fat

Optimizing Oracle by Jonathan Lewis coming to Ann Arbor, MI on Nov.

] 4412 Roosevelt, Dearborn Heights, MI, 48125, USA Please forward this to anyone you think may be interested. Thanks. -- -- Mark J. Bobak Oracle DBA [EMAIL PROTECTED] It is not enough to have a good mind. The main thing is to use it well

Re: SYSDBA privilege with ORAPWD utility

SYSDB SYSOP -- - - INTERNAL TRUE TRUE SYSTRUE TRUE 2 rows selected. Pls help me if possible. Thanks in advance. Chetan -- -- Mark J. Bobak Oracle DBA [EMAIL

RE: Index table last update?

' Neill=0D Organon (Ireland) Ltd.=0D [subscribed: digest mode] =0D The answer is the same as with heap tables. Regards, Stephane Faroult Oriole -- -- Mark J. Bobak Oracle DBA [EMAIL PROTECTED] It is not enough to have a good mind. The main thing is to use it well

Re: methodology to keep only certain programs to connect to

. Bobak Oracle DBA [EMAIL PROTECTED] It is not enough to have a good mind. The main thing is to use it well. -- Rene Descartes -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark J. Bobak INET: [EMAIL PROTECTED] Fat City

Re: ORA-04031

-mail service with MSN Hotmail. http://www.hotmail.com -- -- Mark J. Bobak Oracle DBA [EMAIL PROTECTED] It is not enough to have a good mind. The main thing is to use it well. -- Rene Descartes -- Please see the official ORACLE-L FAQ: http