RE: CPU Pegged at 100%
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 buffer gets reports, I found each of my processes having 2.2 Billion buffer gets. Looking at my application, I should not have more than 250Million buffer gets for each process. Off course the problem is with the SQL. So I am working first on my SQL and then if buffer cache chains problem still exist, I will work on it. So check the buffer gets and find out SQL that are doing it and work on them. Shakir = Mohammed Shakir CompuSoft, Inc. 11 Heather Way East Brunswick, NJ 08816-2825 (732) 672-0464 (Cell) (732) 257-6001 (Home) __ Do You Yahoo!? Yahoo! Health - your guide to health and wellness http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammed Shakir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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).
RE: What block size are you using for your new 9i data warehouse?
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 max IO size depends on the RAID controllers used. > > What, you don't like the GUI? ;-) > > > Todd Carlson > Oracle Database Administrator > Tripos, Inc. > (314) 647-8837 Ext.3246 > > -Original Message- > Lisa > Sent: Friday, April 26, 2002 3:31 PM > To: Multiple recipients of list ORACLE-L > warehouse? > > Can anyone tell me how to figure out the file system block size and > max > i/o > size of a Windows 2000 system? My sysadmin had no clue. (Gosh, > can't > imagine why, everything's hidden behind that stupid gui) > > Thanks in advance for any replies > > Lisa Koivu > Oracle Database Baby Oven > Fairfield Resorts, Inc. > 5259 Coconut Creek Parkway > Ft. Lauderdale, FL, USA 33063 > > > -Original Message- > > From: Gaja Krishna Vaidyanatha [SMTP:[EMAIL PROTECTED]] > > Sent: Friday, April 26, 2002 12:49 PM > > To: Multiple recipients of list ORACLE-L > > Subject:RE: What block size are you using for your new 9i data > > warehouse? > > > > All, > > > > Something to keep in mind regardless of whether you > > are using 9i or not. This issue becomes more relevant > > in 9i with "multiple block sizes" for different > > tablespaces. > > > > You always want to ensure that your DB_BLOCK_SIZE = > > File System Block Size. This is to avoid wasted I/O > > and also the case where the "read ahead algorithm" is > > triggered accidentally, when 1 Database Block results > > in multiple file system blocks being read from disk. > > > > If your application performs range scans, there is a > > high possibility that multiple "single database block" > > read requests to a set of contiguous blocks, may > > result in the "read ahead algorithm" performing 128K > > or 256K pre-fetches, even though your application may > > have not required all 128K or 256K. > > > > This problem is rampant on ufs file systems where the > > default block size is 512 bytes, and with a 8K > > DB_BLOCK_SIZE, it takes 16 file system blocks to store > > 1 DB block on disk. However, even if you have advanced > > file systems and have a 1-is-to-2 ratio of DB block > > is-to FS blocks, you are still in danger of > > overloading your I/O sub-system, "under the right > > conditions". > > > > If you are using a volume manager product such as > > Veritas, and if your version of the volume manager > > supports "dynamic file system block sizing" based on > > size of the file system or the files themselves, > > please pay close attention to that detail and make > > sure that the file system block size does not exceed > > the database block size (based on the size of the file > > system). > > > > Best regards, > > > > Gaja > > > > --- Johnson Poovathummoottil <[EMAIL PROTECTED]> > > wrote: > > > We too have a data warehouse close to 500GB in size. > > > We upgraded the OS solaris 2.8 and our block size is > > > 16K. All our data and index tablespaces datafiles > > > are > > > spread across 20 files systems whose disks are on > > > EMC > > > storage. We too user veritas volume manager. File > > > systems use four 9 GB disks whaich are raid S and > > > software stripe uinit size of 256 KB. > > > > > > reasons > > > 16K block size as we have many full table scan ans > > > sequential reads. > > > 256 KB stripe unit size because we have set the > > > db_file_multi_block_read_count to 64(1MB) > > > > > > we are moving to a sun fire 15K machine soon and > > > then > > > the we will go to 9i 64 bit. > > > > > > --- "Toepke, Kevin M" <[EMAIL PROTECTED]> > > > wrote: > > > > Cherie: > > > > > > > > If you are using Oracle 9i, you can use mutliple > > > > block sizes! You still > > > > create your database with a default block size, > > > but > > > > each tablespace (except > > > > system) can have a block size different from the > > > > default. > > > > > > > > Valid blocksizes are limited by OS, but they range > > > > from 2K to 32k. > > > > > > > > Check out the 9i docs for CREATE TABLESPACE for > > > more > > > > info. > > > > > > > > Caver > > > > > > > > -Original Message- > > > > Sent: Thursday, April 25, 2002 11:24 AM > > > > To: Multiple recipients of list ORACLE-L > > > > > > > > > > > > > > > > We are building a new version 9.0.1 data warehouse > > > > on Sun Solaris 2.6 > > > > migrating to Solaris 2.8. We will be using > > > striped > > > > disk that is striped > > > > using Veritas Volume Manager on EMC disk. > > > > > > > > The datawarehouse will be about 200 Gig. It will > > > > be written to throughout > > > > the day. > > > > > > > > To this point, almost all of our databases have > > > been > > > > created with an 8k > > > > block size. i'm not sure if that blocksize is > > > > opt
Re: sqlldr
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 Sent: Saturday, April 27, 2002 8:18 PM Subject: Re: sqlldr 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 26, 2002 6:43 PM Subject: Re: sqlldr Ravi, To the best of my knowledge, there is no limitation on the number of records that can be loaded at a time other than the size of your rollback segments. I have loaded 10's of millions of rows in a single sqlldr job by setting some parameters. There are defaults that work, but don't perform very well. To determine appropriate settings, you may want to read an article I wrote for O'Reilly & Associates (located at http://oracle.oreilly.com/news/oraclesqlload_0401.html) which gives the step-by-step directions on setting 2 of the key parameters (BINDSIZE and ROWS). It's a pretty easy thing to do, but without knowing you data, the only advice I could give is that DIRECT is the best quick tuning fix if you can. If you are going to be doing any serious data loading with SQL*Loader, Jonathan's book Oracle SQL*Loader: The Definitive Guide would be a good investment. HTH Stephen>>> [EMAIL PROTECTED] 04/25/02 10:13PM >>>i belive there is a limitation on the number of records that can be loadedfrom sqlldr at a time based on the bind array and rows default parameter.if i have a data file with more than 5000records(don't know the exactnumber) that needs to be imported using sqlldrwhat is the value i need to set for the "rows" and/or "bind array" for me toload the records to the table at one attempt.thanksravi-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Ravindra B INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Re: sqlldr
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 26, 2002 6:43 PM Subject: Re: sqlldr Ravi, To the best of my knowledge, there is no limitation on the number of records that can be loaded at a time other than the size of your rollback segments. I have loaded 10's of millions of rows in a single sqlldr job by setting some parameters. There are defaults that work, but don't perform very well. To determine appropriate settings, you may want to read an article I wrote for O'Reilly & Associates (located at http://oracle.oreilly.com/news/oraclesqlload_0401.html) which gives the step-by-step directions on setting 2 of the key parameters (BINDSIZE and ROWS). It's a pretty easy thing to do, but without knowing you data, the only advice I could give is that DIRECT is the best quick tuning fix if you can. If you are going to be doing any serious data loading with SQL*Loader, Jonathan's book Oracle SQL*Loader: The Definitive Guide would be a good investment. HTH Stephen>>> [EMAIL PROTECTED] 04/25/02 10:13PM >>>i belive there is a limitation on the number of records that can be loadedfrom sqlldr at a time based on the bind array and rows default parameter.if i have a data file with more than 5000records(don't know the exactnumber) that needs to be imported using sqlldrwhat is the value i need to set for the "rows" and/or "bind array" for me toload the records to the table at one attempt.thanksravi-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Ravindra B INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Re: 9i new features, the saga continues?
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: Multiple recipients of list ORACLE-L Sent: Thursday, April 25, 2002 3:33 PM Subject: RE: 9i new features, the saga continues? Yes, I am *still* interested Joe. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message-From: JOE TESTA [mailto:[EMAIL PROTECTED]]Sent: Thursday, April 25, 2002 9:14 AMTo: Multiple recipients of list ORACLE-LSubject: 9i new features, the saga continues? Ok life has slowed down some and i've got some free time to potentially pickup the 9i new features saga i did about 6 months ago. Anyone still interested? The next on the list was 9i data guard. joe
Re: What block size are you using for your new 9i data
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 in quick succession and if there is a 1-to-many ratio of logical-to-physical mapping, the "read ahead algorithm" in the I/O sub-system will be triggered into performing pre-fetches that are larger than the actual amount of data required for the process. This is true even if the physical blocks were scattered. The pre-fetching occurs due to multiple blocks being read in random succession. I have encountered this problem at some customer sites and synching DB_BLOCK_SIZE = FS Block Size, by re-engineering the filesystem block size is what that helped us overcome the wastage and the overhead. Cheers, Gaja >--- Danisment Gazi Unal <[EMAIL PROTECTED]> wrote: > Hi Gaja, > > > Once again I've not tested, but I've some questions > > about your comments on physically contiguous" and "Keep DB_BLOCK_SIZE = FS(or OS) Block Size" > > > > > > "physically contiguous": > > > > We know that disk sectors are read and then > > transfered to bus. There will > > be a delay while transfering read sectors to bus, > > but before the reading > > next sector. Since disk rotates, while transfering > > current sector to bus, > > some or all of the next physically contiguous > sector > > may be missed. If > > these sectors were really physically contiguous, > OS > > would wait for the > > next rotation of the disk to read entire next > > physically contiguous > > sector. So, OS doesn't put logically contiguous > > sectors as physically > > contiguous. By depending on disk rotation speed > and > > transfer speed to bus, > > it's scattered to disk. An optimized disk > management > > system finds next > > sector immediately after the current sector is > > transfered to bus. This may > > be done by putting gaps between logically > contiguous > > sectors. These gaps > > may be used for other data. Of course, there may > be > > different > > implementation, but there will be always a delay > to > > bus and there will be > > always a miss to next sector(s). > > > > I've not tested but If Oracle sequential data is > > stored as physically > > contiguous, it's a real problem for IO subsystem. > I > > guess it's logically > > contiguous. > > > > "Keep DB_BLOCK_SIZE = FS(or OS) Block Size": > > > > As I remember(???), Oracle uses bytes as > parameters > > in IO system calls. > > And, let's say we created a db which has > > DB_BLOCK_SIZE = FS/OS block size. > > is it guarantee that each new Oracle block will be > > written to new OS block > > ? Every file is identified by a file handle in OS > > level, and also there > > should be a specific value in a register which > > points to last offset of > > the file. I mean, next insert may be appended to > > current OS block if there > > is free space, and new block(s) may be allocated > for > > the remainings. Here > > is a sample: > > > > - OS block size = db block size = 2k > > - 1K of the last OS block is free and we would > like > > to insert 4K. > > > > 1K is appended to last OS block, a new OS block is > > allocated for the > > remaining 2K, another new OS block is allocated > for > > the remaining 1K. In > > this sample, 4K is scattered to 3 blocks, not 2 > > blocks. > > > > I think this will not be a problem for Oracle. > > Because Oracle uses its own > > format. The check between block header and tail > will > > prevent scattered > > data from any corruptions in physically different > > blocks. > > > > > > I've not tested them, I may be wrong. Looking > > forward to hearing a > > confirmation > > > > > > regards > > > > > > > > > > < stuff deleted> = Gaja Krishna Vaidyanatha Director, Storage Management Products, Quest Software, Inc. Co-author - Oracle Performance Tuning 101 http://www.osborne.com/database_erp/0072131454/0072131454.shtml __ Do You Yahoo!? Yahoo! Health - your guide to health and wellness http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gaja Krishna Vaidyanatha INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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).
Re: ANTI-VIRUS SPAM - YOUR EMAIL ADMIN IS A DIKHEAD / (Fwd) Antigen found =*.*.txt file
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 (because this business doesn't generate enough money to support the typical family), restricts all attachments not only out of concern for viruses, but for the more practical reason of limiting message size and therefore storage and network capacity. It's a good policy -- if you'd like to send attachments, please address people directly... ...and please grow up. -Tim > I don't know if this guy (Evans, David) is subscribed to > this list, but if so, please tell your email admin that > this stuff sucks. > A text file attachment is not automatically equivalent to > a virus attachment. > > If their system wasn't set up by such dikheads, they would > know that they can implement packet scanning at the email > gateway in a non-intrusive manner that is far more > effective than this spam cr*pola. > > http://www.antivirus.com/products/isvw/ > > regards, > ep > > > > > > Return-path: <[EMAIL PROTECTED]> > > Received: from acsdefense.com ([208.155.8.98]) > by csus.edu with ESMTP id LAA23736 > for <[EMAIL PROTECTED]>; Fri, 26 Apr 2002 11:33:14 -0700 > (PDT) > Received: from dilbert.acsdefense.com ([192.168.101.7]) by > gateway.acsdefense.com with ESMTP id <119046>; Fri, 26 Apr > 2002 14:35:41 -0400 > > Received: by webmail.acsdefense.com with Internet Mail > Service (5.5.2654.89)id ; Fri, 26 Apr 2002 > 14:33:05 -0400 > Message-ID: > <299610E95611D411AE5500508BA37D830155F48F@ACSPHX03> > To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> > Date: Fri, 26 Apr 2002 13:22:04 -0400 > MIME-Version: 1.0 > X-Mailer: Internet Mail Service (5.5.2654.89) > Content-Type: text/plain > X-PMFLAGS: 34078848 0 1 Y0F158.CNM > > Antigen for Exchange found Text from file > 'ORACLNT5.TXT'.txt matching > =*.*.txt file filter. > The file is currently Removed. The message, "oracle/nt-5 > (last)", was > sent from Eric D. Pierce and was discovered in Evans, > David\ORACLE- L\EP > located at ACS/ACSPHX/ACSPHX03. > > --- Forwarded message follows --- > To: "'[EMAIL PROTECTED]'" > <[EMAIL PROTECTED]> Date sent: Fri, 26 Apr 2002 > 13:22:06 -0400 > Antigen for Exchange found Text from file > 'N093_NT4.TXT'.txt matching > =*.*.txt file filter. > The file is currently Removed. The message, "N093_NT1.TXT > [4 of 4]", was > sent from Eric D. Pierce and was discovered in Evans, > David\ORACLE- L\EP > located at ACS/ACSPHX/ACSPHX03. > --- End of forwarded message --- > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com -- > Author: Eric D. Pierce > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) > 538-5051 San Diego, California-- Public Internet > access / Mailing Lists > -- > -- To REMOVE yourself from this mailing list, send > an E-Mail message to: [EMAIL PROTECTED] (note EXACT > spelling 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). -- This EMail Was brought to you by WebMail A Netwin Web Based EMail Client http://netwinsite.com/webmail/tag.htm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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).
Manually Create OMS
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 Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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).
RE: Re: How come I don't get postings
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] > >You gotta program like you don't need the money, >You gotta compile like you'll never get hurt, >You gotta run like there's nobody watching, >It's gotta come from the heart if you want it to work. > >On a clear disk you can seek forever. -Computerworld button > > > > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: bill thater > INET: [EMAIL PROTECTED] > >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California -- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling 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). > -- _ Jim Hawkins Oracle Database Administrator [EMAIL PROTECTED] St. Louis, MO USA __ Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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).
RE: Storing formated data in oracle table
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) 745 6019 Live to learn... forget... and learn again. -Original Message- Sent: Saturday, April 27, 2002 12:23 PM To: Multiple recipients of list ORACLE-L hi all How to store formated data(bold,italic) in oracle table. bye Do You Yahoo!? Yahoo! Health - your guide to health and wellness -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ganesh Raja INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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).
Storing formated data in oracle table
hi all How to store formated data(bold,italic) in oracle table. bye Do You Yahoo!? Yahoo! Health - your guide to health and wellness
