Re: pga workarea and ora-04030

2004-01-20 Thread Connor McDonald
). = Connor McDonald Co-author: Mastering Oracle PL/SQL - Practical Solutions - available now web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day

Re: Import foibles

2004-01-14 Thread Connor McDonald
also send the HELP command for other information (like subscribing). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer

RE: Should we stop analyzing?

2004-01-13 Thread Connor McDonald
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). = Connor McDonald web

Re: What is the fastest way to dump oracle data into a human

2004-01-11 Thread Connor McDonald
(like subscribing). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day

Re: Export bigger then 2G with Oracle7.3.4

2004-01-09 Thread Connor McDonald
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). = Connor McDonald web: http://www.oracledba.co.uk web: http

Re: Book (was) oaktable people

2004-01-07 Thread Connor McDonald
I'm saving that for the Hotsos symposium --- Daniel W. Fink [EMAIL PROTECTED] wrote: Who cares about the profanity Do you a) pound nails in a squirrel and b) force David Kurtz to consume massive amounts of gin whilst lobbing Fosters at the audience? Connor McDonald wrote: I

RE: HOTSOS Conference

2004-01-06 Thread Connor McDonald
of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how

Re: D'oh, forgot my title! (Bit twiddling and bit manipulation...)

2004-01-06 Thread Connor McDonald
, 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). ATTACHMENT part 2 application/ms-tnef name=winmail.dat = Connor McDonald web: http://www.oracledba.co.uk

RE: Book (was) oaktable people

2004-01-06 Thread Connor McDonald
to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit

Re: Correct way to accuse BCHR tuning method (Was: Hit ratio)

2003-12-29 Thread Connor McDonald
(or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH

Re: RE: Hit Ratio

2003-12-23 Thread Connor McDonald
') 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). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email

Re: 10g new features question for beta testers

2003-12-22 Thread Connor McDonald
herding cats. Kevin Loney, Oracle DBA Handbook Oh no, it's not. It's much harder than that! Bruce Pihlamae, long-term Oracle DBA -Original Message- Connor McDonald Sent: Saturday, December 20, 2003 2:34 AM To: Multiple recipients of list ORACLE-L As with anything I suppose

Re: Finally! The RAID F Simulator is here ( and attachedd )

2003-12-22 Thread Connor McDonald
; Drop FUNCTION NUM_TO_BIN ; Drop TABLE RAID_Raw ; Drop VIEW RAID_Volume ; = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer

Re: Using dbms_stats.auto_sample_size in dbms_stats.

2003-12-22 Thread Connor McDonald
. = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day

Re: RE: 10g new features question for beta testers

2003-12-19 Thread Connor McDonald
). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day

Re: _index_join_enabled in 9i

2003-12-04 Thread Connor McDonald
you to carry out your own virus checks before opening any attachment. = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all

Semi-OT...dbazine

2003-11-28 Thread Connor McDonald
Anyone noticed www.dbazine.com... This domain has temporarily been disabled. To restore the domain, contact your Customer Support. Ooops... = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day

Re: really annoying utl_file problem

2003-11-14 Thread Connor McDonald
subscribing). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day

RE: Interesting PL/SQL Puzzle

2003-11-09 Thread Connor McDonald
for other information (like subscribing). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day

Re: Wow, Man, Flashbacks!

2003-11-07 Thread Connor McDonald
: 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). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat

RE: Coalescing tablespace

2003-10-27 Thread Connor McDonald
for other information (like subscribing). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day

Re: Re: dba interview questions

2003-10-25 Thread Connor McDonald
, 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). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE

Re: WHERE 1 = 1 (any info on this)

2003-10-21 Thread Connor McDonald
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). = Connor McDonald web: http://www.oracledba.co.uk web

RE: how to keep statistics up to date for CBO

2003-10-09 Thread Connor McDonald
: 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). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he

RE: RE: Cary's Book - new topic

2003-10-08 Thread Connor McDonald
: 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). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he

Re: Deterministic Functions: am I missing something?

2003-10-03 Thread Connor McDonald
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). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man

RE: Deterministic Functions: am I missing something?

2003-10-03 Thread Connor McDonald
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). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED

RE: RE: Separate Indexes and Data

2003-10-01 Thread Connor McDonald
for other information (like subscribing). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day

RE: guidance

2003-09-27 Thread Connor McDonald
). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day

Re: Job queue process

2003-09-26 Thread Connor McDonald
the HELP command for other information (like subscribing). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day

RE: Oracle 9i new features - by Connor McDonald

2003-09-23 Thread Connor McDonald
, Sussex, WI USA -Original Message- From: Prem Khanna J [mailto:[EMAIL PROTECTED] Sent: Monday, September 22, 2003 12:45 AM To: Multiple recipients of list ORACLE-L Subject: Oracle 9i new features - by Connor McDonald ..a paper presented by Connor at OracleWorld 2003 is here

Re: Weird behavior with VARCHAR fields

2003-09-10 Thread Connor McDonald
, 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). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED

