RE: Problem with archive log when testing recovery..., urgent
Well, I think I forget the alter system switch logfile before shutdown and after restart. I'll try that n let you all know the result. Regards, Wendry. -Original Message- Sent: Tuesday, January 13, 2004 6:07 PM To: Wendry Nothing major amiss there, that is exactly what I do. However, remember to do an alter system switch logfile, before shutting the DB, then backup, restart, alter system switch logfile, and take all the logfiles upto and including that created on the second logfile switch. I'd suspect that not switching before shutting down may be the cause, but I'm working on the logic as to why. Let me know how it goes. Cheers GJC The fifty dwarves were reduced to eight, before anyone suspected hungry. __ Gary Colbran System/Database Administrator Telkom SA 55 Oak Avenue Centurian South Africa Ph: 012-680 1315. Ph: 082-786 6592. [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] **Disclaimer** ** Information contained in this E-MAIL being proprietary to Telkom SA and is 'privileged' and 'confidential' and intended for use only by the individual or entity to which it is addressed. You are notified that any use, copying or dissemination of the information contained in the E-MAIL in any manner whatsoever is strictly prohibited. ** * -Original Message- Sent: 12 January 2004 16:09 To: Gary Colbran (GJ); Multiple recipients of list ORACLE-L Thank you for your reply, Yes, you're quite right, I think the archive next to the cold backup is corrupted. The hot backup is always succeeded. But I wonder why is my cold backup is largely end up with internal error or corrupted archive log files. All I do for closed backup is shutdown immediate, copy all controlfiles, datafiles and redo log files to backup destination, and then reopen the database. Is there any steps that I left which cause the archive log to be corrupted? Thank you in advance. Regards, Wendry. -Original Message- Sent: Monday, January 12, 2004 12:36 PM To: Wendry In which order did you perform the backups ? Say you do the cold backup, and the next archive is corrupted. You then do a hot backup. Restore the cold backup and the archive needs to be applied. Restore the hot backup, and it is after the corrupted archive. Does the corruption occur with an archive used by the cold backup, but not the hot backup ? Cheers GJC The fifty dwarves were reduced to eight, before anyone suspected hungry. __ Gary Colbran System/Database Administrator Telkom SA 55 Oak Avenue Centurian South Africa Ph: 012-680 1315. Ph: 082-786 6592. [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] **Disclaimer** ** Information contained in this E-MAIL being proprietary to Telkom SA and is 'privileged' and 'confidential' and intended for use only by the individual or entity to which it is addressed. You are notified that any use, copying or dissemination of the information contained in the E-MAIL in any manner whatsoever is strictly prohibited. ** * -Original Message- Sent: 16 January 2004 03:16 To: LazyDBA.com Discussion Hi all, I have done closed and open backup on my database. Later on I try to test my backup. So I try the closed backup that I've taken. The backup database can be opened succesfully. But when I try to recover database using backup controlfile, the archive logs giving me internal error (sometimes after applying 1st to 5th archive log), sometimes it gave me notification that the archive logs is corrupted. Strangely when I test my open backup, and recover it using the same set of archive logs, the process went smoothly. So what is the real problem here, I really don't have any idea. Is there somebody have the same experience? Now I'm in doubt of planning my backup schedule, please help... Thanks a lot. Regards, Wendry. Get today's cartoon: http://www.LazyDBA.com Please don't reply to RTFM questions Oracle documentation is here: http://tahiti.oracle.com To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] By using this list you agree to these terms:http://www.lazydba.com/legal.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wendry 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
RE: Problem with archive log when testing recovery..., urgent
Thank you for your reply, Yes, you're quite right, I think the archive next to the cold backup is corrupted. The hot backup is always succeeded. But I wonder why is my cold backup is largely end up with internal error or corrupted archive log files. All I do for closed backup is shutdown immediate, copy all controlfiles, datafiles and redo log files to backup destination, and then reopen the database. Is there any steps that I left which cause the archive log to be corrupted? Thank you in advance. Regards, Wendry. -Original Message- Sent: Monday, January 12, 2004 12:36 PM To: Wendry In which order did you perform the backups ? Say you do the cold backup, and the next archive is corrupted. You then do a hot backup. Restore the cold backup and the archive needs to be applied. Restore the hot backup, and it is after the corrupted archive. Does the corruption occur with an archive used by the cold backup, but not the hot backup ? Cheers GJC The fifty dwarves were reduced to eight, before anyone suspected hungry. __ Gary Colbran System/Database Administrator Telkom SA 55 Oak Avenue Centurian South Africa Ph: 012-680 1315. Ph: 082-786 6592. [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] **Disclaimer** ** Information contained in this E-MAIL being proprietary to Telkom SA and is 'privileged' and 'confidential' and intended for use only by the individual or entity to which it is addressed. You are notified that any use, copying or dissemination of the information contained in the E-MAIL in any manner whatsoever is strictly prohibited. ** * -Original Message- Sent: 16 January 2004 03:16 To: LazyDBA.com Discussion Hi all, I have done closed and open backup on my database. Later on I try to test my backup. So I try the closed backup that I've taken. The backup database can be opened succesfully. But when I try to recover database using backup controlfile, the archive logs giving me internal error (sometimes after applying 1st to 5th archive log), sometimes it gave me notification that the archive logs is corrupted. Strangely when I test my open backup, and recover it using the same set of archive logs, the process went smoothly. So what is the real problem here, I really don't have any idea. Is there somebody have the same experience? Now I'm in doubt of planning my backup schedule, please help... Thanks a lot. Regards, Wendry. Get today's cartoon: http://www.LazyDBA.com Please don't reply to RTFM questions Oracle documentation is here: http://tahiti.oracle.com To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] By using this list you agree to these terms:http://www.lazydba.com/legal.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wendry 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: Problem with archive log when testing recovery..., urgent
Are you certain that SHUTDOWN IMMEDIATE succeeded? There are lots of bugs in MetaLink where it hangs or fails with ORA-00600... on 1/12/04 7:04 AM, Wendry at [EMAIL PROTECTED] wrote: Thank you for your reply, Yes, you're quite right, I think the archive next to the cold backup is corrupted. The hot backup is always succeeded. But I wonder why is my cold backup is largely end up with internal error or corrupted archive log files. All I do for closed backup is shutdown immediate, copy all controlfiles, datafiles and redo log files to backup destination, and then reopen the database. Is there any steps that I left which cause the archive log to be corrupted? Thank you in advance. Regards, Wendry. -Original Message- Sent: Monday, January 12, 2004 12:36 PM To: Wendry In which order did you perform the backups ? Say you do the cold backup, and the next archive is corrupted. You then do a hot backup. Restore the cold backup and the archive needs to be applied. Restore the hot backup, and it is after the corrupted archive. Does the corruption occur with an archive used by the cold backup, but not the hot backup ? Cheers GJC The fifty dwarves were reduced to eight, before anyone suspected hungry. __ Gary Colbran System/Database Administrator Telkom SA 55 Oak Avenue Centurian South Africa Ph: 012-680 1315. Ph: 082-786 6592. [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] **Disclaimer** ** Information contained in this E-MAIL being proprietary to Telkom SA and is 'privileged' and 'confidential' and intended for use only by the individual or entity to which it is addressed. You are notified that any use, copying or dissemination of the information contained in the E-MAIL in any manner whatsoever is strictly prohibited. ** * -Original Message- Sent: 16 January 2004 03:16 To: LazyDBA.com Discussion Hi all, I have done closed and open backup on my database. Later on I try to test my backup. So I try the closed backup that I've taken. The backup database can be opened succesfully. But when I try to recover database using backup controlfile, the archive logs giving me internal error (sometimes after applying 1st to 5th archive log), sometimes it gave me notification that the archive logs is corrupted. Strangely when I test my open backup, and recover it using the same set of archive logs, the process went smoothly. So what is the real problem here, I really don't have any idea. Is there somebody have the same experience? Now I'm in doubt of planning my backup schedule, please help... Thanks a lot. Regards, Wendry. Get today's cartoon: http://www.LazyDBA.com Please don't reply to RTFM questions Oracle documentation is here: http://tahiti.oracle.com To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] By using this list you agree to these terms:http://www.lazydba.com/legal.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman 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: stress testing
Jared, Are you talking about yapppack? I've been using that for a while (nice display. Though like statspack it is system wide so I usually just look for high level stuff and changes). Not aware of a patch though. With most peoplesoft applications I have seen, the bottlenecks aren't database related, though I still need to get all appropriate data. That means application server, OS (NTfor app server, Sun for Oracle), web server,... stuff too. I'm still trying to find what numbers the tool itself gathers, and if/how it analyzes the stuff. In the meantime, I've been reviewing some of the papers on orapub (i.e. Ratio Modeling, Predicting Computing System Capacity and Throughput). Thanks. Henry -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of [EMAIL PROTECTED]Sent: Friday, January 02, 2004 2:19 PMTo: Multiple recipients of list ORACLE-LSubject: Re: stress testingAs the ultimate indicator of performance is response time, you might like to investigate YAPP at http://www.miracleas.dk/. The data generated gives a good indicator of response time from a database perspective. If you use it, ask me for the patch. Jared "Poras, Henry R." [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/02/2004 10:54 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:stress testingWe are planning on running some stress tests on a PeopleSoft/Oracle/Solarissystem starting next week (using LoadRunner). I have never gone through aformalized stress test before (most of my stress is brought about informally).So far I am planning to gather statspack information, and periodically getvmstat from the OS. Is there anything else that I should collect? Thanks for thehelp.Henry-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Poras, Henry R.INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-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: stress testing
John, Thanks for the tip. I've used sar and vmstat, but not in enough depth to have any preferences. So far I don't have permissions for sar at this site, but I should be able to get that. Henry -Original Message- John Kanagaraj Sent: Friday, January 02, 2004 2:29 PM To: Multiple recipients of list ORACLE-L Henry, Sar is a better tool than vmstat/iostat as it collects a broad range of information. Specifically, sar -q should show up CPU queueing and swapping, and sar -v will show up file/process table overflow issues that may occur during stress testing. IMHO, sar is quite underutilized ( had a paper on this last IOUG, but couldn't go and present it :( John Kanagaraj DB Soft Inc Phone: 408-970-7002 (W) Grace - Getting something we do NOT deserve Mercy - NOT getting something we DO deserve Click on 'http://www.needhim.org' for Grace and Mercy that is freely available! ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** -Original Message- From: Poras, Henry R. [mailto:[EMAIL PROTECTED] Sent: Friday, January 02, 2004 10:54 AM To: Multiple recipients of list ORACLE-L Subject: stress testing We are planning on running some stress tests on a PeopleSoft/Oracle/Solaris system starting next week (using LoadRunner). I have never gone through a formalized stress test before (most of my stress is brought about informally). So far I am planning to gather statspack information, and periodically get vmstat from the OS. Is there anything else that I should collect? Thanks for the help. Henry -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Poras, Henry R. 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: John Kanagaraj 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: Poras, Henry R. 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: stress testing
The patch I refer to is one I made that didn't make it into the most recent version of yapppack. YP uses an array as internal storage, and walks through it with a for i in 1..n loop. Since arrays are sparsely populated there is a fair chance of hitting an array element that does not exist. The patch consists of rewriting the loop with array.first/next/last in a while loop to avoid the problem. Yes, it is high level, but it can pinpoint time periods that you may want to investigate. Jared On Mon, 2004-01-05 at 06:19, Poras, Henry R. wrote: Jared, Are you talking about yapppack? I've been using that for a while (nice display. Though like statspack it is system wide so I usually just look for high level stuff and changes). Not aware of a patch though. With most peoplesoft applications I have seen, the bottlenecks aren't database related, though I still need to get all appropriate data. That means application server, OS (NT for app server, Sun for Oracle), web server, ... stuff too. I'm still trying to find what numbers the tool itself gathers, and if/how it analyzes the stuff. In the meantime, I've been reviewing some of the papers on orapub (i.e. Ratio Modeling, Predicting Computing System Capacity and Throughput). Thanks. Henry -Original Message- [EMAIL PROTECTED] Sent: Friday, January 02, 2004 2:19 PM To: Multiple recipients of list ORACLE-L As the ultimate indicator of performance is response time, you might like to investigate YAPP at http://www.miracleas.dk/. The data generated gives a good indicator of response time from a database perspective. If you use it, ask me for the patch. Jared Poras, Henry R. [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/02/2004 10:54 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:stress testing We are planning on running some stress tests on a PeopleSoft/Oracle/Solaris system starting next week (using LoadRunner). I have never gone through a formalized stress test before (most of my stress is brought about informally). So far I am planning to gather statspack information, and periodically get vmstat from the OS. Is there anything else that I should collect? Thanks for the help. Henry -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Poras, Henry R. 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: Jared Still 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: stress testing
Good catch on the array. I never noticed that. Henry -Original Message- Jared Still Sent: Monday, January 05, 2004 10:59 AM To: Multiple recipients of list ORACLE-L The patch I refer to is one I made that didn't make it into the most recent version of yapppack. YP uses an array as internal storage, and walks through it with a for i in 1..n loop. Since arrays are sparsely populated there is a fair chance of hitting an array element that does not exist. The patch consists of rewriting the loop with array.first/next/last in a while loop to avoid the problem. Yes, it is high level, but it can pinpoint time periods that you may want to investigate. Jared On Mon, 2004-01-05 at 06:19, Poras, Henry R. wrote: Jared, Are you talking about yapppack? I've been using that for a while (nice display. Though like statspack it is system wide so I usually just look for high level stuff and changes). Not aware of a patch though. With most peoplesoft applications I have seen, the bottlenecks aren't database related, though I still need to get all appropriate data. That means application server, OS (NT for app server, Sun for Oracle), web server, ... stuff too. I'm still trying to find what numbers the tool itself gathers, and if/how it analyzes the stuff. In the meantime, I've been reviewing some of the papers on orapub (i.e. Ratio Modeling, Predicting Computing System Capacity and Throughput). Thanks. Henry -Original Message- [EMAIL PROTECTED] Sent: Friday, January 02, 2004 2:19 PM To: Multiple recipients of list ORACLE-L As the ultimate indicator of performance is response time, you might like to investigate YAPP at http://www.miracleas.dk/. The data generated gives a good indicator of response time from a database perspective. If you use it, ask me for the patch. Jared Poras, Henry R. [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/02/2004 10:54 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:stress testing We are planning on running some stress tests on a PeopleSoft/Oracle/Solaris system starting next week (using LoadRunner). I have never gone through a formalized stress test before (most of my stress is brought about informally). So far I am planning to gather statspack information, and periodically get vmstat from the OS. Is there anything else that I should collect? Thanks for the help. Henry -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Poras, Henry R. 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: Jared Still 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: Poras, Henry R. 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: stress testing
Hi Tim Tony Jambu here. Saw your posting to Oracle-l with regards to your sp_vmstat.sh script. I am not sure if know but I write a regular hints tips column for Select Journal. I read your article and would like to mention your script and point people to the script. Do you mind if I mention it and also to point them to somewhere where they are able to get a copy of it? Dont want them hassling you and sending emails requesting it. Let me know what you think ta tony At 09:14 AM 03/01/2004 -0800, Tim Gorman wrote: Henry, I use the attached shell script to gather and store VMSTAT information in a custom table within the PERFSTAT schema (i.e. schema belonging to STATSPACK). Allows for some nice reporting over time, rather than anecdotal here-and-there observations. Should work OK on Solaris, HP, and Linux. Be aware: the script expects to use the standard oraenv and dbhome scripts to set up the Oracle environment variables, and expects a hidden file in the $HOME directory of the owner's UNIX account for storing Oracle passwords, and also has optional functionality to email/page in the event of trouble. Hope this helps... -Tim on 1/2/04 11:54 AM, Poras, Henry R. at [EMAIL PROTECTED] wrote: We are planning on running some stress tests on a PeopleSoft/Oracle/Solaris system starting next week (using LoadRunner). I have never gone through a formalized stress test before (most of my stress is brought about informally). So far I am planning to gather statspack information, and periodically get vmstat from the OS. Is there anything else that I should collect? Thanks for the help. Henry _ / |Tony Jambu, DatabaseWeb Consultant /_ _/_ __ / |Wizard Consulting Pty Ltd /(_)/ )(_/ \_/(///(/_)/_( |IOUG's Select Asia-Pacific Tech. Editor \___/ |EMAIL: TJambu @ wizard.cx (REMOVE Spaces from email ) |PHONE: +61-419-TJAMBU(852628) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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: stress testing
Henry, I use the attached shell script to gather and store VMSTAT information in a custom table within the PERFSTAT schema (i.e. schema belonging to STATSPACK). Allows for some nice reporting over time, rather than anecdotal here-and-there observations. Should work OK on Solaris, HP, and Linux. Be aware: the script expects to use the standard oraenv and dbhome scripts to set up the Oracle environment variables, and expects a hidden file in the $HOME directory of the owner's UNIX account for storing Oracle passwords, and also has optional functionality to email/page in the event of trouble. Hope this helps... -Tim on 1/2/04 11:54 AM, Poras, Henry R. at [EMAIL PROTECTED] wrote: We are planning on running some stress tests on a PeopleSoft/Oracle/Solaris system starting next week (using LoadRunner). I have never gone through a formalized stress test before (most of my stress is brought about informally). So far I am planning to gather statspack information, and periodically get vmstat from the OS. Is there anything else that I should collect? Thanks for the help. Henry sp_vmstat.sh Description: Binary data
stress testing
We are planning on running some stress tests on a PeopleSoft/Oracle/Solaris system starting next week (using LoadRunner). I have never gone through a formalized stress test before (most of my stress is brought about informally). So far I am planning to gather statspack information, and periodically get vmstat from the OS. Is there anything else that I should collect? Thanks for the help. Henry -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Poras, Henry R. 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: stress testing
As the ultimate indicator of performance is response time, you might like to investigate YAPP at http://www.miracleas.dk/. The data generated gives a good indicator of response time from a database perspective. If you use it, ask me for the patch. Jared Poras, Henry R. [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/02/2004 10:54 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:stress testing We are planning on running some stress tests on a PeopleSoft/Oracle/Solaris system starting next week (using LoadRunner). I have never gone through a formalized stress test before (most of my stress is brought about informally). So far I am planning to gather statspack information, and periodically get vmstat from the OS. Is there anything else that I should collect? Thanks for the help. Henry -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Poras, Henry R. 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: stress testing
Henry, Sar is a better tool than vmstat/iostat as it collects a broad range of information. Specifically, sar -q should show up CPU queueing and swapping, and sar -v will show up file/process table overflow issues that may occur during stress testing. IMHO, sar is quite underutilized ( had a paper on this last IOUG, but couldn't go and present it :( John Kanagaraj DB Soft Inc Phone: 408-970-7002 (W) Grace - Getting something we do NOT deserve Mercy - NOT getting something we DO deserve Click on 'http://www.needhim.org' for Grace and Mercy that is freely available! ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** -Original Message- From: Poras, Henry R. [mailto:[EMAIL PROTECTED] Sent: Friday, January 02, 2004 10:54 AM To: Multiple recipients of list ORACLE-L Subject: stress testing We are planning on running some stress tests on a PeopleSoft/Oracle/Solaris system starting next week (using LoadRunner). I have never gone through a formalized stress test before (most of my stress is brought about informally). So far I am planning to gather statspack information, and periodically get vmstat from the OS. Is there anything else that I should collect? Thanks for the help. Henry -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Poras, Henry R. 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: John Kanagaraj 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: stress testing
Henry: John is partially correct. SAR, in concert with VMSTAT / IOSTAT, will provide you with a wealth of information. However, something is missing from the equation here. LoadRunner will generate scattered statistics on overall performance of an application (sorry: biased because Compuware has a better tool), but misses the mark on what other things could affect overall application performance. For example, are you doing to perform a virgin load test where no one is on the network and nothing but this application is running on the client? What about other traffic that would affect overall performance throughout your enterprise network? What about other applications/activities running on the client machines performing the load test. Only then will you have an effective measurement of application performance in the real world. If you truly have to use LoadRunner, get some software that can measure Network Performance as it relates to the load test and as it relates to general network traffic. The load test should account for other activity being performed such as email, backups, file transfers, reading of documents, etc. Otherwise, your numbers will be skewed. Good luck. Thank You Stephen P. Karniotis Technical Alliance Manager Compuware Corporation Direct: (313) 227-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- John Kanagaraj Sent: Friday, January 02, 2004 2:29 PM To: Multiple recipients of list ORACLE-L Subject:RE: stress testing Henry, Sar is a better tool than vmstat/iostat as it collects a broad range of information. Specifically, sar -q should show up CPU queueing and swapping, and sar -v will show up file/process table overflow issues that may occur during stress testing. IMHO, sar is quite underutilized ( had a paper on this last IOUG, but couldn't go and present it :( John Kanagaraj DB Soft Inc Phone: 408-970-7002 (W) Grace - Getting something we do NOT deserve Mercy - NOT getting something we DO deserve Click on 'http://www.needhim.org' for Grace and Mercy that is freely available! ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** -Original Message- From: Poras, Henry R. [mailto:[EMAIL PROTECTED] Sent: Friday, January 02, 2004 10:54 AM To: Multiple recipients of list ORACLE-L Subject: stress testing We are planning on running some stress tests on a PeopleSoft/Oracle/Solaris system starting next week (using LoadRunner). I have never gone through a formalized stress test before (most of my stress is brought about informally). So far I am planning to gather statspack information, and periodically get vmstat from the OS. Is there anything else that I should collect? Thanks for the help. Henry -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Poras, Henry R. 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: John Kanagaraj 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). The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Karniotis, Stephen 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
Re: stress testing
And when you're doing stress testing, make sure you load your system for quite long time. Stress testing shouldn't only verify system performance, but it should also test system's reliability. One of my clients had a problem with Oracle Apps, where they did a stress test for just one hour and concluded that the performance was acceptable. But one of the components in Apps (forms server) started just hanging after 5-6 hours of usage in their system, so if they had done an automated stress test over a weekend or even more, they'd have found it. Also, any kind of testing should simulate real life, if possible - otherwise you'll get results which might not match with future production usage all. That means, the amounts of data should be similar, if you can use a copy of real system for testing it'd be the best, also note that there are probably different usage patterns in your future system (such as month/year ending, campaign periods in retail businesses etc) so your system has to cope with all of them. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, January 02, 2004 9:29 PM Henry, Sar is a better tool than vmstat/iostat as it collects a broad range of information. Specifically, sar -q should show up CPU queueing and swapping, and sar -v will show up file/process table overflow issues that may occur during stress testing. IMHO, sar is quite underutilized ( had a paper on this last IOUG, but couldn't go and present it :( John Kanagaraj DB Soft Inc Phone: 408-970-7002 (W) Grace - Getting something we do NOT deserve Mercy - NOT getting something we DO deserve Click on 'http://www.needhim.org' for Grace and Mercy that is freely available! ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** -Original Message- From: Poras, Henry R. [mailto:[EMAIL PROTECTED] Sent: Friday, January 02, 2004 10:54 AM To: Multiple recipients of list ORACLE-L Subject: stress testing We are planning on running some stress tests on a PeopleSoft/Oracle/Solaris system starting next week (using LoadRunner). I have never gone through a formalized stress test before (most of my stress is brought about informally). So far I am planning to gather statspack information, and periodically get vmstat from the OS. Is there anything else that I should collect? Thanks for the help. Henry -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Poras, Henry R. 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: John Kanagaraj 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: Tanel Poder 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).
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
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.
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.
testing - pls ignore
¡Internet GRATIS es Yahoo! Conexión! Usuario yahoo, contraseña yahoo. Desde Buenos Aires, 4004-1010. Otras ciudades: http://conexion.yahoo.com.ar/avanzados.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Diego=20Cutrone?= 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).
testing..
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,
Testing database links
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).
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).
OT topic - Testing tools
Hello all, Sorry for this off-topic..i want to know what are the testing tools (like win-runner) available and any good sites are there on the net from where i can learn them... Thanks and Regards, Santosh Varma
Testing
Re: Buffer Pool Testing
At a high level, I think the various pools operate in pretty much the same way - but there are some differences, some of which may be affected by various hidden parameters. For example, Steve Adams has this note (dated Oct 2000) on his website as one of several observations on the 'new' LRU mechanism. Some details may have evolved since then, of course, but it is a good indication of how the pools can be the same, but different. quote By default, the KEEP and RECYCLE buffer pools do not have a hot region, but this can be changed by setting the _db_percent_hot_keep and _db_percent_hot_recycle parameters to non-zero values. Otherwise, the RECYCLE buffer pool has exactly the same LRU semantics as the DEFAULT buffer pool - it is only the name that is different - and the KEEP buffer pool differs only in that buffers read for long table scans are cached just below the hot region rather than at the LRU end and consistent read buffers are immediately frozen. /quote Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon a new one-day tutorial: Cost Based Optimisation (see http://www.jlcomp.demon.co.uk/tutorial.html ) Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) England__January 21/23 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: 03 January 2003 02:23 2. The KEEP and RECYCLE Pools aren't really special in any sense: the buffer algorithms are the same for these as for the DEFAULT pool - it is just that these pools are named so that tables can be defaulted to load into any one of them. By using this feature judiciously, you might be able to avoid the problems of unneccesary buffering during FTS on tables smaller than the threshhold without actually changing the undocumented parameter. Jonathan: Awaiting your expert comments on this new twist :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis 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: Buffer Pool Testing
The reason that I consider it a problem is that I have increased the physical IO on my database. I see Full Table Scans on these two tables, which are large tables relative to the others. I moved them to they RECYCLE pool so that they would have less of an impact on the DEFAULT pool. By doing so, it looks like I am forcing the database to do more physical reads than it may have been doing with these tables in the DEFAULT pool. I thought the FTS blocks would fight with each other (the blocks queried the most often would stay in the pool) over the RECYCLE pool, but the algorithm keeps the first blocks in place. Knowing this, I think I need to re-evaluate whether or not these tables were causing a problem in the DEFAULT pool to begin with. I tried _db_percent_hot_recycle=10, but didn't really notice much of a difference. Since all of my blocks are read into this pool by FTS, I was hoping that it would consider some of them to be hot, thereby causing the rest to be flushed out faster. I just wanted the hottest FTS blocks to stay in the RECYCLE pool, but that wasn't the case. Jay [EMAIL PROTECTED] 01/02/03 06:44PM The 'problem' is, as you say, related to the tablescan. Craig is correct that NORMALLY a full tablescan will only permit a limited number of blocks to get into the cache at the LRU end of the chain - the number is typically the size of db_file_multblock_read_count. There are a couple of special cases though, the first being when there are free blocks in the buffer, Oracle will just keep packing in the multiblock reads into the cache until there are no free blocks left. (And specifically free means state=0). The other special case I can think of at the moment is when you have multiple tablescans going on concurrently, and depending on precise timing you can end up with multiples of db_file_multiblock_read_count blocks from different tables near the LRU end of the cache. There was a period, I believe, when the RECYCLE pool did behave a little differently (can anyone confirm this ?) but in 9.2.0.2, it handles tablescans just the same way as the default pool. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon a new one-day tutorial: Cost Based Optimisation (see http://www.jlcomp.demon.co.uk/tutorial.html ) Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) England__January 21/23 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: 02 January 2003 19:03 So it seems like my problem is the full table scan. Craig Shallahammer mentions this in his All About Oracle's Touch-Count Data Block Buffer Algoithm paper - The modified LRU algorithm places full-table scanned blocks read into the buffer cache at the LRU end of the LRU chain and only permits a limited number of these blocks to exist in the cache at once. Using my second example (query ALRA_TRANSACTION_HISTORY then WORK_ORDER_STEP), I can get more blocks of WORK_ORDER_STEP into the cache if I run queries that don't do full table scans. I still expected multiple queries against a table (full-scan or otherwise) to replace the cache blocks that I was no longer using - especially in the RECYCLE pool. But it appears as though the algorithm doesn't work that way. Thanks, Jay also send the HELP command for other information (like subscribing). **DISCLAIMER This e-mail message and any files transmitted with it are intended for the use of the individual or entity to which they are addressed and may contain information that is privileged, proprietary and confidential. If you are not the intended recipient, you may not use, copy or disclose to anyone the message or any information contained in the message. If you have received this communication in error, please notify the sender and delete this e-mail message. The contents do not represent the opinion of DE except to the extent that it relates to their official business. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Hostetter 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: Buffer Pool Testing
I think you are seeing expected behaviour. Blocks subject to tablescan are loaded in to the LRU end of the cache, even when using a RECYCLE cache. However, if there are free blocks in the cache (state = 0) Oracle uses those rather than flushing other blocks. Consequently, when you startup and scan a 400 block table with a 1,000 block cache, the whole 400 blocks will get into memory. Then the next 10,000 block scan will start by using the last 600 blocks of the cache before recycling the last db_file_multiblock_read_count blocks. By this time, though, the 1st 400 blocks are at the MRU end of the chain, and are not moved by the subsequent tablescan. If you start with the 10,000 block scan, the whole cache is filled. The second scan then keeps recycling the last db_file_multiblock_read_count blocks (though in your case I guess it's plus one - possibly a cleanout block, possibly the segment header block which may go into the Default pool in v9 - without pushing out any more of the first 1,000 blocks from the first scan. Periods of time shortly after startup are always likely to show anomalous behaviour. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon a new one-day tutorial: Cost Based Optimisation (see http://www.jlcomp.demon.co.uk/tutorial.html ) Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) England__January 21/23 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: 31 December 2002 19:31 I'm spending some time today experimenting with buffer pools in 8.1.7. I have two tables that I have assigned to the RECYCLE pool. I have been running various queries that perform full table scans, then checking the buffers to see what gets aged out. During my testing, it seems like the first blocks to get into the RECYCLE buffer pool will stay there. The following two tables are assigned to the RECYCLE pool. No other segments are assigned to it: WORK_ORDER_STEP - 428 blocks of data ALRA_TRANSACTION_HISTORY - 14152 blocks of data The RECYCLE pool has 1000 blocks. I startup the database, query the WORK_ORDER_STEP table (1 time), then run multiple queries against the ALRA_TRANSACTION_HISTORY table (6 times), I see the following in the buffers (the source for this query is at the end of my email): BP_NAME OBJ_OWNER NAME BLOCKS MAX_TOUCH MIN_TOUCH AVG_TOUCH --- -- - - - - - RECYCLE BIS ALRA_TRANSACTION_HISTORY 56914 0 .02 RECYCLE WRKORD WORK_ORDER_STEP 431 1 0 .00 If I startup the database, query the ALRA_TRANSACTION_HISTORY table (1 time), then run multiple queries against the WORK_ORDER_STEP table (6 queries), I get these results: First query - 1000 blocks are used as expected BP_NAME OBJ_OWNER NAME BLOCKS MAX_TOUCH MIN_TOUCH AVG_TOUCH --- -- - - - - - RECYCLE BIS ALRA_TRANSACTION_HISTORY 1000 2 0 .00 After querying the second table multiple times, I expected more than just 9 blocks to be given up. I expected more like 431 blocks. BP_NAME OBJ_OWNER NAME BLOCKS MAX_TOUCH MIN_TOUCH AVG_TOUCH --- -- - - - - - RECYCLE BIS ALRA_TRANSACTION_HISTORY 991 2 0 .00 RECYCLE WRKORD WORK_ORDER_STEP 9 4 0 .44 I expected the blocks (from the table that was queried first) to be aged out as I queried the second table (over and over). This does not occur. Am I hitting a bug or just misunderstanding the buffer management algorithms? ALRA_TRANSACTION_HISTORY blocks should be LRU as I hit the WORK_ORDER_STEP table over and over. Thanks, Jay -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis 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: Buffer Pool Testing
So it seems like my problem is the full table scan. Craig Shallahammer mentions this in his All About Oracle's Touch-Count Data Block Buffer Algoithm paper - The modified LRU algorithm places full-table scanned blocks read into the buffer cache at the LRU end of the LRU chain and only permits a limited number of these blocks to exist in the cache at once. Using my second example (query ALRA_TRANSACTION_HISTORY then WORK_ORDER_STEP), I can get more blocks of WORK_ORDER_STEP into the cache if I run queries that don't do full table scans. I still expected multiple queries against a table (full-scan or otherwise) to replace the cache blocks that I was no longer using - especially in the RECYCLE pool. But it appears as though the algorithm doesn't work that way. Thanks, Jay [EMAIL PROTECTED] 01/02/03 10:20AM I think you are seeing expected behaviour. Blocks subject to tablescan are loaded in to the LRU end of the cache, even when using a RECYCLE cache. However, if there are free blocks in the cache (state = 0) Oracle uses those rather than flushing other blocks. Consequently, when you startup and scan a 400 block table with a 1,000 block cache, the whole 400 blocks will get into memory. Then the next 10,000 block scan will start by using the last 600 blocks of the cache before recycling the last db_file_multiblock_read_count blocks. By this time, though, the 1st 400 blocks are at the MRU end of the chain, and are not moved by the subsequent tablescan. If you start with the 10,000 block scan, the whole cache is filled. The second scan then keeps recycling the last db_file_multiblock_read_count blocks (though in your case I guess it's plus one - possibly a cleanout block, possibly the segment header block which may go into the Default pool in v9 - without pushing out any more of the first 1,000 blocks from the first scan. Periods of time shortly after startup are always likely to show anomalous behaviour. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon a new one-day tutorial: Cost Based Optimisation (see http://www.jlcomp.demon.co.uk/tutorial.html ) Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) England__January 21/23 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: 31 December 2002 19:31 I'm spending some time today experimenting with buffer pools in 8.1.7. I have two tables that I have assigned to the RECYCLE pool. I have been running various queries that perform full table scans, then checking the buffers to see what gets aged out. During my testing, it seems like the first blocks to get into the RECYCLE buffer pool will stay there. The following two tables are assigned to the RECYCLE pool. No other segments are assigned to it: WORK_ORDER_STEP - 428 blocks of data ALRA_TRANSACTION_HISTORY - 14152 blocks of data The RECYCLE pool has 1000 blocks. I startup the database, query the WORK_ORDER_STEP table (1 time), then run multiple queries against the ALRA_TRANSACTION_HISTORY table (6 times), I see the following in the buffers (the source for this query is at the end of my email): BP_NAME OBJ_OWNER NAME BLOCKS MAX_TOUCH MIN_TOUCH AVG_TOUCH --- -- - - - - - RECYCLE BIS ALRA_TRANSACTION_HISTORY 56914 0 .02 RECYCLE WRKORD WORK_ORDER_STEP 431 1 0 .00 If I startup the database, query the ALRA_TRANSACTION_HISTORY table (1 time), then run multiple queries against the WORK_ORDER_STEP table (6 queries), I get these results: First query - 1000 blocks are used as expected BP_NAME OBJ_OWNER NAME BLOCKS MAX_TOUCH MIN_TOUCH AVG_TOUCH --- -- - - - - - RECYCLE BIS ALRA_TRANSACTION_HISTORY 1000 2 0 .00 After querying the second table multiple times, I expected more than just 9 blocks to be given up. I expected more like 431 blocks. BP_NAME OBJ_OWNER NAME BLOCKS MAX_TOUCH MIN_TOUCH AVG_TOUCH --- -- - - - - - RECYCLE BIS ALRA_TRANSACTION_HISTORY 991 2 0 .00 RECYCLE WRKORD WORK_ORDER_STEP 9 4 0 .44 I expected the blocks (from the table that was queried first) to be aged out as I queried the second table (over and over). This does not occur. Am I hitting a bug or just misunderstanding the buffer management algorithms? ALRA_TRANSACTION_HISTORY blocks should be LRU as I hit the WORK_ORDER_STEP table over and over. Thanks, Jay **DISCLAIMER
Re: Buffer Pool Testing
The 'problem' is, as you say, related to the tablescan. Craig is correct that NORMALLY a full tablescan will only permit a limited number of blocks to get into the cache at the LRU end of the chain - the number is typically the size of db_file_multblock_read_count. There are a couple of special cases though, the first being when there are free blocks in the buffer, Oracle will just keep packing in the multiblock reads into the cache until there are no free blocks left. (And specifically free means state=0). The other special case I can think of at the moment is when you have multiple tablescans going on concurrently, and depending on precise timing you can end up with multiples of db_file_multiblock_read_count blocks from different tables near the LRU end of the cache. There was a period, I believe, when the RECYCLE pool did behave a little differently (can anyone confirm this ?) but in 9.2.0.2, it handles tablescans just the same way as the default pool. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon a new one-day tutorial: Cost Based Optimisation (see http://www.jlcomp.demon.co.uk/tutorial.html ) Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) England__January 21/23 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: 02 January 2003 19:03 So it seems like my problem is the full table scan. Craig Shallahammer mentions this in his All About Oracle's Touch-Count Data Block Buffer Algoithm paper - The modified LRU algorithm places full-table scanned blocks read into the buffer cache at the LRU end of the LRU chain and only permits a limited number of these blocks to exist in the cache at once. Using my second example (query ALRA_TRANSACTION_HISTORY then WORK_ORDER_STEP), I can get more blocks of WORK_ORDER_STEP into the cache if I run queries that don't do full table scans. I still expected multiple queries against a table (full-scan or otherwise) to replace the cache blocks that I was no longer using - especially in the RECYCLE pool. But it appears as though the algorithm doesn't work that way. Thanks, Jay -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis 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: Buffer Pool Testing
Jay, Have you considered the default value of '_small_table_threshold'? Apparently it defaults to 2% of the Buffer cache in 8i (haven't seen any official docs to support this though) Also wondering how this works in the case of the 'special' buffer pools in combination with the 'CACHE' and 'NOCACHE' option on the tables in question. Is my understanding that the kernel would load a 'small' table into the MRU end rather than the LRU correct? Two myths here: 1. The 'old' docs (V6, V7.0??) said that small tables were 4 blocks or lesser (or was it 5 blocks?). This carried over into the later versions 2. The KEEP and RECYCLE Pools aren't really special in any sense: the buffer algorithms are the same for these as for the DEFAULT pool - it is just that these pools are named so that tables can be defaulted to load into any one of them. By using this feature judiciously, you might be able to avoid the problems of unneccesary buffering during FTS on tables smaller than the threshhold without actually changing the undocumented parameter. Jonathan: Awaiting your expert comments on this new twist :) John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 What would you see if you were allowed to look back at your life at the end of your journey in this earth? ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- From: Jonathan Lewis [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 02, 2003 3:44 PM To: Multiple recipients of list ORACLE-L Subject: Re: Buffer Pool Testing The 'problem' is, as you say, related to the tablescan. Craig is correct that NORMALLY a full tablescan will only permit a limited number of blocks to get into the cache at the LRU end of the chain - the number is typically the size of db_file_multblock_read_count. There are a couple of special cases though, the first being when there are free blocks in the buffer, Oracle will just keep packing in the multiblock reads into the cache until there are no free blocks left. (And specifically free means state=0). The other special case I can think of at the moment is when you have multiple tablescans going on concurrently, and depending on precise timing you can end up with multiples of db_file_multiblock_read_count blocks from different tables near the LRU end of the cache. There was a period, I believe, when the RECYCLE pool did behave a little differently (can anyone confirm this ?) but in 9.2.0.2, it handles tablescans just the same way as the default pool. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon a new one-day tutorial: Cost Based Optimisation (see http://www.jlcomp.demon.co.uk/tutorial.html ) Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) England__January 21/23 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: 02 January 2003 19:03 So it seems like my problem is the full table scan. Craig Shallahammer mentions this in his All About Oracle's Touch-Count Data Block Buffer Algoithm paper - The modified LRU algorithm places full-table scanned blocks read into the buffer cache at the LRU end of the LRU chain and only permits a limited number of these blocks to exist in the cache at once. Using my second example (query ALRA_TRANSACTION_HISTORY then WORK_ORDER_STEP), I can get more blocks of WORK_ORDER_STEP into the cache if I run queries that don't do full table scans. I still expected multiple queries against a table (full-scan or otherwise) to replace the cache blocks that I was no longer using - especially in the RECYCLE pool. But it appears as though the algorithm doesn't work that way. Thanks, Jay -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis 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: John Kanagaraj 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
Buffer Pool Testing
I'm spending some time today experimenting with buffer pools in 8.1.7. I have two tables that I have assigned to the RECYCLE pool. I have been running various queries that perform full table scans, then checking the buffers to see what gets aged out. During my testing, it seems like the first blocks to get into the RECYCLE buffer pool will stay there. The following two tables are assigned to the RECYCLE pool. No other segments are assigned to it: WORK_ORDER_STEP - 428 blocks of data ALRA_TRANSACTION_HISTORY - 14152 blocks of data The RECYCLE pool has 1000 blocks. I startup the database, query the WORK_ORDER_STEP table (1 time), then run multiple queries against the ALRA_TRANSACTION_HISTORY table (6 times), I see the following in the buffers (the source for this query is at the end of my email): BP_NAME OBJ_OWNER NAME BLOCKS MAX_TOUCH MIN_TOUCH AVG_TOUCH --- -- -- - - - RECYCLE BIS ALRA_TRANSACTION_HISTORY 569 14 0 .02 RECYCLE WRKORD WORK_ORDER_STEP 431 1 0 .00 If I startup the database, query the ALRA_TRANSACTION_HISTORY table (1 time), then run multiple queries against the WORK_ORDER_STEP table (6 queries), I get these results: First query - 1000 blocks are used as expected BP_NAME OBJ_OWNER NAME BLOCKS MAX_TOUCH MIN_TOUCH AVG_TOUCH --- -- -- - - - RECYCLE BIS ALRA_TRANSACTION_HISTORY 1000 2 0 .00 After querying the second table multiple times, I expected more than just 9 blocks to be given up. I expected more like 431 blocks. BP_NAME OBJ_OWNER NAME BLOCKS MAX_TOUCH MIN_TOUCH AVG_TOUCH --- -- -- - - - RECYCLE BIS ALRA_TRANSACTION_HISTORY 991 2 0 .00 RECYCLE WRKORD WORK_ORDER_STEP 9 4 0 .44 I expected the blocks (from the table that was queried first) to be aged out as I queried the second table (over and over). This does not occur. Am I hitting a bug or just misunderstanding the buffer management algorithms? ALRA_TRANSACTION_HISTORY blocks should be LRU as I hit the WORK_ORDER_STEP table over and over. Thanks, Jay Here is the query that I use to check what is in the buffer pools: select bpd.bp_name, u.name obj_owner, o.name, count(*) BLOCKS, max(tch) max_touch, min(tch) min_touch, avg(tch) avg_touch from x$kcbwds wds, /* working data sets */ x$kcbwbpd bpd, /* buffer pools */ x$bh bh, /* buffer headers */ obj$ o,/* objects */ user$ u where wds.set_id = bpd.bp_lo_sid and wds.set_id = bpd.bp_hi_sid and bpd.bp_size != 0 and bh.indx between wds.start_buf# and wds.end_buf# and o.dataobj# = bh.obj and bh.state !=0 and o.owner# !=0 /* exclude sys */ and o.owner# = u.user# group by bpd.bp_name, u.name, o.name order by bpd.bp_name, u.name, o.name ; **DISCLAIMER This e-mail message and any files transmitted with it are intended for the use of the individual or entity to which they are addressed and may contain information that is privileged, proprietary and confidential. If you are not the intended recipient, you may not use, copy or disclose to anyone the message or any information contained in the message. If you have received this communication in error, please notify the sender and delete this e-mail message. The contents do not represent the opinion of DE except to the extent that it relates to their official business. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Hostetter 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).
Testing
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
Rollback Segment Size Testing.
hi, list friends: I am interested in that topic:http://www.ioug.org/ioug_s/repository_pkg.doc?v_tech_content_dtl_phy_id=7666 I am also considering whether too large rbs segment size does have adverse impact on database performance. In my production (OLTP) i configured rbs to be 1m*20 extents. But from v$rollstat and statspack, the average active size is 1.5M. I am considering whether it is too large and shrink it to 128k*20 will help.(but hard to find out the performance gains as it is a big system). If anyone in this list have IOUG membership, can you send me a copy? And i hope friends have experience on this topic can share your experience Regards zhu chao Eachnet DBA 86-21-32174588-667 [EMAIL PROTECTED] www.cnoug.org(Chinese Oracle User Group) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: chao_ping 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: Rollback Segment Size Testing.
Zhu Chao, Please be aware that rollback segments serve two major purposes: * recover individual transactions (i.e. rollback) * provide before-image information for read-consistency The information you are getting from V$ROLLSTAT and STATSPACK is accurate at measuring the first purpose only. Until Oracle9i and the V$UNDOSTAT view that accompanies the use of UNDO tablespaces, it is very difficult to estimate how much space is necessary to satisfy the needs of SQL statements requiring before-image information in order to complete successfully without the ORA-01555 snapshot too old error message. First of all, the size or number of extents in a rollback segment does not affect the performance of SQL statements. Of course, if the size of the extents is extremely small and the number of extents varies wildly up and down, then the sheer overhead of extent maintenance might be a performance factor. Since you are examining V$ROLLSTAT and STATSPACK, you have info as to whether this is happening in hand (i.e. columns EXTENDS and SHRINKS in V$ROLLSTAT)... So, since there is no adverse impact related to the number and size of extents for RBS (other than that mentioned above, easily verifiable), and since reducing the amount of space in your RBS can increase the probability of incurring the ORA-01555 error, I'd like to suggest that the only advantage you can gain by reducing the size or number of extents is saving space. Is space a concern? Summary: be careful and be alert for the incidence of the ORA-01555 error message. Since only end-users become aware of it (i.e. it is not logged in alert.log or in trace files), you might want to activate an AFTER SERVERERROR database-event trigger (if you are running 8i or above) to log occurrances of it. Otherwise, you'll need to be certain that end-users have a reliable feedback mechanism to alert you to any changes in the frequency of ORA-01555. All in all, I think you should leave things alone, unless there is a quantifiable problem. Just some things to consider... -Tim - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, November 12, 2002 5:59 AM hi, list friends: I am interested in that topic:http://www.ioug.org/ioug_s/repository_pkg.doc?v_tech_content_dtl_phy_i d=7666 I am also considering whether too large rbs segment size does have adverse impact on database performance. In my production (OLTP) i configured rbs to be 1m*20 extents. But from v$rollstat and statspack, the average active size is 1.5M. I am considering whether it is too large and shrink it to 128k*20 will help.(but hard to find out the performance gains as it is a big system). If anyone in this list have IOUG membership, can you send me a copy? And i hope friends have experience on this topic can share your experience Regards zhu chao Eachnet DBA 86-21-32174588-667 [EMAIL PROTECTED] www.cnoug.org(Chinese Oracle User Group) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: chao_ping 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: Tim Gorman 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).
Stress Testing Peoplesoft App
Anybody have experience with stress testing software for Peoplesoft? Links, thoughts, comments etc... Thanks, Ethan -- 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).
Testing
Gene Sais [EMAIL PROTECTED] wrote: another suggestion:disable default roles.grant create session to all users.use application to enable roles with password.hth,gene [EMAIL PROTECTED] 08/09/02 01:58PM Why to find who and when. the best thing is to restrict the access.-Original Message-Sent: Friday, August 09, 2002 10:44 PMTo: Multiple recipients of list ORACLE-LUse a logon trigger to capture everything from v$session and you can look atprogram name etc...it will be pretty easy to figure out who and when.Something like this in the trigger...select distinct sid into l_sid from v$mystat;insert into session_log (select * from v$session where sid = l_sid;Ethan Postperotdba (AIM), epost1 (Yahoo)-Original Me! ! ssage-Sent: Friday, August 09, 2002 11:49 AMTo: Multiple recipients of list ORACLE-LFolks,Before I go off re-inventing the wheel once again I'll ask the group isanyone has tried this before. What I have is a request from damanagement totell them when someone connects to our PeopleSoft database using the schemausername, but outside of PeopleTools. The reason is that there have beensome"unexplained" changes to data that have occurred over the last month that iscausing a pile of concern. It is believed that someone who has the schemapassword is using SQL*Plus or Toad to update the data when they should notbedoing so. Now auditing connects for the schema account is not a problem,butdetermining which are suspicious and which are due to the damned PeopleSoftpanel processor I can't see a way around easily from sys.aud$. Anyone elsebeenthere, done that??Dick Goulet-- 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-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).-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, EthanINET: [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).--Please see the official ORACLE-L FAQ: http://www.orafaq.com --Author: Naveen NahataINET: [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).--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Gene SaisINET: [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). Yahoo! Digital How To - Get the best out of your PC!
RE: Licences for testing
Just catching up after the long weekend here, I have been under the understanding that if you are a development partner then you are covered for all products for as many installations for testing and development and learning purposes. Is this wrong or changed ?? If not then it may be in your interests to check out partner status and the value of joining the partner program. Oracle PartnerNetwork Policy Document is the one which states this and as it was explained to me by an Oracle Partner Account Manager a year or so ago Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 03-05-2002 11:43 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:RE: Licences for testing As far as I am aware : NO. It has played a major role in me not being able to obtain some more test boxes at my current job. I believe the licensing is a little better, but it is still there. Plus, you also need the OS (Sun Solaris) so you get hit there too. Hannah -Original Message- From: [EMAIL PROTECTED]@SUNGARD On Behalf Of O'Neill, Sean [EMAIL PROTECTED] Sent: Friday, May 03, 2002 8:09 AM To:Multiple recipients of list ORACLE-L Subject: Licences for testing We're planning to set-up some test servers here and I'm wondering what the practice is out there regarding licences for same. This is only for short term testing and to try out various DR scenarios etc. I'd guess there's an Oracle view which would be if you install on server you pay a licence, (correct?). Is there some workaround for this?. All creative ideas welcome :) -- 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). -- This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. STG14543 Description: Binary data
Licences for testing
We're planning to set-up some test servers here and I'm wondering what the practice is out there regarding licences for same. This is only for short term testing and to try out various DR scenarios etc. I'd guess there's an Oracle view which would be if you install on server you pay a licence, (correct?). Is there some workaround for this?. All creative ideas welcome :) - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Licences for testing
Would the personal edition work for you? I don't think there would be a licensing issue with this. Dave -Original Message- Sent: Friday, May 03, 2002 7:09 AM To: Multiple recipients of list ORACLE-L We're planning to set-up some test servers here and I'm wondering what the practice is out there regarding licences for same. This is only for short term testing and to try out various DR scenarios etc. I'd guess there's an Oracle view which would be if you install on server you pay a licence, (correct?). Is there some workaround for this?. All creative ideas welcome :) - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Licences for testing
As far as I am aware : NO. It has played a major role in me not being able to obtain some more test boxes at my current job. I believe the licensing is a little better, but it is still there. Plus, you also need the OS (Sun Solaris) so you get hit there too. Hannah -Original Message- From: [EMAIL PROTECTED]@SUNGARD On Behalf Of O'Neill, Sean [EMAIL PROTECTED] Sent: Friday, May 03, 2002 8:09 AM To: Multiple recipients of list ORACLE-L Subject: Licences for testing We're planning to set-up some test servers here and I'm wondering what the practice is out there regarding licences for same. This is only for short term testing and to try out various DR scenarios etc. I'd guess there's an Oracle view which would be if you install on server you pay a licence, (correct?). Is there some workaround for this?. All creative ideas welcome :) -- 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: Licences for testing
You could talk to your sales rep about short-term licensing, or you could just do it and hope they don't discover it. I've found that temporary servers have a tendency to become permanent though. |+--- || | || | || Sean.ONeill@o| || rganon.ie| || | || 05/03/2002 | || 08:08 AM | || Please | || respond to | || ORACLE-L | || | |+--- | || | To: [EMAIL PROTECTED] | | cc: (bcc: Rachel Carmichael) | | Subject: Licences for testing| | We're planning to set-up some test servers here and I'm wondering what the practice is out there regarding licences for same. This is only for short term testing and to try out various DR scenarios etc. I'd guess there's an Oracle view which would be if you install on server you pay a licence, (correct?). Is there some workaround for this?. All creative ideas welcome :) - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Licences for testing
Last time I checked Oracle on Linux is free if it's used for testing only. If you don't mind using Linux (we use it extensively) it could be a viable option. --Walt Weaver Bozeman, Montana -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Friday, May 03, 2002 7:43 AM To: Multiple recipients of list ORACLE-L You could talk to your sales rep about short-term licensing, or you could just do it and hope they don't discover it. I've found that temporary servers have a tendency to become permanent though. |+--- || | || | || Sean.ONeill@o| || rganon.ie| || | || 05/03/2002 | || 08:08 AM | || Please | || respond to | || ORACLE-L | || | |+--- | || | To: [EMAIL PROTECTED] | | cc: (bcc: Rachel Carmichael) | | Subject: Licences for testing| | We're planning to set-up some test servers here and I'm wondering what the practice is out there regarding licences for same. This is only for short term testing and to try out various DR scenarios etc. I'd guess there's an Oracle view which would be if you install on server you pay a licence, (correct?). Is there some workaround for this?. All creative ideas welcome :) - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).
RE: Licences for testing
I would not think you would need a license for evaluating the software. However, once you cross the line into development or production licensing is mandatory. Unless things have changed, the Oracle LINUX client is free, but the LINUX server requires licensing as defined above. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- From: O'Neill, Sean [mailto:[EMAIL PROTECTED]] Sent: Friday, May 03, 2002 5:09 AM To: Multiple recipients of list ORACLE-L We're planning to set-up some test servers here and I'm wondering what the practice is out there regarding licences for same. This is only for short term testing and to try out various DR scenarios etc. I'd guess there's an Oracle view which would be if you install on server you pay a licence, (correct?). Is there some workaround for this?. All creative ideas welcome :) - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Licences for testing
Download the 30 day trial from OTN -Original Message- Sean Sent: Friday, May 03, 2002 5:09 AM To: Multiple recipients of list ORACLE-L We're planning to set-up some test servers here and I'm wondering what the practice is out there regarding licences for same. This is only for short term testing and to try out various DR scenarios etc. I'd guess there's an Oracle view which would be if you install on server you pay a licence, (correct?). Is there some workaround for this?. All creative ideas welcome :) - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Licences for testing
Personal Oracle is indeed a product that needs to be licensed. -Original Message- Dave Sent: Friday, May 03, 2002 6:33 AM To: Multiple recipients of list ORACLE-L Would the personal edition work for you? I don't think there would be a licensing issue with this. Dave -Original Message- Sent: Friday, May 03, 2002 7:09 AM To: Multiple recipients of list ORACLE-L We're planning to set-up some test servers here and I'm wondering what the practice is out there regarding licences for same. This is only for short term testing and to try out various DR scenarios etc. I'd guess there's an Oracle view which would be if you install on server you pay a licence, (correct?). Is there some workaround for this?. All creative ideas welcome :) - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
RE: error testing jdbc connectin
Hi Charlie Via SQL*Plus I get connected without any problem via SQL*Net. When using the JdbcCheckup.java program,it sends back messages on whatever has gone through and one of them is the notification that it has connected successfully. If you look at the program which as I mentioned earlier on comes with the samples, you will notice that the next part is the selection of 'Hello world' from dual. Regards Tich -Original Message- Sent: 25 March 2002 09:55 To: [EMAIL PROTECTED] If I were faced with this situation, I'd tackle in in the following manner. Part of the reason is that on a good day I can only spell Java. IMO, you need to determine if you have a Java problem or a more basic SQL*Net problem. Unless until you can connect to the DB via SQL*Net using some other flavor of client s/w; such as SQL*Plus or Access, etc. I'd ignore the Java angle. Are you REALLY sure that it connetcts OK? Ticha Murehwa wrote: Hi all I hope you can help me out with this. I am running JdbcCheckup connection that comes as part of jdbc samples on oracle 9.0.1 I am running win2k and I get the following error.Unfortunately I dont have access to metalink. Can anyone help me out . Oracle 9i is the downloadable one on technet. The program connects fine but as soon as it does the select it gives this error Exception in thread main java.sql.SQLException: ORA-00600: internal error code , arguments: [ttcgcshnd-1], [0], [], [], [], [], [], [] at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168) at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208) at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543) at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1405) at oracle.jdbc.ttc7.TTC7Protocol.fetch(TTC7Protocol.java:889) at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.jav a:1681) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme nt.java:1870) at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java: 538) at JdbcCheckup.main(JdbcCheckup.java:55) Regards Tich -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ticha Murehwa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Charlie Mengler Maintenance Warehouse [EMAIL PROTECTED] 10641 Scripps Summit Ct. 858-831-2229 San Diego, CA 92131 Lead, follow, or at least have the courtesy to get out of my way! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ticha Murehwa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
error testing jdbc connectin
Hi all I hope you can help me out with this. I am running JdbcCheckup connection that comes as part of jdbc samples on oracle 9.0.1 I am running win2k and I get the following error.Unfortunately I dont have access to metalink. Can anyone help me out . Oracle 9i is the downloadable one on technet. The program connects fine but as soon as it does the select it gives this error Exception in thread main java.sql.SQLException: ORA-00600: internal error code , arguments: [ttcgcshnd-1], [0], [], [], [], [], [], [] at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168) at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208) at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543) at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1405) at oracle.jdbc.ttc7.TTC7Protocol.fetch(TTC7Protocol.java:889) at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.jav a:1681) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme nt.java:1870) at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java: 538) at JdbcCheckup.main(JdbcCheckup.java:55) Regards Tich -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ticha Murehwa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Load Testing Help Needed
Can anyone recommend and low cost tool(s) for load testing a database server? I looked at Quest's Benchmark Factory, but it doesn't provide the flexibility I need in this situation I'm facing The $15K I was quoted for the Quest tool is a bit pricey, so I don't believe more expensive tools (e.g., Load Runner) are viable candidates. Here's what I have to work with: I will have a log file from our mid tier server that will contain all the SQL generated by the application. However, since the system is not in production, I will be limited to using a single user or small group to simulate use of the application. Therefore, I will have to find a way to scale the limited capture to production-like levels and substitute values for transactions and queries. Can anyone recommend a tool(s) that would allow me to 1) automate substitution of values in WHERE clauses and INSERT/UPDATE statements and 2) perform load testing using ascii files as the input? TIA for your help, Ed _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Load Testing Help Needed
The low cost testing tool that will do the job is called sqlplus. Just develop your scripts and fire away -Original Message- From: Ed [mailto:[EMAIL PROTECTED]] Sent: Friday, March 22, 2002 8:23 AM To: Multiple recipients of list ORACLE-L Subject: Load Testing Help Needed Can anyone recommend and low cost tool(s) for load testing a database server? I looked at Quest's Benchmark Factory, but it doesn't provide the flexibility I need in this situation I'm facing The $15K I was quoted for the Quest tool is a bit pricey, so I don't believe more expensive tools (e.g., Load Runner) are viable candidates. Here's what I have to work with: I will have a log file from our mid tier server that will contain all the SQL generated by the application. However, since the system is not in production, I will be limited to using a single user or small group to simulate use of the application. Therefore, I will have to find a way to scale the limited capture to production-like levels and substitute values for transactions and queries. Can anyone recommend a tool(s) that would allow me to 1) automate substitution of values in WHERE clauses and INSERT/UPDATE statements and 2) perform load testing using ascii files as the input? TIA for your help, Ed _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Load Testing Help Needed
Check out Craig Shalamahar site www.orapub.com under tools. He got a free loadtesting tool. Cheers, RS Can anyone recommend and low cost tool(s) for load testing a database server? I looked at Quest's Benchmark Factory, but it doesn't provide the flexibility I need in this situation I'm facing The $15K I was quoted for the Quest tool is a bit pricey, so I don't believe more expensive tools (e.g., Load Runner) are viable candidates. Here's what I have to work with: I will have a log file from our mid tier server that will contain all the SQL generated by the application. However, since the system is not in production, I will be limited to using a single user or small group to simulate use of the application. Therefore, I will have to find a way to scale the limited capture to production-like levels and substitute values for transactions and queries. Can anyone recommend a tool(s) that would allow me to 1) automate substitution of values in WHERE clauses and INSERT/UPDATE statements and 2) perform load testing using ascii files as the input? TIA for your help, Ed _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sakthi , Raj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Load Testing Help Needed
Ed wrote: Can anyone recommend and low cost tool(s) for load testing a database server? I looked at Quest's Benchmark Factory, but it doesn't provide the flexibility I need in this situation I'm facing The $15K I was quoted for the Quest tool is a bit pricey, so I don't believe more expensive tools (e.g., Load Runner) are viable candidates. Here's what I have to work with: I will have a log file from our mid tier server that will contain all the SQL generated by the application. However, since the system is not in production, I will be limited to using a single user or small group to simulate use of the application. Therefore, I will have to find a way to scale the limited capture to production-like levels and substitute values for transactions and queries. Can anyone recommend a tool(s) that would allow me to 1) automate substitution of values in WHERE clauses and INSERT/UPDATE statements and 2) perform load testing using ascii files as the input? TIA for your help, Ed SALES_PLUG Ed, You can have a look at Simuload, which we have not developed but which we market, on the Oriole site (http://www.oriole.com). Compared to other products it's a bit crude (we contemplate wrapping it in a nice GUI in the future, it has been written by a hard-core Unix developer, ex-Digital, ex-Sun and now Oracle, and it shows), you may have a bit of work to do (wrapping SQL statements in PL/SQL procedures, chiefly) but it's not very expensive and gives results relatively easily. /SALES_PLUG -- Regards, Stephane Faroult Oriole Ltd -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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
testing -- NO MESSAGE
Kind Regards, Hatzistavrou Yannis -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hatzistavrou Giannis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
DELETE this message. I'm just testing my new address.
If you have opened this you obviously can't read. I'm just testing my new address. You should have read that in the subject and deleted this. DO NOT REPLY to this. If this message starts a thread then there are a number of you who need to go back to elementary school and learn to read. Rodd Holman For those of you wondering... The e-mail gods at my work started blocking ORACLE-L because of virus attachments and volume. I'm now using a free POP mailer to get around that problem. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodd Holman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: DELETE this message. I'm just testing my new address.
I be not read, what be virus? tanks. Rodd Holman wrote: If you have opened this you obviously can't read. I'm just testing my new address. You should have read that in the subject and deleted this. DO NOT REPLY to this. If this message starts a thread then there are a number of you who need to go back to elementary school and learn to read. Rodd Holman For those of you wondering... The e-mail gods at my work started blocking ORACLE-L because of virus attachments and volume. I'm now using a free POP mailer to get around that problem. -- Joe Testa, Oracle DBA Nothing new to put here, hmm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe 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: 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 ('
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 (' xx'); host sleep 60 commit; exit; And a shell script to run it. $ cat block.sh itr=1 echo $itr while : do sqlplus me/mypasswd@sid @blocktest itr=`expr $itr + 1 ` echo $itr if [ $itr -eq $1 ] then break fi done I've run starting up to the max processes allowed by the database, and still don't get the blocking lock on the database. If I can't get blocking locks to appear in a test situation, then I can't prove that increasing the freelists helps the situation. Any suggestions? -rje -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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).
Testing
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).
Testing
Testing to see if the server is working properly. Jared -- 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).
Ang: Testing
It is [EMAIL PROTECTED]@fatcity.com den 2001-11-30 10:40 PST Sänd svar till [EMAIL PROTECTED] Sänt av: [EMAIL PROTECTED] Till: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Kopia: Testing to see if the server is working properly. Jared -- 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: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Efficiency testing
Hi, Could somebody tell me what all to be considered for testing the efficiency of an Oracle database application ? Thanks and Regards Pradeep -- 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).
testing
test -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mario Brenes INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
testing new header
!! Please do not post Off Topic to this List !! ignore this message -- 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: OT: Application stress testing tool
Hi, look for WinRunner. I think it does that stuff and is scriptable (of course ;). [EMAIL PROTECTED] schrieb: Hello, Apologies for an off-topic posting. Does anybody have any positive or negative experience with any system stress testing tools? I do not mean DB stress testing (we have software fot that) but a test package for system with a fat GUI client? Need something that would simulate user input (keystrokes/mouse clicks), allow scripting, simulate multiple users and record results so that they can be analyzed later. Any info would be highly appreciated. Thanks, Val Gamerman. -- 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). - This Mail has been checked for Viruses Attention: Encrypted mails can NOT be checked! ** Diese Mail wurde auf Viren geprueft Hinweis: Verschluesselte mails koennen NICHT auf Viren geprueft werden! - -- | Regards, | | Stefan Jahnke | | BOV AG | | @:D2 Vodafone, Abt.: FBOM | | Tel.: 0211/533-4893| -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stefan Jahnke INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OT: Application stress testing tool
Hello, Apologies for an off-topic posting. Does anybody have any positive or negative experience with any system stress testing tools? I do not mean DB stress testing (we have software fot that) but a test package for system with a fat GUI client? Need something that would simulate user input (keystrokes/mouse clicks), allow scripting, simulate multiple users and record results so that they can be analyzed later. Any info would be highly appreciated. Thanks, Val Gamerman. -- 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: Application stress testing tool
SQA robot is suppose to be one of the best. Out of curiosity, what do you do on the DB end? Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 05, 2001 1:41 PM To: Multiple recipients of list ORACLE-L Hello, Apologies for an off-topic posting. Does anybody have any positive or negative experience with any system stress testing tools? I do not mean DB stress testing (we have software fot that) but a test package for system with a fat GUI client? Need something that would simulate user input (keystrokes/mouse clicks), allow scripting, simulate multiple users and record results so that they can be analyzed later. Any info would be highly appreciated. Thanks, Val Gamerman. -- 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: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
testing patch set 8.1.7.2.1 today
Anita, As you might have guessed from my poast earlier on the ORACLE-L, I applied the 8.1.7.2.1 patch set to the 81715 EE server last night (this morning). It had no effect - still receieved the same ORA-00600. I even set compatible=8.1.7.2.0 and bounced - no effect. I was working from home yesterday and I believe that Scott was working on the business case email. I just figured that most analysts would recommend that we first try the latest patchset. have a good weekend, Paul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Drake INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Testing posting to Oracle-L list...
Hi DBA's, I joined previously, but for some reason my membership was not activated. I've joined again and I'm checking if my membership is registered now. Regards, Denmark W. _ 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: Denmark Weatherburne INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Regression Testing at Oracle???
This seems to be standard practice any more... SIGH! But Oracle must be one of the worst offenders. I once was looking to implement Oracle Financials as a paying beta customer (Shouldn't this be a contradiction in terms?). Oracle was the alpha and Sequent Computer in Oregon was the original beta (Oracle and Sequent had a pretty tight relationship back then). The Sequent implementation was on their own servers running Dynix, a Unix derivative. Our implementation was to be a port to VAX/VMS. What a mess! Bug city and Oracle still wanted to charge us big bucks for beta software!! Oracle eventually dropped the VMS port and I believe the first commercial version of the Oracle Apps did not ship for another 2-3 years. I wonder, how many companies paid for Oracle's development costs? Steve Orr -Original Message- Sent: Thursday, July 26, 2001 9:29 AM To: Multiple recipients of list ORACLE-L regression testing?, heck we are the alpha/beta/regression testers :) joe [EMAIL PROTECTED] 07/26/01 10:35AM This makes me wonder: what kind of regression testing is implemented by oracle? Trial and error? It makes me wonder, oh it makes me wander (Stairway to Heaven) -Original Message- From: A. Bardeen [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 26, 2001 6:15 AM To: Multiple recipients of list ORACLE-L Subject: FYI: new alert regarding 8.1.7.2 patchset Note: 153172.1 ALERT: Do NOT Install 8.1.7.2.0 Patch Set on top of 8.1.7.1 8.1.7.2.0 Patch Set Does Not Install Correctly Over 8.1.7.1/8.1.7.1B This alert will be updated to indicate the current status of this problem. The modification history is shown at the END of the alert. Versions Affected ~ This problem affects the installation of the 8.1.7.2.0 Patch Set. Platforms Affected ~~ This problem affects the following platforms only: HPUX (Oracle 32 bit release) HPUX (Oracle 64 bit release) Compaq Tru64 Intel Solaris This problem does NOT affect the following platform: Sun Sparc Solaris (Oracle 32 bit release) 8.1.7.2 has not been released on any other platform yet. Other platforms will have this problem corrected prior to their 8.1.7.2 Patch Set being released. Description ~~~ If the 8.1.7.2.0 Patch Set is installed on top of either 8.1.7.1 or 8.1.7.1B then the patch set does not install correctly. No errors are reported during the installation but the Oracle version banner still shows the version to be 8.1.7.1. Likelihood of Occurrence You will encounter this problem if you install the 8.1.7.2.0 patch set on top of either 8.1.7.1 or 8.1.7.1B on any of the platforms listed above. You are STRONGLY advised NOT to install 8.1.7.2.0 on top of 8.1.7.1 releases until this issue is addressed. Possible Symptoms ~ The main visible symptoms of this issue are: a. The Oracle version banner still shows the RDBMS release to be 8.1.7.1 b. SELECT * FROM V$VERSION shows the release to be 8.1.7.1 c. Bugs fixed in 8.1.7.2 may still be encountered There may be additional symptoms not yet discovered as the resulting installation contains an untested combination of modules. Workaround ~~ The only workaround to this problem is to install 8.1.7.2.0 on top of an 8.1.7.0 Oracle installation. ie: If the current installation is at release 8.1.7.1, then you must reinstall 8.1.7.0 and then apply the 8.1.7.2 patch set. If you have already installed 8.1.7.2 on top of 8.1.7.1 then it is advisable to reinstall the base release (8.1.7.0) and then apply the patch set on top of this to get a proper 8.1.7.2 release installed. Patches ~~~ The affected patch sets will be re-released shortly with the version number 8.1.7.2.1. These updated patch sets will install on top of 8.1.7.1, 8.1.7.1B or 8.1.7.0. If possible please avoid upgrading until the revised patch sets are released. References ~~ Base bug reporting the install problem [BUG:1898001] Modification History: ~ 26-Jul-2001 Initial alert that 8.1.7.2 does not install over 8.1.7.1 __ Oracle Support Services . -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California
OTRE: Regression Testing at Oracle???
Supports my personal theory (no peer-reviewed work, yet, sorry Eric! :) that large corporations routinely get away with lots of things that you and I would get killed, sued, beat up, and/or besmirched for. -Original Message- Sent: Thursday, July 26, 2001 1:57 PM To: Multiple recipients of list ORACLE-L This seems to be standard practice any more... SIGH! But Oracle must be one of the worst offenders. I once was looking to implement Oracle Financials as a paying beta customer (Shouldn't this be a contradiction in terms?). Oracle was the alpha and Sequent Computer in Oregon was the original beta (Oracle and Sequent had a pretty tight relationship back then). The Sequent implementation was on their own servers running Dynix, a Unix derivative. Our implementation was to be a port to VAX/VMS. What a mess! Bug city and Oracle still wanted to charge us big bucks for beta software!! Oracle eventually dropped the VMS port and I believe the first commercial version of the Oracle Apps did not ship for another 2-3 years. I wonder, how many companies paid for Oracle's development costs? Steve Orr -Original Message- Sent: Thursday, July 26, 2001 9:29 AM To: Multiple recipients of list ORACLE-L regression testing?, heck we are the alpha/beta/regression testers :) joe [EMAIL PROTECTED] 07/26/01 10:35AM This makes me wonder: what kind of regression testing is implemented by oracle? Trial and error? It makes me wonder, oh it makes me wander (Stairway to Heaven) -Original Message- From: A. Bardeen [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 26, 2001 6:15 AM To: Multiple recipients of list ORACLE-L Subject: FYI: new alert regarding 8.1.7.2 patchset Note: 153172.1 ALERT: Do NOT Install 8.1.7.2.0 Patch Set on top of 8.1.7.1 8.1.7.2.0 Patch Set Does Not Install Correctly Over 8.1.7.1/8.1.7.1B This alert will be updated to indicate the current status of this problem. The modification history is shown at the END of the alert. Versions Affected ~ This problem affects the installation of the 8.1.7.2.0 Patch Set. Platforms Affected ~~ This problem affects the following platforms only: HPUX (Oracle 32 bit release) HPUX (Oracle 64 bit release) Compaq Tru64 Intel Solaris This problem does NOT affect the following platform: Sun Sparc Solaris (Oracle 32 bit release) 8.1.7.2 has not been released on any other platform yet. Other platforms will have this problem corrected prior to their 8.1.7.2 Patch Set being released. Description ~~~ If the 8.1.7.2.0 Patch Set is installed on top of either 8.1.7.1 or 8.1.7.1B then the patch set does not install correctly. No errors are reported during the installation but the Oracle version banner still shows the version to be 8.1.7.1. Likelihood of Occurrence You will encounter this problem if you install the 8.1.7.2.0 patch set on top of either 8.1.7.1 or 8.1.7.1B on any of the platforms listed above. You are STRONGLY advised NOT to install 8.1.7.2.0 on top of 8.1.7.1 releases until this issue is addressed. Possible Symptoms ~ The main visible symptoms of this issue are: a. The Oracle version banner still shows the RDBMS release to be 8.1.7.1 b. SELECT * FROM V$VERSION shows the release to be 8.1.7.1 c. Bugs fixed in 8.1.7.2 may still be encountered There may be additional symptoms not yet discovered as the resulting installation contains an untested combination of modules. Workaround ~~ The only workaround to this problem is to install 8.1.7.2.0 on top of an 8.1.7.0 Oracle installation. ie: If the current installation is at release 8.1.7.1, then you must reinstall 8.1.7.0 and then apply the 8.1.7.2 patch set. If you have already installed 8.1.7.2 on top of 8.1.7.1 then it is advisable to reinstall the base release (8.1.7.0) and then apply the patch set on top of this to get a proper 8.1.7.2 release installed. Patches ~~~ The affected patch sets will be re-released shortly with the version number 8.1.7.2.1. These updated patch sets will install on top of 8.1.7.1, 8.1.7.1B or 8.1.7.0. If possible please avoid upgrading until the revised patch sets are released. References ~~ Base bug reporting the install problem [BUG:1898001] Modification History: ~ 26-Jul-2001 Initial alert that 8.1.7.2 does not install over 8.1.7.1
Testing
Testing -- 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).
FW: Testing
-Original Message- Sent: Friday, 29 June 2001 10:11 AM To: 'Multiple recipients of list ORACLE-L'; 'LazyDBA mailing list' Testing -- 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).
Testing
Testing -- 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).
system requirement for performance testing
Hi, We r building a application and need to specify the requirements of a hardware for testing of its performance. our performace metric includes mostly insert statements 10 million insert to 7 tables...then we have to execute some procedures...then report. our main concern is insert...we can't use any bulk inserts...all inserts will be thru application insert statements. Here is the brief test information 10 million insert now taking about 26 hrs for 127,000 accounts with this pace it will take about 40 days only(if everything go well) for insert while we need to finish this in less than 20 days...this test is on 1 cpu single hard disk..512Mb ram..this insert is a single user activity.batch processing.. database size is estimated to be about 400G not much complex stored proceduresonly worry is insert.. we generally use DELL machines.we need to use NT only.. I will appreciate if u give some suggestion with ur experience... information i need is : 1) number of hard disks ...how much capacity each 2) how many cpu's.. 3) how much RAM.. I need to explain the management for each request so kindly include the reason for each request. 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).
testing - delete
see? just a test -- 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).
OCP Testing Software
I have used SelfTest Software in the past to prepare for the OCP tests. Is there another similar company that is as good or better? Thanks, Ken Janusz, CPIM -- 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).
Testing tools
Hello if there any testing tools for QA staff / developer to test on bulk data which can measure it performance,efficient.of the program/PLSQL/sqlscript ??? The function of the tools is , prepare bulk data , testing , generate report . If no such tools , what might be an advice ? Becoz we intend to setup up a ISO 9001 standard on testing environment and testing technique. Anyone go through this before ? or any white paper about this ? Raymond fall asleep in waiting for the Q. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raymond Lee Meng Hong INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Testing - Pls ignore
This is a test. * * * * * 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).
Testing, please delete
Just testing, not understanding why I was bounced ;) -- 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).
testing RMAN == 2 databases in 1 Machine
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).
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).