Re: Snapshot too old during stress test... how to avoid
... and if it still doesn't work, use the trick of putting a transaction in each of the rollback segments while the system is otherwise quiesced, and *do not* commit or rollback the transactions. This forces the rollbacks to extend if necessary, they will never wrap back to the first extent ( actually the second) as long as those transactions are not committed. It just uses a lot of disk space. Disk is cheap, right? :) Consider offlining all your production RBS and creating temporary ones that you can easily drop later. I've used it with SAP client copies, which will not run to completion without doing this, at least on our system. Jared Kirtikumar Deshpande [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/04/2003 09:45 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Snapshot too old during stress test... how to avoid Try removing optimal setting, and shrinking RBS to the min extents (or even below) before running your tests. - Kirti --- Garry Gillies [EMAIL PROTECTED] wrote: From memory (of a course attended looong ago), Oracle recommends one rollback segment for every three to four users. Four rollback segments between thirty six processes does seem a little mean. Garry [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 04/06/03 13:59 Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Snapshot too old during stress test... how to avoid Im testing worst case scenarios right now. So Im doing batch updates,inserts,deletes and 'create table as' from a staging tablespace of approximately 5GBs to a master tablespace of approximately 11GBs. Ive got my job queue processes set to 36 and Im running 36 at a time in the background in order to gather statistics and timing under worst case scenarios. Im in 8.1.7.3 and I have increased the size of my RBS tablespace to 11GB for this test. I have 4 standard RBS with optimal size set to 1GB. Why would I get a snapshot too old? I would think that 11GBs of rollback would be big enough. Would increasing the number of Rollback segments avoid this even though I have the same amount of space in the tablespace? In reality Im going to seriallize the process to avoid this and to improve performance, however, I want to stress the system. any advice? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande 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: 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: Snapshot too old during stress test... how to avoid
Speaking of this trick with a txn in each RBS, I've got a shell script on my website (http://www.evdbt.com/tools.htm) that does just that. It is named prevent1555.sh which uses a stored procedure created by a SQL script named prevent1555_ddl.sql... As Jared mentioned, it is kind of a last resort, but it works... on 6/4/03 4:05 PM, [EMAIL PROTECTED] at [EMAIL PROTECTED] wrote: .. and if it still doesn't work, use the trick of putting a transaction in each of the rollback segments while the system is otherwise quiesced, and *do not* commit or rollback the transactions. This forces the rollbacks to extend if necessary, they will never wrap back to the first extent ( actually the second) as long as those transactions are not committed. It just uses a lot of disk space. Disk is cheap, right? :) Consider offlining all your production RBS and creating temporary ones that you can easily drop later. I've used it with SAP client copies, which will not run to completion without doing this, at least on our system. Jared Kirtikumar Deshpande [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/04/2003 09:45 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Snapshot too old during stress test... how to avoid Try removing optimal setting, and shrinking RBS to the min extents (or even below) before running your tests. - Kirti --- Garry Gillies [EMAIL PROTECTED] wrote: From memory (of a course attended looong ago), Oracle recommends one rollback segment for every three to four users. Four rollback segments between thirty six processes does seem a little mean. Garry [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 04/06/03 13:59 Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Snapshot too old during stress test... how to avoid Im testing worst case scenarios right now. So Im doing batch updates,inserts,deletes and 'create table as' from a staging tablespace of approximately 5GBs to a master tablespace of approximately 11GBs. Ive got my job queue processes set to 36 and Im running 36 at a time in the background in order to gather statistics and timing under worst case scenarios. Im in 8.1.7.3 and I have increased the size of my RBS tablespace to 11GB for this test. I have 4 standard RBS with optimal size set to 1GB. Why would I get a snapshot too old? I would think that 11GBs of rollback would be big enough. Would increasing the number of Rollback segments avoid this even though I have the same amount of space in the tablespace? In reality Im going to seriallize the process to avoid this and to improve performance, however, I want to stress the system. any advice? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- 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: OCP Test Order
Title: RE: OCP Test Order to tell the truth the networking exam is basically some rote memorization and the questions are straightforward - I prepared while waiting 1/2 hour to take exam at most. The performance tuning exam is what I have been told to immediately forget by some certifiable guru's. Basically, not all of it is incorrect but this will be one area you will be studying again from time to time as new versions and new information becomes available and with your own experiences - IMHO. Bottom-line: Don't think it much matters the perf. tuning exam is slightly more to remember then networking. Good luck. Just get it done and don't fret too much about it. It won't and shouldn't be your final studying by a long-shot. I did BR first because it was my #1 priority and I believe the most applicable - good refresher. I did Perf. tuning next. I did networking as a get this over with certification thing. -Original Message- From: Jay Wade [mailto:[EMAIL PROTECTED]] Sent: Monday, June 02, 2003 5:35 PM To: Multiple recipients of list ORACLE-L Subject: OCP Test Order Hello: I resently finished my 8i Backup and Recovery test and was thinking about taking the 8i Networking testing before performance tuning. I was wondering if those of you that have taken both test feel that would be an ok choice of action or would taking performance tuning first be better? Thanks In Advance, jay _ Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Wade 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).
test delete
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: James Howerton 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).
Snapshot too old during stress test... how to avoid
Im testing worst case scenarios right now. So Im doing batch updates,inserts,deletes and 'create table as' from a staging tablespace of approximately 5GBs to a master tablespace of approximately 11GBs. Ive got my job queue processes set to 36 and Im running 36 at a time in the background in order to gather statistics and timing under worst case scenarios. Im in 8.1.7.3 and I have increased the size of my RBS tablespace to 11GB for this test. I have 4 standard RBS with optimal size set to 1GB. Why would I get a snapshot too old? I would think that 11GBs of rollback would be big enough. Would increasing the number of Rollback segments avoid this even though I have the same amount of space in the tablespace? In reality Im going to seriallize the process to avoid this and to improve performance, however, I want to stress the system. any advice? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] 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).
OCP Test Order
Hello: I resently finished my 8i Backup and Recovery test and was thinking about taking the 8i Networking testing before performance tuning. I was wondering if those of you that have taken both test feel that would be an ok choice of action or would taking performance tuning first be better? Thanks In Advance, jay _ Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Wade 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: OCP Test Order
Jay - Personally I did the Tuning exam next after BR and saved the Network for last because most of it is new to me. The BR and Tuning exams share quite a bit of material in terms of they both require a clear understanding of the Oracle architecture, how the rollback, redo, SGA, etc. all interact. Obviously the thrust of the questions are different, with the BR emphasizing integrity and Tuning emphasizing performance. Networking doesn't share anything with the other modules other than it touches on MTS. So I would vote to go ahead and hit the Tuning next. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, June 02, 2003 4:35 PM To: Multiple recipients of list ORACLE-L Hello: I resently finished my 8i Backup and Recovery test and was thinking about taking the 8i Networking testing before performance tuning. I was wondering if those of you that have taken both test feel that would be an ok choice of action or would taking performance tuning first be better? Thanks In Advance, jay _ Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Wade 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: DENNIS WILLIAMS 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: Test
You passed!! Ruth - Original Message !- From: Scott Stefick To: Multiple recipients of list ORACLE-L Sent: Friday, March 21, 2003 4:28 PM Subject: Test This is a test, I have not received any messages in the last couple of days.-Scott**Scott StefickOracle Certified DBAWm. Rainey Harper College847.925.6130**-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Scott Stefick 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).
Test
Test
This is a test, I have not received any messages in the last couple of days. -Scott ** Scott Stefick Oracle Certified DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Stefick 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).
Test - Delete me
Test
Re: Test - Delete me
delete from oracle-l where subscriber = 'Gene Sais'; commit; select count(*) from oracle-l where subscriber = 'Gene Sais'; COUNT(*) -- 0 -- Daniel W. Fink http://www.optimaldba.com IOUG-A Live! April 27 - May 1, 2003 Orlando, FL Sunday, April 27 8:30am - 4:30pm - Problem Solving with Oracle 9i SQL Wednesday, May 1 1:00pm - 2:00pm - Automatic Undo Internals Gene Sais wrote:
RE: Test - Delete me
a small technical mistake :-) delete from "oracle-l" where subscriber = 'Gene Sais'; ^ "-" is not allowed in identifiers ;-) Regards Naveen -Original Message-From: Daniel W. Fink [mailto:[EMAIL PROTECTED]Sent: Wednesday, March 19, 2003 11:57 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Test - Delete medelete from oracle-l where subscriber = 'Gene Sais';commit;select count(*) from oracle-lwhere subscriber = 'Gene Sais'; COUNT(*)-- 0-- Daniel W. Fink http://www.optimaldba.com IOUG-A Live! April 27 - May 1, 2003 Orlando, FL Sunday, April 27 8:30am - 4:30pm - Problem Solving with Oracle 9i SQL Wednesday, May 1 1:00pm - 2:00pm - Automatic Undo InternalsGene Sais wrote: DISCLAIMER:This message (including attachment if any) is confidential and may be privileged. Before opening attachments please check them for viruses and defects. MindTree Consulting Private Limited (MindTree) will not be responsible for any viruses or defects or any forwarded attachments emanating either from within MindTree or outside. If you have received this message by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission.
TEST -- just ignore
test
Yahoo! Mobile - Exchange IMs with Messenger friends on your Telstra or Vodafone mobile phone.
test
Yahoo! Mobile - Exchange IMs with Messenger friends on your Telstra or Vodafone mobile phone.
test - pls Ignore
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Basavaraja, Ravindra 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).
test msg . pl ignore
Hi, This is test msg. pl. ignore. srinivas __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: kommareddy sreenivasa 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).
test
Regards, Daljit You can contact me at Office : [EMAIL PROTECTED] Res : [EMAIL PROTECTED]
Where are the scripts located to create the SCOTT test objects?
I have a user that is using the SCOTT test tables on one of our dev databases. He is apparently missing the DEPT table. Where are the scripts that create the SCOTT tables? I tried looking through the on-line documentation and Metalink to no avail. Can anyone point me in the right direction? Thanks, Cherie Machler Oracle DBA Gelco Information Network -- 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: Where are the scripts located to create the SCOTT test objects?
Cherie: Check $ORACLE_HOME/sqlplus/demo/demobld.sql --Kevin -Original Message- [EMAIL PROTECTED] Sent: Tuesday, January 21, 2003 8:25 AM To: Multiple recipients of list ORACLE-L I have a user that is using the SCOTT test tables on one of our dev databases. He is apparently missing the DEPT table. Where are the scripts that create the SCOTT tables? I tried looking through the on-line documentation and Metalink to no avail. Can anyone point me in the right direction? Thanks, Cherie Machler Oracle DBA Gelco Information Network -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kevin Tsay 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: Where are the scripts located to create the SCOTT test objects?
Kevin, Thanks. Just what the Dr. ordered. Cherie Kevin Tsay [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] 2.mfn.com cc: Sent by: Subject: RE: Where are the scripts located to create the SCOTT [EMAIL PROTECTED] test objects? 01/21/03 01:31 PM Please respond to ORACLE-L Cherie: Check $ORACLE_HOME/sqlplus/demo/demobld.sql --Kevin -Original Message- [EMAIL PROTECTED] Sent: Tuesday, January 21, 2003 8:25 AM To: Multiple recipients of list ORACLE-L I have a user that is using the SCOTT test tables on one of our dev databases. He is apparently missing the DEPT table. Where are the scripts that create the SCOTT tables? I tried looking through the on-line documentation and Metalink to no avail. Can anyone point me in the right direction? Thanks, Cherie Machler Oracle DBA Gelco Information Network -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kevin Tsay 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: 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: Where are the scripts located to create the SCOTT test objects?
In rdbms/admin there's a file called scott.sql, there's also a utlsampl.sql in the same place. [EMAIL PROTECTED]@fatcity.com on 01/21/2003 11:24:32 AM Please respond to [EMAIL PROTECTED] Sent by:[EMAIL PROTECTED] To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: I have a user that is using the SCOTT test tables on one of our dev databases. He is apparently missing the DEPT table. Where are the scripts that create the SCOTT tables? I tried looking through the on-line documentation and Metalink to no avail. Can anyone point me in the right direction? Thanks, Cherie Machler Oracle DBA Gelco Information Network -- 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). -- 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: Where are the scripts located to create the SCOTT test object
Hi Cherie, May be this is what you mean. Create table Dept (DEPTNO NOT NULL NUMBER(2), DNAME VARCHAR2(14), LOC VARCHAR2(13)) Rgrds, Sony -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, January 21, 2003 11:25 PM To: Multiple recipients of list ORACLE-L Subject: Where are the scripts located to create the SCOTT test objects? I have a user that is using the SCOTT test tables on one of our dev databases. He is apparently missing the DEPT table. Where are the scripts that create the SCOTT tables? I tried looking through the on-line documentation and Metalink to no avail. Can anyone point me in the right direction? Thanks, Cherie Machler Oracle DBA Gelco Information Network -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sony kristanto 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: Where are the scripts located to create the SCOTT test object
You can re-create all the tables using the script SCOTT.SQL in \rdbms\admin Sony kristanto [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/22/03 07:58 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Where are the scripts located to create the SCOTT test object Hi Cherie, May be this is what you mean. Create table Dept (DEPTNO NOT NULL NUMBER(2), DNAME VARCHAR2(14), LOC VARCHAR2(13)) Rgrds, Sony -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, January 21, 2003 11:25 PM To: Multiple recipients of list ORACLE-L Subject: Where are the scripts located to create the SCOTT test objects? I have a user that is using the SCOTT test tables on one of our dev databases. He is apparently missing the DEPT table. Where are the scripts that create the SCOTT tables? I tried looking through the on-line documentation and Metalink to no avail. Can anyone point me in the right direction? Thanks, Cherie Machler Oracle DBA Gelco Information Network -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sony kristanto 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: Where are the scripts located to create the SCOTT test object
%Oralce_home%\sqlplus\demo\demobld.sql HTH nirmal. -Original Message- Sent: Wednesday, January 22, 2003 5:29 AM To: Multiple recipients of list ORACLE-L Hi Cherie, May be this is what you mean. Create table Dept (DEPTNO NOT NULL NUMBER(2), DNAME VARCHAR2(14), LOC VARCHAR2(13)) Rgrds, Sony -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, January 21, 2003 11:25 PM To: Multiple recipients of list ORACLE-L Subject: Where are the scripts located to create the SCOTT test objects? I have a user that is using the SCOTT test tables on one of our dev databases. He is apparently missing the DEPT table. Where are the scripts that create the SCOTT tables? I tried looking through the on-line documentation and Metalink to no avail. Can anyone point me in the right direction? Thanks, Cherie Machler Oracle DBA Gelco Information Network -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sony kristanto 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: Nirmal Kumar Muthu Kumaran 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: test this email ad
Here is a quote from my Damager when I send him the link to this marvelous product: " Where do I signup. At a buck and three quarters an hour I'll replace all of you slackards." And told him he will probably get what he paid for :) - Kirti -Original Message-From: Fink, Dan [mailto:[EMAIL PROTECTED]]Sent: Wednesday, January 08, 2003 4:30 PMTo: Multiple recipients of list ORACLE-LSubject: RE: test this email ad Tim, I think you are wasting your time. A threat from Dick is meaningless...cause they appear not to know Dick! I checked their website. Instead of 'Contact Us' it says 'Contacts Us' on each page...And I'm going to trust them to monitor my database? -Original Message-From: Johnston, Tim [mailto:[EMAIL PROTECTED]]Sent: Wednesday, January 08, 2003 2:59 PMTo: Multiple recipients of list ORACLE-LSubject: RE: test this email ad Um... This looks like a sales critter post... So, let's test it... Tell me Paul... Exactly why is this tool so wonderful??? And, a simple cut and paste of marketing material won't do... What exactly does it do for you that is so wonderful???How does it free up your time???FYI, if you are a sales critter, you shouldn't post this kind of stuff unless you have some idea of what you'reare talking about... We do have a couple sales critters around but they maintain a fairly low profile and actually contribute to the list... And whatever you do don't get get on Dick's bad side... Right Dick? :-) Tim
Re:RE: test this email ad
The first time I read this it did not make sense, but now the light bulb has finally come on. I'll just add these folks to the s%$list. Dick Goulet Reply Separator Sent: Wednesday, January 08, 2003 4:30 PM To: Multiple recipients of list ORACLE-L Tim, I think you are wasting your time. A threat from Dick is meaningless...cause they appear not to know Dick! I checked their website. Instead of 'Contact Us' it says 'Contacts Us' on each page...And I'm going to trust them to monitor my database? -Original Message- Sent: Wednesday, January 08, 2003 2:59 PM To: Multiple recipients of list ORACLE-L Um... This looks like a sales critter post... So, let's test it... Tell me Paul... Exactly why is this tool so wonderful??? And, a simple cut and paste of marketing material won't do... What exactly does it do for you that is so wonderful??? How does it free up your time??? FYI, if you are a sales critter, you shouldn't post this kind of stuff unless you have some idea of what you're are talking about... We do have a couple sales critters around but they maintain a fairly low profile and actually contribute to the list... And whatever you do don't get get on Dick's bad side... Right Dick? :-) Tim !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEAD META HTTP-EQUIV=Content-Type CONTENT=text/html; charset=iso-8859-1 META content=MSHTML 5.50.4134.600 name=GENERATOR/HEAD BODY bgColor=#ff leftMargin=70 topMargin=0 marginheight=0 marginwidth=70 DIVSPAN class=211281917-09012003FONT face=Arial color=#ff size=2Here is a quote from my Damager when I send him the link to this marvelous product:/FONT/SPAN/DIV DIVSPAN class=211281917-09012003FONT face=Arial color=#ff size=2/FONT/SPANnbsp;/DIV DIVSPAN class=211281917-09012003FONT face=Arial color=#ff size=2 /FONTFONT face=ArialFONT color=#ffFONT size=2SPAN class=211281917-09012003W/SPANhere do I signup. At a buck and three quarters an hour I'll replace all of you slackards. /FONT/FONT/FONT/SPAN/DIV DIVSPAN class=211281917-09012003FONT face=Arial color=#ff size=2/FONT/SPANnbsp;/DIV DIVSPAN class=211281917-09012003FONT face=Arial color=#ff size=2And told him he will probably get what he paid for :) /FONT/SPAN/DIV DIVSPAN class=211281917-09012003/SPANSPAN class=211281917-09012003FONT face=Arial color=#ff size=2/FONT/SPANnbsp;/DIV DIVSPAN class=211281917-09012003FONT face=Arial color=#ff size=2- Kirti/FONT/SPAN/DIV DIVSPAN class=211281917-09012003FONT face=Arial color=#ff size=2/FONT/SPANnbsp;/DIV DIV class=OutlookMessageHeader dir=ltr align=leftFONT face=Tahoma size=2-Original Message-BRBFrom:/B Fink, Dan [mailto:[EMAIL PROTECTED]]BRBSent:/B Wednesday, January 08, 2003 4:30 PMBRBTo:/B Multiple recipients of list ORACLE-LBRBSubject:/B RE: test this email adBRBR/FONT/DIV DIVFONT face=Arial color=#ff size=2SPAN class=409202822-08012003Tim,/SPAN/FONT/DIV DIVFONT face=Arial color=#ff size=2SPAN class=409202822-08012003nbsp;nbsp;nbsp; I think you are wasting your time. A threat from Dick is meaningless...cause they appear not to know Dick!/SPAN/FONT/DIV DIVFONT face=Arial color=#ff size=2SPAN class=409202822-08012003nbsp;nbsp;nbsp; I checked their website. Instead of 'Contact Us' it says 'Contacts Us' on each page...And I'm going to trust them to monitor my database? /SPAN/FONT/DIV BLOCKQUOTE dir=ltr style=MARGIN-RIGHT: 0px DIV class=OutlookMessageHeader dir=ltr align=leftFONT face=Tahoma size=2-Original Message-BRBFrom:/B Johnston, Tim [mailto:[EMAIL PROTECTED]]BRBSent:/B Wednesday, January 08, 2003 2:59 PMBRBTo:/B Multiple recipients of list ORACLE-LBRBSubject:/B RE: test this email adBRBR/FONT/DIV DIVSPAN class=469575821-08012003FONT face=Arial color=#ff size=2Um...nbsp; This looks like a sales critter post...nbsp; So, let's test it...nbsp; Tell me Paul...nbsp; Exactly why is this tool so wonderful???nbsp; And, a simple cut and paste of marketing material won't do...nbsp; What exactly does it do for you that is so wonderful???nbsp;nbsp;How does it free up your time???nbsp;nbsp;FYI, if you are a sales critter, you shouldn't post this kind of stuff unless you have some idea of what you'renbsp;are talking about...nbsp; We do have a couple sales critters around but they maintain a fairly low profile and actually contribute to the list...nbsp; And whatever you do don't get get on Dick's bad side...nbsp; Right Dick?/FONT/SPAN/DIV DIVSPAN class=469575821-08012003FONT face=Arial color=#ff size=2/FONT/SPANnbsp;/DIV DIVSPAN class=469575821-08012003FONT face=Arial color=#ff size=2:-)/FONT/SPAN/DIV DIVSPAN class=469575821-08012003FONT face=Arial color=#ff size=2/FONT/SPANnbsp;/DIV DIVSPAN class=469575821-08012003FONT face=Arial color=#ff size=2Tim/FONT/SPAN/DIV BLOCKQUOTE dir=ltr style=MARGIN-RIGHT: 0px DIV class
RE: RE: test this email ad
For those not familiar with American Slang, saying You don't know dick. means You don't know anything. It was a pun I just could not resist... -Original Message- Sent: Thursday, January 09, 2003 11:06 AM To: Multiple recipients of list ORACLE-L The first time I read this it did not make sense, but now the light bulb has finally come on. I'll just add these folks to the s%$list. Dick Goulet Reply Separator Sent: Wednesday, January 08, 2003 4:30 PM To: Multiple recipients of list ORACLE-L Tim, I think you are wasting your time. A threat from Dick is meaningless...cause they appear not to know Dick! I checked their website. Instead of 'Contact Us' it says 'Contacts Us' on each page...And I'm going to trust them to monitor my database? -Original Message- Sent: Wednesday, January 08, 2003 2:59 PM To: Multiple recipients of list ORACLE-L Um... This looks like a sales critter post... So, let's test it... Tell me Paul... Exactly why is this tool so wonderful??? And, a simple cut and paste of marketing material won't do... What exactly does it do for you that is so wonderful??? How does it free up your time??? FYI, if you are a sales critter, you shouldn't post this kind of stuff unless you have some idea of what you're are talking about... We do have a couple sales critters around but they maintain a fairly low profile and actually contribute to the list... And whatever you do don't get get on Dick's bad side... Right Dick? :-) Tim !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEAD META HTTP-EQUIV=Content-Type CONTENT=text/html; charset=iso-8859-1 META content=MSHTML 5.50.4134.600 name=GENERATOR/HEAD BODY bgColor=#ff leftMargin=70 topMargin=0 marginheight=0 marginwidth=70 DIVSPAN class=211281917-09012003FONT face=Arial color=#ff size=2Here is a quote from my Damager when I send him the link to this marvelous product:/FONT/SPAN/DIV DIVSPAN class=211281917-09012003FONT face=Arial color=#ff size=2/FONT/SPANnbsp;/DIV DIVSPAN class=211281917-09012003FONT face=Arial color=#ff size=2 /FONTFONT face=ArialFONT color=#ffFONT size=2SPAN class=211281917-09012003W/SPANhere do I signup. At a buck and three quarters an hour I'll replace all of you slackards. /FONT/FONT/FONT/SPAN/DIV DIVSPAN class=211281917-09012003FONT face=Arial color=#ff size=2/FONT/SPANnbsp;/DIV DIVSPAN class=211281917-09012003FONT face=Arial color=#ff size=2And told him he will probably get what he paid for :) /FONT/SPAN/DIV DIVSPAN class=211281917-09012003/SPANSPAN class=211281917-09012003FONT face=Arial color=#ff size=2/FONT/SPANnbsp;/DIV DIVSPAN class=211281917-09012003FONT face=Arial color=#ff size=2- Kirti/FONT/SPAN/DIV DIVSPAN class=211281917-09012003FONT face=Arial color=#ff size=2/FONT/SPANnbsp;/DIV DIV class=OutlookMessageHeader dir=ltr align=leftFONT face=Tahoma size=2-Original Message-BRBFrom:/B Fink, Dan [mailto:[EMAIL PROTECTED]]BRBSent:/B Wednesday, January 08, 2003 4:30 PMBRBTo:/B Multiple recipients of list ORACLE-LBRBSubject:/B RE: test this email adBRBR/FONT/DIV DIVFONT face=Arial color=#ff size=2SPAN class=409202822-08012003Tim,/SPAN/FONT/DIV DIVFONT face=Arial color=#ff size=2SPAN class=409202822-08012003nbsp;nbsp;nbsp; I think you are wasting your time. A threat from Dick is meaningless...cause they appear not to know Dick!/SPAN/FONT/DIV DIVFONT face=Arial color=#ff size=2SPAN class=409202822-08012003nbsp;nbsp;nbsp; I checked their website. Instead of 'Contact Us' it says 'Contacts Us' on each page...And I'm going to trust them to monitor my database? /SPAN/FONT/DIV BLOCKQUOTE dir=ltr style=MARGIN-RIGHT: 0px DIV class=OutlookMessageHeader dir=ltr align=leftFONT face=Tahoma size=2-Original Message-BRBFrom:/B Johnston, Tim [mailto:[EMAIL PROTECTED]]BRBSent:/B Wednesday, January 08, 2003 2:59 PMBRBTo:/B Multiple recipients of list ORACLE-LBRBSubject:/B RE: test this email adBRBR/FONT/DIV DIVSPAN class=469575821-08012003FONT face=Arial color=#ff size=2Um...nbsp; This looks like a sales critter post...nbsp; So, let's test it...nbsp; Tell me Paul...nbsp; Exactly why is this tool so wonderful???nbsp; And, a simple cut and paste of marketing material won't do...nbsp; What exactly does it do for you that is so wonderful???nbsp;nbsp;How does it free up your time???nbsp;nbsp;FYI, if you are a sales critter, you shouldn't post this kind of stuff unless you have some idea of what you'renbsp;are talking about...nbsp; We do have a couple sales critters around but they maintain a fairly low profile and actually contribute to the list...nbsp; And whatever you do don't get get on Dick's bad side...nbsp; Right Dick?/FONT/SPAN/DIV DIVSPAN class=469575821-08012003FONT face=Arial color=#ff size=2/FONT/SPANnbsp;/DIV DIVSPAN class=469575821-08012003FONT face=Arial color=#ff size=2
Re: RE: test this email ad
I thought that was Jack. Maybe you don't know Jack. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, January 09, 2003 1:44 PM For those not familiar with American Slang, saying You don't know dick. means You don't know anything. It was a pun I just could not resist... -Original Message- Sent: Thursday, January 09, 2003 11:06 AM To: Multiple recipients of list ORACLE-L The first time I read this it did not make sense, but now the light bulb has finally come on. I'll just add these folks to the s%$list. Dick Goulet Reply Separator Sent: Wednesday, January 08, 2003 4:30 PM To: Multiple recipients of list ORACLE-L Tim, I think you are wasting your time. A threat from Dick is meaningless...cause they appear not to know Dick! I checked their website. Instead of 'Contact Us' it says 'Contacts Us' on each page...And I'm going to trust them to monitor my database? -Original Message- Sent: Wednesday, January 08, 2003 2:59 PM To: Multiple recipients of list ORACLE-L Um... This looks like a sales critter post... So, let's test it... Tell me Paul... Exactly why is this tool so wonderful??? And, a simple cut and paste of marketing material won't do... What exactly does it do for you that is so wonderful??? How does it free up your time??? FYI, if you are a sales critter, you shouldn't post this kind of stuff unless you have some idea of what you're are talking about... We do have a couple sales critters around but they maintain a fairly low profile and actually contribute to the list... And whatever you do don't get get on Dick's bad side... Right Dick? :-) Tim !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEAD META HTTP-EQUIV=Content-Type CONTENT=text/html; charset=iso-8859-1 META content=MSHTML 5.50.4134.600 name=GENERATOR/HEAD BODY bgColor=#ff leftMargin=70 topMargin=0 marginheight=0 marginwidth=70 DIVSPAN class=211281917-09012003FONT face=Arial color=#ff size=2Here is a quote from my Damager when I send him the link to this marvelous product:/FONT/SPAN/DIV DIVSPAN class=211281917-09012003FONT face=Arial color=#ff size=2/FONT/SPANnbsp;/DIV DIVSPAN class=211281917-09012003FONT face=Arial color=#ff size=2 /FONTFONT face=ArialFONT color=#ffFONT size=2SPAN class=211281917-09012003W/SPANhere do I signup. At a buck and three quarters an hour I'll replace all of you slackards. /FONT/FONT/FONT/SPAN/DIV DIVSPAN class=211281917-09012003FONT face=Arial color=#ff size=2/FONT/SPANnbsp;/DIV DIVSPAN class=211281917-09012003FONT face=Arial color=#ff size=2And told him he will probably get what he paid for :) /FONT/SPAN/DIV DIVSPAN class=211281917-09012003/SPANSPAN class=211281917-09012003FONT face=Arial color=#ff size=2/FONT/SPANnbsp;/DIV DIVSPAN class=211281917-09012003FONT face=Arial color=#ff size=2- Kirti/FONT/SPAN/DIV DIVSPAN class=211281917-09012003FONT face=Arial color=#ff size=2/FONT/SPANnbsp;/DIV DIV class=OutlookMessageHeader dir=ltr align=leftFONT face=Tahoma size=2-Original Message-BRBFrom:/B Fink, Dan [mailto:[EMAIL PROTECTED]]BRBSent:/B Wednesday, January 08, 2003 4:30 PMBRBTo:/B Multiple recipients of list ORACLE-LBRBSubject:/B RE: test this email adBRBR/FONT/DIV DIVFONT face=Arial color=#ff size=2SPAN class=409202822-08012003Tim,/SPAN/FONT/DIV DIVFONT face=Arial color=#ff size=2SPAN class=409202822-08012003nbsp;nbsp;nbsp; I think you are wasting your time. A threat from Dick is meaningless...cause they appear not to know Dick!/SPAN/FONT/DIV DIVFONT face=Arial color=#ff size=2SPAN class=409202822-08012003nbsp;nbsp;nbsp; I checked their website. Instead of 'Contact Us' it says 'Contacts Us' on each page...And I'm going to trust them to monitor my database? /SPAN/FONT/DIV BLOCKQUOTE dir=ltr style=MARGIN-RIGHT: 0px DIV class=OutlookMessageHeader dir=ltr align=leftFONT face=Tahoma size=2-Original Message-BRBFrom:/B Johnston, Tim [mailto:[EMAIL PROTECTED]]BRBSent:/B Wednesday, January 08, 2003 2:59 PMBRBTo:/B Multiple recipients of list ORACLE-LBRBSubject:/B RE: test this email adBRBR/FONT/DIV DIVSPAN class=469575821-08012003FONT face=Arial color=#ff size=2Um...nbsp; This looks like a sales critter post...nbsp; So, let's test it...nbsp; Tell me Paul...nbsp; Exactly why is this tool so wonderful???nbsp; And, a simple cut and paste of marketing material won't do...nbsp; What exactly does it do for you that is so wonderful???nbsp;nbsp;How does it free up your time???nbsp;nbsp;FYI, if you are a sales critter, you shouldn't post this kind of stuff unless you have some idea of what you'renbsp;are talking about...nbsp; We do have a couple sales critters around but they maintain a fairly low profile and actually contribute to the list...nbsp
RE: RE: test this email ad
HTH === If someone ever says You don't know Jack Shit, here is the perfect response. Who is Jack Schitt? The lineage is finally revealed. Many people are at a loss for a response when someone says You don't know Jack Schitt. Now you can intellectually handle the situation. Jack is the only son of Awe Schitt and O. Schitt. Awe Schitt, the fertilizer magnate, married O. Schitt, the owner of Needeep N.Schitt, Inc. They had one son, Jack. In turn, Jack Schitt married Noe Schitt, and the deeply religious couple produced 6 children: Holie Schitt, Fulla Schitt, Giva Schitt, Bull Schitt and the twins: Deap Schitt and Dip Schitt. Against her parent's objections, Deap Schitt married Dumb Schitt, a high school drop out. After being married 15 years, Jack and Noe Schitt divorced. Noe Schitt later married Ted Sherlock, and because her kids were living with them, she wanted to keep her previous name. She was then known as Noe Schitt-Sherlock. Meanwhile, Dip Schitt married Loda Schitt and they produced a son of nervous disposition, Chicken Schitt. Two other of the 6 children... Fulla Schitt and Giva Schitt... were inseparable throughout childhood and subsequently married the Happens Brothers in a dual ceremony. The wedding announcement in the newspaper announced the Schitt-Happens wedding. The Schitt-Happens children were Dawg, Byrd, and Hoarse. Bull Schitt, the prodigal son, left home to tour the world. He recently returned from Italy with his new Italian bride, Pisa Schitt. So now when someone says, You don't know Jack Schitt, you can correct them. Family History recorded by Crock O. Schitt -Original Message- Sent: Thursday, January 09, 2003 2:19 PM To: Multiple recipients of list ORACLE-L I thought that was Jack. Maybe you don't know Jack. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, January 09, 2003 1:44 PM For those not familiar with American Slang, saying You don't know dick. means You don't know anything. It was a pun I just could not resist... -Original Message- Sent: Thursday, January 09, 2003 11:06 AM To: Multiple recipients of list ORACLE-L The first time I read this it did not make sense, but now the light bulb has finally come on. I'll just add these folks to the s%$list. Dick Goulet Reply Separator Sent: Wednesday, January 08, 2003 4:30 PM To: Multiple recipients of list ORACLE-L Tim, I think you are wasting your time. A threat from Dick is meaningless...cause they appear not to know Dick! I checked their website. Instead of 'Contact Us' it says 'Contacts Us' on each page...And I'm going to trust them to monitor my database? -Original Message- Sent: Wednesday, January 08, 2003 2:59 PM To: Multiple recipients of list ORACLE-L Um... This looks like a sales critter post... So, let's test it... Tell me Paul... Exactly why is this tool so wonderful??? And, a simple cut and paste of marketing material won't do... What exactly does it do for you that is so wonderful??? How does it free up your time??? FYI, if you are a sales critter, you shouldn't post this kind of stuff unless you have some idea of what you're are talking about... We do have a couple sales critters around but they maintain a fairly low profile and actually contribute to the list... And whatever you do don't get get on Dick's bad side... Right Dick? :-) Tim !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEAD META HTTP-EQUIV=Content-Type CONTENT=text/html; charset=iso-8859-1 META content=MSHTML 5.50.4134.600 name=GENERATOR/HEAD BODY bgColor=#ff leftMargin=70 topMargin=0 marginheight=0 marginwidth=70 DIVSPAN class=211281917-09012003FONT face=Arial color=#ff size=2Here is a quote from my Damager when I send him the link to this marvelous product:/FONT/SPAN/DIV DIVSPAN class=211281917-09012003FONT face=Arial color=#ff size=2/FONT/SPANnbsp;/DIV DIVSPAN class=211281917-09012003FONT face=Arial color=#ff size=2 /FONTFONT face=ArialFONT color=#ffFONT size=2SPAN class=211281917-09012003W/SPANhere do I signup. At a buck and three quarters an hour I'll replace all of you slackards. /FONT/FONT/FONT/SPAN/DIV DIVSPAN class=211281917-09012003FONT face=Arial color=#ff size=2/FONT/SPANnbsp;/DIV DIVSPAN class=211281917-09012003FONT face=Arial color=#ff size=2And told him he will probably get what he paid for :) /FONT/SPAN/DIV DIVSPAN class=211281917-09012003/SPANSPAN class=211281917-09012003FONT face=Arial color=#ff size=2/FONT/SPANnbsp;/DIV DIVSPAN class=211281917-09012003FONT face=Arial color=#ff size=2- Kirti/FONT/SPAN/DIV DIVSPAN class=211281917-09012003FONT face=Arial color=#ff size=2/FONT/SPANnbsp;/DIV DIV class=OutlookMessageHeader dir=ltr align=leftFONT face=Tahoma size=2-Original Message-BRBFrom
Re[2]: RE: test this email ad
Ruth, That's Jack Sh^. Dick Goulet Reply Separator Author: Ruth Gramolini [EMAIL PROTECTED] Date: 1/9/2003 11:19 AM I thought that was Jack. Maybe you don't know Jack. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, January 09, 2003 1:44 PM For those not familiar with American Slang, saying You don't know dick. means You don't know anything. It was a pun I just could not resist... -Original Message- Sent: Thursday, January 09, 2003 11:06 AM To: Multiple recipients of list ORACLE-L The first time I read this it did not make sense, but now the light bulb has finally come on. I'll just add these folks to the s%$list. Dick Goulet Reply Separator Sent: Wednesday, January 08, 2003 4:30 PM To: Multiple recipients of list ORACLE-L Tim, I think you are wasting your time. A threat from Dick is meaningless...cause they appear not to know Dick! I checked their website. Instead of 'Contact Us' it says 'Contacts Us' on each page...And I'm going to trust them to monitor my database? -Original Message- Sent: Wednesday, January 08, 2003 2:59 PM To: Multiple recipients of list ORACLE-L Um... This looks like a sales critter post... So, let's test it... Tell me Paul... Exactly why is this tool so wonderful??? And, a simple cut and paste of marketing material won't do... What exactly does it do for you that is so wonderful??? How does it free up your time??? FYI, if you are a sales critter, you shouldn't post this kind of stuff unless you have some idea of what you're are talking about... We do have a couple sales critters around but they maintain a fairly low profile and actually contribute to the list... And whatever you do don't get get on Dick's bad side... Right Dick? :-) Tim !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEAD META HTTP-EQUIV=Content-Type CONTENT=text/html; charset=iso-8859-1 META content=MSHTML 5.50.4134.600 name=GENERATOR/HEAD BODY bgColor=#ff leftMargin=70 topMargin=0 marginheight=0 marginwidth=70 DIVSPAN class=211281917-09012003FONT face=Arial color=#ff size=2Here is a quote from my Damager when I send him the link to this marvelous product:/FONT/SPAN/DIV DIVSPAN class=211281917-09012003FONT face=Arial color=#ff size=2/FONT/SPANnbsp;/DIV DIVSPAN class=211281917-09012003FONT face=Arial color=#ff size=2 /FONTFONT face=ArialFONT color=#ffFONT size=2SPAN class=211281917-09012003W/SPANhere do I signup. At a buck and three quarters an hour I'll replace all of you slackards. /FONT/FONT/FONT/SPAN/DIV DIVSPAN class=211281917-09012003FONT face=Arial color=#ff size=2/FONT/SPANnbsp;/DIV DIVSPAN class=211281917-09012003FONT face=Arial color=#ff size=2And told him he will probably get what he paid for :) /FONT/SPAN/DIV DIVSPAN class=211281917-09012003/SPANSPAN class=211281917-09012003FONT face=Arial color=#ff size=2/FONT/SPANnbsp;/DIV DIVSPAN class=211281917-09012003FONT face=Arial color=#ff size=2- Kirti/FONT/SPAN/DIV DIVSPAN class=211281917-09012003FONT face=Arial color=#ff size=2/FONT/SPANnbsp;/DIV DIV class=OutlookMessageHeader dir=ltr align=leftFONT face=Tahoma size=2-Original Message-BRBFrom:/B Fink, Dan [mailto:[EMAIL PROTECTED]]BRBSent:/B Wednesday, January 08, 2003 4:30 PMBRBTo:/B Multiple recipients of list ORACLE-LBRBSubject:/B RE: test this email adBRBR/FONT/DIV DIVFONT face=Arial color=#ff size=2SPAN class=409202822-08012003Tim,/SPAN/FONT/DIV DIVFONT face=Arial color=#ff size=2SPAN class=409202822-08012003nbsp;nbsp;nbsp; I think you are wasting your time. A threat from Dick is meaningless...cause they appear not to know Dick!/SPAN/FONT/DIV DIVFONT face=Arial color=#ff size=2SPAN class=409202822-08012003nbsp;nbsp;nbsp; I checked their website. Instead of 'Contact Us' it says 'Contacts Us' on each page...And I'm going to trust them to monitor my database? /SPAN/FONT/DIV BLOCKQUOTE dir=ltr style=MARGIN-RIGHT: 0px DIV class=OutlookMessageHeader dir=ltr align=leftFONT face=Tahoma size=2-Original Message-BRBFrom:/B Johnston, Tim [mailto:[EMAIL PROTECTED]]BRBSent:/B Wednesday, January 08, 2003 2:59 PMBRBTo:/B Multiple recipients of list ORACLE-LBRBSubject:/B RE: test this email adBRBR/FONT/DIV DIVSPAN class=469575821-08012003FONT face=Arial color=#ff size=2Um...nbsp; This looks like a sales critter post...nbsp; So, let's test it...nbsp; Tell me Paul...nbsp; Exactly why is this tool so wonderful???nbsp; And, a simple cut and paste of marketing material won't do...nbsp; What exactly does it do for you that is so wonderful???nbsp;nbsp;How does it free up your time???nbsp;nbsp;FYI, if you are a sales critter, you shouldn't post this kind of stuff unless you have some idea of what
RE: test this email ad (OT -- helpful tip for list)
BTW, for those of you stuck with MS Lookout as your e-mail reader, you can prevent the senseless download of images when viewing/previewing these HTML messages, whose links often contain encoded IDs so the authors get better ways to track you down and sell your e-mail addresses. 1. In IE, under File, check Work Offline. 2. Use a real browser. 3. See also http://www.grotto11.com/blog/?+1039831658 for an article on MS's lack of RFC compliance. 4. Tell Oracle Corp not to use MS-specific code in their web pages! Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Wednesday, January 08, 2003 3:07 PM To: Multiple recipients of list ORACLE-L Guys and Gays I just started working for this company and they have a really cool DBA appliance. It for up my time to do other DBA stuff. Paul OCP Monitors database health, performance, host, space, audit, response, stand-by and security events including BSTAT/ESTAT and STATSPACK.For a FREE TRIAL: Contact's Name Email Address This information will only be used for contacting you about this product by Pinnacle Data. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich 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).
FW: test this email ad
Guys and Gays I just started working for this company and they have a really cool DBA appliance. Itfor up my time to do other DBA stuff. Paul OCP Monitors database health, performance, host, space, audit, response, stand-by and security events including BSTAT/ESTAT and STATSPACK. For a FREE TRIAL: Contact's Name Email Address This information will only be used for contacting you about this product by Pinnacle Data. DBA-in-a-Box warns you of hundreds of database issues before they become a problem; protecting your assets. Customized filtering of events and threshold settings. No Software is installed on your system. Free Hardware, setup and upgrades. You and your DBA's can focus more on other critical business operations. DBA-in-a-Box sends alerts to your e-mail, PDA, cell phone, and pager. DBA-in-a-Box costs $1.75 per hour, User defines times of operation. For more information:Click here for our product brochure (pdf)or Visit our website _ -- 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). __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net --*. http://join.msn.com/?page=features/featuredemail
RE: test this email ad
Um... This looks like a sales critter post... So, let's test it... Tell me Paul... Exactly why is this tool so wonderful??? And, a simple cut and paste of marketing material won't do... What exactly does it do for you that is so wonderful???How does it free up your time???FYI, if you are a sales critter, you shouldn't post this kind of stuff unless you have some idea of what you'reare talking about... We do have a couple sales critters around but they maintain a fairly low profile and actually contribute to the list... And whatever you do don't get get on Dick's bad side... Right Dick? :-) Tim -Original Message-From: Dessources Paul [mailto:[EMAIL PROTECTED]]Sent: Wednesday, January 08, 2003 3:07 PMTo: Multiple recipients of list ORACLE-LSubject: FW: test this email ad Guys and Gays I just started working for this company and they have a really cool DBA appliance. Itfor up my time to do other DBA stuff. Paul OCP Monitors database health, performance, host, space, audit, response, stand-by and security events including BSTAT/ESTAT and STATSPACK. For a FREE TRIAL: Contact's Name Email Address This information will only be used for contacting you about this product by Pinnacle Data. DBA-in-a-Box warns you of hundreds of database issues before they become a problem; protecting your assets. Customized filtering of events and threshold settings. No Software is installed on your system. Free Hardware, setup and upgrades. You and your DBA's can focus more on other critical business operations. DBA-in-a-Box sends alerts to your e-mail, PDA, cell phone, and pager. DBA-in-a-Box costs $1.75 per hour, User defines times of operation. For more information:Click here for our product brochure (pdf)or Visit our website _ -- 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). __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net --*. http://join.msn.com/?page=features/featuredemail
RE: test this email ad
Tim, I think you are wasting your time. A threat from Dick is meaningless...cause they appear not to know Dick! I checked their website. Instead of 'Contact Us' it says 'Contacts Us' on each page...And I'm going to trust them to monitor my database? -Original Message-From: Johnston, Tim [mailto:[EMAIL PROTECTED]]Sent: Wednesday, January 08, 2003 2:59 PMTo: Multiple recipients of list ORACLE-LSubject: RE: test this email ad Um... This looks like a sales critter post... So, let's test it... Tell me Paul... Exactly why is this tool so wonderful??? And, a simple cut and paste of marketing material won't do... What exactly does it do for you that is so wonderful???How does it free up your time???FYI, if you are a sales critter, you shouldn't post this kind of stuff unless you have some idea of what you'reare talking about... We do have a couple sales critters around but they maintain a fairly low profile and actually contribute to the list... And whatever you do don't get get on Dick's bad side... Right Dick? :-) Tim
RE: test this email ad
If I get a 'sales critter' type email, and it takes me 4 or 5 tries before I can decipher their version of English, then you can guarantee I won't buy their product.There is also a very good chance that I will actually recommend people NOT to use it. -Original Message-From: Fink, Dan [mailto:[EMAIL PROTECTED]]Sent: Wednesday, January 08, 2003 2:30 PMTo: Multiple recipients of list ORACLE-LSubject: RE: test this email ad Tim, I think you are wasting your time. A threat from Dick is meaningless...cause they appear not to know Dick! I checked their website. Instead of 'Contact Us' it says 'Contacts Us' on each page...And I'm going to trust them to monitor my database? -Original Message-From: Johnston, Tim [mailto:[EMAIL PROTECTED]]Sent: Wednesday, January 08, 2003 2:59 PMTo: Multiple recipients of list ORACLE-LSubject: RE: test this email ad Um... This looks like a sales critter post... So, let's test it... Tell me Paul... Exactly why is this tool so wonderful??? And, a simple cut and paste of marketing material won't do... What exactly does it do for you that is so wonderful???How does it free up your time???FYI, if you are a sales critter, you shouldn't post this kind of stuff unless you have some idea of what you'reare talking about... We do have a couple sales critters around but they maintain a fairly low profile and actually contribute to the list... And whatever you do don't get get on Dick's bad side... Right Dick? :-) Tim
RE: test this email ad
Guys and Gays Undskyld, please? - Kirti -Original Message-From: Dessources Paul [mailto:[EMAIL PROTECTED]]Sent: Wednesday, January 08, 2003 2:07 PMTo: Multiple recipients of list ORACLE-LSubject: FW: test this email ad Guys and Gays I just started working for this company and they have a really cool DBA appliance. Itfor up my time to do other DBA stuff. Paul OCP Monitors database health, performance, host, space, audit, response, stand-by and security events including BSTAT/ESTAT and STATSPACK. For a FREE TRIAL: Contact's Name Email Address This information will only be used for contacting you about this product by Pinnacle Data. DBA-in-a-Box warns you of hundreds of database issues before they become a problem; protecting your assets. Customized filtering of events and threshold settings. No Software is installed on your system. Free Hardware, setup and upgrades. You and your DBA's can focus more on other critical business operations. DBA-in-a-Box sends alerts to your e-mail, PDA, cell phone, and pager. DBA-in-a-Box costs $1.75 per hour, User defines times of operation. For more information:Click here for our product brochure (pdf)or Visit our website _ -- 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). __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net --*. http://join.msn.com/?page=features/featuredemail
Test please ignore
office -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed 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).
Test. please ignore
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
test (please ignore)
test please ignore __ Do you Yahoo!? Yahoo! Mail Plus Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: john 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).
test (please ignore)
test please ignore __ Do you Yahoo!? Yahoo! Mail Plus Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: john 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: test (please ignore)
Why do people do this? What is it that they are testing? And why should we ignore it and not each and every single one of us respond directly to such testers to express displeasure (without replying to the list)? Just a thought... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, November 23, 2002 9:13 AM test please ignore __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: john 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).
load runner test and database response mesurement
Hi, I am looking for a best database response measurment for load runner test, any comments are welcome. I am looking at response time per execution in OEM Capacity Planner, however how do I understand the report with massive executions come with very low response time per execution, while very low executions come with higher response time per execution during the load runner test? Thanks a lot. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Development and Test Database Licensing?
How doesOracle handle the licensing of the Dev andTest servers. Does an OTN license need to be purchased forthis or does the purchase of the production server license allow for theTest and Dev servers. thanks, caj From: Paulo Gomes To: Multiple recipients of list ORACLE-L Sent: Friday, November 08, 2002 1:25 PM Subject: RE: FW: developer 2000 THANKS Do u happen to know where can i get that? Regards Paulo -Original Message-From: Viktor [mailto:[EMAIL PROTECTED]]Sent: sexta-feira, 8 de Novembro de 2002 18:09To: Multiple recipients of list ORACLE-LSubject: Re: FW: developer 2000 I think you may need to get an upgraded installer version 3.3.1.1.0c. This is the one compatible with Y2K. Then, run the installer and select typical, and that should be it. Regards, Viktor Paulo Gomes [EMAIL PROTECTED] wrote: -Original Message- From: Paulo Gomes Sent: sexta-feira, 8 de Novembro de 2002 17:33 To: '[EMAIL PROTECTED]' Subject: developer 2000 -Original Message- From: Paulo Gomes Sent: sexta-feira, 8 de Novembro de 2002 17:31 To: '[EMAIL PROTECTED]' Subject: hi people now is my turn to ask for help. Just got some old forms that are still in developer 2000 version. Can't upgrade the client and have a win 2000 machine. Developer 2000 doesn't install in win 2000. Does anyone knows any trick to install Developer 2000 in win 2000? I DON'T WANT TO INSTALL A NEW NT MACHINE JUST FIX SOME LITTLE PROBLEM. Thanks in advance Regards Paulo-- Please see the official ORACLE-! ! L FAQ: http://www.orafaq.com-- Author: Paulo GomesINET: [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). Do you Yahoo!?U2 on LAUNCH - Exclusive medley videos from Greatest Hits CD
TEST pls-ignore
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dcutrone 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).
A test mesage - pls ignore
just to see if i can sendemail to the list - have got problems in teh last few emails ...
TEST -pls ignore
Test message: Please delete
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: test - please ignore
NO Yechiel AdarMehish - Original Message - From: Farnsworth, Dave To: Multiple recipients of list ORACLE-L Sent: Monday, September 09, 2002 5:18 PM Subject: RE: test - please ignore Can you hear me now Good ;o) -Original Message-From: Igor Neyman [mailto:[EMAIL PROTECTED]]Sent: Monday, September 09, 2002 9:38 AMTo: Multiple recipients of list ORACLE-LSubject: test - please ignore Just testing, I'm not getting any messages lately. Igor Neyman, OCP DBA[EMAIL PROTECTED]
RE: test - please ignore
Somebody say something??? peter -Original Message-From: Yechiel Adar [mailto:[EMAIL PROTECTED]]Sent: 12 September 2002 14:54To: Multiple recipients of list ORACLE-LSubject: Re: test - please ignore NO Yechiel AdarMehish - Original Message - From: Farnsworth, Dave To: Multiple recipients of list ORACLE-L Sent: Monday, September 09, 2002 5:18 PM Subject: RE: test - please ignore Can you hear me now Good ;o) -Original Message-From: Igor Neyman [mailto:[EMAIL PROTECTED]]Sent: Monday, September 09, 2002 9:38 AMTo: Multiple recipients of list ORACLE-LSubject: test - please ignore Just testing, I'm not getting any messages lately. Igor Neyman, OCP DBA[EMAIL PROTECTED] * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. The BGS cannot accept any responsibility for viruses, so please scan all attachments.http://www.bgs.ac.uk *
test-pls ignore
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Basavaraja, Ravindra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OEM: Is there a test to find broken dblinks?
Title: OEM: Is there a test to find broken dblinks? Hi All, I'm looking for an event test in OEM to find broken dblinks. Anyone know such? Thanks.
RE: Is there a test to find broken dblinks?
Title: OEM: Is there a test to find broken dblinks? That would be useful, as import drops package bodies when there are invalid db links in packages. Short of testing them manually one by one, I don't know of one. Import must be doing it though, when it tries to compile packages. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services | Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message-From: Sivan Rabinovitz [mailto:[EMAIL PROTECTED]]Sent: Tuesday, September 10, 2002 6:33 AMTo: Multiple recipients of list ORACLE-LSubject: OEM: Is there a test to find broken dblinks? Hi All, I'm looking for an event test in OEM to find broken dblinks. Anyone know such? Thanks.
test - please ignore
Just testing, I'm not getting any messages lately. Igor Neyman, OCP DBA[EMAIL PROTECTED]
RE: test - please ignore
Can you hear me now Good ;o) -Original Message-From: Igor Neyman [mailto:[EMAIL PROTECTED]]Sent: Monday, September 09, 2002 9:38 AMTo: Multiple recipients of list ORACLE-LSubject: test - please ignore Just testing, I'm not getting any messages lately. Igor Neyman, OCP DBA[EMAIL PROTECTED]
TEST -- pls ignore
Just a test ....
test
___ Yahoo! Messenger Nueva versión: Webcam, voz, y mucho más ¡Gratis! Descárgalo ya desde http://messenger.yahoo.es -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Pablo=20Rodriguez?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
test -- ignore
TEST
TEST
Test - pls Ignore
test - pls ignore
test ignore
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Denis Vasconcelos INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
test scenario # 1, dropped online redo logs
list, i will be testing various recovery scenarios on a test instance.. my db is in archive log.. i hv a cold backup, i created a table, inserted some records and switched the logfile.. (i dnt hv a hot backup) , then i deleted both the online redo logs. now i;m trying to re-create the controlfile (with resetlogs) but it fails with.. CREATE CONTROLFILE REUSE DATABASE ORACLE RESETLOGS ARCHIVELOG * ORA-01503: CREATE CONTROLFILE failed ORA-01158: database already mounted before i issue the create controlfile command... i do a . svrmgr30 startup nomount i have the following questions.. 1) why i'm getting this error 2) is re-creating the controlfile the *only* way out after the online logs are removed ? TIA rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
test scenario # 1, dropped online redo logs - UPDATE
i am able to re-create the control file .. but on doing recover database using backup controlfile the database is requesting a change# which was in the deleted online redo log !!! now what ??? -- From: Rahul Sent: Friday, August 16, 2002 1:57 PM To: 'Oracle List I' Subject: test scenario # 1, dropped online redo logs list, i will be testing various recovery scenarios on a test instance.. my db is in archive log.. i hv a cold backup, i created a table, inserted some records and switched the logfile.. (i dnt hv a hot backup) , then i deleted both the online redo logs. now i;m trying to re-create the controlfile (with resetlogs) but it fails with.. CREATE CONTROLFILE REUSE DATABASE ORACLE RESETLOGS ARCHIVELOG * ORA-01503: CREATE CONTROLFILE failed ORA-01158: database already mounted before i issue the create controlfile command... i do a . svrmgr30 startup nomount i have the following questions.. 1) why i'm getting this error 2) is re-creating the controlfile the *only* way out after the online logs are removed ? TIA rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: test scenario # 1, dropped online redo logs - UPDATE
try open resetlogs. you won't be able to fully recover but you might get the database open --- Rahul [EMAIL PROTECTED] wrote: i am able to re-create the control file .. but on doing recover database using backup controlfile the database is requesting a change# which was in the deleted online redo log !!! now what ??? -- From: Rahul Sent: Friday, August 16, 2002 1:57 PM To: 'Oracle List I' Subject:test scenario # 1, dropped online redo logs list, i will be testing various recovery scenarios on a test instance.. my db is in archive log.. i hv a cold backup, i created a table, inserted some records and switched the logfile.. (i dnt hv a hot backup) , then i deleted both the online redo logs. now i;m trying to re-create the controlfile (with resetlogs) but it fails with.. CREATE CONTROLFILE REUSE DATABASE ORACLE RESETLOGS ARCHIVELOG * ORA-01503: CREATE CONTROLFILE failed ORA-01158: database already mounted before i issue the create controlfile command... i do a . svrmgr30 startup nomount i have the following questions.. 1) why i'm getting this error 2) is re-creating the controlfile the *only* way out after the online logs are removed ? TIA rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
TEST
Hi. This is a test mail to see if my subscription was successful. Sorry to bother. Cesar Aracena CE / MCSE+I Neuquen, Argentina +54.299.6356688 +54.299.4466621
Re: Exporting stats for a production server to a dev/test server
Jack, Were your old statistics generated with the ANALYZE command? If yes, were you able to export ALL of the old statistics with the export option of DBMS_STATS before you actually analyzed with DBMS_STATS for the first time? If yes, after exporting them, did you delete the old statistics using the delete option of ANALYZE command before gathering new statistics using DBMS_STATS? Thanks, Cherie Machler Oracle DBA Gelco Information Network Jack Silvey jack_silvey@y To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ahoo.comcc: Sent by: Subject: Re: Exporting stats for a production server to a dev/test [EMAIL PROTECTED]server om 07/07/02 08:58 PM Please respond to ORACLE-L We just used it with great success to test our new analyze strategy. You can label each set of stats, and quickly switch between different analyze levels. Store your old stats first and you can always fall back if necessary. Jack --- [EMAIL PROTECTED] wrote: Hi Can anyone give feedback good or bad on the dbms_stats feature of exporting statistics. Is there any gotcha's or does it work well 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 = 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. -- 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). __ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack Silvey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command
Re: Exporting stats for a production server to a dev/test server
Cherie,
Great name.
Our initial stats were generated with the ANALYZE
command. We did export all the stats with the
dbms_stats - one parameter of the GATHER_TABLE_STATS
procedure is CASCADE, which picks up the index and
column stats too. Please test first on your own system
to make sure this is true for your version and setup.
We did not delete the stats before doing the new, what
we did was this:
1) export the old stats
2) analyze using a new sample, cascade, with histos
3) export the new stats (with a new label)
4) test, reimport the old and new stats as necessary
Do this quick test to show yourself what it can do:
a) create table tester.statstest as select * from
dba_tables;
b) create index tester.statstestidx on
statstest(table_name);
c) analyze table tester.statstest estimate statistics
sample 1 percent for table for all indexes for all
columns size 254;
d) create the stats holding table in the tester schema
using
DBMS_STATS.CREATE_STAT_TABLE('tester','stats','tsuser01')
e) export the stats using
DBMS_STATS.EXPORT_TABLE_STATS('tester','statstest',null,'stats','1pcttest',true,null);
f) select * from tester.stats to see what is stored
g) analyze table tester.statstest delete statistics;
h) import the stats using
DBMS_STATS.IMPORT_TABLE_STATS('tester','statstest',null,'stats','1pcttest',true,null);
i) select * from dba_tables, dba_indexes,
dba_tab_histograms to see what was imported
You can store multiple versions of stats for the same
table with different lables ('1pctest' in the example)
but if you try to store stats with the same label it
will overwrite.
We did have some data dictionary locking issues trying
to import multiple partitions of the same table at the
same time, but our db has suspect dd issues anyway, so
this might just be a feature of our system.
hth,
Jack
--- [EMAIL PROTECTED] wrote:
Jack,
Were your old statistics generated with the ANALYZE
command? If yes, were
you able to export ALL of the old statistics with
the export option of
DBMS_STATS before you actually analyzed with
DBMS_STATS for the first time?
If yes, after exporting them, did you delete the old
statistics using the
delete option of ANALYZE command before gathering
new statistics using
DBMS_STATS?
Thanks,
Cherie Machler
Oracle DBA
Gelco Information Network
Jack Silvey
jack_silvey@y To:
Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
ahoo.comcc:
Sent by: Subject:
Re: Exporting stats for a production server to a
dev/test
[EMAIL PROTECTED]server
om
07/07/02 08:58
PM
Please respond
to ORACLE-L
We just used it with great success to test our new
analyze strategy. You can label each set of stats,
and
quickly switch between different analyze levels.
Store
your old stats first and you can always fall back if
necessary.
Jack
--- [EMAIL PROTECTED] wrote:
Hi
Can anyone give feedback good or bad on the
dbms_stats feature of
exporting statistics. Is there any gotcha's or
does
it work well
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
Exporting stats for a production server to a dev/test server
Hi Can anyone give feedback good or bad on the dbms_stats feature of exporting statistics. Is there any gotcha's or does it work well 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 = 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. -- 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: Exporting stats for a production server to a dev/test server
We just used it with great success to test our new analyze strategy. You can label each set of stats, and quickly switch between different analyze levels. Store your old stats first and you can always fall back if necessary. Jack --- [EMAIL PROTECTED] wrote: Hi Can anyone give feedback good or bad on the dbms_stats feature of exporting statistics. Is there any gotcha's or does it work well 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 = 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. -- 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). __ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack Silvey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Exporting stats for a production server to a dev/test server
I've used 1 month ago on Oracle817 without any problem. --- [EMAIL PROTECTED] a écrit : Hi Can anyone give feedback good or bad on the dbms_stats feature of exporting statistics. Is there any gotcha's or does it work well 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 = 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. -- 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). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
test - Ignore it !
Title: Message
just test. Igonore it !
RE: test
Test complete - you have been assimilated. -The borg -Original Message- Sent: 21 June 2002 16:53 To: Multiple recipients of list ORACLE-L test -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: test
Injecting Bio-nuerogenic agent into Borg Collective. Freedom Rocks! Assimilation sucks! Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration Author: Oracle9i New Features Mastering Oracle8i Clark Griswold: Eddie, has anyone ever told you that you're bad luck? Cousin Eddie: Those were my mother's dying words. But I guess if your body's covered in third degree burns, and your foot's caught in a bear trap, you tend to start talkin' crazy. -Original Message- Sent: Friday, June 21, 2002 1:57 PM To: Multiple recipients of list ORACLE-L Test complete - you have been assimilated. -The borg -Original Message- Sent: 21 June 2002 16:53 To: Multiple recipients of list ORACLE-L test -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Bitmap vs btree - how to tell? how to test?
low cardinality -- good candidate for bitmap. little or no updates to the column being indexed -- good candidate for bitmap low cardinality is relative -- 10,000 distinct values in a 300m row table is low, 100 distinct values in a 10K row table might be high but the main criteria I have found is whether or not the column is updated because when you update the values in a bitmap index, it's not just the one row in the index that is updated but the entire segment of the bitmap. And THAT can lock the index on you. Rachel --- Jack Silvey [EMAIL PROTECTED] wrote: Listers, We are creating indexes on a 300m row fact table today. I am researching bitmap versus btree (again) to see where the latest info points. Anyone care to comment on the way to determine whether an index should be a btree or a bitmap? Anyone even know a good way to test this? thx, /jack __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack Silvey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Bitmap vs btree - how to tell? how to test?
On 2002.05.25 17:38 Rachel Carmichael wrote: low cardinality -- good candidate for bitmap. little or no updates to the column being indexed -- good candidate for bitmap low cardinality is relative -- 10,000 distinct values in a 300m row table is low, 100 distinct values in a 10K row table might be high but the main criteria I have found is whether or not the column is updated because when you update the values in a bitmap index, it's not just the one row in the index that is updated but the entire segment of the bitmap. And THAT can lock the index on you. Rachel Well, it doesn't exactly lock the whole index, it locks only the rows that have the same bitmap value as the row that is being updated. For a low cardinality column, that may mean locking down a significant portion of the index (and the underlying table, of course). That makes bitmap indexes (and indices) completely unsuitable for the OLTP environment. -- Mladen Gogala -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: TEST
Title: TEST Ahhh. I'm guessing that your employer is filtering out any email from these lists? How about if you set up your own free hotmail or yahoo account to use to participate in these lists, instead? I apologize for the curt email earlier, but I (and others) had assumed (always a bad thing to do!) that you were trying to test some thing (a program?) using the ORACLE-L email list as a guinea pig for your experiments. Again, my apologies... - Original Message - From: RAJESH DAYAL To: 'Tim Gorman' Sent: Friday, May 24, 2002 12:55 AM Subject: RE: TEST Hi Tim and list fellows, Thats not my purpose . I am not getting any mail from this mailing list (including this one). I dont know what to do !!! Sorry for inconvenience if any L, Rajesh -Original Message-From: Tim Gorman [mailto:[EMAIL PROTECTED]]Sent: Friday, May 24, 2002 5:37 AMTo: Rajesh DayalSubject: Re: TEST Rajesh, Please test to some other email address? You are annoying hundreds of people this way... Thanks! -Tim - Original Message - From: RAJESH DAYAL To: Multiple recipients of list ORACLE-L Sent: Thursday, May 23, 2002 8:53 AM Subject: TEST TEST ...
Bitmap vs btree - how to tell? how to test?
Listers, We are creating indexes on a 300m row fact table today. I am researching bitmap versus btree (again) to see where the latest info points. Anyone care to comment on the way to determine whether an index should be a btree or a bitmap? Anyone even know a good way to test this? thx, /jack __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack Silvey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Bitmap vs btree - how to tell? how to test?
I am on leave from May 29 to July 15. Please contact Jaspreet Jajj at x4338 for any query. Thanks. Anand Prakash -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anand Prakash INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Bitmap vs btree - how to tell? how to test?
I am on leave from May 29 to July 15. Please contact Jaspreet Jajj at x4338 for any query. Thanks. Anand Prakash -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anand Prakash INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Bitmap vs btree - how to tell? how to test?
LOL Autoreply. I hope that they can block this guy PDQ or we'll be swamped. Anand Prakash AnandPrakashTo: Multiple recipients of list ORACLE-L @firsthealth.[EMAIL PROTECTED] com cc: Sent by: rootSubject: Re: Bitmap vs btree - how to tell? how to test? 05/24/2002 02:00 PM Please respond to ORACLE-L I am on leave from May 29 to July 15. Please contact Jaspreet Jajj at x4338 for any query. Thanks. Anand Prakash -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anand Prakash INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Thomas Day INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Bitmap vs btree - how to tell? how to test?
Either that, or we can contact Jaspreet. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, May 24, 2002 2:29 PM To: Multiple recipients of list ORACLE-L LOL Autoreply. I hope that they can block this guy PDQ or we'll be swamped. Anand Prakash AnandPrakashTo: Multiple recipients of list ORACLE-L @firsthealth.[EMAIL PROTECTED] com cc: Sent by: rootSubject: Re: Bitmap vs btree - how to tell? how to test? 05/24/2002 02:00 PM Please respond to ORACLE-L I am on leave from May 29 to July 15. Please contact Jaspreet Jajj at x4338 for any query. Thanks. Anand Prakash -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anand Prakash INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Thomas Day INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Bitmap vs btree - how to tell? how to test?
I am on leave from May 27 to July 15. Please contact Jaspreet Jajj at x4338 for any query. Thanks. Anand Prakash -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anand Prakash INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Bitmap vs btree - how to tell? how to test?
He's just been put in digest mode. It's good to be king. ;) Jared On Friday 24 May 2002 11:28, Thomas Day wrote: LOL Autoreply. I hope that they can block this guy PDQ or we'll be swamped. Anand Prakash AnandPrakashTo: Multiple recipients of list ORACLE-L @firsthealth.[EMAIL PROTECTED] com cc: Sent by: rootSubject: Re: Bitmap vs btree - how to tell? how to test? 05/24/2002 02:00 PM Please respond to ORACLE-L I am on leave from May 29 to July 15. Please contact Jaspreet Jajj at x4338 for any query. Thanks. Anand Prakash -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anand Prakash INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
TEST
Title: TEST TEST
Re: TEST
This is a production system, do your testing somewhere else. Jared ;^) RAJESH DAYAL [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/23/2002 07:53 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:TEST TEST -- 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).
test
Title: test Testing .
RE: test
Can I have a copy of three or so test result sets that you have compiled? ;P Thanks! Mark -Original Message- Sent: 22 May 2002 12:43 To: Multiple recipients of list ORACLE-L Testing . -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: test
very... -Original Message- Sent: 22 May 2002 12:43 To: Multiple recipients of list ORACLE-L Testing . -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: TEST
you've been ignored, forever RAJESH DAYAL wrote: TESTING .. PLS IGNORE . -- 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: TEST
Title: TEST What are you testing? -Original Message-From: RAJESH DAYAL [mailto:[EMAIL PROTECTED]]Sent: Monday, May 20, 2002 11:18 AMTo: Multiple recipients of list ORACLE-LSubject: TEST TESTING ...
RE: TEST
Your shift key is not working correctly -Original Message- Sent: Monday, May 20, 2002 1:18 AM To: Multiple recipients of list ORACLE-L TESTING ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schilling, Ben INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
TEST
Title: TEST TESTING ...
Test - Please Ignore
Test Mail --- Madhavan Amruthur Outgrown your current e-mail service? Get a 25MB Inbox, POP3 Access, No Ads and No Taglines with LYCOS MAIL PLUS. http://login.mail.lycos.com/brandPage.shtml?pageId=plus -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Madhavan Amruthur INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: pl/sql is INTERPRETED?- java test
Practices books, then perhaps they will be good. But who the hell has free time? There is no free time on any project or effort that I know of!! I'm struggling with trying to improve my Oracle DBA skills, plus some developers skills so I can speak their language when they blow out OPEN_CURSORS or something. My head is swimming in the stupid technical alphabet soup, XML, XDK, XSQL, XSLT, XPath, SOAP, ASP, ADO, EJB, BC4J, JDBC, SQLJ, PSP, JVM, JSP, J2EE, EAD, RMI, CORBA, IIOP...and don't ask me what all those mean, because I can't keep them straight. But I do keep hearing that XML is going to put me out of a job, so I guess I should learn that...whatever that is. Isn't XML an add-on, or extension, or something to DML??? Now where the heck did I hide that bottle... -Original Message- Sent: Tuesday, April 30, 2002 12:15 PM To: Multiple recipients of list ORACLE-L Lisa, You are right about the debate between PL/SQL Java (or anything else outside of the db). In my mind, the deciding factor (and something that is *never* mentioned) is what programming langauage the organization is satisfied with/settled upon. In my little opinion, *any* programmer can learn PL/SQL in a very short period of time. This means that development and maintenance costs are relatively low. If an IT shop is stronger in Java, then they should probably program in Java, or Cobol, or Ada, or whatever the flavor of the decade happens to be (lets bring back APL!). IT tool selection/standards should be the deciding factor. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, April 30, 2002 11:34 AM To: Multiple recipients of list ORACLE-L This is something that's been debated on the list in the past. The general consensus was: For manipulating data in the database, nothing beats pl/sql. It is well suited for this purpose. For everything else, java could beat it. I am sure fellow list members will post links describing studies. I remember seeing these last year. Stefan, have you tried running your own test? There's a sure fire way to convince yourself. Even a small test (no fancy code) would suffice. Wish I had more time to play... Lisa Koivu Oracle Database Monkey Mama Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 -Original Message- From:Stefan Jahnke [SMTP:[EMAIL PROTECTED]] Sent:Tuesday, April 30, 2002 10:49 AM To:Multiple recipients of list ORACLE-L Subject: AW: pl/sql is INTERPRETED? Hi how about Java within Oracle. What do you think about it ? When does it make sense to use Java instead of PL/SQL ? The problem is that I dislike a mix of different languages within an application. It messes things up. But maybe it makes sense to use PL/SQL for most stuff and Java for some specific things (perhaps accessing a file or using a network resource ?). As far as I know, there is an option to compile the Java into platform dependend code, which would make it execute much faster then bytecode (and PL/SQL?), since the later has to be interpreted at run-time. Any opinions ? Regards, -Urspr|ngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Gesendet: Dienstag, 30. April 2002 16:09 An: Multiple recipients of list ORACLE-L Betreff: Re:pl/sql is INTERPRETED? Lisa, It is both true false at the same time. Obviously any anonymous blocks you submit to the database are fully interpreted. PL/SQL that you store in the database as procedures, functions, and packages get partially compiled into a p-code. This makes the code ready for execution, but retains a modular design so that if your DBA reloads catproc your code is not totally destroyed. Where I think PL/SQL buys us a lot of performance is in reducing the communications outside of the database that is otherwise needed. There's no JDBC driver or other miscellaneous mess (like SQL*Net) required. It's all handled inside the kernel. Now the bad part about PL/SQL that Java handles better is platform independence. You can run Java on your client, the apps server or database without a problem. PL/SQL on the other hand must be run in the database. Dick Goulet Reply Separator Author: Koivu; Lisa [EMAIL PROTECTED] Date: 4/29/2002 2:52 PM Can this be true? How can this be? If it's optimized to manipulate data within the database, how can it be fast if it's interpreted (like that slow
test - text file attachment / Re: ORACLE-L Digest -- Volume 2002, Number 123
what is factotum? ORACLE-L Digest -- Volume 2002, Number 123 -- From: Mercadante, Thomas F [EMAIL PROTECTED] Date: Thu, 2 May 2002 08:09:14 -0400 Subject: RE: ITS THE PHB, STPID (was: anti-virus spam) what - you changing careers - trying out for Denis Miller's show? TEST TEXT FILE ATTACHMENT FOR ORACLE-L ANTI-VIRUS SPAMMERS