Re: test

2003-09-06 Thread Connor McDonald
for other information (like subscribing). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day

Re: optimizer_max_permutations

2003-08-26 Thread Connor McDonald
worked with this one? http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76961/ch11 23.htm#81357 http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76961/ch1 123.htm#81357 Patrice. = Connor McDonald web: http://www.oracledba.co.uk web: http

Re: Re: Row level security and latch waits

2003-08-20 Thread Connor McDonald
from). You may also send the HELP command for other information (like subscribing). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat

RE: Oracle World anyone?

2003-08-16 Thread Connor McDonald
that the economy is starting to rebound except when you ask for training funds -Original Message- Connor McDonald Sent: Friday, August 15, 2003 12:34 PM To: Multiple recipients of list ORACLE-L I'll be presenting there. Come see me on Monday for 9i goodies that aren't so well known

RE: Oracle World anyone?

2003-08-15 Thread Connor McDonald
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). = Connor McDonald web: http

Re: quick suggestions for tuning ?

2003-08-14 Thread Connor McDonald
/octet-stream = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day

RE: quick suggestions for tuning ?

2003-08-14 Thread Connor McDonald
issue here. 54 million consistent gets. does it mean that db_cache_size (700M) is small ? any good docs or links regarding LIO and how to deal with it ? Can u explain me Connor ? Regards, Jp. From: Connor McDonald [EMAIL PROTECTED] Subject: Fwd: Re: quick suggestions for tuning

Re: salary question

2003-06-27 Thread Connor McDonald
(or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH

Re: oracle docs do say # of extents effect performance

2003-06-20 Thread Connor McDonald
also send the HELP command for other information (like subscribing). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all

RE: Rule Based Optimizer

2003-06-12 Thread Connor McDonald
). You may also send the HELP command for other information (like subscribing). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat

RE: median function

2003-06-11 Thread Connor McDonald
woodpecker to come along would destroy civilization. - author unknown = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all

RE: Tablespace management.

2003-06-01 Thread Connor McDonald
') 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). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net

RE: Cannot allocate new log - checkpoint not complete

2003-04-04 Thread Connor McDonald
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). = Connor McDonald web: http://www.oracledba.co.uk

Was: Auto vs Uniform - now number of extents

2003-04-04 Thread Connor McDonald
of your choice. Cheers, Gaja --- Connor McDonald [EMAIL PROTECTED] wrote: I don't believe that was the case. auto and uniform in all of the (admittedly rudimentary and subjective) tests I've done appear the same in terms of performance. I prefer

Re: Autoallocate vs Uniform extent performance

2003-04-03 Thread Connor McDonald
). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day __ Yahoo! Plus

Re: Cannot allocate new log - checkpoint not complete

2003-04-03 Thread Connor McDonald
). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day __ Yahoo! Plus

RE: Cannot allocate new log - checkpoint not complete

2003-04-03 Thread Connor McDonald
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). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED

Re: dbshut script - why shutdown so much???

2003-04-03 Thread Connor McDonald
to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he

RE: PGA

2003-03-31 Thread Connor McDonald
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). = Connor McDonald web

Re: How to extract BLOB's into files ??

2003-03-27 Thread Connor McDonald
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). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish

RE: Veritas Quick I/O for Oracle

2003-03-26 Thread Connor McDonald
may also send the HELP command for other information (like subscribing). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink

Re: Reorganizing tables

2003-03-24 Thread Connor McDonald
for other information (like subscribing). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day

Re: Memory taken by s session

2003-03-22 Thread Connor McDonald
= Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day __ Do You Yahoo!? Everything

Re: audit_trail=db Overhead ?

2003-03-21 Thread Connor McDonald
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). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL

Re: Oracle Audit for Failure Logins

2003-03-20 Thread Connor McDonald
in advance, God Bless innocent people in Iraq and let the Imperialists get out there ASAP. Rgds Joshua Gå före i kön och få din sajt värderad på nolltid med Yahoo! Express = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE

Re: TABLE SIZE

2003-03-20 Thread Connor McDonald
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). = Connor McDonald web: http://www.oracledba.co.uk web: http

Re: Storage guidelines in 9iR1 ??

2003-03-19 Thread Connor McDonald
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). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man

Re: Comparing strings whilst ignoring some characters

2003-03-17 Thread Connor McDonald
to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he

Re: Using the /*+ append */ insert hint

2003-03-17 Thread Connor McDonald
). You may also send the HELP command for other information (like subscribing). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat

Re: Autoallocate (was Re: LMT monitoring)

2003-03-17 Thread Connor McDonald
may also send the HELP command for other information (like subscribing). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink

RE: Using the /*+ append */ insert hint

