Linux as a production machine

platform. HTH Dave -- Dave Morgan Senior Database Administrator Internet Barter Inc. www.bartertrust.com 408-910-4183 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538

Re: Linux as a production machine

aggressively and cannot be tamed. So you need to ensure that you never page which is wasteful. @ Regards, @ Steve Adams @ http://www.ixora.com.au/ @ http://www.christianity.net.au/ -- Dave Morgan Senior Database Administrator Internet Barter Inc. www.bartertrust.com 408-910-4183

Anyone Seen this? ACC_TRIGGER problem

work spam :) I know I should spend the time to investigate but the list is so much easier. TIA Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858

OPS on RS6000

Interconnect Serial Port to Serial port direct connection - this is not a network interface! Alex, if you can cluster SUNs clustering IBM's is trivial :) Hooray for smitty ! HTH Dave -- Dave Morgan Senior Database Administrator Internet Barter Inc

Off topic, humour, flagrant breach of the rules

who have helped me at this job. I will rely on you at my next one :) (In Calgary, at one of Canada's largest ISP's) Jared, I'll be good from now on, I promise. After Friday I will be reachable at [EMAIL PROTECTED] Dave -- Dave Morgan Senior Database Administrator Internet Barter Inc. ww

Offtopic: Canada and America

which is wondering if we have a separate culture.) /RANT Sigh.., and the day after I promised Jared I would behave. Dave -- Dave Morgan Senior Database Administrator Internet Barter Inc. www.bartertrust.com 408-910-4183 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Auth

Offtopic:DBA Math, Beer and OEM

d click GUI's is that they isolate the DBA from the detailed sql that is needed to really MANAGE Oracle. IMHO Dave -- Dave Morgan Senior Database Administrator Internet Barter Inc. www.bartertrust.com 408-910-4183 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave M

Request Tracker Call for Assistance

o/rt-devel -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mai

T3's, NetApps, Tuning, Wife's Opinion and other fun

and bitmap indices? I can't help those who won't help themselves. And I don't receive HTML email. TTFN Off to figure out the relationship between multiblock_read_count and those index_optimizer thingies Dave -- Dave Morgan [EMAIL PROTECTED] 403 399 2442 -- Please see the official ORACLE-L

Tuning methodology (was T3's) and use of NetApp's

. All hot backups are put on the filer. I would be extremely hesitant to use it for any other files. I do have to be careful with the timing of my backups as it is pretty easy to overwhelm the appliance when copying files in. Dave Dave Morgan [EMAIL PROTECTED] 403 399 2442 -- Please see

Re: online backup and alter system switch logfile

-- Dave Morgan [EMAIL PROTECTED] 403 399 2442 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

8.1.7 7.3.4 on one listener?

TIA Dave -- Dave Morgan [EMAIL PROTECTED] 403 399 2442 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

PARTITION attache to SYNONYM

the consequences if I dorp the ysnonym. TIA Dave -- Dave Morgan DBA, Cybersurf Office: 403 777 2000 ext 284 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

Re: PARTITION attache to SYNONYM

no such partition. | | I have built another structure to hold the data but does anyone | know the consequences if I dorp the ysnonym. | |TIA |Dave | | |-- |Dave Morgan |DBA, Cybersurf |Office: 403 777 2000 ext 284 -- Dave Morgan DBA, Cybersurf Office: 403 777 2000 ext 284 -- Please see

Re: PARTITION attache to SYNONYM

love my job. TIA Dave Dave Morgan wrote: Hi Jonathan, Oracle 8.1.7.0 on Solaris 2.8 (5.8 or just 8). It is a private synonym owned by the table owner. Strange indeed, there is no record of the partition in dba_segments. All the other partitions show up

More Partition attached to a synonym.

by the table owner) for IMPRESSIONS_TAB I do have a copy of the data, so I can drop the synonym., table and tablespace but I am worried about my data dictionary. TIA Dave Dave Morgan DBA, Cybersurf Office: 403 777 2000 ext 284 -- Please see the official ORACLE-L FAQ: http

