RE: CPU Pegged at 100%

2002-04-27 Thread Mohammed Shakir
Raghu I am also chasing a ghost like yours. Even though I have much larger number of cache Buffer chain waits, I look at the total picture. Looking at my statspack report, I noticed that application spends 30% of the time in buffer cache contention. How about the other 70%? Looking at the buff

RE: What block size are you using for your new 9i data warehouse?

2002-04-27 Thread Mohammed Shakir
Default block size is 512 bytes if the filesystem is NTFS for W2K. If you happen to use Fat32, it depends on the size of the partition. I believe for a 40G to 60G FAT32 partition it is 32K. --- Todd Carlson <[EMAIL PROTECTED]> wrote: > If I remember right the default W2K block size is .5K. > The

Re: sqlldr

2002-04-27 Thread Eriovaldo Andrietta
  HI Yechiel :   How can i to install two versions of Oracle in the same server , like :   Oracle 8i and Oracle 9i, in oracle_home different.   Is it possible ?   Regards   Eriovaldo     - Original Message - From: Yechiel Adar To: Multiple recipients of list ORACLE-L

Re: sqlldr

2002-04-27 Thread Yechiel Adar
Hello Stephen   Thanks for the link. The article is very illuminating. As we have some loader tuning to do I thank you for sharing the knowledge.   Yechiel Adar Mehish - Original Message - From: Stephen Andert To: Multiple recipients of list ORACLE-L Sent: Friday, April 2

Re: 9i new features, the saga continues?

2002-04-27 Thread Yechiel Adar
Well, sitting here at 11:00 PM on Saturday night building replication for 8.1.6 DB and having a nice time catching up on the postings, I am very interested in your postings.   Please keep it up.   Yechiel Adar Mehish - Original Message - From: Jamadagni, Rajendra To: Multip

Re: What block size are you using for your new 9i data

2002-04-27 Thread Gaja Krishna Vaidyanatha
Hi Dan, I think you are reading "way too much" into what I was saying. I was not in any way saying the the "physical blocks that support logical blocks were contiguous". I was saying that if multiple logically contiguous blocks (as in the leaf nodes of an index) were requested by Oracle requested

Re: ANTI-VIRUS SPAM - YOUR EMAIL ADMIN IS A DIKHEAD / (Fwd) Antigen found =*.*.txt file

2002-04-27 Thread Tim Gorman
Eric, A 5th-grade teacher once admonished me on cursing by pointing out that the English language has 100,000 words in frequent usage and how unimaginative it was to constrain myself to the same dozen or so words to describe my feelings... Bruce, the guy who runs FATCITY as a sideline business (

Manually Create OMS

2002-04-27 Thread ltiu
Hello, Is it possible to create an Oracle Management Server (OMS) manually through the command line without using "emca"? Thanks. How do I go about doing this? ltiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Serv

RE: Re: How come I don't get postings

2002-04-27 Thread Jim Hawkins
And new ones joining every day! Wow! Jim bill thater <[EMAIL PROTECTED]> wrote: >[EMAIL PROTECTED] wrote: > >> oh oh, lisa has a fan club :-) > > >with lots of members.;-) > > > >-- >-- >Bill "Shrek" Thater              ORACLE DBA >                 [EMAIL PROTECTED] >-

RE: Storing formated data in oracle table

2002-04-27 Thread Ganesh Raja
Hi, Oracle does not allow you to store Bold and Italics in the Table... What you can do is have a Field called format that will help you to identify what format the data has to be shown. HTH Best Regards, Ganesh R Tel : +971 (4) 397 3337 Ext 420 Fax : +971 (4) 397 6262 HP : +971 (50) 7

Storing formated data in oracle table

2002-04-27 Thread Pati Srinivas Rao
hi all How to store formated data(bold,italic) in oracle table. bye    Do You Yahoo!? Yahoo! Health - your guide to health and wellness