Re: testing
Send 'help' to [EMAIL PROTECTED] It will contain some info about receiving your own posts. ( I think ) Jared Benny Pei [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 08/19/2003 03:24 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:testing how come I never got email I sent to fatcity oracle list? I sent to [EMAIL PROTECTED] benny __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Benny Pei 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: Testing tools for custom applications developed using 100% Oracle
I think that www.2train4.com have a testing tool. also www.mercury.com have such a tool. Yechiel AdarMehish - Original Message - From: Baswannappa, Shiva To: Multiple recipients of list ORACLE-L Sent: Friday, June 06, 2003 5:30 PM Subject: Testing tools for custom applications developed using 100% Oracle Hi All Gurus My division is pondering over acquiring automated testing tools for applications and customizations made to the existing applications. Development is done using almost 100% oracle tools barring O/S scripts in Unix/W2K, external C/C++ routines and some automation for instruments. I am looking for automated testing tools that support robust oracle development. If you have come across such tools or used them or heard about them, I would appreciate some information on this. Thanks in advance It's been a very fruitful association and have good weekend Regards Shiva Baswannappa Life Sciences Business UnitDigital Consulting Software Services, Inc._ Phone: 281.243.2658Fax: 281.243.2504Web: http://www.dcss.com If the reader of this e-mail is not an intended recipient, you have received this e-mail in error and any review, dissemination, distribution or copying is strictly prohibited. If you have received this e-mail in error, please notify the sender immediately by return e-mail and permanently delete the copy you received. Thank you.
RE: Testing database links
Sorry for the delay in replying; something more urgent popped up. Nope, the x$uganco doesn't show the db_links opened by other sessions. The inst_id field looks like it would be useful only in Parallel Server environments. Any other ideas? I can't believe Oracle doesn't keep track of open database links. There must be some x$ view for this. How to find it out? Thanks regards, Charu. -Original Message- Allan Sent: Monday, February 24, 2003 4:45 PM To: Multiple recipients of list ORACLE-L There is an underlying x$table named x$uganco that contains a column named inst_id which is being filtered in the view_definition for V$DBLINK as found in V$FIXED_VIEW_DEFINITION. Selecting from the x$uganco should do the trick. Mind you there are no rows in there when the links are not active so this may be a real problem for you in terms of capturing all the links. Allan -Original Message- Sent: Monday, February 24, 2003 6:34 AM To: Multiple recipients of list ORACLE-L I think I spoke too soon. The v$dblink view shows the db_links opened by the current session only. I want to be able to find out the db_links opened by all current sessions and the sids for the sessions. This way I can monitor all the application instances that opened the db_link and those that didn't close it. Thanks regards, Charu. -Original Message- Sent: Friday, February 21, 2003 5:19 PM To: '[EMAIL PROTECTED]' Darn!! I had taken a hasty look at 'Oracle 8i reference', before posting the query. Not my day today. Thanks Allan. Regards, Charu -Original Message- Allan Sent: Friday, February 21, 2003 5:04 PM To: Multiple recipients of list ORACLE-L V$dblink -Original Message- Sent: Friday, February 21, 2003 7:04 AM To: Multiple recipients of list ORACLE-L Dear Listers, Oracle 8i HP-UX11. We have a database link with a remote database which is accessed from the application code. In the application code, a call is made to the 'dbms_session.close_database_link' procedure (that is what they claim!!). We want to track the call to the database link and the subsequent closure. We don't have any access to the remote system to check the remote session being created and closed. Is there any way (dynamic performance view etc.) which would show the database link being in use and closed again on the local database itself? Thanks regards, Charu -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Charu Joshi 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 email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nelson, Allan 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). * Disclaimer This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited. * Visit us at http://www.mahindrabt.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Charu Joshi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web
RE: Testing database links
Sorry, no more ideas. Allan -Original Message- Sent: Wednesday, February 26, 2003 6:19 AM To: Multiple recipients of list ORACLE-L Sorry for the delay in replying; something more urgent popped up. Nope, the x$uganco doesn't show the db_links opened by other sessions. The inst_id field looks like it would be useful only in Parallel Server environments. Any other ideas? I can't believe Oracle doesn't keep track of open database links. There must be some x$ view for this. How to find it out? Thanks regards, Charu. -Original Message- Allan Sent: Monday, February 24, 2003 4:45 PM To: Multiple recipients of list ORACLE-L There is an underlying x$table named x$uganco that contains a column named inst_id which is being filtered in the view_definition for V$DBLINK as found in V$FIXED_VIEW_DEFINITION. Selecting from the x$uganco should do the trick. Mind you there are no rows in there when the links are not active so this may be a real problem for you in terms of capturing all the links. Allan -Original Message- Sent: Monday, February 24, 2003 6:34 AM To: Multiple recipients of list ORACLE-L I think I spoke too soon. The v$dblink view shows the db_links opened by the current session only. I want to be able to find out the db_links opened by all current sessions and the sids for the sessions. This way I can monitor all the application instances that opened the db_link and those that didn't close it. Thanks regards, Charu. -Original Message- Sent: Friday, February 21, 2003 5:19 PM To: '[EMAIL PROTECTED]' Darn!! I had taken a hasty look at 'Oracle 8i reference', before posting the query. Not my day today. Thanks Allan. Regards, Charu -Original Message- Allan Sent: Friday, February 21, 2003 5:04 PM To: Multiple recipients of list ORACLE-L V$dblink -Original Message- Sent: Friday, February 21, 2003 7:04 AM To: Multiple recipients of list ORACLE-L Dear Listers, Oracle 8i HP-UX11. We have a database link with a remote database which is accessed from the application code. In the application code, a call is made to the 'dbms_session.close_database_link' procedure (that is what they claim!!). We want to track the call to the database link and the subsequent closure. We don't have any access to the remote system to check the remote session being created and closed. Is there any way (dynamic performance view etc.) which would show the database link being in use and closed again on the local database itself? Thanks regards, Charu -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Charu Joshi 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 email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nelson, Allan 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). * Disclaimer This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited. * Visit us at http://www.mahindrabt.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Charu Joshi INET:
RE: Testing database links
I think I spoke too soon. The v$dblink view shows the db_links opened by the current session only. I want to be able to find out the db_links opened by all current sessions and the sids for the sessions. This way I can monitor all the application instances that opened the db_link and those that didn't close it. Thanks regards, Charu. -Original Message- Sent: Friday, February 21, 2003 5:19 PM To: '[EMAIL PROTECTED]' Darn!! I had taken a hasty look at 'Oracle 8i reference', before posting the query. Not my day today. Thanks Allan. Regards, Charu -Original Message- Allan Sent: Friday, February 21, 2003 5:04 PM To: Multiple recipients of list ORACLE-L V$dblink -Original Message- Sent: Friday, February 21, 2003 7:04 AM To: Multiple recipients of list ORACLE-L Dear Listers, Oracle 8i HP-UX11. We have a database link with a remote database which is accessed from the application code. In the application code, a call is made to the 'dbms_session.close_database_link' procedure (that is what they claim!!). We want to track the call to the database link and the subsequent closure. We don't have any access to the remote system to check the remote session being created and closed. Is there any way (dynamic performance view etc.) which would show the database link being in use and closed again on the local database itself? Thanks regards, Charu -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Charu Joshi 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 email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nelson, Allan 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). * Disclaimer This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited. * Visit us at http://www.mahindrabt.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Charu Joshi 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: Testing database links
There is an underlying x$table named x$uganco that contains a column named inst_id which is being filtered in the view_definition for V$DBLINK as found in V$FIXED_VIEW_DEFINITION. Selecting from the x$uganco should do the trick. Mind you there are no rows in there when the links are not active so this may be a real problem for you in terms of capturing all the links. Allan -Original Message- Sent: Monday, February 24, 2003 6:34 AM To: Multiple recipients of list ORACLE-L I think I spoke too soon. The v$dblink view shows the db_links opened by the current session only. I want to be able to find out the db_links opened by all current sessions and the sids for the sessions. This way I can monitor all the application instances that opened the db_link and those that didn't close it. Thanks regards, Charu. -Original Message- Sent: Friday, February 21, 2003 5:19 PM To: '[EMAIL PROTECTED]' Darn!! I had taken a hasty look at 'Oracle 8i reference', before posting the query. Not my day today. Thanks Allan. Regards, Charu -Original Message- Allan Sent: Friday, February 21, 2003 5:04 PM To: Multiple recipients of list ORACLE-L V$dblink -Original Message- Sent: Friday, February 21, 2003 7:04 AM To: Multiple recipients of list ORACLE-L Dear Listers, Oracle 8i HP-UX11. We have a database link with a remote database which is accessed from the application code. In the application code, a call is made to the 'dbms_session.close_database_link' procedure (that is what they claim!!). We want to track the call to the database link and the subsequent closure. We don't have any access to the remote system to check the remote session being created and closed. Is there any way (dynamic performance view etc.) which would show the database link being in use and closed again on the local database itself? Thanks regards, Charu -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Charu Joshi 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 email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nelson, Allan 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). * Disclaimer This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited. * Visit us at http://www.mahindrabt.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Charu Joshi 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.net -- Author: Nelson,
Re: Testing database links
Charu, The view V$DBLINK can show you if the link is in use. select open_cursors, in_transaction from v$dblonk where db_link = 'mylink' HTH. Arup Nanda - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, February 21, 2003 8:03 AM Dear Listers, Oracle 8i HP-UX11. We have a database link with a remote database which is accessed from the application code. In the application code, a call is made to the 'dbms_session.close_database_link' procedure (that is what they claim!!). We want to track the call to the database link and the subsequent closure. We don't have any access to the remote system to check the remote session being created and closed. Is there any way (dynamic performance view etc.) which would show the database link being in use and closed again on the local database itself? Thanks regards, Charu -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Charu Joshi 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.net -- Author: Arup Nanda 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: Testing database links
V$dblink -Original Message- Sent: Friday, February 21, 2003 7:04 AM To: Multiple recipients of list ORACLE-L Dear Listers, Oracle 8i HP-UX11. We have a database link with a remote database which is accessed from the application code. In the application code, a call is made to the 'dbms_session.close_database_link' procedure (that is what they claim!!). We want to track the call to the database link and the subsequent closure. We don't have any access to the remote system to check the remote session being created and closed. Is there any way (dynamic performance view etc.) which would show the database link being in use and closed again on the local database itself? Thanks regards, Charu -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Charu Joshi 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 email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nelson, Allan 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: Testing database links
Darn!! I had taken a hasty look at 'Oracle 8i reference', before posting the query. Not my day today. Thanks Allan. Regards, Charu -Original Message- Allan Sent: Friday, February 21, 2003 5:04 PM To: Multiple recipients of list ORACLE-L V$dblink -Original Message- Sent: Friday, February 21, 2003 7:04 AM To: Multiple recipients of list ORACLE-L Dear Listers, Oracle 8i HP-UX11. We have a database link with a remote database which is accessed from the application code. In the application code, a call is made to the 'dbms_session.close_database_link' procedure (that is what they claim!!). We want to track the call to the database link and the subsequent closure. We don't have any access to the remote system to check the remote session being created and closed. Is there any way (dynamic performance view etc.) which would show the database link being in use and closed again on the local database itself? Thanks regards, Charu -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Charu Joshi 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 email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nelson, Allan 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). * Disclaimer This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited. * Visit us at http://www.mahindrabt.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Charu Joshi 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: Testing
Title: RE: Testing We regret to inform you that your test has failed, please try again. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- From: Natalia Lorena Laracca [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 21, 2002 8:44 AM To: Multiple recipients of list ORACLE-L Subject: Testing *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1
Re: testing freelists
(20 days later -- occurrences aren't that common) Jared, Ok, I've re-RTFM'd the Concepts manual and have dog eared Steve's book unbelievably. I've used the event 10046 traces while the blocking lock event was going on. The curious thing is that I'm not seeing any buffer busy waits. The blocked process sits there and cranks out an equeue wait trace every 3 seconds and does not report a file, block or row that it is waiting on. If I'm reading Steve's book correctly, I should see file and block but no row if it's an initrans problem, so that's out. In Katz's article in the Feb 2002 elementK Journal he says that if all three are 0 then it's a problem with free space in the block and maybe pctfree is low. The table I'm inserting into has 2k blocks and PCTFREE=30. The insert is only populating 7 of the 185 columns, that's 6 varchar2's and a date. There should be plenty of room, unless as you pointed out that the problem was really not in this table -- possibly in the indexes. This guy does have 15 indexes (all single column, all PCTFREE=10). A curious thing is that when I look at the blocker, he shows that he's blocking on 2 tables, this one that he has a transaction open on, and a journaling table that triggers off the first insert into -- but his rows are only 70 bytes and he has PCTFREE=10 also. So I've got 17 suspects, all with plausible alibis. And I haven't figured out how to get the enqueue wait to squeal on any of them. If I'm understanding the file=0 block=0 row=0 properly, he tried, he couldn't get a block so he waits 3 seconds and tries again indefinately. But when one of these happens, I see a rash of them so something's causing it. I keep returning to free lists. This is an evolved application (he says euphemistically) and it's had a freelist=1 on everything since it slithered out of the slime. Now it's running on a 4 cpu sparc. I'm wondering if the free list is just getting overran and if bumping it to the sometimes advised cpu*2 could clear the problem. I have lingering doubts because I haven't found anything that specifically says what I should be seeing when that happens. So I guess I should try to make this into a question hmmn... Am I barking up the wrong tree? -rje From: [EMAIL PROTECTED] [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Tuesday, February 05, 2002, 10:36:27 AM Subject: testing freelists ===8==Original message text=== Robert, Simulating the problem and proving the correction is an excellent idea. One thing to consider when putting together your testing scenario is that writes to the database block by a transaction are done in memory, that is they are made to the cached database blocks. An internal locking mechanism ( a latch ) is used to control access to the cache, and it is normally held for only a short time. The data may be written to the disk before a commit, and it may not be written to disk until after a commit. ( referring to datafiles only here, not the redo log ). The 60 second sleep in your script is only simulating user think time, it's not actually blocking anything. You will need to similate several session simultaneously inserting, and you will need to know if the contention is in the table or in an index: I'm guessing it's an index or indexes. Some time spent with the Concepts manual would help you out here. Here's an excerpt from the section on database writer: Database Writer (DBWn) The database writer writes modified blocks from the database buffer cache to the datafiles. Although one database writer process (DBW0) is sufficient for most systems, you can configure additional processes (DBW1 through DBW9) to improve write performance for a system that modifies data heavily. The initialization parameter DB_WRITER_PROCESSES specifies the number of DBWn processes. Since Oracle uses write-ahead logging, DBWn does not need to write blocks when a transaction commits. Instead, DBWn is designed to perform batched writes with high efficiency. In the most common case, DBWn writes only when more data needs to be read into the system global area and too few database buffers are free. The least recently used data is written to the datafiles first. DBWn also performs writes for other functions such as checkpointing. Take a look at Chapter 15 on Transactions as well. Also check out Steve Adams' web site, www.ixora.com.au. Lots of interesting stuff there if you want to learn about the internals. Here's an excerpt from the section on Free lists: As mentioned previously, free list contention occurs when multiple processes using the same free list attempt to modify the data block on the head of the free list concurrently. It is shown in V$WAITSTAT against the data block class. V$WAITSTAT can also show contention for the segment header and free list blocks. This occurs where multiple transaction in the same free
Re: testing freelists
See my comments in the text: Robert Eskridge wrote: (20 days later -- occurrences aren't that common) Jared, Ok, I've re-RTFM'd the Concepts manual and have dog eared Steve's book unbelievably. I've used the event 10046 traces while the blocking lock event was going on. The curious thing is that I'm not seeing any buffer busy waits. The blocked process sits there and cranks out an equeue wait trace every 3 seconds and does not report a file, block or row that it is waiting on. If I'm reading Steve's book correctly, I should see file and block but no row if it's an initrans problem, so that's out. I am assuming that the mode for the TX enqueue is 4. Right ? In Katz's article in the Feb 2002 elementK Journal he says that if all three are 0 then it's a problem with free space in the block and maybe pctfree is low. The table I'm inserting into has 2k blocks and PCTFREE=30. The insert is only populating 7 of the 185 columns, that's 6 varchar2's and a date. There should be plenty of room, unless as you pointed out that the problem was really not in this table -- possibly in the indexes. This guy does have 15 indexes (all single column, all PCTFREE=10). A curious thing is that when I look at the blocker, he shows that he's blocking on 2 tables, this one that he has a transaction open on, and a journaling table that triggers off the first insert into -- but his rows are only 70 bytes and he has PCTFREE=10 also. Are the indexes UNIQUE ? If yes, what is the chance of people inserting into with the same value ? Are the indexes BITMAP ? So I've got 17 suspects, all with plausible alibis. And I haven't figured out how to get the enqueue wait to squeal on any of them. If I'm understanding the file=0 block=0 row=0 properly, he tried, he couldn't get a block so he waits 3 seconds and tries again indefinately. But when one of these happens, I see a rash of them so something's causing it. Forget about the file, block, row values. They don't mean a thing if you are not waiting on TX mode 6. I keep returning to free lists. This is an evolved application (he says euphemistically) and it's had a freelist=1 on everything since it slithered out of the slime. Now it's running on a 4 cpu sparc. I'm wondering if the free list is just getting overran and if bumping it to the sometimes advised cpu*2 could clear the problem. I have lingering doubts because I haven't found anything that specifically says what I should be seeing when that happens. The only freelist problem that you could have is transaction freelists. But you are doing inserts so that is not the case here. So I guess I should try to make this into a question hmmn... Am I barking up the wrong tree? The right tree, but the tree doesn't understand barking ;-) Anjo. -rje From: [EMAIL PROTECTED] [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Tuesday, February 05, 2002, 10:36:27 AM Subject: testing freelists ===8==Original message text=== Robert, Simulating the problem and proving the correction is an excellent idea. One thing to consider when putting together your testing scenario is that writes to the database block by a transaction are done in memory, that is they are made to the cached database blocks. An internal locking mechanism ( a latch ) is used to control access to the cache, and it is normally held for only a short time. The data may be written to the disk before a commit, and it may not be written to disk until after a commit. ( referring to datafiles only here, not the redo log ). The 60 second sleep in your script is only simulating user think time, it's not actually blocking anything. You will need to similate several session simultaneously inserting, and you will need to know if the contention is in the table or in an index: I'm guessing it's an index or indexes. Some time spent with the Concepts manual would help you out here. Here's an excerpt from the section on database writer: Database Writer (DBWn) The database writer writes modified blocks from the database buffer cache to the datafiles. Although one database writer process (DBW0) is sufficient for most systems, you can configure additional processes (DBW1 through DBW9) to improve write performance for a system that modifies data heavily. The initialization parameter DB_WRITER_PROCESSES specifies the number of DBWn processes. Since Oracle uses write-ahead logging, DBWn does not need to write blocks when a transaction commits. Instead, DBWn is designed to perform batched writes with high efficiency. In the most common case, DBWn writes only when more data needs to be read into the system global area and too few database buffers are free. The least recently used data is written to the datafiles first. DBWn also performs writes for other functions such as checkpointing.
Re: testing freelists
Robert,
Simulating the problem and proving the correction is an excellent idea.
One thing to consider when putting together your testing scenario is
that writes to the database block by a transaction are done in memory,
that is they are made to the cached database blocks.
An internal locking mechanism ( a latch ) is used to control access to
the cache, and it is normally held for only a short time.
The data may be written to the disk before a commit, and it may not
be written to disk until after a commit. ( referring to datafiles only
here, not the redo log ).
The 60 second sleep in your script is only simulating user think time,
it's not actually blocking anything. You will need to similate several
session simultaneously inserting, and you will need to know if the
contention
is in the table or in an index: I'm guessing it's an index or indexes.
Some time spent with the Concepts manual would help you out here.
Here's an excerpt from the section on database writer:
Database Writer (DBWn)
The database writer writes modified blocks from the database buffer
cache to the datafiles. Although one database writer process (DBW0)
is sufficient for most systems, you can configure additional processes
(DBW1 through DBW9) to improve write performance for a system that
modifies data heavily. The initialization parameter DB_WRITER_PROCESSES
specifies the number of DBWn processes.
Since Oracle uses write-ahead logging, DBWn does not need to write
blocks when a transaction commits. Instead, DBWn is designed to perform
batched
writes with high efficiency. In the most common case, DBWn writes only
when more
data needs to be read into the system global area and too few database
buffers are free. The least recently used data is written to the datafiles
first. DBWn
also performs writes for other functions such as checkpointing.
Take a look at Chapter 15 on Transactions as well.
Also check out Steve Adams' web site, www.ixora.com.au. Lots of
interesting stuff
there if you want to learn about the internals. Here's an excerpt from
the section
on Free lists:
As mentioned previously, free list contention occurs when multiple
processes using the same free list attempt to modify the data block on the
head of the free list concurrently. It is shown in V$WAITSTAT against the data block
class. V$WAITSTAT can also show contention for the segment header and free list
blocks. This occurs where multiple transaction in the same free list
group need to update their free list header records simultaneously. There
are various ways of addressing these problems such as rebuilding the table
with more free list groups, or increasing _bump_highwater_mark_count, or the novel
idea of fixing the application.
To drill down on which segments are causing data block contention, I suggested using
event 10046, level 8. This creates a trace
file much like to one produced by the sql_trace facility, except that for each event
wait a line is printed to the trace
file. In particular, each buffer busy wait is recorded together with the
P1 and P2 values which are the data file and block number of the wait. So
to find which blocks a process has been waiting on, you just grep the trace file for
buffer busy waits lines and produce a histogram of the file and block numbers most
commonly
waited for. Once you have suspect file and block numbers, you can relate
them to a segment by querying DBA_EXTENTS. In the case of free list
contention on a table it is common to have several hot blocks just below
the high water mark for the segment.
If you really want to learn the internals, his book is excellent for that.
It's not normally necessary
IMO to delve that deep into the internals to deal with tuning problems, at
least in my experience.
It will certainly help you develop insight and intuition as to what is
going on with your database though.
HTH
Jared
Robert Eskridge [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
02/04/02 08:15 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:testing freelists
I've got a database that I'm experiencing blocking locks on insert
statements into the largest, most active transaction table. The
freelists currently=1 and it's on a 4 CPU Sparc under 8.0.5 in a 24/7
environment.
I think this points to freelists needing to be increased. The powers
that be want a guarantee before they give me a maintenance window so I
can go through the rebuild on this table to change the freelists.
(We've got an 8.1.7 conversion project going but this can't wait.)
So I'm trying to put together a test set to prove that the freelist
increase will help. What I've been trying has two parts. A simple
sql script like:
$cat blocktest.sql
insert into block_test values
('
Re: Testing
I think that many of the more vocal members are busy playing, uh I mean *working* at OOW. Jared Sherman, Edward To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] shermanej@ecc cc: ic.com Subject: Testing Sent by: [EMAIL PROTECTED] om 12/06/01 10:29 AM Please respond to ORACLE-L It's vewy vewy quiyet. * * * * * Freedom of Information Act Notice * * * * * The information in this email is subject to the record protection mandated by 5 United States Code 552(b)(4) and relevant judicial opinions. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Edward INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: testing RMAN == 2 databases in 1 Machine
No, I backup databases on 3 machines using rman. Our recovery catalog database is on our production machine and I backup my production databases on that machine. Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 3:20 AM Dear Listers , I want to try using RMAN in just 1 machine with 2 databases ( client and target ) . I have followed every single step in manual , but there's always error ... Do we must run RMAN in 2 machines ? Thank a lot in advance : ) =bambang= Bambang Setiawan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bambang Setiawan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