Partition attached to SYNONYM

. Then use those values to query the file and block against dba_segments to find out what data segment is actually being referenced. -- Dave Morgan DBA, Cybersurf Office: 403 777 2000 ext 284 -- Please see

RE: Partition attached to Synonym

data dictionary. Oracle support can reproduce it and feel that's enough. Sigh Dave -- Dave Morgan DBA, Cybersurf Office: 403 777 2000 ext 284 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan INET: [EMAIL PROTECTED] Fat City Network

RE: Standard SQLNET.ORA with multiple O_HOME's

with a standard sqlnet.ora. Any thoughts? -- Dave Morgan DBA, Cybersurf Office: 403 777 2000 ext 284 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: Do programmers tune SQL?

lousy SQL Stored procs are the way to go. That way when you get a good programmmer he can rewrite them for you. In my dreams at least :) Dave -- Dave Morgan [EMAIL PROTECTED] 403 399 2442 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan INET: [EMAIL

RE: max_open_cursors

or twice. -- Dave Morgan DBA, Cybersurf Office: 403 777 2000 ext 284 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

RE: Trouble ticketing system

Hi David, Look into REQUEST TRACKER. Open source (perl), many databases. Similar to Remedy byt free. A Google search will find it. Why code when you can install? Dave -- Dave Morgan DBA, Cybersurf Office: 403 777 2000 ext 284 -- Please see

Favourite Urban Myth

The DBA needs root privileges on the server This is one of my interview questions. Dave -- Dave Morgan DBA, Cybersurf Office: 403 777 2000 ext 284 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan INET: [EMAIL PROTECTED] Fat City Network Services

RE: RMAN

what to do when problems during recovery arise. Dave -- Dave Morgan DBA, Cybersurf Office: 403 777 2000 ext 284 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858

Re: persistent connections vs. login/logout white papers anyone?

will swap out the server side process causing shorter but still annoying delays. Also use dedicated servers as the MTS has problems dealing with long winded connections. HTH Dave -- Dave Morgan DBA, Cybersurf Office: 403 777 2000 ext 284 -- Please see the official ORACLE-L FAQ: http

RE IMPORT Urgent

warning, one's a subset of the other Good luck Ravindra Dave -- Dave Morgan [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: Listeners listening to multiple IPs

differently if you put hardcoded IP - it than listens to one IP only, and if you put the dns name - listens to all IPs. -- Dave Morgan DBA, Cybersurf Office: 403 777 2000 ext 284 -- Dave Morgan DBA, Cybersurf Office: 403 777 2000 ext 284 -- Please see the official ORACLE-L FAQ: http

Re: multiple extents are OK, dagnabbit!

. -- Dave Morgan DBA, Cybersurf Office: 403 777 2000 ext 284 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

Returning multiple rows as a single row

-- 1 Excel Word StarOffice 2 vi tgif oracle ... I know it's a group by with a subquery but TIA Dave -- Dave Morgan DBA, Cybersurf Office: 403 777 2000 ext 284 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan INET: [EMAIL PROTECTED] Fat

Re: multiple extents are OK, dagnabbit!

did you encounter, and at which step in the upgrade? Extents should not matter in an upgrade. -- Dave Morgan DBA, Cybersurf Office: 403 777 2000 ext 284 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan INET: [EMAIL PROTECTED] Fat City Network Services

LDAP/OID

Hi all, OID is not worth the hassle of installing, but, has anyone used a regular LDAP server to hold Oracle database information? Details would be appreciatted. TIA Dave -- Dave Morgan DBA, Cybersurf Office: 403 777 2000 ext 284 -- Please see the official ORACLE-L

MaterializeRe: Snapshot Logs Explanation Needed

case. A simple update to the data dictionary enabled the FAST REFRESH to take place. THIS IS DANGEROUS STUFF :) Dave -- Dave Morgan DBA, Cybersurf Office: 403 777 2000 ext 284 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan INET: [EMAIL

RE SQLServer archivingq

RAID does not help when a LUSER like me does a del * There were other issues that made me uncomfortable but robustness was the primary one. SQLServer is an excellent workgroup product, it is not suitable for enterprise/realtime/CAD-CAM systems. IMHO Dave -- Dave Morgan DBA, Cybersurf Office

RE: Fire your DBA

makes it to install Oracle the better off we as Oracle DBA's are. IMHO Dave -- Dave Morgan DBA, Cybersurf Office: 403 777 2000 ext 284 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

Re: WOB (waste of bandwidth ~= OT:)/ Re: HTML in Email

Hi Eric, No I won't, I have Linux nanoprobes which can swallow any virii that use proprietary extensions :) I am assuming Borg == Microsoft Dave Eric D. Pierce wrote: resistance is futile, you WILL be assimilated - the borg On 1 Jun 2001, at 9:54, Dave Morgan

Oracel Support was Re: MaterializeRe: Snapshot Logs Explanation Needed

OFF */ -- Anita --- Dave Morgan [EMAIL PROTECTED] wrote: Hi Anita, I'm not sure if you are the original poster but There is a way to force a view into fast refresh mode after you have restructured the snapshot logs WARNING: This is unsupported

RE SQLServer archiving

is Not a MSSQL/NT/2000 expert, apparently! snip -- Dave Morgan DBA, Cybersurf Office: 403 777 2000 ext 284 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

Re: Size, what is it?

Millsap once came up with a definition for a VLDB: It's any database that stretches its hardware. I cannot see any relationship between SGA and database sizes. None. RAID-3: Bit-level striping. Incredible it still exists (in my opinion) :). -- Dave Morgan DBA, Cybersurf Office: 403 777 2000 ext

RE: What is Quorum device ?

the database tell all the sysadmins/network admins to watch the fun /EVIL It's a cruel but effective piece of training HTH Dave -- Dave Morgan DBA, Cybersurf Office: 403 777 2000 ext 284 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author

News: Technology and the corruption of copyright

Hi All, In light of the recent discussion here is an alternate view. http://www.zdnet.com/zdnn/stories/comment/0,5859,2770541,00.html Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan INET: [EMAIL PROTECTED] Fat City Network Services

OT RE: Digestive DBA special

Morgan DBA, Cybersurf Office: 403 777 2000 ext 284 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE:Hot backup and TEMP tablespace

, these could be re-created too! -- Dave Morgan DBA, Cybersurf Office: 403 777 2000 ext 284 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

OT Now - was RE: screen

never be able to look Dave in the face again -rje RC In that order? pleae tell me it's just an alphabetical list :) RC --- Dave Morgan [EMAIL PROTECTED] wrote: A list of Dave's favourite things: Snip S:screen, sex, skiing, sleep, sushi Snip Dave

RE DATA Modelling Tool

pretty pictures. http://bourbon.usc.edu:8001/tgif/ HTH Dave -- Dave Morgan DBA, Cybersurf Office: 403 777 2000 ext 284 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538

Snapshot shows as INVALID in DBA_OBJECTs

Hi All, The subject says it all, 8.1.7 on Solaris 2.8 The snapshot is accessable and correct. Anyone know a (supported) way to clean up the data dictionary? TIA Dave -- Dave Morgan DBA, Cybersurf Office: 403 777 2000 ext 284 -- Please see the official ORACLE-L FAQ

Re: Snapshot shows as INVALID in DBA_OBJECTs

it's considered annoying, but harmless. The script is fixed in 9i. HTH, -- Anita --- Dave Morgan [EMAIL PROTECTED] wrote: Hi All, The subject says it all, 8.1.7 on Solaris 2.8 The snapshot is accessable and correct. Anyone know a (supported) way to clean up

OT Posts vs HTML posts

where OT's get nicely flamed and HTML does not appear. Just my $0.02 CAN ($0.013 US) Dave -- Dave Morgan Operations Manager, Rigskills Canada Canada's Geographical Oilfield Services Locator http://www.rigskills.ca [EMAIL PROTECTED] 403 399 2442 -- Please see the official ORACLE-L FAQ: http

RAC on Linux vs Support

of these instances is unsupported. Yet they rarely give their owners problems. It gives me problems because I have to keep looking for new work instead of living off of old work. Maybe I should go back to living off Windoze? :-) Dave -- Dave Morgan Operations Manager, Rigskills Canada Canada's

