RE: privileges on packages
Check out DBA_TAB_PRIVS and look for the EXECUTE privilege. Jon Walthour -Original Message- Sent: Monday, October 01, 2001 5:25 AM To: Multiple recipients of list ORACLE-L hi, HOW to find out the whether a particular user has a execute permission on package or not. Regards, sunil s. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SUNILSHIVAPPA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Walthour, Jon (GEAE, Compaq) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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-01555 when running long script
One thing to remember here is that a single transaction will only use one rollback segment. The problem is that ORA-1555 errors occur because a consistent get for a particular db block failed. Here are some things to check: 1. Make sure you're running this script during off hours. The fewer transaction that are running to change db blocks, the better. 2. Place as many explicit commits in your script that are realistically possible. 3. Shrink all your rbs's to their optimal size before running the query. For more information on ORA-1555 errors, check out Steve Adams' excellent treatment of it at http://www.ixora.com.au/tips/admin/ora-1555.htm. Jon Walthour -Original Message- Sent: Sunday, September 23, 2001 6:15 PM To: Multiple recipients of list ORACLE-L Hi, We are running script in whcih we are updating 25 tables but after every 5 tables we are getting oracle error ora-01555.. we tried many options with rolback segment but no use: 1) few very large rollback segment 2 many large rolback segments rollback tablespace size is 5GB what can be the other causes for error??? 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: Walthour, Jon (GEAE, Compaq) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: DB Names in multiple oracle installs
Title: Message Sujatha: I've never done this myself, but I would think if you set us a second listener on a different port, it should work from a SQL*Net point of view. However, you'd probably have problems in the ORATAB file and in the local environment itself with things like svrmgrl. On NT I'm sure it's not possible as the names of the db services would be identical. So, I don't think it's possible from every aspect. But I'm curious now if someone else has better ideas than I. Jon Walthour -Original Message-From: Sujatha Madan [mailto:[EMAIL PROTECTED]] Sent: Monday, September 17, 2001 9:05 PMTo: Multiple recipients of list ORACLE-LSubject: DB Names in multiple oracle installs Hi, Is it possible to call two databases the same name if they are residing on the same machine, in different oracle homes? ... One database is version 8.0.6 and the other is 8.1.7. Thanks Sujatha
RE: OT Start Button
Title: Message You can't. Jon Walthour -Original Message-From: Swapna_Chinnagangannagari [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 16, 2001 3:50 AMTo: Multiple recipients of list ORACLE-LSubject: OT Start Button Hello All, Sorry for posting a OT. How can i change the text of the START button. I'm using windows'95. Regards Swapna
RE: OT Start Button
I stand corrected. Upon further exploration of this subject, I found these on the Internet: http://registry.winguides.com/display.php/791 Or http://www.inquirer.net/infotech/jan2000wk2/info_5.htm Jon Walthour -Original Message- Sent: Sunday, September 16, 2001 9:40 AM To: Multiple recipients of list ORACLE-L No, it is possible. 4-5 years ago I was using W95 and there was a small 'tuning' utility to change look of Windows GUI. Take a look on skinning of Windows software and you will find something. Best regards JP On Sun 16. September 2001 14:20, you wrote: You can't. Jon Walthour -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 16, 2001 3:50 AM To: Multiple recipients of list ORACLE-L Hello All, Sorry for posting a OT. How can i change the text of the START button. I'm using windows'95. Regards Swapna Content-Type: text/html; name=Poiloha: 1 Content-Transfer-Encoding: 7bit Content-Description: -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Walthour, Jon (GEAE, Compaq) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: PL/SQL procedure to return multiple rows
Audrey: What you want is a cursor variable. A cursor variable references a cursor object and may refer to different SQL statements at different times. In your case, the most important benefit of the cursor variable would be that it provides a mechanism for passing results of queries (the rows returned by fetches against a cursor) between different PL/SQL programs. Jon Walthour -Original Message- Sent: Sunday, September 16, 2001 2:55 PM To: Multiple recipients of list ORACLE-L Dear DBAs ! I need to write a stored proc that will do the following : -- open a cursor ; -- loop over the rows returned by the cursor , filter out some of the rows that do not match a certain criteria , do some processing on other rows (that match the criteria) and then return those rows (the processed data) to the calling program ( a PERL DBI script or a java program ) . Ho do U return those multiple rows to a calling program ? It's Oracle 8.0.5 , NOT 8i :-( Thanks a lot in advance, DBAndrey * 03-9254520 * 053-464562 * mailto:[EMAIL PROTECTED] -- 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: Walthour, Jon (GEAE, Compaq) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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-04030 error
Title: Message Big: Try increasing the buffer_size parameter on the import to 1 mb. Jon Walthour -Original Message-From: Big Planet [mailto:[EMAIL PROTECTED]] Sent: Friday, September 14, 2001 9:40 PMTo: Multiple recipients of list ORACLE-LSubject: ORA-04030 error Hi All , I am getting this error ORA-04030 out of memory when importing in 8.1.7 Solaris 8 . There is no data in import it is just empty tables and stored procs .The error comes with one stored proc . Any Idea how this can be solved . TIA , -BigP
RE: When optimizer reevaluate SQL statement
!! Please do not post Off Topic to this List !! Chris: If you are executing it under a different user the statement will be reparsed. I'm puzzled. I always thought that different users submitting the identical SQL statement would use the same plan and not need to be reparsed. I understood that to be part of the reasoning behind bind variables and the big advantage of cursor sharing. Please explain. Jon Walthour -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walthour, Jon (GEAE, Compaq) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: When optimizer reevaluate SQL statement
!! Please do not post Off Topic to this List !! Thanks, Chris. I've learned something. Jon Walthour -Original Message- Sent: Friday, September 14, 2001 1:56 PM To: Multiple recipients of list ORACLE-L !! Please do not post Off Topic to this List !! If the Oracle executing user is different, the execution plan will be different due to possibility of different objects and security. Different sessions under the same user can share using bind variables. 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: Friday, September 14, 2001 12:25 PM To: Multiple recipients of list ORACLE-L !! Please do not post Off Topic to this List !! Chris: If you are executing it under a different user the statement will be reparsed. I'm puzzled. I always thought that different users submitting the identical SQL statement would use the same plan and not need to be reparsed. I understood that to be part of the reasoning behind bind variables and the big advantage of cursor sharing. Please explain. Jon Walthour -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walthour, Jon (GEAE, Compaq) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Walthour, Jon (GEAE, Compaq) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Smon in trouble?
!! Please do not post Off Topic to this List !!
Ian:
Try this:
1. shutdown immediate or shutdown abort
2. startup restricted
3. Take all online user tablespaces offline then back online (not TEMP, RBS,
SYSTEM, etc.) This will stop SMON from trying to recover information in the
corrupted rollback segment.
4. Now the problem rollback segment should be fine. Its status should change
to online.
5. shutdown immediate
6. startup
7. Drop the problem rollback segment and all the rbs's in its tablespace.
8. Drop the tablespace and recreate it.
9. Recreate your rollback segments.
After this, things should return to normal without any loss of data.
Jon Walthour
-Original Message-
Sent: Wednesday, September 12, 2001 11:25 PM
To: Multiple recipients of list ORACLE-L
Hi all,
I had a large table 31 million rows and was trying to add a column to this
table. It used up a lot of Rollback segment, but that was ok as I gave it
plenty, but after a long period of time it died before successfully adding
the column, ie. The database died.
After restarting the database, I can successfully log into it etc. but in
the alert log I am getting a repeated message and the alert log just keeps
growing.
Following is from the alert.log file, I wonder if anyone can give some idea
of why it is doing this and what I need to do to stop it?
Thanks
alter database open
Beginning crash recovery of 1 threads
Recovery of Online Redo Log: Thread 1 Group 2 Seq 5939 Reading mem 0
Mem# 0 errs 0: D:\ORANT\DATABASE\GCAC\LOG02.ORA
Thu Sep 13 11:44:09 2001
Crash recovery completed successfully
Thu Sep 13 11:44:11 2001
Thread 1 advanced to log sequence 5940
Current log# 4 seq# 5940 mem# 0: X:\ORANT\DATABASE\GCAC\LOG4.ORA Thread 1
opened at log sequence 5940
Current log# 4 seq# 5940 mem# 0: X:\ORANT\DATABASE\GCAC\LOG4.ORA
Successful open of redo thread 1. Thu Sep 13 11:44:11 2001
SMON: enabling cache recovery
SMON: enabling tx recovery
Thu Sep 13 11:44:14 2001
Completed: alter database open
Thu Sep 13 11:44:14 2001
SMON: about to recover undo segment 5
SMON: mark undo segment 5 as available
SMON: about to recover undo segment 5
SMON: mark undo segment 5 as available
SMON: about to recover undo segment 5
SMON: mark undo segment 5 as available
SMON: about to recover undo segment 5
SMON: mark undo segment 5 as available
The above 2 lines repeat over and over until I shutdown the
database.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Biddell, Ian
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (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: Walthour, Jon (GEAE, Compaq)
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: bitmap indexes and rule based optimizer
Alex: No, the rbo does not support bitmap indexes or any other Oracle8 or greater feature (such as partitioning, etc.). To use these features, you must set optimizer_mode to CHOOSE, FIRST_ROWS or ALL_ROWS, which will invoke the cbo. Jon Walthour -Original Message- Sent: Wednesday, September 12, 2001 1:05 PM To: Multiple recipients of list ORACLE-L Anybody knows whether rule based optimizer can use bitmap indexes? 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: Walthour, Jon (GEAE, Compaq) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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[2]:RE: STOP THE PRESS!!
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 12, 2001 10:35 AM To: Multiple recipients of list ORACLE-L Subject: Re[2]:RE: STOP THE PRESS!! Rachel, Am I ever GLAD to hear from you again. I guess we can assume that GOD was smiling at you yesterday thank Him/Her for that. Sorry, but I couldn't let this one pass. Dick, are you suggesting, by extension then, that God WASN'T smiling on all those who died yesterday? Jon Walthour -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walthour, Jon (GEAE, Compaq) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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[2]:RE: STOP THE PRESS!!
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 12, 2001 10:35 AM To: Multiple recipients of list ORACLE-L Subject: Re[2]:RE: STOP THE PRESS!! Rachel, Am I ever GLAD to hear from you again. I guess we can assume that GOD was smiling at you yesterday thank Him/Her for that. Sorry, but I couldn't let this one pass. Dick, are you suggesting, by extension then, that God WASN'T smiling on all those who died yesterday? Jon Walthour -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walthour, Jon (GEAE, Compaq) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: bitmap indexes and rule based optimizer
True. Whoops. Jon Walthour -Original Message- Sent: Wednesday, September 12, 2001 4:15 PM To: Multiple recipients of list ORACLE-L Thanks. However bitmap indexes are 7.3+ feature - why I asked. Alex Hillman -Original Message- Sent: Wednesday, September 12, 2001 1:50 PM To: Multiple recipients of list ORACLE-L Alex: No, the rbo does not support bitmap indexes or any other Oracle8 or greater feature (such as partitioning, etc.). To use these features, you must set optimizer_mode to CHOOSE, FIRST_ROWS or ALL_ROWS, which will invoke the cbo. Jon Walthour -Original Message- Sent: Wednesday, September 12, 2001 1:05 PM To: Multiple recipients of list ORACLE-L Anybody knows whether rule based optimizer can use bitmap indexes? 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: Walthour, Jon (GEAE, Compaq) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Walthour, Jon (GEAE, Compaq) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Interesting News..
Well, I can't speak for all of Compaq. But my part (supporting GE Aircraft Engines) is now and will continue to be receiving great service from Compaq. Jon Walthour -Original Message- Sent: Tuesday, September 11, 2001 10:40 AM To: Multiple recipients of list ORACLE-L So, as you devote the extra minutes to your job, does this mean COMPAQ customer service will get better or worse? EG -Original Message- Sent: Monday, September 10, 2001 10:50 PM To: Multiple recipients of list ORACLE-L After thinking about this whole thing further, I realize I've made a terrible mistake. I've stooped to his level rather than stay mature about the whole thing and let it go. It won't happen again. To all of you who've had to receive these messages, I'm sorry. I'm done with this thread. Jon Walthour -Original Message- Sent: Monday, September 10, 2001 7:28 PM To: Walthour, Jon (GEAE, Compaq) Cc: [EMAIL PROTECTED] Jon, Believe it or not, some people *DO* know they are getting screwed even if the person doing it is being superficially polite. regards, ep On 10 Sep 2001, at 19:19, Walthour, Jon (GEAE, Compaq) [EMAIL PROTECTED] wrote: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Date sent: Mon, 10 Sep 2001 19:19:17 -0400 Eric: I wasn't being a pissy little fascist as you call it. I was attempting to be respectful of you, courteous and professional. But, since you obviously insist on responding like the child you are, let me say, Sticks and stones may break my bones, but names will never hurt me. :-P Who pissed in your Cheerios this morning? Jon Walthour Oracle Database Administrator COMPAQ DBA Team Cincinnati, Ohio -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walthour, Jon (GEAE, Compaq) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Walthour, Jon (GEAE, Compaq) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: v_$session HELP...
The sessions where username is null are generally the Oracle background processes. You can confirm this by also checking the TYPE column for 'BACKGROUND'. Jon Walthour -Original Message- Sent: Monday, September 10, 2001 8:56 AM To: Multiple recipients of list ORACLE-L Hi all, Can someone tell me who are those users that identified by null value in username column SQL SELECT username from v_$session where osuser='dba'; USERNAME --- SYS SYS 8 rows selected. Thank you 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: Walthour, Jon (GEAE, Compaq) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: shutdown immediate hangs
Dave: The message in the alert log means that there are uncommitted transactions. During a shutdown immediate uncommitted transactions are rolled back and Oracle must wait until this rollback is complete before the db can be actually shut down. You could do a shutdown abort, but then you would have to have this rollback done during startup, which may be preferable, but Oracle does not recommend shutdown aborts unless absolutely necessary and one shouldn't rely on a cold backup taken on an aborted db. Either way, though, the rollback must occur. One thing you could do is check v$transaction before you shutdown. The used_ublk column may give you some idea of how much rollback has to be done. Jon Walthour -Original Message- Sent: Monday, September 10, 2001 12:10 PM To: Multiple recipients of list ORACLE-L I have Oracle 8.1.7 running on windoze NT 4.0. Every night I have a script that kicks off a cold backup. Part of the script issues the command SHUTDOWN IMMEDIATE which normally works just fine before I actually copy my files. However, periodically the shutdown immediate command does not work. It just hangs until someone complains that they cannot connect to the database or when I come in early in the morning and notice it hanging. In my SIDAlrt.log I get the following SHUTDOWN: waiting for active calls to complete This also shows up in a trace file file multiple times. I have to issue a shutdown abort to stop the database. In doing some research on metalink I see that otheres also have this problem. The responses from Oracle are somewhat vague. I do see that one of the responses seems to indicate that if the intelligent agent is running that it could be the cause for the hanging. Has anyone else had this problem and solved it by shutting down the intelligent agent service?? Any other things that I can do to remedy this. Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walthour, Jon (GEAE, Compaq) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Interesting News..
After thinking about this whole thing further, I realize I've made a terrible mistake. I've stooped to his level rather than stay mature about the whole thing and let it go. It won't happen again. To all of you who've had to receive these messages, I'm sorry. I'm done with this thread. Jon Walthour -Original Message- Sent: Monday, September 10, 2001 7:28 PM To: Walthour, Jon (GEAE, Compaq) Cc: [EMAIL PROTECTED] Jon, Believe it or not, some people *DO* know they are getting screwed even if the person doing it is being superficially polite. regards, ep On 10 Sep 2001, at 19:19, Walthour, Jon (GEAE, Compaq) [EMAIL PROTECTED] wrote: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Date sent: Mon, 10 Sep 2001 19:19:17 -0400 Eric: I wasn't being a pissy little fascist as you call it. I was attempting to be respectful of you, courteous and professional. But, since you obviously insist on responding like the child you are, let me say, Sticks and stones may break my bones, but names will never hurt me. :-P Who pissed in your Cheerios this morning? Jon Walthour Oracle Database Administrator COMPAQ DBA Team Cincinnati, Ohio -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walthour, Jon (GEAE, Compaq) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Logging into Windows 2000 Advanced Server
Thank you for the correction, Mohammad. Jon Walthour -Original Message- Sent: Sunday, September 09, 2001 1:10 AM To: Multiple recipients of list ORACLE-L David, Although Jon has given you almost complete solution but your answer to login as sqlplus is sqlplus / as sysdba and you will connected as sys...This is also courtsy of Jon who gave this answer to someone couple of days back... Regards MOHAMMAD RAFIQ Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Sat, 08 Sep 2001 20:30:17 -0800 The ORA-1113 message suggests that you have a file that needs media recovery, which makes sense considering the abrupt shutdown. Instead of opening the database, mount it first through SVRMGRL, the type recover database. You may be asked for some archive logs if you're in archivelog mode. Just follow the directions that Oracle provides. You should be able to do a full recovery if the file is not permanently damaged. My guess is that the db may just be out of sync and media recovery will just get things back in sync. After the media recovery finishes, run alter database open. To do this, go to a command prompt and type set to see all your environment variables. To use SVRMGRL, you need to set your ORACLE_SID variable. To do this, enter set ORACLE_SID=your oracle sid goes here. The run SVRMGRL, connect internal, and mount the database. Then recover it and open it. For example: C:\set oracle_sid=mydb C:\svrmgrl Oracle Server Manager Release 3.1.7.0.0 - Production Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved. Oracle8i Enterprise Edition Release 8.1.7.2.1 - Production With the Partitioning option JServer Release 8.1.7.2.1 - Production SVRMGR connect internal Connected. SVRMGR startup mount ORACLE instance started. Total System Global Area 52193308 bytes Fixed Size 75804 bytes Variable Size10342400 bytes Database Buffers 41697280 bytes Redo Buffers77824 bytes Database mounted. SVRMGRrecover database Database recovered. (There may be more to this step to do any media recovery.) SVRMGR alter database open; Statement processed. SVRMGR ... and on you go ... Hope this helps. Jon Walthour -Original Message- Sent: Saturday, September 08, 2001 8:45 PM To: Multiple recipients of list ORACLE-L Hope somebody can help. Our network personnel rebooted a Windows 2000 production box without shutting down Oracle. I now have the following error in my alert log: Sat Sep 08 13:45:08 2001 Database mounted in Exclusive Mode. Completed: alter database mount exclusive Sat Sep 08 13:45:08 2001 alter database open ORA-1113 signalled during: alter database open... Metalink says to check my environment variables. Is there an equivalent of the UNIX env command on NT? I'm not sure exactly where the environment is defined here. I'd also like to access this database from the command line to manually start it up. Having had no success with the as SYSDBA options for sqlplus on either UNIX or NT, I figure I must be using the wrong syntax. I know I can't use terminal services client (because the bequeath protocol doesn't work), but here's what I'm gettiing after I explicitly set the ORACLE_SID (Metalink says the double quotes are mandatory): sqlplus username/password connect as sysdba Usage: SQLPLUS [ [option] [logon] [start] ] where option ::= - | -? | [ [-M o] [-R n] [-S] ] logon ::= username[/password][@connect_string] | / | /NOLOG start ::= @filename[.ext] [parameter ...] - displays the usage syntax -? displays the SQL*Plus version banner -M o uses HTML markup options o -R n uses restricted mode n -S uses silent mode TIA - David A. Barbour Oracle DBA, OCP AISD 512-414-1002 -- 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: Walthour, Jon (GEAE, Compaq) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL
RE: How to organize oracle directories in Unix ?
CHAN: If I'm wrong, please correct me, but if you're talking about where to put things for performance reasons and you're using a RAID 5 configuration, then it doesn't make any difference. With a RAID 5 configuration, as I remember, is striped with parity and all the disks are seen as one big volume. Assuming all this is true, it doesn't matter where you put the files in which case I would suggest putting them all under the same directory structure for easy management. If, however, we are talking about separate disks/controllers, here are few file placement perf tuning tips I've come to learn with regard to your questions: Is there any disadvantage if I put the redo log file and control file in different directories but in the same mount point ? Yes, redo logs are essential to recovery. The speed at which redo logs can be written to in many ways determines has a direct impact on the overall performance of the database. Therefore, redo logs should put redo logs on their own devices. Is there any disadvantage if I put the rollback segment data file together with my data file in the same directory ? For the same reasoning above, rollback segments should be on their own devices since inserts, updates and deletes will normally require writing to rollback as well. Is there any disadvantage if I put the tablespace data file together with my temp tablespace data file in the same directory ? Again, the issue here is contention. If you are selecting a large amount of data from a particular table in a particular tablespace and the data must be sorted and that sort must use the sort segment in the temporary tablespace, you don't want that sorting to be utilizing the same controller/disk(s) as the selecting does. Otherwise, you could end up with a I/O performance bottleneck. List, if I'm wrong here, please correct me. Jon Walthour -Original Message- Sent: Sunday, September 09, 2001 7:05 AM To: Multiple recipients of list ORACLE-L Hi Guru, How do you organize your oracle directories in Unix ? I am thinking of using the configurations below. We are using Raid 5 with various mount points. \dg1\oracle = contains Oracle Human Resources software applications and oracle home .eg. sidappl, sidcomn, sidora \dg2\oracle = contains redo log file and control file eg. sidredo sidctrl \dg3\oracle = contains redo log file and control file eg. sidredo sidctrl \dg4\oracle = contains redo log file and control file eg. sidredo sidctrl \dg5\oracle = system tablespace file and temp tablespace data file .eg. siddata \dg6\oracle = data file and rollback segment data file .eg. siddata \dg7\oracle = index file eg. sididx \dg8\oracle = archive log file .eg. sidarc Is there any disadvantage if I put the redo log file and control file in different directories but in the same mount point ? Is there any disadvantage if I put the rollback segment data file together with my data file in the same directory ? Is there any disadvantage if I put the tablespace data file together with my temp tablespace data file in the same directory ? TIA Regds, New Bee -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Walthour, Jon (GEAE, Compaq) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Logging into Windows 2000 Advanced Server
The ORA-1113 message suggests that you have a file that needs media recovery, which makes sense considering the abrupt shutdown. Instead of opening the database, mount it first through SVRMGRL, the type recover database. You may be asked for some archive logs if you're in archivelog mode. Just follow the directions that Oracle provides. You should be able to do a full recovery if the file is not permanently damaged. My guess is that the db may just be out of sync and media recovery will just get things back in sync. After the media recovery finishes, run alter database open. To do this, go to a command prompt and type set to see all your environment variables. To use SVRMGRL, you need to set your ORACLE_SID variable. To do this, enter set ORACLE_SID=your oracle sid goes here. The run SVRMGRL, connect internal, and mount the database. Then recover it and open it. For example: C:\set oracle_sid=mydb C:\svrmgrl Oracle Server Manager Release 3.1.7.0.0 - Production Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved. Oracle8i Enterprise Edition Release 8.1.7.2.1 - Production With the Partitioning option JServer Release 8.1.7.2.1 - Production SVRMGR connect internal Connected. SVRMGR startup mount ORACLE instance started. Total System Global Area 52193308 bytes Fixed Size 75804 bytes Variable Size10342400 bytes Database Buffers 41697280 bytes Redo Buffers77824 bytes Database mounted. SVRMGRrecover database Database recovered. (There may be more to this step to do any media recovery.) SVRMGR alter database open; Statement processed. SVRMGR ... and on you go ... Hope this helps. Jon Walthour -Original Message- Sent: Saturday, September 08, 2001 8:45 PM To: Multiple recipients of list ORACLE-L Hope somebody can help. Our network personnel rebooted a Windows 2000 production box without shutting down Oracle. I now have the following error in my alert log: Sat Sep 08 13:45:08 2001 Database mounted in Exclusive Mode. Completed: alter database mount exclusive Sat Sep 08 13:45:08 2001 alter database open ORA-1113 signalled during: alter database open... Metalink says to check my environment variables. Is there an equivalent of the UNIX env command on NT? I'm not sure exactly where the environment is defined here. I'd also like to access this database from the command line to manually start it up. Having had no success with the as SYSDBA options for sqlplus on either UNIX or NT, I figure I must be using the wrong syntax. I know I can't use terminal services client (because the bequeath protocol doesn't work), but here's what I'm gettiing after I explicitly set the ORACLE_SID (Metalink says the double quotes are mandatory): sqlplus username/password connect as sysdba Usage: SQLPLUS [ [option] [logon] [start] ] where option ::= - | -? | [ [-M o] [-R n] [-S] ] logon ::= username[/password][@connect_string] | / | /NOLOG start ::= @filename[.ext] [parameter ...] - displays the usage syntax -? displays the SQL*Plus version banner -M o uses HTML markup options o -R n uses restricted mode n -S uses silent mode TIA - David A. Barbour Oracle DBA, OCP AISD 512-414-1002 -- 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: Walthour, Jon (GEAE, Compaq) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Interesting News..
Eric: While I can appreciate that your opinion of the Compaq Services division might be less than positive, would you please, for the sake of those who actually work for these companies, be a little less dramatic in your expression of that opinion. Jon Walthour Oracle Database Administrator COMPAQ DBA Team Cincinnati, Ohio -Original Message- Sent: Thursday, September 06, 2001 4:22 PM To: Multiple recipients of list ORACLE-L According to our hardware resalescritter: especially for anything below large enterprise level, both HP and Compaq services suck. so, I guess the objective is to create a new company who services suck even more than either individually? Synergy!!! Guy Hammond wrote: On the contrary, I'd say this is a godsend for Sun. Compaq made a mess of truly epic proportions when they tried to integrate DEC and Tandem into their operations. HP did just as badly with Apollo. ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Walthour, Jon (GEAE, Compaq) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Publishing HTML
Chris: If you know some basic HTML, I would think the best way would be to send the output of the query to a file via UTL_FILE, formatting it into HTML along the way. I saw a Oracle sales geek do this once demonstrating how to use DBMS_JOB and UTL_FILE to refresh static web pages on a website on a periodic basis. Jon Walthour -Original Message- Sent: Friday, September 07, 2001 11:56 AM To: Multiple recipients of list ORACLE-L On a good day, I'm challenged to spell HTML so I need advice. I have a strightforward SQL query that produces our internal phone list. I'd like to make this data available on our Intranet. What is the simplest way for me to webify this output? This can really be a static webpage; rather than doing a real time DB query anytime somebody wants to look at the phone list on the web. TIA HAND! -- Charlie Mengler Maintenance Warehouse [EMAIL PROTECTED] 10641 Scripps Summit Ct. 858-831-2229 San Diego, CA 92131 Data-free analysis results in a success-free history. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Walthour, Jon (GEAE, Compaq) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Rebuilding Indexes Nightly on Solaris
First off, checking on a regular basis for indexes that need rebuilding is fine, but don't rebuild all of them every night. Not only is it unnecessary, it can cause lots of problems. Only rebuild the indexes you need to--the ones who are significantly browned, have a significant percentage of deletes, or whose height is significant. Second, setting up a cron job is indeed a good idea. And David is right that you want to make sure to explicitly set up your environment, but not for the reason he suggests. The problem isn't that the job runs as root. If it were the case that every cron job on a UNIX box ran as root, then that would be a mighty big security hole. The issue is that when running a cron job, the account under which it runs does not automatically get its environment initialized by running .profile as it does when you log in. Thus, the environment must be specifically laid out. Hope this helps. Jon Walthour -Original Message- Sent: Thursday, September 06, 2001 1:33 PM To: Multiple recipients of list ORACLE-L David - Use cron. Nightly might be excessive. Kick off a shell script (remember that cron executes as root, so you need to set your environment) and create your own script dynamically (following code is use for backups also) in a manner like: rebuild_index.sh #!/bin/ksh export PATH=$PATH:/u001/app/oracle/product/8.1.7/bin export ORACLE_SID=ifas export PATH=$PATH:/$ORACLE_HOME/bin export ORACLE_HOME=/u001/app/oracle/product/8.1.7 export ORACLE_BASE=/u001/app/oracle sqlplus either use a password protection scheme or hardcode your access here username/password @/usr/local/bin/rebuild_index exit rebuild_index.sql spool rebuild_index.sql Select 'Alter index ' || index_name || ' rebuild;' from dba_indexes; # add selection caveats if desired spool off !chmod 777 /u014/oradata/ifastrn/rebuild_index.sql @/u014/oradata/ifastrn/rebuild_index exit Lots of variations possible. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Kimberly Smith [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] jitsu.com cc: Sent by: Subject: RE: Scripts for Rebuilding Indexes Nightly on Solaris [EMAIL PROTECTED] 09/06/2001 11:57 AM Please respond to ORACLE-L Nightly? That is a lot. Are you really entering that much data on a daily basis? -Original Message- From: David Wagoner [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 06, 2001 8:57 AM To: Multiple recipients of list ORACLE-L Subject: Scripts for Rebuilding Indexes Nightly on Solaris Does anyone have any good scripts for rebuilding indexes nightly on Solaris UNIX that they'd be willing to share? Also, in your experience is it better to run this through UNIX cron jobs than using the Oracle OEM job scheduler? I suspect the cron job will be the favorable answer. Thanks in advance, David Wagoner Oracle DBA -- 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: Walthour, Jon (GEAE, Compaq) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Test Message
Title: Message This is a test message. Please ignore. Jon Walthour Oracle Database Administrator COMPAQ DBA Team Cincinnati, Ohio
RE: Alter tablespace add datafile
Oracle will see from the total free space of your TABLESPACE, it wont see from datafile level There's one issue with this, however, to keep in mind. Extents cannot span datafiles. So, more datafiles do add a degree of more fragmentation. Jon Walthour -Original Message- Sent: Wednesday, September 05, 2001 11:36 PM To: Multiple recipients of list ORACLE-L - Instead adding a new datafile you can resize a datafile (oracle 7.3.4 above) - Adding and resize datafile you can do it online... - Oracle will automatically manage the space, it doesnt mean if you add a new datafile the old one will not be used anymore, Oracle will see from the total free space of your TABLESPACE, it wont see from datafile level... Rgds/Jeram -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thursday, September 06, 2001 8:46 AM One of our datafiles is about to reach it's maxsize. Is the only way around this to do an alter tablespace add datafile? - Can the database be up and running for this? - After I create the new datafile does this mean Oracle will automatically use the new one and leave the old one? - Is there any other way I can get around this by not shutting down the database??? Thanks in advance sujatha -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sujatha Madan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Jeram INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Walthour, Jon (GEAE, Compaq) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Interesting News..
Jared: It's the buzz of the office this morning. No one here seems to have seen it coming. Jon Walthour Oracle Database Administrator COMPAQ DBA Team Cincinnati, Ohio -Original Message- Sent: Tuesday, September 04, 2001 12:33 PM To: Multiple recipients of list ORACLE-L HP Acquiring Compaq? Yow! That's big news! Anyone see this coming? I would have never guessed. Jared On Tuesday 04 September 2001 07:02, Mark Leith wrote: Thought this would interest you guys.. http://www.theitportal.com/ITPFrameSetBottom.asp?Path=http%3A%2F%2Fwww%2Ema c world%2Eco%2Euk%2Fnews%2Fmain%5Fnews%2Ecfm%3FNewsID%3D3442Domain=www.macwo r ld.co.ukAdArea=TEST Regards 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: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walthour, Jon (GEAE, Compaq) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: connecting as internal
Instead of connecting Internal, which really only works for SYS, try / as sysdba ... such as: sqlplus / as sysdba Jon Walthour -Original Message- Sent: Tuesday, September 04, 2001 7:01 PM To: Multiple recipients of list ORACLE-L I can connect to sqlplus as internal if I am logged on to UNIX as the oracle owner oracle. But I want to be able to logon to SQLPLUS as internal from another UNIX user. I had the SA's set up a user and assigned him to the group dba (database group). But I am having problems connecting : SQL*Plus: Release 8.1.6.0.0 - Production on Tue Sep 4 14:56:13 2001 (c) Copyright 1999 Oracle Corporation. All rights reserved. Enter user-name: internal ERROR: ORA-09925: Unable to create audit trail file SVR4 Error: 13: Permission denied Additional information: 9925 How do I configure this on my system ? Environment : Oracle 8.1.6 Sun Sparc Solaris 5.8 Thanks in advance P Howe Email : [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pat Howe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Walthour, Jon (GEAE, Compaq) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Fwd: RE: !! *Very* important Oracle-L message !!
I don't think they would agree to that as they would point to MetaLink. Jon Walthour -Original Message- Sent: Thursday, August 30, 2001 3:30 AM To: Multiple recipients of list ORACLE-L May be I'm a naive idiot (Forrest Gump :-)), but have somebody asked Oracle to sponzor this community of Oracle users? Jan Pruner -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Walthour, Jon (GEAE, Compaq) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 to Sql Server
Title: Message Easy. Use SQL*Server's DTS (data transformation services) to pull the data from Oracle into SQL*Server. Jon Walthour -Original Message-From: Apps Sol [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 30, 2001 12:07 PMTo: Multiple recipients of list ORACLE-LSubject: Oracle to Sql Server Hello Folks, I am looking for some cool script to move all the database objects across from Oracle 8.1.7 to Latest Sql Server (ver ???) frequently. Is there any particular way we can do it to automate this ?? BTW: I want to pledge $20 or even willing to pay yearly subscription and it would be a good idea to Send out a Pledge form to everyone . to keep the greens coming.. Cheers RK
