RE: UTL_FILE question

2004-01-31 Thread Niall Litchfield
Title: Message I would create a new version of the procedure that took the date from and to as parameters and output a file named appropriately for the date range. You would then just call this 24 times. Niall -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL

RE: [Q] wait time on stat

2004-01-29 Thread Niall Litchfield
by dbca comes with 3 redo logs of 100m each by default. Don't know what the default is if you don't specify a size in the create database statement (never been that daft) but that wouldn't be windows specific. Niall -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall

RE: measuring TPM

2004-01-28 Thread Niall Litchfield
') 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall

RE: FW: Disk capacity planning

2004-01-20 Thread Niall Litchfield
the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Spool to Excel File

2004-01-20 Thread Niall Litchfield
') 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET

RE: most practical 9iR2 features?

2004-01-16 Thread Niall Litchfield
subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Should we stop analyzing?

2004-01-13 Thread Niall Litchfield
mean beans (so to speak) to them. At 02:19 PM 1/12/2004, you wrote: P.S. whilst the above is fictitious they do care about %utilisation of bandwidth but not response time from remote sites, God that irritates me. Author: Niall Litchfield INET: [EMAIL PROTECTED] Wolfgang

FW: problems with dbms_sql w/ 9.2.0.4???

2004-01-13 Thread Niall Litchfield
Title: Message -Original Message-From: Niall Litchfield [mailto:[EMAIL PROTECTED] Sent: 13 January 2004 11:16To: '[EMAIL PROTECTED]'Subject: RE: problems with dbms_sql w/ 9.2.0.4??? There is a bug 3140063which at first glance looks as if it might be relevant to you

RE: Should we stop analyzing?

2004-01-12 Thread Niall Litchfield
the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Suggestions Needed: Latch free - library cache

2004-01-09 Thread Niall Litchfield
that the drawbacks that steve has in mind don't apply to the majority of 3rd party apps. Niall -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

RE: Should we stop analyzing?

2004-01-09 Thread Niall Litchfield
information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: table reorganizations

2004-01-09 Thread Niall Litchfield
of 'alter table move' which is what we did. Cheers, Chris Dunscombe Cheers Niall -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

RE: Who said Oracle ran better on Win03?

2004-01-09 Thread Niall Litchfield
the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: oaktable people

2004-01-07 Thread Niall Litchfield
it what better description of a DBA could there be. I take it all back. Niall P.S. The david bowie bit is overdone though. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: Re[2]: another OCP question -- help me guys

2004-01-07 Thread Niall Litchfield
. Nothing so useful as Art in my background, just graphs with the axes befuddled. Niall P.S. I can work powerpoint too. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: Book (was) oaktable people

2004-01-07 Thread Niall Litchfield
. (And unlike my presentations, I promise that there is no profanity in the book...) Who cares. Squirrels. That's what we want. Squirrels do you hear. Niall -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network

RE: Re[1]: OCP question from Boson practice tests

2004-01-07 Thread Niall Litchfield
. Of course criticism of the OCP based on the fact that it values version specific syntax over DBA/Developer principles is right on the money IMO. Niall -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services

RE: Upgrade

2004-01-06 Thread Niall Litchfield
argument doesn't hold, but I bet you have investigated newer hardware/os and Oracle since then. If so why not windows other than the prejudice the misnaming suggests. Niall -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED

RE: oaktable people

2004-01-06 Thread Niall Litchfield
). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Top level heaps/subheaps

2004-01-06 Thread Niall Litchfield
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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services

RE: oracle client on PC's

2004-01-06 Thread Niall Litchfield
Title: Message OK I'll bite. Why would you not 1. install the Oracle client on every PC? OR 2. make the app web enabled and just point everyone at a URL. I get really confused when folk (and this isn't aimed at you honest) are quite happy to have sqlserver,msaccess,excel,textand foxpro

RE: oracle client on PC's

2004-01-06 Thread Niall Litchfield
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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services

RE: OCP Question (Perf Tuning)

