RE: DBMS_JOB
Roland:
This anonymous PL/SQL block submits a job that will insert a row into
mytable:
VARIABLE jobno number;
BEGIN
DBMS_JOB.SUBMIT(:jobno,
'insert into mytable values (''One'',''Two'',''Three'');'
'SYSDATE, 'SYSDATE + 1');
commit;
END;
/
The SYSDATE parameter says, "Run this right now" and the SYSDATE+1
parameter says, "Then run this again at this same time tomorrow."
Jon Walthour
-Original Message-
[EMAIL PROTECTED]
Sent: Monday, August 27, 2001 5:35 AM
To: Multiple recipients of list ORACLE-L
Hallo,
How can I schedule a pl/sql job, I want this to happen:
Every Sunday at 11 pm I want to do an insert into a table.
How shoudl I write the code in the DBMS_JOB satement.?
Roland S
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from). You may also send the HELP
command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jon Walthour
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Re: Migrate/Update-which way is better?
> 1. I have a full export dump, I know the objects owned by sys are not >exported/imported. What happens to the objects owned by system? Listers, please correct me if I am wrong here, but that's not my understanding. I have recreated a complete database from a full export in the past and the 8i Utilities manual says that a full export "exports the entire database". So, I'm almost certain that includes SYS. Jon Walthour -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: sql query
Seema: Here's my crack at it: select x.userid , x.superid , nvl(y.count, 0) as count from mytable x , (select a.userid , a.superid , count(*) as count from mytable a , mytable b where a.userid=b.superid group by a.userid, a.superid) y where x.userid = y.userid(+) order by 1, 2; Jon Walthour > > From: "Seema Singh" <[EMAIL PROTECTED]> > Date: 2001/08/22 Wed AM 09:00:28 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: sql query > > Hi > One table has following information > userid superid > 14-1 > 4 0 > 8 2 > 9 2 > 152 > 244 > 164 > 254 > 6 5 > 7 5 > 265 > 2 16 > 1816 > 1018 > 1118 > 1 24 > 5 24 > 1324 > I want the output in following format > userid superidCOUNT > 14-10 > 4 0 3 > 8 2 0 > 9 2 0 > 152 0 > 244 3 > 164 2 > 254 0 > 6 5 0 > 7 5 0 > 265 0 > 2 163 > 18162 > 10180 > 11180 > 1 240 > 5 243 > 13240 > Where userid =xx , select count where Superid=xx > Please suggest the query. > THANKS > -Seema > > _ > Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Seema Singh > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: User access within/outside of app
Larry: Upon rereading your post (this time with my eyes open!), I see your problem. Hmm. I worked with a developer who did something like this. I don't know all the details, but I seem to recall that he didn't put the password in the DSN for the ODBC connection, but rather encrypted it in an .ini file that the app decrypted and used to log into the database. That way, the users couldn't use the ODBC connection with that userid outside of the app. That may not be an option for you here, but that's about all I can think of as an alternative. Jon Walthour -Original Message- Sent: Tuesday, August 21, 2001 3:36 PM To: Multiple recipients of list ORACLE-L Jon, Thanks for the response. But these users still need to do updates through the app. I only want to keep them from doing updates from outside the app. Larry --- Jon Walthour <[EMAIL PROTECTED]> wrote: > Create another user with select privileges only on > the objects in the app's schema. Give that one to > them and then change the password on the original > app id so they won't be able to use that one > anymore. > > Jon Walthour > > > > From: Larry Hahn <[EMAIL PROTECTED]> > > Date: 2001/08/21 Tue AM 11:21:04 EDT > > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > > Subject: User access within/outside of app > > > > List, > > > > We have purchased a system where users login > through > > an ODBC connection using a generic Oracle userid. > This > > userid has full rights to do insert, update, > delete, > > select on any table in the schema. The app asks > for > > another username and password which checks the > > application security table, which limits what > areas of > > the apps they can access. > > > > Although this may work fine for the app, the users > > also have the ability to use Access and other ODBC compliant > > programs to look at the data. When doing > so, > > they use the same ODBC DSN and, what do you know, > they > > have capabilities beyond their wildest > imagination. > > > > This is obviously not a situation I want to > implement. > > I am looking for a way to allow a user into the > app to > > do their normal work, but only allow read access > for > > anything outside the app. > > > > Any suggestions or ideas would be more than > welcome. > > > > Thanks, > > > > Larry Hahn > > Journal Sentinel, Inc. > > > > __ > > Do You Yahoo!? > > Make international calls for as low as $.04/minute > with Yahoo! Messenger > > http://phonecard.yahoo.com/ > > -- > > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > > -- > > Author: Larry Hahn > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 > FAX: (858) 538-5051 > > San Diego, California-- Public Internet > access / Mailing Lists > > > > > To REMOVE yourself from this mailing list, send an > E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > > the message BODY, include a line containing: UNSUB > ORACLE-L > > (or the name of mailing list you want to be > removed from). You may > > also send the HELP command for other information > (like subscribing). > > > > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Jon Walthour > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). = Larry Hahn DBA Journal Sentinel,Inc __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Larry Hahn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists -
Re: User access within/outside of app
Create another user with select privileges only on the objects in the app's schema. Give that one to them and then change the password on the original app id so they won't be able to use that one anymore. Jon Walthour > > From: Larry Hahn <[EMAIL PROTECTED]> > Date: 2001/08/21 Tue AM 11:21:04 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: User access within/outside of app > > List, > > We have purchased a system where users login through > an ODBC connection using a generic Oracle userid. This > userid has full rights to do insert, update, delete, > select on any table in the schema. The app asks for > another username and password which checks the > application security table, which limits what areas of > the apps they can access. > > Although this may work fine for the app, the users > also have the ability to use Access and other ODBC > compliant programs to look at the data. When doing so, > they use the same ODBC DSN and, what do you know, they > have capabilities beyond their wildest imagination. > > This is obviously not a situation I want to implement. > I am looking for a way to allow a user into the app to > do their normal work, but only allow read access for > anything outside the app. > > Any suggestions or ideas would be more than welcome. > > Thanks, > > Larry Hahn > Journal Sentinel, Inc. > > __ > Do You Yahoo!? > Make international calls for as low as $.04/minute with Yahoo! Messenger > http://phonecard.yahoo.com/ > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Larry Hahn > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How do they get the answer?
in the where clause, the IN says "any teachers that are in any of these subjects. Since there are two subjects in the IN set and at least 2 teachers have to teach each subject, 2*2=4. Basic mathematics: at least 4 teachers will get a raise. Jon Walthour > > From: [EMAIL PROTECTED] > Date: 2001/08/21 Tue PM 12:25:54 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: How do they get the answer? > > I am taking the Self-Test software test for the SQL exam > and don't see how they get the answer to this problem. > They don't explain how it is arrived at. > > Any help you can give me will be appreciated. > > Thanks, > Ken Janusz, CPIM > > -- > > Examine the structure of the TEACHER table: > > Name Null? Type > IDNOT NULLNUMBER(9) > SALARYNUMBER > (7,2) > SUBJECT_IDNOT NULLNUMBER(3) > SUBJECT_DESCRIPTION VARCHAR2(2) > > There are 200 teachers and 15 subjects. Each subject is > taught > by at least 2 teachers. > > Evaluate this PL/SQL block: > > DECLARE > v_pct_raise number := 1.10; > BEGIN > UPDATE teacher > SET salary = salary * 1.10 > WHERE subject_id IN (102, 105); > COMMIT; > END; > > Which result will the PL/SQL block provide? > > (A) Only two teachers will receive a 10% salary increase. > (B) All of the teachers will receive a 10% salary > increase. > (C) At least four teachers will receive a 10% salary > increase. > (D) A syntax error will occur. > > Answer: > (C) > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RE: Freelist Contention
No. Just because you have a high bbw ratio, that doesn't indicate strictly a freelist problem. However, having problems with freelists often results in a high bbw ratio. Jon Walthour > > From: Johnson Poovathummoottil <[EMAIL PROTECTED]> > Date: 2001/08/21 Tue AM 11:21:02 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: Freelist Contention > > Bufer busy waits can also be caused by parallel query > servers trying to read the same buffer block at the > same time. So does it always indicate a freelist > problem? > . > --- Jon Walthour <[EMAIL PROTECTED]> wrote: > > Raja: > > > > You will know you have freelist contention if you > > have a significant > > buffer busy waits ratio (>5%). > > > > Jon Walthour > > > > -Original Message- > > Luthra > > Sent: Monday, August 20, 2001 11:45 PM > > To: Multiple recipients of list ORACLE-L > > > > > > Hello folks, > > > > How do I come to know that there is a contention > > going on in the > > freelists? Is there any v$ table or this type of > > contention you derive > > from some other info. like a ripple effect from some > > parameter? > > > > TIA. > > > > raja > > > > > > Get 250 color business cards for FREE! > > http://businesscards.lycos.com/vp/fastpath/ > > -- > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.com > > -- > > Author: Viraj Luthra > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: > > (858) 538-5051 > > San Diego, California-- Public Internet > > access / Mailing Lists > > > > > To REMOVE yourself from this mailing list, send an > > E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of > > 'ListGuru') and in the > > message BODY, include a line containing: UNSUB > > ORACLE-L (or the name of > > mailing list you want to be removed from). You may > > also send the HELP > > command for other information (like subscribing). > > > > > > -- > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.com > > -- > > Author: Jon Walthour > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: > > (858) 538-5051 > > San Diego, California-- Public Internet > > access / Mailing Lists > > > > > To REMOVE yourself from this mailing list, send an > > E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of > > 'ListGuru') and in > > the message BODY, include a line containing: UNSUB > > ORACLE-L > > (or the name of mailing list you want to be removed > > from). You may > > also send the HELP command for other information > > (like subscribing). > > > __ > Do You Yahoo!? > Make international calls for as low as $.04/minute with Yahoo! Messenger > http://phonecard.yahoo.com/ > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Johnson Poovathummoottil > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: What is in archive log...
Check out the Oracle 8i Administrator's Guide, look at the chapter entitled: "Using LogMiner to Analyze Online and Archived Redo Logs". Jon Walthour > > From: "Aldi Barco" <[EMAIL PROTECTED]> > Date: 2001/08/21 Tue AM 11:41:32 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: What is in archive log... > > Hi Lister, > > Can we read what activities are in archive log files ? > (utility like 'tkprof' to read trace file). > Tia. > > Aldi > > > _ > Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Aldi Barco > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Freelist Contention
Raja: You will know you have freelist contention if you have a significant buffer busy waits ratio (>5%). Jon Walthour -Original Message- Luthra Sent: Monday, August 20, 2001 11:45 PM To: Multiple recipients of list ORACLE-L Hello folks, How do I come to know that there is a contention going on in the freelists? Is there any v$ table or this type of contention you derive from some other info. like a ripple effect from some parameter? TIA. raja Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viraj Luthra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: changing long to lob
Title: Message Joe: Can you tell me if you were able to do this? I just tried it and it errored out on me: SQL> create table test_lob (col1 varchar2(30), col_lob long); Table created. SQL> desc test_lob Name Null? Type - COL1 VARCHAR2(30) COL_LOB LONG SQL> alter table test_lob modify col_lob clob;alter table test_lob modify col_lob clob *ERROR at line 1:ORA-22858: invalid alteration of datatype Thanks, Jon Walthour -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of JOE TESTASent: Monday, August 20, 2001 4:26 PMTo: Multiple recipients of list ORACLE-LSubject: changing long to lob while looking thru the migration guide(for downgrade info in case it happens), alter table modify clob; and supposedly POOF its now a clob. interesting. joe
RE: net 8 / 8i ?
> 1. Should I install the net 8.0 client on the base image and upgrade it to 8i later ? Yes. Go ahead and get it over with. > 2. Should I go ahead and install the 8i client on the base image and be done with it. > The larger question being will the 8i client work with the 8.0 databases ?? Yes. I use an 8.1.7 client to connect to db's version 7.1.6 and up all the time. No problem. You just can't go the other way and expect to do anything and everything (i.e., if you use a 7.x client to connect to an 8i database, don't expect to be able to work with LOBs). Jon Walthour -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How to sign-off this group?
Read the bottom of your email. > > From: Ben Le <[EMAIL PROTECTED]> > Date: 2001/08/20 Mon PM 04:04:08 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: How to sign-off this group? > > Would some one please tell me how to sign-off this group. It was a > pleasure to be in this excellent group in the past years. Thank you. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Ben Le > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RE: WARNING: CURSOR_SHARING=FORCE on 8.1.7
Rich: Please let me know if the problem goes away for you with any of the patches or if the only real fix is to go to 9i. Jon Walthour > > From: "Jesse, Rich" <[EMAIL PROTECTED]> > Date: 2001/08/20 Mon PM 01:32:30 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: WARNING: CURSOR_SHARING=FORCE on 8.1.7 > > Hey Jon, > > We're on 8.1.7.1.0. And as luck would have it, 8.1.7.2.0 came out THE DAY > AFTER our upgrade, so I dunno if it appears there. > > Rich Jesse System/Database Administrator > [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA > > > -Original Message- > Sent: Monday, August 20, 2001 11:12 > To: Multiple recipients of list ORACLE-L > > > Rich: > > This is Bug #1561329: ORA-12704 character set mismatch on select with > cursor_sharing = force. This bug apparently appears only in 8.1.7 on HP-UX. > In this case, CURSOR_SHARING must be set to EXACT. I'm not sure, but I seem > to remember that it didn't give me problems in 8.1.7.1.x, only in 8.1.7.0.x. > > Jon Walthour > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jesse, Rich > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: environmental variables
Simple. Put them in a batch file: @echo off set env1 = One set env2 = Two set oracle_sid = mydb ... Then reference like normal C:\> echo %oracle_sid% mydb Jon Walthour > > From: [EMAIL PROTECTED] > Date: 2001/08/20 Mon PM 02:36:36 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: environmental variables > > Is there any way to create NT environmental variables through script? > > Lyuda Hoska > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: WARNING: CURSOR_SHARING=FORCE on 8.1.7
Rich:
This is Bug #1561329: ORA-12704 character set mismatch on select with cursor_sharing =
force. This bug apparently appears only in 8.1.7 on HP-UX. In this case,
CURSOR_SHARING must be set to EXACT. I'm not sure, but I seem to remember that it
didn't give me problems in 8.1.7.1.x, only in 8.1.7.0.x.
Jon Walthour
>
> From: "Jesse, Rich" <[EMAIL PROTECTED]>
> Date: 2001/08/20 Mon AM 11:05:29 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: WARNING: CURSOR_SHARING=FORCE on 8.1.7
>
> Hi all,
>
> Just thought I'd share an "experience" (ON-TOPIC!) with everyone. After
> upgrading from 8.0.6 to 8.1.7 on HP/UX 11.0, we've had a few problems with
> CURSOR_SHARING=FORCE. The reason I decided to use it is because our apps
> don't use bind variables and I wanted to decrease the size of our shared
> pool to help reduce latch contention. I figured this was the *easy*
> solution!
>
> Well, after almost three weeks, we're OK, but there is one lingering
> occasional problem. Under certain circumstances (I can't seem to get what
> exactly those are), specific DML will always generate an "ORA-12704
> character set mismatch" error when using CURSOR_SHARING=FORCE and CBO.
> Oracle knows about this and say it's fixed in 9i. However, they also say
> that a backport of the fix to 8.1.7 is "not feasible".
>
> One common theme in the offending DML seems to be the use of functions in a
> GROUP BY or ORDER BY clause, but it's not consistent. However, Oracle
> Support was able to consistently reproduce the error. I've attached the
> output from the script (set echo on) in case anyone is interested in
> testing. Note however that not all SQL I've had blow up with this uses the
> ORDERED hint or deals with unanalyzed tables. Also note that Oracle Support
> says the workaround is to ALTER SESSION SET CURSOR_SHARING=EXACT for each
> problem statement.
>
> And last week I went to a quickie seminar with Kevin Loney/TUSC/Veritas,
> where Kevin recommended waiting for 9i before using CURSOR_SHARING=FORCE.
> Now I think I'll need to plan how I'm going to turn it off: How big
> to make the shared pool? Do I now use histograms? etc. Like I didn't have
> enough to do...
>
> Hope this helps someone else planning an upgrade to 8i! :)
>
> Rich Jesse System/Database Administrator
> [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
>
>
>
>
>SQL> alter session set cursor_sharing=force;
>
>Session altered.
>
>SQL> drop table test12704;
>
>Table dropped.
>
>SQL> create table test12704 (f1 varchar2(3), f2 varchar2(3)) tablespace users ;
>
>Table created.
>
>SQL> insert into test12704 values ('A', 'B');
>
>1 row created.
>
>SQL> insert into test12704 values ('C', 'D');
>
>1 row created.
>
>SQL> commit;
>
>Commit complete.
>
>SQL> select * from test12704;
>
>F1 F2
>--- ---
>A B
>C D
>
>SQL> select * from test12704 where (f1 = 'A' and f2 = 'B') or (f1 = 'C' and f2 =
>'D');
>
>F1 F2
>--- ---
>A B
>C D
>
>SQL> select /*+ ORDERED */ * from test12704 where (f1 = 'A' and f2 = 'B') or (f1
>= 'C' and f2 = 'D');
>where (f1 = 'A' and f2 = 'B') or (f1 = 'C' and f2 = 'D')
>*
>ERROR at line 2:
>ORA-12704: character set mismatch
>
>SQL> analyze table test12704 compute statistics;
>
>Table analyzed.
>
>SQL> select * from test12704 where (f1 = 'A' and f2 = 'B') or (f1 = 'C' and f2 =
>'D');
>
>F1 F2
>--- ---
>A B
>C D
>
>SQL> alter session set cursor_sharing=exact;
>
>Session altered.
>
>SQL> select * from test12704;
>
>F1 F2
>--- ---
>A B
>C D
>
>SQL> select * from test12704 where (f1 = 'A' and f2 = 'B') or (f1 = 'C' and f2 =
>'D');
>
>F1 F2
>--- ---
>A B
>C D
>
>SQL> select /*+ ORDERED */ * from test12704 where (f1 = 'A' and f2 = 'B') or (f1
>= 'C' and f2 = 'D');
>
>F1 F2
>--- ---
>A B
>C D
>
>SQL> analyze table test12704 compute statistics;
>
>Table analyzed.
>
>SQL> select * from test12704 where (f1 = 'A' and f2 = 'B') or (f1 = 'C' and f2 =
>'D');
>
>F1 F2
>--- ---
>A B
>C D
>
>
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jon Walthour
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: transaction ???
Raja:
The view you're thinking of with a sql_text column of 1000 characters is
v$sqlarea, not v$sqltext. In v$sqltext, the column sql_text is
varchar2(64) but the text of the statement is there completely, broken
over various lines. These lines can be ordered by the column "piece".
DBA_SOURCE, on the other hand, is a view showing all the source code in
the database, such as that for packages, procedures and triggers. So, it
is not currently running SQL, but SQL that has been compiled into the
database for later use. I most often use the owner column to join that
view with, say, dba_users. The column "line". in this case, orders the
various code fragments contained in the column "text".
Jon Walthour
-Original Message-
Luthra
Sent: Sunday, August 19, 2001 9:50 PM
To: Multiple recipients of list ORACLE-L
Hello,
The sql_text that is there in v$sqltext is only 1000 chars wide, where
as the text field in dba_source is 4000 chars. long. How do I get the
text from dba_source, as I am not able to join that table with any other
suitable table.
Any help/comments?
rgds,
raja
--
On Sun, 19 Aug 2001 17:15:30
Jon Walthour wrote:
>To find currently running sql, run the following query:
>
>SELECT a.username AS username
> , a.sid AS sid
> , a.serial# AS ser#
> , b.sql_text AS statement
>FROM v$session a
> , v$sqltext b
> WHERE a.username IS NOT NULL
> AND a.status = 'ACTIVE'
> AND a.sql_address = b.address
> AND a.sql_hash_value = b.hash_value
> AND a.audsid != USERENV('sessionid')
>ORDER BY sid
> , ser#
> , b.piece;
>
>To check out lots of scripts for tuning, look into Steve Adams' website
>at http://www.ixora.com.au.
>
>Jon Walthour
>-Original Message-
>Linsy
>Sent: Sunday, August 19, 2001 6:41 PM
>To: Multiple recipients of list ORACLE-L
>
>Hi, all
>
>How to find the currently running transaction,
>including user, sql_text, etc?
>
>Do you have any scripts for monitoring, tuning
>transactions?
>
>Thank you!
>
>Janet
>
>__
>Do You Yahoo!?
>Make international calls for as low as $.04/minute with Yahoo!
>Messenger http://phonecard.yahoo.com/
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Janet Linsy
> INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
>message BODY, include a line containing: UNSUB ORACLE-L (or the name of
>mailing list you want to be removed from). You may also send the HELP
>command for other information (like subscribing).
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Jon Walthour
> INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
>message BODY, include a line containing: UNSUB ORACLE-L (or the name of
>mailing list you want to be removed from). You may also send the HELP
>command for other information (like subscribing).
>
Get 250 color business cards for FREE!
http://businesscards.lycos.com/vp/fastpath/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Viraj Luthra
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from). You may also send the HELP
command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jon Walthour
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: transaction ???
To find currently running sql, run the following query:
SELECT a.username AS username
, a.sid AS sid
, a.serial# AS ser#
, b.sql_text AS statement
FROM v$session a
, v$sqltext b
WHERE a.username IS NOT NULL
AND a.status = 'ACTIVE'
AND a.sql_address = b.address
AND a.sql_hash_value = b.hash_value
AND a.audsid != USERENV('sessionid')
ORDER BY sid
, ser#
, b.piece;
To check out lots of scripts for tuning, look into Steve Adams' website
at http://www.ixora.com.au.
Jon Walthour
-Original Message-
Linsy
Sent: Sunday, August 19, 2001 6:41 PM
To: Multiple recipients of list ORACLE-L
Hi, all
How to find the currently running transaction,
including user, sql_text, etc?
Do you have any scripts for monitoring, tuning
transactions?
Thank you!
Janet
__
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Janet Linsy
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jon Walthour
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: How to find maximum number of concurrent sorts from instance star
To find the maximum number of concurrent sorts from instance start, run the following query: SELECT LEAST(disk_sorts, peak) AS peak_concurrent FROM (SELECT VALUE AS disk_sorts FROM sys.v_$sysstat WHERE name = 'sorts (disk)') , (SELECT /*+ ordered */ SUM(l.max_utilization) peak FROM (SELECT /*+ ordered */ DISTINCT t.contents$ FROM (SELECT DISTINCT tempts# FROM sys.user$ WHERE type# = 1) u , sys.ts$ t WHERE t.ts# = u.tempts#) y , sys.v_$resource_limit l WHERE (y.contents$ = 0 AND l.resource_name = 'temporary_table_locks') OR (y.contents$ = 1 AND l.resource_name = 'sort_segment_locks')); Jon Walthour -Original Message- Alex Sent: Friday, August 17, 2001 7:01 PM To: Multiple recipients of list ORACLE-L star -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Please Help - ora error
Alex: This is a fallacy that's been around since Oracle 6. In actuality, one wants to set the initial and next extents of a temporary tablespace to the same size as the size of the average sort in memory to ensure that most disk sorts can be accommodated within a single temporary tablespace extent. This avoids the unnecessary overhead of extent allocation. You can determine the size of the average disk sort with the following query: SELECT DECODE(disk_sorts, NULL, 0, 0, 0, ROUND((blocks_written * block_size) / disk_sorts, 0)) AS avg_sort_size FROM (SELECT VALUE AS disk_sorts FROM sys.v_$sysstat WHERE name = 'sorts (disk)') , (SELECT NVL(SUM(fs.phyblkwrt), 0) AS blocks_written FROM dba_data_files df , sys.v_$filestat fs , dba_tablespaces ts WHERE df.file_id = fs.file# AND df.tablespace_name = ts.tablespace_name AND ts.contents = 'TEMPORARY') , (SELECT TO_NUMBER(VALUE) AS block_size FROM sys.v_$parameter WHERE name LIKE 'db_block_size'); For example, I just ran this query against one of our production systems and it said the average disk sort was 61,349,888 bytes. Now, if I set sort_area_size to just 1M (1,048,576), then Oracle would have to do an additional 58 extent allocations, if the extents are not already present in a temporary tablespace, and would possibly increase the number of multiblock reads necessary to fetch the data in merging together the sorted result set. For more information on this topic, take a look at Steve Adams' website http://www.ixora.com.au. Jon Walthour -Original Message- Alex Sent: Friday, August 17, 2001 11:52 AM To: Multiple recipients of list ORACLE-L Are you sure enough to post an answer? Alex Hillman -Original Message- Sent: Friday, August 17, 2001 2:45 AM To: Multiple recipients of list ORACLE-L Hi In case of Temporary Tablespace the Initital segemnt and next segment should be equal to the sort_area_size parameter. bye G.Subrahmanyam -Original Message- Sent: Thursday, August 16, 2001 8:28 PM To: Multiple recipients of list ORACLE-L Hello all, I have a strage error. 'ORA-01658: unable to create INITIAL extent for segment in tablespace TEMP'. The clients TEMP tablespace is 200M. The sql is:- SELECT a.username, length(sql_text), substr(sql_text,1,100) as "SQL TEXT", substr(sql_text,101,250) as "Second TEXT", substr(sql_text,351,250) as "Third TEXT", substr(sql_text,601,250) as "Fourth TEXT", substr(sql_text,851,250) as "Fifth TEXT", substr(sql_text,1101,250) as "Sixth TEXT" FROM sys.dba_users a, v$session, v$sqlarea WHERE parsing_user_id=user_id AND address=sql_address(+) ORDER BY executions desc / Can you please explain why I am getting this error and cannot run the simple SQL statement? Rgds, raja Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viraj Luthra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: G, Subrahmanyam (CAP) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command
Re: RE: Recovering WITHOUT tablespaces
Yes. > > From: Kumanan Balasundaram <[EMAIL PROTECTED]> > Date: 2001/08/17 Fri AM 10:11:10 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: Recovering WITHOUT tablespaces > > So if I just have SYSTEM, RBS, and TEMP along with the required data TS, it > will > be fine to "apply archive redo logs" of the DB? > If so, that will be great. > > Thanks > Kumanan > > > -Original Message- > > From: Jon Walthour [SMTP:[EMAIL PROTECTED]] > > Sent: 17 August 2001 14:16 > > To: Multiple recipients of list ORACLE-L > > Subject:Re: Recovering WITHOUT tablespaces > > > > Kumanan: > > > > Where I work, our databases are so big that we do it this way all the > > time. You need to restore the SYSTEM tablespace, at least one rollback > > tablespace, and any tablespaces you're interested in recovering from. > > You'll also need to have a copy of a 'backup controlfile to trace' script. > > You edit that script to include on the files you're recovering and use it > > to bring up the database. > > > > Jon Walthour > > > > > > From: Kumanan Balasundaram <[EMAIL PROTECTED]> > > > Date: 2001/08/17 Fri AM 07:55:29 EDT > > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > > Subject: Recovering WITHOUT tablespaces > > > > > > Hi I need to recover the database with only a number of tablespaces from > > HOT > > > backup. > > > > > > I know I can drop it from system later on, but will it cause any > > problems in > > > > > > applying archive logs with recover database statement? > > > > > > Any experiences/issues? > > > > > > Thanks > > > Kumanan > > > > > > > > > > > > ** > > > This email and any files transmitted with it are confidential and > > > intended solely for the use of the individual or entity to whom they > > > are addressed. If you have received this email in error please notify > > > [EMAIL PROTECTED] > > > > > > This footnote also confirms that this email message has been swept by > > > MIMEsweeper and Nortons Anti-Virus, for the presence of computer > > viruses. > > > > > > ** > > > -- > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > > -- > > > Author: Kumanan Balasundaram > > > INET: [EMAIL PROTECTED] > > > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > > San Diego, California-- Public Internet access / Mailing Lists > > > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > > the message BODY, include a line containing: UNSUB ORACLE-L > > > (or the name of mailing list you want to be removed from). You may > > > also send the HELP command for other information (like subscribing). > > > > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Jon Walthour > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing Lists > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Kumanan Balasundaram > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line
Re: linux for oracle
Uma: >From what I've seen and used myself, SuSE seem to be officially endorsed distro. I've >heard of people installing on RedHat, but I've also heard (especially concerning 9i) >that it is a pain in the a__ to get working--if at all. Jon Walthour > > From: "Rao, UmaSankara S (CAP)" <[EMAIL PROTECTED]> > Date: 2001/08/17 Fri AM 08:23:37 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: linux for oracle > > Hi Gurus, > > Can u please tell me the most stable version of Linux on which I can install > Oracle 8i? > > Thanks in advance > Uma > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Rao, UmaSankara S (CAP) > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Recovering WITHOUT tablespaces
Kumanan: Where I work, our databases are so big that we do it this way all the time. You need to restore the SYSTEM tablespace, at least one rollback tablespace, and any tablespaces you're interested in recovering from. You'll also need to have a copy of a 'backup controlfile to trace' script. You edit that script to include on the files you're recovering and use it to bring up the database. Jon Walthour > > From: Kumanan Balasundaram <[EMAIL PROTECTED]> > Date: 2001/08/17 Fri AM 07:55:29 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: Recovering WITHOUT tablespaces > > Hi I need to recover the database with only a number of tablespaces from HOT > backup. > > I know I can drop it from system later on, but will it cause any problems in > > applying archive logs with recover database statement? > > Any experiences/issues? > > Thanks > Kumanan > > > > ** > This email and any files transmitted with it are confidential and > intended solely for the use of the individual or entity to whom they > are addressed. If you have received this email in error please notify > [EMAIL PROTECTED] > > This footnote also confirms that this email message has been swept by > MIMEsweeper and Nortons Anti-Virus, for the presence of computer viruses. > > ** > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Kumanan Balasundaram > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RE: What file(s) does Oracle read in deciding what has been insta
Delete the directory structure under C:\Program Files\Oracle, as well. That's where Oracle keeps the inventory information (among other things). Jon Walthour > > From: Christopher Spence <[EMAIL PROTECTED]> > Date: 2001/08/16 Thu PM 01:28:15 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: What file(s) does Oracle read in deciding what has been insta > > Delete the oracle directory, then go into the registry and delete the > > HK_LOCAL_MACHINE\Software\Oracle > > Key. > > "Do not criticize someone until you walked a mile in their shoes, that way > when you criticize them, you are a mile a way and have their shoes." > > Christopher R. Spence > Oracle DBA > Phone: (978) 322-5744 > Fax:(707) 885-2275 > > Fuelspot > 73 Princeton Street > North, Chelmsford 01863 > > > > > -Original Message- > Sent: Thursday, August 16, 2001 12:47 PM > To: Multiple recipients of list ORACLE-L > > > Hi All, > > I am having great difficulty in getting Oracle 8.1.7 installed on Win 2k. I > have completely removed Oracle, i.e., directory,registry entries, program > groups and services. When I try to re-install it again Installer says 167 > products installed when in fact there are none. Where is Oracle reading > this from so I can delete this d__n file. > > Thanks > Rick > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Cale, Rick T (Richard) > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the > message BODY, include a line containing: UNSUB ORACLE-L (or the name of > mailing list you want to be removed from). You may also send the HELP > command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Christopher Spence > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Q about Oracle Optimizer
Volker: If optimizer_mode = 'choose', then the optimizer chooses between cost-based optimization and rule-based optimization based on whether or not statistics are present. In your case, since they aren't it's using rule-based. -Original Message- Volker Sent: Thursday, August 16, 2001 4:46 AM To: Multiple recipients of list ORACLE-L Hi list, a quick question about oracle optimizer. a customer has database migrated from 7.3.4 to 8.1.6 on AIX. Data was transfered via full exp/imp. After migration the performance of the new database is very poor. I looked at the parameters and saw that no object is analyzed. So now me question: What does oracle optimizer do, if there are no statistics on all objects. Optimizer level is choose. Volker Schön E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schoen Volker INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: A "modification time" question
If you can't modify the structure to add a timestamp column or add a trigger to insert a timestamp into another table, there's no way I know of to track it. Oracle doesn't track this sort of thing on its own; you need some sort of timestamp field. Jon Walthour -Original Message- Bronfin Sent: Thursday, August 16, 2001 7:16 AM To: Multiple recipients of list ORACLE-L Dear gurus ! Is there a way to know the time of insert/update for each row in a table ? Or , which rows in a table were inserted/updated since a certain time. ( Sort of find ... -mtime ... for UNIX files) . I CAN NOT modify the structure of the table , i.e. i CAN NOT add a timestamp or other column , just need to deal with what is present. Thanks a lot for your help !!! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: An SQL question , not easy ;-)
I think I have an alternative solution that, if you're using 8.1.6 or better, would
provide a pure SQL solution. It's probably not the tidiest SQL, but it works (as far
as I can tell):
SELECT c1 AS start_time
, c2 AS end_time
, total
FROM (SELECT LAG (call_time, 1) OVER (ORDER BY call_time) AS c1
, call_time AS c2
, incr
, SUM (incr) OVER (ORDER BY call_time RANGE UNBOUNDED PRECEDING) AS total
FROM (SELECT TO_CHAR (call_start, 'DD-MON-RR HH24:MI:SS') AS call_time
, 1 AS incr
FROM calls
UNION ALL
SELECT TO_CHAR (call_end, 'DD-MON-RR HH24:MI:SS') AS call_time
, -1 AS incr
FROM calls))
WHERE c1 IS NOT NULL
AND TO_DATE (c2, 'DD-MON-RR HH24:MI:SS') > TO_DATE (c1, 'DD-MON-RR HH24:MI:SS')
AND total = (SELECT MAX (total) AS max_sim_calls
FROM (SELECT LAG (call_time, 1) OVER (ORDER BY call_time) AS c1
, call_time AS c2
, incr
, SUM (incr) OVER (ORDER BY call_time RANGE UNBOUNDED
PRECEDING) AS total
FROM (SELECT TO_CHAR (call_start, 'DD-MON-RR HH24:MI:SS') AS
call_time
, 1 AS incr
FROM calls
UNION ALL
SELECT TO_CHAR (call_end, 'DD-MON-RR HH24:MI:SS') AS
call_time
, -1 AS incr
FROM calls)));
Jon Walthour
>
> From: "Lord, David - C&S" <[EMAIL PROTECTED]>
> Date: 2001/08/15 Wed AM 11:01:33 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: An SQL question , not easy ;-)
>
> Yes, so the maximum is 3, between 12:25 and 12:30. To explicitly show the
> maximum (and a little histogram) you could amend it as follows: -
>
> declare
> l_count pls_integer := 0;
> l_max_count pls_integer := 0;
> begin
> for rec in (
> select call_start time, 1 incr from table
> union all
> select call_end time, -1 incr from table
> order by 1
> ) loop
> l_count := l_count + rec.incr;
> if( l_count > l_max_count ) then
> l_max_count := l_count;
> end if;
> dbms_output.put_line( to_char(rec.time) || ' - ' || l_count
> || ' ' || lpad('*',l_count) )
> end loop;
> dbms_output.put_line( 'Maximum concurrent calls = ' ||
> to_char(l_max_count) );
> end;
>
> Regards
> David Lord
>
> > -Original Message-
> > From: Thomas, Kevin [mailto:[EMAIL PROTECTED]]
> > Sent: 15 August 2001 15:07
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: An SQL question , not easy ;-)
> >
> >
> > David,
> >
> > Here's the output from your suggestion based on a table
> > with the following rows;
> >
> > CALL_STARTCALL_END
> > - -
> > 01-AUG-2001 12:10 01-AUG-2001 12:40
> > 01-AUG-2001 12:15 01-AUG-2001 12:30
> > 01-AUG-2001 12:25 01-AUG-2001 12:55
> > 01-AUG-2001 12:45 01-AUG-2001 12:47
> >
> > -
> >
> > 01-AUG-2001 12:10 - 1
> > 01-AUG-2001 12:15 - 2
> > 01-AUG-2001 12:25 - 3
> > 01-AUG-2001 12:30 - 2
> > 01-AUG-2001 12:40 - 1
> > 01-AUG-2001 12:45 - 2
> > 01-AUG-2001 12:47 - 1
> > 01-AUG-2001 12:55 - 0
> >
> >
> >
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Lord, David - C&S
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> --------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jon Walthour
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Re: Pathname for Spool - [NT]
Sean: Use the shorter 8.3 directory name. You can get it with the dir /x command. Then you could do something like: t:\oracle\output\system~1\free_space.log Jon Walthour > > From: "O'Neill, Sean" <[EMAIL PROTECTED]> > Date: 2001/08/14 Tue AM 10:15:23 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: Pathname for Spool - [NT] > > Can anyone tell me if it is possible to specify a pathname using NT to a > file with SQL*Plus spool command if the pathname contains a space. For > example if I want to spool output of a SQL*Plus session to > t:\oracle\output\system check\free_space.log can this be done. I've tried > enclosing the pathname in " " and ' ' but that don't do it, it gives same > error message as for no "" or '': > > SP2-0333: Illegal spool file name: "t:\oracle\scripts\system > checks\free_space.log" (bad character: ' ') > > I'm hoping that I won't be stuck with having directory names with no spaces, > arrrggghh. > (and puhhleezze no comments about on Unix yada, yada, yada) > > > Sean :) > > Rookie Data Base Administrator > Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K > [0%] OCP Oracle8i DBA > [0%] OCP Oracle9i DBA > > Organon (Ireland) Ltd. > E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] > > Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA > > "Nobody loves me but my mother... and she could be jivin' too." - BB King > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: O'Neill, Sean > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Downloading patch from metalink
Rukmini: 1. Go to MetaLink 2. Go the "Patches" section (link on the left-hand bar) 3. Click on "Click here for patches release after February 19, 2001 and for all Application patches" 4. Enter your patch number (725440) in the "Patch Number" field and click "Submit" at the bottom of the page. 5. Download the patch for your particular platform. Simple as that. Jon Walthour > > From: "Rukmini Devi" <[EMAIL PROTECTED]> > Date: 2001/08/14 Tue AM 08:11:43 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: Downloading patch from metalink > > Hi All, > >I want to download a patch 725440 to avoid the error APP-22067 in Oracle >Applications 10.7SC. > This patch information I got it in metalink docid 1070670.6. > Can any one explain how to download this patch ? > > Thanks > rukmini > > > Hi All, I want to download a patch 725440 to avoid the error APP-22067 in Oracle Applications 10.7SC. This patch information I got it in metalink docid 1070670.6. Can any one explain how to download this patch ? Thanks rukmini
RE: different stats in sga..
Title: Message Sharma: Some of this extra memory is taken up with the redo log guard pages. Guard pages are one memory protection unit in size and are there to prevent Oracle software bugs or hackers from corrupting the log buffer. Another portion of the memory results from a minimum size for the log buffer of 4 * db_block_size. This rounding up is reflected in v$sga, but not in v$sgastat. Jon Walthour -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Saurabh SharmaSent: Tuesday, August 14, 2001 6:46 AMTo: Multiple recipients of list ORACLE-LSubject: different stats in sga.. Hi all, i've changed the log_buffer parameter in my init file to a little higher value( say from 32768 to 40960) and bounced my DB but sga shows the redo buffer to 73728 (no change in pre value) while looking into v$sgastat, it says log_buffers = 65536 (still no change in pre value) why is this so, i'm getting diff values.. can anyone explain. thanks Saurabh Sharma [EMAIL PROTECTED]http://www.geocities.com/saurabh00pc/stride.html
RE: 07_DICTIONARY_ACCESSIBILITY
Ron: All I can find on it is that it's an Oracle 8 parameter used to provide Oracle 7 dictionary accessibility. Not much, I know. Jon Walthour -Original Message- L. Sent: Monday, August 13, 2001 11:51 AM To: Multiple recipients of list ORACLE-L Does anyone have any experience and or info on the 07_DICTIONARY_ACCESSIBILITY parameter? Ron Smith Database Administrator [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: rollback tables
Srinivas: This query will tell you if your current session is using a rollback segment: SELECT s.sid , rn.name FROM sys.v_$session s , sys.v_$transaction t , sys.v_$rollname rn , (SELECT distinct sid FROM sys.v_$mystat) m WHERE t.addr = s.taddr AND rn.usn = t.xidusn AND s.sid = m.sid; HTH, Jon Walthour -Original Message- Shrinivas (MED, Keane) Sent: Monday, August 13, 2001 4:36 AM To: Multiple recipients of list ORACLE-L HI dba's can anybody tell me from which tables can i find whether my statement is generating rollback. post queries if you have.. thnx srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SGA info.
Raja: Let me see if I can explain it. As Girijan previously explained, some of this extra memory is taken up with the redo log guard pages. Guard pages are one memory protection unit in size and are there to prevent Oracle software bugs or hackers from corrupting the log buffer. Another portion of the memory results from a minimum size for the log buffer of 4 * db_block_size. This rounding up is reflected in v$sga, but not in v$sgastat. There is also a lot of "rounding up" and extra memory allocation like this going on with other structures in the sga to fill out full memory pages. This, too, is represented in v$sga, but not in v$sgastat. The remainder of the space is accounted for in the "empty pages" like the redo log buffer's guard pages that enclose various sga structures to avoid areas stepping on each other. These "empty pages" are also not accounted for in v$sgastat. HTH, Jon Walthour -Original Message- Luthra Sent: Sunday, August 12, 2001 10:41 PM To: Multiple recipients of list ORACLE-L Hello, Doing select * from v$sga shows:- NAME VALUE -- Fixed Size67688 Variable Size 18042880 Database Buffers 16777216 Redo Buffers 172032 What do you mean by "presence of 2 guard pages for the log buffer"? Please explain. rgds, raja -- On Sun, 12 Aug 2001 17:50:21 Girijan Puthran wrote: > >Raja, > 16k of this difference might be with respect to the log buffer >size (most probably) and this is due to the presence of 2 guard pages >for the log buffer on some Operating systems, and as for the remaining >space--I am not too sure. > > > Girijan > > > Message History > > > > >Please respond to [EMAIL PROTECTED] > >To: [EMAIL PROTECTED] >cc: > > > > Hello, > >I am running oracle 8.1.5.0.0 on hp11. > >If I select from V$sga I get at least 18104 more than what I see in >v$sgastat. Therefore I wanted to know why the figures are different and >what statistic in v$sgastat is not counted, and therefore the figure in >v$sgastat is low?? > >I am getting some thing like this:- > >select sum(value) from v$sga; > >35059816 > >select sum(bytes) from v$sgastat; > > 35041712 > >Please comment if you can, thanks in advance. > >rgds, > >raja >-- > >On Thu, 09 Aug 2001 10:25:21 > Seema Singh wrote: >>Hermanto >>which version of oracle u r running?Just see following output >>SVRMGR> connect internal; >>Connected. >>SVRMGR> select sum(value) from v$sga; >>SUM(VALUE) >>-- >>1033101472 >>1 row selected. >>SVRMGR> select sum(bytes) from v$sgastat; >>SUM(BYTES) >>-- >>1033044248 >>1 row selected. >>SVRMGR> show sga >>Total System Global Area 1033101472 bytes >>Fixed Size 73888 bytes >>Variable Size 537395200 bytes >>Database Buffers49152 bytes >>Redo Buffers 4112384 bytes >>If u see all three output you can see the diffrence.The correct view >>to check size of sga is v$sga. Hope this will help u. >>Thanks >>-Seema >> >> >> >>>From: Hermanto P <[EMAIL PROTECTED]> >>>Reply-To: [EMAIL PROTECTED] >>>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >>>Subject: RE: SGA info. >>>Date: Wed, 08 Aug 2001 20:51:10 -0800 >>> >>>Raja, >>>if i do what you do..the value is same. >>>i am not sure if you said the value between v$sgastat and v$sga is >>>different. >>> >>>SVRMGR> select sum(value) from v$sga; >>>SUM(VALUE) >>>-- >>> 64046072 >>>1 row selected. >>>SVRMGR> select sum(bytes) from v$sgastat; >>>SUM(BYTES) >>>-- >>> 64046072 >>>1 row selected. >>>SVRMGR> >>> >>>Warm Regards, >>> >>>Hermanto P >>>Application Engineer >>>PT Riau Andalan Pulp And Paper - IT/IS Dept. >>>Phone : (0761) - 491147 / 491354 >>>HP: 0812-752-3092 >>>"Dream as if you'll live forever, live as if you'll die today" >>> >>> >>> >>> >>>-Original Message- >>>Sent: Thursday, August 09, 2001 11:30 AM >>>To: Multiple recipients of list ORACLE-L >>> >>> >>&g
RE: which segment need more freelist?
Title: Message
Chao_ping:There is no "tally" of buffer
busy waits (bbw's) as related to segments. You can see total bbw's with this
query:SELECT w.class AS
block_class , w.COUNT AS
total_waits , w.TIME AS
time_waited , ROUND(w.COUNT /
(consistent_gets + db_block_gets), 3) AS bbw_ratio FROM
sys.v_$waitstat w , (SELECT
(SUM(DECODE(name, 'no work - consistent read gets', VALUE, 0)) +
SUM(
DECODE(
name
, 'cleanouts only - consistent read gets',
VALUE
,
0))
+ SUM(DECODE(name, 'rollbacks only - consistent read gets', VALUE,
0))
+ SUM(DECODE(name, 'cleanouts and rollbacks - consistent read gets', VALUE, 0)))
AS
consistent_gets
FROM sys.v_$sysstat) , (SELECT VALUE AS
db_block_gets
FROM v$sysstat
WHERE name = 'db block gets') WHERE w.COUNT > 0ORDER BY 3
DESC;You can see bbw's per datafile with this query:SELECT d.name AS
filename , d.file# AS
file_id , w.COUNT AS
waits ,
w.TIME , w.TIME / (DECODE(w.COUNT, 0, 1,
w.COUNT)) AS average FROM sys.x_$kcbfwait
w , sys.v_$datafile d
WHERE w.indx + 1 = d.file# AND w.indx < (SELECT
COUNT(*)
FROM sys.v_$datafile) AND w.COUNT > 0ORDER BY
w.COUNT DESC;When a given session is on a bbw, you can see what
segment the block is a part of with this query:SELECT LOWER(s.username) AS
username ,
s.osuser ,
s.sid ,
s.serial# , sw.event AS
wait_event , sw.seconds_in_wait AS
time ,
LOWER(
'file: '|| SUBSTR(df.file_name, INSTR(df.file_name, '/', -1) + 1) || CHR(10) ||
'object: ' || map.owner || '.' || map.segment_name ||
'('
|| bc.class || ')') AS details FROM sys.v_$session_wait
sw , sys.v_$session
s , sys.dba_data_files
df , (SELECT
owner
,
segment_name
,
segment_type
, file_id AS
file#
, block_id AS
lo_blk
, block_id + blocks - 1 AS
hi_blk
FROM dba_extents) map , (SELECT
file#
,
dbablk
,
DECODE(
class
, 1, 'data
block'
, 2, 'sort
segment'
, 3, 'save
undo'
, 4, 'segment
header'
, 5, 'save undo segment
header'
, 6, 'freelist
block'
, 7, 'system undo
header'
, 8, 'system undo
block'
, DECODE(MOD(class, 2), 1, 'undo header', 0, 'undo block')) AS
class FROM
sys.x_$bh) bc WHERE sw.sid = s.sid
AND sw.p1 = df.file_id AND sw.p1 =
map.file# AND sw.p2 BETWEEN map.lo_blk AND
map.hi_blk AND bc.file# =
sw.p1 AND bc.dbablk =
sw.p2 AND sw.event = 'buffer busy
waits';
However, I know of no way to get a
system-level view of what segments have been experiencing bbw's. If anyone knows
of any way, please let me know as I would love to know.
Regards,
Jon Walthour, BSCDCincinnati,
Ohio-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of
chao_pingSent: Saturday, August 11, 2001 9:30 AMTo: Multiple recipients
of list ORACLE-LSubject: which segment need more freelist?hi,
grurus: i know if a table is frequently inserted/updated,
oracle will meet freelist (or freelist groups) contention, but how to find out
which table on earth meet the wait of the segment head
freelist? which view shall i refer
to? thanks.chao_ping.from
china.>±z¡r9,¶Ã©¢j?jÉ¡r´ÈÂIóßç_çÓjzj¢hq³¶DTº¢¶u1j ´¹rr¢\²¡²®v
²xbjyµ59,®¡·Á¶½®¢É©l¢Ç§vØ^ BÏr¦jw_¢º->
êâ?«b¢ybë.n?¸
Re: PL/SQL length overflow prob
Uma: This is a restriction of DBMS_OUTPUT. It can only output a line of up to 255 characters. To fix it, you'll need to break up the output into multiple lines or use DBMS_OUTPUT.PUT instead of DBMS_OUTPUT.PUT_LINE to concatonate several pieces together into one line. HTH! Jon Walthour > > From: "Rao, UmaSankara S (CAP)" <[EMAIL PROTECTED]> > Date: 2001/08/08 Wed AM 09:50:23 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: PL/SQL length overflow prob > > HI, > > I am encountering the following problem in my pl/sql programme.Please let me > know how to counter ths prob: > > DECLARE > > * > > ERROR at line 1: > > ORA-2: ORU-10028: line length overflow, limit of 255 bytes per > line > > ORA-06512: at "SYS.DBMS_OUTPUT", line 99 > > ORA-06512: at "SYS.DBMS_OUTPUT", line 65 > > ORA-06512: at line 30 > > > Thanks in advance, > Uma > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Rao, UmaSankara S (CAP) > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: avoid duplicate sql
Srinivas: How about this: select sid , serial# from sys.v_$session where (sysdate-logon_time) <= (30/(24*60)); This will give you a list of all the sessions that have been connected for 30 minutes or less. HTH Jon Walthour > > From: "Tatireddy, Shrinivas (MED, Keane)" <[EMAIL PROTECTED]> > Date: 2001/08/08 Wed AM 09:15:26 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: avoid duplicate sql > > Hi lists > > i need help in writing a sql query: > > i am trying to capture the session information from v$session and > inserting the same into someother table xyz with columns username, > logon_time. (scott logged in at 10:30 hrs) > > i put this script in cron. it runs every 30 minutes. but i need the > values shoudld not be duplicated. > > Every time the shell script runs, it inserts values into XYZ. table. > Here i need your help. The values should not be duplicated that are > being insreted into xyz. > > since username,logon_time are composite primary key, system will not > accept duplicates. > > Because, in the v$session, if the user stays more than 30 minutes, his > values will be sent to xyz table and as already xyz has that row > (inserted before 30 minutes by shell), system will deny to insert the > duplicate the value into xyz. > > any scripts? scripts? > > thanx in advance > srinivas > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Tatireddy, Shrinivas (MED, Keane) > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ora-600 ..sort extent pool??
Raghu: What I have found suggests that you are having latch contention on the SORT EXTENT POOL. The "510" indicates that a call was made to free a latch that is unowned. The second parameter is the address for that latch. The third argument is the type of child latch that the kernel was trying to free. Oracle processes doing sorting that require access to a sort segment in a temporary tablespace are coordinated by a SHARED POOL structure called the SORT EXTENT POOL. This structure contains a description of all of the active sort segments and their extents in the sort segment. Access to this structure is controlled by the SORT EXTENT POOL latch. Your problem could be due to latch contention on this latch. You can view the statistics on this latch by joining v$latch and v$latchname on latch#. To reduce contention on this latch, increase the extent size by changing the NEXT value of the DEFAULT STORAGE clause of the temporary tablespace in which you are sorting. Jon Walthour - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Saturday, August 04, 2001 4:55 PM > > Hi Friends, > > When Iam rebuilding my index and clearing TEMP tablespace frequently..that > time I got this error..Any suggestions?? > > ORA-00600: internal error code, arguments: [510], [1073758876], [sort extent > poo > l], [], [], [], [], [] > > Thanks > Raghu. > > > _ > Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Raghu Kota > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: divide with decode
Srinivas:
What you're looking to do is find the value of physical reads/db block gets.
So, you want the value1/value2 where value1 is 'physical reads' and value2
is 'db block gets'. So, what you need to do is put the literals 'physical
reads' and 'db block gets' in the where clause somehow rather than use
decode. There are several ways to do this, but here is the way I would:
select physical_reads/db_block_gets as
from (select to_number(value) as physical_select
physical_reads/db_block_gets as reads_per_get
from (select to_number(value) as physical_reads
from sys.v_$sysstat
where name = 'physical reads')
, (select to_number(value) as db_block_gets
from sys.v_$sysstat
where name = 'db block gets');
Jon Walthour
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Saturday, August 04, 2001 12:20 PM
> hi lists
>
> can anybody help me for the flwng :
>
> i need to do calculation dividing phy reads value/db block gets
>
> i am following the principle
>
> select decode(name,'physical reads',value)/decode(name,'db block
> gets',value)
> from v$sysstat
> where name in ('db block gets','physical reads')
>
> just this query is returning notthing.
>
> i tried with to_number function also, that is not also returning
> anything.
>
> is there any trick to solve this.
>
> srinivas
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Tatireddy, Shrinivas (MED, Keane)
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jon Walthour
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Re: Your ideas will be helpful
Helen: How about a select statement that will do it for you instead of all the looping? Does this work? select asset_num , decode(min(num), 1, 'DHI', 2, 'AHI', 3, 'CHI', '???') as company_id from (select asset_num , decode(company_id, 'DHI', 1, 'AHI',2, 'CHI', 3, 4) as num from assets)group by asset_num; Hope this helps. Jon Walthour - Original Message - From: Helen rwulfjeq To: Multiple recipients of list ORACLE-L Sent: Wednesday, August 01, 2001 5:12 PM Subject: Your ideas will be helpful Hello, all: I'm import data from schema1.table1 (ASSET_NUM,COMPANY_ID,CONSOLI_ID……) to schema2.table2 (ASSET_NUM,COMPANY_ID,CONSOLI_ID……)using SQL script on Oracle 8i. The situation is like this: In schema1.table1, it does not has a Primary Key and Table1.ASSET_NUM has duplicated records while values in COMPANY_ID are different. For example: ASSET_NUM COMPANY_ID -- -- AA237334 AHI AA237334 DHI On the other hand, in schema2.table2, the corresponding column Table2.ASSET_NUM is defined as a NOT NULL, Primary Key. These tables' definition can't be modified. So, I need to drop the duplicated ASSET_NUM/records from schema1.table1 and then import into schema2.table2. The rule of drop will depend on the priorities of COMPANY_ID (ranking as < Dxx, Axx, Cxx >, from < Keep to Drop >. which means between Axx & Dxx, "Dxx" will be imported. For instances, like the above example, record contains 'AHI' will be dropped. This rule is only depended on the first Character -- substr(company_id, 1,1). ) I thought about: 1/ loop a cursor on whole table1? 2/ just duplicate records and then the rest records will be "insert into table2" directly. Then how do I decide which record to drop? Use a second cursor? 3/ screen all the duplicate record into a temp table and create a PK on that table and then decide… (this sounds very redundant) Any ideas how can I do this? Thanks in advance Helen Do You Yahoo!?Make international calls for as low as $.04/minute with Yahoo! Messengerhttp://phonecard.yahoo.com/
Re: Import Issue/question
That you have to do on your own by analyzing the tables and indexes after the import is finished. Jon Walthour - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, August 01, 2001 4:37 PM > > What about generating statistics? > > Mike Hand > Polaroid Corp > > -Original Message- > > Hi, > > What is the Import utility doing exactly after it says > the rows of a table have been imported? > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Hand, Michael T > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: import table from SQL server To Oracle
Mitchell: I can think of two ideas: Oracle's Transparent Gateway for Microsoft SQL Server and Microsoft Access. With Access I would think you could import the SQL Server data into Access then use Oracle's Access Migration tool to migrate the data into Oracle. There is, of course, also flat files and SQL*Loader. Jon Walthour - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, August 01, 2001 3:31 PM > Dear DBAs > > is there any tool available to import table from SQL 2000 server To Oracle > 8.5 online or by other way. > > Mitchell > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Mitchell > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Help, processes won't die
Ruth: Just a couple of notes: first, PMON, not SMON, is responsible for process cleanup--clean up of the components of failed transactions such as cache entries, locks and other process resources. In instance recovery, PMON will rollback any uncommitted transactions. On the other hand, SMON recovers temporary segment space when it's no longer needed, coalesces contiguous areas of free space in database tablespaces where PCTINCREASE is greater than zero, and recovers dead transactions skipped during crash and instance recovery because of file-read or offline errors, which are eventually recovered by SMON when the tablespace or file is brought back online. So, PMON is the instance process needed in this situation. Second, if Ivan were to perform a shutdown abort in this situation, it would bring the instance down real fast, that's true. However, startup would take that much longer and would require recovery of the database and transactions could be lost. I would not recommend a shutdown abort except as a last resort. Hope this helps. Jon Walthour - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, August 01, 2001 3:06 PM > It is smon who takes care of cleaning up after killed jobs. You can pay him > now or pay him later as the metaphor is mixed but you will have to let him > do his job. You can try a shutdown abort and startup but they smon will do > the cleanup in the background while your users scream. > > So, Kim is right. You have to let smon do his thing. > HTH, > Ruth > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Wednesday, August 01, 2001 1:56 PM > > > > It could be rolling back. If so, you really do have to wait. > > > > -Original Message- > > Sent: Wednesday, August 01, 2001 10:02 AM > > To: Multiple recipients of list ORACLE-L > > > > > > > > I need some assistance ASAP. Our nightly batch process seems to have hung > > up for some strange reason (ok no biggie my boss says kill it and start it > > again). The problem is I have killed the processes both in oracle (sid, > > serial#) and also in unix. Now I can't see the processes in unix but in > > oracle they have a status of killed but are still holding the resources. > My > > thinking is telling me the pmon is not waking up or not doing it's job. > How > > can one manually tell a process to wake up. Any help will be greatly > > appreciated. > > > > OS Solaris 7 > > Oracle 8.0.6.3 > > > > Thanks. Ivan > > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Ruth Gramolini > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Help, processes won't die
Title: Help, processes won't die Ivan: The problem is that there is no way to "wake up" PMON. PMON is cleaning up and rolling back all uncommitted transactions every 3 minutes and this isn't configurable. If this is 8i, you could have used alter session ... kill session immediate, although if you've already killed it normally, you can't try to kill it again. Seems the only way to clean it out is to bounce the instance, although that may take time, too. Just a thought: you could also try, for future reference, setting CLEANUP_ROLLBACK_ENTRIES. It sets how may rollback entries are cleaned up on a single pass. This became a hidden parameter in 8.1.3 and, since I never officially advocate the use of hidden parameters, if you're using 8.1.3 or higher and use it, you're on your own. - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Wednesday, August 01, 2001 1:01 PM Subject: Help, processes won't die I need some assistance ASAP. Our nightly batch process seems to have hung up for some strange reason (ok no biggie my boss says kill it and start it again). The problem is I have killed the processes both in oracle (sid, serial#) and also in unix. Now I can't see the processes in unix but in oracle they have a status of killed but are still holding the resources. My thinking is telling me the pmon is not waking up or not doing it's job. How can one manually tell a process to wake up. Any help will be greatly appreciated. OS Solaris 7 Oracle 8.0.6.3 Thanks. Ivan
Re: cleaning up oracle homes on NT
Patrice: If you're talking about the filesystem, everything should be under the %ORACLE_HOME% directory (usually c:\oracle\ora81 or the like). The registry entries are all in HKLM\Software\Oracle. Just run regedit and delete this key to remove all the Oracle registry keys. Also, the OUI will not uninstall itself. List, please correct me if I'm mistaken here. Jon Walthour - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, August 01, 2001 7:41 AM Andrea asked about removing NT services. What about Oracle homes? The Oracle Universal Installer appears to be doing a poor job of cleaning those up when we de-install Oracle software. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin & Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: simple sql problem
Raja: Let me put my two cents into the idea bin. How about: select decode(sign(num-1),-1,'0' || to_char(num), to_char(num)) as num from t1; Jon Walthour - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, July 31, 2001 1:10 AM > Hello all, > > If I have a situation, where I have the following:- > > select x+y from blah > > and if x+y > 1, eg 5 then the output can be 5, > but if x+y < 1, eg, .92, then I need the output as 0.92. > > How do I do this? > > rgds, > > raja > > > Get 250 color business cards for FREE! > http://businesscards.lycos.com/vp/fastpath/ > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Viraj Luthra > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: performance pl/sql for DW conclusion
To completely install the DBMS_PROFILER package, run: 1. $ORACLE_HOME/rdbms/admin/profload.sql - to install the package (run as SYS) 2. $ORACLE_HOME/rdbms/admin/proftab.sql - to create the appropriate tables for the package. You can either run this script in the schema of the user who is going to use DBMS_PROFILER or, as I do, run it as SYSTEM, then create the appropriate synonyms and grant the appropriate permissions to use the tables. Jon Walthour - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, July 30, 2001 7:30 PM Looks like DBMS_PROFILER is not installed using catproc. I found loadprof.sql rdbms/admin which will install it. Any other way to install it? I did not find any scripts in rdbms/admin which call profload.sql. Alex Hillman -Original Message- Sent: Monday, July 30, 2001 6:31 PM To: Multiple recipients of list ORACLE-L DBMS_PROFILER is great, if you have PL/SQL Developer, it has a great interface to it. "Walking on water and developing software from a specification are easy if both are frozen." Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Monday, July 30, 2001 5:41 PM To: Multiple recipients of list ORACLE-L Hi guys Thanx everyone, I found what was going on. A special thank-you to Raj for pointing out the dbms_profiler, what a wonderful tool. Using that tool I discover that it was my select, and not the parsing or inserts, that were causing the problem. I created a bunch of indexes for all my dimension tables, and voilà... Down to 500 rows in 5 seconds. I love that list :-) FYI: SGA is fine, hit ratio ok, on that side, server and DB are going well, it was really my coding or pl/sql the problem. Now I know I was not helping my code at all. Thanks again to everyone who helped. Merci Steph, je te répond bientôt... Daniel -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Daniel Garant INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Urgent..DB creation problem..
There's not a database on the server yet, that's true. Oracle is just trying to start the instance with the initSID.ora file it has. Are you using MTS? If not, the way to fix the problem is to remove the MTS_DISPATCHERS parameter from your initSID.ora file. To make this work, when the db assistant gets done with all the setup and offers to either create the db or save off the scripts for running later, save the scripts then edit the initSID.ora to make sure the MTS_DISPATCHERS parameter isn't there. Then run the scripts yourself and you shouldn't have that problem. Jon Walthour - Original Message - From: Saurabh Sharma To: Multiple recipients of list ORACLE-L Sent: Saturday, July 28, 2001 2:50 AM Subject: Urgent..DB creation problem.. Hi all, i'm having a problem in creating new database through database config assistant. after giving all information (both in typical and custom mode) it starts creating DB, but soon shows the msg "invalid specification for mts_dispatcher in initSID.ora file.." while there is no DB on the server, how is it reading the init.ora file. i've not specified any new mts_dispatcher parameter value. why it is showing me the error msg. how to counter this. other errors are oracle not available. error code ORA-00101 invalid specification for system parameter MTS_DISPATCHERS Saurabh Sharma [EMAIL PROTECTED]http://www.geocities.com/saurabh00pc/stride.html
Re: Unusable index
Prasad: If you have access to MetaLink, see Note 1054736.6 "How Do Indexes Become Index Unusable?" If you don't, let me know and I'll copy the article for you. Jon Walthour - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Saturday, July 28, 2001 1:45 AM > Hi dba's > > can anybody clarify what is unusable index, in what > situation will become unusable? > > and the solution to reuse it? > > thanx in adva. > > prasad. > > __ > Do You Yahoo!? > Make international calls for as low as $.04/minute with Yahoo! Messenger > http://phonecard.yahoo.com/ > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: prasad maganti > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: no create system tbs ?????
Sinardy: The SYSTEM tablespace is created with the CREATE DATABASE statement. Its datafile is the file set out in the DATAFILE portion of the statement. Jon Walthour - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Saturday, July 28, 2001 12:20 AM > Hi all, > > When I am using dbassist to create "create DB script", > > First of the script is for something like: > CREATE DATABASE > > .. > redo bla bla > datafile > logfile > > ; > > Second script > > ALTER TABLESPACE SYSTEM > DEFAULT STORAGE > > . > . > . > . > > CREATE TABLESPACE tool > > ... > .. > > CREATE TABLESPACE rbs > > > > My question is in second script, where we create the tablespace call system > ? > alter tablespace will not create tablespace, am I right ? > > > Regards, > Sinardy > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Sinardy > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: CURSOR_SHARING = FORCE
Larry, et. al., I'm running 8.1.7.1.1 on Win 2K Pro SP2. I did the following: alter session set cursor_sharing=force; select 'x' from dual; select 'X' from dual; select ' x' from dual; select ' X' from dual; select 'x ' from dual; select ' x ' from dual; select ' X ' from dual; No problems with any of 'em. Jon Walthour >--- Original Message --- >From: "Larry Elkins" <[EMAIL PROTECTED]> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Date: 7/27/01 12:41:20 PM > >Mark, > >Thanks for running the test. I would be interested if anyone could test on >the latest version of 8.1.7 on Win2000. I called a friend and had them test >on the latest release on HP-UX and they couldn't duplicate the bug. > >My inability to duplicate on *my* machine was due to a brain cramp -- I >didn't force a hard parse of the statement like I had at the client. Cursor >sharing is set to exact on my machine. I tried the statement with the >trailing space, it worked. I then set to force and re-executed with no >problem. But, the statement wasn't hard parsed since it was found in the >shared pool. I can now duplicate without any problem by simply forcing my >statement to be hard parsed (just like I was doing on the client's >machine -- duh!): > >SQL> select 'x ' from dual; <<<<< this works (trailing space which didn't fail for you) 'x -- x sql> alter session set cursor_sharing = force; <<<< change to force session altered. sql> select 'x ' from dual; <<<< still works but it wasn't hard parsed. 'x -- x sql> Select 'x ' from dual; <<<< force a hard parse by changing lower case s to upper case select 'x ' from dual * error at line 1: ora-00600: internal error code, arguments: [17182], [366030328], [], [], [], [], [], [] so, it looks like the problem is with just cursor sharing itself (though it could still be a mix of parameters -- and i'm not going to try every combination!!!). thanks for the help. i don't know anything else you can do. i wrapped up the contract with the client yesterday after taking care of the major issues i was brought in to resolve. they can handle this issue and some other minor ones. since i *am* curious, i will probably give their dba a call in a week or two to see if they and/or oracle solved this with the latest version and patches for 8.1.7. and maybe someone on the list will be able to test against and up to date 8.1.7 on win2k regards, larry g. elkins [EMAIL PROTECTED] > -Original Message- >> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Mark Leith >> Sent: Friday, July 27, 2001 10:02 AM >> To: Multiple recipients of list ORACLE-L >> Subject: RE: CURSOR_SHARING = FORCE >> >> >> Larry, >> >> Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production >> With the Partitioning option >> JServer Release 8.1.7.0.0 - Production >> >> >select 'x ' from dual; >> >> 'X' >> >> x >> >> >select 'x' from dual; >> >> 'X' >> >> x >> >> >select ' x' from dual; >> select ' x' from dual >> * >> ERROR at line 1: >> ORA-00600: internal error code, arguments: [17182], [167886636], >> [], [], [], >> [], [], [] >> >> >alter system set cursor_sharing = exact; >> >> System altered. >> >> >select ' x' from dual; >> >> 'X >> -- >> x >> >> What can I share with you to help you out? This is on a test >> database only, >> so just let me know. Also note that the error was only thrown on >> mine with a >> leading space. >> >> This is Win2K Professional SP2. >> >> Cheers >> >> Mark > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Larry Elkins > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Rollback seg for big job
Prasad: As far as I know (and listers please correct me if I'm wrong) you can't single out the rollback segment you are using for that big transaction EXCLUSIVELY. In other words, since the rbs is still online and available, there is still the potential that another transaction could use that rbs as well. However, if you're running it at night, wouldn't your activity level be lower and thus the odds of getting another transaction in the same rbs be much lower as well? Just my 2 cents. Jon Walthour >--- Original Message --- >From: prasad maganti <[EMAIL PROTECTED]> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Date: 7/27/01 7:16:11 AM > >Hi dba's > >can anybody clarify my doubt reg. RBS. > >i need to run a very big job in night times. > >so , i have to create a very bigh rollback segment >purely intended for that job. > >so i will set at sql > >set trnx use rollback seg.. > >my doubt is whether this rollback segment stores the >rollback of my job or will it allow any other rollback >of the database (that is not part of my job) > >prasad. > >__ >Do You Yahoo!? >Make international calls for as low as $.04/minute with Yahoo! Messenger >http://phonecard.yahoo.com/ >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: prasad maganti > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: moving tables to a different tablespace
George: I think you need to do a fromuser/touser export/import here. Jon Walthour >--- Original Message --- >From: "Rusnak, George A." <[EMAIL PROTECTED]> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Date: 7/26/01 1:50:41 PM > >Hi Group, >Please explain what I am doing wrong. >1) exp outln/outln@webprod <mailto:outln/outln@webprod> file=exp_file >tables = 'OL$' 'OL$HINTS' >2) Dropped the tables: 'OL$' and 'OL$HINTS' on webprod >3) Created tablespace outln_ts on webprod >4) Altered user outln default tablespace outln_ts >5) imp outln/outln@webprod <mailto:outln/outln@webprod> file=exp_file >tables = 'OL$' 'OL$HINTS' >6) SQL> select table_name, tablespace_name > from dba_tables > where owner = 'OUTLN'; > > TABLE_NAME TABLESPACE_NAME > -- >-- >OL$ SYSTEM >OL$HINTS SYSTEM >XX >OUTLN_TS > >WHY are the tables being re-imported back into SYSTEM tablespace > >Oracle 8.1.7 on Sun Solaris 5.7 > >TIA > >Al Rusnak >804-734-8453 >[EMAIL PROTECTED] > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Rusnak, George A. > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: catparr.sql
Alex: I run catparr.sql as part of every database creation I do because it provides views that help with performance tuning, such v$bh for buffer cache data. The tables the script creates keep track of the status of all SGA blocks, too. Jon Walthour >--- Original Message --- >From: "Hillman, Alex" <[EMAIL PROTECTED]> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Date: 7/26/01 3:05:31 PM > >Is there any sense to run catparr.sql if I do not use OPS? > >Alex Hillman >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Hillman, Alex > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: how do i explain this ?
Is it possible that under 7.3.2 the optimizer was rule-based (I don't know when CBO was introduced) and that under 8.1.5 it is set to CHOOSE or FIRST_ROWS or ALL_ROWS? Also, is there anyway you could move to 8.1.6 and take advantage of the CURSOR_SHARING parameter? Jon Walthour - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, July 26, 2001 5:37 AM > list, > this application heavyly make use of literals , NO BIND VARIABLES > and was running without any lib cache latch or shared pool latch problems on > 7.3.2 > > We ported the DB to 8.1.5 and v$session_wait is full of "latch free" event > !! > all the latch waits are on lib cache and shapred pool (as expected from any > app NOT using bind vars) > and the app is running terribly slow !! > > my question is... how 7.3.2 was able to handle this ?? how i explain this to > my management ? > i was able to convince then on porting to 8i to get better perfornace !! > > note: i cannot change the app. all changes must be from the back end. > > TIA > > Rahul > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Rahul > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Securing passwords in scripts
If you're going to be doing DBA tasks like you describe (backups which require you to shutdown the database, etc.), you can just use "/ as sysdba" in sqlplus. This works all the way back to 7.3 as far as I know. For it to work, however, the OS account that is being used must be a member of the DBA group (Unix) or the ORA_DBA group (NT). In a UNIX script, I use it like this: sqlplus << EOF / as sysdba shutdown immediate exit EOF In NT, it would be a matter of putting all the commands in a .sql script and executing the script like this: sqlplus "/ as sysdba" @myscript.sql Hope this helps. Jon Walthour - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, July 26, 2001 4:55 AM > I have some scripts, O.S. command and SQL, which I use to perform COLD > backups of DBs and other tasks. I'm not particularily happy about having > username/password information in the scripts. Has anyone come up with a way > to avoid same allowing for the fact the scripts should require no user input > to execute. > > > Sean :) > > Rookie Data Base Administrator > Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K > [0%] OCP Oracle8i DBA > [0%] OCP Oracle9i DBA > > Organon (Ireland) Ltd. > E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] > > Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA > > "Nobody loves me but my mother... and she could be jivin' too." - BB King > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: O'Neill, Sean > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Information about User-defined Locks
Listers:
Solved my own problem and thought I would share the solution
with you all.
To find the name of a user-defined lock:
SELECT s.sid
, s.serial#
, DECODE(
s.process
, NULL, DECODE(SUBSTR(p.username, 1, 1), '?', UPPER(s.osuser),
p.username)
, DECODE(p.username, 'oracusr ', LOWER(s.osuser),
s.process)) AS process
, NVL(s.username, 'SYS (' || LOWER(bg.name) || ')') AS
username
, DECODE(s.username, NULL, ' ', DECODE(s.terminal, NULL,
RTRIM(LOWER(p.terminal), CHR(0)), LOWER(s.terminal))) AS terminal
, 'UL' as type
, DECODE(l.lmode, 0, 'none', 1, 'null', 2, 'RS', 3, 'RX',
4, 'S', 5, 'SRX', 6, 'X', TO_CHAR(l.lmode)) AS lmode
, DECODE(l.request, 0, 'none', 1, 'null', 2, 'RS', 3,
'RX', 4, 'S', 5, 'SRX', 6, 'X', TO_CHAR(l.request)) AS lrequest
, 'lock name: ' || la.name || ', expiration date: ' ||
TO_CHAR(la.expiration, 'DD-MON-RR HH24:MI:SS') as detail
FROM sys.v_$lock l
, sys.v_$session s
, sys.v_$process p
, sys.v_$bgprocess bg
, sys.dbms_lock_allocated la
WHERE l.sid = s.sid
AND s.paddr = bg.paddr(+)
AND s.paddr = p.addr(+)
AND l.id1 = la.lockid(+)
AND l.type = 'UL';
Thanks, everyone, for your continued help through this forum.
Jon Walthour
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jon Walthour
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Re: data files the busiest
Viraj: It's not the difference between the reads and the writes that makes for the busyness, but the addition of the two together that is a better measure of the activity on the file. See my previous posting for a query that will list all the datafiles in order of most to least active. Jon Walthour - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, July 24, 2001 9:50 PM > Hello all, > > If I want to know which data files are the busiest, can I assume that from the following query:- > > SELECT SUBSTR(name, 1, 128), f.phyrds, f.phywrts > FROM v$datafile d, v$filestat f > WHERE f.file# = d.file# > ORDER BY phywrts > > If there is vast difference between the physical reads and physical writes, then that particular data file would be the busiest? Is this true? > > rgds, > > raja > > > Get 250 color business cards for FREE! > http://businesscards.lycos.com/vp/fastpath/ > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Viraj Luthra > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Information about User-defined Locks
Viraj: Thanks for the idea, but I already know the lock type to be User-defined. I also know that p2 and p3 (id1 and id2) are application dependent, according to the documentation. So, joining them to dba_objects yields me nothing. But I appreciate your input ... let's keep looking. Jon Walthour - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, July 24, 2001 9:50 PM > Jon, > > Try doing the following, it should give you the information, you need :- > > SELECT o.object_id, s.username, l.sid, object_name, > DECODE( l.type, > 'MR', 'Media Recovery', > 'RT', 'Redo Thread', > 'UN', 'User Name', > 'TX', 'Transaction', > 'TM', 'DML', > 'UL', 'PL/SQL User Lock', > 'DX', 'Distributed Xaction', > 'CF', 'Control File', > 'IS', 'Instance State', > 'FS', 'File Set', > 'IR', 'Instance Recovery', > 'ST', 'Disk Space Transaction', > 'TS', 'Temp Segment', > 'IV', 'Library Cache Invalidation', > 'LS', 'Log Start or Switch', > 'RW', 'Row Wait', > 'SQ', 'Sequence Number', > 'TE', 'Extend Table', > 'TT', 'Temp Table', > l.type ), > DECODE( l.lmode, > 0, 'None', > 1, 'Null', > 2, 'Row-s (SS)', > 3, 'Row-x (SX)', > 4, 'Share', > 5, 'S/Row-X (SSX)', > 6, 'Exclusive', > to_char(l.request)) > FROM v$lock l, v$session s, dba_objects o > WHERE s.sid = l.sid and > l.id1 = o.object_id(+) and > username is not null > ORDER BY username, l.sid > / > > > -- > > On Tue, 24 Jul 2001 16:45:47 > Jon Walthour wrote: > >Listers: > > > >I had an interesting question today that I cannot find the answer for, but would love to know about. > > > >A developer came to me today and asked how we could find the object that was being locked by a User-defined lock (UL). He works with Oracle Clinical and in one of its "blackbox" procedures, it appears to hang while holding a UL. He would like to know what object it is holding. Now, as far as I know, in v$lock a UL's id1 and id2 do not provide useful information to this end; both parameters are "application dependent." So, where else can I turn? > > > >Jon Walthour > > > > > Get 250 color business cards for FREE! > http://businesscards.lycos.com/vp/fastpath/ > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Viraj Luthra > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: data files the busiest
Raja: Your query is on the right track, but it only accounts for the physical writes, not the physical reads. Try the attached script. Jon Walthour - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, July 24, 2001 9:50 PM > Hello all, > > If I want to know which data files are the busiest, can I assume that from the following query:- > > SELECT SUBSTR(name, 1, 128), f.phyrds, f.phywrts > FROM v$datafile d, v$filestat f > WHERE f.file# = d.file# > ORDER BY phywrts > > If there is vast difference between the physical reads and physical writes, then that particular data file would be the busiest? Is this true? > > rgds, > > raja > > > Get 250 color business cards for FREE! > http://businesscards.lycos.com/vp/fastpath/ > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Viraj Luthra > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). file_io.sql
Re: ERROR IN INSTALING PATCH 8.1.6.3.0
I've had this problem before. Two things to check: (1) the DLL's may still be locked in memory if you just shutdown Oracle; try rebooting with all the Oracle services disabled so that Oracle doesn't start up at all then run the patch or (2) are the DLL's marked read-only? I know it sounds strange, but I've seen installation programs mark all their DLL's read-only "for protection." Jon Walthour - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, July 24, 2001 4:45 PM > Hi, > > I am trying to install patch 8.1.6.3.0 on WIN 2 and i am getting error: > Error in writing to file f:\ORACLE\ORA81\BIN\ORANCDS8.DLL..and if i > ignore this > error the same error comes for other DLL...Oracle is shutdown properly > and there is > no service running of Oracle. > What might be the reason. > > Thanks > Harvinder > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Harvinder Singh > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: both dbms_stats & dbms_utility are gathering stats on sys objects
Well, first of all, you could use dbms_utility.analyze_schema() and analyze
all the schemas except SYS ... or couldn't you run
dbms_utility.analyze_database() and then
dbms_utility.analyze_schema('SYS','DELETE') to remove SYS's stats. What
about one of those?
Jon Walthour
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, July 24, 2001 3:55 PM
>
> Both DBMS_STATS.GATHER_DATABASE_STATS and DBMS_UTILITY.ANALYZE_DATABASE
are
> gathering statistics on sys objects. As per oracle, we shouldn't analyze
> the objects owned by sys.
>
> When I searched on metalink, I found the following information provided by
> oracle tech support.
>
> filed bug 969814 against DBMS_UTILITY.ANALYZE_DATABASE which was not
> excluding these tables.
> This bug is fixed in 8.1.7.
>
> I did my tests on 8.1.7 database on hp-ux. Apparently it is not fixed on
> 8.1.7.0.0.
>
> Is it fixed in later releases? I appreciate your comments.
>
> Best regards,
> Prasad
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jon Walthour
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Information about User-defined Locks
Listers: I had an interesting question today that I cannot find the answer for, but would love to know about. A developer came to me today and asked how we could find the object that was being locked by a User-defined lock (UL). He works with Oracle Clinical and in one of its "blackbox" procedures, it appears to hang while holding a UL. He would like to know what object it is holding. Now, as far as I know, in v$lock a UL's id1 and id2 do not provide useful information to this end; both parameters are "application dependent." So, where else can I turn? Jon Walthour
RE: Data Modeling opinion? Help?
Chris: You have to remember that you are there as a consultant, as a value add to the client's business, not to argue with them. If they choose to do something different than what you recommend, that's their choice. I agree with what others have said: document, document, document. That way if things don't turn out as expected or when project deadlines start to slip because of scope creep, you can go back and point to what decisions and activities brought about these changes. And would you want a project deadline to be missed because you spent a week arguing a point with them ro because you did it the way they asked and it didn't work as they thought it would. I always try to remember as a consultant that, when it gets right down to it, I'm not part of their team--that's not my role. I'm a hired gun in the case of project work or an augmentation to their team. In either case, I am there to add something, not to detract from it. Just my two cents. Jon Walthour >--- Original Message --- >From: "Grabowy, Chris" <[EMAIL PROTECTED]> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Date: 7/24/01 2:40:24 PM > >Hmmm...when the spec is changed because of some business requirement then >that's fine. But when it's changed because your own designers cant argue >the design on technical merit then what? A spec should quote all the >business rules, and some high level details about the overall architecture >of the system. But the spec shouldn't tell you that you will have these two >specific tables in the database, with these specific fields, etc. > >In the end the contractor is ultimately responsible for the validity and >performance of the system that they deliver. The contractor will never be >able to point back to some disclaimer and say "We told you so". It will be >next to impossible to point to the disclaimer when you start slipping the >schedule or when the performance is not quite there. > >-Original Message- >Sent: Tuesday, July 24, 2001 1:09 PM >To: Grabowy; Chris; Multiple recipients of list ORACLE-L > > >Chris, > >True, except when I as the customer change the specs. Then what is >right is >what I say. Or as a Program Management instructor told the class "As it is >written, so let it be done." > >Dick Goulet > >Reply Separator >Author: "Grabowy; Chris" <[EMAIL PROTECTED]> >Date: 7/24/2001 9:48 AM > >Exactly. Which is why I am trying to change this now. > >As for the previous comment, they do not pay me to beat them over the head, >BUT they do pay me to do what is right. > >-Original Message- >Sent: Tuesday, July 24, 2001 1:29 PM >To: Multiple recipients of list ORACLE-L > > >Yes, but ironically enough, its the consultant they ram to the ground after >it goes south, no matter how well you document that you recommended against >it. > >-Original Message- >Sent: Tuesday, July 24, 2001 10:02 AM >To: Multiple recipients of list ORACLE-L > > >Keep in mind that they pay you to advise them and to do what they want done. >They do not pay you to beat them over the head to do what is right. > >Document to cya > > >> This is one of those cases where I would document your >> concerns and the >> potential consequences thereof and submit that to damagement, >> also keep a copy >> for yourself in the 'Pearl Harbor File'. Then do as they >> ask. Yeah, I know >> it's dumb, but what are you as a consultant/contractor going to do? >> >> Dick Goulet >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Page, Bruce > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Kimberly Smith > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing lis
RE: what do I tune?
Gene: It all depends on a couple of factors: (1) what are the average wait times for each of the wait events, (2) which one(s) have the highest wait times. I would ignore any waits less than 1 centisecond for the most part. Buffer Busy Waits occur when a session is waiting for a buffer to become available. This is because a buffer is either being read into the buffer cache by another session (and the session is waiting for that read to complete) or the buffer is in the buffer cache, but in an incompatible mode(that is, some other session is changing the buffer). There are several courses of action here, depending on what type of block it is: -- If it is a data block, change the pctfree and pctused or, in the case of an index, check for "right-hand indexing" or increase initrans. The key is to reduce the number of rows/leaves per block to reduce contention. -- If it is a segment header, increase the number of freelists or use freelist groups. -- If it is a freelist block, increase the number of freelists. -- If it is an undo header block, add more rollback segments when in exclusive mode and consider setting transactions per rbs = 1. -- If it is an undo block, add more rollback segments when in exclusive mode or make the segments you have larger. DB file sequential read waits indicate that either (a) an index lookup is being performed or (b) a controlfile is being rebuilt or (c) datafile headers are being dumped or retrieved. In your case, it's probably the first one. Enqueue waits are waits for locks to be released. Taking care of those can be quite complex depending on the types of locks being held and those being requested and on what structures, etc. Latch free waits are waits for another to release a latch on a given resource. The presence of latch free waits of any significant magnitude may indicate a bottleneck within the SGA. It seems obvious that when you turned up the degree of parallelism on the query, the database as you currently have it set up could not handle the load. All these wait events would be consistent with that. Hope this helps. Jon Walthour >--- Original Message --- >From: Gene Gurevich <[EMAIL PROTECTED]> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Date: 7/24/01 11:56:29 AM > >Hi all: > >I am trying to tune some queries. I ran them all in >one stream (in sequence) and then ran them in several >(up to 64) parallel streams. I got a snapshot of >the system for each run. I see some of the waits went >up significantly when I switched from 2 parallel >streams to 64: buffer busy wait, db file seq read, >enqueue waits, latch free waits and many more. Now >some of this increases may be OK, some may be not. My >question is how do I decide which of these waits are a >problem and should be looked into and which are normal >and can be safely ignored. Are there any quantative >rules that I could use? > >thank you for any insight > >Gene > >= > > >__ >Do You Yahoo!? >Make international calls for as low as $.04/minute with Yahoo! Messenger >http://phonecard.yahoo.com/ >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Gene Gurevich > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Input truncated
Andrea: Open up your .sql file in notepad or the like and put a carriage return after the last line so you, in effect, have a final blank line. Jon Walthour >--- Original Message --- >From: Quaglio Andrea <[EMAIL PROTECTED]> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Date: 7/24/01 10:00:47 AM > >I don't know why when I try to load error_p1 procedure it's printed "Input >truncated to 35 characters". > > SQL> @error_p1 > > Procedure created. > > Input truncated to 35 characters > No errors. > >Can anybody help me ? > >Thanks, >Andrea >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Quaglio Andrea > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Starting Oracle services remotely (Win2K).
Add the computer in the MMC (Microsoft Management Console) and then you can control whatever you want (if you're an Administrator). Jon Walthour - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, July 24, 2001 7:05 AM > Hi all, > > Has anybody come across a way of starting the Oracle services (or indeed any > service) on a Win2K box remotely from another Win2K machine? > > I would be interested in your insight if you have.. > > Cheers > > Mark > > === > Mark Leith | T: +44 (0)1905 330 281 > Sales & Marketing | F: +44 (0)870 127 5283 > Cool Tools UK Ltd | E: [EMAIL PROTECTED] > === > http://www.cool-tools.co.uk > Maximising throughput & performance > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Mark Leith > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: The number of used cursors?
Tamas: I've done some looking into this issue and I think it depends on what you want when you say want to know the number of "used" cursors. If you mean those that have been opened AND parsed, then a count from v$open_cursor will give you that (for the most part). If, however, you want to know the number of dynamic cursors that have been opened (parsed or not), then the statistic 'opened cursors current' will give you that number. Keep in mind, too, that a row in v$open_cursor does not necessarily mean that the cursor is open and in use. For performance reasons, cursors are not "closed", but "cancelled." This allows most system resources to be released while still allowing the cursor to be reused if need be. There is currently no view that ill provide this information as to how many cursors are really open and in use (i.e., open and not cancelled). Hope this helps. Jon Walthour - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, July 24, 2001 5:55 AM > Thank you for the anwers. > > If I try Jon's version I get a big number that does not seem to be related > to the number of maximum open cursors ( it's much higher). > > If I query the V$SQL_CURSOR view, then I get a number the could be the value > I look for. > > Could some one shed some light on this? > > Regards > > Tamas Szecsy > > -Original Message- > Sent: Monday, July 23, 2001 5:29 PM > To: Multiple recipients of list ORACLE-L > > > > > Try this: > > select sum(value) as open_cursors > from sys.v_$sesstat s > , sys.v_$statname n > where s.statistic# = n.statistic# >and n.name = 'opened cursors current'; > > Jon Walthour > > >--- Original Message --- > >From: Szecsy Tamas <[EMAIL PROTECTED]> > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > >Date: 7/23/01 9:55:24 AM > > > > >Hi, > > > >I would like to know the the number of used cursors at any given > time. Is > >there a select statement that does this for me? I would like > to decide if > >the growing number of concurent users for a given database has > reached the > >point where the maximum open cursor init ora parameter got to > be increased. > > > >Thank you in advance. > > > >Tamas Szecsy > >-- > >Please see the official ORACLE-L FAQ: http://www.orafaq.com > >-- > >Author: Szecsy Tamas > > INET: [EMAIL PROTECTED] > > > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > >San Diego, California-- Public Internet access / Mailing > Lists > > > >To REMOVE yourself from this mailing list, send an E-Mail message > >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') > and in > >the message BODY, include a line containing: UNSUB ORACLE-L > >(or the name of mailing list you want to be removed from). > You may > >also send the HELP command for other information (like subscribing). > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jon Walthour > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Szecsy Tamas > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > ---- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Insufficient priveleges
Sounds like you may be on Windows NT? If that's so, is your ID a member of the ORA_DBA group? If not, add it to the group and reboot the server. Jon Walthour - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, July 23, 2001 3:57 PM > I keep getting an ORA-01031 trying to start an Oacle 7.3 instance. I have > run ORADIM trying to change the password but it doesn't seem to do any good. > My brains not working today. Can anyone give me some help? > > Ron > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Smith, Ron L. > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: CASE Expressions
CASE is supported in 8.1.6 and 8.1.7. Jonathan, as far as I can tell, your SQL statement is flawed. Shouldn't it be something like: select case when 1=1 then 2 end as test from dual; Jon Walthour >--- Original Message --- >From: Yuval Arnon <[EMAIL PROTECTED]> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Date: 7/23/01 12:42:00 PM > Jonathan >CASE is not supported in 8.1.7. > > >SQL> select * from v$version; > > >BANNER > >Oracle8i Enterprise Edition Release 8.1.7.1.0 - Production > >SQL> SELECT CASE 1 WHEN 1 THEN 2 > 2 FROM dual; > SELECT CASE 1 WHEN 1 THEN 2 > * >ERROR at line 1: >ORA-00923: FROM keyword not found where expected > > >SQL> > >Yuval > >-Original Message- >Sent: Monday, July 23, 2001 11:03 AM >To: Multiple recipients of list ORACLE-L > > >I'm doing some research for a book, and I need to know when >Oracle began to support CASE expressions. I thought it was >in Oracle9i, but the new features list seems to imply that >CASE may have come about in 8.1.7. Can anyone with 8.1.7 >verify this for me? I have 8.1.6 and 9.whatever, but not >8.1.7 or I'd try it myself. > >If you have 8.1.7, and have a second to experiment, try the >following query as a test: > >SELECT CASE 1 WHEN 1 THEN 2 >FROM dual; > >Best regards, > >Jonathan Gennick >mailto:[EMAIL PROTECTED] * 906.387.1698 >http://Gennick.com * http://MichiganWaterfalls.com * http://MetalDrums.org > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Jonathan Gennick > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re: init.ora
Rood: Not exactly correct. The ifile parameter will tell you all the files included in the init.ora via this method. However, it will not necessarily give you the location of the init.ora itself. Now, on a Windows NT system, this is how Oracle is able to keep the init.ora in the %ORACLE_ADMIN%\%ORACLE_SID%\pfile directory and still have a "link" to it in the %ORACLE_HOME%\dbs directory. However, on UNIX, where symlinks are used, there may be no ifile parameter in the init.ora and certainly probably not one pointing to the init.ora itself. Therefore, at best, this parameter is unreliable for finding the init.ora. Jon Walthour >--- Original Message --- >From: Rodd Holman <[EMAIL PROTECTED]> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Date: 7/23/01 9:20:54 AM > >This won't tell you of aditional config files (referenced using ifile= > in >you init file) but it will tell you the primary file. > select * from v$parameter where name = 'ifile'; > >Rodd Holman > >>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<< on 7/23/01, 6:35:50 am, jon walthour <[EMAIL PROTECTED]> wrote regarding Re: > >init.ora: > > >> Prasad: > >> There is no way to tell from inside Oracle exactly what init.ora you u >sed >to >> start the db up with. By default, it uses the one pointed to by the >> symlink/ifile in $ORACLE_HOME/dbs, but if you start up the db with the > >> pfile= parameter (as in, startup pfile=some_other_init.ora), then >there's >no >> way to know other than knowing what parameters are different between t >he >two >> init.ora files and querying sys.v_$parameter to check those difference >s. > >> Jon Walthour > >> - Original Message - >> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> >> Sent: Monday, July 23, 2001 5:20 AM > > >> > hi dbas >> > >> > is there anyway to see >> > >> > using what init.ora file i start my instance/db >> > >> > bcoz i hv somany init files in the same dir. >> > >> > they have same parameters. i forgot to remember what >> > init file i used to start the db. >> > >> > can it be found from any table/or anyother source? >> > >> > prasad >> > >> > __ >> > Do You Yahoo!? >> > Make international calls for as low as $.04/minute with Yahoo! Messe >nger >> > http://phonecard.yahoo.com/ >> > -- >> > Please see the official ORACLE-L FAQ: http://www.orafaq.com >> > -- >> > Author: prasad maganti >> > INET: [EMAIL PROTECTED] >> > >> > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >> > San Diego, California -- Public Internet access / Mailing Lis >ts >> > > >> > To REMOVE yourself from this mailing list, send an E-Mail message >> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >> > the message BODY, include a line containing: UNSUB ORACLE-L >> > (or the name of mailing list you want to be removed from). You may >> > also send the HELP command for other information (like subscribing). > > > >> -- >> Please see the official ORACLE-L FAQ: http://www.orafaq.com >> -- >> Author: Jon Walthour >> INET: [EMAIL PROTECTED] > >> Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >> San Diego, California-- Public Internet access / Mailing Lists > >> >> To REMOVE yourself from this mailing list, send an E-Mail message >> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >> the message BODY, include a line containing: UNSUB ORACLE-L >> (or the name of mailing list you want to be removed from). You may >> also send the HELP command for other information (like subscribing). >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Rodd Holman > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru
RE: The number of used cursors?
Try this: select sum(value) as open_cursors from sys.v_$sesstat s , sys.v_$statname n where s.statistic# = n.statistic# and n.name = 'opened cursors current'; Jon Walthour >--- Original Message --- >From: Szecsy Tamas <[EMAIL PROTECTED]> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Date: 7/23/01 9:55:24 AM > >Hi, > >I would like to know the the number of used cursors at any given time. Is >there a select statement that does this for me? I would like to decide if >the growing number of concurent users for a given database has reached the >point where the maximum open cursor init ora parameter got to be increased. > >Thank you in advance. > >Tamas Szecsy >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Szecsy Tamas > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: Re: Jobs
Jenny, et. al. I'm right there with you on this. I don't have a problem with someone announcing, "Hey, I'm looking for a job. Anybody know of positions in blah-blah?" What I don't care for the resume attachments and would just ask if it could be discontinued in the future. Jon Walthour >--- Original Message --- >From: Jenny Jacobson <[EMAIL PROTECTED]> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Date: 7/23/01 10:30:52 AM > >IMHO: If recruiters can post jobs, each of us can post our need for a job. > >However, sending a resume is unnecessary. If someone is interestered, >they can contact the poster privately and request a resume. > >Jenny Jacobson >www.oracle-dba-consulting.com > > >On Mon, 23 Jul 2001, Jon Walthour wrote: > >> >> >> Listers: >> >> Is it appropriate to be sending one's resume to the mailing list >> (especially as an attachment)? I don't think so, but have not >> heard much to that effect thus far. So, maybe it is. Can someone >> please enlighten me? >> >> Jon Walthour >> >> >--- Original Message --- >> >From: "C.S.Venkata Subramanian" <[EMAIL PROTECTED]> >> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >> >Date: 7/23/01 8:30:27 AM >> > >> Hello, >> >I'm currently working in India as Oracle DBA. I'm willing to >> relocate to UK or Europe for a descent salary. I'm attaching >> my resume with this mail. >> > >> >Expecting to hear from you >> > >> >Regards >> >Venkata Subramanian C.S. >> >-- >> > >> >On Mon, 16 Jul 2001 11:30:50 >> > Culum Slater wrote: >> >>Hello Oracle professionals, >> >> >> >> >> >>Are there any Oracle DBA's currently looking for work in and >> around London, England. >> >> >> >>If so, send me a copy of your cv and I will do my best to find >> you the right job. >> >> >> >>We are an Oracle specialist recruitment consultancy. >> >> >> >>Regards >> >> >> >>Culum Slater >> >>Managing Director >> >>CMS Global Ltd >> >> >> >>D/L: 01923 233196 >> >> >> >>M/N: 07960 113 738 >> >> >> >>[EMAIL PROTECTED] >> >> >> >>CMS Global Ltd, 39 Elizabeth House, Watford, Herts, WD24 4RE >> >> >> > >> > >> >Get 250 color business cards for FREE! >> >http://businesscards.lycos.com/vp/fastpath/ >> > >> >> >> -- >> Please see the official ORACLE-L FAQ: http://www.orafaq.com >> -- >> Author: Jon Walthour >> INET: [EMAIL PROTECTED] >> >> Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >> San Diego, California-- Public Internet access / Mailing Lists >> >> To REMOVE yourself from this mailing list, send an E-Mail message >> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >> the message BODY, include a line containing: UNSUB ORACLE-L >> (or the name of mailing list you want to be removed from). You may >> also send the HELP command for other information (like subscribing). >> > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Jenny Jacobson > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: get yesterdays date
John: To get yesterday's, simply subtract 1 from sysdate ... like this: select sysdate-1 as yesterday from dual; Jon Walthour >--- Original Message --- >From: John Dunn <[EMAIL PROTECTED]> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Date: 7/23/01 7:35:53 AM > >Anyone know how to get yesterdays date in PL/SQL? > >John > > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: John Dunn > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re: Jobs
Listers: Is it appropriate to be sending one's resume to the mailing list (especially as an attachment)? I don't think so, but have not heard much to that effect thus far. So, maybe it is. Can someone please enlighten me? Jon Walthour >--- Original Message --- >From: "C.S.Venkata Subramanian" <[EMAIL PROTECTED]> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Date: 7/23/01 8:30:27 AM > Hello, >I'm currently working in India as Oracle DBA. I'm willing to relocate to UK or Europe for a descent salary. I'm attaching my resume with this mail. > >Expecting to hear from you > >Regards >Venkata Subramanian C.S. >-- > >On Mon, 16 Jul 2001 11:30:50 > Culum Slater wrote: >>Hello Oracle professionals, >> >> >>Are there any Oracle DBA's currently looking for work in and around London, England. >> >>If so, send me a copy of your cv and I will do my best to find you the right job. >> >>We are an Oracle specialist recruitment consultancy. >> >>Regards >> >>Culum Slater >>Managing Director >>CMS Global Ltd >> >>D/L: 01923 233196 >> >>M/N: 07960 113 738 >> >>[EMAIL PROTECTED] >> >>CMS Global Ltd, 39 Elizabeth House, Watford, Herts, WD24 4RE >> > > >Get 250 color business cards for FREE! >http://businesscards.lycos.com/vp/fastpath/ > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: init.ora
Prasad: There is no way to tell from inside Oracle exactly what init.ora you used to start the db up with. By default, it uses the one pointed to by the symlink/ifile in $ORACLE_HOME/dbs, but if you start up the db with the pfile= parameter (as in, startup pfile=some_other_init.ora), then there's no way to know other than knowing what parameters are different between the two init.ora files and querying sys.v_$parameter to check those differences. Jon Walthour - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, July 23, 2001 5:20 AM > hi dbas > > is there anyway to see > > using what init.ora file i start my instance/db > > bcoz i hv somany init files in the same dir. > > they have same parameters. i forgot to remember what > init file i used to start the db. > > can it be found from any table/or anyother source? > > prasad > > __ > Do You Yahoo!? > Make international calls for as low as $.04/minute with Yahoo! Messenger > http://phonecard.yahoo.com/ > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: prasad maganti > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OUTPUT WIDTH..
SVRMGRL is more primitive than SQL*Plus and doesn't have all the formatting capabilities that SQL*Plus does. So, there are no SET commands in SVRMGRL. Why can't you do the query in SQL*Plus just as well? Jon Walthour - Original Message - From: Saurabh Sharma To: Multiple recipients of list ORACLE-L Sent: Monday, July 23, 2001 6:00 AM Subject: OUTPUT WIDTH.. hi all, how do i increase the width of output of a querry concatenated with some strings through '||'. the output is truncated in the end. output is ok in sql prompt with set line option. but whatabput svrmgrl.. any idea.. Saurabh Sharma [EMAIL PROTECTED]http://www.geocities.com/saurabh00pc/stride.html
Re: select on v$ tables
Prasad: Grant the user the SELECT_CATALOG_ROLE role. That will give the user access to the v$ views, the DBA_ views and several other views and tables. To see a full listing of what they would be granted select on, run: select table_name from dba_tab_privs where grantee='SELECT_CATALOG_ROLE' order by table_name; Jon Walthour - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, July 23, 2001 5:25 AM > hi dba's > > i need to give select permission to scott user on all > v$ tables. > > is there any role for that. or should i grant the > selection using dynamic sql > > thanx in advance > prasad > > __ > Do You Yahoo!? > Make international calls for as low as $.04/minute with Yahoo! Messenger > http://phonecard.yahoo.com/ > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: prasad maganti > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: version
Easy. Log in to sqlplus or svrmgrl and run the following query: select * from v$version; The first line will tell you what version of Oracle you are running. Jon Walthour - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Sunday, July 22, 2001 12:16 PM > Hi All, > >How can we find what version of oracle (standard/enterprise/workgroup) is > running in the system. > Is there any view/table ? > > Thanks > rukmini > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Rukmini Devi > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: table scan vs idx scan
Prasad: Have you run an explain plan on the the query on tab2 to see what Oracle is doing? Jon Walthour - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Saturday, July 21, 2001 12:15 PM > Hi dbas > > we have a situation here. can anybody tell me > why this is happening > : > > we have 2 tables with identical rows(almost) with same > columns even indexed in same manner. > > tab1 51000 rows > tab2 51500 rows > > tab1 indexed with idx1 on col1,col2,col3 > tab2 indexed with idx2 on col1,col2,col3 > > TAB1: > - > just i am selecting as > select col1,col2,col3 from tab1 > > this is using index scan and taking > 90 seconds to get the data > (Explain plan ) > > TAB2: > - > i am select as above > select col1,col2,col3 from tab2 > > this is using fulltable scan and taking > 18 minutes to get data. > (Explain plan) > > we tried in all possible ways for tab2 ,like > > analyzed objects (both idx,table (compute statistics)) > changed optimizer modes and tried, > giving hints to use index , > rebuilt of index, > after all we dropped the idx2 and recreated it. > > but the case is same. still it is taking >18 minutes. > > even when i provided hints it is not searching for > that > index, doing the same old full table scan. > > why oracle doesn't follow hints in some cases. > > and what should i do to reduce the time to fetch the > data. > > > thnx in adv > > prasad > > > > > __ > Do You Yahoo!? > Make international calls for as low as $.04/minute with Yahoo! Messenger > http://phonecard.yahoo.com/ > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: prasad maganti > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: sql help
Srinivas: Try this: break on "TYPE" SELECT 'TABLE' AS "TYPE" , table_name AS object_name FROM sys.dba_tables WHERE owner = 'SCOTT' UNION SELECT 'INDEX' , index_name FROM sys.dba_indexes WHERE owner = 'SCOTT' UNION SELECT 'CLUSTER' , cluster_name FROM sys.dba_clusters WHERE owner = 'SCOTT' ORDER BY 1 , 2; Jon Walthour - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Saturday, July 21, 2001 11:45 AM > hi dba's > > how to find out a users all objects+the tablespaces > in which they reside. > > i tried using the flwng way: > > > select tablespacename,table_name from dba_tables > where obj in (select obj_nm from dba_objects where > obj_type ='table' and owner='xyz') > union > > select for indexes > > union > > select for clusters > ; > > can anybody tell me any alternative statement for the > above. > > thnx in adv. > > srinivas > > > __ > Do You Yahoo!? > Make international calls for as low as $.04/minute with Yahoo! Messenger > http://phonecard.yahoo.com/ > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: kommareddy sreenivasa > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: oracle dba and tuning books
Personally, for tuning, I would suggest "Oracle Performance Tuning Tips and Techniques" by Richard Niemac, et. al. In the DBA arena, I've never really found a good book that I could wholeheartedly recommend (sorry, Rachael, I've not gotten around to reading your book yet). Jon Walthour - Original Message - From: shirish To: Multiple recipients of list ORACLE-L Sent: Saturday, July 21, 2001 9:40 AM Subject: oracle dba and tuning books hi all can u plz give me good books for dba and tuning thanks in advance thanks and regards ! Shirish Khapre, SE Rolta India Ltd.Off Ph No. (+91) (022) 832,826,8300568Ext'n 2730visit me at:- www.geocities.com/shirishkhapreMinds are like parachutes. They only function when they are open
Re: Extent allocation
I mean just that--that Oracle will look in its free extent cache for the first free extent the tablespace that is the same size as that which it needs. There is no particular ordering first. And that would make it "appear" to be distributing extents equally among the files, but not always. Sometimes it will also look, as another lister has pointed out, as if Oracle is always going to the biggest datafile in the tablespace. Jon Walthour - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Saturday, July 21, 2001 11:45 AM > What do you mean by the "first one on the list?" The list ordered > how? The order in which dynamic extent allocation is reading fet$ > appears to favor distributing extents equally among files. > > -- > Jeremiah Wilton > http://www.speakeasy.net/~jwilton > > On Sat, 21 Jul 2001, Jon Walthour wrote: > > > Kirti and others: > > > > Actually, Oracle only uses a round-robin extent allocation method for direct > > loads and parallel CTAS operations. For dynamic extent allocation, Oracle > > doesn't fill up one file and then the next. Actually, Oracle doesn't > > distinguish between datafiles, but rather looks at the total free space > > extents for the tablespace as listed in SYS.FET$ (Oracle's free extent > > cache). Basically, Oracle will look for a free extent equal to the size of > > the one it needs to allocate(see Doc ID #69343.1 on MetaLink of details on > > Oracle's extent algorithm). The first one on the list, regardless of the > > datafile, gets picked first. If one of exact size doesn't exist, Oracle will > > then split an existing larger extent. This larger extent, again, will be the > > first one found in SYS.FET$ which can provide the necessary space. So, it > > can at times appear to be round-robin allocation or one-file-at-a-time when, > > in point of fact, it is much more complex. > > > > Jon Walthour > > > > - Original Message - > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > > Sent: Friday, July 20, 2001 6:30 PM > > > > > > > Jeremiah is right. Depending on the version of the database this is an > > > imaginary problem. > > > I have been using this 'auto round robin' feature since 8.0.6 (HP-UX > > > 32-bit). Just did quite a bit of re-organization involving partitioning a > > > large table and used this auto round robin extent allocation feature to > > > spread out I/O... > > > > > > Anyone seen this in any lower versions ?? > > > > > > Cheers! > > > > > > - Kirti Deshpande > > > Verizon Information Services > > >http://www.superpages.com > > > > > > > -Original Message- > > > > From: Jeremiah Wilton [SMTP:[EMAIL PROTECTED]] > > > > Sent: Friday, July 20, 2001 4:57 PM > > > > To: Multiple recipients of list ORACLE-L > > > > Subject: Re: Extent allocation > > > > > > > > On Fri, 20 Jul 2001, Adrian Roe wrote: > > > > > > > > > Is there any way to get Oracle (816) to do round robin extent > > > > > allocation eg. if a tablespace has 4 data files and each file is on > > > > > a different disk, can extents be allocated from each file in > > > > > sequence ? As I understand, Oracle will fill one file and then go > > > > > onto the next file. > > > > > > > > It appears we may be discussing an imaginary problem. At least on the > > > > version I am using (8.1.6.2 HP-UX 64 bit), Oracle round robins among > > > > files with available space automatically. It does not just fill up > > > > one datafile and move on to the next. > > > > > > > > I did a little experiment: > > > > > > > > SQL> create tablespace jeremiah_temp1 > > > > 1 datafile '/tmp/jeremiah_temp-01.dbf' size 10m, > > > > 2 '/tmp/jeremiah_temp-02.dbf' size 10m, > > > > 3 '/tmp/jeremiah_temp-03.dbf' size 10m, > > > > 4 '/tmp/jeremiah_temp-04.dbf' size 10m; > > > > > > > > Tablespace created. > > > > > > > > SQL> create table foobar > > > > 1 (baz varchar2(10)) > > > > 2 storage (initial 32k next 32k pctincrease 0 maxextents 4) > > > > 3 tablespace jeremiah_temp1; > > > > > > > > Table created. > > > > >
Re: Off topic: Linux - NT dual boot
I think this site should provide you with what you need: http://www.redhat.com/support/manuals/RHL-6.2-Manual/ref-guide/ch-dualboot.h tml Jon Walthour - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Saturday, July 21, 2001 7:05 AM > Hello listers > > Would someone explain (or point me to the web page) how to make Linux - NT > dual boot system. When having Windows 9x/ME it is not problem at all. But, > when installed Linux after NT installation, I simply lost NT installation. > LILO offered linux boot only. > > Thank you in advance > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Sadzakovic Slavica > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Extent allocation
Kirti and others: Actually, Oracle only uses a round-robin extent allocation method for direct loads and parallel CTAS operations. For dynamic extent allocation, Oracle doesn't fill up one file and then the next. Actually, Oracle doesn't distinguish between datafiles, but rather looks at the total free space extents for the tablespace as listed in SYS.FET$ (Oracle's free extent cache). Basically, Oracle will look for a free extent equal to the size of the one it needs to allocate(see Doc ID #69343.1 on MetaLink of details on Oracle's extent algorithm). The first one on the list, regardless of the datafile, gets picked first. If one of exact size doesn't exist, Oracle will then split an existing larger extent. This larger extent, again, will be the first one found in SYS.FET$ which can provide the necessary space. So, it can at times appear to be round-robin allocation or one-file-at-a-time when, in point of fact, it is much more complex. Jon Walthour - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, July 20, 2001 6:30 PM > Jeremiah is right. Depending on the version of the database this is an > imaginary problem. > I have been using this 'auto round robin' feature since 8.0.6 (HP-UX > 32-bit). Just did quite a bit of re-organization involving partitioning a > large table and used this auto round robin extent allocation feature to > spread out I/O... > > Anyone seen this in any lower versions ?? > > Cheers! > > - Kirti Deshpande > Verizon Information Services >http://www.superpages.com > > > -Original Message- > > From: Jeremiah Wilton [SMTP:[EMAIL PROTECTED]] > > Sent: Friday, July 20, 2001 4:57 PM > > To: Multiple recipients of list ORACLE-L > > Subject: Re: Extent allocation > > > > On Fri, 20 Jul 2001, Adrian Roe wrote: > > > > > Is there any way to get Oracle (816) to do round robin extent > > > allocation eg. if a tablespace has 4 data files and each file is on > > > a different disk, can extents be allocated from each file in > > > sequence ? As I understand, Oracle will fill one file and then go > > > onto the next file. > > > > It appears we may be discussing an imaginary problem. At least on the > > version I am using (8.1.6.2 HP-UX 64 bit), Oracle round robins among > > files with available space automatically. It does not just fill up > > one datafile and move on to the next. > > > > I did a little experiment: > > > > SQL> create tablespace jeremiah_temp1 > > 1 datafile '/tmp/jeremiah_temp-01.dbf' size 10m, > > 2 '/tmp/jeremiah_temp-02.dbf' size 10m, > > 3 '/tmp/jeremiah_temp-03.dbf' size 10m, > > 4 '/tmp/jeremiah_temp-04.dbf' size 10m; > > > > Tablespace created. > > > > SQL> create table foobar > > 1 (baz varchar2(10)) > > 2 storage (initial 32k next 32k pctincrease 0 maxextents 4) > > 3 tablespace jeremiah_temp1; > > > > Table created. > > > > SQL> insert into foobar (baz) > > 1 select substr(trash,1,10) from garbage where rownum <= 6000; > > > > 6000 rows created. > > > > SQL> commit; > > > > Commit complete. > > > > SQL> select segment_name, e.bytes/1024 kb, file_name > > 1 from dba_extents e, dba_data_files d > > 2 where e.file_id = d.file_id > > 3 and e.segment_name = 'FOOBAR'; > > > > SEGMENT_NAME KB FILE_NAME > > -- -- -- > > FOOBAR 32 /tmp/jeremiah_temp-01.dbf > > FOOBAR 32 /tmp/jeremiah_temp-02.dbf > > FOOBAR 32 /tmp/jeremiah_temp-03.dbf > > FOOBAR 32 /tmp/jeremiah_temp-04.dbf > > > > So, it looks like it "round robins" automatically, and there is no > > need to do so manually. I don't know which version of Oracle was the > > first to do this. > > > > -- > > Jeremiah Wilton > > http://www.speakeasy.net/~jwilton > > > > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Deshpande, Kirti > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists >
Re: Locally managed tablespaces
Yes, you can make any tablespace a locally-managed tablespace except SYSTEM. What they're saying, I think, is that you can't set up temporary tablespaces and shouldn't set up rollback segments with the AUTOALLOCATE allocation management. Jon Walthour - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, July 19, 2001 4:32 PM > I was pretty sure you could use it for any TS but SYSTEM. Is this documented? > > Cheers, > > Earl > > --- > > TheOracleDBA > [EMAIL PROTECTED] > > > > On Thu, 19 Jul 2001 09:32:27 > Hillman, Alex wrote: > >You canuse any storage parameters you like but oracle will ignore them exept > >for initial for LMT with autoallocate. I would personally do not use > >autoallocate. Also you cannot use autoallocate for temporary tablespace and > >shouldn't use it for rollback. > > > >Alex Hillman > > > >-Original Message- > >Sent: Thursday, July 19, 2001 12:43 PM > >To: Multiple recipients of list ORACLE-L > > > > > >HPUX 11i 64 bit > >Oracle 8.1.7.1 32 bit > > > >I am creating a new database and decided to go with locally managed > >tablespaces. I was going to go with autoallocate because the best I can > >tell the only possible drawback with this is a little wasted space. > >However, I was under the impression that you could not specify a next in the > >storage clause of a table creation. Yet you can. So what happens if I have > >a next defined? Do they pretty much just throw that away or should I really > >not define it? > > > > > > > > > >Kimberly Smith > >Database Administrator > >IT Dept. - Fujitsu/GMD > >Phone: (503) 669-6050 > >Fax: (503) 669-5705 > >Email : [EMAIL PROTECTED] > > > >-- > >Please see the official ORACLE-L FAQ: http://www.orafaq.com > >-- > >Author: Kimberly Smith > > INET: [EMAIL PROTECTED] > > > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > >San Diego, California-- Public Internet access / Mailing Lists > > > >To REMOVE yourself from this mailing list, send an E-Mail message > >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > >the message BODY, include a line containing: UNSUB ORACLE-L > >(or the name of mailing list you want to be removed from). You may > >also send the HELP command for other information (like subscribing). > >-- > >Please see the official ORACLE-L FAQ: http://www.orafaq.com > >-- > >Author: Hillman, Alex > > INET: [EMAIL PROTECTED] > > > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > >San Diego, California-- Public Internet access / Mailing Lists > > > >To REMOVE yourself from this mailing list, send an E-Mail message > >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > >the message BODY, include a line containing: UNSUB ORACLE-L > >(or the name of mailing list you want to be removed from). You may > >also send the HELP command for other information (like subscribing). > > > > > Get 250 color business cards for FREE! > http://businesscards.lycos.com/vp/fastpath/ > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: The Oracle DBA > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RE: New Listener Question
List, please correct me if I'm wrong, but I understand that you can define local listeners for the dynamic registration process to register with using the init.ora parameter LOCAL_LISTENER. This parameter identifies "local" listeners for the instance via a tnsnames.ora style format. It can contain multiple listener address to register with. For example: LOCAL_LISTENER = "(ADDRESS_LIST = (ADDRESS=(PROTOCOL=TCP)(HOST=db01.acme.com)(PORT=1521)) (ADDRESS=(PROTOCOL=TCP)(HOST=db02.acme.com)(PORT=1521))(ADDRESS=(PROTOCOL=TC P)(HOST=db03.acme.com)(PORT=1521)))" Jon Walthour - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, July 18, 2001 3:44 PM > Alex, you are correct. And that's how it worked in 8.1.6. > But due to some unknown 'feature' one has to explicitly set th > service_names and instance_name in the init .ora file as a workaround to be > able to use auto-register feature in 8.1.7. Again, only if using the default > listener name with default listener port#.. I have not yet tested this > stuff in 9.0.1 but will do in the very near future. > > Regards, > > - Kirti Deshpande > Verizon Information Services >http://www.superpages.com > > > -Original Message- > > From: Hillman, Alex [SMTP:[EMAIL PROTECTED]] > > Sent: Wednesday, July 18, 2001 1:52 PM > > To: Multiple recipients of list ORACLE-L > > Subject: RE: RE: New Listener Question > > > > instance_name has default value ORACLE_SID and service_name has default > > value db_name.db_domain - so you do not need to define these parameters > > for > > dynamic service registration. > > > > Alex Hillman > > > > -Original Message- > > Sent: Wednesday, July 18, 2001 2:25 PM > > To: Multiple recipients of list ORACLE-L > > > > > > > > > > Actually, it's called dynamic service registration and you need > > both the INSTANCE_NAME parameter and the SERVICE_NAMES parameter > > defined in the init.ora. Then, when the instance starts up, it > > will register the services it supports with the listener(s). > > > > Jon Walthour > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Deshpande, Kirti > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: New Listener Question
Actually, it's called dynamic service registration and you need both the INSTANCE_NAME parameter and the SERVICE_NAMES parameter defined in the init.ora. Then, when the instance starts up, it will register the services it supports with the listener(s). Jon Walthour >--- Original Message --- >From: Glenn Travis <[EMAIL PROTECTED]> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Date: 7/18/01 12:21:24 PM > >I disagree. Mine only registers itself if I have the "service_names" entry >in the init.ora file. Comment this line out and see what happens... > >-Original Message- >Smith >Sent: Tuesday, July 17, 2001 1:31 PM >To: Multiple recipients of list ORACLE-L > > >In Oracle 8i a database will self register with the default listener >even if you do not have it defined. There are parameters that you >can put in your init.ora to prevent this. > >-Original Message- >Sent: Tuesday, July 17, 2001 9:35 AM >To: Multiple recipients of list ORACLE-L > > >First Off, I would like to thank everyone who replied yesterday, your >answers were most helpful! > >Today, I am facing a new puzzle. I am currently running 3 databases on a >server, but only two of them are listed in the listener.ora (bdw and rcvr). >If I do a 'lsnrctl status' it shows a listener for all three databases (bdw >rcvr and webprod). How is this possible? I have included my current >listener.ora and output from 'lsnrctl status' ... Also, people who access >these databases go through VIRTUAL ip's, i.e. the box itself has IP address >xxx.xxx.xxx.11 the bdw ip is xxx.xxx.xxx.31 and the webprod ip is >xxx.xxx.xxx.30 >The reason for the virt ip's is for the fail over we have in place, so >people do not have to reconfigure their machines when we move the databases >around. > >So by all rights I do not see how anyone can connect, but they are?!?!?!? >WTH??? > >Thanks again guys ... > ># LISTENER.ORA Configuration >File:/apps/oracle/product/816/network/admin/listener.ora ># Generated by Oracle configuration tools. > >LISTENER = > (DESCRIPTION_LIST = >(DESCRIPTION = > (ADDRESS_LIST = >(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) > ) > (ADDRESS_LIST = >(ADDRESS = (PROTOCOL = TCP)(HOST = bdw1)(PORT = 1521)) > ) >) >(DESCRIPTION = > (PROTOCOL_STACK = >(PRESENTATION = GIOP) >(SESSION = RAW) > ) > (ADDRESS = (PROTOCOL = TCP)(HOST = bdw1)(PORT = 2481)) >) > ) > >SID_LIST_LISTENER = > (SID_LIST = >(SID_DESC = > (SID_NAME = PLSExtProc) > (ORACLE_HOME = /apps/oracle/product/816) > (PROGRAM = extproc) >) >(SID_DESC = > (GLOBAL_DBNAME = bdw) > (ORACLE_HOME = /apps/oracle/product/816) > (SID_NAME = bdw) >) >(SID_DESC = > (GLOBAL_DBNAME = rcvr) > (ORACLE_HOME = /apps/oracle/product/816) > (SID_NAME = rcvr) >) > ) > >oracle@bdw1 SID: bdw /apps/oracle/product/816/network/admin > lsnrctl status > >LSNRCTL for Solaris: Version 8.1.6.0.0 - Production on 17-JUL-2001 09:24:30 > >(c) Copyright 1998, 1999, Oracle Corporation. All rights reserved. > >Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC))) >STATUS of the LISTENER > >Alias LISTENER >Version TNSLSNR for Solaris: Version 8.1.6.0.0 - >Production >Start Date10-JUL-2001 15:14:01 >Uptime6 days 18 hr. 10 min. 30 sec >Trace Level off >Security OFF >SNMP OFF >Listener Parameter File >/apps/oracle/product/816/network/admin/listener.ora >Listener Log File /apps/oracle/product/816/network/log/listener.log >Services Summary... > PLSExtProchas 1 service handler(s) > WEBPROD has 2 service handler(s) > bdw has 1 service handler(s) > bdw has 1 service handler(s) > rcvr has 1 service handler(s) >The command completed successfully > >-- >Edward W. Carr >UNIX Systems Administrator >Qwest Communications >Broadband Services Inc. > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Kimberly Smith > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECT
Re: security problem with 8i
Listers: My client has asked me to look into this issue and determine if they should be concerned about it or not. Since they don't have any db's directly accessible from the Internet and since their LAN is very secure anyway, I'm inclined to not apply any patches based on the premise that if it isn't a necessary patch, don't apply it in fear of breaking something else. What do you think? -- Jon Walthour, OCDBA Oracle DBA Computer Horizons Cincinnati, Ohio - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, July 09, 2001 1:26 PM > Hi All, > > i am not sure if this has already been posted or not, but.. > > --29 June 2001 Oracle8i Database Buffer Overflow Vulnerability > Security experts found and disclosed a pair of vulnerabilities in the > standard and enterprise editions of Oracle8i database. The Transport > Network Substrate (TNS) Listener has a buffer overflow vulnerability; > a flaw in the SQL Net protocol leaves the system vulnerable to > denial-of- service attacks. Patches are available. > > http://www.computerworld.com/storyba/0,4125,NAV47_STO61802,00.html > > -bill > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Bill Conner > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Scripts for tuning in 8.1.6
Eca: A great place to start would be bstat/estat or stats pack. After that, I'd pick up Richard Niemac's book on Performance Tuning. Then, I'd round that off with a look at Steve Adams' website http://www.ixora.com.au when you're ready for it (it's pretty advanced). -- Jon Walthour, OCDBA Oracle DBA Cincinnati, Ohio - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, July 17, 2001 10:05 PM > > Hi Friends : > > Does anyone have some good prepared scripts for tuning in database. > > And how to use it in Linux ? > > I know that it is necessary to run several times and to calculate some > statistics using the result of the queries. > > Regards > > Eriovaldo > > > _ > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Eca Eca > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: ORA-24323
Vinay: While Remco is correct here (about using backslashes), that was probably just an oversight on your part in writing the email. Are you running or do you have a login.sql or glogin.sql script in your SQLPATH directory or the current working directory? If so, try removing it or unsetting your SQLPATH environment variable. -- Jon Walthour, OCDBA Oracle DBA Computer Horizons Cincinnati, Ohio >--- Original Message --- >From: "Daemen, Remco" <[EMAIL PROTECTED]> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Date: 7/17/01 10:06:16 AM > >How about trying c:\mypath\mysql.sql ? Note the backslashes instead of the >forward slashes ! > >Tip: start the day with lots of coffee ... :) > >-Oorspronkelijk bericht- >Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] >Verzonden: dinsdag 17 juli 2001 15:51 >Aan: Multiple recipients of list ORACLE-L >Onderwerp: ORA-24323 > > >Hello All. > >When i am running my sql script from SQL/PLUS command using >@C:/mypath/mysql.sql >giving error > >ORA-24323: value not allowed >Error accessing package DBMS_APPLICATION_INFO, and disconnected the user >from the database . >Second time when i reconnect and run the script again it runs successfully. > >I have nearly 150 such scripts to be run and i can not use batch sql file to >run these scripts as it generally fails after one script. > >Can some one help me that what is wrong with my databse. Why ORA-24323 error >is coming. > >Thanks in advance >Vinay > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Daemen, Remco > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: Problem connecting to a db
Steven: To log on as INTERNAL in svrmgrl on NT, the user must be a member of the ORA_DBA group, not the Administrators group. Is the user in question a member of the ORA_DBA group? -- Jon Walthour, OCDBA Oracle DBA Computer Horizons Cincinnati, Ohio >--- Original Message --- >From: "Steven Hovington" <[EMAIL PROTECTED]> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Date: 7/17/01 10:06:17 AM > >Logged on as administrator (NT4). >Then in svrmgrl: connect internal/oracle >Or : connect internal (prompted for password): oracle >Same error message either way. >Tried it several times, I don't *think* it is being typed wrong... > >Steven. > >-Original Message- >Gramolini >Sent: 17 July 2001 14:41 >To: Multiple recipients of list ORACLE-L > > >How is the user logged on to the server before trying to run svrmgrl? I >always log on as oracle. > >hth, >Ruth >- Original Message - >To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> >Sent: Tuesday, July 17, 2001 8:30 AM > > >> I have someone on a remote site who is having problems connecting to a db >in >> server mgr as internal. >> connect internal should work, but it replies with insufficient privileges, >I >> must be missing something. >> >> Does anyone have a suggestion what this could be? >> >> OS is NT 4, using Oracle 8.1.6 standard and they are logged on to NT as >> administrator. >> >> Thanks, >> >> Steven. >> >> -- >> Please see the official ORACLE-L FAQ: http://www.orafaq.com >> -- >> Author: Steven Hovington >> INET: [EMAIL PROTECTED] >> >> Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >> San Diego, California-- Public Internet access / Mailing Lists >> >> To REMOVE yourself from this mailing list, send an E-Mail message >> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >> the message BODY, include a line containing: UNSUB ORACLE-L >> (or the name of mailing list you want to be removed from). You may >> also send the HELP command for other information (like subscribing). > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Ruth Gramolini > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Steven Hovington > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to get the list of tables used in a view?
For clarification, a query to SYS.DBA_DEPENDENCIES works all the way back to 7.1.6. -- Jon Walthour, OCDBA Oracle DBA Computer Horizons Cincinnati, Ohio >From: "Reardon, Bruce (CALBBAY)" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: How to get the list of tables used in a view? >Date: Thu, 12 Jul 2001 20:15:44 -0800 > >Hi Ashoke, > >Under 817 you can use dba_dependencies - their may be other ways as well. > >For example: > >SQL> create table a (a integer); > >Table created. > >SQL> create table b (b integer); > >Table created. > >SQL> create view ab as select * from a,b where a=b; > >View created. > >SQL> select * from dba_dependencies where NAME = 'AB'; > >OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME >REFERENCED_T REFERENCED_LINK DEPE >-- -- -- --- > --- >USER01 AB VIEW USER01 B >TABLEHARD >USER01 AB VIEW USER01 A >TABLEHARD > >2 rows selected. > >Searching dba_views.text will be a problem if the table names are split >over >more than 1 line in the view definition. > >Regards, >Bruce Reardon > >-Original Message- >>Sent: Friday, 13 July 2001 1:10 >> >>Greetings, >> >>Is there any dictionary table/view where I can query the name of all the >>tables used by a particular view? >> >>The way I do now is : Query the line containing 'from' in text field of >>dba_views for the specified view. >> >>Is there any other way to get the list of the tables used by a view? >> >>Thanks, >>Ashoke >>-- >>Please see the official ORACLE-L FAQ: http://www.orafaq.com >>-- >>Author: Reardon, Bruce (CALBBAY) >> INET: [EMAIL PROTECTED] >> >>Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >>San Diego, California-- Public Internet access / Mailing Lists >> >>To REMOVE yourself from this mailing list, send an E-Mail message >>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >>the message BODY, include a line containing: UNSUB ORACLE-L >>(or the name of mailing list you want to be removed from). You may >>also send the HELP command for other information (like subscribing). > >_ >Get your FREE download of MSN Explorer at http://explorer.msn.com > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: ASHOKE MANDAL > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: how to check BG process in WIN2000
Seema: As far as I know, all the Oracle background processes on Windows NT/2000 run under the oracle executable. So, in Task Manager, for example, all you can see is the resource usage of oracle.exe, not of the individual processes. The only way I know to monitor the individual Oracle processes on NT/2000 is from within the database. Hope this helps. -- Jon Walthour, OCDBA Oracle DBA Computer Horizons Cincinnati, Ohio >--- Original Message --- >From: "Seema Singh" <[EMAIL PROTECTED]> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Date: 7/12/01 2:40:58 PM > >Hi >How to check Oracle background processes in WIN2000. >Like ps -ef |grep smon in unix >Thanks >-Seema >_ >Get your FREE download of MSN Explorer at http://explorer.msn.com > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Seema Singh > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re: rollback gen
Nicholas: Some DDL (CTAS in particular and other commands that are not exclusively DDL) will generate rollback. The rollback is due to the data dictionary changes incurred in creating the new table and extent allocation. If you're not sure, check it out. Just do a simple test to confirm it. -- Jon Walthour, OCDBA Oracle DBA Computer Horizons Cincinnati, Ohio >--- Original Message --- >From: Nicholas Tufar <[EMAIL PROTECTED]> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Date: 7/12/01 12:01:36 PM > >On Thu, 12 Jul 2001, kommareddy sreenivasa wrote: > >> will a ddl statement generate rollback. >> >> eg: create table or alter table or drop table ... > >As far as I know, no. DDL statements do not generate >rollback. You have to take a full backup after any DDL. > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Nicholas Tufar > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: URGENT ORA-03113
Helen: Try reducing your SHMMAX kernel parameter to under 4GB and see if that works. -- Jon Walthour, OCDBA Oracle DBA Computer Horizons Cincinnati, Ohio >--- Original Message --- >From: Helen rwulfjeq <[EMAIL PROTECTED]> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Date: 7/12/01 6:45:22 AM > > Hi ALL: >Anybody has any luck to install oracle 8.1.7 on Solaris 8. I installed 8.1.5 on same OS without any problem. When I run dbassist , I got ORA-03113 error message. Actually It happened when you execute the command: >startup nomount pfile="/u01/app/oracle/admin/DEV/pfile/initDEV.ora" >I checked previous messages. Someone suggested to reduce the size of kernel SHMM (I don't remember). I just follow the recommanded parameters to modify /etc/system. I have no idea how large I should set the sizes of the parameters. >How can I check the bits of OS or ORACLE like (64 bits or 32 bits). IT IS URGENT. I really appreciate your help. I have to get it done ASAP. It is 4:45am (US CT). I was almost sleepless. Thank you so much. >H.L. > > > >- >Do You Yahoo!? >Get personalized email addresses from Yahoo! Mail - only $35 a year! >http://personal.mail.yahoo.com/ > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORA-12564: TNS:connection refused
Chris: That's odd because you're not supposed to be able to see this error message. Why don't you turn on tracing and do what you were doing again. Then see what the trace file yields in terms of more information. -- Jon Walthour, OCDBA Oracle DBA Computer Horizons Cincinnati, Ohio >--- Original Message --- >From: "Grabowy, Chris" <[EMAIL PROTECTED]> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Date: 7/11/01 2:06:02 PM > >Hello everyone, > >A fellow DBA sent me the below email to forward onto the list. Perhaps >someone can give us some clues as to what were missing?? The original >message they got was "listener not found" or something like that. So they >made some updates to the firewall to allow access, and now there getting >ORA-12564. Many thanks!!! > >* >Chris, > Is there anything on the listserv about this error: ORA-12564: >TNS:connection refused. We are trying to resolve a connectivity issue using >Gauntlet Firewall. We are trying to connect to a database from the >production server to the development server, both are inside the service >network. > >Michael Rothouse >* >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Grabowy, Chris > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: unable to allocate 4096 bytes of shared memory - HELP!!!!
John:
List, please correct me if I'm wrong, but it appears that your
shared pool isn't big enough or is too fragmented. You can try
two things as I see it right now: (1) try pinning your large,
frequently used packages into the shared pool at instance startup
using the DBMS_SHARED_POOL package, or (2) increase the amount
of available shared memory by increasing the value of the initialization
parameters SHARED_POOL_RESERVED_SIZE and SHARED_POOL_SIZE.
Hope this helps.
--
Jon Walthour, OCDBA
Oracle DBA
Computer Horizons
Cincinnati, Ohio
>--- Original Message ---
>From: John Dunn <[EMAIL PROTECTED]>
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Date: 7/11/01 7:40:46 AM
>
>We have just upgraded from 8.0.5 to 8.1.7 and are getting problems
as
>follows :
>
>It appears to be related to dbms_job
>
>Can any one help?
>
>John
>
>Errors in file /u01/app/oracle/admin/PRTGH1/bdump/snp2_28976_prtgh1.trc:
>ORA-12012: error on auto execute of job 11223917
>
>ORA-04031: unable to allocate 4096 bytes of shared memory ("shared
>pool","SERVER
>_PRINTER_RESET","PL/SQL MPCODE","BAMIMA: Bam Buffer")
>ORA-06508: PL/SQL: could not find program unit being called
>ORA-06512: at line 1
>Sun Jul 8 23:52:14 2001
>Errors in file /u01/app/oracle/admin/PRTGH1/bdump/snp1_19492_prtgh1.trc:
>
>ORA-12012: error on auto execute of job 11227622
>ORA-04031: unable to allocate 4096 bytes of shared memory ("shared
>pool","SERVER
>_RECEPTION","PL/SQL MPCODE","BAMIMA: Bam Buffer")
>ORA-06508: PL/SQL: could not find program unit being called
>ORA-06512: at line 1
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: John Dunn
> INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing
Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru')
and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).
You may
>also send the HELP command for other information (like subscribing).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jon Walthour
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Re: Why default domain?
In short, I don't. I use local resolution (as our ONS is frequently down and unreliable) and none of my aliases have domain names attached to them. In my sqlnet.ora, the entries about default domain, etc. are all commented out. -- Jon Walthour, OCDBA Oracle DBA Computer Horizons Cincinnati, Ohio - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, July 10, 2001 8:35 PM > The O'Reilly Net8 book states: > > "It's possible to run a Net8 network without using domains at all." > > If this is true, why create net service names that are qualified by a domain > name, why define a default domain in sqlnet.ora, etc.? What benefit do you > get by setting things up to use a domain? > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Greg Moore > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Date / Time
Sajid: Try this piece. I use a version of it for my uptime.sql script: TO_CHAR(TRUNC(date1 - date2)) || ' day(s), ' || TO_CHAR(TRUNC(MOD(date1 - date2 - 1, 1) * 24)) || ' hour(s), ' || TO_CHAR(TRUNC(((MOD(date1 - date2 - 1, 1) * 24) - (TRUNC(MOD(date1 - date2 - 1, 1) * 24))) * 60)) || ' minute(s) and ' || TO_CHAR(ROUND(MOD(((MOD(date1 - date2 - 1, 1) * 24) - (TRUNC(MOD(date1 - date2 - 1, 1) * 24))) * 60, 1) * 60, 1)) || ' seconds.' -- Jon Walthour, OCDBA Oracle DBA Computer Horizons Cincinnati, Ohio >--- Original Message --- >From: Sajid Iqbal <[EMAIL PROTECTED]> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Date: 7/10/01 9:26:09 AM > >Hello All > >I want to display the "time elapsed" between two dates - in days, hours, >minutes and seconds. > >If I do "select date1 - date2", the result is : 12.0194907 > >Is there a function that will turn the number of days into something more >legible? Ideally i'd like to do ; > >"to_char(12.0194907,'DD:HH:MI:SS')" but obviously that won't work. Is >there a solution other than writing a complex function myself which will >have to * by 24, / by 60 and substr etc to get the different bits of the >number? > >Please CC any replies directly to me at [EMAIL PROTECTED] > >Thanks in advance, >Saj. > > > >-- >Sajid Iqbal >Database Team Leader > > > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Sajid Iqbal > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Rename alert log
Ron: If you mean, "Can the alert log be renamed for archiving purposes while the db is up?" the answer is yes. Oracle will just recreate the alert log the next time it needs to write an entry to it. -- Jon Walthour, OCDBA Oracle DBA Computer Horizons Cincinnati, Ohio >--- Original Message --- >From: "Smith, Ron L." <[EMAIL PROTECTED]> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Date: 7/10/01 10:56:31 AM > >Can the alert log be renamed while the database is up and running? > >Ron >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Smith, Ron L. > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: PX Idle Wait?
Tom: It's a wait that indicates that the Parallel Query slave is waiting for something to do. You can ignore it. -- Jon Walthour, OCDBA Oracle DBA Computer Horizons Cincinnati, Ohio >--- "Terrian, Tom" <[EMAIL PROTECTED]> wrote: >> After looking at the top waits in my databases, I >> see "PX Idle Wait" pop up a >> lot. Does anyone know what this wait means? >> >> Tom >> >> Tom Terrian >> Oracle DBA >> WPAFB - DAASC >> [EMAIL PROTECTED] >> 937-656-3844 >> >> -- >> Please see the official ORACLE-L FAQ: >> http://www.orafaq.com >> -- >> Author: Terrian, Tom >> INET: [EMAIL PROTECTED] >> >> Fat City Network Services-- (858) 538-5051 FAX: >> (858) 538-5051 >> San Diego, California-- Public Internet >> access / Mailing Lists >> > >> To REMOVE yourself from this mailing list, send an >> E-Mail message >> to: [EMAIL PROTECTED] (note EXACT spelling of >> 'ListGuru') and in >> the message BODY, include a line containing: UNSUB >> ORACLE-L >> (or the name of mailing list you want to be removed >> from). You may >> also send the HELP command for other information >> (like subscribing). > > >__ >Do You Yahoo!? >Get personalized email addresses from Yahoo! Mail >http://personal.mail.yahoo.com/ >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: marsy mahmud > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
