RE: Histogram Helper -- Follow up

your email this morning I found that you had already done it all! And better than I could have done as I was entertaining PL/SQL. Great technique with inline views and CASE expressions! In your script comments you wrote: -- Author: Steve Adams -- based a suggestion from Steve Orr Well at least I

Histogram Helper

Any ideas or personal experiences with histograms? Any white papers on implementing and managing histograms? TIA! Steve Orr -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Orr INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538

RE: OT RE: Oracle being scalable

Title: RE: Oracle being scalable > Inquiring minds want to know! You must not be very inquisitive. :>) You should check out their website. http://wintercorp.com/   List of sponsers: EMC; HP; IBM; Informix; Microsoft; NCR; NetGenesis; Oracle; Sun; Sybase.   List of program partners: Amdahl;

RE: Select won't work for view create

With apologies to Oracle Corporation...   Hope they don't sue me. ;-)   -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Kevin KostyszynSent: Thursday, April 05, 2001 10:27 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Select won't

RE: Oracle being scalable

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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com

RE: OT : Sinclair was RE: Metalink Again

rest is history. And now you know "the rest of the story." Steve Orr -Original Message- Kenneth R Sent: Wednesday, April 04, 2001 1:46 PM To: Multiple recipients of list ORACLE-L I had a Spectrum 48K and the rest of the story is about the same for me. Same downward spira

OT: Prognostications and Timing the Market... was "I'll just go and kill myself..."

re much more urgent than those of greed. Therefore, the fall is faster than the recovery so I'll wait patiently for the panic to subside and observe a few months of up tick before getting back in. Missing the absolute bottoming out of the market by a mere two months is better than the alte

RE: Veritas

:" Note:29676.1. FYI, here's a couple more Metalink notes: - 20 questions on raw devices: Note:37914.1 - How to implement raw devices: Note:23037.1 Also, regarding Veritas performance vs. raw... http://eval.veritas.com/webfiles/docs/dbed_2-1_perf.pdf Steve Orr -Original Message

RE: Veritas

Here's a very exhaustive survey... On my Oracle Open World badge the following sponsers were represented: Oracle, IOUG, EMC, HP, Intel, Sun, Veritas. :-) Steve Orr -Original Message- Gennick Sent: Monday, April 02, 2001 9:46 AM To: Multiple recipients of list ORACLE-L The subje

RE: Veritas

ain symbolic links. Unlike raw it's relatively easy to increase the pre-allocated size of a QuickIO file. HTH, Steve Orr -Original Message- Sent: Monday, April 02, 2001 10:32 AM To: Multiple recipients of list ORACLE-L I've used it at a prior employer. Its a nice product, great

RE: Why is there air?

cial ORACLE-L FAQ: http://www.orafaq.com -- Author: Maser, Donna (SEA) INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Orr INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, Cal

RE: Single Code Table or Separate Code tables dilemma

rtunately they usually outnumber us DBA's so we have to be particularly nimble. ;-) Regards, Steve Orr -Original Message- Netrusov Sent: Thursday, March 22, 2001 10:56 AM To: Multiple recipients of list ORACLE-L Referential integrity is still present if you create Master looku

RE: Single Code Table or Separate Code tables dilemma

ed as standard practice in the where clause of every lookup query. Ditto for the effective_date and expiration_date columns where your validations have a time fence constraint such as a 'date_DBA_hourly_rate_increase_becomes_billable column." :>) Ready for duhveloper combat... Steve O

RE: EMC TimeFinder, and EMC TimeFinder vs Hot Standby

to the Pacific Ocean. ;-) Steve Orr -Original Message- Carmichael Sent: Thursday, March 22, 2001 5:36 AM To: Multiple recipients of list ORACLE-L Tim, That sounds about right. SRDF is something like Symmetrix Remote Data Facility and is basically mirrored disks at a remote site. Rachel &

RE: Re[2]: Re: SUN vs. HP

e the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Orr INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists ---

RE: DBA Job at a Chocolate Factory

I know you are :) Actually I would turn that job down, if only because it would make me crazy to be around the chocolate and know that eating it would make me unfit to work Rachel >From: "Steve Orr" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple

RE: DBA Job at a Chocolate Factory

