Security risk with catsnmp catalog
Hi Listers, There is a security risk with catsnmp catalog (ORACLE_HOME/rdbms/admin/catsnmp.sql) which is shipped with Oracle releases. This is generic. Details : this file drop and recreate user dbsnmp with default password dbsnmp and give him different privileges. For 8i releases, it is mostly V_$ views privileges But for 9i releases, it will grant SELECT ANY DICTIONARY privilege (this one give access to any sys objects like link$ if you see what i mean...). One can argue that the security policy of the site should ensure that default passwordmust be changed. But even in this case, I'm sure that over the time many databases will reverse to the default password because catproc.sql (which execute automatically catsnmp) is required when applying patchsets and sometimes individual patches. I opened a TAR and the support analyst referred me to bug #2432163 which is visible (i thought naively that all security problems were kept out from prying eyes...) As a patch will probably take some time, i asked Oracle to place an alert accordingly . In the meantime, if you don't use OEM, i strongly suggest that you 1- execute ORACLE_HOME/rdbms/admin/catnsnmp.sql to remove this stuff 2- remove ORACLE_HOME/bin/dbsnmp which is by default setuid root (at least if you have followed install procedures and run root.sh) Unbreakable...or autobreakable ;-) Regards Gilles Parc carpe diem !! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gilles PARC 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).
Houston, do I have a problem?
This is not a joke.!!! This is from a business critical production database that I was asked to 'review' past Friday. The report is from v$system_event taken at 10:30am, Aug 9, 2002. The server (and database) was bounced on Aug 4, 2002 at 9:20am. This was the 1st time I was logging into this database. SQL / EVENT TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED AVERAGE_WAIT --- --- -- --- control file parallel write 143933 0 4080356626 28349.0001 db file scattered read 12540695 0 1.2254E+10 977.107332 buffer busy waits 10740450 36 8193235928 762.839167 SQL*Net message from client 180769027 0 9.9561E+10 550.761199 db file sequential read 298968127 0 1.1839E+11 395.99129 enqueue 13500 6435 2036785 150.872963 SQL*Net more data from client 52227948 0 4093231165 78.3724294 free buffer waits16 4 795 49.6875 log file switch completion 804 43 16263 20.2276119 log buffer space977 05409 5.53633572 control file single write17 0 51 3 db file parallel write 1749695 0 2935317 1.67761638 db file parallel read 8149 0 13484 1.65468156 log file single write 1024 0 701 .684570313 latch free 20070341616763 1054137 .525221297 log file sync 1366242560 526049 .385033545 SQL*Net message from dblink 1514480 0 451351 .298023744 log file sequential read 405415 0 82877 .204425095 SQL*Net break/reset to dblink10 0 2 .2 log file parallel write 2025192 7 293332 .144841576 SQL*Net break/reset to client 28113 03221 .114573329 db file single write320 0 36 .1125 SQL*Net more data from dblink447044 0 11375 .025444923 SQL*Net more data to client11770996 0 75680 .006429362 control file sequential read 554851 03261 .005877254 SQL*Net more data to dblink1076 0 5 .00464684 buffer deadlock1045 1029 1 .000956938 SQL*Net message to dblink 1514485 0 456 .000301092 SQL*Net message to client 180769119 0 48736 .000269604 29 rows selected. SQL Here is the environment: 1)all the file systems for the database, including dump directories are in a single disk volume group, 2) all redo logs and control files are spread among all the other database files, 3) Hitachi array is in use with nothing but RAID-5 for all files (redo as well), 4) the real hard drives within the array are either shared with other databases on the same server or with other servers, 5) redo logs are of 100MB size and switch 20+ times/hour when some of the batch processes run in the evening, 6) no changes are allowed to any SQL code, Pro*COBOL code that use 'COPYBOOKs'
Re: Houston, do I have a problem?
Kirti, since i'm still not up to speed on the Wait event concept. What should i see as a problem in your report. thanks, joe Deshpande, Kirti wrote: This is not a joke.!!! This is from a business critical production database that I was asked to 'review' past Friday. The report is from v$system_event taken at 10:30am, Aug 9, 2002. The server (and database) was bounced on Aug 4, 2002 at 9:20am. This was the 1st time I was logging into this database. SQL / EVENT TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED AVERAGE_WAIT --- --- -- --- control file parallel write 143933 0 4080356626 28349.0001 db file scattered read 12540695 0 1.2254E+10 977.107332 buffer busy waits 10740450 36 8193235928 762.839167 SQL*Net message from client 180769027 0 9.9561E+10 550.761199 db file sequential read 298968127 0 1.1839E+11 395.99129 enqueue 13500 6435 2036785 150.872963 SQL*Net more data from client 52227948 0 4093231165 78.3724294 free buffer waits16 4 795 49.6875 log file switch completion 804 43 16263 20.2276119 log buffer space977 05409 5.53633572 control file single write17 0 51 3 db file parallel write 1749695 0 2935317 1.67761638 db file parallel read 8149 0 13484 1.65468156 log file single write 1024 0 701 .684570313 latch free 20070341616763 1054137 .525221297 log file sync 1366242560 526049 .385033545 SQL*Net message from dblink 1514480 0 451351 .298023744 log file sequential read 405415 0 82877 .204425095 SQL*Net break/reset to dblink10 0 2 .2 log file parallel write 2025192 7 293332 .144841576 SQL*Net break/reset to client 28113 03221 .114573329 db file single write320 0 36 .1125 SQL*Net more data from dblink447044 0 11375 .025444923 SQL*Net more data to client11770996 0 75680 .006429362 control file sequential read 554851 03261 .005877254 SQL*Net more data to dblink1076 0 5 .00464684 buffer deadlock1045 1029 1 .000956938 SQL*Net message to dblink 1514485 0 456 .000301092 SQL*Net message to client 180769119 0 48736 .000269604 29 rows selected. SQL Here is the environment: 1)all the file systems for the database, including dump directories are in a single disk volume group, 2) all redo logs and control files are spread among all the other database files, 3) Hitachi array is in use with nothing but RAID-5 for all files (redo as well), 4) the real hard drives within the array are either shared with other databases on the same server or with other servers, 5) redo logs are of 100MB size and switch
Re: Houston, do I have a problem?
On 2002.08.11 18:43 Deshpande, Kirti wrote: This is not a joke.!!! buffer busy waits 10740450 36 8193235928 db file parallel write 1749695 0 2935317 latch free 20070341616763 1054137 log file sync 1366242560 526049 log file parallel write 2025192 7 293332 buffer deadlock1045 1029 1 I was also informed that I will not have much chance to bring about any changes in the environment described above. Because, I was told, ...it is the corporate decision to use RAID-5 with HDS array and it is 'the most cost - And I was already beginning to wonder about their disk writes and buffer chain latches. Run away from there and do it as fast as humanly possible because companies like that usually prefer the executive opinion to the professional advice. Loook under damagement. -- Mladen Gogala -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mladen Gogala 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: Lock table table_name in exclusive mode - Performance gain?
All my comments are with regards to 8i. Might do things differently with 9i ;-) Familiar with the technique for doing large deletes? For example, you want to delete 40 million rows from a 100 million row table. It can often times be much more effective to do a CTAS (or insert append into an existing object) in parallel excluding the rows you want to delete. You can then truncate the source and throw the rows back in, or drop and rename (taking care of priv's and possible synonyms), or exchange partition, whatever. The same technique can be applied to updates. Numerous examples where this approach has been used with great success, I'll use one. In this particular example, we have a partitioned table, 162 million rows in a partition, and need to update 30 million rows in that partition with values from another table (bad, bad app, if designed correctly such a step wouldn't even be needed). We also have a holding table with the same structure. We'll do an insert append in parallel (implying append) outer joining to the table providing the values (using HJ). Use a decode to know whether or not to retain the value or if it should be updated if you found a matching row. Then, simply do an exchange partition no validate swapping your hold table with the partition that was to be updated. With the no validate it's basically a dictionary operation not even having to verify the values. Boom, there you go, a big update done very quickly. And then truncate the hold table (paying attention to next extent issues after parallel insert and ways around them). In another recent example, we had to update a column with a constant for all rows in a 109 million row table (don't ask). This type insert and swap approach allowed it to be done in 10 to 12 minutes. So you might be able to apply similar techniques to your situation. In our case, the app is very bad and we (me and another member on the list) were tasked to pull it out of the ditch (my 42nd day straight on this on back to back to back, etc 100/hr weeks, I want to hear the violins!). If we were to have written it, there wouldn't be the need for some of these large updates, etc. But we don't have the luxury of completely rewriting the whole thing right now, so we apply the update / delete becomes an insert and exchange partition approach to selected areas experiencing severe performance issues. And it works well. We had one process (cursor based of course in the coder's infinite wisdom updating 1 row at a time and committing every 1000 rows) that projected, by the rate of rows updated, to take 52.4 years to complete ;-). Now it takes 15 minutes. Just an idea that might be applicable in your situation. It's a little different, but not really much different than the CTAS (or insert append) approach that folks use for mass deletes. It's the same concept just applied to updates. And you can extend it to inserts / deletes. Don't know you situation, but maybe you do it in one statement. Seriously, I took a few thousand lines package doing multiple updates/deletes down to a single insert statement outer joining some tables and an exchange partition. Oh well, I'm delirious from a lack of sleep so the above might be a bit rambling. But I hope you get the idea. Regards, Larry G. Elkins [EMAIL PROTECTED] 214.954.1781 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of [EMAIL PROTECTED] Sent: Saturday, August 10, 2002 12:38 PM To: Multiple recipients of list ORACLE-L Subject: Lock table table_name in exclusive mode - Performance gain? Anyone do any bench marking, know of any papers, or using lock table table_name in exclusive mode to get a performance boost. I'm trying to figure out how to do 90,000,000 operations (add/change/delete) on the same table/partitions in a 4 hour period, and it looks like lighting will have to strike twice in the same place for it to happen. Any other suggestions on how to cut down on the cost of a transaction. I know about dropping indexes, using hash keys, partitions, unrecoverable, multi-process/threading, sql loader direct, and noarchivelog. Help Meee! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Larry Elkins INET: [EMAIL PROTECTED] Fat City Network
Re: Houston, do I have a problem?
Kirti, Get it in WRITING that you are not allowed to change anything. So that when they start to beat on you (okay, I know your boss, HE won't beat but HIS boss might) you are covered. You have my sympathies... I've worked under similar conditions (Rachel, we are giving you 750GB for your databases... oh yeah, RAID 5) Rachel --- Deshpande, Kirti [EMAIL PROTECTED] wrote: This is not a joke.!!! This is from a business critical production database that I was asked to 'review' past Friday. The report is from v$system_event taken at 10:30am, Aug 9, 2002. The server (and database) was bounced on Aug 4, 2002 at 9:20am. This was the 1st time I was logging into this database. SQL / EVENT TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED AVERAGE_WAIT --- --- -- --- control file parallel write 143933 0 4080356626 28349.0001 db file scattered read 12540695 0 1.2254E+10 977.107332 buffer busy waits 10740450 36 8193235928 762.839167 SQL*Net message from client 180769027 0 9.9561E+10 550.761199 db file sequential read 298968127 0 1.1839E+11 395.99129 enqueue 13500 6435 2036785 150.872963 SQL*Net more data from client 52227948 0 4093231165 78.3724294 free buffer waits16 4 795 49.6875 log file switch completion 804 43 16263 20.2276119 log buffer space977 0 5409 5.53633572 control file single write17 0 51 3 db file parallel write 1749695 0 2935317 1.67761638 db file parallel read 8149 0 13484 1.65468156 log file single write 1024 0 701 .684570313 latch free 20070341616763 1054137 .525221297 log file sync 1366242560 526049 .385033545 SQL*Net message from dblink 1514480 0 451351 .298023744 log file sequential read 405415 0 82877 .204425095 SQL*Net break/reset to dblink10 0 2 .2 log file parallel write 2025192 7 293332 .144841576 SQL*Net break/reset to client 28113 0 3221 .114573329 db file single write320 0 36 .1125 SQL*Net more data from dblink447044 0 11375 .025444923 SQL*Net more data to client11770996 0 75680 .006429362 control file sequential read 554851 0 3261 .005877254 SQL*Net more data to dblink1076 0 5 .00464684 buffer deadlock1045 1029 1 .000956938 SQL*Net message to dblink 1514485 0 456 .000301092 SQL*Net message to client 180769119 0 48736 .000269604 29 rows selected. SQL Here is the environment: 1)all the file systems for the database, including dump directories are in a single disk
TO_CHAR got one space in front
Hi all, Have you guys ever try this before: 1* select to_char(1.6,'0.') from dualSQL / TO_CHAR(1.6---1.6000 Notice that got one space in front of "1.6000"? I'm using Oracle 8.0.5 in Linux. Thanks in advance.
Unix solaris forum.
Hi, DBAs, Could anyone recommend a good unix solaris discussion/news group for me? Thanks, Chuan Unless otherwise stated, this e-mail does not represent the views of TransACT Communications Pty Limited. This text and any attachments of this e-mail are confidential and may be legally privileged. This email is for the use of the intended recipient only. If you are not the intended recipient do not take any action in relation to this email, other than to notify TransACT Communications by replying to this e-mail and destroying the original communication. Except as required by law, TransACT Communications does not represent that this transmission is free of errors, viruses or interference.
/etc/system on Sun Solaris 8 for 8i and 9i
Dear All, I've Sun machine that run Oracle 8.1.7. Recently I installed new oracle 9i2 64-bit on the same machine. But unfortunetly the old instance (8.1.7) is run out resource. I must set the /etc/system to higher value. But it is still the same. Could you please someone give me advice about it, and what is the impact for my Sun Machine if I increase the /etc/system value?? Below is my /etc/system. thanks Ahmadsyah.Alghozi.Nugroho ps: I'm feel sorry for my english.. :( === /etc/system === set hme:hme_adv_autoneg_cap=0 set hme:hme_adv_100fdx_cap=1 set hme:hme_adv_100hdx_cap=0 set hme:hme_adv_10hdx_cap=0 set hme:hme_adv_10hdx_cap=0 set ge:ge_adv_1000autoneg_cap=0 set ge:ge_adv_1000fdx_cap=1 set ge:ge_adv_1000hdx_cap=0 forceload: drv/vxdmp forceload: drv/vxio forceload: drv/vxspec forceload: sys/semsys set semsys:seminfo_semmsl = 500 set semsys:seminfo_semmap = 10 set semsys:seminfo_semmni = 1200 set semsys:seminfo_semmns = 5000 set semsys:seminfo_semmnu = 30 set semsys:seminfo_semopm = 100 set semsys:seminfo_semume = 10 set semsys:seminfo_semusz = 96 set semsys:seminfo_semvmx = 32767 set semsys:seminfo_semaem = 16384 forceload: sys/shmsys set shmsys:shminfo_shmmax = 4294967295 set shmsys:shminfo_shmmni = 800 set shmsys:shminfo_shmmin = 1 set shmsys:shminfo_shmseg = 400 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Unix Solaris forum.
www.sunmangers.org will do it for you Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Chuan Zhang [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12-08-2002 01:03 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:Unix solaris forum. Hi, DBAs, Could anyone recommend a good unix solaris discussion/news group for me? Thanks, Chuan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).
Transferring data from one table to another
Hi, We are transferring data from one table in a schema to another table in another schema with identical fields using INSERT INTO schema1.abc (SELECT * from schema2.abc) The source table has 1.6 million records. The tablespace increases to consume full disk space and yet seems to be demanding more so the operation doesn't complete. Is there a possibility to process commit after every 1,000 records? Is there any other way of doing it? TIA! Aleem -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Abdul Aleem 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: /etc/system on Sun Solaris 8 for 8i and 9i
How do you know it ran out of resource? What's the error message and when does this appear? During startup, during heavy use or when it's just idle? ltiu On Sunday 11 August 2002 20:08, you wrote: Dear All, I've Sun machine that run Oracle 8.1.7. Recently I installed new oracle 9i2 64-bit on the same machine. But unfortunetly the old instance (8.1.7) is run out resource. I must set the /etc/system to higher value. But it is still the same. Could you please someone give me advice about it, and what is the impact for my Sun Machine if I increase the /etc/system value?? Below is my /etc/system. thanks Ahmadsyah.Alghozi.Nugroho ps: I'm feel sorry for my english.. :( === /etc/system === set hme:hme_adv_autoneg_cap=0 set hme:hme_adv_100fdx_cap=1 set hme:hme_adv_100hdx_cap=0 set hme:hme_adv_10hdx_cap=0 set hme:hme_adv_10hdx_cap=0 set ge:ge_adv_1000autoneg_cap=0 set ge:ge_adv_1000fdx_cap=1 set ge:ge_adv_1000hdx_cap=0 forceload: drv/vxdmp forceload: drv/vxio forceload: drv/vxspec forceload: sys/semsys set semsys:seminfo_semmsl = 500 set semsys:seminfo_semmap = 10 set semsys:seminfo_semmni = 1200 set semsys:seminfo_semmns = 5000 set semsys:seminfo_semmnu = 30 set semsys:seminfo_semopm = 100 set semsys:seminfo_semume = 10 set semsys:seminfo_semusz = 96 set semsys:seminfo_semvmx = 32767 set semsys:seminfo_semaem = 16384 forceload: sys/shmsys set shmsys:shminfo_shmmax = 4294967295 set shmsys:shminfo_shmmni = 800 set shmsys:shminfo_shmmin = 1 set shmsys:shminfo_shmseg = 400 -- 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: TO_CHAR got one space in front
well that space is used 4 the sign bit... rgds, Ams. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of shuanSent: Monday, August 12, 2002 6:53 AMTo: Multiple recipients of list ORACLE-LSubject: TO_CHAR got one space in front Hi all, Have you guys ever try this before: 1* select to_char(1.6,'0.') from dualSQL / TO_CHAR(1.6---1.6000 Notice that got one space in front of "1.6000"? I'm using Oracle 8.0.5 in Linux. Thanks in advance.
RE: Transferring data from one table to another
well if u wanna commit after 1000 records u could very well use a cursor and within the loop keep a counter which will indicate the no. of records inserted...upon reaching 1000 records just commit and reinitialize the counter.. i have written the Pseudo code below: declare cursor c1 is SELECT * from schema2.abc; cntr number := 0; begin for c1_abc in c1 loop insert into schema1.abc values contained in c1_abc; cntr := cntr +1; if (cntr = 1000)then cntr := 0; commit; end if; end loop; /* the following commit is 4 last set of records that might not b commited*/ commit; end; rgds, Ams. www.medicomsoft.com -Original Message- Sent: Monday, August 12, 2002 8:23 AM To: Multiple recipients of list ORACLE-L Hi, We are transferring data from one table in a schema to another table in another schema with identical fields using INSERT INTO schema1.abc (SELECT * from schema2.abc) The source table has 1.6 million records. The tablespace increases to consume full disk space and yet seems to be demanding more so the operation doesn't complete. Is there a possibility to process commit after every 1,000 records? Is there any other way of doing it? TIA! Aleem -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Abdul Aleem 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Amjad Saiyed 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: Houston, do I have a problem?
This is an interesting report. I think the responses to it are even more interesting. One response admits confusion (which I think is a completely fair reaction). Another zeroes in knowingly on some specific details. If everyone had time to respond, I would expect a rash of differing opinions about what you should do first to fix this system... This kind of game is a fundamental part of using system-wide performance data. (The various ratio problems are just as relevant for system-wide data collected from the wait interface as they are from v$sysanything-else.) Don't lose hope if you look at Kirti's note and wonder, so what's the point? You cannot see everything that's wrong with a system from a report like this. I think in fact that you can know only two things from a v$system_event report: 1. If you know the secret constants (see www.hotsos.com/dnloads/1/constants), then you can see whether the database is spending heinously longer than normal systems at doing things. In this report, I would propose that an average single-block read latency of 9.7 seconds (977.107332 centiseconds), for example, is heinously longer than normal. 2. If you know the secret list of things that databases should and shouldn't do, then you can see whether a database is doing a lot of things that it shouldn't be doing. Databases, for example, shouldn't need to wait very often for 'buffer busy waits' waits, 'enqueue' waits, or 'latch free' waits. (Where's the url for *this* secret list? It's so simple that you don't really need one. Database should spend most of their time either idle, providing CPU service, or doing physical I/O. Not much else.) Sure, knowing these two things is worth something, but it leaves lots of good questions unanswered (*essential* questions, actually): a. Even if an Oracle kernel event is consuming heinously longer-than-normal elapsed times, or even if it is called heinously too often, does it really matter? What if the event is called predominantly by unimportant business processes, and the long latencies don't impact anything important? Then you would be wasting your time fixing it (instead of fixing something important first). If you assume an event is important because it's prominent in a system-wide data collection and you then fix a huge performance problem, then you were actually just lucky. It won't happen this way every time. b. What if the database is providing the right kinds of service in the right proportions? How can you tell whether it's spending more time than it *could* have spent? For example, just because a program spends 90% of its response time on the CPU and 10% on a disk (kind of a normal, healthy profile), it is *not* okay if the response time is 10 hours when it should be 6 seconds. It's not the proportions that are important; it's the absolute response time. So... Is the HDS disk array a problem? Probably. But, it's possible--*likely*, actually--that an analyst could fix all the problems shown here and still have really slow applications. Why? Because several essential-but-slow programs on this system might not spend significant amounts of their response time waiting on any of the top 10 events in this list. We see it pretty often: people fix their system's worst performance problems and then find out that their work really didn't make a noticeable end-user impact. (I'm confident that Kirti won't end up in this trap, but that's because I trust him to exercise intuition and experience far beyond the scope of what can be learned from his v$system_event data.) The wait interface is an important tool, because it finally (well, since over ten years ago) allows us to see where a program spends its time. But to use that tool to see how a whole system has spent its time since instance startup has the same limitations as any other method that relies upon system-wide aggregated data. So, what should you look at to avoid performance improvement project ambiguities? Session-level data. Which session? As I mentioned last week, I believe the analyst should focus first upon sessions whose performance improvement would most significantly improve the business. That, in my opinion, is The Big Secret. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic, Oct 1-3 San Francisco, Oct 15-17 Dallas, Dec 9-11 Honolulu - 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 Dallas - Next event: NCOAUG Training Day, Aug 16 Chicago -Original Message- Kirti Sent: Sunday, August 11, 2002 5:43 PM To: Multiple recipients of list ORACLE-L This is not a joke.!!! This is from a business critical production database that I was asked to 'review' past Friday. The report is from v$system_event taken at 10:30am, Aug 9, 2002. The server (and database) was bounced on Aug 4, 2002 at 9:20am. This was the 1st time I was logging into this database. SQL / EVENT TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED
E business Suite 11i - for Apps DBA's
Hello Application DBA's I'd like to know where I can get/buy E-business Suite 11i documentation with the ERD and data dictionary of the tables. Thank you so much. -- Maria Aurora VT de la Vega OCP Database Specialist Philippine Stock Exchange, Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Maria Aurora VT de la Vega 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).