Re: BCHR Tuning

2003-01-11 Thread Jonathan Lewis
A brilliant solution. I knew that the real Steve Adams couldn't have edited it when I say the line starting: quote Latches are low-level queuing mechanisms end quote The man who wrote THE book about latches in Oracle couldn't possibly have made the mistake of thinking that latching was a

Re: #of blocks in extent

2003-01-11 Thread Amar Kumar Padhi
UNIFORM SIZE clause of Tablespace, if it is LMT. --- Igor Neyman [EMAIL PROTECTED] wrote: INITIAL, NEXT, PCTINCREASE -- if it's not LMT Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday,

RE: Create Mat View uses DEFAULT TABLESPACE for temp segments?

2003-01-11 Thread Burke, William F (Bill)
Title: RE: Create Mat View uses DEFAULT TABLESPACE for temp segments? The only people who don't occasionally look a bit dumb are those who don't do anything... Check my CLOB/RAW question... can I help paddle the bit dumb boat :) Regards, Bill Burke "The Kinder and Gentler DBA" IOUG

Re: BCHR Tuning

2003-01-11 Thread Mogens Nørgaard
The real Steve is sitting about 42 centimeters from me talking to his family in Australia. And I think the flight from Sydney took about 2000 hours, so it cannot possibly be him mentioned in the article by Rich. Thanks for pointing this out, Kerti. Suddenly it all makes sense. There are at

RE: Conversion from CLOB to RAW

2003-01-11 Thread Burke, William F (Bill)
The amount of data being stored is fairly significant @60G of xml transaction data. The developers want to apply a compression routine to the xml string which will save about 70% of the space currently in use. BLOB was my original recommendation, they were pushing to go RAW instead. We've only

www.oracle.com down?

2003-01-11 Thread Nicolai Tufar
Is Oracle's web site down? I just decieded to try J2EE Web Services CD they sent me. It has all the goodies in password-protectd ZIP files and tells to go to http://www.oracle.com/go/?Src="">and fill registration form to get the password. What a pity. The site is down just in the omemnt

Re: www.oracle.com down?

2003-01-11 Thread Nicolai Tufar
Thank you! The site is up again and I was worried that no one would confirm that it was down. I swear it was down! UNBREAKABLE indeed. Cannot break it, cannot break in. Cannot get it, cannot get in. I know what are you doing. Metalink, huh? Best luck. Regards, Nick - Original

Oracle CD's

2003-01-11 Thread guess who
One of my friend who has subscribed to oracle OTN has got three CD's free(Oracle 9i Database CD's)...Can any one tell me how to get it... I am also registered in OTN but i am getting magazines only..No CD's like that... Regards, [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ:

RE: Oracle CD's

2003-01-11 Thread Richard Ji
Probably because Oracle didn't want to guess who you are? -Original Message- Sent: Saturday, January 11, 2003 11:49 PM To: Multiple recipients of list ORACLE-L One of my friend who has subscribed to oracle OTN has got three CD's free(Oracle 9i Database CD's)...Can any one tell me how

Re: Oracle CD's

2003-01-11 Thread Nicolai Tufar
http://otn.oracle.com/software/products/ias/htdocs/winsoft.html#j2ee Click on TryOnline icon and fill in the form. But they are not sending Oracle Database these days. Ony Application Server, JDeveloper and Oracle Lite. Nick - Original Message - To: Multiple recipients of list

Re: Conversion from CLOB to RAW

2003-01-11 Thread Arup Nanda
Bill, If the data length is less than 2K, why not use varchar2? You get all the functionality like substr(), instr(), like etc. I'm not sure why you are leaning towards RAW, when the type you are storing is of character based. HTH. Arup - Original Message - To: Multiple recipients of