RE: how to see errors when precompiling proc program
In your script file, put: SHOW ERRORS after the procedure text. -Original Message- Sent: 20 March 2003 06:49 To: Multiple recipients of list ORACLE-L This is a multi-part message in MIME format. --=002_Dragon236182704230_= Content-Type: text/plain; charset=GB2312 Content-Transfer-Encoding: quoted-printable My oracle using version is 8.0.0.5. Now , I'm programming proc . When I precompile them and fail. But I can=A1=AFt see what happened= .and where the errors are. So I look carefully for errors in large file. Is there some way to show where the error is .and what the error= is . Can you give me your hand . Thanks in advance! --=002_Dragon236182704230_= Content-Type: text/html; charset=GB2312 Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEAD META http-equiv=3DContent-Type content=3Dtext/html;= charset=3Dgb2312 META content=3DMSHTML 6.00.2600.0 name=3DGENERATOR/HEAD BODY bgColor=3D#eaeaea P class=3DMsoNormal style=3DTEXT-ALIGN: left;= mso-layout-grid-align: none align=3DleftFONT face=3DArial size=3D1SPAN lang=3DEN-US style=3DFONT-SIZE: 9pt; FONT-FAMILY: Arial; mso-font-kerning:= 0ptMy oracle using version is 8.0.0.5.?xml:namespace prefix =3D o ns =3D urn:schemas-microsoft-com:office:office= /o:p/o:p/SPAN/FONT/P P class=3DMsoNormal style=3DTEXT-ALIGN: left;= mso-layout-grid-align: none align=3DleftSPAN class=3DGramEFONT face=3DArial size=3D1SPAN= lang=3DEN-US style=3DFONT-SIZE: 9pt; FONT-FAMILY: Arial; mso-font-kerning:= 0ptNow ,/SPAN/FONT/SPANFONT face=3DArial size=3D1SPAN lang=3DEN-US style=3DFONT-SIZE: 9pt; FONT-FAMILY: Arial; mso-font-kerning:= 0pt I'm programming proc .o:p/o:p/SPAN/FONT/P P class=3DMsoNormal style=3DTEXT-ALIGN: left;= mso-layout-grid-align: none align=3DleftFONT face=3DArial size=3D1SPAN lang=3DEN-US style=3DFONT-SIZE: 9pt; FONT-FAMILY: Arial; mso-font-kerning:= 0ptWhen I SPAN class=3DSpellEprecompile/SPAN SPAN class=3DGramEthemSPAN style=3Dmso-spacerun: yesnbsp; /SPANand/SPAN fail. But I= can=A1=AFt see what happened .and where the errors are.o:p/o:p/SPAN/FONT/P P class=3DMsoNormal style=3DTEXT-ALIGN: left;= mso-layout-grid-align: none align=3DleftFONT face=3DArial size=3D1SPAN lang=3DEN-US style=3DFONT-SIZE: 9pt; FONT-FAMILY: Arial; mso-font-kerning:= 0ptSo I look SPAN class=3DGramEcarefullySPAN style=3Dmso-spacerun: yesnbsp;= /SPANfor/SPAN errors in large= file.o:p/o:p/SPAN/FONT/P P class=3DMsoNormal style=3DTEXT-ALIGN: left;= mso-layout-grid-align: none align=3DleftFONT face=3DArial size=3D1SPAN lang=3DEN-US style=3DFONT-SIZE: 9pt; FONT-FAMILY: Arial; mso-font-kerning:= 0ptIs there some way to show where the error is .and what the error SPAN= class=3DGramEis ./SPANo:p/o:p/SPAN/FONT/P P class=3DMsoNormal style=3DTEXT-ALIGN: left;= mso-layout-grid-align: none align=3DleftFONT face=3DArial size=3D1SPAN lang=3DEN-US style=3DFONT-SIZE: 9pt; FONT-FAMILY: Arial; mso-font-kerning:= 0ptCan you give me your SPAN class=3DGramEhand= ./SPANo:p/o:p/SPAN/FONT/P P class=3DMsoNormal style=3DTEXT-ALIGN: left;= mso-layout-grid-align: none align=3DleftFONT face=3DArial size=3D1SPAN lang=3DEN-US style=3DFONT-SIZE: 9pt; FONT-FAMILY: Arial; mso-font-kerning:= 0ptThanks in advance!o:p/o:p/SPAN/FONT/P/BODY/HTML --=002_Dragon236182704230_=-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?GB2312?Q?=C1=F5=BC=CC=B6=AB?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). --- This e-mail and any attachment is for authorised use by the intended recipient(s) only. It may contain proprietary material, confidential information and/or be subject to legal privilege. It should not be copied, disclosed to, retained or used by, any other party. If you are not an intended recipient then please promptly delete this e-mail and any attachment and all copies and inform the sender. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Virk, Istifad INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name
RE: How to see it?
You're right... How can I see it? -Original Message-From: hukangang [mailto:[EMAIL PROTECTED]]Sent: Friday, October 11, 2002 3:38 AMTo: Multiple recipients of list ORACLE-LSubject: How to see it?
Re: How to see it?
me too :-) Igor Neyman, OCP DBA[EMAIL PROTECTED] - Original Message - From: Johnston, Tim To: Multiple recipients of list ORACLE-L Sent: Friday, October 11, 2002 11:44 AM Subject: RE: How to see it? You're right... How can I see it? -Original Message-From: hukangang [mailto:[EMAIL PROTECTED]]Sent: Friday, October 11, 2002 3:38 AMTo: Multiple recipients of list ORACLE-LSubject: How to see it?
RE: How to see it?
he used white text on a white background -Original Message-From: Johnston, Tim [mailto:[EMAIL PROTECTED]]Sent: Friday, October 11, 2002 11:45 AMTo: Multiple recipients of list ORACLE-LSubject: RE: How to see it? You're right... How can I see it? -Original Message-From: hukangang [mailto:[EMAIL PROTECTED]]Sent: Friday, October 11, 2002 3:38 AMTo: Multiple recipients of list ORACLE-LSubject: How to see it?
Re: How to see it?
The light? The light at the end of the tunnel? The forest for the trees? The ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to see it?
You must have faith grasshopper... the substance of things hoped for, the evidence of things not seen. -Original Message- Sent: Friday, October 11, 2002 3:49 PM To: Multiple recipients of list ORACLE-L Importance: High The light? The light at the end of the tunnel? The forest for the trees? The ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to see howmany transactions commit per minute?
Transactions committing per minute... isn't that redundant? :-) Statspack report will tell you. Also, v$sysstat will help you, ya just need to query it at time point 0 and time point 1 and diff the result. Each user commit would essentially be one transaction. RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) Oracle9i New Features (Oracle Press) Mastering Oracle8i (Sybex) The avalanche has begun, It is too late for the pebbles to vote. -Original Message- Sent: Thursday, July 25, 2002 1:09 PM To: Multiple recipients of list ORACLE-L Hi Gurus, Greetings. How to see howmany transactions commit per minute? v$sysstat does not help me. Thanks, Jonny _ http://uk.yahoo.com/mail/tagline_xtra/?http://uk.docs.yahoo.com/mail_storag e.html Get a bigger mailbox -- choose a size that fits your needs. http://uk.yahoo.com/mail/tagline_xtra/?http://uk.docs.yahoo.com/mail_storag e.html http://uk.docs.yahoo.com/mail_storage.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How to see howmany transactions commit per min?
Answer: All of them, otherwise they would not be transactions :-) Anyway, humour aside, check out the 'user commits' statistic in v$sysstat hth connor --- Jonny Delmont [EMAIL PROTECTED] wrote: Hi Gurus, Greetings. How to see howmany transactions commit per minute? Thanks, Jonny - Get a bigger mailbox -- choose a size that fits your needs. http://uk.docs.yahoo.com/mail_storage.html = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net Remember amateurs built the ark - Professionals built the Titanic __ 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: How to see howmany transactions commit per min?
Check the 'user commits' in V$SYSSTAT... John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Want to know about a carpenter who built a bridge with two sticks and three nails? Write me for details! ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- Sent: Thursday, July 25, 2002 9:19 AM To: Multiple recipients of list ORACLE-L Hi Gurus, Greetings. How to see howmany transactions commit per minute? Thanks, Jonny _ http://uk.yahoo.com/mail/tagline_xtra/?http://uk.docs.yahoo.com/mail_storag e.html Get a bigger mailbox -- choose a size that fits your needs. http://uk.yahoo.com/mail/tagline_xtra/?http://uk.docs.yahoo.com/mail_storag e.html http://uk.docs.yahoo.com/mail_storage.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to see howmany transactions commit per minute?
Hi Jesse,
That's great! I really enjoyed it ;-)) Thanks for this code and thanks who replied.
Jonny
"Jesse, Rich" [EMAIL PROTECTED] wrote:
Before I installed STATSPACK, I had a dbms_job run this every five minutes(in fact it still runs):DECLAREv_tx_count NUMBER;BEGINSELECT SUM(VALUE) INTO v_tx_countFROM V$SYSSTATWHERE NAME IN ('user commits','user rollbacks');INSERT INTO MY_TRANSACTION_LOG(TX_COUNT, TIMESTAMP)VALUES (v_tx_count, SYSDATE);COMMIT;END;It runs subsecond and puts no discernable load on my system, AFAIK. Toquery, I wrote a l'il webpage that makes this call:SELECT TIMESTAMP, TPMFROM(SELECT TO_CHAR(TIMESTAMP,'MM/DD/ HH24:MI') TIMESTAMP,TO_CHAR(TX_COUNT - LAG(TX_COUNT) OVER (ORDER BY TIMESTAMP)) TPMFROM SYSTEM.QT_TRANSACTION_LOGWHERE TIMESTAMP = TO_DATE('start_timestamp','MM/DD/:HH24:MI')AND TIMESTAMP =TO_DATE('end_timestamp','MM/DD/:HH24:MI'))WHERE TPM IS NOT NULLORD!
!
ER BY 1;Because of the LAG function, it's 8i-and-up-only (as an aside, I just lookedat this and the final "ORDER BY" probably isn't needed because of LAG). Anddon't forget to divide by the number of minutes between samples to get the"PM" in "TPM".I also dump the output into GNUPLOT for output on the webpage, but thatpart's optional. ;) It's great for seeing those huge spikes in the middleof the night where someone coded a COMMIT after every one of 50K INSERTS...HTH! Enjoy! :)Rich Jesse System/Database Administrator[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Freeman, Robert [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 25, 2002 1:04 PM To: Multiple recipients of list ORACLE-L Subject: RE: How to see howmany transactions commit per minute? Transactions committing per minute... isn't that redundan!
!
t? :-) Statspack report will tell you. Also, v$sysstat will help you, ya just need to query it at time point 0 and time point 1 and diff the result. Each user commit would essentially be one transaction. RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) Oracle9i New Features (Oracle Press) Mastering Oracle8i (Sybex) The avalanche has begun, It is too late for the pebbles to vote.-Original Message- Sent: Thursday, July 25, 2002 1:09 PM To: Multiple recipients of list ORACLE-LHi Gurus, Greetings. How to see howmany transactions commit per minute? v$sysstat does not help me. <B!
!
R> Thanks, Jonny-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Jesse, RichINET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).Get a bigger mailbox -- choose a size that fits your needs.http://uk.docs.yahoo.com/mail_storage.html
Re: How to see howmany transactions commit per min?
Unless you code it into your application, you can't. Oracle only knows about 'commit'. This may technically end a transaction, but does not necessarily delinieate a business transaction. It's up to the app developers to deal with that. Some 3rd party software such as SAP will track that kind of information. Jared Jonny Delmont [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/25/2002 09:18 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:How to see howmany transactions commit per min? Hi Gurus, Greetings. How to see howmany transactions commit per minute? Thanks, Jonny Get a bigger mailbox -- choose a size that fits your needs. http://uk.docs.yahoo.com/mail_storage.html -- 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).