t former President then you can do whatever you want without fear of justice) I urge you to tour such a facility. You'll never have an intrest in commiting crime again. -Rocky --- Steve Orr <[EMAIL PROTECTED]> wrote: > Seven years ago I was offered an Oracle DBA job at a chocolate fac

RE: identifying shared memory segments

f list ORACLE-L > > > A while back someone posted a method for determining which shared memory > segments belonged to an instance. Can someone repost that and CC me? Thanks. > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Orr INET:

DBA Job at a Chocolate Factory

is a basic technology that can be applied to just about any business anywhere. Any interesting stories? Personal experiences? Steve Orr -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Orr INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX:

RE: OT -- A humorous reply to the Canada rulz

Actually, I think the Aztecs (or some other Central American tribe) invented basketball and the losers were slain literally. Now that's what I call a salary cap. We need something like that in professional sports today. Steve Orr -Original Message- Sent: Tuesday, March 20, 2001

RE: Offtopic:DBA Math, Beer and OEM

in Calgary but if I'm ever up there I think I'd rather visit you. Besides, I owe you that stout. :-) Regarding beer... If you get a chance, visit your neighbor Walt Weaver just to the south and have a "Moose Drool" and a "Black Star" for me. Best of Luck on the n

RE: Offtopic:DBA Math, Beer and OEM

d have a "Moose Drool" and a "Black Star" for me. Best of Luck on the new job, Steve Orr -Original Message- Sent: Friday, March 16, 2001 8:31 AM To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] wrote: > > Well, I doubt that. With an average reach

RE: Intermedia Domain index and tablespace

I've done this and it works well. Steve Orr -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Marin DimitrovSent: Thursday, March 15, 2001 6:43 AMTo: Multiple recipients of list ORACLE-LSubject: Re: Intermedia Domain index and table

Is "MetaWink" Doing Another Rip Van Winkle???

It appears "MetaWink" is doing more than just taking "20 winks." It's doing another Rip Van Winkle. Steve Orr -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Orr INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

RE: Off topic, humour, flagrant breach of the rules

ever back in the neighborhood just let me know... The next stout's on me. So how many miles did you put on your bike anyway? Might be kind of hard to bicycle commute in Calgary this time of year. :) Keep in touch! Steve Orr -Original Message- Sent: Wednesday, March 14, 2001 7:46 AM To:

Stability of the Parallel Query Option - PQO

ether humble or otherwise. :>) TIA, Steve Orr -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Orr INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet acce

RE: Forms, Client, and the meaning of life.

r Windoze or the network any. Regarding the meaning of life... it varies by individual but for me it's living close to the slopes during ski season. Still stuck in Silicon Valley, Steve Orr -Original Message- Sent: Tuesday, March 13, 2001 3:18 PM To: '[EMAIL PROTECTED]' We have

Working Query Fails with PQO.

g of this but how can I give a cogently articulate explanation for the naysayer? TIA! TIA! TIA! TIA! TIA! TIA! TIA! TIA! TIA! TIA! TIA! Steve Orr . . . OK, for the curious, detail oriented types, I got the query from the duhveloper and found some "tuning opportunities." Here'

RE: Standby db license for 8.1.6

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

RE: Netbackup and RMAN

dition so you could backup raw devices without RMAN, (I think? ...never used the BLI stuff). Did you check out the Veritas web site? Lot's of "full color glossies" there. Also, check out the NetBackup pages at Backup Central... http://www.backupcentral.com/netbackup-faq.html. HTH, Steve

RE: Oracle Licensing

nd apply patches across the board? What are the fine print legally correct answers versus the ethically correct practices in the real world? Is there a distinction? I can imagine what the answers would be if Oracle included these questions on the OCP tests. ;-) What do you say? Comments and confessi

RE: Oracle Licensing

d apply patches across the board? What are the fine print legally correct answers versus the ethically correct practices in the real world? Is there a distinction? I can imagine what the answers would be if Oracle included these questions on the OCP tests. ;-) What do you say? Comments and confess

RE: eek!

om). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Orr INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, Californi

RE: MetaStink, Redux

Title: MetaStink, Redux I call it "MetaWink."   With apologies to Elmer Fudd, Steve Orr   -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jamadagni, RajendraSent: Thursday, February 22, 2001 9:33 AMTo: Multiple recipients of l

Homepage and Internet services for the DBA

