Re: Re[2]: 10g: SQL Plus

2003-09-24 Thread Tanel Poder
Does it work even in sqlplus? Tanel. - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Wednesday, September 24, 2003 10:14 PM Subject: Re: Re[2]: 10g: SQL Plus This can be done with ksh as well. Someone else may

Re: Storage Frust....

2003-09-24 Thread Mogens Nørgaard
Sir Visser, It would be my honour to enroll you in the BAARF party as party member # 43 if you like. Also, if you enroll, I'll send you the whole BAARF.zip file (33 K) which contains the story, the dialogues, and the song texts of the BAARF musical which we'll do at the Database Forum Gala

RE: RAC for download - thanks2all who replied

2003-09-24 Thread quriyat
--- On Wed 09/24, Johnston, Tim [EMAIL PROTECTED] wrote: From: Johnston, Tim [mailto: [EMAIL PROTECTED]To: [EMAIL PROTECTED]Date: Wed, 24 Sep 2003 14:34:49 -0800Subject: RE: RAC for downloadUm... I'd definitely get that in writing... I just looked at the oraclestore and it looks like

RE: CLOB

2003-09-24 Thread John Kanagaraj
Tanel/Original poster, Let me add one more issue about LOBs - My understanding is that rollback information for LOB changes is allocated from the LOB segment itself, and not from system UNDO or RBS. This is controlled by the PCTVERSION parameter - read more about it in the Concepts and SQL

Re: ROW CACHE HIGH - Priority 1

2003-09-24 Thread Mogens Nørgaard
I HAVE to ask this question: Is it possible for you to turn off RAC and thereby completely avoiding this issue? Yeah, that's kind of funny. Except it isn't, really. Invalidations of objects, drops, in general breaking of breakable parse locks - they will all need to be communicated to all the

Re: guidance

2003-09-24 Thread Mogens Nørgaard
Just talked to Jonathan Lewis from Helsinki. He went through some of the examples given in the latest issue of Oracle Magazine, and they were just plain wrong. I can't recall them in detail, but I think one of the questions were which parameter to set in order to let a user do large sorts. In

Re: RAC for download

2003-09-24 Thread Mogens Nørgaard
Mladen, you old respected warrior you're wrong, I'm sad to inform you. Another way to get to Tim's place is this: Go to http://www.oracle.com/corporate/pricing/content.html Hit Price lists on the left hand side. Hit US Commercial Price List Undskyld. There have been no changes - none - to

RE: Storage Frust....

2003-09-24 Thread Johnston, Tim
Hey... I'm jealous!!! BAARF! BAARF! BAARF! Tim -Original Message- Sent: Wednesday, September 24, 2003 7:30 PM To: Multiple recipients of list ORACLE-L Sir Visser, It would be my honour to enroll you in the BAARF party as party member # 43 if you like. Also, if you enroll, I'll

Re: guidance

2003-09-24 Thread Stephane Faroult
[EMAIL PROTECTED] wrote: List , I am planning to give my 9i performance tuning exam on the first . Any advice you all want to give me ? Pretty nervous about it. Sure would appreciate your guidance. At least something which will disappear from 10g ironical grin -- Regards,

Re: how to generate unique file names on Windows.

2003-09-24 Thread Jared . Still
And people say Perl is cryptic. Wolfgang Breitling [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/24/2003 11:59 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: how to generate unique file names on

Re: Re[2]: 10g: SQL Plus

2003-09-24 Thread Jared . Still
Yes, that was the point of the script. I've used it before, Kirti has tried it recently on his systems and it still works. I had some trouble with it in ksh for Linux, didn't spend much time on it. See the link Kirti provided earlier. Jared Tanel Poder [EMAIL PROTECTED] Sent by:

Re: Storage Frust....

2003-09-24 Thread Jared . Still
I'm curious about this one: CCCP: for Compulsory use of a Clustered Computing Platform, whose mission should be to elimiate all usage of Mulitple, In-duh-vidual, ORACLE_BASE/HOMEs and to enforce the use of single-installed Oracle software on Clustered file systems. Our cluster is setup

Oracle Compress Option

2003-09-24 Thread Avnish.Rastogi
Does anybody has any experience with Oracle 9I compression option. I did some test on 9202 with a table of more 14 million rows. Table has total 7 indexes. Surprising both table and indexes are using more space after compression. Before compression space used is 13064MB and after compression

Re: guidance

2003-09-24 Thread Stephane Faroult
RANT Well, concerning point 4), I am surprised by the resilience of users to often dreadful applications. Perhaps that with age I am getting more and more impatient, but in their place I would have flown terminal and keyboard across the room. Perhaps I have memories of a time when machines weren't

RE: Storage Frust....

2003-09-24 Thread MacGregor, Ian A.
Garth Gibson, one of the original inventors of RAID (http://www.panasas.com/bio_gibson.html), and currently CTO of Panasas Inc, will be here [at SLAC] tomorrow to talk about his research into Object file systems. The talk will be Thursday (tomorrow) at 10:30 in the SCS conference room. I

Re: Oracle Compress Option

2003-09-24 Thread Mogens Nørgaard
Compress to impress? by Julian Dyke is a good presentation on this topic (see for instance http://www.ukoug.org/calendar/jan03/jan30ab.htm). I do have the article - 202 K with no compression, 147 K with compression :). Let me know if you're interested, and I'll email it directly to you.

Re: Storage Frust....

2003-09-24 Thread Mogens Nørgaard
Oh man, that would be cool. He can choose any membership number above 44...for instance 10046 :-). PS Would you like to be a member yourself? Mogens MacGregor, Ian A. wrote: Garth Gibson, one of the original inventors of RAID (http://www.panasas.com/bio_gibson.html), and currently CTO of

Re: Storage Frust....

2003-09-24 Thread Mogens Nørgaard
Well, Sir Tim - congratulations with your BAARF party membership # 44. The BAARF.zip file will be shipped in a second. Mogens Johnston, Tim wrote: Hey... I'm jealous!!! BAARF! BAARF! BAARF! Tim -Original Message- Sent: Wednesday, September 24, 2003 7:30 PM To: Multiple recipients

Re: Storage Frust....

2003-09-24 Thread Joe Testa
I figure I have to wait for a while to get BAARF party membership #69, bwahahahahahha i'll go back to programming php against mysql :) joe Mogens Nørgaard wrote: Well, Sir Tim - congratulations with your BAARF party membership # 44. The BAARF.zip file will be shipped in a second. Mogens

Re: DBA needed in Austin, TX

2003-09-24 Thread JApplewhite
David forgot to mention a couple of things about working for AISD: - We don't wear neckties (well, David does sometimes). - We get 23 paid Holidays (how does 2 weeks off for Christmas and a week off for Spring Break sound?). - We have an unlimited site license for Oracle EE. I slap databases out

Re: Storage Frust....

2003-09-24 Thread Mogens Nørgaard
Can't deny you such a good and simple wish. Welcome as BAARF Party member # 69. Mogens Joe Testa wrote: I figure I have to wait for a while to get BAARF party membership #69, bwahahahahahha i'll go back to programming php against mysql :) joe Mogens Nørgaard wrote: Well, Sir Tim -

Re: Storage Frust....

2003-09-24 Thread ManojKr Jha
Hi, Any body have any idea about how to control the size of library cache and sql area in shared_pool? With Regards, Manoj Kumar Jha A transcendentalist engaged in auspicious activities does

<    1   2