2003-03-17 Thread Connor McDonald
, and now scanning the barren wilderness otherwise known as the Perth job market :-( Cheers Connor --- Grant Allen [EMAIL PROTECTED] wrote: -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Connor McDonald Sent: Monday, March 17, 2003 13:34

Re: how to get metalink user name ??

2003-03-17 Thread Connor McDonald
to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he

Re: LMT monitoring

2003-03-11 Thread Connor McDonald
= Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day __ Do You Yahoo

RE: Oracle position on hints

2003-03-08 Thread Connor McDonald
information (like subscribing). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day

Re: how to find elapsed time for a query in oracle 8.1.7 Database

2003-03-07 Thread Connor McDonald
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). = Connor McDonald web: http

Re: System tablespace Oracle 9202

2003-03-06 Thread Connor McDonald
= Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day __ Do You

Re: fast full index scan

2003-03-03 Thread Connor McDonald
mobile phone. = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day

Re: Big SGA.......

2003-03-03 Thread Connor McDonald
) = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day __ Do

Re: How to load pictures/documents in oracle

2003-03-02 Thread Connor McDonald
want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he

RE: Statistics on SYS?

2003-03-02 Thread Connor McDonald
the HELP command for other information (like subscribing). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day

Re: bulk load of data

2003-03-02 Thread Connor McDonald
of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him

Re: Oracle Magazine excels itself

2003-03-02 Thread Connor McDonald
command for other information (like subscribing). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day

Re: temporary tablespace using tempfile

2003-02-27 Thread Connor McDonald
for temporary segments? Jos - Yahoo! Mobile - Exchange IMs with Messenger friends on your Telstra or Vodafone mobile phone. = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man

Re: PGA question

2003-02-27 Thread Connor McDonald
information (like subscribing). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day

Re: system/internal tables for query tree

2003-02-27 Thread Connor McDonald
you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish

Re: Update and Trigger

2003-02-25 Thread Connor McDonald
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). = Connor McDonald web: http://www.oracledba.co.uk web: http

RE: select count(case ...) slow in PL/SQL, any better way?

2003-02-25 Thread Connor McDonald
information (like subscribing). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day

Re: Materialized views not refreshing

2003-02-25 Thread Connor McDonald
from). You may also send the HELP command for other information (like subscribing). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit

Re: dbms_job

2003-02-25 Thread Connor McDonald
') 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). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email

Re: Select Statement Gone South??

2003-02-25 Thread Connor McDonald
and requisition_date = effective_date) Any ideas?? Any insight would be appreciated. Thanks, Laura = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish

Re: update 30mil rows

2003-02-25 Thread Connor McDonald
also send the HELP command for other information (like subscribing). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer

RE: RE: Top 10 DBA Do's and Don'ts anyone - Here is my list, comm

2003-02-25 Thread Connor McDonald
. First, I got some great feedback from Jonathan Lewis, which I was very thankful for (but, honestly, I was so out of it at the time (still in stress induced fight or flight mode) that I don't remember much of it!). Second, I saw a great presentation by Connor McDonald on 9i. Connor does

Re: Alert Log reporting question

2003-02-24 Thread Connor McDonald
want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he

Re: Which is beter a cursor or a for loop?

2003-02-24 Thread Connor McDonald
] (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). = Connor McDonald web: http

Top 10 normalised down to Top 2

2003-02-24 Thread Connor McDonald
, 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). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE

RE: Error pinning PKS in shared pool

2003-02-23 Thread Connor McDonald
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 809-565-3121 = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day

RE: Error pinning PKS in shared pool

2003-02-23 Thread Connor McDonald
: := . ( @ % ; tia Ramon E. Estevez [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 809-565-3121 = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish

Re: Hot Backups or RMAN

2003-02-20 Thread Connor McDonald
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). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he

Re: Lock table and disallow select

2003-02-16 Thread Connor McDonald
information (like subscribing). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day

Re: Optimizer help, get query to run as good as with RULE hint

2003-02-16 Thread Connor McDonald
they are ignored. However, I will agree that there are more and more grey areas in 9.2 where the increased scope for (internal) query rewrites is so extensive that it is becoming a lot harder to decide why a hint appears to have been ignored. = Connor McDonald web: http

Re: Hotsos Symposium in Dallas

2003-02-13 Thread Connor McDonald
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). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat

Re: database file sizes....more of smaller size or less of larger size?

2003-02-13 Thread Connor McDonald
send the HELP command for other information (like subscribing). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all

Re: buffer pools

2003-02-13 Thread Connor McDonald
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). = Connor McDonald web: http://www.oracledba.co.uk web: http

Re: Index update = Delete + insert ?

2003-02-12 Thread Connor McDonald
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). = Connor McDonald web: http://www.oracledba.co.uk web: http

Re: How to send/receive email through pl/sql ??

2003-02-11 Thread Connor McDonald
list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish

Re: HISTOGRAMS , CBO and OLTP

2003-02-08 Thread Connor McDonald
to a good white paper or material that would discuss this? TIA Menon - Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED

Re: multiple oracle homes

2003-02-06 Thread Connor McDonald
for other information (like subscribing). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day

Re: RAC on linux?

2003-02-06 Thread Connor McDonald
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). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man

  1   2   3   4   5   6   7   >