uld find useful? Besides links to Metalink, OTN, etc., how about some graphics on the performance of our database servers? (Karma-like stuff.)   Steve Orr   -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Kevin KostyszynSent: Wednesday, Februar

RE: OT: this is the last thing we need

the Reagan Recovery! Before that was the Jimmy Carter malaise. So how old is Greenspan? Hey, it's Friday and I'm finishing lunch!!! :>) Steve Orr, Dispassionate Libertarian, Fiscal Conservative, 1776 Liberal, Politically Incorrect Saturday Nite Live Enthusiast. ;-) The above ex

RE: this is the last thing we need

Title: OT: this is the last thing we need Ellison and Clinton... "Birds of a feather flock together?" Got cigar?   -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Adams, Matthew (GEA, 088130)Sent: Thursday, February 15, 2001 10:32 AMTo: Multi

RE: Applying patches - minimizing database down time

on > > > >available. > > > > 9) With everything up, run the SQL scripts to complete the patch: > > > >@catalog.sql > > > >@catproc.sql > > > >@catrep.sql > > > >create or replace java system; >

Priority Paging on Solaris

Has anyone enabled priority paging on Solaris and did you experience any performance gains as a result? (10-300% performance gains possible according to Sun.) For a description here's a link: http://www.sun.com/sun-on-net/performance/priority_paging.html Comments? Recommendations? Stev

RE: Applying patches - minimizing database down time

@catproc.sql >@catrep.sql >create or replace java system; >-- interMedia stuff >@dr0pkh.sql >@dr0plb.sql > @dr0type.plb > 10) scan/recompile invalid objects. > > HERE'S THE PIVOTAL ISSUE... > Depending on resources step 9 could take a

Applying patches - minimizing database down time

PIVOTAL ISSUE... Depending on resources step 9 could take about two hours. What are the effects of executing this while the application is running? Comments and suggestions? TIA, Steve Orr -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Orr INET: [EMAIL PROTECT

RE: OT - WHAT is a FEDERATED DATABASE ???

dvocate and stirring up the pot for the sake of spirited discussion. :-) It's been fun but work beckons... Sigh. Steve Orr -Original Message- Sent: Tuesday, February 06, 2001 5:46 AM To: Multiple recipients of list ORACLE-L > the TPC is *independent*. Yes, and it's flawed a

OT - WHAT is a FEDERATED DATABASE ???

C is *independent*. Yes, and it's flawed and vendors take advantage of this to dupe the unwitting. BTW, Oracle OPS / EMC doesn't have to be a single point of failure if you implement the SRDF option but I've never done it so what do I know? Well I'll answer that by saying I don&

OT RE: Async I/O on Windows - Federated Database Foolishness

s (which is impossible under the federated database approach without doing a complete reorg). Oh but now I'm dreaming so it's back to reading the reviews and making decisions based on gut feel. IMHO, Steve Orr -Original Message- Sent: Monday, February 05, 2001 11:42 AM To: Multiple r

RE: Pondering Question of the Day-RESPECT

Sounds like a new white paper titled, "How To Be Fired as a DBA." :-) Best of luck... however you're interpreting that. ;-) Steve Orr -Original Message- [EMAIL PROTECTED] Sent: Friday, February 02, 2001 11:46 AM To: Multiple recipients of list ORACLE-L Lisa, W

RE: OT NT2K vs Unix.

o gobbled up by MS. WebTV runs on Oracle and I believe they are now located at the Microsoft campus here in Silicon Valley. MS knows they can't run WebTV on NT/SQLServer so they won't even try. These are the things Bill doesn't want you to know. Steve Orr -Original Message---

RE: OT_RE:_Réf._:_Re:_asyn_i/o_on_sun_

Close. It's Dave Cutler. There's too much old DOS/Windows backward compatibility for WinNT/2000 to achieve stability like VMS despite Cutler's leadership. I knew VMS and you, Mr. NT, are no VMS! With apologies to Senator Bentsen, Steve Orr -Original Message- stephane

RE: Email from a trigger

nt the plsql.jar. Here's what I did: $ cd $ORACLE_HOME/plsql/jlib $ loadjava -u system/password -v -r plsql.jar The 106513.1. doc gives sample code to help you roll your own PL/SQL email package/procedure. That's all there is to it. Have fun, Steve Orr -Original Message- Weinsh