Fw: Simple Query
santosh: Thanks for the help The following query also worked fine . Select count(tc_transcriptid) file_count , Sum(Tc_LineCount), trunc(tc_collectdatetime)From dc_transcript_collectwhere (Tc_TranscriptId,Tc_ActionId) in (Select Tc_TranscriptId,Max(TC_ActionId)From dc_transcript_collect Group By Tc_TranscriptId)group by trunc(tc_collectdatetime) regards, shibu - Original Message - From: Santosh Varma To: Multiple recipients of list ORACLE-L Sent: Friday, April 19, 2002 12:13 PM Subject: RE: Simple Query Hi shibu, Try the following query - I hope this helps. SELECT count(*),sum(TC_LINECOUNT) from tablename.a,tablename.b where TC_ACTIONID = (select MAX(ACTIONID) from tablename.b where b.TC_TRANSCRIPTIDin (select DISTINCT TC_TRANSCRIPTID from tablename.a)) santosh -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of ShibuSent: Tuesday, April 16, 2002 6:08 PMTo: Multiple recipients of list ORACLE-LSubject: Simple Query Hi All, I have a specific problem in retrieving rows from a table. I am listing down the some sample data in a table. TC_ID TC_TRANSCRIPTID TC_COLLECTDATETIME TC_ACTIONID TC_LINECOUNT ---1 10104/02/2002 12:30:00 1060 10 2 101 04/02/2002 01:00:00 1080 8 3 10204/02/2002 02:00:00 1060 25 410204/02/2002 03:00:00 1080 27- 5 103 04/02/2002 04:00:00 1060 40-- I need a query which will retrieve the COUNT(TC_ID) and SUM(TC_LINECOUNT) and the Conditions are 1) COUNT(TC_ID) should only be retrieved for the maximum of TC_ACTIONID. ( I mean for all those TC_TRANSCRIPTID which has got more than one entries in the table the maximum of TC_ACTIONID should be retrieved. 2) SUM(TC_LINECOUNT) should only be retrieved for the maximum of TC_ACTIONID I mean each and every TC_TRANSCRIPTID can have 'n' number of records in the table and when the query is executed it should retrieve the MAXIMUM of TC_ACTIONID that a TC_TRANSCRIPTID is having and the same goes with the File Count also. In the example sited above the query should retrieve COUNT(TC_ID) as 3 and the SUM(TC_LINECOUNT) as 75. COUNT(TC_ID) SUM(TC_LINECOUNT) 375 Thanks in advance. Regards, Shibu. Acusis - Bangalore
STANDBY DATABASE QUESTION?
Dear Gurus , I want to ask something .. I want to apply a standby server ,What I wonder is , if I set it up automatic , is the archive log files automatically copied to standby server , or do I move it manually . ??? And my second question is on my Win2000 Adv. Server C:\ drive , PAGEFILE.SYS file is nearly 2 GB , AND does not increase , Why is it so big ? I know that it is because of SWAP .But I am sure that there must not be swap since I have 8 GB ram and only 40 users use database for now. . . Bunyamin K. Karadeniz Oracle DBA / DeveloperCivilian IT DepartmentHavelsan A.S. Eskisehir yolu 7.km Ankara TurkeyPhone: +90 312 2873565 / 1217Mobile : +90 535 3357729 The degree of normality in a database is inversely proportional to that of its DBA.
Renaming files on Unix via PL/SQL
Hi all, Is it possible to rename files (e.g .txt files) on Unix by using PL/SQL? Is there a function to do that? Regards M.Emre HANCIOGLU Masterfoods Services GmbH ISI Application Support Tel : +49 2162 500-576 Fax: +49 2162 41497 E-Mail: [EMAIL PROTECTED]
Re: STANDBY DATABASE QUESTION?
yes , if you put in "maneged mode" , archived logs are copied and applýed to standby site from master site. - Original Message - From: Bunyamin K. Karadeniz To: Multiple recipients of list ORACLE-L Sent: Friday, April 19, 2002 12:03 PM Subject: STANDBY DATABASE QUESTION? Dear Gurus , I want to ask something .. I want to apply a standby server ,What I wonder is , if I set it up automatic , is the archive log files automatically copied to standby server , or do I move it manually . ??? And my second question is on my Win2000 Adv. Server C:\ drive , PAGEFILE.SYS file is nearly 2 GB , AND does not increase , Why is it so big ? I know that it is because of SWAP .But I am sure that there must not be swap since I have 8 GB ram and only 40 users use database for now. . . Bunyamin K. Karadeniz Oracle DBA / DeveloperCivilian IT DepartmentHavelsan A.S. Eskisehir yolu 7.km Ankara TurkeyPhone: +90 312 2873565 / 1217Mobile : +90 535 3357729 The degree of normality in a database is inversely proportional to that of its DBA.
RE: Compare (diff) Oracle DB and MS-SQLServer DB
Ray, Have you looked at Embarcardero's DBArtisan tool? I'm not sure if it will do an active compare of the schemas etc. but it certainly works on both Oracle and SQLServer concurrently, and is in the ballpark that you are looking for.. May be worth checking it out: www.embarcadero.com HTH Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -Original Message- Sent: 18 April 2002 21:24 To: Multiple recipients of list ORACLE-L Mostly schema (tables, views, indexes, ...) and if possible data (reference tables). Now, ERWin... I dont think so...not a good idea to use an ER tool. We would end up unnecessarily managing a model within ERWin, and we would have to retrofit the model (complete compare) each time before running the compare. Such a pain, and I would have to hire another person and keep paying another salary just to do this. I want to reduce my headcount not increase it. What we need is a very simple utility. Something like TOAD. But TOAD only works for ORACLE and does not let you set conditions, so it will be useless here. While I am dreaming... lets continue. We need something like an ADVANCED TOAD, i.e. which not only identifies the diffs but shows the deltas exactly, and which allows us to set conditions for the compare (eg: ignore tablespace, ignore INITIAL, ignore datatype, etc.). Ray From: Joe Raube [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Compare (diff) Oracle DB and MS-SQLServer DB Date: Thu, 18 Apr 2002 10:42:37 -0800 Diff of what? Data? Schema? Stored procs? Depends on what you need -- ERwin or another ER tool may be able to help find schema diffs... --- Ray Gordon [EMAIL PROTECTED] wrote: One of our teams started programming in SQLServer, but now we are live in a production ORACLE environment. Due to several issues, such as licensing,skills, etc., the development must stay on SQLServer. Is there a tool or whatever to find out the deltas between a SQLServerDB and an Oracle DB? Or any suggestions. Ray _ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Gordon 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!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube 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). _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Gordon 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: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego,
RE: STANDBY DATABASE QUESTION?
Original Message-From: Bunyamin K. Karadeniz [mailto:[EMAIL PROTECTED]]Sent: Friday, April 19, 2002 2:33 PMTo: Multiple recipients of list ORACLE-LSubject: STANDBY DATABASE QUESTION? Dear Gurus , I want to ask something .. I want to apply a standby server ,What I wonder is , if I set it up automatic , is the archive log files automatically copied to standby server , or do I move it manually . ???[Vikas Khanna]You have do transfer them manually to the standy by server. OR you can write automated scripts todo the job for you. And my second question is on my Win2000 Adv. Server C:\ drive , PAGEFILE.SYS file is nearly 2 GB , AND does not increase , Why is it so big ? I know that it is because of SWAP .But I am sure that there must not be swap since I have 8 GB ram and only 40 users use database for now. . [Vikas Khanna] Its the max limit for the size of the file which this OS support. Even if you might have 8 GB RAM what depends is your SGA Size. . Bunyamin K. Karadeniz Oracle DBA / DeveloperCivilian IT DepartmentHavelsan A.S. Eskisehir yolu 7.km Ankara TurkeyPhone: +90 312 2873565 / 1217Mobile : +90 535 3357729 The degree of normality in a database is inversely proportional to that of its DBA.
Re: RAC
There are about a dozen in North America and Europe that I know of, but can't name (NDA). There was one person I met at IOUG-A Live! 2002 that is actually live on it in production - and it isn't running anything truly critical, more of a pilot system. I have one client who wants to pounce on it immediately with a somewhat critical database and has just received all the hardware this week. I am likely going to try to defer a production date until after the June release comes out. Don Granaman [certifiable OraSaurus] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, April 17, 2002 9:18 PM I was talking w/someone today, and we realized that neither of us knows of anyone actually using RAC in production. So now I'm curious. Is anyone? Jonathan Gennick --- Brighten the corner where you are mailto:[EMAIL PROTECTED] http://Gennick.com * http://MichiganWaterfalls.com * http://ValleySpur.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Gennick 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: Don Granaman 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: Renaming files on Unix via PL/SQL
Hi, no, there's no way to do that through PL/SQL. If have the option of using java you can use the solution given by Tom Kyte at http://asktom.oracle.com/pls/ask/f?p=4950:8:F4950_P8_DISPLAYID:952229840241 Regards, Mike Hately -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: 19 April 2002 10:03To: Multiple recipients of list ORACLE-LSubject: Renaming files on Unix via PL/SQLHi all, Is it possible to rename files (e.g .txt files) on Unix by using PL/SQL? Is there a function to do that? Regards M.Emre HANCIOGLUMasterfoods Services GmbHISI Application SupportTel : +49 2162 500-576Fax: +49 2162 41497E-Mail: [EMAIL PROTECTED] This email and any attached to it are confidential and intended only for the individual or entity to which it is addressed. If you are not the intended recipient, please let us know by telephoning or emailing the sender. You should also delete the email and any attachment from your systems and should not copy the email or any attachment or disclose their content to any other person or entity. The views expressed here are not necessarily those of Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you. Churchill Insurance Group plc. Company Registration Number - 2280426. England. Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1 1DP.
Re: MySQL vs. Oracle database
- Original Message - There is a new alternative. SAPDB is open source but supported by SAP. Whan used outside of SAP applications it is free but charged when used inside of SAP. The support is from a major software company and the features are much closer to the Oracle feature set. I don't think SAP AG cares much about SAP DB, so don't rely too much on the support is from a major software company also closer to Oracle is not true at all 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).
Re: Cobol Zone Dec.
1) Zoned decimals is something like hex 'F1F2F3' for 123. 2) Those numbers are not zoned decimal. They look like packed decimal with the last byte reversed. 'A' is 'C1' in hex and that means 1 positive. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, April 15, 2002 8:33 PM Hello everyone, If anyone can help me interpret this junk that I am seeing (I have a feeling it's zone decimal, but I am having a hard time finding a simple definition of exactly what zone dec is) please email me directly. Thank you, here's some of my junk, er, an example of what I'm referring to. 1 select id, member_number, assessment_0_30_delinquent, total_past_due 2 from fpmast_raw 3 where rownum 15 4* and total_past_due not like '000%' (INV-ELVIS)/ ID MEMBER_NU ASSESSMEN TOTAL_PAS - - - - 193 001469663 001061I 001777C 215 001547860 00{ 001201B 250 001747190 000252G 002626H 272 002166726 00{ 007573A 284 002224443 000185D 002087A 308 002267067 000293G 019461B 309 002268727 00{ 001201B 390 002441850 000226F 001633C 443 002566750 00{ 001124H 468 002643641 000198B 003603D 565 003342161 000421C 003228B 569 003346365 000274A 006456{ 579 003368045 000366C 023057H 731 004286360 000259A 011834D Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 954-935-4117 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Koivu, Lisa 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: Yechiel Adar 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: Close instances while installing new versions or creating new databases
But you may have to close the listener and activate the listener of the new version and that means that you better close the instances also. The same for oracle agent and maybe other services. I think that you should check this on a test machine first. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, April 17, 2002 4:48 PM databases No to both. You do not have to close instances for these things. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, April 16, 2002 5:38 PM databases Hi The install guides that I have seen specify that you shut down all instances before any installations. Is it really necessary to close all instances and listeners on a server when you are: a)Installing a new version of Oracle in a new $ORACLE_HOME OR b)Creating a new database under the new $ORACLE_HOME What about when creating a new database under an existing $ORACLE_HOME which has open instances. Thanks. Ben -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ben Poels 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: 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: Yechiel Adar 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-00600 [12333], [0], [0]
Hello, I get often ORA-00600 [12333], [0], [0] in a database (8.1.7.0 AIX 4.3). I openned a TAR but they just said there were lost of connections. Does anyone have the same problem and how to get rid of it please ? Thank in advance. Thanh-truc Nguyen Below is the header of the trace file : (ibm_rtki1) oracle8:/home/oracle8 head - 100 /log/oracle/RTKPRD/udump/ora_46650_rtkprd.trc /log/oracle/RTKPRD/udump/ora_46650_rtkprd.trc Oracle8i Enterprise Edition Release 8.1.7.0.0 - 64bit Production With the Partitioning option JServer Release 8.1.7.0.0 - 64bit Production ORACLE_HOME = /apps/oracle/product/8.1.7 System name:AIX Node name: ibm_rtki1 Release:3 Version:4 Machine:0052BA7A4C00 Instance name: RTKPRD Redo thread mounted by this instance: 1 Oracle process number: 31 Unix process pid: 46650, image: oracle@ibm_rtki1 (TNS V1-V3) *** SESSION ID:(191.3404) 2002-04-19 08:06:57.972 *** 2002-04-19 08:06:57.963 ksedmp: internal or fatal error ORA-00600: internal error code, arguments: [12333], [0], [0], [0], [], [], [], [] Current SQL information unavailable - no session. - Call Stack Trace - calling call entryargument values in hex location type point(? means dubious value) ksedmp+00fc bl ksedst 0 ? ksfdmp+0018 bl ksedmp 30003 ? kgeriv+0118 bl _ptrgl kgesiv+0080 bl kgeriv FFFD400 ? 1101B8320 ? 1101B8308 ? 01000D280 ? FFFDA68 ? ksesic3+0060 bl kgesiv 302D302D ? 30003 ? FFFD4B8 ? FFFE268 ? 0 ? opitsk+0654 bl ksesic3 302D302D ? 0 ? 0 ? 0 ? 0 ? 0 ? 0 ? 064206F6E ? opiino+0670 bl opitsk 110013E68 ? opiodr+06b8 bl _ptrgl opidrv+056c bl opiodr 3C0002 ? 4200FE898 ? E00 ? 0 ? sou2o+0028 bl opidrv 3C003C ? 40004 ? E00 ? main+0128bl sou2o 92163DC ? 9FFF0009DF8 ? E10 ? 9001000A00843E8 ? __start+0090 bl main 0 ? 0 ? - Argument/Register Address Dump - Accédez au courrier électronique de La Poste : www.laposte.net ; 3615 LAPOSTENET (0,13 /mn) ; tél : 08 92 68 13 50 (0,34/mn) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?Q?Thanh-truc_Nguyen? 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: RAC
I agree with Scott's reply. Compaq may be able to claim the only Tru RAC, but not the only true RAC! I skipped the keynote/marketing stuff at IOUG-A Live! 2002, but I've seen the long version of Compaq 's demo/propaganda on RAC and, to put it mildly, they exaggerated - A LOT. I don't know what may have been said at any f their scheduled sessions at the conference, but... The business about (paraphrased) other vendors' RAC implementations being like an HA cluster is pure unadulterated rubbish. There is no constraint on any certified RAC configuration that would limit it to a single active node. (This applies also to at least one extremely non-certified configuration - my personal sandbox). There were four technical people from Compaq at the OPS/RAC roundtable (and one from HP). None made any such preposterous statements. In fact, one of the Compaq representatives said they are currently running RAC on Linux (not Tru64) on Compaq hardware. They did, of course, push Tru64 and its cluster file system. I can verify, from direct experience, that RAC on Linux CAN share a datafile on a raw device. I don't know what was actually said, but the statement attributed to Compaq about this is obviously nonsense. If RAC nodes can share a raw device, they can share a datafile on the raw device. (BTW: Didn't HP also do a Keynote session and demo on RAC?) Perhaps the Compaq representative was confused as to the distinction between an Oracle datafile and a filesystem file. I know that there are currently production RAC systems on NT, Sun, HP, and Compaq - at least. IBM may be on the list also. I know of one small site in the early stages of implementing RAC on a Dell RAC-certified configuration (Dell 6450 nodes running RedHat 7.1 SBE with an EMC FC4700 array). It will likely go into production within 2-3 months. Don Granaman [certifiable OraSaurus] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, April 18, 2002 7:38 AM Jonathan, At the seminars I have attended it was pointed out that the :true RAC is COMPAQ only. The seminar was hosted by Oracle/Compaq. Compaq RAC allows multiple CPU's to mount and use/share the same datafiles in a true RAC configuration. The drives including the os drive are on a SAN and shared by the CPU's so knowledge is shared. It was pointed out the new Linux RAC can only share a RAW device and not a datafile. I don't know if this is true as I have not tried it yet. The speaker at the seminar said that with other OS's a RAC is like a High Availability (HA) option, one CPU is doing nothing until the first one fails or you only run different applications and datafiles on one CPU and other applications and datafiles on the second CPU. if one fails you have to mount the datafiles and switch applications to the active CPU. To use a true RAC you have to use Compaq and I think the market share of the OS's are not True64, so there are probably not a lot of users of RAC. Ron ROR mª¿ªm [EMAIL PROTECTED] 04/17/02 10:18PM I was talking w/someone today, and we realized that neither of us knows of anyone actually using RAC in production. So now I'm curious. Is anyone? Jonathan Gennick --- Brighten the corner where you are mailto:[EMAIL PROTECTED] http://Gennick.com * http://MichiganWaterfalls.com * http://ValleySpur.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Gennick 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: Don Granaman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE
Send mail from PL/SQL
Hallo, anyone whom can help me. I would like this code to send email to two recipients, what is missing? Thanks for all help I can get. PROCEDURE sendmailtestny2( inRecipient1 IN VARCHAR2, inRecipient2 in VARCHAR2, inSubject IN VARCHAR2, inMessage IN VARCHAR2, inSender IN VARCHAR2 := '[EMAIL PROTECTED]' ) IS crlf VARCHAR2(2) := CHR(13)||CHR(10); mailhostVARCHAR2(30) := 'asolc78.ica.se'; mail_conn utl_smtp.connection; lMessage1 VARCHAR2(200); lmessage2 VARCHAR2(200); BEGIN lMessage1 := 'From:' || inSender || crlf || 'Subject:' || inSubject || crlf || 'To:' || inRecipient1 || crlf || '' || crlf || inrecipient2 || crlf || '' || crlf || inMessage || crlf || crlf || '/' || inSender; --lMessage2 := 'From:' || inSender || crlf || -- 'Subject:' || inSubject || crlf || -- 'To:' || inRecipient2 || crlf || '' || crlf || -- inMessage || crlf || crlf || '/' || inSender; mail_conn := utl_smtp.open_connection(mailhost, 25); utl_smtp.helo(mail_conn, mailhost); utl_smtp.mail(mail_conn, inSender); utl_smtp.rcpt(mail_conn, inRecipient1); utl_smtp.rcpt(mail_conn, inRecipient2); utl_smtp.data(mail_conn, lMessage1); utl_smtp.data(mail_conn, lMessage2); utl_smtp.quit(mail_conn); END; Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: STANDBY DATABASE QUESTION?
From 8.1, the primary node can automatically transfer the logs to the standby node. hth connor --- Vikas Khanna [EMAIL PROTECTED] wrote: Original Message- Sent: Friday, April 19, 2002 2:33 PM To: Multiple recipients of list ORACLE-L Dear Gurus , I want to ask something .. I want to apply a standby server ,What I wonder is , if I set it up automatic , is the archive log files automatically copied to standby server , or do I move it manually . ??? [Vikas Khanna] You have do transfer them manually to the standy by server. OR you can write automated scripts to do the job for you. And my second question is on my Win2000 Adv. Server C:\ drive , PAGEFILE.SYS file is nearly 2 GB , AND does not increase , Why is it so big ? I know that it is because of SWAP . But I am sure that there must not be swap since I have 8 GB ram and only 40 users use database for now. . [Vikas Khanna] Its the max limit for the size of the file which this OS support. Even if you might have 8 GB RAM what depends is your SGA Size. . Bunyamin K. Karadeniz Oracle DBA / Developer Civilian IT Department Havelsan A.S. Eskisehir yolu 7.km Ankara Turkey Phone: +90 312 2873565 / 1217 Mobile : +90 535 3357729 The degree of normality in a database is inversely proportional to that of its DBA. = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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: Send mail from PL/SQL
In Outlook, when I put two addresses in TO or CC or BCC fields, they are separated by a semi-colon(;). It appears that your code is placing carriage return. I do not know if the code will understand this semi-colon as command terminator. Otherwise you might want to use the CC or BCC fields for the second recipient. HTH! Aleem -Original Message- Sent: Friday, April 19, 2002 4:28 PM To: Multiple recipients of list ORACLE-L Subject:Send mail from PL/SQL Hallo, anyone whom can help me. I would like this code to send email to two recipients, what is missing? Thanks for all help I can get. PROCEDURE sendmailtestny2( inRecipient1 IN VARCHAR2, inRecipient2 in VARCHAR2, inSubject IN VARCHAR2, inMessage IN VARCHAR2, inSender IN VARCHAR2 := '[EMAIL PROTECTED]' ) IS crlf VARCHAR2(2) := CHR(13)||CHR(10); mailhostVARCHAR2(30) := 'asolc78.ica.se'; mail_conn utl_smtp.connection; lMessage1 VARCHAR2(200); lmessage2 VARCHAR2(200); BEGIN lMessage1 := 'From:' || inSender || crlf || 'Subject:' || inSubject || crlf || 'To:' || inRecipient1 || crlf || '' || crlf || inrecipient2 || crlf || '' || crlf || inMessage || crlf || crlf || '/' || inSender; --lMessage2 := 'From:' || inSender || crlf || -- 'Subject:' || inSubject || crlf || -- 'To:' || inRecipient2 || crlf || '' || crlf || -- inMessage || crlf || crlf || '/' || inSender; mail_conn := utl_smtp.open_connection(mailhost, 25); utl_smtp.helo(mail_conn, mailhost); utl_smtp.mail(mail_conn, inSender); utl_smtp.rcpt(mail_conn, inRecipient1); utl_smtp.rcpt(mail_conn, inRecipient2); utl_smtp.data(mail_conn, lMessage1); utl_smtp.data(mail_conn, lMessage2); utl_smtp.quit(mail_conn); END; Roland -- 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: Abdul Aleem INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RAC
Which reminds me of a joke I heard once. You know what the difference between a used car salesman and a computer salesman The used car salesman usually knows when he is lying! ba-dum-dum John [EMAIL PROTECTED] wrote: I agree with Scott's reply. Compaq may be able to claim the "only Tru RAC",but not the only true RAC"!I skipped the keynote/marketing stuff at IOUG-A Live! 2002, but I've seenthe "long version" of Compaq 's demo/propaganda on RAC and, to put itmildly, "they exaggerated - A LOT". I don't know what may have been said atany f their scheduled sessions at the conference, but...The business about (paraphrased) "other vendors' RAC implementations beinglike an HA cluster" is pure unadulterated rubbish. There is no constrainton any certified RAC configuration that would limit it to a single activenode. (This applies also to at least one extremely non-certifiedconfiguration - my personal sandbox). There were four technical people fromCompaq at the OPS/RAC roundtable (and one from HP). None made any suchpreposterous statements. In fact, one of the Compaq representatives saidthey are currently running RAC on Linux (not Tru64) on Compaq hardware.They did, of course, push Tru64 and its cluster file system.I can verify, from direct experience, that RAC on Linux CAN share a datafileon a raw device. I don't know what was actually said, but the statementattributed to Compaq about this is obviously nonsense. If RAC nodes canshare a raw device, they can share a datafile on the raw device. (BTW:Didn't HP also do a "Keynote session" and demo on RAC?) Perhaps the Compaqrepresentative was confused as to the distinction between an Oracle"datafile" and a filesystem "file".I know that there are currently production RAC systems on NT, Sun, HP, andCompaq - at least. IBM may be on the list also. I know of one small sitein the early stages of implementing RAC on a Dell RAC-certifiedconfiguration (Dell 6450 nodes running RedHat 7.1 SBE with an EMC FC4700array). It will likely go into production within 2-3 months.Don Grana man[certifiable OraSaurus]- Original Message -To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED]Sent: Thursday, April 18, 2002 7:38 AMJonathan, At the seminars I have attended it was pointed out that the :true RAC"is COMPAQ only. The seminar was hosted by Oracle/Compaq. Compaq RACallows multiple CPU's to mount and use/share the same datafiles in atrue RAC configuration. The drives including the os drive are on a SANand shared by the CPU's so knowledge is shared. It was pointed out thenew Linux RAC can only share a RAW device and not a datafile. I don'tknow if this is true as I have not tried it yet. The speaker at theseminar said that with other OS's a RAC is like a High Availability (HA)option, one CPU is doing nothing until the first one fails or you onlyrun different applications and datafiles on one CP U and otherapplications and datafiles on the second CPU. if one fails you have tomount the datafiles and switch applications to the active CPU. To use a true RAC you have to use Compaq and I think the market shareof the OS's are not True64, so there are probably not a lot of users ofRAC.RonROR mm [EMAIL PROTECTED] 04/17/02 10:18PM I was talking w/someone today, and we realized that neitherof us knows of anyone actually using RAC in production. Sonow I'm curious. Is anyone?Jonathan Gennick --- Brighten the corner where you aremailto:[EMAIL PROTECTED]http://Gennick.com * http://MichiganWaterfalls.com *http://ValleySpur.com--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Jonathan Gennick INET: [EMAIL PROTECTED]Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051San D iego, California-- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).--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-5051San Diego, California-- Public Internet access / Mailing Lists--- -To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: hi i'm back amongst the living
Come On Walt... I thought you installed Windozz first to allow the Oracle to install without a hitch and then upgraded your pc to Linux. Nt first, SP4,SP5,SP6 then Oracle 8.0, migrate to 8.1.6, upgrade to 8.1.7, patch up to 8.1.7.3, and if your lucky migrate to 9.0.1. When all is said and done and the database is working flawless you install the Linux release you desire. This way you eliminate the glibc and JDK patch for oracle's GUI installers. Is it correct that next year the IOUG conference will be in Orlando again??? I can afford it again.. Ron ROR mª¿ªm [EMAIL PROTECTED] 04/19/02 12:33AM Joe, Glad you had a good time. Sorry I didn't make it, my company pulled funding at the last minute. As far as Oracle and Linux is concerned, I have a lot of experience. You have to install Linux first. That makes everything else a lot easier. --Walt Weaver Bozeman, Montana -Original Message- To: Multiple recipients of list ORACLE-L Sent: 4/18/2002 6:38 PM Lots of good stuff at IOUG conference this year, the food sucked, blah. Technical sessions were good(the few i went to), met some people been talking to for years on this forum. Party was as sea world, it was ok. We thought maybe Shamu was going to eat Rich N, but that didnt happen. For those of you who didnt make it :(, maybe next year in Orlando, FL at the Swan/Dolphin hotel, april 27-may 1st. Lots of first time presenters and for those of you who know Marlene Theriault, she did her last IOUG presentation this time around, she's officially retiring from the Oracle world. She's doing the european one and then she's quitting, no more books either. We'll miss her dearly. So for those of you who've contemplated presenting before a conference, call for papers should be in jul/aug at latest for Orlando. I think i'm done with logminer, milked it for too many years, next year i'm toying around with a couple of ideas: 1. Recovery Concepts: Let's blow up a database and do live recovery during the presentation 2. Linux: Can I really do a no-brainer install of linux and oracle?, Here are the steps. Oh well, off to dinner and chillin for one more day. For those who didn't make it, we missed you. Joe -- Joseph S Testa Data Management Consulting http://www.dmc-it.com 614-791-9000 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S Testa 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: Weaver, Walt 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).
Re: Enqueue and DB File Sequential Read Waits Problem
Regarding the Enqueues: One follow-up is to connect as SYS and look at x$ksqst where ksqstwat != 0. This tells you two things (after the event). First, which type of enqueue has suffered waits, and secondly whether the waits in v$session_wait are represent a few very long waits or lots of shorter waits. (v$session_wait increments every 3 seconds, x$ksqst just once at the end) However, since your wait time is a large fraction of your elapsed time, you will probably be able to get some extra information simply by running a query against v$session_wait where name = 'enqueue' a couple of dozen times in quick succession. For the same reason, if you look at v$lock where request != 0 at regular intervals, you will be able to see the type and id of the wait. If you can identify the enqueue type, request mode, and id values, then you can track down causes more easily. Regarding the db file sequential read: Can I confirm that your report is describing a job where your session runs for six hours, and reports 1 hour of enqueues, and 4 hours of db file sequential reads, in that six hours ? If that is the case, then even though the reads are very fast reads (presumably helped by a large file-system buffer) then I suspect your SQL (or the strategy surrounding your use of SQL) needs to be examined. You MAY be doing an extreme amount of logical I/O to require 7M single block reads for one (effective) hour of CPU usage. For example, it is possible that the code has been 'tuned' to eliminate tablescans and increase hit ratios, with the detrimental side-effect that the logical I/O has gone up dramatically, and increased the actual cost of physical I/O. It is possible that the code has been written to loop through cursors and 'emulate' joining by executing several simple statements per row of the main cursor. In the short term, you may get an improvement in performance by shifting memory away from the file system buffer and into the Oracle buffer. The logical I/O won't drop, but the number of waits for filesystem interaction may. Anjo, the 307 is interesting. I have seen 307 and 107 (depending on wait event) appear as the max time with remarkable frequency on Windows systems, even when the machines were idle. I wonder if this may be due to some tick-granularity on Windows/DOS-based machines, rather than stress. (In fact, the first time I saw this was on a Sun that was under extreme pressure, and I made the same assumption that you did - now I'm beginning to wonder if there is more to it than that). Jonathan Lewis http://www.jlcomp.demon.co.uk Author of: Practical Oracle 8i: Building Efficient Databases Next Seminar - Australia - July/August http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html -Original Message- |The enqueue problem looks like an TX enqueue problem. Given the fact that the |average wait is 307 and max wait is 308, |I can see that you are also running out of CPU on your box. The normal max_wait |should be 300 and the average wait should be less than 300. | |Sam Bootsma wrote: | | We have a batch job taking a long time to process. Querying the | v$session_wait view, I discovered there have been over 1200 enqueue waits, | with an average wait of just over 307 and a max wait of 308. The total time | waited is 370081 (just over one hour if these figures are in centiseconds). | The batch job has been running about 6 hours. | | I also see that db file sequential read has waited almost 4 hours. This | sounds like 4 hours waiting on index access requests. What could cause | these long waits? | | I am not sure how to troubleshoot this problem further (Reading the | Performance 101 Book is on My To Do List). This is Oracle 81630 on Windows | NT server. | | Any suggestions or advice on how to troubleshoot this further is much | appreciated. Here is my query and the output: | | SQL l | 1 select substr(event, 1,30), total_waits, time_waited, average_wait, | max_wait | 2 from v$session_event | 3* where sid=18 | SQL / | | SUBSTR(EVENT,1,30) TOTAL_WAITS TIME_WAITED AVERAGE_WAIT | MAX_WAIT | -- -- | --- | - | latch free 5 0 | 0 0 | enqueue 1204370081 | 307.376246 308 | buffer busy waits 45 0 | 0 0 | log file switch completion2 27 13.5 | 17 | log file sync 4 0 | 0 0 | db file sequential read 7269278 1375000 | .18915221 29 | direct path read4 10 | 2.5
security announcements
ALERT NUMBER 1: UNAUTHORIZED ACCESS VULNERABILITY IN THE ORACLE E-BUSINESS SUITE. Document Identification Number 185073.1 ALERT NUMBER 2: USER PRIVILEGES VULNERABILITY IN ORACLE9i DATABASE SERVER Document Identification Number 185074.1 === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell 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: Renaming files on Unix via PL/SQL
What about issueing a HOST command through dbms_sql? Not saying it will work (I haven't tried it) but it seems like it should. -Original Message-From: Hately Mike [mailto:[EMAIL PROTECTED]]Sent: Friday, April 19, 2002 5:53 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Renaming files on Unix via PL/SQL Hi, no, there's no way to do that through PL/SQL. If have the option of using java you can use the solution given by Tom Kyte at http://asktom.oracle.com/pls/ask/f?p=4950:8:F4950_P8_DISPLAYID:952229840241 Regards, Mike Hately -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: 19 April 2002 10:03To: Multiple recipients of list ORACLE-LSubject: Renaming files on Unix via PL/SQLHi all, Is it possible to rename files (e.g .txt files) on Unix by using PL/SQL? Is there a function to do that? Regards M.Emre HANCIOGLUMasterfoods Services GmbHISI Application SupportTel : +49 2162 500-576Fax: +49 2162 41497E-Mail: [EMAIL PROTECTED] This email and any attached to it are confidential and intended only for the individual or entity to which it is addressed. If you are not the intended recipient, please let us know by telephoning or emailing the sender. You should also delete the email and any attachment from your systems and should not copy the email or any attachment or disclose their content to any other person or entity. The views expressed here are not necessarily those of Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you. Churchill Insurance Group plc. Company Registration Number - 2280426. England. Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1 1DP.
Ang: RE: Send mail from PL/SQL
it helped with CC: Thanks /Roland Abdul Aleem [EMAIL PROTECTED]@fatcity.com den 2002-04-19 03:48 PST Sänd svar till [EMAIL PROTECTED] Sänt av: [EMAIL PROTECTED] Till: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Kopia: In Outlook, when I put two addresses in TO or CC or BCC fields, they are separated by a semi-colon(;). It appears that your code is placing carriage return. I do not know if the code will understand this semi-colon as command terminator. Otherwise you might want to use the CC or BCC fields for the second recipient. HTH! Aleem -Original Message- Sent: Friday, April 19, 2002 4:28 PM To:Multiple recipients of list ORACLE-L Hallo, anyone whom can help me. I would like this code to send email to two recipients, what is missing? Thanks for all help I can get. PROCEDURE sendmailtestny2( inRecipient1 IN VARCHAR2, inRecipient2 in VARCHAR2, inSubject IN VARCHAR2, inMessage IN VARCHAR2, inSender IN VARCHAR2 := '[EMAIL PROTECTED]' ) IS crlf VARCHAR2(2) := CHR(13)||CHR(10); mailhostVARCHAR2(30) := 'asolc78.ica.se'; mail_conn utl_smtp.connection; lMessage1 VARCHAR2(200); lmessage2 VARCHAR2(200); BEGIN lMessage1 := 'From:' || inSender || crlf || 'Subject:' || inSubject || crlf || 'To:' || inRecipient1 || crlf || '' || crlf || inrecipient2 || crlf || '' || crlf || inMessage || crlf || crlf || '/' || inSender; --lMessage2 := 'From:' || inSender || crlf || -- 'Subject:' || inSubject || crlf || -- 'To:' || inRecipient2 || crlf || '' || crlf || -- inMessage || crlf || crlf || '/' || inSender; mail_conn := utl_smtp.open_connection(mailhost, 25); utl_smtp.helo(mail_conn, mailhost); utl_smtp.mail(mail_conn, inSender); utl_smtp.rcpt(mail_conn, inRecipient1); utl_smtp.rcpt(mail_conn, inRecipient2); utl_smtp.data(mail_conn, lMessage1); utl_smtp.data(mail_conn, lMessage2); utl_smtp.quit(mail_conn); END; Roland -- 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: Abdul Aleem INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Help with Locking Issue
This is hugely irritating, and I guess it may be a version-dependent thing, but I can't get the exact match for the quoted locks by setting up three tables in the manner described. The locking information varies between 8.1.7.3 and 9.0.1.3, but I can't get a PK/FK issue to behave (mis-behave ?) properly. Various failures include: a)Seeing a lock on the parent table b)Not seeing the TX mode 4 (share) lock at all c)See a TM mode 5 (share row exclusive) request on the child. (combined with a held mode 3 (row exclusive). Which version of (exact) Oracle is this, and have you figured out the exact pattern of actions that make the problem appear. My tables are: P1 (id_p1 number primary key ...) P2 (id_p2 number primary key ...) C(id_p1 references P1, id_p2 references P2, primary key (id_p1,id_p2) ...) This seems to describe your scenario - two foreign keys, but only one of them index by virtue of the composite primary key. Jonathan Lewis http://www.jlcomp.demon.co.uk Author of: Practical Oracle 8i: Building Efficient Databases Next Seminar - Australia - July/August http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 18 April 2002 19:45 I had already checked that, but since you asked, I double checked. The primary key on the FIXED_ASSET_ACTIV table has two columns - both are foreign keys from other tables. I created a separate index for the 2nd column in the PK. This fixed my problem! So, the foreign key was indexed, it just wasn't indexed correctly. Thanks, Jay [EMAIL PROTECTED] 04/18/02 01:17PM Jay, do you have any unindexed foreign keys on those tables? If so, Oracle Sess Op Sys OBJ NAME or ID USERNAME User IDTERMINAL TRANS_ID TY Lock Mode Req Mode -- - -- --- --- 12 KEN468 ken468 KEN468-1 FIXED_ASSET_ACTIV TM Row Excl 12 KEN468 ken468 KEN468-1 Trans-196694 TX Exclusive 14 KEN468 Batch BATCHFIXED_ASSET_ACTIV TM Row Excl 14 KEN468 Batch BATCHTrans-196694 TX --Waiting-- Share 14 KEN468 Batch BATCHTrans-65597 TX Exclusive So session 14 is waiting for a share lock. Session 12 has an exclusive lock that is blocking session 14. How do I find out what session 12 has locked that is needed by session 14? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Lewis 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: Renaming files on Unix via PL/SQL
HOST is a SQL*Plus command only. --- John Weatherman [EMAIL PROTECTED] wrote: What about issueing a HOST command through dbms_sql? Not saying it will work (I haven't tried it) but it seems like it should. -Original Message- Sent: Friday, April 19, 2002 5:53 AM To: Multiple recipients of list ORACLE-L Hi, no, there's no way to do that through PL/SQL. If have the option of using java you can use the solution given by Tom Kyte at http://asktom.oracle.com/pls/ask/f?p=4950:8:F4950_P8_DISPLAYID:952229840 241 http://asktom.oracle.com/pls/ask/f?p=4950:8:F4950_P8_DISPLAYID:95222984 0241 Regards, Mike Hately -Original Message- Sent: 19 April 2002 10:03 To: Multiple recipients of list ORACLE-L Hi all, Is it possible to rename files (e.g .txt files) on Unix by using PL/SQL? Is there a function to do that? Regards M.Emre HANCIOGLU Masterfoods Services GmbH ISI Application Support Tel : +49 2162 500-576 Fax: +49 2162 41497 E-Mail: [EMAIL PROTECTED] This email and any attached to it are confidential and intended only for the individual or entity to which it is addressed. If you are not the intended recipient, please let us know by telephoning or emailing the sender. You should also delete the email and any attachment from your systems and should not copy the email or any attachment or disclose their content to any other person or entity. The views expressed here are not necessarily those of Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you. Churchill Insurance Group plc. Company Registration Number - 2280426. England. Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1 1DP. __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube 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: Number of CPUs vs. Speed of CPUs
Bruce: You got the point. We have discussed that some time back (Steve, Jonathan, and Adrian Cockcroft) and the result was: Few Faster CPUs are better for Performance, More slower CPUs are better for Manageability and fault tolerance. Steve Adams and Adrian are with few faster CPUS and Jonathan supports more slower CPUs. Best Regards, K Gopalakrishnan Bangalore, INDIA -Original Message- Bruce (CALBBAY) Sent: Thursday, April 18, 2002 4:33 PM To: Multiple recipients of list ORACLE-L Lisa, These aren't my points or ideas but below are some emails from Steve Adams that I have kept that may be of use. Also, I don't know for sure, but the 2 books (and or their authors:-) Practical Oracle8i by Jonathan Lewis and Scaling Oracle8i by James Morle may well have some very useful information on this topic. HTH, Bruce Reardon -Original Message- Sent: Thursday, 1 March 2001 17:46 To: Ixora Answers Hi All, Here is another follow-up to the February Ixora News item Buying Time at http://www.ixora.com.au/newsletter/2001_02.htm#memory_access. One of our subscribers asked Adrian Cockcroft, the author of Sun Performance and Tuning at http://www.amazon.com/exec/obidos/ASIN/0130952494/ixora for a second opinion. Here is Adrian's response ... Few faster CPUs is a little more efficient and has lower response time. More slow CPUs gives a flatter more predictable response time curve as the load increases so you can run nearer 100% busy. Read any book on queuing theory, especially Neil Gunther's Practical Performance Analyst at http://www.amazon.com/exec/obidos/ASIN/059512674X/ixora. See Performance Dynamics at http://www.perfdynamics.com/ for more on Neil Gunther's work, and Performance School at http://www.perfskool.com/ for related downloads. @ Regards, @ Steve Adams -Original Message- Sent: Wednesday, 28 February 2001 15:23 To: Ixora Answers Hi All, The recent Ixora News item Buying Time at http://www.ixora.com.au/newsletter/2001_02.htm#memory_access has provoked some discussion on the question of whether to buy fewer faster CPUs or more slower ones. It has been pointed out that there is one case in which it might be better to buy more slower CPUs. If an application has a number of highly CPU intensive processes (or threads) greater than or equal to the number of CPUs available, then the CPU usage will be unacceptably high. High CPU usage increases context switching overheads and introduces a risk of latch contention. If for some reason the CPU intensive processes cannot be tamed, then buying a greater number of slower CPUs may give better overall performance, despite the reduced CPU capacity and scalability. @ Regards, @ Steve Adams -Original Message- Sent: Friday, 19 April 2002 1:58 We are in the process of sizing a new server for multiple Oracle instances. What factors are useful as input in determining how many CPUs and the relative speed of them? For example, do we want fewer, faster CPUs or do we want more, slower CPUs? Are there any good guidelines to determine what the number of CPUs should be? Thanks in advance - Lisa -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) 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: 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).
Re: Enqueue and DB File Sequential Read Waits Problem
Oracle waits normally 3 seconds on a TX enqueue, checks for interrupts and goes again to sleep for 3 seconds. So if we see 307 on average, we waited longer. Now there may be tons of reasons of why that is: scheduling, granularity, etc. The thing to know/remember is that an enqueue wait is counted differently in different parts of the Oracle kernel. You can check for the session in v$sesstat (where name or stat# = 'enqueue waits') that will tell you how often the session waited for an enqueue. So take the wait time from v$session_event for enqueue and divide that by enqueue waits (v$sesstat) and you have the average enqueue wait time. If we can't trust the timing on NT we probably need a tool that samples more precisely ;-) Anjo. Jonathan Lewis wrote: Regarding the Enqueues: One follow-up is to connect as SYS and look at x$ksqst where ksqstwat != 0. This tells you two things (after the event). First, which type of enqueue has suffered waits, and secondly whether the waits in v$session_wait are represent a few very long waits or lots of shorter waits. (v$session_wait increments every 3 seconds, x$ksqst just once at the end) However, since your wait time is a large fraction of your elapsed time, you will probably be able to get some extra information simply by running a query against v$session_wait where name = 'enqueue' a couple of dozen times in quick succession. For the same reason, if you look at v$lock where request != 0 at regular intervals, you will be able to see the type and id of the wait. If you can identify the enqueue type, request mode, and id values, then you can track down causes more easily. Regarding the db file sequential read: Can I confirm that your report is describing a job where your session runs for six hours, and reports 1 hour of enqueues, and 4 hours of db file sequential reads, in that six hours ? If that is the case, then even though the reads are very fast reads (presumably helped by a large file-system buffer) then I suspect your SQL (or the strategy surrounding your use of SQL) needs to be examined. You MAY be doing an extreme amount of logical I/O to require 7M single block reads for one (effective) hour of CPU usage. For example, it is possible that the code has been 'tuned' to eliminate tablescans and increase hit ratios, with the detrimental side-effect that the logical I/O has gone up dramatically, and increased the actual cost of physical I/O. It is possible that the code has been written to loop through cursors and 'emulate' joining by executing several simple statements per row of the main cursor. In the short term, you may get an improvement in performance by shifting memory away from the file system buffer and into the Oracle buffer. The logical I/O won't drop, but the number of waits for filesystem interaction may. Anjo, the 307 is interesting. I have seen 307 and 107 (depending on wait event) appear as the max time with remarkable frequency on Windows systems, even when the machines were idle. I wonder if this may be due to some tick-granularity on Windows/DOS-based machines, rather than stress. (In fact, the first time I saw this was on a Sun that was under extreme pressure, and I made the same assumption that you did - now I'm beginning to wonder if there is more to it than that). Jonathan Lewis http://www.jlcomp.demon.co.uk Author of: Practical Oracle 8i: Building Efficient Databases Next Seminar - Australia - July/August http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html -Original Message- |The enqueue problem looks like an TX enqueue problem. Given the fact that the |average wait is 307 and max wait is 308, |I can see that you are also running out of CPU on your box. The normal max_wait |should be 300 and the average wait should be less than 300. | |Sam Bootsma wrote: | | We have a batch job taking a long time to process. Querying the | v$session_wait view, I discovered there have been over 1200 enqueue waits, | with an average wait of just over 307 and a max wait of 308. The total time | waited is 370081 (just over one hour if these figures are in centiseconds). | The batch job has been running about 6 hours. | | I also see that db file sequential read has waited almost 4 hours. This | sounds like 4 hours waiting on index access requests. What could cause | these long waits? | | I am not sure how to troubleshoot this problem further (Reading the | Performance 101 Book is on My To Do List). This is Oracle 81630 on Windows | NT server. | | Any suggestions or advice on how to troubleshoot this further is much | appreciated. Here is my query and the output: | | SQL l | 1 select substr(event, 1,30), total_waits, time_waited, average_wait, | max_wait | 2 from v$session_event | 3* where sid=18 | SQL / | | SUBSTR(EVENT,1,30)
Re: HIGH CPU WITH MULTIPLE CONCURRENT USERS (long)
I've got a little lost about who has said what in answer to whom about what - so apologies if I'm repeating comments, answering non-questions and giving incorrect attributions. The primary problem appears to be that performance plunges dramatically when concurrent increases. Three tkprof outputs for single use and multiple use are quoted below. The examples taken from 20 concurrent users are the best case and worst case of several reported. The first point is one that someone has already made, you have a hard limit on the number of CPU seconds available per second. NOTE - there are 4 CPUs on the system. Single user - takes 1.75 CPU seconds to run the query. Therefore 20 users should take about 35 CPU seconds to run all 20 copies of the query. Sharing this time across 4 CPUs you get an elapsed time of 8.75 seconds per user to complete. The worst case takes 9.81 seconds elapsed, the best takes 6.48. The range is a little surprising, but not totally insane. The fact that CPU usage (which is only accurate to the 1/100 sec per call) goes up from 1.76 to about 1.90 seconds is also not entirely ridiculous, especially when the CPUs are all operating under a run-queue of 5 tasks. The second point is the one I made earlier - I think your problem is excessive CPU in the optimisation phase, and I think this is related to the 50 values in your IN-list. Is your execution path an in-list iterator or a concatenation. Can you try running the query with the no_expand hint and seeing what the difference in CPU is ? Until you can reduce the CPU time to something like 0.01 seconds, your application will not scale. (Your simple table isn't partitioned is it ?) Jonathan Lewis http://www.jlcomp.demon.co.uk Author of: Practical Oracle 8i: Building Efficient Databases Next Seminar - Australia - July/August http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html 1 USER: call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse1 0.03 0.02 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch4 1.73 1.74 0334 0 31 --- -- -- -- -- -- -- total6 1.76 1.76 0334 0 31 20 Simultaneous Users: -- USER #1: --- call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch4 1.91 6.48 0334 0 31 --- -- -- -- -- -- -- total6 1.91 6.48 0334 0 31 USER #3: call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse1 0.01 0.01 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch4 1.86 9.81 0334 0 31 --- -- -- -- -- -- -- total6 1.87 9.82 0334 0 31 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Lewis 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: STANDBY DATABASE QUESTION?
1. Read the oracle docs on either 8i standby database, 9i data guard, log transport services and log apply services. joe Bunyamin K. Karadeniz wrote: Dear Gurus , I want to ask something .. I want to apply a standby server ,What I wonder is , if I set it up automatic , is the archive log files automatically copied to standby server , or do I move it manually . ??? And my second question is on my Win2000 Adv. Server C:\ drive , PAGEFILE.SYS file is nearly 2 GB , AND does not increase , Why is it so big ? I know that it is because of SWAP . But I am sure that there must not be swap since I have 8 GB ram and only 40 users use database for now. . . Bunyamin K. Karadeniz Oracle DBA / Developer Civilian IT Department Havelsan A.S. Eskisehir yolu 7.km Ankara Turkey Phone: +90 312 2873565 / 1217 Mobile : +90 535 3357729 The degree of normality in a database is inversely proportional to that of its DBA. -- Joseph S Testa Data Management Consulting http://www.dmc-it.com 614-791-9000 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S Testa 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: STANDBY DATABASE QUESTION?
Vikas, you need to read the docs also, you can have the logs automatically shipped and applied to the standby database, it all depends on how you set it up. the docs are a wonderful thing. joe Vikas Khanna wrote: Original Message- *From:* Bunyamin K. Karadeniz [mailto:[EMAIL PROTECTED]] *Sent:* Friday, April 19, 2002 2:33 PM *To:* Multiple recipients of list ORACLE-L *Subject:* STANDBY DATABASE QUESTION? Dear Gurus , I want to ask something .. I want to apply a standby server ,What I wonder is , if I set it up automatic , is the archive log files automatically copied to standby server , or do I move it manually . ??? [Vikas Khanna] You have do transfer them manually to the standy by server. OR you can write automated scripts to do the job for you. And my second question is on my Win2000 Adv. Server C:\ drive , PAGEFILE.SYS file is nearly 2 GB , AND does not increase , Why is it so big ? I know that it is because of SWAP . But I am sure that there must not be swap since I have 8 GB ram and only 40 users use database for now. . [Vikas Khanna] Its the max limit for the size of the file which this OS support. Even if you might have 8 GB RAM what depends is your SGA Size. . Bunyamin K. Karadeniz Oracle DBA / Developer Civilian IT Department Havelsan A.S. Eskisehir yolu 7.km Ankara Turkey Phone: +90 312 2873565 / 1217 Mobile : +90 535 3357729 The degree of normality in a database is inversely proportional to that of its DBA. -- Joseph S Testa Data Management Consulting http://www.dmc-it.com 614-791-9000 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S Testa 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: hi i'm back amongst the living
Yes next year back to orlando. joe Ron Rogers wrote: Come On Walt... I thought you installed Windozz first to allow the Oracle to install without a hitch and then upgraded your pc to Linux. Nt first, SP4,SP5,SP6 then Oracle 8.0, migrate to 8.1.6, upgrade to 8.1.7, patch up to 8.1.7.3, and if your lucky migrate to 9.0.1. When all is said and done and the database is working flawless you install the Linux release you desire. This way you eliminate the glibc and JDK patch for oracle's GUI installers. Is it correct that next year the IOUG conference will be in Orlando again??? I can afford it again.. Ron ROR mª¿ªm [EMAIL PROTECTED] 04/19/02 12:33AM Joe, Glad you had a good time. Sorry I didn't make it, my company pulled funding at the last minute. As far as Oracle and Linux is concerned, I have a lot of experience. You have to install Linux first. That makes everything else a lot easier. --Walt Weaver Bozeman, Montana -Original Message- To: Multiple recipients of list ORACLE-L Sent: 4/18/2002 6:38 PM Lots of good stuff at IOUG conference this year, the food sucked, blah. Technical sessions were good(the few i went to), met some people been talking to for years on this forum. Party was as sea world, it was ok. We thought maybe Shamu was going to eat Rich N, but that didnt happen. For those of you who didnt make it :(, maybe next year in Orlando, FL at the Swan/Dolphin hotel, april 27-may 1st. Lots of first time presenters and for those of you who know Marlene Theriault, she did her last IOUG presentation this time around, she's officially retiring from the Oracle world. She's doing the european one and then she's quitting, no more books either. We'll miss her dearly. So for those of you who've contemplated presenting before a conference, call for papers should be in jul/aug at latest for Orlando. I think i'm done with logminer, milked it for too many years, next year i'm toying around with a couple of ideas: 1. Recovery Concepts: Let's blow up a database and do live recovery during the presentation 2. Linux: Can I really do a no-brainer install of linux and oracle?, Here are the steps. Oh well, off to dinner and chillin for one more day. For those who didn't make it, we missed you. Joe -- Joseph S Testa Data Management Consulting http://www.dmc-it.com 614-791-9000 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S Testa 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: STANDBY DATABASE QUESTION?
Arslan, not exactly managed mode applies the logs, you need to setup the primary init.ora to have the shipped from primary site to standby site. joe Arslan Bahar wrote: yes , if you put in maneged mode , archived logs are copied and appled to standby site from master site. - Original Message - *From:* Bunyamin K. Karadeniz mailto:[EMAIL PROTECTED] *To:* Multiple recipients of list ORACLE-L mailto:[EMAIL PROTECTED] *Sent:* Friday, April 19, 2002 12:03 PM *Subject:* STANDBY DATABASE QUESTION? Dear Gurus , I want to ask something .. I want to apply a standby server ,What I wonder is , if I set it up automatic , is the archive log files automatically copied to standby server , or do I move it manually . ??? And my second question is on my Win2000 Adv. Server C:\ drive , PAGEFILE.SYS file is nearly 2 GB , AND does not increase , Why is it so big ? I know that it is because of SWAP . But I am sure that there must not be swap since I have 8 GB ram and only 40 users use database for now. . . Bunyamin K. Karadeniz Oracle DBA / Developer Civilian IT Department Havelsan A.S. Eskisehir yolu 7.km Ankara Turkey Phone: +90 312 2873565 / 1217 Mobile : +90 535 3357729 The degree of normality in a database is inversely proportional to that of its DBA. -- Joseph S Testa Data Management Consulting http://www.dmc-it.com 614-791-9000 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S Testa 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: STANDBY DATABASE QUESTION?
I will be in training the week of April 22nd to April 25th. I will respond to your e-mail when I return on April 26th. Don ORACLE-L 04/19/02 09:48 1. Read the oracle docs on either 8i standby database, 9i data guard, log transport services and log apply services. joe Bunyamin K. Karadeniz wrote: Dear Gurus , I want to ask something .. I want to apply a standby server ,What I wonder is , if I set it up automatic , is the archive log files automatically copied to standby server , or do I move it manually . ??? And my second question is on my Win2000 Adv. Server C:\ drive , PAGEFILE.SYS file is nearly 2 GB , AND does not increase , Why is it so big ? I know that it is because of SWAP . But I am sure that there must not be swap since I have 8 GB ram and only 40 users use database for now. . . Bunyamin K. Karadeniz Oracle DBA / Developer Civilian IT Department Havelsan A.S. Eskisehir yolu 7.km Ankara Turkey Phone: +90 312 2873565 / 1217 Mobile : +90 535 3357729 The degree of normality in a database is inversely proportional to that of its DBA. -- Joseph S Testa Data Management Consulting http://www.dmc-it.com 614-791-9000 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S Testa 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: Donald Bricker 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: STANDBY DATABASE QUESTION?
thank you all... Bunyamin K. Karadeniz Oracle DBA / Developer Civilian IT Department Havelsan A.S. Eskisehir yolu 7.km Ankara Turkey Phone: +90 312 2873565 / 1217 Mobile : +90 535 3357729 The degree of normality in a database is inversely proportional to that of its DBA. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, April 19, 2002 6:18 PM I will be in training the week of April 22nd to April 25th. I will respond to your e-mail when I return on April 26th. Don ORACLE-L 04/19/02 09:48 1. Read the oracle docs on either 8i standby database, 9i data guard, log transport services and log apply services. joe Bunyamin K. Karadeniz wrote: Dear Gurus , I want to ask something .. I want to apply a standby server ,What I wonder is , if I set it up automatic , is the archive log files automatically copied to standby server , or do I move it manually . ??? And my second question is on my Win2000 Adv. Server C:\ drive , PAGEFILE.SYS file is nearly 2 GB , AND does not increase , Why is it so big ? I know that it is because of SWAP . But I am sure that there must not be swap since I have 8 GB ram and only 40 users use database for now. . . Bunyamin K. Karadeniz Oracle DBA / Developer Civilian IT Department Havelsan A.S. Eskisehir yolu 7.km Ankara Turkey Phone: +90 312 2873565 / 1217 Mobile : +90 535 3357729 The degree of normality in a database is inversely proportional to that of its DBA. -- Joseph S Testa Data Management Consulting http://www.dmc-it.com 614-791-9000 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S Testa 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: Donald Bricker 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: Bunyamin K. Karadeniz 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: Donald Burleson
Hi You can read the articles ( + other articles ) of Donald Burleson at www.DBResources.com Thanks Jason --- YTTRI Lisa [EMAIL PROTECTED] wrote: Hi - Does anyone know if Donald Burleson has a website? If so, do you have the url? Has anyone read his book 9i Unix Administration Handbook? comments please... Lisa -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: YTTRI Lisa INET: [EMAIL PROTECTED] __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jason Rowski 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).
Good Article on differences between ORACLE and SQLServer
Hi Check the document below which discusses the differences in Oracle and SQL Server databases. http://www.dbresources.com/modules.php?name=Newsfile=articlesid=86 Thanks Jason --- Tim Gorman [EMAIL PROTECTED] wrote: ...this is even worse than the myth that programming to the ANSI SQL standard will allow you to port an application between RDBMS products, such as Oracle and SQL Server... :-) Oracle does not charge for development usage of it's products. That's why all software is downloadable for free from OTN. It is when you try to seek support that you should be properly licensed. That takes care of the cost issue... As far as the skills issue, the investment in learning how to install an Oracle development environment for an Oracle-based production system would be more than justified by the cost you are going to incur trying to put an application developed under SQL Server into an Oracle production system. Pay up now, or pay up later... This question of a script or tool to determine deltas is only the first of many installments of the pay up later choice... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, April 18, 2002 11:28 AM One of our teams started programming in SQLServer, but now we are live in a production ORACLE environment. Due to several issues, such as licensing,skills, etc., the development must stay on SQLServer. Is there a tool or whatever to find out the deltas between a SQLServerDB and an Oracle DB? Or any suggestions. Ray _ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Gordon 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: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jason Rowski 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: HIGH CPU WITH MULTIPLE CONCURRENT USERS (long)
Again: needed time is 1.76 20 jobs require 1.76 * 20 Divided on 4 cpu each cpu will take 1.76 * 20 /4 = 8.8 sec This is the average elapsed time for any job (20 concurrent) on your system. regards, Waleed -Original Message- To: Multiple recipients of list ORACLE-L Sent: 4/19/02 12:23 AM Vivek's feedback: (on your questions) Richard, I agree that over time this incident has been tested with various scenarios that it is getting confusing. However, the objective that we started with is still the same. Query: I have a query that does a select from 1 table (uses first_rows and index hint). This index is the one that gives us the best possible time with least possible consistent gets. The IN clause contain 50 individual literals. The query for 1 user to execute takes 1.67 seconds. This includes the time it also takes to display the results on the client. In our case the sql plus window on the database server. I had generated the trace file and did a TKPROF on the trace file. I am attaching the results of the trace file for your perusal. I had tried to _spin_count as default and various values from 4 to 4. The most optimal response time was obtained at _spin_count of 1. This is the value currently set. This was also recommended by Oracle as the CPU seems to be doing something (I believe due to Oracle) and is clearly visible as the user load is increased. To provide more clarity, I am attaching a word document that lists the trace status of parse, execute and fetch for 1 and 20 simultaneous users. Please note that while for 1 user the total elapsed time is very close the fetch time, for 20 concurrent users, the disparity is high. This disparity increases more than linearly as the stress is increased. I hope this helps. You are correct in your observation that Oracle does not show a wait in the v$session_wait and the CPU idle time is 0%, usage 98% user, 2% kernel. This can be observed clearly for as small as 100 concurrent users. There is no data functions or conversion on any of the columns both in the select and in the where clause. I want to be careful here. As I keep reducing the number of literals in the IN clause, the query works faster. However, the degradation factor (response time for 20 simultaneous queries to response time of 1 query) is the same hovering around 1 to 3.6. This degradation factor becomes very large as the stress in increased. Our first scenario was an IN clause with 800 literals. Then we had reduced it to 200. Then to 100. Now we are at 50. However, since our application response is for 800, now we have that many simultaneous queries accessing the database. This contributes to increased load and the overall degradation factor is still the high level. I will try the truss and send you the observation soon. Thanks in advance. Vivek Vijayaraghavan _ 1 USER: call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse1 0.03 0.02 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch4 1.73 1.74 0334 0 31 --- -- -- -- -- -- -- total6 1.76 1.76 0334 0 31 20 Simultaneous Users: -- USER #1: --- call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch4 1.91 6.48 0334 0 31 --- -- -- -- -- -- -- total6 1.91 6.48 0334 0 31 USER #2: --- call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse1 0.01 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch4 1.80 9.02 0334 0 31 --- -- -- -- -- -- -- total6 1.81 9.02 0334 0 31 USER #3: call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse1 0.01 0.01 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch4 1.86 9.81 0334 0 31 --- -- --
Re: Number of CPUs vs. Speed of CPUs
My view: if you have a lot of contention: few fast CPUs if you have virtually no contention: few fast CPUs or large number of slower CPUs. if you have a lot of contention and a large number of slow CPUs, your contention will become worse (basically it will take longer to execute the synchronized code and with more cpu's there is more chance for sessions spinning on a latch ). Anjo. K Gopalakrishnan wrote: Bruce: You got the point. We have discussed that some time back (Steve, Jonathan, and Adrian Cockcroft) and the result was: Few Faster CPUs are better for Performance, More slower CPUs are better for Manageability and fault tolerance. Steve Adams and Adrian are with few faster CPUS and Jonathan supports more slower CPUs. Best Regards, K Gopalakrishnan Bangalore, INDIA -Original Message- Bruce (CALBBAY) Sent: Thursday, April 18, 2002 4:33 PM To: Multiple recipients of list ORACLE-L Lisa, These aren't my points or ideas but below are some emails from Steve Adams that I have kept that may be of use. Also, I don't know for sure, but the 2 books (and or their authors:-) Practical Oracle8i by Jonathan Lewis and Scaling Oracle8i by James Morle may well have some very useful information on this topic. HTH, Bruce Reardon -Original Message- Sent: Thursday, 1 March 2001 17:46 To: Ixora Answers Hi All, Here is another follow-up to the February Ixora News item Buying Time at http://www.ixora.com.au/newsletter/2001_02.htm#memory_access. One of our subscribers asked Adrian Cockcroft, the author of Sun Performance and Tuning at http://www.amazon.com/exec/obidos/ASIN/0130952494/ixora for a second opinion. Here is Adrian's response ... Few faster CPUs is a little more efficient and has lower response time. More slow CPUs gives a flatter more predictable response time curve as the load increases so you can run nearer 100% busy. Read any book on queuing theory, especially Neil Gunther's Practical Performance Analyst at http://www.amazon.com/exec/obidos/ASIN/059512674X/ixora. See Performance Dynamics at http://www.perfdynamics.com/ for more on Neil Gunther's work, and Performance School at http://www.perfskool.com/ for related downloads. @ Regards, @ Steve Adams -Original Message- Sent: Wednesday, 28 February 2001 15:23 To: Ixora Answers Hi All, The recent Ixora News item Buying Time at http://www.ixora.com.au/newsletter/2001_02.htm#memory_access has provoked some discussion on the question of whether to buy fewer faster CPUs or more slower ones. It has been pointed out that there is one case in which it might be better to buy more slower CPUs. If an application has a number of highly CPU intensive processes (or threads) greater than or equal to the number of CPUs available, then the CPU usage will be unacceptably high. High CPU usage increases context switching overheads and introduces a risk of latch contention. If for some reason the CPU intensive processes cannot be tamed, then buying a greater number of slower CPUs may give better overall performance, despite the reduced CPU capacity and scalability. @ Regards, @ Steve Adams -Original Message- Sent: Friday, 19 April 2002 1:58 We are in the process of sizing a new server for multiple Oracle instances. What factors are useful as input in determining how many CPUs and the relative speed of them? For example, do we want fewer, faster CPUs or do we want more, slower CPUs? Are there any good guidelines to determine what the number of CPUs should be? Thanks in advance - Lisa -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) 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: 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
Re: ORA-00600 [12333], [0], [0]
Unfortunately, support is correct. But to add a bit more: 600/12333 indicates that the two task layer in Oracle (just above sqlnet) has received a function code, that it does not understand. I've been involved in a few cases with this error, and we did also not reach any conclusion. My personal opion is that this is really caused by problems/bugs in the underlying network (either lower parts of protocol stack or hardware) or by bugs in Oracle code. The latter - as subscribers to this mailing list will now - is difficult to get a real handle on without a reproducible case. /Bjørn. On Friday 19 April 2002 12:28, Thanh-truc Nguyen wrote: Hello, I get often ORA-00600 [12333], [0], [0] in a database (8.1.7.0 AIX 4.3). I openned a TAR but they just said there were lost of connections. Does anyone have the same problem and how to get rid of it please ? Thank in advance. Thanh-truc Nguyen Below is the header of the trace file : (ibm_rtki1) oracle8:/home/oracle8 head - 100 /log/oracle/RTKPRD/udump/ora_46650_rtkprd.trc /log/oracle/RTKPRD/udump/ora_46650_rtkprd.trc Oracle8i Enterprise Edition Release 8.1.7.0.0 - 64bit Production With the Partitioning option JServer Release 8.1.7.0.0 - 64bit Production ORACLE_HOME = /apps/oracle/product/8.1.7 System name:AIX Node name: ibm_rtki1 Release:3 Version:4 Machine:0052BA7A4C00 Instance name: RTKPRD Redo thread mounted by this instance: 1 Oracle process number: 31 Unix process pid: 46650, image: oracle@ibm_rtki1 (TNS V1-V3) *** SESSION ID:(191.3404) 2002-04-19 08:06:57.972 *** 2002-04-19 08:06:57.963 ksedmp: internal or fatal error ORA-00600: internal error code, arguments: [12333], [0], [0], [0], [], [], [], [] Current SQL information unavailable - no session. - Call Stack Trace - calling call entryargument values in hex location type point(? means dubious value) ksedmp+00fc bl ksedst 0 ? ksfdmp+0018 bl ksedmp 30003 ? kgeriv+0118 bl _ptrgl kgesiv+0080 bl kgeriv FFFD400 ? 1101B8320 ? 1101B8308 ? 01000D280 ? FFFDA68 ? ksesic3+0060 bl kgesiv 302D302D ? 30003 ? FFFD4B8 ? FFFE268 ? 0 ? opitsk+0654 bl ksesic3 302D302D ? 0 ? 0 ? 0 ? 0 ? 0 ? 0 ? 064206F6E ? opiino+0670 bl opitsk 110013E68 ? opiodr+06b8 bl _ptrgl opidrv+056c bl opiodr 3C0002 ? 4200FE898 ? E00 ? 0 ? sou2o+0028 bl opidrv 3C003C ? 40004 ? E00 ? main+0128bl sou2o 92163DC ? 9FFF0009DF8 ? E10 ? 9001000A00843E8 ? __start+0090 bl main 0 ? 0 ? - Argument/Register Address Dump - Accédez au courrier électronique de La Poste : www.laposte.net ; 3615 LAPOSTENET (0,13 /mn) ; tél : 08 92 68 13 50 (0,34/mn) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yso-8859-1?Q?Thanh-truc_Nguyen? 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). -- Bjørn Engsig, Miracle A/S http://MiracleAS.dk -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Bj=F8rn=20Engsig?= 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: Compare (diff) Oracle DB and MS-SQLServer DB
Hi Check the document below which discusses the differences in Oracle and SQL Server databases. http://www.dbresources.com/modules.php?name=Newsfile=articlesid=86 Thanks Jason --- Tim Gorman [EMAIL PROTECTED] wrote: ...this is even worse than the myth that programming to the ANSI SQL standard will allow you to port an application between RDBMS products, such as Oracle and SQL Server... :-) Oracle does not charge for development usage of it's products. That's why all software is downloadable for free from OTN. It is when you try to seek support that you should be properly licensed. That takes care of the cost issue... As far as the skills issue, the investment in learning how to install an Oracle development environment for an Oracle-based production system would be more than justified by the cost you are going to incur trying to put an application developed under SQL Server into an Oracle production system. Pay up now, or pay up later... This question of a script or tool to determine deltas is only the first of many installments of the pay up later choice... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, April 18, 2002 11:28 AM One of our teams started programming in SQLServer, but now we are live in a production ORACLE environment. Due to several issues, such as licensing,skills, etc., the development must stay on SQLServer. Is there a tool or whatever to find out the deltas between a SQLServerDB and an Oracle DB? Or any suggestions. Ray _ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Gordon 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: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jason Rowski 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: Good Article on differences between ORACLE and SQLServer
Which, of course was written by MS in MS Wurd format, which promptly locked up when I tried to close it. Figures. Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Jason Rowski [mailto:[EMAIL PROTECTED]] Sent: Friday, April 19, 2002 10:49 AM To: Multiple recipients of list ORACLE-L Subject: Good Article on differences between ORACLE and SQLServer Hi Check the document below which discusses the differences in Oracle and SQL Server databases. http://www.dbresources.com/modules.php?name=Newsfile=articlesid=86 -- 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).
RE: HIGH CPU WITH MULTIPLE CONCURRENT USERS (long)
The elapsed time taken can not change for this stress test except by improving the cpu time needed to execute a single task. So to improve the numbers some tuning needed on the sql. The average elapsed time for (n concurrent jobs) = x * n / c sec x = cpu time needed to execute a single task (alone on the system) c = number of CPUs n = number of concurrent tasks n = m * c where m = 2,3,4,5,6, etc. regards, Waleed -Original Message- To: Multiple recipients of list ORACLE-L Sent: 4/19/02 12:23 AM Vivek's feedback: (on your questions) Richard, I agree that over time this incident has been tested with various scenarios that it is getting confusing. However, the objective that we started with is still the same. Query: I have a query that does a select from 1 table (uses first_rows and index hint). This index is the one that gives us the best possible time with least possible consistent gets. The IN clause contain 50 individual literals. The query for 1 user to execute takes 1.67 seconds. This includes the time it also takes to display the results on the client. In our case the sql plus window on the database server. I had generated the trace file and did a TKPROF on the trace file. I am attaching the results of the trace file for your perusal. I had tried to _spin_count as default and various values from 4 to 4. The most optimal response time was obtained at _spin_count of 1. This is the value currently set. This was also recommended by Oracle as the CPU seems to be doing something (I believe due to Oracle) and is clearly visible as the user load is increased. To provide more clarity, I am attaching a word document that lists the trace status of parse, execute and fetch for 1 and 20 simultaneous users. Please note that while for 1 user the total elapsed time is very close the fetch time, for 20 concurrent users, the disparity is high. This disparity increases more than linearly as the stress is increased. I hope this helps. You are correct in your observation that Oracle does not show a wait in the v$session_wait and the CPU idle time is 0%, usage 98% user, 2% kernel. This can be observed clearly for as small as 100 concurrent users. There is no data functions or conversion on any of the columns both in the select and in the where clause. I want to be careful here. As I keep reducing the number of literals in the IN clause, the query works faster. However, the degradation factor (response time for 20 simultaneous queries to response time of 1 query) is the same hovering around 1 to 3.6. This degradation factor becomes very large as the stress in increased. Our first scenario was an IN clause with 800 literals. Then we had reduced it to 200. Then to 100. Now we are at 50. However, since our application response is for 800, now we have that many simultaneous queries accessing the database. This contributes to increased load and the overall degradation factor is still the high level. I will try the truss and send you the observation soon. Thanks in advance. Vivek Vijayaraghavan _ 1 USER: call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse1 0.03 0.02 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch4 1.73 1.74 0334 0 31 --- -- -- -- -- -- -- total6 1.76 1.76 0334 0 31 20 Simultaneous Users: -- USER #1: --- call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch4 1.91 6.48 0334 0 31 --- -- -- -- -- -- -- total6 1.91 6.48 0334 0 31 USER #2: --- call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse1 0.01 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch4 1.80 9.02 0334 0 31 --- -- -- -- -- -- -- total6 1.81 9.02 0334 0 31 USER #3: call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse1 0.01 0.01 0
Oracle licensing
Hi There have been some postings related to Oracle licensing. An interesting article: http://www.sacbee.com/content/politics/story/2219532p-2613285c.html Witold -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Witold Iwaniec 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).
Dbms_job not running
Hi, We have a job own by user MTSSYS which we scheduled to run every 1 minute but it is not running itself. If we run the job manully from sqlplus it runs fine. What can be the reason that job is not running itself??? Interval is set to SYSDATE+1/1440 Thanks --Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder 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).
sys.dbms_system.ksdwrt Strangeness
Calls to sys.dbms_system.ksdwrt to add entries to the alert log mysteriously insert a space infront of the string and sometimes doesn't SERVERERROR[955] SESSION 17,355 USER SYSTEM,oracle PROGRAM sqlplus@foo (TNS V1-V3),foo SERVERERROR[955] SESSION 13,5385 USER SYSTEM,oracle PROGRAM sqlplus@foo (TNS V1-V3),foo SERVERERROR[942] SESSION 13,7282 USER SYSADM,jdoe PROGRAM ,JOHN\DOE Anyone know why the last line has a space inserted into it? I have tried duplicating it but have had no luck. Ethan Post perotdba (AIM), epost1 (Yahoo) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan 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-00600: internal error code, arguments: [4400], [48]
Search on ora-00600 lookup, it should come up as the first doc on the list. Brian P. MacLean Oracle DBA, OCP8i Paul Vincent Paul.Vincent@ To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] uce.ac.uk cc: Sent by: Subject: RE: ORA-00600: internal error code, arguments: [4400], [48] [EMAIL PROTECTED] om 04/19/02 05:03 AM Please respond to ORACLE-L Purely out of interest, Brian, how do you find this page within MetaLink? I always prefer being able to navigate to these things myself within MetaLink, rather than having loads of bookmarks to specific MetaLink pages, but when I tried to find it, I didn't even know where to start looking! Can you tell me the navigation sequence, starting from the front page? Thanks, Paul -Original Message- Sent: 18 April 2002 20:49 To: Multiple recipients of list ORACLE-L Follow the link, put in your Oracle version, first argument of the ORA-00600, and paste the top of your stack trace, and wha-lait's magic, or what I like to call FM. http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_datab ase_id=NOTp_id=153788.1 Brian P. MacLean Oracle DBA, OCP8i -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Vincent 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).
Log on denied.... from script: Urgent - Pre-production Testing
Hi, We have an ETL script that logs onto the db. The scripts usually runs without error. During pre-production testing, we rec'd a logon denied error message. We re-ran the scripts and all was fine. I did not see anything in the alert log, only message for today was a redo log roll. Can anyone point me in the direction to troubleshoot this issue. We are in the testing phase of a system that is scheduled to go live and I am not preparded to allow this type of thing to slip by. Are there some other misc log either on Unix or Oracle that I can check to see what may have happed? I am running Oracle 8.1.7. on Sun Solaris 8 (both 64 bit). I would like to see if maybe there are semaphores for sessions etc that may need to be adjusted. Thanks, Hannah Hannah Doran Oracle Developer Sungard Securities Processing East (781) 999-9761 -- 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).
Long time for Batch Processing
Hello All, We are observing a strange problem for a couple of days. One of our batch process which usually takes about 30 minutes to complete sometimes takes upto 8 hours to complete and this varies even though the batch load is almost the same everynight. Some details on the job The job is a simple Oracle replication process of about 20-25 tables. Put a trace on the session during the time it spent a lot of time and observed that the inserts into our table took a very long time. No waits were observed. The tkprof report shows the CPU time = Elapsed Time. One other thing observed was the RBS usage jumped up to around 8 Gb.The table size is only 700M, add about 5 indexes to it, still does not explain why RBS usage should be so high. On normal days i.e. when it gets processed in 30 mts., the RBS usage is only about 100M. After the job is done, the database size increase is only about 100M, so wonder what goes into the RBS. No transactions in the database at the time the batch runs. Behaviour is not consistent, some days are good , others bad. Did complete network testing, no problems, server tests, disk transfer tests , everythings seems fine. The DB is an 8.17 database. Any idea folks how to proceed. Thanks Satish
RE: Enqueue and DB File Sequential Read Waits Problem
Hi Anjo, Q1: Are you running multiple jobs at the same time ? Could be true because you are running out of CPU How can you tell we are running out of CPU??? We are a development shop and have about 30 instances running on a single database server. There was just one major job running on this particular instance during the afternoon (although there may have been 3 or 4 additional connections). I will talk to the programmers about possible improvements to the SQL statements ... Thanks for the suggestions! Sam. p.s. If I have convincing evidence that the CPU on this box is overtaxed, it may help me to get another database server to spread instances onto. *** Date: Thu, 18 Apr 2002 23:22:17 +0200 Subject: Re: Enqueue and DB File Sequential Read Waits Problem Sam, The enqueue problem looks like an TX enqueue problem. Given the fact that the average wait is 307 and max wait is 308, I can see that you are also running out of CPU on your box. The normal max_wait should be 300 and the average wait should be less than 300. So the question now is why is there an TX enqueue problem. Q1: Are you running multiple jobs at the same time ? Could be true because you are running out of CPU The different jobs could interfere with each other. Given the fact that only 4 log file sync's have been done, could indicate some job control updates take place. The problem with db file sequential read is not the average speed (2 msec is fast), but there are peaks (max_wait of 290 msec) and the real problem is 7.2 million read operations. The question you need to ask your self: Do I need to do that many I/O operations ? Could I tune the SQL to reduce the number of I/O or utilize my cache better ? Anjo. -Original Message- From: Sam Bootsma Sent: April 18, 2002 5:33 PM To: '[EMAIL PROTECTED]' Subject: Enqueue and DB File Sequential Read Waits Problem We have a batch job taking a long time to process. Querying the v$session_wait view, I discovered there have been over 1200 enqueue waits, with an average wait of just over 307 and a max wait of 308. The total time waited is 370081 (just over one hour if these figures are in centiseconds). The batch job has been running about 6 hours. I also see that db file sequential read has waited almost 4 hours. This sounds like 4 hours waiting on index access requests. What could cause these long waits? I am not sure how to troubleshoot this problem further (Reading the Performance 101 Book is on My To Do List). This is Oracle 81630 on Windows NT server. Any suggestions or advice on how to troubleshoot this further is much appreciated. Here is my query and the output: SQL l 1 select substr(event, 1,30), total_waits, time_waited, average_wait, max_wait 2 from v$session_event 3* where sid=18 SQL / SUBSTR(EVENT,1,30)TOTAL_WAITS TIME_WAITED AVERAGE_WAIT MAX_WAIT ---- --- - latch free 5 0 0 0 enqueue 1204370081 307.376246308 buffer busy waits 45 0 0 0 log file switch completion2 27 13.5 17 log file sync 4 0 0 0 db file sequential read 7269278 1375000 .18915221 29 direct path read 4 10 2.5 10 direct path write 1098112 .1020036432 file open 4 0 0 0 SQL*Net message to client555 0 0 0 SQL*Net more data to client 11 1 .0909090911 SQL*Net message from client 555 32565.8667 1038 Thanks again for any pointers and suggestions. Sam Bootsma, OCP Technical Support Analyst -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sam Bootsma 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: Good Article on differences between ORACLE and SQLServer
If I find a file in Mac format and don't have a tool to open it, I guess I should blame Mac... Witold On 19 Apr 2002 at 8:13, Jesse, Rich wrote: Which, of course was written by MS in MS Wurd format, which promptly locked up when I tried to close it. Figures. Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Jason Rowski [mailto:[EMAIL PROTECTED]] Sent: Friday, April 19, 2002 10:49 AM To: Multiple recipients of list ORACLE-L Subject: Good Article on differences between ORACLE and SQLServer Hi Check the document below which discusses the differences in Oracle and SQL Server databases. http://www.dbresources.com/modules.php?name=Newsfile=articlesid=86 -- 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: Witold Iwaniec 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: Dbms_job not running
Did you set JOB_QUEUE_PROCESSES and JOB_QUEUE_INTERVAL in your initsid.ora parameter file? Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, April 19, 2002 12:13 PM Hi, We have a job own by user MTSSYS which we scheduled to run every 1 minute but it is not running itself. If we run the job manully from sqlplus it runs fine. What can be the reason that job is not running itself??? Interval is set to SYSDATE+1/1440 Thanks --Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder 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: Igor Neyman 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: Enqueue and DB File Sequential Read Waits Problem
Jonathan, Thanks for your response. The programmer stopped the process last night because it was taking too long ... so there was nothing in x$ksqst when I looked this morning. However, thanks for the tips on how to troubleshoot this further. Can I confirm that your report is describing a job where your session runs for six hours, and reports 1 hour of enqueues, and 4 hours of db file sequential reads, in that six hours ? Yes, that is what v$session_event showed me. And I confirmed the start time with the programmer. Sam. *** Waits Problem Date: Fri, 19 Apr 2002 13:14:19 +0100 Regarding the Enqueues: One follow-up is to connect as SYS and look at x$ksqst where ksqstwat != 0. This tells you two things (after the event). First, which type of enqueue has suffered waits, and secondly whether the waits in v$session_wait are represent a few very long waits or lots of shorter waits. (v$session_wait increments every 3 seconds, x$ksqst just once at the end) However, since your wait time is a large fraction of your elapsed time, you will probably be able to get some extra information simply by running a query against v$session_wait where name = 'enqueue' a couple of dozen times in quick succession. For the same reason, if you look at v$lock where request != 0 at regular intervals, you will be able to see the type and id of the wait. If you can identify the enqueue type, request mode, and id values, then you can track down causes more easily. Regarding the db file sequential read: Can I confirm that your report is describing a job where your session runs for six hours, and reports 1 hour of enqueues, and 4 hours of db file sequential reads, in that six hours ? If that is the case, then even though the reads are very fast reads (presumably helped by a large file-system buffer) then I suspect your SQL (or the strategy surrounding your use of SQL) needs to be examined. You MAY be doing an extreme amount of logical I/O to require 7M single block reads for one (effective) hour of CPU usage. For example, it is possible that the code has been 'tuned' to eliminate tablescans and increase hit ratios, with the detrimental side-effect that the logical I/O has gone up dramatically, and increased the actual cost of physical I/O. It is possible that the code has been written to loop through cursors and 'emulate' joining by executing several simple statements per row of the main cursor. In the short term, you may get an improvement in performance by shifting memory away from the file system buffer and into the Oracle buffer. The logical I/O won't drop, but the number of waits for filesystem interaction may. -Original Message- From: Sam Bootsma Sent: April 18, 2002 5:33 PM To: '[EMAIL PROTECTED]' Subject: Enqueue and DB File Sequential Read Waits Problem We have a batch job taking a long time to process. Querying the v$session_wait view, I discovered there have been over 1200 enqueue waits, with an average wait of just over 307 and a max wait of 308. The total time waited is 370081 (just over one hour if these figures are in centiseconds). The batch job has been running about 6 hours. I also see that db file sequential read has waited almost 4 hours. This sounds like 4 hours waiting on index access requests. What could cause these long waits? I am not sure how to troubleshoot this problem further (Reading the Performance 101 Book is on My To Do List). This is Oracle 81630 on Windows NT server. Any suggestions or advice on how to troubleshoot this further is much appreciated. Here is my query and the output: SQL l 1 select substr(event, 1,30), total_waits, time_waited, average_wait, max_wait 2 from v$session_event 3* where sid=18 SQL / SUBSTR(EVENT,1,30)TOTAL_WAITS TIME_WAITED AVERAGE_WAIT MAX_WAIT ---- --- - latch free 5 0 0 0 enqueue 1204370081 307.376246308 buffer busy waits 45 0 0 0 log file switch completion2 27 13.5 17 log file sync 4 0 0 0 db file sequential read 7269278 1375000 .18915221 29 direct path read 4 10 2.5 10 direct path write 1098112 .1020036432 file open 4 0 0 0 SQL*Net message to client555 0 0 0 SQL*Net more data to
Re:Dbms_job not running
What is/are the settings of JOB_QUEUE_INTERVAL and JOB_QUEUE_PROCESSES in your init.ora. Dick Goulet Reply Separator Author: Harvinder Singh [EMAIL PROTECTED] Date: 4/19/2002 8:13 AM Hi, We have a job own by user MTSSYS which we scheduled to run every 1 minute but it is not running itself. If we run the job manully from sqlplus it runs fine. What can be the reason that job is not running itself??? Interval is set to SYSDATE+1/1440 Thanks --Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder 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: 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: Good Article on differences between ORACLE and SQLSer
Jesse, What did you expect? It's from MSDN (MicroSlut Developers Network). Dick Goulet Reply Separator Author: Jesse; Rich [EMAIL PROTECTED] Date: 4/19/2002 8:13 AM Which, of course was written by MS in MS Wurd format, which promptly locked up when I tried to close it. Figures. Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Jason Rowski [mailto:[EMAIL PROTECTED]] Sent: Friday, April 19, 2002 10:49 AM To: Multiple recipients of list ORACLE-L Subject: Good Article on differences between ORACLE and SQLServer Hi Check the document below which discusses the differences in Oracle and SQL Server databases. http://www.dbresources.com/modules.php?name=Newsfile=articlesid=86 -- 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: 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).
REPLICATION/FAIL OVER
Hi I want to do sync two database once in a day.I have one database named test1 on one server and another db named test2 on other server.I want to sync 10 tables from db test1 to db test2 and 20 tables from db test2 to db test1. How can I do this?Is is only way to go replication?IS any other way to do that?If I go replication then can someone suggest which replication method would be good. Thx -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).
REPLICATION/FAIL OVER
Hi I want to do sync two database once in a day.I have one database named test1 on one server and another db named test2 on other server.I want to sync 10 tables from db test1 to db test2 and 20 tables from db test2 to db test1. How can I do this?Is is only way to go replication?IS any other way to do that?If I go replication then can someone suggest which replication method would be good. Thx -Seema _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- 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).
Re: sys.dbms_system.ksdwrt Strangeness
There is a level parameter in ksdind I believe, so just before you call ksdwrt, call ksdind(0). the lvl controls the indentation (sp?). Anjo. Post, Ethan wrote: Calls to sys.dbms_system.ksdwrt to add entries to the alert log mysteriously insert a space infront of the string and sometimes doesn't SERVERERROR[955] SESSION 17,355 USER SYSTEM,oracle PROGRAM sqlplus@foo (TNS V1-V3),foo SERVERERROR[955] SESSION 13,5385 USER SYSTEM,oracle PROGRAM sqlplus@foo (TNS V1-V3),foo SERVERERROR[942] SESSION 13,7282 USER SYSADM,jdoe PROGRAM ,JOHN\DOE Anyone know why the last line has a space inserted into it? I have tried duplicating it but have had no luck. Ethan Post perotdba (AIM), epost1 (Yahoo) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan 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: Anjo Kolk 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: REPLICATION/FAIL OVER
Seema - You could buy a separate replication package to do this, but you probably couldn't justify the cost. You could simply write some scripts to do this. But if you use Oracle's Basic Replication, then you get some resume material as a bonus. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, April 19, 2002 12:40 PM To: Multiple recipients of list ORACLE-L Hi I want to do sync two database once in a day.I have one database named test1 on one server and another db named test2 on other server.I want to sync 10 tables from db test1 to db test2 and 20 tables from db test2 to db test1. How can I do this?Is is only way to go replication?IS any other way to do that?If I go replication then can someone suggest which replication method would be good. Thx -Seema _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- 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: 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).
RE: Dbms_job not running
If the parameters suggested are already set up right , I have one more thing to ask... 1. is this something do with the DB Link ??? 2. if so , the user running the job is having any private DBLINK ??? --Madhu PS: If the DB LINK is used to run this job , you need to have a private dblink created for the user running the job. -Original Message- Sent: Friday, April 19, 2002 11:14 AM To: Multiple recipients of list ORACLE-L Hi, We have a job own by user MTSSYS which we scheduled to run every 1 minute but it is not running itself. If we run the job manully from sqlplus it runs fine. What can be the reason that job is not running itself??? Interval is set to SYSDATE+1/1440 Thanks --Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder 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: Reddy, Madhusudana 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: REPLICATION/FAIL OVER
Now that depends on how big the tables are? A few options off the top of my head: 1) Drop tables, export, import. 2) Replication. 3) Truncate, insert from select as. 4) Spool data, sql*load it. so many ways to skin a cat... I would probably play w/ replication. [EMAIL PROTECTED] 04/19/02 01:39PM Hi I want to do sync two database once in a day.I have one database named test1 on one server and another db named test2 on other server.I want to sync 10 tables from db test1 to db test2 and 20 tables from db test2 to db test1. How can I do this?Is is only way to go replication?IS any other way to do that?If I go replication then can someone suggest which replication method would be good. Thx -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: Gene Sais 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: Reorganize table
Is the table partitioned? Also, do you have any money for reorg tools? What sort of maintenance window do you have to complete this reorg? Can you negotiate for a larger-than-normal maintenance window? Cherie Koivu, Lisa lisa.koivu@efair To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] field.com cc: Sent by:Subject: RE: Reorganize table [EMAIL PROTECTED] 04/18/02 12:18 PM Please respond to ORACLE-L If you can't export, can you do ctas (create table as select..) ? Either way it's going to take a long, long time... Lisa Koivu Oracle Database Monkey. Fairfield Resorts, Inc. 954-935-4117 -Original Message- From: Raghu Kota [SMTP:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 11:39 AM To: Multiple recipients of list ORACLE-L Subject: Reorganize table Hi Friends, I need to reorganize my big fat table sized 23Gb, I don't have much space for export on my filesystem( I keep one or two filesystems ready for my expansion each size 4Gb) in the same table I have more than 5Gb free fragmented space, But I can't use it!! So what is best way to reorganize this monster table?? Thanks in advance Raghu. _ Join the world's largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota 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: Koivu, Lisa 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).
For Delphi user?
If I use Borland Delphi 5 for user interface and Oracle 8i for the database. How to set the value of EMP_ID column as a Primary Key(PK) of EMPLOYEE table ? Note: The PK was generated automatically by a sequence number 'EMP_SEQ', and it works normally on Oracle Form. TIA, Ferry Situmorang: Using Oracle 8.1.7 Designer 6i R4 PT Perkebunan Nusantara XIII (Persero) Pontianak-Indonesia http://www.ptpn13.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ferry Situmorang 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: Dbms_job not running
Are there any jobs running? There's a couple of init.ora parameters that must be set first. Jim -Original Message- Sent: Friday, April 19, 2002 2:04 PM To: Multiple recipients of list ORACLE-L If the parameters suggested are already set up right , I have one more thing to ask... 1. is this something do with the DB Link ??? 2. if so , the user running the job is having any private DBLINK ??? --Madhu PS: If the DB LINK is used to run this job , you need to have a private dblink created for the user running the job. -Original Message- Sent: Friday, April 19, 2002 11:14 AM To: Multiple recipients of list ORACLE-L Hi, We have a job own by user MTSSYS which we scheduled to run every 1 minute but it is not running itself. If we run the job manully from sqlplus it runs fine. What can be the reason that job is not running itself??? Interval is set to SYSDATE+1/1440 Thanks --Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder 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: Reddy, Madhusudana 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: Conboy, Jim 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).
Date fields store as varchar2???
Hello, Our DB has a GMT time zone, while our data warehouse has EST. For our application, some guys here insist that we store dates as varchar2 to avoid all the problems associated with data in the two databases. Though personally I want the dates to be stored in oracle date datatype, I would like to know more about how date fields behave in different processes... like 1) Snapshots - if the date in the data WH is going to be refreshed via a snapshot, what will the value be. 2) Export/Import 3) SQLLoader I depend on this list to give me some expert advice on this. Thanks much. __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Celine John 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: Good Article on differences between ORACLE and SQLServer
- Original Message - From: "Jason Rowski" Check the document below which discusses the differences in Oracle and SQL Server databases. http://www.dbresources.com/modules.php?name=Newsfile=articlesid=86 what about: Category Microsoft SQL Server Oracle Blob type storage 16-byte pointer stored with row. Data stored on other data pages One long or long raw per table, must be at end of row, data stored on same block(s) with row surely there are lots of similar pearls 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. "
RE: Dbms_job not running
Did you commit after submitting the job or the session is still open? Waleed -Original Message- Sent: Friday, April 19, 2002 12:14 PM To: Multiple recipients of list ORACLE-L Hi, We have a job own by user MTSSYS which we scheduled to run every 1 minute but it is not running itself. If we run the job manully from sqlplus it runs fine. What can be the reason that job is not running itself??? Interval is set to SYSDATE+1/1440 Thanks --Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder 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: Khedr, Waleed 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: Good Article on differences between ORACLE and SQLServer
LOL! Igor Neyman, OCP DBA[EMAIL PROTECTED] - Original Message - From: Marin Dimitrov To: Multiple recipients of list ORACLE-L Sent: Friday, April 19, 2002 3:19 PM Subject: Re: Good Article on differences between ORACLE and SQLServer - Original Message - From: "Jason Rowski" Check the document below which discusses the differences in Oracle and SQL Server databases. http://www.dbresources.com/modules.php?name=Newsfile=articlesid=86 what about: Category Microsoft SQL Server Oracle Blob type storage 16-byte pointer stored with row. Data stored on other data pages One long or long raw per table, must be at end of row, data stored on same block(s) with row surely there are lots of similar pearls 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. "
schedule Oracle stored procedure
Title: schedule Oracle stored procedure i've got the answer, for all those wanting to know, it's : dbms_job.submit (:jobnumber,'myproc(' 'proc_parameter' '); ', SYSDATE,'NEXT_DATE(TRUNC(SYSDATE), ' 'friday' ') + 17/24') ; (executes a SP every friday at 5pm) if anyone has a better solution, please let me know ... Atte. Nelson Flores P. Ingeniero Jefe de Proyectos [EMAIL PROTECTED] Fono (56-2) 2428374 --- Centro de tecnologías de Información http://cti.intec.cl Corporación de investigación Tecnológica - Intec http://www.intec.cl --- Avda el condor 844 Ciudad Empresarial Huechuraba Santiago - Chile
Re: executing a stored procedure at a certain time
Title: executing a stored procedure at a certain time Read on DBMS_JOB oracle-supplied package in docs. Igor Neyman, OCP DBA[EMAIL PROTECTED] - Original Message - From: Nelson Flores To: Multiple recipients of list ORACLE-L Sent: Friday, April 19, 2002 3:53 PM Subject: executing a stored procedure at a certain time Hello everyone, i was wondering if someone could tell me how set up an oracle internal mechanism that allows me to execute an oracle stored proc. at a certain time every day. thanks. Atte. Nelson Flores P. Intec Project Manager [EMAIL PROTECTED] --- Centro de tecnologías de Información http://cti.intec.cl Corporación de investigación Tecnológica - Intec http://www.intec.cl ---
RE: executing a stored procedure at a certain time
Title: executing a stored procedure at a certain time Schedule the stored proc as a job using 'EXEC DBMS_JOB.SUBMIT' Dave -Original Message-From: Nelson Flores [mailto:[EMAIL PROTECTED]]Sent: Friday, April 19, 2002 2:53 PMTo: Multiple recipients of list ORACLE-LSubject: executing a stored procedure at a certain time Hello everyone, i was wondering if someone could tell me how set up an oracle internal mechanism that allows me to execute an oracle stored proc. at a certain time every day. thanks. Atte. Nelson Flores P. Intec Project Manager [EMAIL PROTECTED] --- Centro de tecnologías de Información http://cti.intec.cl Corporación de investigación Tecnológica - Intec http://www.intec.cl ---
RE: executing a stored procedure at a certain time
Title: executing a stored procedure at a certain time You can schedule it as a database job. Look into the dbms_job package and section about database jobs in the admin guide. -Original Message-From: Nelson Flores [mailto:[EMAIL PROTECTED]]Sent: Friday, April 19, 2002 3:53 PMTo: Multiple recipients of list ORACLE-LSubject: executing a stored procedure at a certain time Hello everyone, i was wondering if someone could tell me how set up an oracle internal mechanism that allows me to execute an oracle stored proc. at a certain time every day. thanks. Atte. Nelson Flores P. Intec Project Manager [EMAIL PROTECTED] --- Centro de tecnologías de Información http://cti.intec.cl Corporación de investigación Tecnológica - Intec http://www.intec.cl ---
RE: executing a stored procedure at a certain time
dbms_job. See the SQL guide for your particular version of Oracle at http://technet.oracle.com Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: Nelson Flores [SMTP:[EMAIL PROTECTED]] Sent: Friday, April 19, 2002 2:53 PM To: Multiple recipients of list ORACLE-L Subject: executing a stored procedure at a certain time Hello everyone, i was wondering if someone could tell me how set up an oracle internal mechanism that allows me to execute an oracle stored proc. at a certain time every day. thanks. Atte. Nelson Flores P. Intec Project Manager [EMAIL PROTECTED] -- - Centro de tecnologías de Información http://cti.intec.cl Corporación de investigación Tecnológica - Intec http://www.intec.cl -- - -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: REPLICATION/FAIL OVER
Sais I am takling about replication.The assumption is tables are having millions of rows.In case if one Db server down i want to fail over to another one also.Which option in replication would be good Is it Multimaster replication. Thx -seema From: Gene Sais [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: REPLICATION/FAIL OVER Date: Fri, 19 Apr 2002 10:08:50 -0800 Now that depends on how big the tables are? A few options off the top of my head: 1) Drop tables, export, import. 2) Replication. 3) Truncate, insert from select as. 4) Spool data, sql*load it. so many ways to skin a cat... I would probably play w/ replication. [EMAIL PROTECTED] 04/19/02 01:39PM Hi I want to do sync two database once in a day.I have one database named test1 on one server and another db named test2 on other server.I want to sync 10 tables from db test1 to db test2 and 20 tables from db test2 to db test1. How can I do this?Is is only way to go replication?IS any other way to do that?If I go replication then can someone suggest which replication method would be good. Thx -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: Gene Sais 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). _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- 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).
Re: REPLICATION/FAIL OVER
Sais I am takling about replication.The assumption is tables are having millions of rows.In case if one Db server down i want to fail over to another one also.Which option in replication would be good Is it Multimaster replication. Thx -Dinesh From: Gene Sais [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: REPLICATION/FAIL OVER Date: Fri, 19 Apr 2002 10:08:50 -0800 Now that depends on how big the tables are? A few options off the top of my head: 1) Drop tables, export, import. 2) Replication. 3) Truncate, insert from select as. 4) Spool data, sql*load it. so many ways to skin a cat... I would probably play w/ replication. [EMAIL PROTECTED] 04/19/02 01:39PM Hi I want to do sync two database once in a day.I have one database named test1 on one server and another db named test2 on other server.I want to sync 10 tables from db test1 to db test2 and 20 tables from db test2 to db test1. How can I do this?Is is only way to go replication?IS any other way to do that?If I go replication then can someone suggest which replication method would be good. Thx -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: Gene Sais 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). _ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- 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).
RE: executing a stored procedure at a certain time
Title: executing a stored procedure at a certain time Check out Oracle jobs (dbms_jobs package). It's pretty easy. Prakash -Original Message-From: Nelson Flores [mailto:[EMAIL PROTECTED]]Sent: Friday, April 19, 2002 3:53 PMTo: Multiple recipients of list ORACLE-LSubject: executing a stored procedure at a certain time Hello everyone, i was wondering if someone could tell me how set up an oracle internal mechanism that allows me to execute an oracle stored proc. at a certain time every day. thanks. Atte. Nelson Flores P. Intec Project Manager [EMAIL PROTECTED] --- Centro de tecnologías de Información http://cti.intec.cl Corporación de investigación Tecnológica - Intec http://www.intec.cl ---
Re: Renaming files on Unix via PL/SQL
Sorry to get on this thread so late... To answer Emre's question, we can do it if you have a extproc listener configured and have a external procedure to do the same. Babu - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, April 19, 2002 8:53 AM HOST is a SQL*Plus command only. --- John Weatherman [EMAIL PROTECTED] wrote: What about issueing a HOST command through dbms_sql? Not saying it will work (I haven't tried it) but it seems like it should. -Original Message- Sent: Friday, April 19, 2002 5:53 AM To: Multiple recipients of list ORACLE-L Hi, no, there's no way to do that through PL/SQL. If have the option of using java you can use the solution given by Tom Kyte at http://asktom.oracle.com/pls/ask/f?p=4950:8:F4950_P8_DISPLAYID:952229840 241 http://asktom.oracle.com/pls/ask/f?p=4950:8:F4950_P8_DISPLAYID:95222984 0241 Regards, Mike Hately -Original Message- Sent: 19 April 2002 10:03 To: Multiple recipients of list ORACLE-L Hi all, Is it possible to rename files (e.g .txt files) on Unix by using PL/SQL? Is there a function to do that? Regards M.Emre HANCIOGLU Masterfoods Services GmbH ISI Application Support Tel : +49 2162 500-576 Fax: +49 2162 41497 E-Mail: [EMAIL PROTECTED] This email and any attached to it are confidential and intended only for the individual or entity to which it is addressed. If you are not the intended recipient, please let us know by telephoning or emailing the sender. You should also delete the email and any attachment from your systems and should not copy the email or any attachment or disclose their content to any other person or entity. The views expressed here are not necessarily those of Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you. Churchill Insurance Group plc. Company Registration Number - 2280426. England. Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1 1DP. __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube 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: Babu Nagarajan 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: REPLICATION/FAIL OVER
Is there any additional software required if i go to advanced replication? -seema From: DENNIS WILLIAMS [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: REPLICATION/FAIL OVER Date: Fri, 19 Apr 2002 10:03:57 -0800 Seema - You could buy a separate replication package to do this, but you probably couldn't justify the cost. You could simply write some scripts to do this. But if you use Oracle's Basic Replication, then you get some resume material as a bonus. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, April 19, 2002 12:40 PM To: Multiple recipients of list ORACLE-L Hi I want to do sync two database once in a day.I have one database named test1 on one server and another db named test2 on other server.I want to sync 10 tables from db test1 to db test2 and 20 tables from db test2 to db test1. How can I do this?Is is only way to go replication?IS any other way to do that?If I go replication then can someone suggest which replication method would be good. Thx -Seema _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- 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: 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). _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx -- 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).
RE: REPLICATION/FAIL OVER
Seema - Another alternative you may want to check out is transportable tablespaces, since you just want to sync the databases up once/day. I think this will require less maintenance than replication. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, April 19, 2002 3:24 PM To: Multiple recipients of list ORACLE-L Sais I am takling about replication.The assumption is tables are having millions of rows.In case if one Db server down i want to fail over to another one also.Which option in replication would be good Is it Multimaster replication. Thx -Dinesh From: Gene Sais [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: REPLICATION/FAIL OVER Date: Fri, 19 Apr 2002 10:08:50 -0800 Now that depends on how big the tables are? A few options off the top of my head: 1) Drop tables, export, import. 2) Replication. 3) Truncate, insert from select as. 4) Spool data, sql*load it. so many ways to skin a cat... I would probably play w/ replication. [EMAIL PROTECTED] 04/19/02 01:39PM Hi I want to do sync two database once in a day.I have one database named test1 on one server and another db named test2 on other server.I want to sync 10 tables from db test1 to db test2 and 20 tables from db test2 to db test1. How can I do this?Is is only way to go replication?IS any other way to do that?If I go replication then can someone suggest which replication method would be good. Thx -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: Gene Sais 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). _ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- 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: 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).
Re: EMC Storage Array Issue
Since I started this thread, I thought I'd update everyone on what the problem ended up being. There is a problem with one of the power supplies on the switch in the SAN. The other power supply was not plugged in, so it halted everything occasionally. We plugged the other power supply in, and haven't had the problem since. Now we need to get the power supply replaced. Interesting that EMC tried to blame it on Oracle first. Scott Canaan wrote: We have implemented a Sun Solaris Cluster (4 machines), connected to an EMC storage array. The migration began last fall, and we now have 15 Oracle instances, with a mixture of 8.1.6 and 8.1.7, located there. We recently have had 2 occurances of asynchronous I/O wait times exceeded. When this occurs, every database crashes at the same time. The solution from EMC is to turn asynchronous I/O off in all of the Oracle instances (disk_async_io = false) and to increase the database writer slaves (dbwr_io_slaves = something not 0) to emulate asynchronous I/O. Has anyone run into this problem before? If so, how did you correct it? My feeling is that EMC is trying to give us a bandage to cover up the real problem, by trying to get Oracle to ignore it. Thank you. -- Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 Life is like a sewer, what you get out of it depends on what you put into it - Tom Lehrer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan 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). -- Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 Life is like a sewer, what you get out of it depends on what you put into it - Tom Lehrer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan 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: REPLICATION/FAIL OVER
Seema, Excuse me for spitting out ideas. You mentioned replication as one method and were unsure of this method. You also expressed interest in alternative methods besides replication of which I mentioned a few. Good luck in your search. Gene PS. BTW, replication is not a good tool for HA. But then again, thats another question. [EMAIL PROTECTED] 04/19/02 04:24PM Sais I am takling about replication.The assumption is tables are having millions of rows.In case if one Db server down i want to fail over to another one also.Which option in replication would be good Is it Multimaster replication. Thx -Dinesh From: Gene Sais [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: REPLICATION/FAIL OVER Date: Fri, 19 Apr 2002 10:08:50 -0800 Now that depends on how big the tables are? A few options off the top of my head: 1) Drop tables, export, import. 2) Replication. 3) Truncate, insert from select as. 4) Spool data, sql*load it. so many ways to skin a cat... I would probably play w/ replication. [EMAIL PROTECTED] 04/19/02 01:39PM Hi I want to do sync two database once in a day.I have one database named test1 on one server and another db named test2 on other server.I want to sync 10 tables from db test1 to db test2 and 20 tables from db test2 to db test1. How can I do this?Is is only way to go replication?IS any other way to do that?If I go replication then can someone suggest which replication method would be good. Thx -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: Gene Sais 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). _ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- 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: Gene Sais 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: Renaming files on Unix via PL/SQL
Babu, can you give an example ? thanks Santi -Original Message- Sent: Friday, April 19, 2002 1:38 PM To: Multiple recipients of list ORACLE-L Sorry to get on this thread so late... To answer Emre's question, we can do it if you have a extproc listener configured and have a external procedure to do the same. Babu - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, April 19, 2002 8:53 AM HOST is a SQL*Plus command only. --- John Weatherman [EMAIL PROTECTED] wrote: What about issueing a HOST command through dbms_sql? Not saying it will work (I haven't tried it) but it seems like it should. -Original Message- Sent: Friday, April 19, 2002 5:53 AM To: Multiple recipients of list ORACLE-L Hi, no, there's no way to do that through PL/SQL. If have the option of using java you can use the solution given by Tom Kyte at http://asktom.oracle.com/pls/ask/f?p=4950:8:F4950_P8_DISPLAYID:952229840 241 http://asktom.oracle.com/pls/ask/f?p=4950:8:F4950_P8_DISPLAYID:95222984 0241 Regards, Mike Hately -Original Message- Sent: 19 April 2002 10:03 To: Multiple recipients of list ORACLE-L Hi all, Is it possible to rename files (e.g .txt files) on Unix by using PL/SQL? Is there a function to do that? Regards M.Emre HANCIOGLU Masterfoods Services GmbH ISI Application Support Tel : +49 2162 500-576 Fax: +49 2162 41497 E-Mail: [EMAIL PROTECTED] This email and any attached to it are confidential and intended only for the individual or entity to which it is addressed. If you are not the intended recipient, please let us know by telephoning or emailing the sender. You should also delete the email and any attachment from your systems and should not copy the email or any attachment or disclose their content to any other person or entity. The views expressed here are not necessarily those of Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you. Churchill Insurance Group plc. Company Registration Number - 2280426. England. Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1 1DP. __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube 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: Babu Nagarajan 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: Prakriteswar Santikary 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: Enqueue and DB File Sequential Read Waits Problem
Hi Jonathan/Anjo/Sam: Let me say that v$system_event (and I assume it´s valid for v$session_event too) does not report the enqueue average wait time correctly. (unless until version 8.1.6, I don't know what version are you using) To calculate the precise number of enqueue waits you have to use v$sysstat enqueue waits (*) statistic or to do TOTAL_WAITS-TOTAL_TIMEOUTS (*). it's the same. So, to get the correct average you should divide TIME_WAITED/(*). In order to resolve the enqueue waits I'd take Jonathan advice. First identify the class of enqueue wait you're facing. You can do that running a query against v$session_wait (like Jonathan said) or by tracing the session with event 10046 and interpreting the output. Is this the only transaction running against these tables in the moment you're executing this procedure? If this were true, then I think it'd not be possible to see enqueue waits of type TX. right? So it must be another type of enqueue problem. Find out which type of enqueue problem you have. select * from x$ksqst where ksqstwat != 0 HTH Greetings Diego Cutrone - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, April 19, 2002 10:59 AM Jonathan, Thanks for your response. The programmer stopped the process last night because it was taking too long ... so there was nothing in x$ksqst when I looked this morning. However, thanks for the tips on how to troubleshoot this further. Can I confirm that your report is describing a job where your session runs for six hours, and reports 1 hour of enqueues, and 4 hours of db file sequential reads, in that six hours ? Yes, that is what v$session_event showed me. And I confirmed the start time with the programmer. Sam. *** Waits Problem Date: Fri, 19 Apr 2002 13:14:19 +0100 Regarding the Enqueues: One follow-up is to connect as SYS and look at x$ksqst where ksqstwat != 0. This tells you two things (after the event). First, which type of enqueue has suffered waits, and secondly whether the waits in v$session_wait are represent a few very long waits or lots of shorter waits. (v$session_wait increments every 3 seconds, x$ksqst just once at the end) However, since your wait time is a large fraction of your elapsed time, you will probably be able to get some extra information simply by running a query against v$session_wait where name = 'enqueue' a couple of dozen times in quick succession. For the same reason, if you look at v$lock where request != 0 at regular intervals, you will be able to see the type and id of the wait. If you can identify the enqueue type, request mode, and id values, then you can track down causes more easily. Regarding the db file sequential read: Can I confirm that your report is describing a job where your session runs for six hours, and reports 1 hour of enqueues, and 4 hours of db file sequential reads, in that six hours ? If that is the case, then even though the reads are very fast reads (presumably helped by a large file-system buffer) then I suspect your SQL (or the strategy surrounding your use of SQL) needs to be examined. You MAY be doing an extreme amount of logical I/O to require 7M single block reads for one (effective) hour of CPU usage. For example, it is possible that the code has been 'tuned' to eliminate tablescans and increase hit ratios, with the detrimental side-effect that the logical I/O has gone up dramatically, and increased the actual cost of physical I/O. It is possible that the code has been written to loop through cursors and 'emulate' joining by executing several simple statements per row of the main cursor. In the short term, you may get an improvement in performance by shifting memory away from the file system buffer and into the Oracle buffer. The logical I/O won't drop, but the number of waits for filesystem interaction may. -Original Message- From: Sam Bootsma Sent: April 18, 2002 5:33 PM To: '[EMAIL PROTECTED]' Subject: Enqueue and DB File Sequential Read Waits Problem We have a batch job taking a long time to process. Querying the v$session_wait view, I discovered there have been over 1200 enqueue waits, with an average wait of just over 307 and a max wait of 308. The total time waited is 370081 (just over one hour if these figures are in centiseconds). The batch job has been running about 6 hours. I also see that db file sequential read has waited almost 4 hours. This sounds like 4 hours waiting on index access requests. What could cause these long waits? I am not sure how to troubleshoot this problem further (Reading the Performance 101 Book is on My To Do List). This is Oracle 81630 on Windows NT server. Any suggestions or advice on how to troubleshoot this further is much appreciated. Here is my query and the output: SQL l 1 select substr(event, 1,30), total_waits, time_waited, average_wait,
RE: REPLICATION/FAIL OVER
Seema - Advanced replication is a feature of Oracle Enterprise Edition, so if you have that, you should be set. Based on your description, updatable snapshots may meet your needs, and be simpler to configure and maintain. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, April 19, 2002 3:49 PM To: Multiple recipients of list ORACLE-L Is there any additional software required if i go to advanced replication? -seema From: DENNIS WILLIAMS [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: REPLICATION/FAIL OVER Date: Fri, 19 Apr 2002 10:03:57 -0800 Seema - You could buy a separate replication package to do this, but you probably couldn't justify the cost. You could simply write some scripts to do this. But if you use Oracle's Basic Replication, then you get some resume material as a bonus. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, April 19, 2002 12:40 PM To: Multiple recipients of list ORACLE-L Hi I want to do sync two database once in a day.I have one database named test1 on one server and another db named test2 on other server.I want to sync 10 tables from db test1 to db test2 and 20 tables from db test2 to db test1. How can I do this?Is is only way to go replication?IS any other way to do that?If I go replication then can someone suggest which replication method would be good. Thx -Seema _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- 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: 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). _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx -- 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: 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).
RE: EMC Storage Array Issue
Very interesting. So the EMC box didn't 'phone home' like it was suppossed to, to report this problem? Thanks for sharing this Scott. Lisa Koivu Oracle Database Blue Softball Ankles Fairfield Resorts, Inc. Office: 954-935-4117 -Original Message- From: Scott Canaan [SMTP:[EMAIL PROTECTED]] Sent: Friday, April 19, 2002 5:09 PM To: Multiple recipients of list ORACLE-L Subject: Re: EMC Storage Array Issue Since I started this thread, I thought I'd update everyone on what the problem ended up being. There is a problem with one of the power supplies on the switch in the SAN. The other power supply was not plugged in, so it halted everything occasionally. We plugged the other power supply in, and haven't had the problem since. Now we need to get the power supply replaced. Interesting that EMC tried to blame it on Oracle first. Scott Canaan wrote: We have implemented a Sun Solaris Cluster (4 machines), connected to an EMC storage array. The migration began last fall, and we now have 15 Oracle instances, with a mixture of 8.1.6 and 8.1.7, located there. We recently have had 2 occurances of asynchronous I/O wait times exceeded. When this occurs, every database crashes at the same time. The solution from EMC is to turn asynchronous I/O off in all of the Oracle instances (disk_async_io = false) and to increase the database writer slaves (dbwr_io_slaves = something not 0) to emulate asynchronous I/O. Has anyone run into this problem before? If so, how did you correct it? My feeling is that EMC is trying to give us a bandage to cover up the real problem, by trying to get Oracle to ignore it. Thank you. -- Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 Life is like a sewer, what you get out of it depends on what you put into it - Tom Lehrer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan 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). -- Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 Life is like a sewer, what you get out of it depends on what you put into it - Tom Lehrer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan 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: Koivu, Lisa 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: EMC Storage Array Issue
ROFLOL Gosh, we don't know why, must be the databases fault, all 15 of them. Thanx for giving me a Friday Funny..BOL Scott Canaan srcdco@ritvax To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] .rit.educc: Sent by: Subject: Re: EMC Storage Array Issue [EMAIL PROTECTED] om 04/19/02 02:09 PM Please respond to ORACLE-L Since I started this thread, I thought I'd update everyone on what the problem ended up being. There is a problem with one of the power supplies on the switch in the SAN. The other power supply was not plugged in, so it halted everything occasionally. We plugged the other power supply in, and haven't had the problem since. Now we need to get the power supply replaced. Interesting that EMC tried to blame it on Oracle first. Scott Canaan wrote: We have implemented a Sun Solaris Cluster (4 machines), connected to an EMC storage array. The migration began last fall, and we now have 15 Oracle instances, with a mixture of 8.1.6 and 8.1.7, located there. We recently have had 2 occurances of asynchronous I/O wait times exceeded. When this occurs, every database crashes at the same time. The solution from EMC is to turn asynchronous I/O off in all of the Oracle instances (disk_async_io = false) and to increase the database writer slaves (dbwr_io_slaves = something not 0) to emulate asynchronous I/O. Has anyone run into this problem before? If so, how did you correct it? My feeling is that EMC is trying to give us a bandage to cover up the real problem, by trying to get Oracle to ignore it. Thank you. -- Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 Life is like a sewer, what you get out of it depends on what you put into it - Tom Lehrer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan 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). -- Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 Life is like a sewer, what you get out of it depends on what you put into it - Tom Lehrer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan 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
Re: Pinhitratio vs gethitratio
Tracy, The best thing you can do to your sanity is to completely ignore these kinds of ratios. If the wait interface shows a problem you might now and then end up looking at certain ratios in order to determine the real reason for waits, but that's it. Ratios as the ones you mention are meaningless. Best regards, Mogens Tracy Rahmlow wrote: Can someone explain why a pinhitratio would be higher than a gethitratio in the v$librarycache for the namespace = 'SQL AREA'? I would think it would be the opposite. Our current gethitratio is 87.98 and the pinhitratio is 95.10. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mogens =?ISO-8859-1?Q?N=F8rgaard?= 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: REPLICATION/FAIL OVER
Dennis I want to do sync 4 tables from db1 to db2 and 3tables from db2 to db1. If i make one server as master server then is it possible to make secondary server(snapshot server) once and vice versa. Thanks -Seema From: DENNIS WILLIAMS [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: REPLICATION/FAIL OVER Date: Fri, 19 Apr 2002 13:09:19 -0800 Seema - Advanced replication is a feature of Oracle Enterprise Edition, so if you have that, you should be set. Based on your description, updatable snapshots may meet your needs, and be simpler to configure and maintain. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, April 19, 2002 3:49 PM To: Multiple recipients of list ORACLE-L Is there any additional software required if i go to advanced replication? -seema From: DENNIS WILLIAMS [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: REPLICATION/FAIL OVER Date: Fri, 19 Apr 2002 10:03:57 -0800 Seema - You could buy a separate replication package to do this, but you probably couldn't justify the cost. You could simply write some scripts to do this. But if you use Oracle's Basic Replication, then you get some resume material as a bonus. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, April 19, 2002 12:40 PM To: Multiple recipients of list ORACLE-L Hi I want to do sync two database once in a day.I have one database named test1 on one server and another db named test2 on other server.I want to sync 10 tables from db test1 to db test2 and 20 tables from db test2 to db test1. How can I do this?Is is only way to go replication?IS any other way to do that?If I go replication then can someone suggest which replication method would be good. Thx -Seema _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- 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: 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). _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx -- 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: 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). _ Get your FREE download of
RE: Renaming files on Unix via PL/SQL
Yes you could, but one needs to be aware of the security implications. One hopes that nobody is running their external procedure listener under a privileged user such as oracle or root.If so who ever could use the PL/SQL procedure could rename YOU right out of a job. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Friday, April 19, 2002 2:09 PM To: Multiple recipients of list ORACLE-L Babu, can you give an example ? thanks Santi -Original Message- Sent: Friday, April 19, 2002 1:38 PM To: Multiple recipients of list ORACLE-L Sorry to get on this thread so late... To answer Emre's question, we can do it if you have a extproc listener configured and have a external procedure to do the same. Babu - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, April 19, 2002 8:53 AM HOST is a SQL*Plus command only. --- John Weatherman [EMAIL PROTECTED] wrote: What about issueing a HOST command through dbms_sql? Not saying it will work (I haven't tried it) but it seems like it should. -Original Message- Sent: Friday, April 19, 2002 5:53 AM To: Multiple recipients of list ORACLE-L Hi, no, there's no way to do that through PL/SQL. If have the option of using java you can use the solution given by Tom Kyte at http://asktom.oracle.com/pls/ask/f?p=4950:8:F4950_P8_DISPLAYID:952229840 241 http://asktom.oracle.com/pls/ask/f?p=4950:8:F4950_P8_DISPLAYID:95222984 0241 Regards, Mike Hately -Original Message- Sent: 19 April 2002 10:03 To: Multiple recipients of list ORACLE-L Hi all, Is it possible to rename files (e.g .txt files) on Unix by using PL/SQL? Is there a function to do that? Regards M.Emre HANCIOGLU Masterfoods Services GmbH ISI Application Support Tel : +49 2162 500-576 Fax: +49 2162 41497 E-Mail: [EMAIL PROTECTED] This email and any attached to it are confidential and intended only for the individual or entity to which it is addressed. If you are not the intended recipient, please let us know by telephoning or emailing the sender. You should also delete the email and any attachment from your systems and should not copy the email or any attachment or disclose their content to any other person or entity. The views expressed here are not necessarily those of Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you. Churchill Insurance Group plc. Company Registration Number - 2280426. England. Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1 1DP. __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube 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: Babu Nagarajan 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: Prakriteswar Santikary 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
Re: Enqueue and DB File Sequential Read Waits Problem
Diego, Let me say that v$system_event (and I assume its valid for v$session_event too) does not report the "enqueue" average wait time correctly. (unless until version 8.1.6, I don't know what version are you using) I know and I know why that is ;-) And by the way, it is correct ... Anjo. Diego Cutrone wrote: Hi Jonathan/Anjo/Sam: Let me say that v$system_event (and I assume its valid for v$session_event too) does not report the "enqueue" average wait time correctly. (unless until version 8.1.6, I don't know what version are you using) To calculate the precise number of enqueue waits you have to use v$sysstat "enqueue waits" (*) statistic or to do TOTAL_WAITS-TOTAL_TIMEOUTS (*). it's the same. So, to get the correct average you should divide TIME_WAITED/(*). In order to resolve the enqueue waits I'd take Jonathan advice. First identify the class of enqueue wait you're facing. You can do that running a query against v$session_wait (like Jonathan said) or by tracing the session with event 10046 and interpreting the output. Is this the only transaction running against these tables in the moment you're executing this procedure? If this were true, then I think it'd not be possible to see enqueue waits of type TX. right? So it must be another type of enqueue problem. Find out which type of enqueue problem you have. select * from x$ksqst where ksqstwat != 0 HTH Greetings Diego Cutrone - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]> Sent: Friday, April 19, 2002 10:59 AM > Jonathan, > Thanks for your response. The programmer stopped the process last night > because it was taking too long ... so there was nothing in x$ksqst when I > looked this morning. However, thanks for the tips on how to troubleshoot > this further. > > Can I confirm that your report is describing a job where your session runs > for six hours, and reports 1 hour of enqueues, and 4 > hours of db file > sequential reads, in that six hours ? > Yes, that is what v$session_event showed me. And I confirmed the start time > with the programmer. > Sam. > *** > Waits Problem Date: Fri, 19 Apr 2002 13:14:19 +0100 > Regarding the Enqueues: One follow-up is to connect as SYS and look at > x$ksqst where ksqstwat != 0. This tells you two things (after the event). > First, which type of enqueue has suffered waits, and secondly whether the > waits in v$session_wait are represent a few very long waits or lots of > shorter waits. (v$session_wait increments every 3 seconds, x$ksqst just once > at the end) However, since your wait time is a large fraction of your > elapsed time, you will probably be able to get some extra information simply > by running a query against v$session_wait where name = 'enqueue' a couple of > dozen times in quick succession. For the same reason, if you look at v$lock > where request != 0 at regular intervals, you will be able to see the type > and id of the wait. If you can identify the enqueue type, request mode, and > id values, then you can track down causes more easily. Regarding the db file > sequential read: Can I confirm that your report is describing a job where > your session runs for six hours, and reports 1 hour of enqueues, and 4 hours > of db file sequential reads, in that six hours ? If that is the case, then > even though the reads are very fast reads (presumably helped by a large > file-system buffer) then I suspect your SQL (or the strategy surrounding > your use of SQL) needs to be examined. You MAY be doing an extreme amount of > logical I/O to require 7M single block reads for one (effective) hour of CPU > usage. For example, it is possible that the code has been 'tuned' to > eliminate tablescans and increase hit ratios, with the detrimental > side-effect that the logical I/O has gone up dramatically, and increased the > actual cost of physical I/O. It is possible that the code has been written > to loop through cursors and 'emulate' joining by executing several simple > statements per row of the main cursor. In the short term, you may get an > improvement in performance by shifting memory away from the file system > buffer and into the Oracle buffer. The logical I/O won't drop, but the > number of waits for filesystem interaction may. > > > > > -Original Message- > > From: Sam Bootsma > > Sent: April 18, 2002 5:33 PM > > To: '[EMAIL PROTECTED]' > > Subject: Enqueue and DB File Sequential Read Waits Problem > > > > We have a batch job taking a long time to process. Querying the > > v$session_wait view, I discovered there have been over 1200 enqueue waits, > > with an average wait of just over 307 and a max wait of 308. The total > > time waited is 370081 (just over one hour if these figures are in > > centiseconds). The batch job has been running about 6 hours. > > > > I also see that db file sequential read has waited almost 4 hours. This > > sounds like 4 hours waiting on index access requests. What could cause > > these long
RE: REPLICATION/FAIL OVER
Seema - I have only done just a little testing of replication, so I'm hardly the expert. I believe the answer to your question is yes. You can make db1 the master site for the 4 tables and db2 the master site for the 3 tables. The bigger question is whether changes can be made to these tables from either side. If the answer is no, then simple snapshots will be sufficient. If the answer is yes, then you must look at how the application is designed. Can you make changes to the application to avoid problems in replication? But people tend to approach replication with a set of ideas and then find that they must change those ideas as they learn more. Oracle Replication is not a high-volume method, so you must have a good handle on how many rows will get changed each day. A good book is Oracle Distributed Systems by Charles Dye. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, April 19, 2002 4:59 PM To: Multiple recipients of list ORACLE-L Dennis I want to do sync 4 tables from db1 to db2 and 3tables from db2 to db1. If i make one server as master server then is it possible to make secondary server(snapshot server) once and vice versa. Thanks -Seema From: DENNIS WILLIAMS [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: REPLICATION/FAIL OVER Date: Fri, 19 Apr 2002 13:09:19 -0800 Seema - Advanced replication is a feature of Oracle Enterprise Edition, so if you have that, you should be set. Based on your description, updatable snapshots may meet your needs, and be simpler to configure and maintain. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, April 19, 2002 3:49 PM To: Multiple recipients of list ORACLE-L Is there any additional software required if i go to advanced replication? -seema From: DENNIS WILLIAMS [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: REPLICATION/FAIL OVER Date: Fri, 19 Apr 2002 10:03:57 -0800 Seema - You could buy a separate replication package to do this, but you probably couldn't justify the cost. You could simply write some scripts to do this. But if you use Oracle's Basic Replication, then you get some resume material as a bonus. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, April 19, 2002 12:40 PM To: Multiple recipients of list ORACLE-L Hi I want to do sync two database once in a day.I have one database named test1 on one server and another db named test2 on other server.I want to sync 10 tables from db test1 to db test2 and 20 tables from db test2 to db test1. How can I do this?Is is only way to go replication?IS any other way to do that?If I go replication then can someone suggest which replication method would be good. Thx -Seema _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- 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: 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). _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx -- 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,
Re: EMC Storage Array Issue
Hi Scott/All, We have been able to identify the root cause for the issues we had with EMC during the last 2 weeks. The root cause was an issue with EMC PowerPath in a SAN environment where it was not able to resolve alternate paths. We are upgrading from PowerPath Version 1.3 to Version 2.0 to resolve the problem. The frame didn't dial out to EMC and it took some time before we identified the root cause. Regards, Denny Recently we had issues with EMC. Last week we started getting IO timeout on one of our frames followed by files being accessed disappearing. We lost controlfiles, redo log files and library files. EMC hasn't been able to tell us why it happended. I would like to hear about solutions/explanation they come up with for your problem. Quoting Scott Canaan [EMAIL PROTECTED]: Since I started this thread, I thought I'd update everyone on what the problem ended up being. There is a problem with one of the power supplies on the switch in the SAN. The other power supply was not plugged in, so it halted everything occasionally. We plugged the other power supply in, and haven't had the problem since. Now we need to get the power supply replaced. Interesting that EMC tried to blame it on Oracle first. Scott Canaan wrote: We have implemented a Sun Solaris Cluster (4 machines), connected to an EMC storage array. The migration began last fall, and we now have 15 Oracle instances, with a mixture of 8.1.6 and 8.1.7, located there. We recently have had 2 occurances of asynchronous I/O wait times exceeded. When this occurs, every database crashes at the same time. The solution from EMC is to turn asynchronous I/O off in all of the Oracle instances (disk_async_io = false) and to increase the database writer slaves (dbwr_io_slaves = something not 0) to emulate asynchronous I/O. Has anyone run into this problem before? If so, how did you correct it? My feeling is that EMC is trying to give us a bandage to cover up the real problem, by trying to get Oracle to ignore it. Thank you. -- Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Denny Koovakattu 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: Ang: Re:Import excelfile into Oracle table
Of course you could use Perl with the DBI, DBD::Oracle and Spreadsheet::ParseExcel modules. I've done it, work great. Load directly from the spreadsheet into an Oracle table. Jared On Thursday 18 April 2002 07:28, Koivu, Lisa wrote: Or sql*loader. csv isn't the best choice of file format in my opinion (will any of your fields have commas in them?) but sql*loader will pick up the file and slam it in faster than you can blink an eye. Lisa Koivu Oracle Database Monkey Mama Fairfield Resorts, Inc. 954-935-4117 -Original Message- From: Charlie Mengler [SMTP:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 10:03 AM To: Multiple recipients of list ORACLE-L Subject:Re: Ang: Re:Import excelfile into Oracle table RTFM where the Fine Manual = PL/SQL for Dummies or Teach Yourself PL/SQL in 21 Days [EMAIL PROTECTED] wrote: Ok, thanks can you give me a good example on how to write the pl/sql code? Thanks in advance. Roland [EMAIL PROTECTED]@fatcity.com den 2002-04-18 01:10 PST Sänd svar till [EMAIL PROTECTED] Sänt av: [EMAIL PROTECTED] Till: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Kopia: Hi, You'd better do the following: * Convert the excel file to .csv file. * Use utl_file package to read the data and insert to Oracle Tables. M.Emre HANCIOGLU Masterfoods GmbH -- 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: Charlie Mengler 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: Jared Still 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: Date fields store as varchar2???
Storing dates as varchar2 doesn't sound like a good idea to me, especially in a data warehouse. All date comparisons will require converting to date type. In many cases you probably don't want to stored dates in your data warehouse anyway. They should be in a robust date dimension table. The date component is used to determine the key to the date dimension table at load time. If you want to keep the time component in the DW you will need to determine the granularity required and make it a part of your date dimension for consistency. That could conceivably create a rather large date dimension. Granularity for 10 year date dimension: 1 day: 3652 rows 1 hour: 87,648 rows 1 minute: 525,880 rows 1 second: 315,532,800 rows That last one is a seriously large dimension! A little too big for practicality. 1) Snapshots - if the date in the data WH is going to be refreshed via a snapshot, what will the value be. GMT 2) Export/Import GMT 3) SQLLoader GMT Your DW in EST will not know that these are EST dates. Prior to 9i, Oracle really is not too aware of TZ. I haven't yet explored what 9i will do though in the way of TZ. Hope you aren't querying your DW with 'sysdate'. :) Jared On Friday 19 April 2002 12:28, Celine John wrote: Hello, Our DB has a GMT time zone, while our data warehouse has EST. For our application, some guys here insist that we store dates as varchar2 to avoid all the problems associated with data in the two databases. Though personally I want the dates to be stored in oracle date datatype, I would like to know more about how date fields behave in different processes... like 1) Snapshots - if the date in the data WH is going to be refreshed via a snapshot, what will the value be. 2) Export/Import 3) SQLLoader I depend on this list to give me some expert advice on this. Thanks much. __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still 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: MySQL vs. Oracle database
Um, no, not really. SAPDB is Sybase, pure and simple. Jared On Thursday 18 April 2002 12:21, Gordon, Emery {PDBI~Palo Alto} wrote: There is a new alternative. SAPDB is open source but supported by SAP. Whan used outside of SAP applications it is free but charged when used inside of SAP. The support is from a major software company and the features are much closer to the Oracle feature set. Emery Gordon -Original Message- Sent: Wednesday, April 17, 2002 12:32 PM To: Multiple recipients of list ORACLE-L -- Weaver, Walt [EMAIL PROTECTED] I don't think you're wrong. MySQL gets dissed frequently on this list, but it's really a nice little product. IMHO it's much closer to Oracle than Access. It works well for us. Doesn't scale like Oracle, but works well. In some ways it scales better than Oracle. For load+query (a.k.a., warehouse) operations it can be faster than Oracle because it doesn't get tangled up with rollbacks, etc. On systms with many instances it also can be much simpler to administer. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still 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: Good Article on differences between ORACLE and SQLServer
This is because the paper is comparing Oracle 7 to SQL Server 2000. So it is correct, just out dated. Jared On Friday 19 April 2002 12:58, Igor Neyman wrote: LOL! Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - From: Marin Dimitrov To: Multiple recipients of list ORACLE-L Sent: Friday, April 19, 2002 3:19 PM Subject: Re: Good Article on differences between ORACLE and SQLServer - Original Message - From: Jason Rowski Check the document below which discusses the differences in Oracle and SQL Server databases. http://www.dbresources.com/modules.php?name=Newsfile=articlesid=86 what about: Category Microsoft SQL Server Oracle Blob type storage 16-byte pointer stored with row. Data stored on other data pages One long or long raw per table, must be at end of row, data stored on same block(s) with row surely there are lots of similar pearls 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. Content-Type: text/html; charset=iso-8859-1; name=Attachment: 1 Content-Transfer-Encoding: quoted-printable Content-Description: -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still 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: Number of CPUs vs. Speed of CPUs
Power units are history. You can renew them, but you can't buy more. It's by CPU or named user per server. Jared On Thursday 18 April 2002 14:20, Seefelt, Beth wrote: I'm not positive, but I'm pretty sure you still pay by power units. a 4 x 200Mhz costs the same as a 1 x 800Mhz. I agree to some extent, but fewer and faster should not be a hard and fast rule. There are other things to consider, like how many concurrent cpu intensive processes are running on the system. On a single cpu system, it only takes 1 bad query to hog the entire system, with 2 cpus, they can only suck up 50% of it at most...and can your application benefit from parallelism? -Original Message- Sent: Thursday, April 18, 2002 3:44 PM To: Multiple recipients of list ORACLE-L I may be blowing smoke out my back side but here is my opinion: Fewer and Faster Reasons: I think Oracle has started to license by cpu instead of the power units thing. So if it is cpu number, then fewer and faster is cheaper. Oracle also was and may still be licensing based on maximum box capacity. So if you have 2 machines that are both 4 way (4 cpu's installed), but machine one max'es at a 4 way and the second machine max'es at a 10 way, you pay more for each license on the 10 way than the 4 way even thought the 10 way is using just 4 cpu's. Doesn't make much sense to me but that's how pricing worked last fall. From an OS level, when cpu's are added it's a diminishing return issue. So historically a 4 x 800mhz is faster than a 8 x 400mhz. Brian P. MacLean Oracle DBA, OCP8i YTTRI Lisa lisa.yttri@cn To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] h.com cc: Sent by: Subject: Number of CPUs vs. Speed of CPUs [EMAIL PROTECTED] om 04/18/02 08:58 AM Please respond to ORACLE-L We are in the process of sizing a new server for multiple Oracle instances. What factors are useful as input in determining how many CPUs and the relative speed of them? For example, do we want fewer, faster CPUs or do we want more, slower CPUs? Are there any good guidelines to determine what the number of CPUs should be? Thanks in advance - Lisa -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still 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).
System applying grants
Hi gurus, I created a script to assign some grants automatically to some roles and users. As the user sys, I assigned to user system the GRANT ANY PRIVILIGE, GRANT ANY ROLE, roles and when run the script get the error of insufficient privileges. What I dont want is to connect to each user to apply the grants. How can achieve that ? TIA Ramon -- 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).
LMT bitmap question
Hi all, I'm confuse with Segment Header and Data file header. some said LMT keep the free block information (bitmap) in Segment header and some said Data file header. I have 3 questions 1. where oracle keep LMT bitmap each data file header or each segment header ? 2a. if it is store in data file header can one tell whether is LMT or DMT by view (first line) of the physical file ? 2b. if it is stored in segment header which view of base tables store these information. 3. What is ST enqueue ? Thanks Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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: System applying grants
That won't give SYS the privileges you think it does. For any user, including SYS, to be allowed to grant direct privileges on another users objects, that user must have explicity direct grants with the 'with grant option'. e.g. to allow SYS to grant privileges on the table EMP owned by SCOTT, you must log in as SCOTT and issue this command: GRANT ALL ON EMP TO SYS; The user SYS will now be able to grant privilege on SCOTT.EMP to other users. Jared On Friday 19 April 2002 19:23, [EMAIL PROTECTED] wrote: Hi gurus, I created a script to assign some grants automatically to some roles and users. As the user sys, I assigned to user system the GRANT ANY PRIVILIGE, GRANT ANY ROLE, roles and when run the script get the error of insufficient privileges. What I dont want is to connect to each user to apply the grants. How can achieve that ? TIA Ramon -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still 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).