RE: Need some white papers on replication
Unknown address, This address isn't in our system. This person is not employed here anymore, or has never been employed here. Please remove this address from your address book... Have A Nice Day Gerald T. Bray Email Administrator Handex Environmental, Inc. (352) 735-1800 Ext 145 E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Wednesday, February 27, 2002 7:38 AM To: Multiple recipients of list ORACLE-L Orafaw is a dead link for me from here... Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Tuesday, February 26, 2002 5:16 PM To: Multiple recipients of list ORACLE-L Subject:RE: Need some white papers on replication Bill: Anita Bardeen's Replication DOs and DON'Ts is excellent. All of Lawrence To's White Papers are good Graceful Switchover and Switchback, Oracle Standby Database Oracle8i Standby Database Mission Critical Recovery Within 30 Minutes I believe these are all on Metalink. www.orafaw.com/fawrepl.htm as an Oracle Replication FAQ Sorry, don't know of any good book recommendations. Barb -- From: Bill Conner[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Tuesday, February 26, 2002 12:53 PM To: Multiple recipients of list ORACLE-L Subject: Need some white papers on replication Hi All, i really need some papers on replication and any book recommendations. TiA!! -bill -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Conner 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: Baker, Barbara 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: Boivin, Patrice J 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: Babich , Sergey 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: HUGE numbers is V$SYSTAT
Unknown address, This address isn't in our system. This person is not employed here anymore, or has never been employed here. Please remove this address from your address book... Have A Nice Day Gerald T. Bray Email Administrator Handex Environmental, Inc. (352) 735-1800 Ext 145 E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Wednesday, February 27, 2002 6:03 AM To: Multiple recipients of list ORACLE-L Steve, Do you have the BUG#? Best Regards, K Gopalakrishnan Bangalore, INDIA -Original Message- Sent: Monday, February 25, 2002 3:48 PM To: Multiple recipients of list ORACLE-L OWS confirmed it's a bug and needs to be back ported for Linux. Sigh... -Original Message- Sent: Friday, February 15, 2002 6:18 PM To: Multiple recipients of list ORACLE-L Steve, The number 18,446,744,069,414,584,320 is 0x000. So looks like some of the counters are hitting their max values. I clearly suspect this could be a BUG. Have you directly queried $ksusgsta? If your X$KSUSSGTA shows correct values then there is something went wrong during the conversion. Otherwise this could be a BUG. BTW Which version of Oracle? Looks like you are on some 64 Bit Oracle? Best Regards, K Gopalakrishnan Bangalore, INDIA -Original Message- Sent: Friday, February 15, 2002 4:48 PM To: Multiple recipients of list ORACLE-L I'm finding HUGE numbers in the V$SYSTAT table. For instance for statistic# 1, logons current the number is 18,446,744,069,414,584,320... I don't think so! What's the cause and what's the cure? I used know about this but now I forget. Sigh... Steve Orr Bozeman, MT -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve 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). _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan 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: Orr, Steve 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). _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan 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: Babich , Sergey 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
RE: Old Chestnut: Tablespace Fragmentation
Unknown address, This address isn't in our system. This person is not employed here anymore, or has never been employed here. Please remove this address from your address book... Have A Nice Day Gerald T. Bray Email Administrator Handex Environmental, Inc. (352) 735-1800 Ext 145 E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Wednesday, February 27, 2002 7:43 AM To: Multiple recipients of list ORACLE-L I know this one has been done to death: use uniform extents to avoid fragmentation; multiple extents don't hurt (within limits). But what if: Data Warehouse, one big table on a single disk, full table (batch) scan, no concurrent transactions on the database (so no contention for the disk), no fragmentation at the file system level, initially empty buffer cache (startup), read-only operation so DBWR isn't doing anything on this disk. Basically I want to read one data file from end to end. Surely it would make sense to have the disk read moving smoothly from one end of the disk to the other rather than bouncing about all over the place as it may do with multiple extents randomly allocated. Any thoughts? Thanks - Bill. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Buchan 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: Babich , Sergey 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: RETURNING clause
Unknown address, This address isn't in our system. This person is not employed here anymore, or has never been employed here. Please remove this address from your address book... Have A Nice Day Gerald T. Bray Email Administrator Handex Environmental, Inc. (352) 735-1800 Ext 145 E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Wednesday, February 27, 2002 6:13 AM To: Multiple recipients of list ORACLE-L Hi list, I am firing foll query from oracle forms INSERT INTO TABLE_NAME (col1,col2,..) VALUES(val1,val2,..) RETURNING ROWID INTO var_rowid. it displays me follwoing error. ORA-00439:feature not enabled:RETURNING clause from this client type Is there any way to enable this feature from client ? (i know that in Forms ,there is a property of BLOCK 'DML returning value :YES/NO' but my table is not attached to the block ) (same query works fine from sqlplus) (Forms 6i, Orcale 8.1.6) Any help is appreciated Thx Sameer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ghadge,Sameer 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: Babich , Sergey 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[2]: address parse
Unknown address, This address isn't in our system. This person is not employed here anymore, or has never been employed here. Please remove this address from your address book... Have A Nice Day Gerald T. Bray Email Administrator Handex Environmental, Inc. (352) 735-1800 Ext 145 E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Wednesday, February 27, 2002 7:33 AM To: Multiple recipients of list ORACLE-L To throw a totally different twist into the combination: The new IRS ( yer favorite U.S. institution) form for corporations to report taxable income for individuals requires--- 1.If the address of the individual is in the U.S. use the street1,street1,city,county,state,zip fields. 2.If the address of the individual is outside the U.S. place all the information into 1 field. makes for a nightmare to parse the information. ROR mª¿ªm [EMAIL PROTECTED] 02/26/02 04:12PM John, We're actually messing with you a little bit, having fun at your incomplete question. Not only are there many things that could be considered an address, some of them have several components that could be combined in several different ways. Not only that, but there are different ways that you might choose to represent those components. A common street address example would be that given something like: '1293 Incomplete Drive, Suite 2001, Mail Stop H, Specification City, Oklahoma, 74953-0011' And a common set of fields to parse it into would be: AddressLine1 AddressLine2 City State Zip When stating a parsing problem both the input form and the output form need to specified. Also any peculiar rules. Above you'd need to state things like: -Assume USA address -Comma separated fields -City state and zip are last three fields -First field always AddressLine1 -If 4 fields AddressLine2 left null -If 5 fields then field 2 is AddressLine2 -If 6 or more fields, then fields 2 - (n-3) are concatenated separated by commas in AddressLine2 -State will be stored as 2 character state code -Zip can be either 5 digit or 9 digit (no dash) codes Now given all that, a parse routine could be written. But lacking such a specification, the question is very open for various interpretation, any of which has only a remote chance of meeting your needs. -rje S street address S -Original Message- S Sent: Tuesday, February 26, 2002 10:55 AM S To: Multiple recipients of list ORACLE-L S Anybody already have an address string parser (plsql) already written S that S they would care to share? S Address? IP? Internet mail? USPS? Memory address? URL? -rje -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge 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: Ron Rogers 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: Babich , Sergey 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).
DISREGARD, JUST A TEST
TEST ONLY
Problem running a report
Hi, ladies and gentlemen, Here is a good one. We have 25 offices nation wide, running similar reports. At the headquarters the one in consideration takes 12 min to complete. Any other office (WAN) it gets stuck and takes a few hours if it completes at all. Here is the output from V$SESSION_WAIT for the session: SID SEQ# EVENT P1TEXT P1 P1RAW P2TEXT P2 P2RAW P3TEXT P3 P3RAW WAIT_TIME SEC_WT STATE - - - -- - -- - -- - - -- - 82 31384 SQL*Net message from clie driver id 675562835 28444553 #bytes 1 0001 0 00 0 0 WAITING After some time: SID SEQ# EVENT P1TEXT P1 P1RAW P2TEXT P2 P2RAW P3TEXT P3 P3RAW WAIT_TIME SEC_WT STATE - - - -- - -- - -- - - -- 82 33799 SQL*Net message from clie driver id 675562835 28444553 #bytes 1 0001 0 00 0 0 WAITING and so on.(SEQ# increases and then resets). At the headquarters (LAN) it shows the same event after scattered read and it is done. Could that be a SQL*Net issue between LAN and WAN? Any ideas are appreciated as always. TIA, Sergey
RE: Problem running a report
Thank you, Mladen. It's always good to know that the guess was right -Original Message- From: Gogala, Mladen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 26, 2002 2:38 PM To: Multiple recipients of list ORACLE-L Subject: RE: Problem running a report That wait is, essentially, an idle wait. That means that the database processes are waiting for the message from the client, which, quite obviously, is taking it's time. Yes, I think that getting yourself a Snoopy (network engineer with a packet sniffer) would probably be a good idea. -Original Message- From: Babich , Sergey [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 26, 2002 2:18 PM To: Multiple recipients of list ORACLE-L Subject: Problem running a report Hi, ladies and gentlemen, Here is a good one. We have 25 offices nation wide, running similar reports. At the headquarters the one in consideration takes 12 min to complete. Any other office (WAN) it gets stuck and takes a few hours if it completes at all. Here is the output from V$SESSION_WAIT for the session: SID SEQ# EVENT P1TEXT P1 P1RAW P2TEXT P2 P2RAW P3TEXT P3 P3RAW WAIT_TIME SEC_WT STATE - - - -- - -- - -- - - -- - 82 31384 SQL*Net message from clie driver id 675562835 28444553 #bytes 1 0001 0 00 0 0 WAITING After some time: SID SEQ# EVENT P1TEXT P1 P1RAW P2TEXT P2 P2RAW P3TEXT P3 P3RAW WAIT_TIME SEC_WT STATE - - - -- - -- - -- - - -- 82 33799 SQL*Net message from clie driver id 675562835 28444553 #bytes 1 0001 0 00 0 0 WAITING and so on.(SEQ# increases and then resets). At the headquarters (LAN) it shows the same event after scattered read and it is done. Could that be a SQL*Net issue between LAN and WAN? Any ideas are appreciated as always. TIA, Sergey
RE: Problem running a report
Thanks to everyone who responded. The database is centralized. Yesterday I PINGed some machines in different offices (and TRACERTed, too) right from the server, and the response time was under 100 msec. However, some offices reported it to have run normally. That particular report creates a big file on C: (local machine) which raises the question if the machine had enough space on that drive and how fragmented it was... Oh, users Best regards to everyone, Sergey -Original Message- Sent: Tuesday, February 26, 2002 2:54 PM To: Multiple recipients of list ORACLE-L Are you using remote connections to a centralized database, or does each office have its own database? Tracert and netstat commands should help you figure out if its a network issue. Regards Raj Babich , Sergey To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] SBabich@handecc: xmail.comSubject: Problem running a report Sent by: [EMAIL PROTECTED] om February 26, 2002 02:18 PM Please respond to ORACLE-L Hi, ladies and gentlemen, Here is a good one. We have 25 offices nation wide, running similar reports. At the headquarters the one in consideration takes 12 min to complete. Any other office (WAN) it gets stuck and takes a few hours if it completes at all. Here is the output from V$SESSION_WAIT for the session: SID SEQ# EVENT P1TEXT P1 P1RAW P2TEXT P2 P2RAW P3TEXT P3 P3RAW WAIT_TIME SEC_WT STATE - - - -- - -- - -- - - -- - 82 31384 SQL*Net message from clie driver id 675562835 28444553 #bytes 1 0001 0 00 0 0 WAITING After some time: SID SEQ# EVENT P1TEXT P1 P1RAW P2TEXT P2 P2RAW P3TEXT P3 P3RAW WAIT_TIME SEC_WT STATE - - - -- - -- - -- - - -- 82 33799 SQL*Net message from clie driver id 675562835 28444553 #bytes 1 0001 0 00 0 0 WAITING and so on.(SEQ# increases and then resets). At the headquarters (LAN) it shows the same event after scattered read and it is done. Could that be a SQL*Net issue between LAN and WAN? Any ideas are appreciated as always. TIA, Sergey -- 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: Babich , Sergey 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).
Function based indexes
Hi, everyone, This may seem very simple to you, but what's the best way to see if a fresh FBI (sorry!) is used during the execution? Are they reported in the same manner to the SQL trace as other ones? Regards, Sergey
RE: ORA-27072
I used to have similar problems with Arcserve. Best, Sergey -Original Message- Sent: Monday, February 25, 2002 12:49 PM To: Multiple recipients of list ORACLE-L I'll bet you a case of Virtual Beer that it's your backup software. Most likely you are using Arcserve, correct? It's misconfigured and/or broken, and definately not the best backup solution around. Jared Shibu [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/22/02 10:18 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:ORA-27072 Hi all.. My database is going down frequently showing this error in alertfile . This is happening to different datafiles and controlfiles. What are the possibilities that cause this error ? How can i avoid this error ? oracle 8.1.7 in win2k Errors in file C:\oracle\admin\acusis\bdump\acusisCKPT.TRC: ORA-00206: error in writing (block 3, # blocks 1) of controlfile ORA-00202: controlfile: 'D:\ORADATA\CONTROL01.CTL' ORA-27072: skgfdisp: I/O error OSD-04008: WriteFile() failure, unable to write to file O/S-Error: (OS 33) The process cannot access the file because another process has locked a portion of the file. regards, shibu -- 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: Babich , Sergey 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: using dbms_output.put_line to write out a blank line
Did you try a tab instead? -Original Message- Sent: Monday, February 25, 2002 2:59 PM To: Multiple recipients of list ORACLE-L anyone know how to use dbms_output.put_line to write out a blank line? tried this: dbms_output.put_line (' '); -- single space between the two single quotes but it doesn't work. thx Bill Magaliff Framework, Inc. 914-631-2322 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Magaliff, Bill 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: Babich , Sergey 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: Problem with Rollback segment getting locked
Title: Problem with Rollback segment getting locked Hi, Viral, Are these RB segments public? Regards, Sergey -Original Message- From: Viral Amin [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 7:29 AM To: Multiple recipients of list ORACLE-L Subject: Problem with Rollback segment getting locked Hi All, I have about 12 Rollback segmennts in my database 25 concurrent users logged in. I am continuously facing problems of oracle just keep locking couple of Rollback segments. other people have to wait till Oracle releses the locks on this rollback segments. My Query is..Why Oracle is just using the few rollback segments from the avilable 12 then others have to wait till the locks on the rollback segments are released. Pls help..This is URGENT!! Regards, Viral Amin
RE: Create Database ... really dumb question
: [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: Babich , Sergey 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: SP2 error
You can't do that in SQL*Plus: SET COLUMN_NAME . You can see the list of parameters which you can set by issuing SHOW ALL (except a few). If you want to format a column, than: COL col_name_or_alias FORMAT . HTH, Best, Sergey -Original Message- Sent: Wednesday, February 13, 2002 11:18 AM To: Multiple recipients of list ORACLE-L How do I investigate the following error? SP2-0735: unknown SET option beginning column_name=... I don't seem to find much... -- 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: Babich , Sergey 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: Rollback Segment Problem
to be removed from). You may also send the HELP command for other information (like subscribing). MOHAMMAD RAFIQ _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq 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: SARKAR, Samir 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). MOHAMMAD RAFIQ _ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq 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: Babich , Sergey 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: Rollback Segment Problem
on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir 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). MOHAMMAD RAFIQ _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq 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: SARKAR, Samir 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). MOHAMMAD RAFIQ _ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq 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: Babich , Sergey 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). MOHAMMAD RAFIQ _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq 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: Babich , Sergey 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
RE: Rollback Segment Problem
exceeds 400M. This would suggest to me that none of the previous month's deletions exceeded 400M per month, so why should it fail on this particular one when it had nearly 3,000M available? Is there something I am not understanding about rollback segments ?? Thanks and Regards, Samir Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir 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). MOHAMMAD RAFIQ _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq 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: SARKAR, Samir 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). MOHAMMAD RAFIQ _ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq 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: Babich , Sergey 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). MOHAMMAD RAFIQ _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. -- Please see the official ORACLE-L FAQ
RE: parallel execution
How about DBA_TABLES where degree1? Best, Sergey -Original Message- Sent: Tuesday, February 12, 2002 9:14 AM To: Multiple recipients of list ORACLE-L Good morning all, It there a view which tell which tables are in parallel?I would like to see which table have parallel execution turned on. Thanks is advance, Ruth -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini 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: Babich , Sergey 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).
Patch 8.1.7.3 for NT/2000
FYI: It's available on Metastink and supposedly fixes a lo-o-o-o-o-ta bugs! Best, Sergey Babich
Latest patch for 8.1.7.0.0 (Win2k)
Hi, everyone, Couldn't find anything on Metastink. Could someone forgive my dumbness and help? TIA, Best, Sergey -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Babich , Sergey 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: Duplicate rows
Or to just count them: SELECT col1,col2.coln,count(*) from table Group by col1,col2...coln Having count(*) 1; -Original Message- Sent: Wednesday, February 06, 2002 10:33 AM To: Multiple recipients of list ORACLE-L Subject:Duplicate rows Hi gurus, I need detect and delete duplicate rows in any table, somebody helpme thanks!!! @lex Lic. Alexander Ordóñez Arroyo Caja Costarricense del Seguro Social Soporte Técnico - División de Informática Telefono: 295-2004, San José, Costa Rica [EMAIL PROTECTED]Icq# 30173325 The true is out there in WWW -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alexander Ordonez 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: Babich , Sergey 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: Duplicate rows
Delete from table_name where rowid not in(select min(rowid) from table_name group by col1,col2,...coln); Best, Sergey -Original Message- Sent: Wednesday, February 06, 2002 10:33 AM To: Multiple recipients of list ORACLE-L Subject:Duplicate rows Hi gurus, I need detect and delete duplicate rows in any table, somebody helpme thanks!!! @lex Lic. Alexander Ordóñez Arroyo Caja Costarricense del Seguro Social Soporte Técnico - División de Informática Telefono: 295-2004, San José, Costa Rica [EMAIL PROTECTED]Icq# 30173325 The true is out there in WWW -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alexander Ordonez 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: Babich , Sergey 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: Latest patch for 8.1.7.0.0 (Win2k)
Thank you, I will try. Just got a response from Oracle support it was NOT going to be released for a couple of days. Bizarre, so bizarre -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 06, 2002 1:38 PM To: Multiple recipients of list ORACLE-L Subject:RE: Latest patch for 8.1.7.0.0 (Win2k) Go to ftp://oracle-ftp.oracle.com/server/patchsets/NT and you should be able to find it there. -::YEX::- ))) -Original Message- Sent: Wednesday, February 06, 2002 10:44 AM To: Multiple recipients of list ORACLE-L Hi, everyone, Couldn't find anything on Metastink. Could someone forgive my dumbness and help? TIA, Best, Sergey -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Babich , Sergey 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: Yexley Robert D Contr Det 1 AFRL/WSI 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: Babich , Sergey 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).
ORA-04030 Out of process memory trying to.....
Hi, colleagues, Could someone enlighten me on the above subject? 8.1.7.0.0/ Win2k 2.5G RAM. Users get a lot of those when reports are run heavily. Once I opened a TAR on that, and Oracle support recommended either cutting the db_block_buffers (which I did), or changing the process memory addressability to 3G. Reports use a lot of views based on joins of huge tables. Now I'm getting these errors again. Any advice appreciated. Regards, Sergey Babich -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Babich , Sergey 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: Session_wait
Thank you, Henry, but that still does not excuse my stupidity and being superficial. I need to learn more about Oracle internals, and that's something which is NOT taught at schools. So I try to learn it from you, guys, and much appreciate this opportunity. Anyway, I've been successful, too, so I was benevolently forgiven. Best regards, Sergey -Original Message- Sent: Wednesday, January 30, 2002 11:45 PM To: Multiple recipients of list ORACLE-L Subject:RE: Session_wait Sorry, I guess I was reading too quickly also. I saw the 10046 and skimmed the rest. I assumed a session trace and didn't check the syntax. I'll try to be more careful before responding in the future. Henry -Original Message- Sent: Wednesday, January 30, 2002 11:56 AM To: Multiple recipients of list ORACLE-L On Wed, 30 Jan 2002, Babich , Sergey wrote: However, I made the following entry into init.ora file: Event= 10046 trace name errorstack level 12 and it rebooted over the weekend. Then I got a call from my boss on Monday morning (I was home sick) letting me know the system had come to a crawl and was producing a trace file every minute or so. Eventually, after some speculations, I told him to rem out that entry and reboot. That resolved the issue, but left me puzzled. Oh, boy, I couldn't understand who would tell you to do that on a production system, so I looked back in the archives and found this exchange: Sergey writes: Since I didn't expect that to happen, I had just SQL trace turned on for that particular session. Do you suggest entering event=10046 trace name errorstack level 12 into init.ora? Henry writes: Couldn't hurt. Also why not do some deltas of your session statistics (before and after snapshots) I wish I had been paying more attention when this exchange was happening, as I would have said something. It can and does hurt, and you should never set such an event system wide. Furthermore, the event syntax makes no sense. I don't know where you got the syntax for the event, but it is really wrong. What you are essentially asking for is for every process to dump a full errorstack (call stack trace, argument/register address dump, cursor dump, heap dump and PGA dump), every time a process starts up (same as setting 'immediate trace name errorstack...'). Furthermore, this event does not produce a 10046 trace. It just gives you an errorstack. The correct syntax for a 10046 trace is: 10046 trace name context forever, level level This should probably not be set instance-wide in the init.ora in a production system. It uses large amounts of resources. Oracle Support has from time to time tried to convince me to set this event instance-wide, but they are mistaken and misguided. It should be set in the session you want to trace, either using 'alter session set events,' 'dbms_system.set_ev(),' or 'oradebug event...' The correct syntax for an errorstack is: [immediate|errno] trace name errorstack, level level This can be set safely at the instance (init.ora) level if you have it dump on error. If you have it dump on setting the event, as you did, ever server process will have to do this dump when it starts, bringing even a moderately utilized system to its knees. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton 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: Henry Poras 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: Babich , Sergey 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
LOCK!!!
Hi, guys, Trying to figure out what my best option is. Some users are unable to access the system. Previously I had a trace file with Deadlock detected , but that session was killed. SELECT * FROM V$LOCK WHERE block0 or lmode=6 / ADDR KADDR SID TYID1ID2 LMODE REQUEST CTIME BLOCK - -- - - - - - - 037DFE74 037DFE84 3 RT 1 0 6 01464073 0 Any quick advice is appreciated. Best, Sergey -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Babich , Sergey 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!!!
THX -Original Message- Sent: Thursday, January 31, 2002 3:45 PM To: Multiple recipients of list ORACLE-L Subject:RE: LOCK!!! Why dont u check it out from v$session_wait From what u have show below there is not locking issue Check the v$session_wait,you should defnetly see something out there It is better always to come from v$session_Wait If you see any issues there then u got a probs -Original Message- Sent: Thursday, January 31, 2002 3:13 PM To: Multiple recipients of list ORACLE-L Hi, guys, Trying to figure out what my best option is. Some users are unable to access the system. Previously I had a trace file with Deadlock detected , but that session was killed. SELECT * FROM V$LOCK WHERE block0 or lmode=6 / ADDR KADDR SID TYID1ID2 LMODE REQUEST CTIME BLOCK - -- - - - - - - 037DFE74 037DFE84 3 RT 1 0 6 01464073 0 Any quick advice is appreciated. Best, Sergey -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Babich , Sergey 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: Arun Chakrapani 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: Babich , Sergey 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: Session_wait
. Look to them for longer posts with more explanation. Good Luck! - Ross -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross 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: Babich , Sergey 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: Mohan, Ross 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: Babich , Sergey 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: Session_wait
Thanks a lot. That's what a lack of knowledge does... Regards, Dummy -Original Message- Sent: Wednesday, January 30, 2002 11:56 AM To: Multiple recipients of list ORACLE-L Subject:RE: Session_wait On Wed, 30 Jan 2002, Babich , Sergey wrote: However, I made the following entry into init.ora file: Event= 10046 trace name errorstack level 12 and it rebooted over the weekend. Then I got a call from my boss on Monday morning (I was home sick) letting me know the system had come to a crawl and was producing a trace file every minute or so. Eventually, after some speculations, I told him to rem out that entry and reboot. That resolved the issue, but left me puzzled. Oh, boy, I couldn't understand who would tell you to do that on a production system, so I looked back in the archives and found this exchange: Sergey writes: Since I didn't expect that to happen, I had just SQL trace turned on for that particular session. Do you suggest entering event=10046 trace name errorstack level 12 into init.ora? Henry writes: Couldn't hurt. Also why not do some deltas of your session statistics (before and after snapshots) I wish I had been paying more attention when this exchange was happening, as I would have said something. It can and does hurt, and you should never set such an event system wide. Furthermore, the event syntax makes no sense. I don't know where you got the syntax for the event, but it is really wrong. What you are essentially asking for is for every process to dump a full errorstack (call stack trace, argument/register address dump, cursor dump, heap dump and PGA dump), every time a process starts up (same as setting 'immediate trace name errorstack...'). Furthermore, this event does not produce a 10046 trace. It just gives you an errorstack. The correct syntax for a 10046 trace is: 10046 trace name context forever, level level This should probably not be set instance-wide in the init.ora in a production system. It uses large amounts of resources. Oracle Support has from time to time tried to convince me to set this event instance-wide, but they are mistaken and misguided. It should be set in the session you want to trace, either using 'alter session set events,' 'dbms_system.set_ev(),' or 'oradebug event...' The correct syntax for an errorstack is: [immediate|errno] trace name errorstack, level level This can be set safely at the instance (init.ora) level if you have it dump on error. If you have it dump on setting the event, as you did, ever server process will have to do this dump when it starts, bringing even a moderately utilized system to its knees. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton 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: Babich , Sergey 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: Session_wait
84233 SQL*Net roundtrips to/from client 342 buffer is not pinned count 73513922 I see some updates (or inserts) and heavy reads...at first glance, though, you don't appear to be I/O throttled but likely have inefficiencies in buffer cache. Pin some small tables? Reexamine access paths for fts, even if on small tables (generally defined to be around 5% in blocks of buffer cache size?)and consider seeking out and destroying nested loops joins in favor of hash joins. There's more CPU, but less buffer cache splashing arounddon't forget to review init.ora settings for hash, buffer pools, and query planning. (...be happy to do a flyover of those as well, if you like.) That's about all i can get in a one minute glance, but there are alot of people on the list who'll see more. Look to them for longer posts with more explanation. Good Luck! - Ross -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross 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: Babich , Sergey 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: Mohan, Ross 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: Babich , Sergey 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 is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir 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
RE: Session_wait
table scans), why are they present? Perform a trace and TKPROF it. If you post the output, we could help further. My feeling is that 'Database' or 'Instance' level tuning via init parameters isn't going to get you much mileage. However, SQL tuning certainly will! Have a nice weekend, all! John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Fear is the darkroom where Evil develops your negatives. Wanna break free of fear? Click on 'http://www.needhim.org' ** The opinions and statements above are entirely my own and not those of my employer or clients ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj 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: Babich , Sergey 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: Session_wait
Sergey, please run this and post values. Just curious. select name, value from v$sesstat vs, v$statname sn where vs.statistic#=sn.statistic# and value is NOT NULL and value0 and sid=11; hth, - Ross p.s. shadow process - your client connection's 'footprint' in the os. if a local host connect, look for LOCAL=YES. If not, look for LOCAL=NO. Sort out all not in your instance name. -Original Message- Sent: Tuesday, January 22, 2002 4:57 PM To: Multiple recipients of list ORACLE-L Well, now it's finished, but the timing is terrible... I should've queried v$lock. RAID had a lot of activity while that was going on. File #10 is a data datafile. I am not sure what is meant by shadow process, sorry. I guess we'll repeat this tomorrow. Thank you, guys, I really appreciate your help. Best regards, Sergey -Original Message- Sent: Tuesday, January 22, 2002 4:36 PM To: Multiple recipients of list ORACLE-L Subject:RE: Session_wait well, then it's an entirely different kettle of fish. Jeremiah is on track. don't suppose you can query v$lock where sid=11 or block0 or lmode=6 while this is going on, can you? and...in the OSwhat is going on w/disk? and with the shadow process? and, lastly, what is file# 10? Probably a data datafile... -Original Message- Sent: Tuesday, January 22, 2002 4:11 PM To: Multiple recipients of list ORACLE-L Thanks for your input, but P2 was not changing as u can c from the last one I caught: SID SEQ# EVENT P1TEXT P1 P1RAW P2TEXT P2 P2RAW P3TEXT P3 P3RAW WAIT_TIME SEC_WT STATE - - - -- - -- - -- - - -- --- 11 40019 db file sequential readfile# 10 000A block# 221571 00036183 blocks 1 0001 -1 1594 WAITED SHORT TIME After that the SQL changed Regards, Sergey Babich -Original Message- Sent: Tuesday, January 22, 2002 3:32 PM To: Multiple recipients of list ORACLE-L Subject:RE: Session_wait it was reading blocks into SGA buffers. No big deal. As the wait time went up, so likely were the values of P2 changing. A longish read by sid 11. shrug -Original Message- Sent: Tuesday, January 22, 2002 3:19 PM To: Multiple recipients of list ORACLE-L Hi, listers, One of the sessions seems to be a problem: SELECT * FROM V$SESSION_WAIT WHERE SID=NUM / Output: SID SEQ# EVENT P1TEXT P1 P1RAW P2TEXT P2 P2RAW P3TEXT P3 P3RAW WAIT_TIME SEC_WT STATE - - - -- - -- - -- - - -- --- 11 40019 db file sequential readfile# 10 000A block# 221571 00036183 blocks 1 0001 -1 335 WAITED SHORT TIME Then wait_time was 689, then 749 and higher and higher (the rest of the output being the same). Any su ggestions are appreciated. Regards, Sergey Babich -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Babich , Sergey 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: Mohan, Ross 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: Babich , Sergey 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
RE: Session_wait
WAIT_TIME SEC_WT STATE - - - -- - -- - -- - - -- --- 11 40019 db file sequential readfile# 10 000A block# 221571 00036183 blocks 1 0001 -1 335 WAITED SHORT TIME Then wait_time was 689, then 749 and higher and higher (the rest of the output being the same). Any su ggestions are appreciated. Regards, Sergey Babich -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Babich , Sergey 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: Mohan, Ross 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: Babich , Sergey 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: Mohan, Ross 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: Babich , Sergey 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: Mohan, Ross 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: Babich , Sergey 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
RE: Session_wait
Hi, Ross, This has been running for about 4 hours now. I got an SQL trace file, and looked at the execution plans. So here's the deal. There's an interesting join condition ...where A.col1=B.col1.. However, A has a few hundred distinct values in that column, none of them being NULL, and B, which has a few hundred thousand rows, has ALL NULLs in the corresponding column, and that column is not indexed, too. That's the query where it sits for a couple of hours. Guess what the optimizer is doing (8i)? I think internal effects are secondary in this scenario. It is the production (including the database) designed by the company named DELTEK, so nobody can change the code. Anyway, I reported my findings... Thank you very much for your help, it's always appreciated. Best, Sergey -Original Message- Sent: Friday, January 25, 2002 12:56 PM To: Multiple recipients of list ORACLE-L Subject:RE: Session_wait This is a busy little beaver...how long you say this runs? opened cursors cumulative 1072 session logical reads 77233609 db block gets 2642119 consistent gets74591490 physical reads 148822 db block changes3005410 consistent changes 141 no work - consistent read gets 72058049 table scans (short tables) 210918 table scans (long tables)36 table scan rows gotten798264962 table scan blocks gotten 71788386 table fetch by rowid1074164 leaf node splits 4018 execute count 74445 bytes sent via SQL*Net to client 59650 bytes received via SQL*Net from client84233 SQL*Net roundtrips to/from client 342 buffer is not pinned count 73513922 I see some updates (or inserts) and heavy reads...at first glance, though, you don't appear to be I/O throttled but likely have inefficiencies in buffer cache. Pin some small tables? Reexamine access paths for fts, even if on small tables (generally defined to be around 5% in blocks of buffer cache size?)and consider seeking out and destroying nested loops joins in favor of hash joins. There's more CPU, but less buffer cache splashing arounddon't forget to review init.ora settings for hash, buffer pools, and query planning. (...be happy to do a flyover of those as well, if you like.) That's about all i can get in a one minute glance, but there are alot of people on the list who'll see more. Look to them for longer posts with more explanation. Good Luck! - Ross -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross 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: Babich , Sergey 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: Session_wait
Hi, Cherie, Sorry for the delayed reply. Yes, I already did, and analyzed the table, too. But, logically, will it do any good given that one of the columns in join condition has NULLs only, the other being everything but NULL? Anyway, I'll test it again. Thanks for your reply. Best have a great weekend. Sergey -Original Message- Sent: Friday, January 25, 2002 2:44 PM To: Multiple recipients of list ORACLE-L Subject:RE: Session_wait Sergey, Have you considered adding an index to that queried column in table B? Many third-party vendors allow the DBA to add indexes even when they won't allow them to alter the code. Something to consider. Cherie Machler Oracle DBA Gelco Information Network Babich , Sergey To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] SBabich@hande cc: xmail.com Subject: RE: Session_wait Sent by: [EMAIL PROTECTED] om 01/25/02 12:31 PM Please respond to ORACLE-L Hi, Ross, This has been running for about 4 hours now. I got an SQL trace file, and looked at the execution plans. So here's the deal. There's an interesting join condition ...where A.col1=B.col1.. However, A has a few hundred distinct values in that column, none of them being NULL, and B, which has a few hundred thousand rows, has ALL NULLs in the corresponding column, and that column is not indexed, too. That's the query where it sits for a couple of hours. Guess what the optimizer is doing (8i)? I think internal effects are secondary in this scenario. It is the production (including the database) designed by the company named DELTEK, so nobody can change the code. Anyway, I reported my findings... Thank you very much for your help, it's always appreciated. Best, Sergey -Original Message- Sent: Friday, January 25, 2002 12:56 PM To:Multiple recipients of list ORACLE-L This is a busy little beaver...how long you say this runs? opened cursors cumulative 1072 session logical reads 77233609 db block gets 2642119 consistent gets74591490 physical reads 148822 db block changes3005410 consistent changes 141 no work - consistent read gets 72058049 table scans (short tables) 210918 table scans (long tables)36 table scan rows gotten798264962 table scan blocks gotten 71788386 table fetch by rowid1074164 leaf node splits 4018 execute count 74445 bytes sent via SQL*Net to client 59650 bytes received via SQL*Net from client84233 SQL*Net roundtrips to/from client 342 buffer is not pinned count 73513922 I see some updates (or inserts) and heavy reads...at first glance, though, you don't appear to be I/O throttled but likely have inefficiencies in buffer cache. Pin some small tables? Reexamine access paths for fts, even if on small tables (generally defined to be around 5% in blocks of buffer cache size?)and consider seeking out and destroying nested loops joins in favor of hash joins. There's more CPU, but less buffer cache splashing arounddon't forget to review init.ora settings for hash, buffer pools, and query planning. (...be happy to do a flyover of those as well, if you like.) That's about all i can get in a one minute glance, but there are alot of people on the list who'll see more. Look to them for longer posts with more explanation. Good Luck! - Ross -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross 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
RE: SCOTT/TIGER
Obviously, that was Scott's sYster... And she had to change after installing Oracle on some dirty boxes... -Original Message- Sent: Wednesday, January 23, 2002 10:50 PM To: Multiple recipients of list ORACLE-L Subject:RE: SCOTT/TIGER So who was SYS, and why on earth did s/he name his/her pet CHANGE_ON_INSTALL??? :-) [EMAIL PROTECTED] 24/1/2002 12:00:27 This message has been scanned by MAILSweeper. The name I was given is Scott Gossett. My team leader and one of our team members took the advanced seminars last year, and their instructor was Scott, and he admitted his notoriety. -Original Message- Sent: Wednesday, January 23, 2002 4:00 PM To: Multiple recipients of list ORACLE-L there are several instructors named Scott how do you know which one it is or even if it's one of the instructors? --- Vergara, Michael (TEM) [EMAIL PROTECTED] wrote: Ok...it's true. Take the Oracle Technical seminars and you too may get to meet Scott, Live and In Person. Unfortunately, Tiger is waiting for Scott at the Rainbow Bridge, but Scott is still there (at least he was last year...you know how Oracle's been lately). -Original Message- Sent: Wednesday, January 23, 2002 10:26 AM To: Multiple recipients of list ORACLE-L I was once told with certainty from an Oracle instructor that Scott was an early developer, and Tiger was his cat. But without actually meeting Scott I take this with a grain of salt. I expect there are many urban legends surrounding this. Jim -Original Message- Sent: Wednesday, January 23, 2002 11:45 AM To: Multiple recipients of list ORACLE-L Anyone out there know the history of this? -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) 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 and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arn Klammer 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: Babich , Sergey 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: Session_wait
to run the query, but later on we'll run the OLTP again, and then I'll do it and post the output. Currently I'm analyzing the trace file which is about 130M (did not tkprof it yet), and that size does NOT sound healthy to me. Best regards, Sergey Babich -Original Message- Sent: Tuesday, January 22, 2002 5:19 PM To: Multiple recipients of list ORACLE-L Subject:RE: Session_wait Sergey, please run this and post values. Just curious. select name, value from v$sesstat vs, v$statname sn where vs.statistic#=sn.statistic# and value is NOT NULL and value0 and sid=11; hth, - Ross p.s. shadow process - your client connection's 'footprint' in the os. if a local host connect, look for LOCAL=YES. If not, look for LOCAL=NO. Sort out all not in your instance name. -Original Message- Sent: Tuesday, January 22, 2002 4:57 PM To: Multiple recipients of list ORACLE-L Well, now it's finished, but the timing is terrible... I should've queried v$lock. RAID had a lot of activity while that was going on. File #10 is a data datafile. I am not sure what is meant by shadow process, sorry. I guess we'll repeat this tomorrow. Thank you, guys, I really appreciate your help. Best regards, Sergey -Original Message- Sent: Tuesday, January 22, 2002 4:36 PM To: Multiple recipients of list ORACLE-L Subject:RE: Session_wait well, then it's an entirely different kettle of fish. Jeremiah is on track. don't suppose you can query v$lock where sid=11 or block0 or lmode=6 while this is going on, can you? and...in the OSwhat is going on w/disk? and with the shadow process? and, lastly, what is file# 10? Probably a data datafile... -Original Message- Sent: Tuesday, January 22, 2002 4:11 PM To: Multiple recipients of list ORACLE-L Thanks for your input, but P2 was not changing as u can c from the last one I caught: SID SEQ# EVENT P1TEXT P1 P1RAW P2TEXT P2 P2RAW P3TEXT P3 P3RAW WAIT_TIME SEC_WT STATE - - - -- - -- - -- - - -- --- 11 40019 db file sequential readfile# 10 000A block# 221571 00036183 blocks 1 0001 -1 1594 WAITED SHORT TIME After that the SQL changed Regards, Sergey Babich -Original Message- Sent: Tuesday, January 22, 2002 3:32 PM To: Multiple recipients of list ORACLE-L Subject:RE: Session_wait it was reading blocks into SGA buffers. No big deal. As the wait time went up, so likely were the values of P2 changing. A longish read by sid 11. shrug -Original Message- Sent: Tuesday, January 22, 2002 3:19 PM To: Multiple recipients of list ORACLE-L Hi, listers, One of the sessions seems to be a problem: SELECT * FROM V$SESSION_WAIT WHERE SID=NUM / Output: SID SEQ# EVENT P1TEXT P1 P1RAW P2TEXT P2 P2RAW P3TEXT P3 P3RAW WAIT_TIME SEC_WT STATE - - - -- - -- - -- - - -- --- 11 40019 db file sequential readfile# 10 000A block# 221571 00036183 blocks 1 0001 -1 335 WAITED SHORT TIME Then wait_time was 689, then 749 and higher and higher (the rest of the output being the same). Any su ggestions are appreciated. Regards, Sergey Babich -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Babich , Sergey 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: Mohan, Ross 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
RE: Session_wait
and higher and higher (the rest of the output being the same). Any su ggestions are appreciated. Regards, Sergey Babich -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Babich , Sergey 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: Mohan, Ross 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: Babich , Sergey 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: Mohan, Ross 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: Babich , Sergey 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: Mohan, Ross 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: Babich , Sergey 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: Henry Poras INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
RE: HP vs SUN for a UNIX box
Message- Sent: Friday, January 18, 2002 12:51 PM To: Multiple recipients of list ORACLE-L Hi, dear listers, My boss has decided to switch production to a UNIX box and now he's asking me for a recommendation between HP and SUN. I am a newbee to UNIX (to put it the softest way). I've heard people say HP is better, but need more than that... The DB itself is about 40G on RAID (currently on Windoze 2k). Any advice is greatly appreciated. Regards, Sergey Babich -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Babich , Sergey 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: Smith, Ron L. 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: Sherman, Paul R. 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: Babich , Sergey 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: DENNIS WILLIAMS 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: Babich , Sergey 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: DENNIS WILLIAMS 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
RE: Connect as sysdba on 9i
Title: Connect as sysdba on 9i That exactly connects you as SYS which u can check with SHOW USER Just my $.02. Regards, Sergey Babich -Original Message-From: eric harrington [mailto:[EMAIL PROTECTED]]Sent: Tuesday, January 22, 2002 8:45 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Connect as sysdba on 9i Try: sqlplus "/ as sysdba" I suspect the / indicates current OS user and if you belong to the SYSDBA or SYSOPER groups then you will be connected. SYS is probably not a member of these groups. I haven't tested this. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Daiminger, HelmutSent: Tuesday, January 22, 2002 7:05 AMTo: Multiple recipients of list ORACLE-LSubject: Connect as sysdba on 9i Hi! I have a question concerning "connect sys as sydba" on 9i. When I open sqlplus and connect as sysdba (I'm logged in as the Unix oracle user): sqlplus "sys as sysdba" Oracle asks for a password. Even if I type in the wrong password, I am connected to Oracle. So does Oracle just use the OS authentication (like connect internal did on 8i)? But why is Oracle asking for a password in the first place then? Any ideas? This is 9.0.1 on Sun Solaris. Thanks, Helmut
RE: RE: HP vs SUN for a UNIX box
Thank you so very much. Best regards, Sergey -Original Message- Sent: Friday, January 18, 2002 5:16 PM To: Multiple recipients of list ORACLE-L Subject:Re:RE: HP vs SUN for a UNIX box Sergey, I asked my SA to add his 2 cents, guess he's not inclined. Anyway, I've been on HP for the last 10 years, coming from VMS, I love it. VERY stable, easy to use, although I don't do the admin any longer it was easy with SAM even when it was a character based tool. Rman/OmniBack integration is well documented in the OmniBack manuals works as advertised. HP support is pretty darn good as well, especially in the middle of the night when the system won't boot. I've had HP support tech's remotely logged in to the system helping get it back online. Also if you have a problem that is not in the area of the tech you call they normally conference in the needed assistance. Problems can be resolved as fast as they occur. We also don't use disk arrays from HP, but then HP EMC really like each other. If you want an inexpensive disk alternative look into NetAppliance. Dick Goulet Senior Oracle DBA Reply Separator Author: Babich ; Sergey [EMAIL PROTECTED] Date: 1/18/2002 1:25 PM Thank you, Paul, I'll forward it to my boss... Anyone else to add to it? Thank you very much, Sergey Babich -Original Message- Sent: Friday, January 18, 2002 3:55 PM To: Multiple recipients of list ORACLE-L Stay with HP. It's a hell of a lot more reliable, and does not require anywhere near the # of patches, and its patches work far more often that Sun's. I've done 5 years with each, and there's no question that HP is superior. Thank you, Paul Sherman DBA voice - 781-501-4143 (office) fax- 781-278-8341 (office) email - [EMAIL PROTECTED] -Original Message- Sent: Friday, January 18, 2002 3:00 PM To: Multiple recipients of list ORACLE-L Our shop is switching from HP to Sun. No one can tell me why. There must be a cost savings somewhere. -Original Message- Sent: Friday, January 18, 2002 12:51 PM To: Multiple recipients of list ORACLE-L Hi, dear listers, My boss has decided to switch production to a UNIX box and now he's asking me for a recommendation between HP and SUN. I am a newbee to UNIX (to put it the softest way). I've heard people say HP is better, but need more than that... The DB itself is about 40G on RAID (currently on Windoze 2k). Any advice is greatly appreciated. Regards, Sergey Babich -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Babich , Sergey 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: Smith, Ron L. 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: Sherman, Paul R. 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: Babich , Sergey 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
RE: RE: HP vs SUN for a UNIX box
I want to thank everyone for the input. Best regards, Sergey Babich 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: Babich , Sergey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Babich , Sergey 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: HP vs SUN for a UNIX box
Thanks, Dennis, my boss is thinking HP already. As far as flavor of UNIX, that wouldn't matter much. I'll have to learn it from scratch anyway. Best regards, Sergey -Original Message- Sent: Monday, January 21, 2002 3:25 PM To: Multiple recipients of list ORACLE-L Subject:RE: HP vs SUN for a UNIX box Sergey - Sorry for the confusion. Our ERP system is Lawson and I somehow had a brain fart and thought you were on that email list. If you management is just thinking about Unix, then the last thing you want to do is scare them off with an argument about which Unix. Start every reply with of course all these are excellent choices and it will be no doubt difficult to choose between these really great systems. It sounds as if your application won't be very dependent on the flavor of Unix, so then you don't need to be so concerned about the long-term trends. Boxes are easier to replace than in-house developed software, it's just that software doesn't show up in the financial reports. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, January 21, 2002 7:45 AM To: Multiple recipients of list ORACLE-L Hi, Dennis, Just got back to work and found your message. It's a shame, but I don't know what Lawson is. Well, I used to be a chemical engineer in Soviet Union and didn't know Oracle existed... Anyway, I appreciate your reply. As far as that box, it's supposed to be a box for our main production. We have a pretty simple financial application, but huge OLTP and A LOT of reports. There's no programming except for my short scripts which I create to extend the app functionality (it is VERY old). The company is very lax on investments. Nonetheless, they're contemplating a switch to UNIX, and that I call a major move! Let's see what happens. Thanks for your reply again. Best regards, Sergey -Original Message- Sent: Friday, January 18, 2002 5:16 PM To: Multiple recipients of list ORACLE-L Subject:RE: HP vs SUN for a UNIX box Sergey - One factor you may want to consider is the timeframe of your decision. If it is just a decision for your Lawson box, then that isn't so critical. It is pretty easy to move Lawson from one system to another. Last fall we were looking at making a decision for all our systems. We are on Compaq Tru64, and that doesn't have a long future ahead of it. The META Group advice was that only three operating systems can be considered to have a stable future: 1. MS W2K 2. Linux 3. Solaris Most of the other Unix vendors are facing the next generation of computer chip architecture. I don't believe that HP is investing in the next generation itself, but will be switching to the new Intel 64-bit chips. Based on that advice, we chose Solaris because W2K and Linux are not up to the same standards as Solaris today. To repeat, we are looking at a lot of programming beyond Lawson, so our decision was based on more than simply purchasing the next box. We will have our Lawson system on Tru64 for several more years. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, January 18, 2002 3:25 PM To: Multiple recipients of list ORACLE-L Thank you, Paul, I'll forward it to my boss... Anyone else to add to it? Thank you very much, Sergey Babich -Original Message- Sent: Friday, January 18, 2002 3:55 PM To: Multiple recipients of list ORACLE-L Subject:RE: HP vs SUN for a UNIX box Stay with HP. It's a hell of a lot more reliable, and does not require anywhere near the # of patches, and its patches work far more often that Sun's. I've done 5 years with each, and there's no question that HP is superior. Thank you, Paul Sherman DBA voice - 781-501-4143 (office) fax- 781-278-8341 (office) email - [EMAIL PROTECTED] -Original Message- Sent: Friday, January 18, 2002 3:00 PM To: Multiple recipients of list ORACLE-L Our shop is switching from HP to Sun. No one can tell me why. There must be a cost savings somewhere. -Original Message- Sent: Friday, January 18, 2002 12:51 PM To: Multiple recipients of list ORACLE-L Hi, dear listers, My boss has decided to switch production to a UNIX box and now he's asking me for a recommendation between HP and SUN. I am a newbee to UNIX (to put it the softest way). I've heard people say HP is better, but need more than that... The DB itself is about 40G on RAID (currently on Windoze 2k). Any advice is greatly appreciated. Regards, Sergey Babich -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Babich , Sergey 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
HP vs SUN for a UNIX box
Hi, dear listers, My boss has decided to switch production to a UNIX box and now he's asking me for a recommendation between HP and SUN. I am a newbee to UNIX (to put it the softest way). I've heard people say HP is better, but need more than that... The DB itself is about 40G on RAID (currently on Windoze 2k). Any advice is greatly appreciated. Regards, Sergey Babich -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Babich , Sergey 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: HP vs SUN for a UNIX box
Thank you, Paul, I'll forward it to my boss... Anyone else to add to it? Thank you very much, Sergey Babich -Original Message- Sent: Friday, January 18, 2002 3:55 PM To: Multiple recipients of list ORACLE-L Subject:RE: HP vs SUN for a UNIX box Stay with HP. It's a hell of a lot more reliable, and does not require anywhere near the # of patches, and its patches work far more often that Sun's. I've done 5 years with each, and there's no question that HP is superior. Thank you, Paul Sherman DBA voice - 781-501-4143 (office) fax- 781-278-8341 (office) email - [EMAIL PROTECTED] -Original Message- Sent: Friday, January 18, 2002 3:00 PM To: Multiple recipients of list ORACLE-L Our shop is switching from HP to Sun. No one can tell me why. There must be a cost savings somewhere. -Original Message- Sent: Friday, January 18, 2002 12:51 PM To: Multiple recipients of list ORACLE-L Hi, dear listers, My boss has decided to switch production to a UNIX box and now he's asking me for a recommendation between HP and SUN. I am a newbee to UNIX (to put it the softest way). I've heard people say HP is better, but need more than that... The DB itself is about 40G on RAID (currently on Windoze 2k). Any advice is greatly appreciated. Regards, Sergey Babich -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Babich , Sergey 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: Smith, Ron L. 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: Sherman, Paul R. 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: Babich , Sergey 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: HP vs SUN for a UNIX box
Thanks, it is very important to me Regards, Serge -Original Message- Sent: Friday, January 18, 2002 4:05 PM To: Multiple recipients of list ORACLE-L Subject:RE: HP vs SUN for a UNIX box Using both HP 11.0 and Solaris 2.8, I have a preference for HP. Just little toolset things like SAM for a GUI SysAdmin, top and GlancePlus, although GlancePlus, a system monitor, I guess I would consider a huge advantage over what Sun offers. As far as the hardware, I guess I don't have a huge preference either way. But if you do go with HP -- DO NOT GET AN AutoRAID! Biggest performance mistake we've made, IMO. Super slow writes. Just my $.02... Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Friday, January 18, 2002 12:51 PM To: Multiple recipients of list ORACLE-L Hi, dear listers, My boss has decided to switch production to a UNIX box and now he's asking me for a recommendation between HP and SUN. I am a newbee to UNIX (to put it the softest way). I've heard people say HP is better, but need more than that... The DB itself is about 40G on RAID (currently on Windoze 2k). Any advice is greatly appreciated. Regards, Sergey Babich -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich 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: Babich , Sergey 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).
HP vs SUN for a UNIX box
-Original Message- Sent: Friday, January 18, 2002 1:48 PM To: '[EMAIL PROTECTED]' Subject:HP vs SUN for a UNIX box Hi, dear listers, My boss has decided to switch production to a UNIX box and now he's asking me for a recommendation between HP and SUN. I am a newbee to UNIX (to put it the softest way). I've heard people say HP is better, but need more than that... The DB itself is about 40G on RAID (currently on Windoze 2k). Any advice is greatly appreciated. Regards, Sergey Babich -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Babich , Sergey 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: ORA-01555: snapshot too old: rollback segment number...
Hi, Viktor, Have any long transactions been running parallel to the export when it happened? And do you specify the parameter CONSISTENT=Y for the export? Regards,, Sergey Babich -Original Message- Sent: Tuesday, January 15, 2002 12:20 PM To: Multiple recipients of list ORACLE-L Subject:ORA-01555: snapshot too old: rollback segment number... Hi all, Last nignt when we were expring data for one of our databases, this error ocurred: ORA-01555: snapshot too old: rollback segment number 3 with name R02) offset=(0). Now, we were able to once again export and load data this morning. And there was no error. What is the best aproach to try to eliminate this error in the future? Any suggestions apreciated. Thanks Regards __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viktor 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: Babich , Sergey 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: HOW TO MAKE DELETION FAST
Hi, Seema, I f the issue is still current, deletions taking too much time may be caused by not indexed foreign keys. If the child table does not have an index on a column which references the parent one, to delete even a single row Oracle performs full table scan which locks the table, too. It is a serious issue when tables are huge. So I'd check for unindexed foreign keys first. Regards, Sergey Babich -Original Message- Sent: Thursday, January 10, 2002 6:05 PM To: Multiple recipients of list ORACLE-L Subject:HOW TO MAKE DELETION FAST Hi I want to delete milliuns of row from one table.that table have 2 constraints and some indexes.What to do for fast deletion.When ever I run deletion it takes time too. Thanks -Seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh 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: Babich , Sergey 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: SQL for top 100 values
Correction : SELECT * FROM (SELECT DISTINCT VALUES FROM TABLE ORDER BY VALUES DESC) WHERE ROWNUM 101; -Original Message- Sent: Thursday, January 10, 2002 11:51 AM To: Multiple recipients of list ORACLE-L Subject:Re: SQL for top 100 values SELECT * FROM (SELECT VALUES FROM TABLE ORDER BY VALUES) ROWNUM 101; Deen Dayal ddayal To: Multiple recipients of list ORACLE-L @dol.state.nj[EMAIL PROTECTED] .us cc: Sent by: rootSubject: SQL for top 100 values 01/10/2002 11:03 AM Please respond to ORACLE-L hi SQL wizards, Can any body help me with the tjis SQL. I need a SQL records with top 100 values of a table ( not rownum 101 ). Thanks Deen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deen Dayal 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: 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: Babich , Sergey 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: SQL for top 100 values
Don't use any aliases (x in your case) and try again Regards -Original Message- Sent: Thursday, January 10, 2002 12:32 PM To: Multiple recipients of list ORACLE-L Subject:RE: SQL for top 100 values I tried to run it in Oracle 7.3.4, it comes up with a syntax error Here is the SQL select x.fein,x.open_bal from (select sf_get_fein(employer_id) fein, nvl(total_open_balance_amt,0) open_bal from employer order by open_bal desc ) x where rownum 101 Here is what I get SQLWKS select x.fein,x.open_bal 2 from (select sf_get_fein(employer_id) fein, nvl(total_open_balance_amt,0) open_bal 3 from employer 4 order by open_bal desc ) x 5 where rownum 101 6 order by open_bal desc ) x * ORA-00907: missing right parenthesis Is it because I am on a lower version Thanks Deen -Original Message- Faroult Sent: Thursday, January 10, 2002 11:26 AM To: Multiple recipients of list ORACLE-L Deen Dayal wrote: hi SQL wizards, Can any body help me with the tjis SQL. I need a SQL records with top 100 values of a table ( not rownum 101 ). Thanks Deen rownum 101 is OK if you nest your query, ORDER BY included, as an in-line view, ie select x.val from (select val from my_table order by val desc) x where rownum 101 -- Regards, Stephane Faroult Oriole Ltd -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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: Deen Dayal 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: Babich , Sergey 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: SQL for top 100 values
You may be right, that's the version issue -Original Message- Sent: Thursday, January 10, 2002 12:32 PM To: Multiple recipients of list ORACLE-L Subject:RE: SQL for top 100 values I tried to run it in Oracle 7.3.4, it comes up with a syntax error Here is the SQL select x.fein,x.open_bal from (select sf_get_fein(employer_id) fein, nvl(total_open_balance_amt,0) open_bal from employer order by open_bal desc ) x where rownum 101 Here is what I get SQLWKS select x.fein,x.open_bal 2 from (select sf_get_fein(employer_id) fein, nvl(total_open_balance_amt,0) open_bal 3 from employer 4 order by open_bal desc ) x 5 where rownum 101 6 order by open_bal desc ) x * ORA-00907: missing right parenthesis Is it because I am on a lower version Thanks Deen -Original Message- Faroult Sent: Thursday, January 10, 2002 11:26 AM To: Multiple recipients of list ORACLE-L Deen Dayal wrote: hi SQL wizards, Can any body help me with the tjis SQL. I need a SQL records with top 100 values of a table ( not rownum 101 ). Thanks Deen rownum 101 is OK if you nest your query, ORDER BY included, as an in-line view, ie select x.val from (select val from my_table order by val desc) x where rownum 101 -- Regards, Stephane Faroult Oriole Ltd -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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: Deen Dayal 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: Babich , Sergey 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: Clone a database
Hi, Beatriz, If you want to create an identical copy of your production (that's my understanding), it is a lot easier to export it (FULL=Y) and then import the dump file into your new database. Let me know if you need more info. Regards, Sergey Babich, Oracle DBA -Original Message- Sent: Wednesday, January 09, 2002 4:50 AM To: Multiple recipients of list ORACLE-L Subject:Clone a database Hello list, I new to clone a database for changing between test to production. The new database is going to be in a different host. I have the copy obtained through the enterprise manager (I suppose it´s a cold backup). Which are the steps I should follow? A lot of thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Beatriz =?iso-8859-1?Q?Mart=EDnez=20Jim=E9nez?= 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: Babich , Sergey 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: Clone a database
With all my respect, this is not always the case Best regards, Serge -Original Message- Sent: Wednesday, January 09, 2002 10:15 AM To: Multiple recipients of list ORACLE-L Subject:RE: Clone a database easier perhaps only if you have the exact same disk layouts and space available. and certainly MUCH more time to create -- an import takes anywhere from 2-4 times as long as the export did. --- Babich , Sergey [EMAIL PROTECTED] wrote: Hi, Beatriz, If you want to create an identical copy of your production (that's my understanding), it is a lot easier to export it (FULL=Y) and then import the dump file into your new database. Let me know if you need more info. Regards, Sergey Babich, Oracle DBA -Original Message- Sent: Wednesday, January 09, 2002 4:50 AM To: Multiple recipients of list ORACLE-L Subject: Clone a database Hello list, I new to clone a database for changing between test to production. The new database is going to be in a different host. I have the copy obtained through the enterprise manager (I suppose it´s a cold backup). Which are the steps I should follow? A lot of thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Beatriz =?iso-8859-1?Q?Mart=EDnez=20Jim=E9nez?= 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: Babich , Sergey 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). __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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: Babich , Sergey 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: Clone a database
Thanks -Original Message- Sent: Wednesday, January 09, 2002 1:25 PM To: Multiple recipients of list ORACLE-L Subject:RE: Clone a database This message uses a character set that is not supported by the Internet Service. To view the original message content, open the attached message. If the text doesn't display correctly, save the attachment to disk, and then open it using a viewer that can display the original character set. File: message.txt -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Babich , Sergey 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: CHAINED ROWS
It depends on the number. If it's a real high number on the tables that are actively involved in OLTP (or just queried a lot, for that matter), chained (or migrated) rows will definitely slow down the processing. In this case you can either use EXP/IMP on the tables or create a copy of the table (CTAS), truncate the table and INSERT INTO ...(...) SELECT (*)...; Regards, Sergey Babich, Oracle DBA -Original Message-From: Bunyamin K. Karadeniz [mailto:[EMAIL PROTECTED]]Sent: Tuesday, January 08, 2002 8:36 AMTo: Multiple recipients of list ORACLE-LSubject: CHAINED ROWS I have seen that There are some number of chained rows in several tables of a schema in my database . What is it done in such a situation ? Thank you Bunyamin
RE: Convert ACESS to Oracle
Hi, I would think the general idea could be converting all the tables into flat files and then loading them into your Oracle pre-built database ( you have to create schemas, of course) using SQLLDR. If you have any integrity constraints, I think you will have to manually create them in Oracle. Try a search on GOOGLE.com. Very helpful. Regards, Sergey Babich -Original Message- Sent: Tuesday, January 08, 2002 11:31 AM To: Multiple recipients of list ORACLE-L Subject:Convert ACESS to Oracle Group, Can anyone please give me links, steps, document or step by step procedures to convert an Access database to an Oracle database? Also, please include any 'Gottcha's'. Thanks Al Rusnak DeCA: 804-734-8453 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rusnak, George A. 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: Babich , Sergey 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: Convert ACESS to Oracle
http://www.bunkerhill.com/Mig2Ora.html -Original Message- Sent: Tuesday, January 08, 2002 11:31 AM To: Multiple recipients of list ORACLE-L Subject:Convert ACESS to Oracle Group, Can anyone please give me links, steps, document or step by step procedures to convert an Access database to an Oracle database? Also, please include any 'Gottcha's'. Thanks Al Rusnak DeCA: 804-734-8453 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rusnak, George A. 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: Babich , Sergey 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: Using Import/Export thru DBA studio requires OMS
Hi, colleagues, Could not agree more with Mr. Sherman. DBA STUDIO is NOT for that. Real pros use EXP/IMP Regards, Sergey E. Babich, Oracle DBA -Original Message- Sent: Monday, January 07, 2002 4:11 PM To: Multiple recipients of list ORACLE-L Subject:RE: Using Import/Export thru DBA studio requires OMS Hello all, If you take my advise, you will never, ever use DBA studio for exports or imports. To do it the correct DBA-approved-and-time-honored way is to do command line execution, either through an interactive session (if you are new to imp/exp), or use of full command line, or use of parfiles. Exports and imports are way too important to use DBA studio on. Be sure to use log files to review possible imp/exp errors. Thank you, Paul Sherman DBA voice - 781-501-4143 (office) fax- 781-278-8341 (office) email - [EMAIL PROTECTED] -Original Message- Sent: Monday, January 07, 2002 3:46 PM To: Multiple recipients of list ORACLE-L - Original Message - Platform is Win Nt Oracle 8.1.6. When I try to use import/export utilities in DBA studio I get a message stating I must access thru Oracle Management Server. I have search and cannot find a step by step on how to set up OMS so I can use import/export in DBA studios. Can someone help or point me to some links that will provide what I need. I wouldn't recommend messing with OMS just for export/import. Why don't u use the command line utilities? Anyways, the docs for OMS version u need are at http://technet.oracle.com/docs/products/oem/doc_library/3packs/InstallGuide/ html/toc.htm and the distribution is available at http://technet.oracle.com/software/products/oem/content.html hth, Marin ...what you brought from your past, is of no use in your present. When you must choose a new path, do not bring old experiences with you. Those who strike out afresh, but who attempt to retain a little of the old life, end up torn apart by their own memories. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Marin Dimitrov 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: Sherman, Paul R. 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: Babich , Sergey 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).