Hot backups vs RMAN, the rebuttal

a corrupted /usr/bin, a couple other minor file systems are missing and Oracle is complaining about a control file missing Easy, one line change in init.ora with what? /usr/bin/vi :-) My first experience with ed. I tolerated vi before, I love it now :-) -- Dave Morgan Operations Manager

US Travel for the DBA

south in Missoula, I believe) Walt, Steve, whats the snow like in Bozeman this year? I'm allowed to go skiing there. :-) Sigh .. Dave -- Dave Morgan Operations Manager, Rigskills Canada Canada's Geographical Oilfield Services Locator http://www.rigskills.ca [EMAIL PROTECTED] 403 399 2442

Re: RAC on Linux vs Support

any other OS, and my work is split 40% Linux, 40% Solaris, 10% HP and 10% AIX. Snip ... -- Dave Morgan Operations Manager, Rigskills Canada Canada's Geographical Oilfield Services Locator http://www.rigskills.ca [EMAIL PROTECTED] 403 399 2442 -- Please see the official ORACLE-L FAQ: http

SANS Oracle Security Book released

. The author, Pete Finnigan, has gathered input from over 60 Oracle professionals (many from this list) and spent almost a year producing this best practises manual. Highly recommended Dave -- Dave Morgan Operations Manager, Rigskills Canada Canada's Geographical Oilfield Services Locator http