2004-01-06 Thread Niall Litchfield
not blocks but as usual I am probably wrong. Niall OCP DBA (the last time you'll see that sig for a while). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: Convert to Locally-Managed Tablespaces

2004-01-06 Thread Niall Litchfield
change, the historic sgements contain current data, the transactional tables might be lookups My *impression* is that this sort of setup is actually quite common. Niall -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat

RE: order by

2004-01-02 Thread Niall Litchfield
://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from

RE: Hardware for RAC?

2004-01-02 Thread Niall Litchfield
Title: Message I'd also ask myself am I 'evaluating' RAC in which case presumably whatever hardware you can lay your hands on will be fine, or am I 'testing' RAC in which case I'd suggest that you need to purchase the same hardware as you would be using in a live environment, which would

RE: Should we stop analyzing?

2003-12-31 Thread Niall Litchfield
://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself

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

2003-12-27 Thread Niall Litchfield
is a script that will create one for you then I would agree with you, but in my experience the argument is more cogent than that. Niall -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051

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

2003-12-27 Thread Niall Litchfield
the right questions is a key skill for DBAs it seems to me. Niall -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

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

2003-12-27 Thread Niall Litchfield
at the problem. Niall -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: standby database configuration in 9iR2 SE ?

2003-12-17 Thread Niall Litchfield
://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from

RE: How windows manage memory: oracle

2003-12-05 Thread Niall Litchfield
Title: Message winternalssoftware runs a website called sysinternals which has a bunch of useful free utilities for windows (and IIRC Linux now as well). pslist is one of those utilities. www.sysinternals.com -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL

OT - LHC

2003-12-05 Thread Niall Litchfield
(like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Plan stability

2003-12-05 Thread Niall Litchfield
Title: Message I could notget Outlook to prefix your message properly - grrr. Comments are at the top which may make reading them hard.I have tried to setup a simple demo that hints are not 'suggestions' sorry if this becomes long - this is all 9.2 but should apply to 8i and later versions

RE: Plan stability

2003-12-04 Thread Niall Litchfield
: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE

RE: partitioning option licensing

2003-12-04 Thread Niall Litchfield
Title: Message as I understand it Oracle no longer uses (officially) processor speed to determine license costs, though it appears that *actually* it uses revenue targets to determine license costs Niall -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL

RE: Where are my trace files going?

2003-12-02 Thread Niall Litchfield
files going? Another possiblity is that file has once generated a trace file and you accidently rm that file. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: raw traces - EXEC: c=10,000 e=40

2003-12-02 Thread Niall Litchfield
for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting

RE: Which storage solution is good or you will recommend

2003-12-02 Thread Niall Litchfield
(or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538

RE: raw traces - EXEC: c=10,000 e=40

2003-12-02 Thread Niall Litchfield
. Niall -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Niall Litchfield Sent: 02 December 2003 22:24 To: Multiple recipients of list ORACLE-L Subject: RE: raw traces - EXEC: c=10,000 e=40 I'd be highly, highly suspicious of the cpu time c. 1

RE: Initalization files, etc

2003-11-24 Thread Niall Litchfield
be read from HKEY\local machine\software\oracle in the registry. HTH Niall -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: FW: SAN configuration for Banner

2003-11-20 Thread Niall Litchfield
Title: Message Hmm The small print on compaqSANS specifically states that you shouldn't pull drives 'for testing purposes' but only do itin the event of a drive failure. I wonder if other vendors say the same thing to avoid exactly this stuff. Mind you however I think of itI still

RE: SAN configuration for Banner

2003-11-20 Thread Niall Litchfield
Title: Message Hi I *think* but I may have entirely misread the comment that point 4 is just wrong. It sounds like you only have one raid 5 set (which is shared between 2 machines). If this is the case then the clustering has no effect on the fault tolerance/performance of the raid 5 set.

RE: RE: orbitz fiasco

2003-11-20 Thread Niall Litchfield
also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: NT/WINDOWS 2000 resources for ORACLE

2003-11-20 Thread Niall Litchfield
Jan/Feb next year. Niall -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: RE: orbitz fiasco

2003-11-20 Thread Niall Litchfield
may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: Any articles/books that take relational theory and make it

2003-11-19 Thread Niall Litchfield
for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting

RE: Development vs. Production DBA

2003-11-19 Thread Niall Litchfield
://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from

RE: RE: How do you generate primary keys?

2003-11-08 Thread Niall Litchfield
missed Henry Poras's reply, Niall. He replied with the same answer for this one. ;) --- Niall Litchfield [EMAIL PROTECTED] wrote: Rollback? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Cary Millsap Sent: 05 November 2003 20:39

RE: RE: How do you generate primary keys?

2003-11-07 Thread Niall Litchfield
the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: How do you genrate primary keys?

2003-11-06 Thread Niall Litchfield
-- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing

RE: How do you genrate primary keys?

2003-11-05 Thread Niall Litchfield
(or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858

RE: How do you genrate primary keys?

2003-11-05 Thread Niall Litchfield
. Niall -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Win termin services alert

2003-10-31 Thread Niall Litchfield
the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web

RE: dba interview questions

2003-10-28 Thread Niall Litchfield
). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Oracle pricing ain't going down

2003-10-27 Thread Niall Litchfield
) 2005. I fear that move will kill Oracle corp. Niall -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web

RE: Query Tuning Help

2003-10-27 Thread Niall Litchfield
but comparing the average wait for dbfile scattered read to dbfile sequential read might give some clue. For my dbs 80 and 66 are better values. Niall -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services

RE: What happened to Howard Rogers ?

2003-10-26 Thread Niall Litchfield
at home and do real research. I was never sacked by Oracle. Regards HJR -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

RE: How to record at SqlServer using Oracle

2003-10-25 Thread Niall Litchfield
-- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list

RE: What happened to Howard Rogers ?

2003-10-25 Thread Niall Litchfield
was never sacked by Oracle. Regards HJR -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: What happened to Howard Rogers ?

2003-10-23 Thread Niall Litchfield
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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services

RE: Oracle pricing ain't going down

2003-10-23 Thread Niall Litchfield
also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing

RE: Your new book

2003-10-22 Thread Niall Litchfield
Title: Message I also am not Cary .I have however read Cary's book from cover to cover (including spending rather too long on a romantic weekend in paris with my wife contemplating a 10046 trace parsing project :(). I Am rereading and intend to require my fellow DBAs and sysadmins to

RE: 10046 trace question

2003-10-22 Thread Niall Litchfield
Title: Message I'm not entirely sure what the problem with granting execute on dbms_system is here? dbms_system.ksddt and dbms_system.ksdwrtseem to give exactly what you wish? Niall -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of

RE: Your new book

2003-10-22 Thread Niall Litchfield
see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

LMT and Fragmentation

2003-10-13 Thread Niall Litchfield
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: locally managed autoallocate (was: Separate Indexes and Data)

2003-10-02 Thread Niall Litchfield
TEST_AUTO SQL select bytes from dba_free_space where tablespace_name='TEST_AUTO'; BYTES -- 65536 SQL create table tX(n number,charcol char(200)) 2 tablespace test_auto; Table created. Niall -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall

RE: 8i OCP Net8 Exam

2003-09-30 Thread Niall Litchfield
-- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list

RE: workarea_size_policy=auto and performance efficiency [was: Re:

2003-09-29 Thread Niall Litchfield
to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

RE: BAARF

2003-09-29 Thread Niall Litchfield
faster than restoring datafiles and applying logs I might be more convinced but at the moment I'm not so sure. So is this garbage Or not.? Niall -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services

RE: Fwd: RE: RAC for download -- re RAC Pricing and Partitioning

2003-09-26 Thread Niall Litchfield
the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: YEAAAAAAAAAAAAAAAAAAA!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!, drop in number

2003-09-23 Thread Niall Litchfield
ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: oraperf.com is now Veritas

2003-09-21 Thread Niall Litchfield
Title: Message All of it? how did you plough through all the detail? Niall -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jamadagni, RajendraSent: 18 September 2003 17:40To: Multiple recipients of list ORACLE-LSubject: RE: oraperf.com

RE: Dataguard Benchmark

2003-09-17 Thread Niall Litchfield
Title: Message I see your point, but I'm not sure if I'd say it was a bandwidth issue or a rate of redo generation issue - if you see whatI mean. It sounds like the batch job places execess stress on the redo/archive log systemas a whole. That said if the remore destination is optional

RE: Dataguard Benchmark

2003-09-16 Thread Niall Litchfield
Title: Message Just to add to Mladen's comments. I would wish to know 1. How long is fail over time in reality. 2. What is the impact on online operations. Of the db and of anything else that happens to use the same 'backup' link. You'll note I don't give a damn about bandwidth, I do

RE: Re: Application DBA

2003-09-04 Thread Niall Litchfield
FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE

RE: Oracle on Win2000

2003-09-04 Thread Niall Litchfield
Title: Message If a list of "stupid things I have done or found with Oracle on windows" were to be written would folk be interested Niall -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bala RegupathySent: 03 September 2003 18:44To:

RE: Oracle on Win2000

2003-09-04 Thread Niall Litchfield
Title: Message don't always=doesn't ever - you need a tns connection. Niall -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Smith, Ron L.Sent: 03 September 2003 22:39To: Multiple recipients of list ORACLE-LSubject: RE: Oracle on

RE: Future demand for DBAs

2003-09-04 Thread Niall Litchfield
' Us. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Oracle client and DNS

2003-09-01 Thread Niall Litchfield
(like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Re: OT - Linux books ??

2003-08-28 Thread Niall Litchfield
The Linux kernel is totally different, though you will find some code in it that is from System 4 UNIX. And maybe even from SCO G,DR Niall -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services

RE: Moving Data from Oracle to SQL Server

2003-08-28 Thread Niall Litchfield
, 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL

RE: Congratulations Arup (DBA of the Year)

2003-08-28 Thread Niall Litchfield
FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: OT: Hey Jared!!

2003-08-27 Thread Niall Litchfield
conveniently hasn't patched for 2 years) 3, Insert decommissioned kit into user who connected unauthorised pc to office LAN (this serves merely to boost morale by 'patching your organisations hole' :( Niall -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield

RE: Nature of Oracle-l has changed

2003-08-24 Thread Niall Litchfield
Tim wrote Any custom development projects in these areas are the likely result of poor requirements analysis... :-) Hey we do that Niall -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services

RE: Is there any certification for Systems Analyst/Designer ?

2003-08-19 Thread Niall Litchfield
subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: 32 or 64?

2003-08-19 Thread Niall Litchfield
? Daniel Fink -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: quick suggestions for tuning ?

2003-08-14 Thread Niall Litchfield
is a column that does not have many values (one would think no more than 8 or so) then you can make this a compressed index degree 1, if entpc also has very few values compressing it degree 2 might be helpful (though I'd be sceptical). Niall -Original Message- From: Niall Litchfield

RE: Raid 1 vs Raid 5 for tablespaces

2003-08-14 Thread Niall Litchfield
to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

RE: Event 10235

2003-08-14 Thread Niall Litchfield
(or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051

RE: quick suggestions for tuning ?

2003-08-14 Thread Niall Litchfield
') 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET

RE: Poor performance after moving Extempore database from 7.3.4 to 8.1.7

2003-08-14 Thread Niall Litchfield
: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE

RE: Oracle to MSSQL conversion?

2003-08-04 Thread Niall Litchfield
://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself

RE: Number of processors and standard edition

2003-07-30 Thread Niall Litchfield
subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Oracle links web page gone -- bummer!

2003-07-26 Thread Niall Litchfield
://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from

RE: Question about the list

2003-07-25 Thread Niall Litchfield
you took the words right out of my mouth (anyone recognizing the song?). Indeed, but there's no way I'm kissing you :( Niall -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051

RE: Oracle on linux vs. on windows

2003-07-25 Thread Niall Litchfield
Title: Message When I eventually found the source article http://www.interealm.com/technotes/roby/pentmark.html, it seemed to me that there were some problems with it. 1. It said the two OS and databases were 'similarly' configured but didn't show what the configuration was. 2. It

RE: Oracle 10G info note

2003-07-23 Thread Niall Litchfield
process which load best in near real time. Also the acronym would be I-RAC which might not be too good. Niall -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: Active Directory question

2003-07-21 Thread Niall Litchfield
Title: Message I didn't see it, probably 10G overload I too have thought about it and decided, um no. My reasons. 1. Its a brand new naming method. Brand new tends to mean buggy. 2. It requires modifying the AD schema (so you need to be schema admin to do this) 3. It will

RE: RAC

2003-07-21 Thread Niall Litchfield
Title: Message www.oaktable.net. Harrison redhouse has a paper on this. Think vmware. Niall -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of AKSent: 21 July 2003 19:49To: Multiple recipients of list ORACLE-LSubject: RAC Is it

  1   2   >