test please ignore
Test new oracle-l -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: EPS - DBA (Group) 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
oops! wrong list, eh? :) EPS - DBA (Group) [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/22/2004 11:39 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:test please ignore Test new oracle-l -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: EPS - DBA (Group) 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 mail -- plz. ignore
test mail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J 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
-test... We have been having mail problems. I've only had female problems. ;o) Dave -Original Message-From: Jeffrey Beckstrom [mailto:[EMAIL PROTECTED]Sent: Monday, January 12, 2004 9:29 PMTo: Multiple recipients of list ORACLE-LSubject: test test... We have been having mail problems. Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113
test
test... We have been having mail problems. Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113
Re: test
--- Jeffrey Beckstrom [EMAIL PROTECTED] wrote: test... We have been having mail problems. Jeffrey Beckstrom Database Administrator Greater Cleveland Regional Transit Authority 1240 W. 6th Street Cleveland, Ohio 44113 yeah, I had 2 posts not go through today ... unless I'm blocking my own posts. mmm, could be ... Pd __ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Drake 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
switched emails. just testing.
test - please ignore
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: IT - Database (Do Not Use) 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
Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing
test
test
RE: test
Title: Message Test failed -Original Message-From: Jeffrey Beckstrom [mailto:[EMAIL PROTECTED] Sent: Thursday, December 04, 2003 1:55 PMTo: Multiple recipients of list ORACLE-LSubject: testtest
test mail -- plz ignore
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J 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
Ignore -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: viraj2 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
ignore viraj2 wrote: Ignore -- Joseph S Testa Chief Technology Officer Data Management Consulting 614-791-9000 It's all about the CACHE -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa 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
Yahoo! Personals - New people, new possibilities. FREE for a limited time!
test mail ...... plz ignore
(B-- (BPlease see the official ORACLE-L FAQ: http://www.orafaq.net (B-- (BAuthor: Prem Khanna J (B INET: [EMAIL PROTECTED] (B (BFat City Network Services-- 858-538-5051 http://www.fatcity.com (BSan Diego, California-- Mailing list and web hosting services (B- (BTo REMOVE yourself from this mailing list, send an E-Mail message (Bto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in (Bthe message BODY, include a line containing: UNSUB ORACLE-L (B(or the name of mailing list you want to be removed from). You may (Balso send the HELP command for other information (like subscribing).
Test mesg
Just making sure the list is up. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Test mesg
JS Just making sure the list is up. I'm up. Though I didn't know we had hours we were supposed to be online on a Sunday. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robert Eskridge 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 mesg
[EMAIL PROTECTED]:avsp:9.2.0:OPS$ORACLE:81,43878r
1 select case
2 when rtrim(to_char(sysdate,'DAY')) in ('SATURDAY','SUNDAY')
3 then 'Working from home'
4 else case
5 when to_char(sysdate,'HH24') between 8 and 17
6 then 'At work'
7 else
8 'Working from home'
9end
10 end Just another Day
11* from dual
Just another Day
-
Working from home
Robert Eskridge
[EMAIL PROTECTED]To: Multiple recipients of list
ORACLE-L [EMAIL PROTECTED]
t cc:
Sent by: Subject: Re: Test mesg
[EMAIL PROTECTED]
.com
11/16/2003 08:59
AM
Please respond to
ORACLE-L
JS Just making sure the list is up.
I'm up. Though I didn't know we had hours we were supposed to be
online on a Sunday.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Robert Eskridge
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: Test mesg
It was just a little strange to see no traffic in 20 or so hours, even on a weekend, so just thought I would check. Jared On Sun, 2003-11-16 at 07:59, Robert Eskridge wrote: JS Just making sure the list is up. I'm up. Though I didn't know we had hours we were supposed to be online on a Sunday. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Test mesg
Thought that when Larry has created the database in 7 days, he allocated the 7th day for rest and meditation. No email lists were mentioned in the original 10 commandments. On 11/16/2003 07:39:25 PM, Jared Still wrote: It was just a little strange to see no traffic in 20 or so hours, even on a weekend, so just thought I would check. Jared On Sun, 2003-11-16 at 07:59, Robert Eskridge wrote: JS Just making sure the list is up. I'm up. Though I didn't know we had hours we were supposed to be online on a Sunday. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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 mesg
Hey! that looks like my switch_logfile proc (scheduled with dbms_job), which I still like better than archive_lag_target (except that it only looks at the first character being an 'S')
Why generate a log every half hour over the weekend?
Pd[EMAIL PROTECTED] wrote:
[EMAIL PROTECTED]:avsp:9.2.0:OPS$ORACLE:81,43878r1 select case2 when rtrim(to_char(sysdate,'DAY')) in ('SATURDAY','SUNDAY')3 then 'Working from home'4 else case5 when to_char(sysdate,'HH24') between 8 and 176 then 'At work'7 else8 'Working from home'9 end10 end "Just another Day"11* from dualJust another Day-Working from homeRobert Eskridge <[EMAIL PROTECTED] <[EMAIL PROTECTED] ORACLE-L list of recipients Multiple To:>
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
Re: Test mesg
Brian, you are bad.
On 2003.11.16 17:04, [EMAIL PROTECTED] wrote:
[EMAIL PROTECTED]:avsp:9.2.0:OPS$ORACLE:81,43878r
1 select case
2 when rtrim(to_char(sysdate,'DAY')) in ('SATURDAY','SUNDAY')
3 then 'Working from home'
4 else case
5 when to_char(sysdate,'HH24') between 8 and 17
6 then 'At work'
7 else
8 'Working from home'
9end
10 end Just another Day
11* from dual
Just another Day
-
Working from home
Robert Eskridge
[EMAIL PROTECTED]To: Multiple recipients
of list ORACLE-L [EMAIL PROTECTED]
t cc:
Sent by: Subject: Re: Test mesg
[EMAIL PROTECTED]
.com
11/16/2003 08:59
AM
Please respond to
ORACLE-L
JS Just making sure the list is up.
I'm up. Though I didn't know we had hours we were supposed to be
online on a Sunday.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Robert Eskridge
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).
--
Mladen Gogala
Oracle DBA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mladen Gogala
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 mail -- plz ignore
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J 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).
anyone take the 8i performance tuning ocp test?
Im reading the Sybex OCP book on tuning and it is absolutely loaded with inaccuracies. Is the test the same way? If so do they improve it in 9i? The book is loaded with all types of hit ratios, discussions about committing frequently to IMPROVE performance, and other garbage. anyone know the guys who wrote this book? I dont want to write their names. Did they just write it to the test? -- 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).
RE: anyone take the 8i performance tuning ocp test?
Ryan - I took the 8i OCP for Tuning. I used Couchman to study with, and don't recall any big differences with the exam. The exam is prepared from the Oracle Education Student Guide for Oracle 8i. That would have been a couple of years ago, and if Oracle Education was teaching hit ratios back then, then you better know the answers on the exam. I thought Cary put it best in quoting his father: There is the right answer and the answer the teacher expects, and I expect you to know them both. When I took the 9i version of the Oracle Tuning class, they were in the process of shifting away from hit ratios. I expect by the time 10g rolls around Cary's book will have had a deep impact on Oracle Education. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, November 12, 2003 8:09 AM To: Multiple recipients of list ORACLE-L Im reading the Sybex OCP book on tuning and it is absolutely loaded with inaccuracies. Is the test the same way? If so do they improve it in 9i? The book is loaded with all types of hit ratios, discussions about committing frequently to IMPROVE performance, and other garbage. anyone know the guys who wrote this book? I dont want to write their names. Did they just write it to the test? -- 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). -- 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: anyone take the 8i performance tuning ocp test?
I'm studying for the 9i Performance Tuning exam, too. I'm glad to hear about the inaccuracies in this book. I have this book and the Oracle Press book by Pack. I also have Oracle Online Learning and I think I will stick more closely to that. Also, hopefully the Self Test Software gives a good indication of the type of questions on the exam, or the focus of them. Mike -Original Message- Sent: Wednesday, November 12, 2003 7:09 AM To: Multiple recipients of list ORACLE-L Im reading the Sybex OCP book on tuning and it is absolutely loaded with inaccuracies. Is the test the same way? If so do they improve it in 9i? The book is loaded with all types of hit ratios, discussions about committing frequently to IMPROVE performance, and other garbage. anyone know the guys who wrote this book? I dont want to write their names. Did they just write it to the test? -- 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). This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Milligan 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 see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeffrey Beckstrom 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).
Moving projects from development/test to production
Hi! A somewhat off-topic question this time. I am put in charge of defining the procedure of moving projects from test/development into the production environment. This is to be seen from the entire IT-perspective (i.e. not just databases, but also Unix, Oracle and SAN). I.e. we should come up with check-lists and the like; although having an eye on quality assurance... We urgently need to set procedures up for that since the last time this was a nightmare... Did anybody out there work on a similar project? What are the procedures that you are following? Any input would be appreciated. This is 9.2 on HP-UX 11. Thanks, Helmut Helmut Daiminger WWK Lebensversicherung a.G. Marsstrasse 37 80292 München Telefon: (0 89) 51 14 - 3490 Fax: (0 89) 51 14 - 27 62 mailto:[EMAIL PROTECTED] http://www.wwk.de *** select 'bye for now' from sys.dual *** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daiminger, Helmut 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: Moving projects from development/test to production
Helmut, Not sure of the scope of your request, but I'll try and help. If you are talking about ERP packages, I think it's easier to control - you only move stuff after much testing in a development/user test environment, and it all goes as a package. If you are talking about home-grown stuff, change control starts at the development level. For the current project that I am on, I (the Dba team) established a formal change request application for the developers. They submit a request to change a database object. the request gets reviewed and implemented by the DBA team in development. There are four check boxes for each request that indicate when the request was implemented in each of the environments (Dev, User Test, Train Prod). Reports are run to indicate which request is eligible to be moved to the next level (implemented in Dev, but not in User test). When a build is requested, this report is reviewed, and things are moved up as needed. So we always know when things are moved up and what request is where. A pretty simple application (written in MSAccess) that is working well for us. Hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, October 31, 2003 2:59 AM To: Multiple recipients of list ORACLE-L Hi! A somewhat off-topic question this time. I am put in charge of defining the procedure of moving projects from test/development into the production environment. This is to be seen from the entire IT-perspective (i.e. not just databases, but also Unix, Oracle and SAN). I.e. we should come up with check-lists and the like; although having an eye on quality assurance... We urgently need to set procedures up for that since the last time this was a nightmare... Did anybody out there work on a similar project? What are the procedures that you are following? Any input would be appreciated. This is 9.2 on HP-UX 11. Thanks, Helmut Helmut Daiminger WWK Lebensversicherung a.G. Marsstrasse 37 80292 München Telefon: (0 89) 51 14 - 3490 Fax: (0 89) 51 14 - 27 62 mailto:[EMAIL PROTECTED] http://www.wwk.de *** select 'bye for now' from sys.dual *** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daiminger, Helmut 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: Mercadante, Thomas F 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: Moving projects from development/test to production
Hire a Configuration Management/Quality Assurance person. We have a whole group of about six people and two piece of COTS software to accomplish this. Daiminger, Helmut To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] HELMUT.DAIMINGE cc: RSubject: Moving projects from development/test to production @wwk.de Sent by: ml-errors 10/31/2003 02:59 AM Please respond to ORACLE-L Hi! A somewhat off-topic question this time. I am put in charge of defining the procedure of moving projects from test/development into the production environment. This is to be seen from the entire IT-perspective (i.e. not just databases, but also Unix, Oracle and SAN). I.e. we should come up with check-lists and the like; although having an eye on quality assurance... We urgently need to set procedures up for that since the last time this was a nightmare... Did anybody out there work on a similar project? What are the procedures that you are following? Any input would be appreciated. This is 9.2 on HP-UX 11. Thanks, Helmut Helmut Daiminger WWK Lebensversicherung a.G. Marsstrasse 37 80292 München Telefon: (0 89) 51 14 - 3490 Fax: (0 89) 51 14 - 27 62 mailto:[EMAIL PROTECTED] http://www.wwk.de *** select 'bye for now' from sys.dual *** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daiminger, Helmut 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: Thomas Day 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: Moving projects from development/test to production
Helmut I don't think this is off-topic, but something that many of us Oracle DBAs wrestle with. If you kept John Kanagaraj's posting yesterday on the DBA Support Database topic, it contains the big picture. If you didn't keep it, email me privately and I'll send it. I believe he is referring to the ITIL standards body. There is probably an ITIL user group near you or a company that gives talks from time to time. That is the easiest way to get an overview of ITIL. Our organization is evolving in that direction. Overall, this is a long-term commitment by your organization. You don't change everything overnight. One immediate change you can implement is a staging system. Most of us currently have a test or development system. Staging is an exact copy of production in all respects. From the database side, cloning the database or using RMAN DUPLICATE works very well. Then the development team makes a release to you. Ideally this is on a CD-ROM labeled 1.1 or whatever. You take the CD-ROM and instructions and apply the changes to the staging server. Then the staging system is tested. If it is deemed satisfactory, then you schedule a time and make the changes on production. If it fails the testing or you are unable to apply the changes, then it gets bounced back to the development group. The release may include application or web server changes that must be coordinated with database changes. This is a small change, but it has helped our releases. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, October 31, 2003 1:59 AM To: Multiple recipients of list ORACLE-L Hi! A somewhat off-topic question this time. I am put in charge of defining the procedure of moving projects from test/development into the production environment. This is to be seen from the entire IT-perspective (i.e. not just databases, but also Unix, Oracle and SAN). I.e. we should come up with check-lists and the like; although having an eye on quality assurance... We urgently need to set procedures up for that since the last time this was a nightmare... Did anybody out there work on a similar project? What are the procedures that you are following? Any input would be appreciated. This is 9.2 on HP-UX 11. Thanks, Helmut Helmut Daiminger WWK Lebensversicherung a.G. Marsstrasse 37 80292 München Telefon: (0 89) 51 14 - 3490 Fax: (0 89) 51 14 - 27 62 mailto:[EMAIL PROTECTED] http://www.wwk.de *** select 'bye for now' from sys.dual *** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daiminger, Helmut 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: Moving projects from development/test to production
Dennis, You guessed correctly that this is ITIL based. I completed a Foundation certificate in ITIL way back in '96 when it was still UK based more than what it is now. The principles still stand, and the organization I worked for implemented some kind of CMDB. Unfortunately, they got into very low level details for the Cis and the project became too big to get off the ground One needs to find a balance. OTOH, the tools to help implement ITIL have come a long way since and I mentioned some good ones (at least ones that I have seen). Most of ITIL is just common-sense distilled into a framework for IT processes that define what an IT organization needs to get things done properly. However, in my limited understanding, the IT scene and organizations changes direction and in leadership so rapidly that one needs an evolving plan (to say the least). John Kanagaraj DB Soft Inc Phone: 408-970-7002 (W) Disappointment is inevitable, but Discouragement is optional! ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** -Original Message- From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED] Sent: Friday, October 31, 2003 8:55 AM To: Multiple recipients of list ORACLE-L Subject: RE: Moving projects from development/test to production Helmut I don't think this is off-topic, but something that many of us Oracle DBAs wrestle with. If you kept John Kanagaraj's posting yesterday on the DBA Support Database topic, it contains the big picture. If you didn't keep it, email me privately and I'll send it. I believe he is referring to the ITIL standards body. There is probably an ITIL user group near you or a company that gives talks from time to time. That is the easiest way to get an overview of ITIL. Our organization is evolving in that direction. Overall, this is a long-term commitment by your organization. You don't change everything overnight. One immediate change you can implement is a staging system. Most of us currently have a test or development system. Staging is an exact copy of production in all respects. From the database side, cloning the database or using RMAN DUPLICATE works very well. Then the development team makes a release to you. Ideally this is on a CD-ROM labeled 1.1 or whatever. You take the CD-ROM and instructions and apply the changes to the staging server. Then the staging system is tested. If it is deemed satisfactory, then you schedule a time and make the changes on production. If it fails the testing or you are unable to apply the changes, then it gets bounced back to the development group. The release may include application or web server changes that must be coordinated with database changes. This is a small change, but it has helped our releases. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, October 31, 2003 1:59 AM To: Multiple recipients of list ORACLE-L Hi! A somewhat off-topic question this time. I am put in charge of defining the procedure of moving projects from test/development into the production environment. This is to be seen from the entire IT-perspective (i.e. not just databases, but also Unix, Oracle and SAN). I.e. we should come up with check-lists and the like; although having an eye on quality assurance... We urgently need to set procedures up for that since the last time this was a nightmare... Did anybody out there work on a similar project? What are the procedures that you are following? Any input would be appreciated. This is 9.2 on HP-UX 11. Thanks, Helmut Helmut Daiminger WWK Lebensversicherung a.G. Marsstrasse 37 80292 München Telefon: (0 89) 51 14 - 3490 Fax: (0 89) 51 14 - 27 62 mailto:[EMAIL PROTECTED] http://www.wwk.de *** select 'bye for now' from sys.dual *** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daiminger, Helmut 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
Test : Because I haven't got a mail since yesterday
Title: Message Are the email services down?
Re: Test : Because I haven't got a mail since yesterday
On 2003.10.30 21:59, Satya Prakash Viswanath wrote: Are the email services down? Nope, they're up in smoke. -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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 : Because I haven't got a mail since yesterday
solar flares? http://www.theregister.co.uk/content/archive/21961.html where is that excuse calendar, when I need it? Pd Mladen Gogala [EMAIL PROTECTED] wrote: On 2003.10.30 21:59, Satya Prakash Viswanath wrote: Are the email services down?Nope, they're up in smoke.-- Mladen GogalaOracle DBA-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Mladen GogalaINET: [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!? Exclusive Video Premiere - Britney Spears
test
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeffrey Beckstrom 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
Test failed. Jared-1555: list too old. Check the program on TV. Go Yanks! On 10/17/2003 02:40:38 PM, Jeffrey Beckstrom wrote: -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeffrey Beckstrom 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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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
Yes, the list was down for a few hours. The server software went down, the admin has out cold with cold medicine and didn't hear the pager. You could say we were hit with a virus - the rhino virus. Jared Mladen Gogala [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/17/2003 12:04 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: test Test failed. Jared-1555: list too old. Check the program on TV. Go Yanks! On 10/17/2003 02:40:38 PM, Jeffrey Beckstrom wrote: -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeffrey Beckstrom 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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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
Cheer up, Jared and always look on the bright side of life. It's still much better then List-1555: Jared too old. Blessed are the cheesemakers! On 10/17/2003 05:09:25 PM, [EMAIL PROTECTED] wrote: Yes, the list was down for a few hours. The server software went down, the admin has out cold with cold medicine and didn't hear the pager. You could say we were hit with a virus - the rhino virus. Jared Mladen Gogala [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/17/2003 12:04 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: test Test failed. Jared-1555: list too old. Check the program on TV. Go Yanks! On 10/17/2003 02:40:38 PM, Jeffrey Beckstrom wrote: -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeffrey Beckstrom 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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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
Jeffrey Beckstrom Database Administrator Greater Cleveland Regional Transit Authority 1240 W. 6th Street Cleveland, Ohio 44113 (216) 781-4204 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeffrey Beckstrom 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 see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeffrey Beckstrom 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: createing test sessions
How about for /L %i IN (1,1,250) do start /min sqlplus user/[EMAIL PROTECTED] @script.sql Id try it with less than 250 as it can kill the machine opening 250 windows! ;-) to run form a batch file you need to %%i the variable hth bob If on windows, type start /min sqlplus user/[EMAIL PROTECTED] @script.sql ..255 times on your windows command prompt. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 25, 2003 7:54 PM I want to run some sql scripts and i need to open 255 session at same time and these session will run somw sql scripts. HOW CAN I OPEN 255 session at the same time ? may be a tool , may be shell script. Help bittee -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky 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: createing test sessions
Our exchange hiccupped... How about for /L %i IN (1,1,250) do start /min sqlplus user/[EMAIL PROTECTED] @script.sql Id try it with less than 250 as it can kill the machine opening 250 windows! ;-) to run form a batch file you need to %%i the variable hth bob If on windows, type start /min sqlplus user/[EMAIL PROTECTED] @script.sql ..255 times on your windows command prompt. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 25, 2003 7:54 PM I want to run some sql scripts and i need to open 255 session at same time and these session will run somw sql scripts. HOW CAN I OPEN 255 session at the same time ? may be a tool , may be shell script. Help bittee -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky 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: creating test sessions
the structure of scripts is as follows ...
set ...
declare
v_alert_msg varchar2(20);
v_alert_statusnumber;
begin
dbms_alert.register('START_NOW');
-- first wait for alert to be received ...
dbms_alert.waitone('START_NOW',v_alert_msg,
v_alert_status);
-- your rest of script code ...
...
all scripts will be fashioned like this, once you are ready to go ... all
you need to do is
exec dbms_alert.raise('START_NOW',null);
commit;
HTHS
Raj
Rajendra dot Jamadagni at nospamespn dot
com All Views expressed in this email
are strictly personal. QOTD: Any clod
can have facts, having an opinion is an art !
-Original Message-From: Tanel Poder
[mailto:[EMAIL PROTECTED]Sent: Thursday, September 25, 2003
7:15 PMTo: Multiple recipients of list ORACLE-LSubject:
Re: creating test sessions
Sorry, it's either too late or I just don't get
it, how come any instances of this sql scriptwould wait for an
alert?
Is there any mechanism inside the sql
script?
Tanel.
This e-mail
message is confidential, intended only for the named recipient(s) above and may
contain information that is privileged, attorney work product or exempt from
disclosure under applicable law. If you have received this message in error, or are
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000
and delete this e-mail message from your computer, Thank
you.*1
createing test sessions
I want to run some sql scripts and i need to open 255 session at same time and these session will run somw sql scripts. HOW CAN I OPEN 255 session at the same time ? may be a tool , may be shell script. Help bittee -- 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).
Re: createing test sessions
Type.. sqlplus user/[EMAIL PROTECTED] @script.sql output.log ..255 times on your unix command prompt. If on windows, type start /min sqlplus user/[EMAIL PROTECTED] @script.sql ..255 times on your windows command prompt. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 25, 2003 7:54 PM I want to run some sql scripts and i need to open 255 session at same time and these session will run somw sql scripts. HOW CAN I OPEN 255 session at the same time ? may be a tool , may be shell script. Help bittee -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: createing test sessions
# get number of processes to run from cmd line if [ -z $1 ]; then #default to 5 MAX_CHILD_COUNT=5 else MAX_CHILD_COUNT=$1 fi echo Running $MAX_CHILD_COUNT children CHILD_COUNT=0 while [ $CHILD_COUNT -lt $MAX_CHILD_COUNT ] do (( CHILD_COUNT = CHILD_COUNT + 1)) # run your command in the background # sqlplus -s $USERNAME/$PASSWORD @thc1.sql $CHILD_COUNT 2/dev/null echo $CHILD_COUNT done [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/25/2003 09:54 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:createing test sessions I want to run some sql scripts and i need to open 255 session at same time and these session will run somw sql scripts. HOW CAN I OPEN 255 session at the same time ? may be a tool , may be shell script. Help bittee -- 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).
RE: creating test sessions
one cool thing about this is you can have all your scripts (that would run in parallel) register to receive an alert. So you startup all sessions but they won't do anything. when you are ready to start processing, from another session you raise alert and commit, all sessions start processing within couple of seconds of each other. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Thursday, September 25, 2003 2:50 PMTo: Multiple recipients of list ORACLE-LSubject: Re: createing test sessions# get number of processes to run from cmd line if [ -z $1 ]; then #default to 5 MAX_CHILD_COUNT=5 else MAX_CHILD_COUNT=$1 fi echo Running $MAX_CHILD_COUNT children CHILD_COUNT=0 while [ $CHILD_COUNT -lt $MAX_CHILD_COUNT ] do (( CHILD_COUNT = CHILD_COUNT + 1)) # run your command in the background # sqlplus -s $USERNAME/$PASSWORD @thc1.sql $CHILD_COUNT 2/dev/null echo $CHILD_COUNT done [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/25/2003 09:54 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:createing test sessions I want to run some sql scripts and i need to open 255 session at same time and these session will run somw sql scripts. HOW CAN I OPEN 255 session at the same time ? may be a tool , may be shell script.Help bittee-- 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.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). This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1
Re: creating test sessions
Sorry, it's either too late or I just don't get it, how come any instances of this sql scriptwould wait for an alert? Is there any mechanism inside the sql script? Tanel. - Original Message - From: Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L Sent: Thursday, September 25, 2003 10:44 PM Subject: RE: creating test sessions one cool thing about this is you can have all your scripts (that would run in parallel) register to receive an alert. So you startup all sessions but they won't do anything. when you are ready to start processing, from another session you raise alert and commit, all sessions start processing within couple of seconds of each other. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Thursday, September 25, 2003 2:50 PMTo: Multiple recipients of list ORACLE-LSubject: Re: createing test sessions# get number of processes to run from cmd line if [ -z $1 ]; then #default to 5 MAX_CHILD_COUNT=5 else MAX_CHILD_COUNT=$1 fi echo Running $MAX_CHILD_COUNT children CHILD_COUNT=0 while [ $CHILD_COUNT -lt $MAX_CHILD_COUNT ] do (( CHILD_COUNT = CHILD_COUNT + 1)) # run your command in the background # sqlplus -s $USERNAME/$PASSWORD @thc1.sql $CHILD_COUNT 2/dev/null echo $CHILD_COUNT done [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/25/2003 09:54 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:createing test sessions I want to run some sql scripts and i need to open 255 session at same time and these session will run somw sql scripts. HOW CAN I OPEN 255 session at the same time ? may be a tool , may be shell script.Help bittee-- 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.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: creating test sessions
This is actually just an excerpt from a set of scripts that do what you describe. call sqlplus, kicks off a configurable number of sqlplus children via 'host test.sh', all the kids run simultaneously. Do this for 2 iterations to stress test different methods of coding, collect all the stats via Tom Kytes run_stats, compare the stats side by side. Can be kind of fun. Jared Jamadagni, Rajendra [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/25/2003 12:44 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: creating test sessions one cool thing about this is you can have all your scripts (that would run in parallel) register to receive an alert. So you startup all sessions but they won't do anything. when you are ready to start processing, from another session you raise alert and commit, all sessions start processing within couple of seconds of each other. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, September 25, 2003 2:50 PM To: Multiple recipients of list ORACLE-L Subject: Re: createing test sessions # get number of processes to run from cmd line if [ -z $1 ]; then #default to 5 MAX_CHILD_COUNT=5 else MAX_CHILD_COUNT=$1 fi echo Running $MAX_CHILD_COUNT children CHILD_COUNT=0 while [ $CHILD_COUNT -lt $MAX_CHILD_COUNT ] do (( CHILD_COUNT = CHILD_COUNT + 1)) # run your command in the background # sqlplus -s $USERNAME/$PASSWORD @thc1.sql $CHILD_COUNT 2/dev/null echo $CHILD_COUNT done [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/25/2003 09:54 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:createing test sessions I want to run some sql scripts and i need to open 255 session at same time and these session will run somw sql scripts. HOW CAN I OPEN 255 session at the same time ? may be a tool , may be shell script. Help bittee -- 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). encoded content removed -- binaries not allowed by ListGuru
test
__ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Oracle DBA 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
negative Oracle DBA wrote: __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa 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
Title: RE: test Whew! What a relief!!! -Original Message- From: Joe Testa [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 23, 2003 1:20 PM To: Multiple recipients of list ORACLE-L Subject: Re: test negative Oracle DBA wrote: __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa 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
TEST -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sultan Syed 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' Note on Metalink...
And I guess the hidden text feature doesn't work. -Original Message- Sent: Wednesday, September 17, 2003 2:50 PM To: Multiple recipients of list ORACLE-L Have a laff! See Note 240863.1 (esp the first sentence). This seems to have been around since 11-Jun-2003 (if the Modified date can be believed) John -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice J 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: Mercadante, Thomas F 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' Note on Metalink...
The modified date is unreliable. I have seen notes relating to 7.3 and 8.0 and Apps 10.7 which, from the text, I know have *not* been modified for two or more years and yet the modified date appears as being only a month ago -- particulary Desupport Advisories. e.g. see Note 39013.1 -- The Desupport Advisory for 7.1/7.2 which was supposedly last modified 04-Sep-03. Hemant At 09:49 AM 17-09-03 -0800, you wrote: Have a laff! See Note 240863.1 (esp the first sentence). This seems to have been around since 11-Jun-2003 (if the Modified date can be believed) John -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale 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' Note on Metalink...
Have a laff! See Note 240863.1 (esp the first sentence). This seems to have been around since 11-Jun-2003 (if the Modified date can be believed) John -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 'Test' Note on Metalink...
Just proves, what's TEST today is Production tomorrow. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Wednesday, September 17, 2003 1:50 PM To: Multiple recipients of list ORACLE-L Have a laff! See Note 240863.1 (esp the first sentence). This seems to have been around since 11-Jun-2003 (if the Modified date can be believed) John -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick 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' Note on Metalink...
Or that the developers test in production! -Original Message- From: Goulet, Dick [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 2:05 PM To: Multiple recipients of list ORACLE-L Subject: RE: 'Test' Note on Metalink... Just proves, what's TEST today is Production tomorrow. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Wednesday, September 17, 2003 1:50 PM To: Multiple recipients of list ORACLE-L Have a laff! See Note 240863.1 (esp the first sentence). This seems to have been around since 11-Jun-2003 (if the Modified date can be believed) John -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Murray, Margaret 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' Note on Metalink...
I wonder how long it's going to stay in Metalink now... : ) Patrice. -Original Message- Sent: Wednesday, September 17, 2003 2:50 PM To: Multiple recipients of list ORACLE-L Have a laff! See Note 240863.1 (esp the first sentence). This seems to have been around since 11-Jun-2003 (if the Modified date can be believed) John -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice J 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' Note on Metalink...
Title: RE: 'Test' Note on Metalink... I'm curious as to who has time to search for such an item these days:-) greg -Original Message- From: John Kanagaraj [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 17, 2003 1:50 PM To: Multiple recipients of list ORACLE-L Subject: 'Test' Note on Metalink... Have a laff! See Note 240863.1 (esp the first sentence). This seems to have been around since 11-Jun-2003 (if the Modified date can be believed) John -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Apology for my test
test -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mario Cariggi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OT - how/where to buy oracle test voucher ?
Hi everybody, Where/how can i buy a voucher for oracle exam ? I noticed two payment methods while filling up a Prometric registration form for Exam #1Z0-031. One of them was voucher. how and where do i get it ? how much is it ? ...anyone in this list from Japan ? Regards, Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J 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: OT - how/where to buy oracle test voucher ?
www.oracle.com do a search for certification. select a track. you can get to a prometric site throught there. put down OTN20 in the voucher to save $25. the forms 9i one is in beta and is only $40 now. however, its a pain. 165 questions... and boring. From: Prem Khanna J [EMAIL PROTECTED] Date: 2003/09/10 Wed AM 06:34:24 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: OT - how/where to buy oracle test voucher ? Hi everybody, Where/how can i buy a voucher for oracle exam ? I noticed two payment methods while filling up a Prometric registration form for Exam #1Z0-031. One of them was voucher. how and where do i get it ? how much is it ? ...anyone in this list from Japan ? Regards, Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J 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: [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).
RE: Re: test
I am really happy to see such responses for my test !! BTW, I was just checking whether I have successfully been un-subscribed for my old mail-id and subscribed with new one. But disappointed to see that un-subscription mail reached much later than test Mail (which actually I sent before). And yes, will silently be watching the testG launch through net. My Damagement Doesn't think it's worth attending these launches. ;-(( Regards, Rajesh Dayal Senior Oracle DBA (OCP 8,8i,9i) International Information Technology Company LLC -Original Message- Sent: Sunday, September 07, 2003 11:14 AM To: Multiple recipients of list ORACLE-L Subject:Fwd: Re: test No, no, no, no. You just live on the wrong side of the world, these days. TestG is old, gone, dead. It's Test/g/ now. Has been for a couple of weeks. Notice the italics. Don't make users more ten'se than neccessary. The first one who sees a production version of Tense/g /will forever be known as the g-spotter. Connor McDonald wrote: I would not bother to use Test, because TestG is coming out very shortly. A lot of the Test programs have not been Test'd on version TestG which tends to make users a little testy :-) --- Mogens_Nørgaard [EMAIL PROTECTED] wrote: I also need to test. Mogens [EMAIL PROTECTED] wrote: Search the web by email! mailto:[EMAIL PROTECTED] adding your search to the subject line like this: search summer vacations test -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= 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). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://uk.messenger.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= 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: Rajesh Dayal 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
No, no, no, no. You just live on the wrong side of the world, these days. TestG is old, gone, dead. It's Test/g/ now. Has been for a couple of weeks. Notice the italics. Don't make users more ten'se than neccessary. The first one who sees a production version of Tense/g /will forever be known as the g-spotter. Connor McDonald wrote: I would not bother to use Test, because TestG is coming out very shortly. A lot of the Test programs have not been Test'd on version TestG which tends to make users a little testy :-) --- Mogens_Nørgaard [EMAIL PROTECTED] wrote: I also need to test. Mogens [EMAIL PROTECTED] wrote: Search the web by email! mailto:[EMAIL PROTECTED] adding your search to the subject line like this: search summer vacations test -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= 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). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://uk.messenger.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= 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
Test
RE: test
Bad Mexican accent Test,TestWe don't need no stinkin test. -Original Message-From: Rajesh Dayal [mailto:[EMAIL PROTECTED]Sent: Saturday, September 06, 2003 5:13 AMTo: Multiple recipients of list ORACLE-LSubject: test Test
test
test
Search the web by email! mailto:[EMAIL PROTECTED] adding your search to the subject line like this: search summer vacations test -- 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: test
I also need to test. Mogens [EMAIL PROTECTED] wrote: Search the web by email! mailto:[EMAIL PROTECTED] adding your search to the subject line like this: search summer vacations test -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= 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
I would not bother to use Test, because TestG is coming out very shortly. A lot of the Test programs have not been Test'd on version TestG which tends to make users a little testy :-) --- Mogens_Nørgaard [EMAIL PROTECTED] wrote: I also need to test. Mogens [EMAIL PROTECTED] wrote: Search the web by email! mailto:[EMAIL PROTECTED] adding your search to the subject line like this: search summer vacations test -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= 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). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://uk.messenger.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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
Babette Turner-Underwood scribbled on the wall in glitter crayon: test oh damn, i hate pop quizzes.;-) -- Bill Shrek Thater ORACLE DBA BAARF Party member #25 [EMAIL PROTECTED] It's no coincidence that in no known language does the phrase As pretty as an airport appear. - Douglas Adams -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thater, William 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
Title: RE: test No Bill, it's a POP test That's even worse. -Original Message- From: Thater, William [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 04, 2003 12:50 PM To: Multiple recipients of list ORACLE-L Subject: RE: test Babette Turner-Underwood scribbled on the wall in glitter crayon: test oh damn, i hate pop quizzes.;-) -- Bill Shrek Thater ORACLE DBA BAARF Party member #25 [EMAIL PROTECTED] It's no coincidence that in no known language does the phrase As pretty as an airport appear. - Douglas Adams -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thater, William 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
Title: RE: test -Original Message-From: Stefick Ronald S Contr ESC/HRIDD [mailto:[EMAIL PROTECTED]Sent: Thursday, September 04, 2003 2:50 PMTo: Multiple recipients of list ORACLE-LSubject: RE: test No Bill, it's a POP "test" That's even worse. [Shrek] is that a POP or IMAP test? -- Bill "Shrek" Thater ORACLE DBA BAARF Party member #25 [EMAIL PROTECTED] Experiments before 1880 showed that light always travels athe the same speed relative to you, no matter how you were moving - basis for Einsteins axiom on moving observers.
test
test -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Babette Turner-Underwood 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
fail - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, September 03, 2003 3:04 PM test -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Babette Turner-Underwood 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: AK 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
fail Babette Turner-Underwood wrote: test -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Babette Turner-Underwood 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). begin:vcard n:Fink;Daniel x-mozilla-html:FALSE org:Sun Microsystems, Inc. adr:;; version:2.1 title:Lead, Database Services x-mozilla-cpt:;9168 fn:Daniel W. Fink end:vcard
RE: test message eom ==== Test OK !
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Harvinder Singh 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: Mercadante, Thomas F 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 message eom
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Harvinder Singh 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).
How to test whether a text file exists in Dev6i on client machine
Hi Gurus I need to test whether a text file 'a.txt' exists in the default oracle reports directory on client machine and print at the end of the report? I can use text_io but I don't seem to see a test for file existence. Appreciate any help. Have a great weekend. Regards Shiva Baswannappa Life Sciences Business UnitDigital Consulting Software Services, Inc._ Phone: 281.243.2658Fax: 281.243.2504Web: http://www.dcss.com If the reader of this e-mail is not an intended recipient, you have received this e-mail in error and any review, dissemination, distribution or copying is strictly prohibited. If you have received this e-mail in error, please notify the sender immediately by return e-mail and permanently delete the copy you received. Thank you.
how do I test a restore of a raw device?
Hi all: I'm testing a restore of a database file (tools TS). The datafile is a raw device and I have link to that raw evice in my links directory. Im running Oracle 9203 and UNIX 5l. And the problem I ran into is as follows. If I drop the logical link , the rman restores the data as a datafile. If I remove the link and recreate it pointing to another raw device, the restore fails bacause the file exist. How do I force rman to restore the data in the raw device form? IS there a way to do it? thanks gene __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gurelei 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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer 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
. -- Chris J. Guidry Principal Engineer, DCSI Phone: (314) 895-6516 Fax: (314) 895-6453 Email: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guidry, Chris 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 mail -- please ignore
test mail -- please ignore -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nilesh Darji 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).
Preparing for Performance test
Tru64 5.1A 8.1.7.3 I have a very short window of time tomorrow to try and determine why the runtime of one 2-table join takes ~4 time as long on a (SAN/Snapshot) database copy as the same statement on the source database. All other test selects have similar runtimes on each database. Both database are using copies of the same init.ora file with only directory specific parameters changed, CBO statistics are, of course, the same and one of these 2 database are the only thing running on the box during test time. I plan to run the SQL test scripts with event 10046 lvl 8 set. Should I have a look at anything else during the test to try and shed more light on this discrepency. Thanks, Mike Hand Polaroid Corp. This transmission is intended only for use by the addressee(s) named herein and may contain information that is proprietary, confidential and/or legally privileged. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hand, Michael T 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: Preparing for Performance test
Title: RE: Preparing for Performance test after you are done wint 10046^8, you may want to try with event 10053^1 ... and if you are looking for information to interpret the output look no further than http://www.centrexcc.com/papers.html Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: Hand, Michael T [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 11, 2003 3:26 PM To: Multiple recipients of list ORACLE-L Subject: Preparing for Performance test Tru64 5.1A 8.1.7.3 I have a very short window of time tomorrow to try and determine why the runtime of one 2-table join takes ~4 time as long on a (SAN/Snapshot) database copy as the same statement on the source database. All other test selects have similar runtimes on each database. Both database are using copies of the same init.ora file with only directory specific parameters changed, CBO statistics are, of course, the same and one of these 2 database are the only thing running on the box during test time. I plan to run the SQL test scripts with event 10046 lvl 8 set. Should I have a look at anything else during the test to try and shed more light on this discrepency. Thanks, Mike Hand Polaroid Corp. This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2
Re: Re: Snapshot too old during stress test... how to avoid
With optimal, the rollback segment shrinks back to its optimal size as soon as the update, insert, or delete transaction is committed. However, there may be a long running query that is using that rollback segment for a consistent view of the database. If the rollback segment shrinks, the query cannot find the data that it needs. This results in a snapshot too old error. rgaffuri @cox.netTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: rootcc: Subject: Re: Re: Snapshot too old during stress test... how to avoid 06/05/2003 08:31 AM Please respond to ORACLE-L why would removing optimal setting help with snapshot too old? what I dont understand is that each of my DML transactions are independent of each other. They query and perform DML on different tables. None of them overlap. The only time they overlap is when they hit the data dictionary for some brief queries. From: Tim Gorman [EMAIL PROTECTED] Date: 2003/06/05 Thu AM 03:25:36 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: 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
RE: Re: Snapshot too old during stress test... how to avoid
the thing is Im not doing any of that. Here is waht Im doing. update,inserts and deletes on tables select on data dictionary. Im also doing 'create table as' Transactions do NOT overlap. for example update,insert,and delete will not use the same tables in different transactions. and Im not updating the data dictionary. From: Ganesh Raja [EMAIL PROTECTED] Date: 2003/06/05 Thu AM 10:09:52 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Re: Snapshot too old during stress test... how to avoid Snapshot Too Old Maybe caused bcos of Delayed Block Cleanout Problems. Now this Bock was updated an Hour ago and u are now selecting it.. It finds that there are ITL Entries in there and oracle wants to see if the Transaction has been commited. He Goes back to the Transaction Table of the RBS Pointed by this ITL and he finds that there is No Rollback entry available.. Why is this ??? The Optimal Parameter Shrunk the RBS Down and with it all the Undo Information needed to do a Block Clean out. HTH Best Regards, Ganesh R DID : +65-6215-8413 HP : +65-9067-8474 === Live to learn... forget... and learn again. === -Original Message- [EMAIL PROTECTED] Sent: Thursday, June 05, 2003 8:32 PM To: Multiple recipients of list ORACLE-L why would removing optimal setting help with snapshot too old? what I dont understand is that each of my DML transactions are independent of each other. They query and perform DML on different tables. None of them overlap. The only time they overlap is when they hit the data dictionary for some brief queries. From: Tim Gorman [EMAIL PROTECTED] Date: 2003/06/05 Thu AM 03:25:36 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: 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
RE: Re: Snapshot too old during stress test... how to avoid
Snapshot Too Old Maybe caused bcos of Delayed Block Cleanout Problems. Now this Bock was updated an Hour ago and u are now selecting it.. It finds that there are ITL Entries in there and oracle wants to see if the Transaction has been commited. He Goes back to the Transaction Table of the RBS Pointed by this ITL and he finds that there is No Rollback entry available.. Why is this ??? The Optimal Parameter Shrunk the RBS Down and with it all the Undo Information needed to do a Block Clean out. HTH Best Regards, Ganesh R DID : +65-6215-8413 HP : +65-9067-8474 === Live to learn... forget... and learn again. === -Original Message- [EMAIL PROTECTED] Sent: Thursday, June 05, 2003 8:32 PM To: Multiple recipients of list ORACLE-L why would removing optimal setting help with snapshot too old? what I dont understand is that each of my DML transactions are independent of each other. They query and perform DML on different tables. None of them overlap. The only time they overlap is when they hit the data dictionary for some brief queries. From: Tim Gorman [EMAIL PROTECTED] Date: 2003/06/05 Thu AM 03:25:36 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: 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
RE: Re: Snapshot too old during stress test... how to avoid
Actually when are u getting this error.. There are a Lot Of reasons for ORA-01555 and primary one is DB Block Cleanout or Long Running quries... Best Regards, Ganesh R DID : +65-6215-8413 HP : +65-9067-8474 === Live to learn... forget... and learn again. === -Original Message- [EMAIL PROTECTED] Sent: Thursday, June 05, 2003 11:10 PM To: Multiple recipients of list ORACLE-L the thing is Im not doing any of that. Here is waht Im doing. update,inserts and deletes on tables select on data dictionary. Im also doing 'create table as' Transactions do NOT overlap. for example update,insert,and delete will not use the same tables in different transactions. and Im not updating the data dictionary. From: Ganesh Raja [EMAIL PROTECTED] Date: 2003/06/05 Thu AM 10:09:52 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Re: Snapshot too old during stress test... how to avoid Snapshot Too Old Maybe caused bcos of Delayed Block Cleanout Problems. Now this Bock was updated an Hour ago and u are now selecting it.. It finds that there are ITL Entries in there and oracle wants to see if the Transaction has been commited. He Goes back to the Transaction Table of the RBS Pointed by this ITL and he finds that there is No Rollback entry available.. Why is this ??? The Optimal Parameter Shrunk the RBS Down and with it all the Undo Information needed to do a Block Clean out. HTH Best Regards, Ganesh R DID : +65-6215-8413 HP : +65-9067-8474 === Live to learn... forget... and learn again. === -Original Message- [EMAIL PROTECTED] Sent: Thursday, June 05, 2003 8:32 PM To: Multiple recipients of list ORACLE-L why would removing optimal setting help with snapshot too old? what I dont understand is that each of my DML transactions are independent of each other. They query and perform DML on different tables. None of them overlap. The only time they overlap is when they hit the data dictionary for some brief queries. From: Tim Gorman [EMAIL PROTECTED] Date: 2003/06/05 Thu AM 03:25:36 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: 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
Re: Snapshot too old during stress test... how to avoid
Are you hitting ORA-1555 because of a fetch across commit?
[EMAIL PROTECTED] wrote:
why would removing optimal setting help with snapshot too old?
what I dont understand is that each of my DML transactions are independent of each other. They query and perform DML on different tables. None of them overlap. The only time they overlap is when they hit the data dictionary for some brief queries.
From: Tim Gorman [EMAIL PROTECTED]
Date: 2003/06/05 Thu AM 03:25:36 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
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).
--
Daniel W. Fink
http://www.optimaldba.com
Re: Snapshot too old during stress test... how to avoid
The rbs does not shrink to optimal when the transaction commits. The 2nd transaction to 'find' that the rbs has extended beyond optimal will cause the rbs to shrink. -- Daniel W. Fink http://www.optimaldba.com Thomas Day wrote: With optimal, the rollback segment shrinks back to its optimal size as soon as the update, insert, or delete transaction is committed. However, there may be a long running query that is using that rollback segment for a consistent view of the database. If the rollback segment shrinks, the query cannot find the data that it needs. This results in a snapshot too old error. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel W. Fink 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: Re: Snapshot too old during stress test... how to avoid
Not as soon as the Update is Over.. Only after a Certain period of Time. This operation is done By SMON. HTH Best Regards, Ganesh R DID : +65-6215-8413 HP : +65-9067-8474 === Live to learn... forget... and learn again. === -Original Message- Sent: Thursday, June 05, 2003 10:05 PM To: Multiple recipients of list ORACLE-L With optimal, the rollback segment shrinks back to its optimal size as soon as the update, insert, or delete transaction is committed. However, there may be a long running query that is using that rollback segment for a consistent view of the database. If the rollback segment shrinks, the query cannot find the data that it needs. This results in a snapshot too old error. rgaffuri @cox.netTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: rootcc: Subject: Re: Re: Snapshot too old during stress test... how to avoid 06/05/2003 08:31 AM Please respond to ORACLE-L why would removing optimal setting help with snapshot too old? what I dont understand is that each of my DML transactions are independent of each other. They query and perform DML on different tables. None of them overlap. The only time they overlap is when they hit the data dictionary for some brief queries. From: Tim Gorman [EMAIL PROTECTED] Date: 2003/06/05 Thu AM 03:25:36 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: 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
Re: Snapshot too old during stress test... how to avoid
Is the error only occurring when you do the create table as select? Are any other processes modifying data in the source table? What is the db_block_size? [EMAIL PROTECTED] wrote: nope. My process is rather simple. A flag comes in... either we do a create table as, drop the old table, and create the indexes based on the data in the stage tablespace or, we do insert select Commit; update commit; delete commit; The snapshot too old is occurring during the process of create table as, all the data is getting created in the new table, then Im getting a snapshot too old. I didnt have error handling there to know EXACTLY when its happening, but right after I do the create table as, I have a query of the data dictionary, then I drop the old table. The old table is not being dropped and the new table is being created. Im at a loss. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel W. Fink 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: Re: Snapshot too old during stress test... how to avoid
It could be that your own process is causing the error by committing between DML operations. Take a look at metalink note 40689.1. My hazy understanding of which is as follows: - When you change a block in the buffer cache, a pointer to the rollback entry is placed in the block header. When the transaction is committed, the rollback entry is freed, but the buffer is not updated to reflect this. When the block is revisited, the process must find the rollback entry to determine whether the transaction has been committed or not. If the entry has been overwritten, then you get snapshot too old. The answer is not to commit between the insert select, update and delete, or alternatively, to force the block cleanout by doing a full scan of the table (for instance by doing a select count(*) from my_table) after each commit. Regards David Lord -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 05 June 2003 18:40 To: Multiple recipients of list ORACLE-L Subject: Re: Re: Snapshot too old during stress test... how to avoid nope. My process is rather simple. A flag comes in... either we do a create table as, drop the old table, and create the indexes based on the data in the stage tablespace or, we do insert select Commit; update commit; delete commit; The snapshot too old is occuring during the process of create table as, all the data is getting created in the new table, then Im getting a snapshot too old. I didnt have error handling there to know EXACTLY when its happening, but right after I do the create table as, I have a query of the data dictionary, then I drop the old table. The old table is not being dropped and the new table is being created. Im at a loss. From: Daniel W. Fink [EMAIL PROTECTED] Date: 2003/06/05 Thu AM 10:55:05 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Snapshot too old during stress test... how to avoid Are you hitting ORA-1555 because of a fetch across commit? [EMAIL PROTECTED] wrote: why would removing optimal setting help with snapshot too old? what I dont understand is that each of my DML transactions are independent of each other. They query and perform DML on different tables. None of them overlap. The only time they overlap is when they hit the data dictionary for some brief queries. From: Tim Gorman [EMAIL PROTECTED] Date: 2003/06/05 Thu AM 03:25:36 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: 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
Re: Re: Snapshot too old during stress test... how to avoid
why would removing optimal setting help with snapshot too old? what I dont understand is that each of my DML transactions are independent of each other. They query and perform DML on different tables. None of them overlap. The only time they overlap is when they hit the data dictionary for some brief queries. From: Tim Gorman [EMAIL PROTECTED] Date: 2003/06/05 Thu AM 03:25:36 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: 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). -- 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
Re: Snapshot too old during stress test... how to avoid
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] 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: Garry Gillies 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
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).