Re: Hot backups vs RMAN, the rebuttal

will be able to handle the crisis when it occurs. Jared Dave Off to interview for a contract where they do nightly colds and yet when I ask if they can afford a day's loss of data/work answer Of course not -- Dave Morgan Operations Manager, Rigskills Canada Canada's Geographical Oilfield Services

RE: dump.sql

it. Jared -- Dave Morgan Operations Manager, Rigskills Canada Canada's Geographical Oilfield Services Locator http://www.rigskills.ca [EMAIL PROTECTED] 403 399 2442 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dave Morgan INET: [EMAIL PROTECTED] Fat City

Re: copyright

. There is no disservice in not tilting at this particular windmill. You owe Jared an apology. -- -- Dave Morgan Operations Manager, Rigskills Canada Canada's Geographical Oilfield Services Locator http://www.rigskills.ca [EMAIL PROTECTED] 403 399 2442 -- Please see the official ORACLE-L FAQ

DBMS_OBFUSTICATION

will only show the package header and not the package body This will not protect against rogue DBA's or network sniffing HTH Dave -- Dave Morgan Operations Manager, Rigskills Canada Canada's Geographical Oilfield Services Locator http://www.rigskills.ca [EMAIL PROTECTED] 403 399 2442 -- Please see

A Couple of does and donts

Hi All, Do not tune because a statistic looks bad Do tune because a luser says this is slow and is adversely affecting my productivity. Do not use MTS Yes I know there are a few exceptions, but in general MTS causes more problems than it solves. Dave -- Dave Morgan

Single sign on

from the early days, again, not used alot but needed. Thanks for the code, loading it on to my development server as I write Dave -- Dave Morgan Operations Manager, Rigskills Canada Canada's Geographical Oilfield Services Locator http://www.rigskills.ca [EMAIL PROTECTED] 403 399 2442 -- Please