Re: sqlplus question
And if you are running an unavowable OS, you can probably turn your SQL*Plus script into a jPL/SQL procedure and schedule it using dbms_job. Weaver, Walt wrote: Cron? At? -Original Message- Sent: Monday, January 28, 2002 3:21 PM To: Multiple recipients of list ORACLE-L Hello, I need to run some script using Oracle Sqlplus. The script is only suppose to run certain days of week. Does anyone have a suggestion how to do that. Thank you. -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
LOB Help needed
Title: LOB Help needed Hi, Has anyone any document about implementation of Lobs/BFILES using Oracle Developer 6/6i as front end tool. Manulplating LOBs within the database is not a big problem, but getting them out to display it is what I need. I have found a doc which explains the procedure but its about JAVA not Developer 6, Any help in the regards will be highly appreciated.. Thanks in Advance, Arslan Zaheer Dar [EMAIL PROTECTED] Database Administrator Shaukat Khanum Memorial Cancer Hospital Research Centre www.shaukatkhanum.org.pk
Re: AW: auditing tables
Foelz.Frank wrote: TNX for your answers. What I need is exactly what Oracle doesn't support. Logging who changed what in a special area of our database. I think triggering the events will be much more specific and more easy to change. In case all our applications use the same database and user, I am trying to check out what application is changing monitored tables (i.e. c:\app\userapp\app.exe is changing table1). What do you think of that ?? greets Frank dbms_application_info + triggers. -- Regards, Stephane Faroult Oriole Ltd -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RTFM questions (formally RE: PL/SQL)
Amen! -Original Message- Sent: 29 January 2002 06:20 To: Multiple recipients of list ORACLE-L The problem is that if you always ask the group for help, you never learn where the information is within the manuals or other reference documentation and the group also gets cluttered with trivia. I agree with you that the list is here to help people and I personally do not mind the odd naive question from a new DBA, but it is the ...can't be bothered to look up the manual.. attitude that is most frustrating. When you ask the format of a command (for example) to the list, you are potentionally asking 1000's of people the same question who will all have to spend the time to filter these questions - we are all busy people and I personally do not want to use my time in this way. I'm sure you can see that this is a much more expensive option than asking the person next to you. Cheers, Craig. -Original Message- mailto:[EMAIL PROTECTED] ] Sent: Tuesday, 29 January 2002 2:55 PM To: Multiple recipients of list ORACLE-L Why do you bother being on this List: The list is here to help fellow DBA'S. Have you never said to one of your collegues , what is the format of this command, or how can I do that, when you simply cant be bothered to look it up in the manual (either your busy or just down right lazy): Sometimes this list is useful for just that. So why dont u lighten up dude. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com 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: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OFF TOPIC: RE: PL/SQL
When I arrive in the morning to a mailbox containing 150+ messages from this list, I'm almost certainly guaranteed that 10% of them will be questions that can easily be found via otn or a manual. That 10% usually comes from the same person!! No wonder I'm irritated!!! }:o| -Original Message- Sent: 28 January 2002 17:35 To: Multiple recipients of list ORACLE-L Geez... lay off already. If you don't think the question is worthy of your time, then don't answer it. What a grouch. -Original Message- Sent: Monday, January 28, 2002 11:16 AM To: Multiple recipients of list ORACLE-L RRR TTTFF !! -Original Message- Sent: 28 January 2002 15:46 To: Multiple recipients of list ORACLE-L How can I in a pl/sql block write null if I want null to be inserted in a field when I use dynamic sql.? . I mean nothing is going to be inserted. Thanks in advance Roland -- 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: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seefelt, Beth INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: sqlplus question
I was also trying to put some script on Oracle scheduler and successful too. But on Oracle 8 I failed. It was successful on Oracle 8i (8 doesn't support execute immediate). Would appreciate, if someone can give equivalent code for Oracle 8. Here is the code for Oracle 8i, create or replace PROCEDURE SWITCH IS 2 BEGIN 3 execute immediate 'alter system switch logfile '; 4 commit ; 5 END; 6 / Thanks in Advance, Rajesh NOTE: It would be executed with any user having sysdba privilege. -Original Message- Faroult Sent: Tuesday, January 29, 2002 11:40 AM To: Multiple recipients of list ORACLE-L And if you are running an unavowable OS, you can probably turn your SQL*Plus script into a jPL/SQL procedure and schedule it using dbms_job. Weaver, Walt wrote: Cron? At? -Original Message- Sent: Monday, January 28, 2002 3:21 PM To: Multiple recipients of list ORACLE-L Hello, I need to run some script using Oracle Sqlplus. The script is only suppose to run certain days of week. Does anyone have a suggestion how to do that. Thank you. -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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
because DUDE! see my earlier explanation! I ask colleagues if I can't find it in the manual...such is the joy of the internet...the pages are bookmarked and are therein front...on my screenwhere I need them! It's not rocket science! -Original Message- Sent: 29 January 2002 03:55 To: Multiple recipients of list ORACLE-L Why do you bother being on this List: The list is here to help fellow DBA'S. Have you never said to one of your collegues , what is the format of this command, or how can I do that, when you simply cant be bothered to look it up in the manual (either your busy or just down right lazy): Sometimes this list is useful for just that. So why dont u lighten up dude. -- 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: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: sqlplus question
u can also create batch file if os is windows e.g. t.sql as set serveroutput on; select * from tab; exit; put this in some batch file eq bb.bat sqlplus fxsam/s@du @t and schedule bb.bat -Original Message- From: Stephane Faroult [SMTP:[EMAIL PROTECTED]] Sent: Monday, January 28, 2002 11:40 PM To: Multiple recipients of list ORACLE-L Subject: Re: sqlplus question And if you are running an unavowable OS, you can probably turn your SQL*Plus script into a jPL/SQL procedure and schedule it using dbms_job. Weaver, Walt wrote: Cron? At? -Original Message- Sent: Monday, January 28, 2002 3:21 PM To: Multiple recipients of list ORACLE-L Hello, I need to run some script using Oracle Sqlplus. The script is only suppose to run certain days of week. Does anyone have a suggestion how to do that. Thank you. -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ghadge,Sameer INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: sqlplus question
Rajesh Dayal wrote: I was also trying to put some script on Oracle scheduler and successful too. But on Oracle 8 I failed. It was successful on Oracle 8i (8 doesn't support execute immediate). Would appreciate, if someone can give equivalent code for Oracle 8. Here is the code for Oracle 8i, create or replace PROCEDURE SWITCH IS 2 BEGIN 3 execute immediate 'alter system switch logfile '; 4 commit ; 5 END; 6 / Thanks in Advance, Rajesh NOTE: It would be executed with any user having sysdba privilege. Look in the doc for the dbms_sql package. Hardly more complicated than 'execute immediate' for DDL (you declare a handler for the cursor, then it's done in two calls, parse and execute). -- Regards, Stephane Faroult Oriole Ltd -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Need some help PLEASE on an ora 3113 in svrmgrl
Bill, I think u have some hung shared memory segments which need to b cleaned up before u can start ur instance. Do the following : At the Unix prompt, type : $ ipcs -mobs Then identify the segment id which has Owner = Oracle and Nattch = 0. Remove that segment using the following command : $ ipcrm -m shared_memory_id Start up the database. Hope this helps. Samir Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 28 January 2002 21:42 To: Multiple recipients of list ORACLE-L Hi All, i am running oracle 8170 on solaris 7, i had a problem shutting down oracle and ended up having to do a shutdown abort. i reboot the server to clean everything up and when i tried to restart the db i get the ora 3113 inside of svrmgrl. There are 2 other db that start up fine. It creates a 20m core file and there are no errors in the alert log, listener log, sqlnet log etc and no trace files. Any help would be greatly appreciated!! i am lost been looking around metalink for hours and can't find anything useful. Thanks, -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). ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Report Builder [32-bit]
I am trying to save a report at runtime in PDF format. I am getting the error REP-1249 : Column '...' has no pl/sql formula. I have Report Builder 3.0.5.8.0 Help. Nilesh P Shah [EMAIL PROTECTED] Phone No : 570 44 91 Ext : 6575 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OFF TOPIC: RE: PL/SQL
Hear hear ! You tell 'm, Kevin ! I'm with you all the way. Anybody can ask me a simple question when they are looking for a quick answer, but you can't do a good job when you're always looking for quick answers. You have to LEARN. There's a difference between learning and constantly asking questions. Sorry, couldn't resist ... -Oorspronkelijk bericht- Van: Thomas, Kevin [mailto:[EMAIL PROTECTED]] Verzonden: dinsdag 29 januari 2002 9:00 Aan: Multiple recipients of list ORACLE-L Onderwerp: OFF TOPIC: RE: PL/SQL When I arrive in the morning to a mailbox containing 150+ messages from this list, I'm almost certainly guaranteed that 10% of them will be questions that can easily be found via otn or a manual. That 10% usually comes from the same person!! No wonder I'm irritated!!! }:o| -Original Message- Sent: 28 January 2002 17:35 To: Multiple recipients of list ORACLE-L Geez... lay off already. If you don't think the question is worthy of your time, then don't answer it. What a grouch. -Original Message- Sent: Monday, January 28, 2002 11:16 AM To: Multiple recipients of list ORACLE-L RRR TTTFF !! -Original Message- Sent: 28 January 2002 15:46 To: Multiple recipients of list ORACLE-L How can I in a pl/sql block write null if I want null to be inserted in a field when I use dynamic sql.? . I mean nothing is going to be inserted. Thanks in advance Roland -- 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: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seefelt, Beth INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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).
Rman again. Long screen output included
Hi , I copied jay's line for duplication until time exactly into my test script but recovering errors out in the end. I looked in the documentation for another example of the until time clause but no luck. Can anybody explain why this won't work. (the double single quotes to which it translates looks fishy to me, but so does the whole RMAN thing at the moment) If I remove the until time clause it works fine. following is the screen output of my RMAN commands ep3[/data/oracle8/BACKUP]$ cat rmanClone.sh export ORACLE_SID=TEST3 sqlplus /nolog EOF connect sys/rman_oracledba as sysdba shutdown abort startup nomount exit EOF rm /data/oracle8/TEST3/* rman EOF connect target rman/rman_oracledba@test2 connect catalog rman/rman_oracledba@test1 connect auxiliary sys/rman_oracledba@test3 run { set until time to_date('29012002094700','ddmmhh24miss'); allocate auxiliary channel d1 type disk; allocate auxiliary channel d2 type disk; duplicate target database to test3; } EOF ep3[/data/oracle8/BACKUP]$ rmanClone.sh SQL*Plus: Release 8.1.7.0.0 - Production on Tue Jan 29 11:03:27 2002 (c) Copyright 2000 Oracle Corporation. All rights reserved. SQL Connected. SQL ORACLE instance shut down. SQL ORACLE instance started. Total System Global Area 74919828 bytes Fixed Size73620 bytes Variable Size 33808384 bytes Database Buffers 4096 bytes Redo Buffers 77824 bytes SQL Disconnected from Oracle8i Enterprise Edition Release 8.1.7.2.0 - Production With the Partitioning option JServer Release 8.1.7.2.0 - Production Recovery Manager: Release 8.1.7.2.0 - Production RMAN RMAN-06005: connected to target database: TEST2 (DBID=536102344) RMAN RMAN-06008: connected to recovery catalog database RMAN RMAN-06020: connected to auxiliary database RMAN 2 3 4 5 6 RMAN-03022: compiling command: set RMAN-03022: compiling command: allocate RMAN-03023: executing command: allocate RMAN-08030: allocated channel: d1 RMAN-08500: channel d1: sid=11 devtype=DISK RMAN-03022: compiling command: allocate RMAN-03023: executing command: allocate RMAN-08030: allocated channel: d2 RMAN-08500: channel d2: sid=12 devtype=DISK RMAN-03022: compiling command: Duplicate Db RMAN-03027: printing stored script: Memory Script { set until scn 95275; set newname for datafile 1 to /data/oracle8/TEST3/systemTEST3.dbf; set newname for datafile 2 to /data/oracle8/TEST3/rbsTEST3.dbf; set newname for datafile 3 to /data/oracle8/TEST3/tempTEST3.dbf; set newname for datafile 4 to /data/oracle8/TEST3/dataTEST3.dbf; restore check readonly clone database ; } RMAN-03021: executing script: Memory Script RMAN-03022: compiling command: set RMAN-03022: compiling command: set RMAN-03022: compiling command: set RMAN-03022: compiling command: set RMAN-03022: compiling command: set RMAN-03022: compiling command: restore RMAN-03022: compiling command: IRESTORE RMAN-03023: executing command: IRESTORE RMAN-08016: channel d1: starting datafile backupset restore RMAN-08502: set_count=42 set_stamp=452362933 creation_time=28-JAN-02 RMAN-08089: channel d1: specifying datafile(s) to restore from backup set RMAN-08523: restoring datafile 2 to /data/oracle8/TEST3/rbsTEST3.dbf RMAN-08523: restoring datafile 4 to /data/oracle8/TEST3/dataTEST3.dbf RMAN-08016: channel d2: starting datafile backupset restore RMAN-08502: set_count=43 set_stamp=452362949 creation_time=28-JAN-02 RMAN-08089: channel d2: specifying datafile(s) to restore from backup set RMAN-08523: restoring datafile 3 to /data/oracle8/TEST3/tempTEST3.dbf RMAN-08023: channel d2: restored backup piece 1 RMAN-08511: piece handle=/data/oracle8/BACKUP/rman_LVL0_TEST2.452362949.1.1.bus tag=null params=NULL RMAN-08024: channel d2: restore complete RMAN-08016: channel d2: starting datafile backupset restore RMAN-08502: set_count=44 set_stamp=452362964 creation_time=28-JAN-02 RMAN-08089: channel d2: specifying datafile(s) to restore from backup set RMAN-08523: restoring datafile 1 to /data/oracle8/TEST3/systemTEST3.dbf RMAN-08023: channel d1: restored backup piece 1 RMAN-08511: piece handle=/data/oracle8/BACKUP/rman_LVL0_TEST2.452362933.1.1.bus tag=null params=NULL RMAN-08024: channel d1: restore complete RMAN-08023: channel d2: restored backup piece 1 RMAN-08511: piece handle=/data/oracle8/BACKUP/rman_LVL0_TEST2.452362964.1.1.bus tag=null params=NULL RMAN-08024: channel d2: restore complete RMAN-06162: sql statement: CREATE CONTROLFILE REUSE SET DATABASE test3 RESETLOGS ARCHIVELOG MAXLOGFILES 32 MAXLOGMEMBERS 2 MAXDATAFILES 30 MAXINSTANCES 8 MAXLOGHISTORY 907 LOGFILE GROUP 1 ( '/data/oracle8/TEST3/redoTEST301.log' ) SIZE 512000 REUSE, GROUP 2 ( '/data/oracle8/TEST3/redoTEST302.log' ) SIZE 512000 REUSE, GROUP 3 ( '/data/oracle8/TEST3/redoTEST303.log' ) SIZE
Re: AW: auditing tables
triggers -- that do an insert into an auditing table. Been there, done that: Insert -- add a row to the auditing table of all the new values with one extra column type =I Delete add a row to the auditing table with all the old values and type=D Update -- add two rows to the auditing table -- first with old values and type = O second with all the new values and type =N --- Foelz.Frank [EMAIL PROTECTED] wrote: TNX for your answers. What I need is exactly what Oracle doesn't support. Logging who changed what in a special area of our database. I think triggering the events will be much more specific and more easy to change. In case all our applications use the same database and user, I am trying to check out what application is changing monitored tables (i.e. c:\app\userapp\app.exe is changing table1). What do you think of that ?? greets Frank Von: Rachel Carmichael [mailto:[EMAIL PROTECTED]] what sort of information are you looking to audit? if you want any sort of detail, you are better off with triggers and possibly an audit table. Oracle doesn't record WHAT has been changed, just that the table was accessed. So you don't know the row etc... --- Foelz.Frank [EMAIL PROTECTED] wrote: Hi all, does anyone have experience in using Oracle's possibilities of auditing a database ?? I am interested in performance questions i.e. is it a hughe loss of performance when auditing tables Inserts/Updates/Deletes. Should I use triggers instead ? any hints (comments, websites, etc...) are welcome. Frank -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Foelz.Frank INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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!? Great stuff seeking new owners in Yahoo! Auctions! http://auctions.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: sqlplus question
Thanks Stephan, Your suggestion had motivated me and I wrote the code, after RTFM. Sameer, I didn't scheduled the job on OS because this should an Oracle Job, log switching has nothing to do with OS (you don't trouble a company GM when the work should be done by a Normal Manager right??). And you need to handle the error conditions of OS when your DB is down, which is eliminated in this case. Any-way thanks to all, Rajesh And-yes, the code is like this: create or replace PROCEDURE SWITCH1 IS c number; d number; begin c := dbms_sql.open_cursor; dbms_sql.parse(c, 'alter system switch logfile', 1); d := dbms_sql.execute(c); dbms_sql.close_cursor(c); commit ; END; -Original Message- Faroult Sent: Tuesday, January 29, 2002 1:36 PM To: Multiple recipients of list ORACLE-L Rajesh Dayal wrote: I was also trying to put some script on Oracle scheduler and successful too. But on Oracle 8 I failed. It was successful on Oracle 8i (8 doesn't support execute immediate). Would appreciate, if someone can give equivalent code for Oracle 8. Here is the code for Oracle 8i, create or replace PROCEDURE SWITCH IS 2 BEGIN 3 execute immediate 'alter system switch logfile '; 4 commit ; 5 END; 6 / Thanks in Advance, Rajesh NOTE: It would be executed with any user having sysdba privilege. Look in the doc for the dbms_sql package. Hardly more complicated than 'execute immediate' for DDL (you declare a handler for the cursor, then it's done in two calls, parse and execute). -- Regards, Stephane Faroult Oriole Ltd -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: bug in cursor FOR loops?
I have seen something like this with application loop that open a new cursor for each iteration of the loop. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: Paul Baumgartel [SMTP:[EMAIL PROTECTED]] Sent: Mon, January 28, 2002 11:15 PM To: Multiple recipients of list ORACLE-L Subject: bug in cursor FOR loops? Is there a bug (8.1.7.2.0 on HP-UX) in the implementation of cursor FOR loops, such that the cursor is not closed upon loop exit? If a function containing such a loop is called many times, eventually the session returns a too many open cursors error; an attempt to close the cursor manually after the loop returns invalid cursor. I've searched MetaLink (including bug database) and haven't found anything. TIA, Paul Baumgartel __ Do You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! http://auctions.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- This e-mail was scanned by the eSafe Mail Gateway -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OT : howto RTFM
http://www.microsoft.com[EMAIL PROTECTED]/nyheter/feb01/Q209354%20-% 20HOWTO.htm have fun, Marin ...what you brought from your past, is of no use in your present. When you must choose a new path, do not bring old experiences with you. Those who strike out afresh, but who attempt to retain a little of the old life, end up torn apart by their own memories. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Marin Dimitrov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Public Privileges on system tables?
Hello Ron I checked our 7.3.4 DB (on NT) and did not find these tables. I think that they may belong to a product that use these tables and so everyone who uses this product need them. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: Smith, Ron L. [SMTP:[EMAIL PROTECTED]] Sent: Mon, January 28, 2002 6:56 PM To: Multiple recipients of list ORACLE-L Subject: Public Privileges on system tables? I have two tables, sys.pstubtbl and sys.user_privs that have grants to public for insert, update, and delete. Our auditors are wondering why. I don't really want to remove the privs without knowing why. This is an old 7.3.4 instance. Any ideas? Ron Smith -- 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). -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- This e-mail was scanned by the eSafe Mail Gateway -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Class does not exist error
Hi DBAs, Oracle 8.1.6, NT server, JServer 8.1.6, Win 200 client A list member sent me a pl/sql script for sending mail. It compiles ok when I run it I get the following error class oracle/plsql/net/TCPConnection does not exist Any ideas on how to correct this? I do not know if I have to do something on client side or server side Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Rman again. Long screen output included
Hello Jack The RMAN commandrecover database; is changed to be recover database until time '1999-03-05:11:33:00'; Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Tue, January 29, 2002 12:15 PM To: Multiple recipients of list ORACLE-L Subject: Rman again. Long screen output included Hi , I copied jay's line for duplication until time exactly into my test script but recovering errors out in the end. I looked in the documentation for another example of the until time clause but no luck. Can anybody explain why this won't work. (the double single quotes to which it translates looks fishy to me, but so does the whole RMAN thing at the moment) If I remove the until time clause it works fine. following is the screen output of my RMAN commands ** ** ep3[/data/oracle8/BACKUP]$ cat rmanClone.sh export ORACLE_SID=TEST3 sqlplus /nolog EOF connect sys/rman_oracledba as sysdba shutdown abort startup nomount exit EOF rm /data/oracle8/TEST3/* rman EOF connect target rman/rman_oracledba@test2 connect catalog rman/rman_oracledba@test1 connect auxiliary sys/rman_oracledba@test3 run { set until time to_date('29012002094700','ddmmhh24miss'); allocate auxiliary channel d1 type disk; allocate auxiliary channel d2 type disk; duplicate target database to test3; } EOF ep3[/data/oracle8/BACKUP]$ rmanClone.sh SQL*Plus: Release 8.1.7.0.0 - Production on Tue Jan 29 11:03:27 2002 (c) Copyright 2000 Oracle Corporation. All rights reserved. SQL Connected. SQL ORACLE instance shut down. SQL ORACLE instance started. Total System Global Area 74919828 bytes Fixed Size73620 bytes Variable Size 33808384 bytes Database Buffers 4096 bytes Redo Buffers 77824 bytes SQL Disconnected from Oracle8i Enterprise Edition Release 8.1.7.2.0 - Production With the Partitioning option JServer Release 8.1.7.2.0 - Production Recovery Manager: Release 8.1.7.2.0 - Production RMAN RMAN-06005: connected to target database: TEST2 (DBID=536102344) RMAN RMAN-06008: connected to recovery catalog database RMAN RMAN-06020: connected to auxiliary database RMAN 2 3 4 5 6 RMAN-03022: compiling command: set RMAN-03022: compiling command: allocate RMAN-03023: executing command: allocate RMAN-08030: allocated channel: d1 RMAN-08500: channel d1: sid=11 devtype=DISK RMAN-03022: compiling command: allocate RMAN-03023: executing command: allocate RMAN-08030: allocated channel: d2 RMAN-08500: channel d2: sid=12 devtype=DISK RMAN-03022: compiling command: Duplicate Db RMAN-03027: printing stored script: Memory Script { set until scn 95275; set newname for datafile 1 to /data/oracle8/TEST3/systemTEST3.dbf; set newname for datafile 2 to /data/oracle8/TEST3/rbsTEST3.dbf; set newname for datafile 3 to /data/oracle8/TEST3/tempTEST3.dbf; set newname for datafile 4 to /data/oracle8/TEST3/dataTEST3.dbf; restore check readonly clone database ; } RMAN-03021: executing script: Memory Script RMAN-03022: compiling command: set RMAN-03022: compiling command: set RMAN-03022: compiling command: set RMAN-03022: compiling command: set RMAN-03022: compiling command: set RMAN-03022: compiling command: restore RMAN-03022: compiling command: IRESTORE RMAN-03023: executing command: IRESTORE RMAN-08016: channel d1: starting datafile backupset restore RMAN-08502: set_count=42 set_stamp=452362933 creation_time=28-JAN-02 RMAN-08089: channel d1: specifying datafile(s) to restore from backup set RMAN-08523: restoring datafile 2 to /data/oracle8/TEST3/rbsTEST3.dbf RMAN-08523: restoring datafile 4 to /data/oracle8/TEST3/dataTEST3.dbf RMAN-08016: channel d2: starting datafile backupset restore RMAN-08502: set_count=43 set_stamp=452362949 creation_time=28-JAN-02 RMAN-08089: channel d2: specifying datafile(s) to restore from backup set RMAN-08523: restoring datafile 3 to /data/oracle8/TEST3/tempTEST3.dbf RMAN-08023: channel d2: restored backup piece 1 RMAN-08511: piece handle=/data/oracle8/BACKUP/rman_LVL0_TEST2.452362949.1.1.bus tag=null params=NULL RMAN-08024: channel d2: restore complete RMAN-08016: channel d2: starting datafile backupset restore RMAN-08502: set_count=44 set_stamp=452362964 creation_time=28-JAN-02 RMAN-08089: channel d2: specifying datafile(s) to restore from backup set RMAN-08523: restoring datafile 1 to /data/oracle8/TEST3/systemTEST3..dbf RMAN-08023: channel d1: restored backup piece 1 RMAN-08511: piece handle=/data/oracle8/BACKUP/rman_LVL0_TEST2.452362933.1.1.bus tag=null params=NULL RMAN-08024: channel d1: restore complete RMAN-08023: channel d2: restored backup piece 1 RMAN-08511: piece
INFORMIX 7.3 to ORACLE 8.1.7
Hi! We inherited one Informix database, which we must put into our production Oracle database (new schema). Both databases are on AIX UNIX machines. We can do this by writing a scripts, but I'm wondering does any of you have some experiance in this, and could you suggest me some other (simpler) way? Perhaps some Conversion tools? TIA, Sonja -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?ISO-8859-2?Q?Sonja_=A9ehovi=E6?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Class does not exist error
[EMAIL PROTECTED] wrote: Hi DBAs, Oracle 8.1.6, NT server, JServer 8.1.6, Win 200 client A list member sent me a pl/sql script for sending mail. It compiles ok when I run it I get the following error class oracle/plsql/net/TCPConnection does not exist Any ideas on how to correct this? I do not know if I have to do something on client side or server side Thanks Rick Where do you think the stored procedure is executed? Your runtime message comes from a dynamically loaded routine. If you find TCPConnection.class it may be CLASSPATH or similar which is improperly set on your server. -- Regards, Stephane Faroult Oriole Ltd -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT : howto RTFM
Cant' believe that !!! -Original Message- Sent: Tuesday, January 29, 2002 4:35 PM To: Multiple recipients of list ORACLE-L http://www.microsoft.com[EMAIL PROTECTED]/nyheter/feb01/Q209354%20-% 20HOWTO.htm have fun, Marin ...what you brought from your past, is of no use in your present. When you must choose a new path, do not bring old experiences with you. Those who strike out afresh, but who attempt to retain a little of the old life, end up torn apart by their own memories. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Marin Dimitrov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Rman again. Long screen output included
Hi Thomas, AFAIK this is generated code (by RMAN) based on the command duplicate that I issued. I sure didn't store any script yet. This is the next step when all secrets of RMAN are uncovered (than it's time to move to RMAN 9i) Jack Mercadante, Thomas F [EMAIL PROTECTED] on 29-01-2002 14:19:30 To: '[EMAIL PROTECTED]' [EMAIL PROTECTED] cc: But where is it getting the other commands shown in the output? Like the set newfile for datafile 1 to command? Are you running scripts stored within the Rman catalog? The message 'RMAN-03027-' states that this is a stored script. Maybe a stored script is wrong? Just a thought. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, January 29, 2002 8:13 AM To: Mercadante, Thomas F Hi, In my test script (all I'm doing is trying to find out the do's don'ts of RMAN for the moment but examples are difficult to find and error messages frequent) I put double quotes, but later (towards the end of the screen output it shows the line with double single quotes around the format mask and date string (must be what it translates into internally) and that is the only thing weird to me Jack Mercadante, Thomas F [EMAIL PROTECTED] on 29-01-2002 13:58:37 To: '[EMAIL PROTECTED]' [EMAIL PROTECTED] cc: '[EMAIL PROTECTED]' [EMAIL PROTECTED] Jack, I don't think Rman wants double single quotes, but double quotes around the whole to_date clause. At least that's what I use when performing recovery. Did I mis-read what you said? Hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, January 29, 2002 5:15 AM To: Multiple recipients of list ORACLE-L Hi , I copied jay's line for duplication until time exactly into my test script but recovering errors out in the end. I looked in the documentation for another example of the until time clause but no luck. Can anybody explain why this won't work. (the double single quotes to which it translates looks fishy to me, but so does the whole RMAN thing at the moment) If I remove the until time clause it works fine. following is the screen output of my RMAN commands ep3[/data/oracle8/BACKUP]$ cat rmanClone.sh export ORACLE_SID=TEST3 sqlplus /nolog EOF connect sys/rman_oracledba as sysdba shutdown abort startup nomount exit EOF rm /data/oracle8/TEST3/* rman EOF connect target rman/rman_oracledba@test2 connect catalog rman/rman_oracledba@test1 connect auxiliary sys/rman_oracledba@test3 run { set until time to_date('29012002094700','ddmmhh24miss'); allocate auxiliary channel d1 type disk; allocate auxiliary channel d2 type disk; duplicate target database to test3; } EOF ep3[/data/oracle8/BACKUP]$ rmanClone.sh SQL*Plus: Release 8.1.7.0.0 - Production on Tue Jan 29 11:03:27 2002 (c) Copyright 2000 Oracle Corporation. All rights reserved. SQL Connected. SQL ORACLE instance shut down. SQL ORACLE instance started. Total System Global Area 74919828 bytes Fixed Size73620 bytes Variable Size 33808384 bytes Database Buffers 4096 bytes Redo Buffers 77824 bytes SQL Disconnected from Oracle8i Enterprise Edition Release 8.1.7.2.0 - Production With the Partitioning option JServer Release 8.1.7.2.0 - Production Recovery Manager: Release 8.1.7.2.0 - Production RMAN RMAN-06005: connected to target database: TEST2 (DBID=536102344) RMAN RMAN-06008: connected to recovery catalog database RMAN RMAN-06020: connected to auxiliary database RMAN 2 3 4 5 6 RMAN-03022: compiling command: set RMAN-03022: compiling command: allocate RMAN-03023: executing command: allocate RMAN-08030: allocated channel: d1 RMAN-08500: channel d1: sid=11 devtype=DISK RMAN-03022: compiling command: allocate RMAN-03023: executing command: allocate RMAN-08030: allocated channel: d2 RMAN-08500: channel d2: sid=12 devtype=DISK RMAN-03022: compiling command: Duplicate Db RMAN-03027: printing stored script: Memory Script { set until scn 95275; set newname for datafile 1 to /data/oracle8/TEST3/systemTEST3.dbf; set newname for datafile 2 to /data/oracle8/TEST3/rbsTEST3.dbf; set newname for datafile 3 to /data/oracle8/TEST3/tempTEST3.dbf; set newname for datafile 4 to /data/oracle8/TEST3/dataTEST3.dbf; restore check readonly clone database ; } RMAN-03021: executing script: Memory Script RMAN-03022: compiling command: set RMAN-03022: compiling command: set RMAN-03022: compiling command: set RMAN-03022: compiling command: set RMAN-03022: compiling command: set RMAN-03022: compiling command: restore RMAN-03022: compiling command: IRESTORE RMAN-03023: executing command: IRESTORE RMAN-08016: channel d1: starting datafile backupset restore RMAN-08502: set_count=42 set_stamp=452362933 creation_time=28-JAN-02 RMAN-08089: channel d1: specifying datafile(s) to restore
RE: OFF TOPIC: RE: PL/SQL
Roland, Besides reading the manuals, take a look at www.lazydba.com. They also host an Oracle email list that might be a more appropriate forum for your questions. I think they have a higher ratio of new DBAs on their list, and seldom mind answering the beginner questions. HTH, Beth (was that so hard guys?) -Original Message- Sent: Tuesday, January 29, 2002 5:21 AM To: Multiple recipients of list ORACLE-L Hear hear ! You tell 'm, Kevin ! I'm with you all the way. Anybody can ask me a simple question when they are looking for a quick answer, but you can't do a good job when you're always looking for quick answers. You have to LEARN. There's a difference between learning and constantly asking questions. Sorry, couldn't resist ... -Oorspronkelijk bericht- Van: Thomas, Kevin [mailto:[EMAIL PROTECTED]] Verzonden: dinsdag 29 januari 2002 9:00 Aan: Multiple recipients of list ORACLE-L Onderwerp: OFF TOPIC: RE: PL/SQL When I arrive in the morning to a mailbox containing 150+ messages from this list, I'm almost certainly guaranteed that 10% of them will be questions that can easily be found via otn or a manual. That 10% usually comes from the same person!! No wonder I'm irritated!!! }:o| -Original Message- Sent: 28 January 2002 17:35 To: Multiple recipients of list ORACLE-L Geez... lay off already. If you don't think the question is worthy of your time, then don't answer it. What a grouch. -Original Message- Sent: Monday, January 28, 2002 11:16 AM To: Multiple recipients of list ORACLE-L RRR TTTFF !! -Original Message- Sent: 28 January 2002 15:46 To: Multiple recipients of list ORACLE-L How can I in a pl/sql block write null if I want null to be inserted in a field when I use dynamic sql.? . I mean nothing is going to be inserted. Thanks in advance Roland -- 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: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seefelt, Beth INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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
Re: INFORMIX 7.3 to ORACLE 8.1.7
Sonja, Start here: http://otn.oracle.com/tech/migration/workbench/content.html ...JIM... [EMAIL PROTECTED] 1/29/02 7:20:33 AM Hi! We inherited one Informix database, which we must put into our production Oracle database (new schema). Both databases are on AIX UNIX machines. We can do this by writing a scripts, but I'm wondering does any of you have some experiance in this, and could you suggest me some other (simpler) way? Perhaps some Conversion tools? TIA, Sonja -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?ISO-8859-2?Q?Sonja_=A9ehovi=E6?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: James Howerton INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: sqlplus question
'dbms_output.put_job '? What the heck was this about? Please, check your answers before posting to the list! Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, January 29, 2002 12:50 AM Well, you can check the manual but use the package dbms_output.put_job that willfix it when you are inoracle but ifyoua re in unix environment you must use crontab Hope this is of help for you Roland Weaver, Walt [EMAIL PROTECTED]@fatcity.com den 2002-01-28 14:45 PST Sänd svar till [EMAIL PROTECTED] Sänt av: [EMAIL PROTECTED] Till: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Kopia: Cron? At? -Original Message- Sent: Monday, January 28, 2002 3:21 PM To: Multiple recipients of list ORACLE-L Hello, I need to run some script using Oracle Sqlplus. The script is only suppose to run certain days of week. Does anyone have a suggestion how to do that. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Weaver, Walt INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT : howto RTFM
And you shouldn't... This is just a web trick - I mean it's not a Microsoft's site. You can see the same page, loaded even faster, if you remove: www.microsoft.comitem=q209354@ from the url. Just try: http://hardware.no/nyheter/feb01/Q209354%20-%20HOWTO.htm You can replace in the url www.microsoft.com with whatever company you want and get redirected to the same page, try www.oracle.com ... It will take you to the same page... http://hardware.no is website of a company in Norway and they have this page. Getting the graphics, style, etc and make a page look like Microsoft's is a piece of cake. While it may be funny I guess it's a poor joke to make pages and present as someone else's... Witold On 29 Jan 2002 at 5:30, Rajesh Dayal wrote: Cant' believe that !!! -Original Message- Sent: Tuesday, January 29, 2002 4:35 PM To: Multiple recipients of list ORACLE-L http://www.microsoft.com[EMAIL PROTECTED]/nyheter/feb01/Q209354%20-% 20HOWTO.htm have fun, Marin ...what you brought from your past, is of no use in your present. When you must choose a new path, do not bring old experiences with you. Those who strike out afresh, but who attempt to retain a little of the old life, end up torn apart by their own memories. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Marin Dimitrov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). == Witold Iwaniec Sr Software Developer NovaLIS Technologies [EMAIL PROTECTED] http://www.novalistech.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Witold Iwaniec INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Class does not exist error
[EMAIL PROTECTED] wrote: [EMAIL PROTECTED] wrote: Hi DBAs, Oracle 8.1.6, NT server, JServer 8.1.6, Win 200 client A list member sent me a pl/sql script for sending mail. It compiles ok when I run it I get the following error class oracle/plsql/net/TCPConnection does not exist Any ideas on how to correct this? I do not know if I have to do something on client side or server side Thanks Rick Where do you think the stored procedure is executed? Your runtime message comes from a dynamically loaded routine. If you find TCPConnection.class it may be CLASSPATH or similar which is improperly set on your server. or it could not be installed on the database JVM. -- -- Bill Shrek Thater ORACLE DBA [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. A list is only as strong as its weakest link. - Don Knuth -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: bill thater INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: INFORMIX 7.3 to ORACLE 8.1.7
Hi Sonja, I would recommend you look at the oracle migration workbench product. John [EMAIL PROTECTED] wrote: Hi! We inherited one Informix database, which we must put into our production Oracle database (new schema). Both databases are on AIX UNIX machines. We can do this by writing a scripts, but I'm wondering does any of you have some experiance in this, and could you suggest me some other (simpler) way? Perhaps some Conversion tools? TIA, Sonja -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: orantdba INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Class does not exist error
Hi, Rick I'm not 100% sure, but it I think, the problem is Server/JServer version. The script will be OK on 8.1.7. 8.1.7 JVM is very different from 8.1.6 HTH Vadim -Original Message- Sent: Tuesday, January 29, 2002 8:15 AM To: Multiple recipients of list ORACLE-L Hi DBAs, Oracle 8.1.6, NT server, JServer 8.1.6, Win 200 client A list member sent me a pl/sql script for sending mail. It compiles ok when I run it I get the following error class oracle/plsql/net/TCPConnection does not exist Any ideas on how to correct this? I do not know if I have to do something on client side or server side Thanks Rick -- 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: Vadim Gorbounov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: sqlplus question
I'm lost here... --Walt -Original Message- Sent: Monday, January 28, 2002 10:50 PM To: Multiple recipients of list ORACLE-L Well, you can check the manual but use the package dbms_output.put_job that willfix it when you are inoracle but ifyoua re in unix environment you must use crontab Hope this is of help for you Roland Weaver, Walt [EMAIL PROTECTED]@fatcity.com den 2002-01-28 14:45 PST Sänd svar till [EMAIL PROTECTED] Sänt av: [EMAIL PROTECTED] Till: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Kopia: Cron? At? -Original Message- Sent: Monday, January 28, 2002 3:21 PM To: Multiple recipients of list ORACLE-L Hello, I need to run some script using Oracle Sqlplus. The script is only suppose to run certain days of week. Does anyone have a suggestion how to do that. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Weaver, Walt INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Weaver, Walt INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OFF TOPIC: RE: PL/SQL
Kevin, I am sorry, but you didn't sound holier than thou on that last post. Could you do it a bit differently next time? ;-) WWJD? JWRTFM! -Original Message- Sent: Tuesday, January 29, 2002 9:10 AM To: Multiple recipients of list ORACLE-L Hey I've helped this guy heaps of times...taken the time out to explain what I'm sending back to him and drop subtle hints about the references I use to get those answers if I don't know myselfwhy should he be any different??? -Original Message- Sent: 29 January 2002 13:45 To: Multiple recipients of list ORACLE-L Roland, Besides reading the manuals, take a look at www.lazydba.com. They also host an Oracle email list that might be a more appropriate forum for your questions. I think they have a higher ratio of new DBAs on their list, and seldom mind answering the beginner questions. HTH, Beth (was that so hard guys?) -Original Message- Sent: Tuesday, January 29, 2002 5:21 AM To: Multiple recipients of list ORACLE-L Hear hear ! You tell 'm, Kevin ! I'm with you all the way. Anybody can ask me a simple question when they are looking for a quick answer, but you can't do a good job when you're always looking for quick answers. You have to LEARN. There's a difference between learning and constantly asking questions. Sorry, couldn't resist ... -Oorspronkelijk bericht- Van: Thomas, Kevin [mailto:[EMAIL PROTECTED]] Verzonden: dinsdag 29 januari 2002 9:00 Aan: Multiple recipients of list ORACLE-L Onderwerp: OFF TOPIC: RE: PL/SQL When I arrive in the morning to a mailbox containing 150+ messages from this list, I'm almost certainly guaranteed that 10% of them will be questions that can easily be found via otn or a manual. That 10% usually comes from the same person!! No wonder I'm irritated!!! }:o| -Original Message- Sent: 28 January 2002 17:35 To: Multiple recipients of list ORACLE-L Geez... lay off already. If you don't think the question is worthy of your time, then don't answer it. What a grouch. -Original Message- Sent: Monday, January 28, 2002 11:16 AM To: Multiple recipients of list ORACLE-L RRR TTTFF !! -Original Message- Sent: 28 January 2002 15:46 To: Multiple recipients of list ORACLE-L How can I in a pl/sql block write null if I want null to be inserted in a field when I use dynamic sql.? . I mean nothing is going to be inserted. Thanks in advance Roland -- 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: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seefelt, Beth INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be
RE: INFORMIX 7.3 to ORACLE 8.1.7
There is a tool from DataBee that is used to copy integrated data from production to test (among other things). Maybe you can use it to copy ALL the data from one DB to the other. http://www.databee.com Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Tue, January 29, 2002 3:21 PM To: Multiple recipients of list ORACLE-L Subject: INFORMIX 7.3 to ORACLE 8.1.7 Hi! We inherited one Informix database, which we must put into our production Oracle database (new schema). Both databases are on AIX UNIX machines. We can do this by writing a scripts, but I'm wondering does any of you have some experiance in this, and could you suggest me some other (simpler) way? Perhaps some Conversion tools? TIA, Sonja -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?ISO-8859-2?Q?Sonja_=A9ehovi=E6?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- This e-mail was scanned by the eSafe Mail Gateway -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: OFF TOPIC: RE: PL/SQL
beginner should start with RTFM, trying it on test box, and only than, if he still does not get it, post his question explaining his problems. Beth, you must not have seen Roland's questions. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, January 29, 2002 8:45 AM Roland, Besides reading the manuals, take a look at www.lazydba.com. They also host an Oracle email list that might be a more appropriate forum for your questions. I think they have a higher ratio of new DBAs on their list, and seldom mind answering the beginner questions. HTH, Beth (was that so hard guys?) -Original Message- Sent: Tuesday, January 29, 2002 5:21 AM To: Multiple recipients of list ORACLE-L Hear hear ! You tell 'm, Kevin ! I'm with you all the way. Anybody can ask me a simple question when they are looking for a quick answer, but you can't do a good job when you're always looking for quick answers. You have to LEARN. There's a difference between learning and constantly asking questions. Sorry, couldn't resist ... -Oorspronkelijk bericht- Van: Thomas, Kevin [mailto:[EMAIL PROTECTED]] Verzonden: dinsdag 29 januari 2002 9:00 Aan: Multiple recipients of list ORACLE-L Onderwerp: OFF TOPIC: RE: PL/SQL When I arrive in the morning to a mailbox containing 150+ messages from this list, I'm almost certainly guaranteed that 10% of them will be questions that can easily be found via otn or a manual. That 10% usually comes from the same person!! No wonder I'm irritated!!! }:o| -Original Message- Sent: 28 January 2002 17:35 To: Multiple recipients of list ORACLE-L Geez... lay off already. If you don't think the question is worthy of your time, then don't answer it. What a grouch. -Original Message- Sent: Monday, January 28, 2002 11:16 AM To: Multiple recipients of list ORACLE-L RRR TTTFF !! -Original Message- Sent: 28 January 2002 15:46 To: Multiple recipients of list ORACLE-L How can I in a pl/sql block write null if I want null to be inserted in a field when I use dynamic sql.? . I mean nothing is going to be inserted. Thanks in advance Roland -- 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: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seefelt, Beth INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Daemen, Remco INET: [EMAIL PROTECTED] Fat City Network
Database Performance Question
Hello all: We have an application that is having slow response time against an 8i database, I would like to improve the response time. This is a web based application accessing the database with about 2000 users. Most of the application queries are based on complex joins on 4 big tables with each having over 5 million rows( biggest table has 18 million rows). I have tuned the Package queries for the best explain plan possible, but still do not seem to make dramatic change in the response time. Though, I was able to make significant headway tuning these packages by bringing down response times from 7 minutes to under 3 minutes. But this is not an acceptable response time from a web-application perspective. I am considering creating data cubes based on the most frequently used join conditions and pre-populate them on a nightly basis or use triggers to update the cube simultaneously. I am hoping that this enhance the response times. I would greatly appreciate your suggestions or opinions on this idea. If you have an alternative/better way of achiving this please enlighten me. Thank very much. Srini Rajendran. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: AW: auditing tables
On Tuesday 29 January 2002 03:00, Rachel Carmichael wrote: Update -- add two rows to the auditing table -- first with old values and type = O second with all the new values and type =N Rachel, I don't think you need two rows for updates. The old values will be in the audit table, the new ones are in the production table. At least that's the way I've always done it. Is there some other reason for saving both in the audit table? Jared --- Foelz.Frank [EMAIL PROTECTED] wrote: TNX for your answers. What I need is exactly what Oracle doesn't support. Logging who changed what in a special area of our database. I think triggering the events will be much more specific and more easy to change. In case all our applications use the same database and user, I am trying to check out what application is changing monitored tables (i.e. c:\app\userapp\app.exe is changing table1). What do you think of that ?? greets Frank Von: Rachel Carmichael [mailto:[EMAIL PROTECTED]] what sort of information are you looking to audit? if you want any sort of detail, you are better off with triggers and possibly an audit table. Oracle doesn't record WHAT has been changed, just that the table was accessed. So you don't know the row etc... --- Foelz.Frank [EMAIL PROTECTED] wrote: Hi all, does anyone have experience in using Oracle's possibilities of auditing a database ?? I am interested in performance questions i.e. is it a hughe loss of performance when auditing tables Inserts/Updates/Deletes. Should I use triggers instead ? any hints (comments, websites, etc...) are welcome. Frank -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Foelz.Frank INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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!? Great stuff seeking new owners in Yahoo! Auctions! http://auctions.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT : howto RTFM
Nah it is a URL trick you need to discard everything between HTTP:// and first @ sign. The browser does it too. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- Sent: Tuesday, January 29, 2002 9:20 AM To: Multiple recipients of list ORACLE-L Looks like good old MicroSlop got hacked, again!! Dick Goulet PS: I love it!! *2 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *2
RE: OFF TOPIC: RE: PL/SQL
Voting him off the island... uh? ;-) -Original Message- Sent: Tuesday, January 29, 2002 7:45 AM To: Multiple recipients of list ORACLE-L Roland, Besides reading the manuals, take a look at www.lazydba.com. They also host an Oracle email list that might be a more appropriate forum for your questions. I think they have a higher ratio of new DBAs on their list, and seldom mind answering the beginner questions. HTH, Beth (was that so hard guys?) -- 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).
RE: Mail from PL/SQL without Java
One of the neat tricks how to that is described in Tom Kyte's book in the chapter about UTL_HTTP. -Original Message- Sent: Monday, January 28, 2002 6:55 PM To: Multiple recipients of list ORACLE-L Some of you may find this of interest: http://www.total-knowledge.com/progs/ora_mail/ -- 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: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: sqlplus question
Walt, don't worry. He's speaking WaReZ speak. You have to follow the White Rabbit to get out. For further instructions, see Kimberly. She enjoys questions like these. -Original Message- I'm lost here... --Walt -Original Message- Sent: Monday, January 28, 2002 10:50 PM To: Multiple recipients of list ORACLE-L Well, you can check the manual but use the package dbms_output.put_job that willfix it when you are inoracle but ifyoua re in unix environment you must use crontab Hope this is of help for you Roland -- 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).
Re: AW: Oracle Books
Tom Kyte's Expert One-on-One Oracle or whatever it's called is the best book written ever on Oracle. Reviewed by Jonathan Lewis and Steve Adams. Jonathan says it's the best book on the market, including his own. Very useful for developer types, too. As to specific Forms/Reports books I have no idea. I'm not a developer, I'm a destroyer. Mogens Foelz.Frank wrote: Hi,I would suggest you should take a look at Osborne Oracle Press !!! They are very good !!www.osborne.comi.e. ISBN.: 0-07-212048-7 Oracle Developer Advanced Forms Reportsvery powerful knowledge !! Frank Von: Gagandeep Singh [mailto:[EMAIL PROTECTED]]Greetings All !!!Could anyone tell me which book is best for the oracle developer which is compatible with Oracle 8i.Regards,Gagandeep
Default role all
Hello, Env: 8.1.6 on Solaris 2.7 Does anyone know which data dictionary table stores the setting when you issue an ALTER USER user_name DEFAULT ROLE ALL COMMAND? I know that dba_role_privs has a default_role (YES/NO) field, but that is specific to each role. Is there another table that stores a system-wide default role setting per user? The reason I ask, without getting too complicated, is that we used to assign new roles to users without specifying anything to do with default roles, and the newly-assigned role automatically became a default role. Recently, this has changed due to using both toad and sqlplus to administer roles, and I am wondering if there is another table where the system-wide default setting for roles is stored. If not, is there any way to assign new roles as default roles without having to specify alter user user_name default role all every time a new role is granted (or worse, an explicit list of roles)? Thanks to any responders. Bill Becker -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Becker INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: RTFM questions (formally RE: PL/SQL)
Title: RTFM questions (formally RE: PL/SQL) No offense to anybody, butI think this is rather arrogant. The list is for anybody (unless the list owner decides it's just for experienced dba's). I am brand new to Oracle, having just started learning it this week. I can easily foresee having what some might consider stupid orRTFM questions, and being possibly unable to find the answer or having problems deciphering the manual. I myself am somewhat of a Word pro (and my vba code samples page is the #1 ranked site of its kind on most major search engines) and I help all kinds of newbies out on a Word list of which I am a member, as do all the other members of the list. Everybody on that list is extremely gracious and nobody complains -- and the people with questions get the help they need, with nobody sitting back going "boy are you stupid / lazy". I am hoping that I can get the same kind of help here, when I am ready for it, that I and others give on other lists. --JoJo -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Craig MundaySent: Monday, January 28, 2002 10:20 PMTo: Multiple recipients of list ORACLE-LSubject: RTFM questions (formally RE: PL/SQL) The problem is that if you always ask the group for help, you never learn where the information is within the manuals or other reference documentation and the group also gets cluttered with trivia. I agree with you that the list is here to help people and I personally do not mind the odd naive question from a new DBA, but it is the "...can't be bothered to look up the manual.." attitude that is most frustrating. When you ask the format of a command (for example) to the list, you are potentionally asking 1000's of people the same question who will all have to spend the time to filter these questions - we are all busy people and I personally do not want to use my time in this way. I'm sure you can see that this is a much more expensive option than asking the person next to you. Cheers, Craig. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 29 January 2002 2:55 PM To: Multiple recipients of list ORACLE-L Subject: RE: PL/SQL Why do you bother being on this List: The list is here to help fellow DBA'S. Have you never said to one of your collegues , what is the format of this command, or how can I do that, when you simply cant be bothered to look it up in the manual (either your busy or just down right lazy): Sometimes this list is useful for just that. So why dont u lighten up dude. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT : howto RTFM
Ross Mohan tried to pull this one on us before. C'mon Ross 'fess up. Is this your handywork? -Original Message- Sent: Tuesday, January 29, 2002 9:20 AM To: Multiple recipients of list ORACLE-L Looks like good old MicroSlop got hacked, again!! Dick Goulet PS: I love it!! Reply Separator Author: Marin Dimitrov [EMAIL PROTECTED] Date: 1/29/2002 4:35 AM http://www.microsoft.com[EMAIL PROTECTED]/nyheter/feb01/Q209354%20-% 20HOWTO.htm have fun, Marin ...what you brought from your past, is of no use in your present. When you must choose a new path, do not bring old experiences with you. Those who strike out afresh, but who attempt to retain a little of the old life, end up torn apart by their own memories. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Marin Dimitrov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Odell, Charles [Contractor] INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: AW: auditing tables
Jared, I just put the old values in the audit table with an additional column which tells exactly which columns are changed. Ah the wonders of dynamic sql ... Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- Sent: Tuesday, January 29, 2002 10:06 AM To: Multiple recipients of list ORACLE-L Rachel, I don't think you need two rows for updates. The old values will be in the audit table, the new ones are in the production table. At least that's the way I've always done it. Is there some other reason for saving both in the audit table? Jared *2 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *2
Re: AW: auditing tables
Is there some other reason for saving both in the audit table? Jared, You must be right. But, if for some 'crazy' reason primary key of the record gets modified, then you need both old and new in audit table. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, January 29, 2002 10:05 AM On Tuesday 29 January 2002 03:00, Rachel Carmichael wrote: Update -- add two rows to the auditing table -- first with old values and type = O second with all the new values and type =N Rachel, I don't think you need two rows for updates. The old values will be in the audit table, the new ones are in the production table. At least that's the way I've always done it. Is there some other reason for saving both in the audit table? Jared --- Foelz.Frank [EMAIL PROTECTED] wrote: TNX for your answers. What I need is exactly what Oracle doesn't support. Logging who changed what in a special area of our database. I think triggering the events will be much more specific and more easy to change. In case all our applications use the same database and user, I am trying to check out what application is changing monitored tables (i.e. c:\app\userapp\app.exe is changing table1). What do you think of that ?? greets Frank Von: Rachel Carmichael [mailto:[EMAIL PROTECTED]] what sort of information are you looking to audit? if you want any sort of detail, you are better off with triggers and possibly an audit table. Oracle doesn't record WHAT has been changed, just that the table was accessed. So you don't know the row etc... --- Foelz.Frank [EMAIL PROTECTED] wrote: Hi all, does anyone have experience in using Oracle's possibilities of auditing a database ?? I am interested in performance questions i.e. is it a hughe loss of performance when auditing tables Inserts/Updates/Deletes. Should I use triggers instead ? any hints (comments, websites, etc...) are welcome. Frank -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Foelz.Frank INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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!? Great stuff seeking new owners in Yahoo! Auctions! http://auctions.yahoo.com -- 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: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: OFF TOPIC: RE: PL/SQL
LOL...where's me soapbox!! I'm having a bad week, and hot-dang if everyone else ain't gonna suffer to!! ;o) TFIC! -Original Message- Sent: 29 January 2002 14:50 To: Multiple recipients of list ORACLE-L Kevin, I am sorry, but you didn't sound holier than thou on that last post. Could you do it a bit differently next time? ;-) WWJD? JWRTFM! -Original Message- Sent: Tuesday, January 29, 2002 9:10 AM To: Multiple recipients of list ORACLE-L Hey I've helped this guy heaps of times...taken the time out to explain what I'm sending back to him and drop subtle hints about the references I use to get those answers if I don't know myselfwhy should he be any different??? -Original Message- Sent: 29 January 2002 13:45 To: Multiple recipients of list ORACLE-L Roland, Besides reading the manuals, take a look at www.lazydba.com. They also host an Oracle email list that might be a more appropriate forum for your questions. I think they have a higher ratio of new DBAs on their list, and seldom mind answering the beginner questions. HTH, Beth (was that so hard guys?) -Original Message- Sent: Tuesday, January 29, 2002 5:21 AM To: Multiple recipients of list ORACLE-L Hear hear ! You tell 'm, Kevin ! I'm with you all the way. Anybody can ask me a simple question when they are looking for a quick answer, but you can't do a good job when you're always looking for quick answers. You have to LEARN. There's a difference between learning and constantly asking questions. Sorry, couldn't resist ... -Oorspronkelijk bericht- Van: Thomas, Kevin [mailto:[EMAIL PROTECTED]] Verzonden: dinsdag 29 januari 2002 9:00 Aan: Multiple recipients of list ORACLE-L Onderwerp: OFF TOPIC: RE: PL/SQL When I arrive in the morning to a mailbox containing 150+ messages from this list, I'm almost certainly guaranteed that 10% of them will be questions that can easily be found via otn or a manual. That 10% usually comes from the same person!! No wonder I'm irritated!!! }:o| -Original Message- Sent: 28 January 2002 17:35 To: Multiple recipients of list ORACLE-L Geez... lay off already. If you don't think the question is worthy of your time, then don't answer it. What a grouch. -Original Message- Sent: Monday, January 28, 2002 11:16 AM To: Multiple recipients of list ORACLE-L RRR TTTFF !! -Original Message- Sent: 28 January 2002 15:46 To: Multiple recipients of list ORACLE-L How can I in a pl/sql block write null if I want null to be inserted in a field when I use dynamic sql.? . I mean nothing is going to be inserted. Thanks in advance Roland -- 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: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seefelt, Beth INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself
RE: Database Performance Question
You have done very nicely so far in tuning those joins... but... More questions to you : 1. Why do you think this is still a database problem? 2. Will partitioning those larger tables help the queries? 3. What have you checked to make sure that the bottleneck is not the web-server? 4. Are these connections persistent or the app connects/disconnects when accessing the database? Looking for answers to these questions may help you locate other opportunities to improve upon.. - Kirti -Original Message- Sent: Tuesday, January 29, 2002 9:25 AM To: Multiple recipients of list ORACLE-L Hello all: We have an application that is having slow response time against an 8i database, I would like to improve the response time. This is a web based application accessing the database with about 2000 users. Most of the application queries are based on complex joins on 4 big tables with each having over 5 million rows( biggest table has 18 million rows). I have tuned the Package queries for the best explain plan possible, but still do not seem to make dramatic change in the response time. Though, I was able to make significant headway tuning these packages by bringing down response times from 7 minutes to under 3 minutes. But this is not an acceptable response time from a web-application perspective. I am considering creating data cubes based on the most frequently used join conditions and pre-populate them on a nightly basis or use triggers to update the cube simultaneously. I am hoping that this enhance the response times. I would greatly appreciate your suggestions or opinions on this idea. If you have an alternative/better way of achiving this please enlighten me. Thank very much. Srini Rajendran. -- 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: 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).
RE:Hot backup and TEMP tablespace
ALWAYS BACKUP THE ROLLBACK TABLESPACE! or you will not be able to recover. How else will Oracle rollback a transaction in the works when the database went down. I do not back up TEMP or my INDEX tables spaces. I have scripts that recreate all of these. (150GB of indices, not worth the tape.) And while I use RMAN for backups I do all my recoveries from the our scripted hot backups. I also practise recoveries every 6 months. RMAN backups fine, it's recoveries it has trouble with :) Why? There is limited flexibility with RMAN along with an added dependency. As most know I loathe unecessary dependencies. An Example: power surge blows out Machine and hub/router power supply. Machine automagicaly fails over to alternate power, however, the hub/router needs servicing. Your RMAN catalog is on the other side of the hub/router. What are you going to do now? And yes, as I keep saying, I am paranoid. Dave Tom wrote: steps just to save yourself some time during backups? Why stop at backing up the TEMP tablespace - why not the ROLLBACK tablespace - this could be dropped and re-created also. Why not INDEX tablespaces - heck, if you have the scripts, these could be re-created too! -- Dave Morgan DBA, Cybersurf Office: 403 777 2000 ext 284 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
NetSaint
Has anybody heard of/used/liked/hated NetSaint? One of our UNIX administrators is pushing this as a cheap alternative to CA UniCenter, and he wants to start using it to monitor systems and databases. Please let me know your opinions, thoughts, and locations of any resources you are aware of. Thanx, Mike --- === Michael P. Vergara Guidant Corporation Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Lookup Table Usage
Thanks, Connor. Oh, did I enjoy the Master Class this past week. A couple of situations: 14 people, including Millsap, Steve Adams, Jonathan Lewis, James Morle and what have you sitting around my oak table one evening when dinner is served. Most of the guys simply closed their laptops, placed the plates on top of the laptop, ate dinner while continuing to discuss important Oracle matters, then removed the plates, thanked for the dinner, re-opened the laptops and continued typing. Or one morning when Steve Adams and I are discussing South African the in my kitchen. Jonathan comes down the stairs with a towel around his neck. Doesn't say good morning. Doesn't say hello. Does say: "Did you know, that when you join 256 simple tables, the parse time with the RBO is 44 minutes and 22 seconds?". Steve replied: Good morning, Jonathan. Jonathan looked at us (very sleepy look), then said Good Morning and went to the showers. Or the look on the hotdog stand owner's face when we pulled up beside his hotdog stand at 2330 hours in a huge bus and people just kept coming out of the bus and ordering hotdogs. We had been there every night (Anjo insists) in growing numbers. I had promised to call ahead and tell him how many we would be on this special night. Well, I forgot. Bjarnes Polser, as it's called, will never be the same again. It was a fun week. You should have been there, Connor ;-). Mogens Connor McDonald wrote: Hello Mogens,TCH is the touch count.CheersConnorOT - enjoy JL's conference this week. --- Mogens Nrgaard [EMAIL PROTECTED] wrote: Andin 8i there's a column in x$bh which counts the number of times the buffer is touched (as I recall) called XNC orsomething?Rachel Carmichael wrote: you could turn auditing on on the table and count the number of times it was selected--- Whittle Jerome Contr NCI [EMAIL PROTECTED] wrote: Hi,Oracle 7.3.4 on Unix.The database has dozens of little lookup tables. I'd like to cache thoseused the most. Is there a way to see how often a table is queried? Thanks,Jerry WhittleACIFICS DBANCI Information Systems Inc.[EMAIL PROTECTED]618-622-4145--Please see the official ORACLE-L FAQ: http://www.orafaq.com --Author: Whittle Jerome Contr NCI INET: [EMAIL PROTECTED]Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: INFORMIX 7.3 to ORACLE 8.1.7
Look here: http://technet.oracle.com/tech/migration/toolkits/content.html -Original Message- Sent: Tuesday, January 29, 2002 8:21 AM To: Multiple recipients of list ORACLE-L Hi! We inherited one Informix database, which we must put into our production Oracle database (new schema). Both databases are on AIX UNIX machines. We can do this by writing a scripts, but I'm wondering does any of you have some experiance in this, and could you suggest me some other (simpler) way? Perhaps some Conversion tools? TIA, Sonja -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?ISO-8859-2?Q?Sonja_=A9ehovi=E6?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OFF TOPIC: RE: PL/SQL
Has anyone read 'Oracle8i for Dummies' ?? I have checked it out from our local public library It's not a bad read, I am still in chapter 1, though.. learning some new interesting analogies to this techie stuff.. - Kirti -Original Message- Sent: Tuesday, January 29, 2002 8:55 AM To: Multiple recipients of list ORACLE-L beginner should start with RTFM, trying it on test box, and only than, if he still does not get it, post his question explaining his problems. Beth, you must not have seen Roland's questions. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, January 29, 2002 8:45 AM Roland, Besides reading the manuals, take a look at www.lazydba.com. They also host an Oracle email list that might be a more appropriate forum for your questions. I think they have a higher ratio of new DBAs on their list, and seldom mind answering the beginner questions. HTH, Beth (was that so hard guys?) -Original Message- Sent: Tuesday, January 29, 2002 5:21 AM To: Multiple recipients of list ORACLE-L Hear hear ! You tell 'm, Kevin ! I'm with you all the way. Anybody can ask me a simple question when they are looking for a quick answer, but you can't do a good job when you're always looking for quick answers. You have to LEARN. There's a difference between learning and constantly asking questions. Sorry, couldn't resist ... -Oorspronkelijk bericht- Van: Thomas, Kevin [mailto:[EMAIL PROTECTED]] Verzonden: dinsdag 29 januari 2002 9:00 Aan: Multiple recipients of list ORACLE-L Onderwerp: OFF TOPIC: RE: PL/SQL When I arrive in the morning to a mailbox containing 150+ messages from this list, I'm almost certainly guaranteed that 10% of them will be questions that can easily be found via otn or a manual. That 10% usually comes from the same person!! No wonder I'm irritated!!! }:o| -Original Message- Sent: 28 January 2002 17:35 To: Multiple recipients of list ORACLE-L Geez... lay off already. If you don't think the question is worthy of your time, then don't answer it. What a grouch. -Original Message- Sent: Monday, January 28, 2002 11:16 AM To: Multiple recipients of list ORACLE-L RRR TTTFF !! -Original Message- Sent: 28 January 2002 15:46 To: Multiple recipients of list ORACLE-L How can I in a pl/sql block write null if I want null to be inserted in a field when I use dynamic sql.? . I mean nothing is going to be inserted. Thanks in advance Roland -- 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: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seefelt, Beth INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru')
Re: CHECKPOINT?
Log file sync is another name for commit. So have fewer commits or make them faster is the extremely short answer. But these values are taking out of context - if the time_waited for log file sync is small compared to the total response time, then who cares? :). Mogens Seema Singh wrote: Hi I checked the following events Name total_waits time_waited log file switch completion 181188 log file sync 99909 667388 This value is increasing.I checked following stats and found ok. background checkpoints Completed 15 background checkpoints started 16 Oracle suggest if above wait events is repeated frequently with considerable values then we need to atke a action like adding more redo log files or increasing their sizes or modifying checkpointing parameters. Thanks -Dinesh _ 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: Mogens =?ISO-8859-1?Q?N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: OFF TOPIC: RE: PL/SQL
Kirti, Too much time on your hands? Does the one, who gets through it's last chapter, get 'Oracle Dummy DBA' sign? Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, January 29, 2002 11:05 AM Has anyone read 'Oracle8i for Dummies' ?? I have checked it out from our local public library It's not a bad read, I am still in chapter 1, though.. learning some new interesting analogies to this techie stuff.. - Kirti -Original Message- Sent: Tuesday, January 29, 2002 8:55 AM To: Multiple recipients of list ORACLE-L beginner should start with RTFM, trying it on test box, and only than, if he still does not get it, post his question explaining his problems. Beth, you must not have seen Roland's questions. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, January 29, 2002 8:45 AM Roland, Besides reading the manuals, take a look at www.lazydba.com. They also host an Oracle email list that might be a more appropriate forum for your questions. I think they have a higher ratio of new DBAs on their list, and seldom mind answering the beginner questions. HTH, Beth (was that so hard guys?) -Original Message- Sent: Tuesday, January 29, 2002 5:21 AM To: Multiple recipients of list ORACLE-L Hear hear ! You tell 'm, Kevin ! I'm with you all the way. Anybody can ask me a simple question when they are looking for a quick answer, but you can't do a good job when you're always looking for quick answers. You have to LEARN. There's a difference between learning and constantly asking questions. Sorry, couldn't resist ... -Oorspronkelijk bericht- Van: Thomas, Kevin [mailto:[EMAIL PROTECTED]] Verzonden: dinsdag 29 januari 2002 9:00 Aan: Multiple recipients of list ORACLE-L Onderwerp: OFF TOPIC: RE: PL/SQL When I arrive in the morning to a mailbox containing 150+ messages from this list, I'm almost certainly guaranteed that 10% of them will be questions that can easily be found via otn or a manual. That 10% usually comes from the same person!! No wonder I'm irritated!!! }:o| -Original Message- Sent: 28 January 2002 17:35 To: Multiple recipients of list ORACLE-L Geez... lay off already. If you don't think the question is worthy of your time, then don't answer it. What a grouch. -Original Message- Sent: Monday, January 28, 2002 11:16 AM To: Multiple recipients of list ORACLE-L RRR TTTFF !! -Original Message- Sent: 28 January 2002 15:46 To: Multiple recipients of list ORACLE-L How can I in a pl/sql block write null if I want null to be inserted in a field when I use dynamic sql.? . I mean nothing is going to be inserted. Thanks in advance Roland -- 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: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seefelt, Beth INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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:
RE: RTFM questions (formally RE: PL/SQL)
Title: RTFM questions (formally RE: PL/SQL) JoJo... You're missing the point... Most people have no issue with helping another list member... But, some members abuse this help and consistent ask questions that could be found in the manual without even attempting to find it... The list member in question has consistently asked questions of this nature for the last few MONTHS... Many times other list members have given the answer and then pointed at the manual where the information is found... Instead of looking at the manual before asking the next question,the abuserwill immediately ask another question... And so on... And so on... And so on... After awhile, this gets frustrating... Personally, I do not reply to this list member due to his behavior... And I won'tuntil he starts saying things like... "I looked in this manual and read this part but I don't understand it" or "What manual should I look in to get this answer"... I guess what I am trying to say is that there is a history establishedwith a list member such as this that you are probably not aware of... People are frustrated and it is showing... Tim -Original Message-From: JoJo Al-Zawawi [mailto:[EMAIL PROTECTED]]Sent: Tuesday, January 29, 2002 10:41 AMTo: Multiple recipients of list ORACLE-LSubject: RE: RTFM questions (formally RE: PL/SQL) No offense to anybody, butI think this is rather arrogant. The list is for anybody (unless the list owner decides it's just for experienced dba's). I am brand new to Oracle, having just started learning it this week. I can easily foresee having what some might consider stupid orRTFM questions, and being possibly unable to find the answer or having problems deciphering the manual. I myself am somewhat of a Word pro (and my vba code samples page is the #1 ranked site of its kind on most major search engines) and I help all kinds of newbies out on a Word list of which I am a member, as do all the other members of the list. Everybody on that list is extremely gracious and nobody complains -- and the people with questions get the help they need, with nobody sitting back going "boy are you stupid / lazy". I am hoping that I can get the same kind of help here, when I am ready for it, that I and others give on other lists. --JoJo -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Craig MundaySent: Monday, January 28, 2002 10:20 PMTo: Multiple recipients of list ORACLE-LSubject: RTFM questions (formally RE: PL/SQL) The problem is that if you always ask the group for help, you never learn where the information is within the manuals or other reference documentation and the group also gets cluttered with trivia. I agree with you that the list is here to help people and I personally do not mind the odd naive question from a new DBA, but it is the "...can't be bothered to look up the manual.." attitude that is most frustrating. When you ask the format of a command (for example) to the list, you are potentionally asking 1000's of people the same question who will all have to spend the time to filter these questions - we are all busy people and I personally do not want to use my time in this way. I'm sure you can see that this is a much more expensive option than asking the person next to you. Cheers, Craig. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 29 January 2002 2:55 PM To: Multiple recipients of list ORACLE-L Subject: RE: PL/SQL Why do you bother being on this List: The list is here to help fellow DBA'S. Have you never said to one of your collegues , what is the format of this command, or how can I do that, when you simply cant be bothered to look it up in the manual (either your busy or just down right lazy): Sometimes this list is useful for just that. So why dont u lighten up dude. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RTFM questions (formally RE: PL/SQL)
Seriously though... You would of course get as much help as the next person here and I don't think it's out of place for me to say that newbies are always welcome! But it starts to get ridiculous when a poster continually posts questions that can be found on websites similar to your own without having to a) bother writing an email and b) waiting on a reply. The number of posts that can come from one person and be classed as just newbie questions, is finite, after a period of time, that individual can no longer be classed as a newbie! PLUS the fact that we more or less write the goddam applications for these people, why don't they just hire us!!!??? :o| -Original Message- Sent: 29 January 2002 15:41 To: Multiple recipients of list ORACLE-L No offense to anybody, but I think this is rather arrogant. The list is for anybody (unless the list owner decides it's just for experienced dba's). I am brand new to Oracle, having just started learning it this week. I can easily foresee having what some might consider stupid or RTFM questions, and being possibly unable to find the answer or having problems deciphering the manual. I myself am somewhat of a Word pro (and my vba code samples page is the #1 ranked site of its kind on most major search engines) and I help all kinds of newbies out on a Word list of which I am a member, as do all the other members of the list. Everybody on that list is extremely gracious and nobody complains -- and the people with questions get the help they need, with nobody sitting back going boy are you stupid / lazy. I am hoping that I can get the same kind of help here, when I am ready for it, that I and others give on other lists. --JoJo -Original Message- Sent: Monday, January 28, 2002 10:20 PM To: Multiple recipients of list ORACLE-L The problem is that if you always ask the group for help, you never learn where the information is within the manuals or other reference documentation and the group also gets cluttered with trivia. I agree with you that the list is here to help people and I personally do not mind the odd naive question from a new DBA, but it is the ...can't be bothered to look up the manual.. attitude that is most frustrating. When you ask the format of a command (for example) to the list, you are potentionally asking 1000's of people the same question who will all have to spend the time to filter these questions - we are all busy people and I personally do not want to use my time in this way. I'm sure you can see that this is a much more expensive option than asking the person next to you. Cheers, Craig. -Original Message- mailto:[EMAIL PROTECTED] ] Sent: Tuesday, 29 January 2002 2:55 PM To: Multiple recipients of list ORACLE-L Why do you bother being on this List: The list is here to help fellow DBA'S. Have you never said to one of your collegues , what is the format of this command, or how can I do that, when you simply cant be bothered to look it up in the manual (either your busy or just down right lazy): Sometimes this list is useful for just that. So why dont u lighten up dude. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com 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: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: export the schema exclude two tables?
Well. I've done it several times, ie modify the exutab or exu7tab or whatever view to do something special like exporting all tables except ... or export of a tablespace (!), etc. As long as you modify the export views, run the modified catexp, do the export, then re-run the original catexp you're fine. It's just a bunch of views used by the database. Nothing dangerous in that - except, of course, if you specify something wrong and doesn't export the data you want. Just remember to go back to the real and correct definitions of the views after your special export. Mogens [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Raj, You are obviously one dangerous dude. We're watching you. :) Newbies: He didn't mean it. Don't try this stuff on your databases! JARed [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 01/24/02 03:50 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] cc: Subject:Re: export the schema exclude two tables? Could we do it in 7.3, 8.0? ;-) Open the catexp.sql and modify some table creation scripts, possibly some exutab tables to say obj$.name != Table1, Table2. Hic !! Nooo. I did not say that ;-) What I say is, include all the tablenames e xcept the two that you do not need in your parfile. Regards Raj CC Harvest [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]@fatcity.com on 01/24/2002 04:55:22 PM Please respond to [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] cc: Anyone knows how to do it in Oracle8.1.7? __ Do You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! http://auctions.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CC Harvest INET: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Mogens =?ISO-8859-1?Q?N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: sqlplus question
AFAIK, Kimberly does everything. (Except move to Dallas) -Original Message- Sent: Tuesday, January 29, 2002 11:41 AM To: Multiple recipients of list ORACLE-L Kewl! That means I get to start taking drugs again. I am a happy boy. I'll whiz over to the OT list and give Kimberly a ring. Does she like to climb mountains? -Original Message- Sent: Tuesday, January 29, 2002 8:25 AM To: Multiple recipients of list ORACLE-L Walt, don't worry. He's speaking WaReZ speak. You have to follow the White Rabbit to get out. For further instructions, see Kimberly. She enjoys questions like these. -Original Message- I'm lost here... --Walt -Original Message- Sent: Monday, January 28, 2002 10:50 PM To: Multiple recipients of list ORACLE-L Well, you can check the manual but use the package dbms_output.put_job that willfix it when you are inoracle but ifyoua re in unix environment you must use crontab Hope this is of help for you Roland -- 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: Weaver, Walt INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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).
Re: sqlplus question
So true! Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, January 29, 2002 10:05 AM Igor Neyman wrote: 'dbms_output.put_job '? What the heck was this about? Please, check your answers before posting to the list! Igor Neyman, OCP DBA [EMAIL PROTECTED] answers AND questions -- Regards, Stephane Faroult Oriole Ltd -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Function In Select Statment
Hi List, One of our developer using function in his select statment but the problem is when he is using order by one of the function results column the query is very slow, Is there any way to use hint for function or some thing to make quesry faster. Thanks in advance Hamid Alavi Office 818 737-0526 Cell818 402-1987 The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: RTFM questions (formally RE: PL/SQL)
Title: RTFM questions (formally RE: PL/SQL) yep, but a lot of us I am sure do not have time to answer these types of questions whilst holding down a full time job. I think this has gone a bit far anyway and I am sure Roland has been suitably chastised and even said himself that he went out and found the answer to his problem. Nothing wrong with helping new guys but there must be a limit to how much help you can expect without doing any work or research yourself. Lee -Original Message-From: JoJo Al-Zawawi [mailto:[EMAIL PROTECTED]]Sent: 29 January 2002 15:41To: Multiple recipients of list ORACLE-LSubject: RE: RTFM questions (formally RE: PL/SQL) No offense to anybody, butI think this is rather arrogant. The list is for anybody (unless the list owner decides it's just for experienced dba's). I am brand new to Oracle, having just started learning it this week. I can easily foresee having what some might consider stupid orRTFM questions, and being possibly unable to find the answer or having problems deciphering the manual. I myself am somewhat of a Word pro (and my vba code samples page is the #1 ranked site of its kind on most major search engines) and I help all kinds of newbies out on a Word list of which I am a member, as do all the other members of the list. Everybody on that list is extremely gracious and nobody complains -- and the people with questions get the help they need, with nobody sitting back going "boy are you stupid / lazy". I am hoping that I can get the same kind of help here, when I am ready for it, that I and others give on other lists. --JoJo -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Craig MundaySent: Monday, January 28, 2002 10:20 PMTo: Multiple recipients of list ORACLE-LSubject: RTFM questions (formally RE: PL/SQL) The problem is that if you always ask the group for help, you never learn where the information is within the manuals or other reference documentation and the group also gets cluttered with trivia. I agree with you that the list is here to help people and I personally do not mind the odd naive question from a new DBA, but it is the "...can't be bothered to look up the manual.." attitude that is most frustrating. When you ask the format of a command (for example) to the list, you are potentionally asking 1000's of people the same question who will all have to spend the time to filter these questions - we are all busy people and I personally do not want to use my time in this way. I'm sure you can see that this is a much more expensive option than asking the person next to you. Cheers, Craig. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 29 January 2002 2:55 PM To: Multiple recipients of list ORACLE-L Subject: RE: PL/SQL Why do you bother being on this List: The list is here to help fellow DBA'S. Have you never said to one of your collegues , what is the format of this command, or how can I do that, when you simply cant be bothered to look it up in the manual (either your busy or just down right lazy): Sometimes this list is useful for just that. So why dont u lighten up dude. -- 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). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system.
RE: RTFM questions (formally RE: PL/SQL)
And your point caller?? TIC ;o) -Original Message- Sent: 29 January 2002 15:41 To: Multiple recipients of list ORACLE-L No offense to anybody, but I think this is rather arrogant. The list is for anybody (unless the list owner decides it's just for experienced dba's). I am brand new to Oracle, having just started learning it this week. I can easily foresee having what some might consider stupid or RTFM questions, and being possibly unable to find the answer or having problems deciphering the manual. I myself am somewhat of a Word pro (and my vba code samples page is the #1 ranked site of its kind on most major search engines) and I help all kinds of newbies out on a Word list of which I am a member, as do all the other members of the list. Everybody on that list is extremely gracious and nobody complains -- and the people with questions get the help they need, with nobody sitting back going boy are you stupid / lazy. I am hoping that I can get the same kind of help here, when I am ready for it, that I and others give on other lists. --JoJo -Original Message- Sent: Monday, January 28, 2002 10:20 PM To: Multiple recipients of list ORACLE-L The problem is that if you always ask the group for help, you never learn where the information is within the manuals or other reference documentation and the group also gets cluttered with trivia. I agree with you that the list is here to help people and I personally do not mind the odd naive question from a new DBA, but it is the ...can't be bothered to look up the manual.. attitude that is most frustrating. When you ask the format of a command (for example) to the list, you are potentionally asking 1000's of people the same question who will all have to spend the time to filter these questions - we are all busy people and I personally do not want to use my time in this way. I'm sure you can see that this is a much more expensive option than asking the person next to you. Cheers, Craig. -Original Message- mailto:[EMAIL PROTECTED] ] Sent: Tuesday, 29 January 2002 2:55 PM To: Multiple recipients of list ORACLE-L Why do you bother being on this List: The list is here to help fellow DBA'S. Have you never said to one of your collegues , what is the format of this command, or how can I do that, when you simply cant be bothered to look it up in the manual (either your busy or just down right lazy): Sometimes this list is useful for just that. So why dont u lighten up dude. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com 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: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: sqlplus question
Kewl! That means I get to start taking drugs again. I am a happy boy. I'll whiz over to the OT list and give Kimberly a ring. Does she like to climb mountains? -Original Message- Sent: Tuesday, January 29, 2002 8:25 AM To: Multiple recipients of list ORACLE-L Walt, don't worry. He's speaking WaReZ speak. You have to follow the White Rabbit to get out. For further instructions, see Kimberly. She enjoys questions like these. -Original Message- I'm lost here... --Walt -Original Message- Sent: Monday, January 28, 2002 10:50 PM To: Multiple recipients of list ORACLE-L Well, you can check the manual but use the package dbms_output.put_job that willfix it when you are inoracle but ifyoua re in unix environment you must use crontab Hope this is of help for you Roland -- 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: Weaver, Walt INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Function In Select Statment
Hamid, Why not create a function based index on the column that is being and the data returned will be faster. I do not know if it will help the sort for the order by but the data returned will be available faster. What does your sort area look like? Is it to small to handle the sort and paging out to disk? ROR mª¿ªm [EMAIL PROTECTED] 01/29/02 11:05AM Hi List, One of our developer using function in his select statment but the problem is when he is using order by one of the function results column the query is very slow, Is there any way to use hint for function or some thing to make quesry faster. Thanks in advance Hamid Alavi Office 818 737-0526 Cell818 402-1987 The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contReceived: from CONNECT-MTA by galotterain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: RTFM questions (formally RE: PL/SQL)
Title: RTFM questions (formally RE: PL/SQL) JoJo, There is a difference between 'unable to find the answer' and 'not willing to find the answer through RTFM'. BTW, I didn't see any 'stupid or RTFM' kind of questions from you (unlike this other person). Igor Neyman, OCP DBA[EMAIL PROTECTED] - Original Message - From: JoJo Al-Zawawi To: Multiple recipients of list ORACLE-L Sent: Tuesday, January 29, 2002 10:40 AM Subject: RE: RTFM questions (formally RE: PL/SQL) No offense to anybody, butI think this is rather arrogant. The list is for anybody (unless the list owner decides it's just for experienced dba's). I am brand new to Oracle, having just started learning it this week. I can easily foresee having what some might consider stupid orRTFM questions, and being possibly unable to find the answer or having problems deciphering the manual. I myself am somewhat of a Word pro (and my vba code samples page is the #1 ranked site of its kind on most major search engines) and I help all kinds of newbies out on a Word list of which I am a member, as do all the other members of the list. Everybody on that list is extremely gracious and nobody complains -- and the people with questions get the help they need, with nobody sitting back going "boy are you stupid / lazy". I am hoping that I can get the same kind of help here, when I am ready for it, that I and others give on other lists. --JoJo -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Craig MundaySent: Monday, January 28, 2002 10:20 PMTo: Multiple recipients of list ORACLE-LSubject: RTFM questions (formally RE: PL/SQL) The problem is that if you always ask the group for help, you never learn where the information is within the manuals or other reference documentation and the group also gets cluttered with trivia. I agree with you that the list is here to help people and I personally do not mind the odd naive question from a new DBA, but it is the "...can't be bothered to look up the manual.." attitude that is most frustrating. When you ask the format of a command (for example) to the list, you are potentionally asking 1000's of people the same question who will all have to spend the time to filter these questions - we are all busy people and I personally do not want to use my time in this way. I'm sure you can see that this is a much more expensive option than asking the person next to you. Cheers, Craig. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 29 January 2002 2:55 PM To: Multiple recipients of list ORACLE-L Subject: RE: PL/SQL Why do you bother being on this List: The list is here to help fellow DBA'S. Have you never said to one of your collegues , what is the format of this command, or how can I do that, when you simply cant be bothered to look it up in the manual (either your busy or just down right lazy): Sometimes this list is useful for just that. So why dont u lighten up dude. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Public Privileges on system tables?
Hi Ron... I found some info in the reference guide... PSTUBTBL This table contains information on stubs generated by the PSTUB utility so that an Oracle Forms 3.0 client can call stored procedures in an Oracle database. Note: The contents of this table are intended only for use by the PSTUB utility. I only found a couple references to user_privs... Looks like it was eliminated... I found it mentioned on a couple web pages... I also found out that there appears to be a view named user_privs created by older pupbld.sql... It was based on the user_profile table... HTH Tim -Original Message- Sent: Tuesday, January 29, 2002 8:10 AM To: Multiple recipients of list ORACLE-L Hello Ron I checked our 7.3.4 DB (on NT) and did not find these tables. I think that they may belong to a product that use these tables and so everyone who uses this product need them. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: Smith, Ron L. [SMTP:[EMAIL PROTECTED]] Sent: Mon, January 28, 2002 6:56 PM To: Multiple recipients of list ORACLE-L Subject: Public Privileges on system tables? I have two tables, sys.pstubtbl and sys.user_privs that have grants to public for insert, update, and delete. Our auditors are wondering why. I don't really want to remove the privs without knowing why. This is an old 7.3.4 instance. Any ideas? Ron Smith -- 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). -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- This e-mail was scanned by the eSafe Mail Gateway -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Johnston, Tim INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Database Performance Question
Title: RE: Database Performance Question Partitions, Materialized views, bit map indexes. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 29, 2002 10:25 AM To: Multiple recipients of list ORACLE-L Subject: Database Performance Question Hello all: We have an application that is having slow response time against an 8i database, I would like to improve the response time. This is a web based application accessing the database with about 2000 users. Most of the application queries are based on complex joins on 4 big tables with each having over 5 million rows( biggest table has 18 million rows). I have tuned the Package queries for the best explain plan possible, but still do not seem to make dramatic change in the response time. Though, I was able to make significant headway tuning these packages by bringing down response times from 7 minutes to under 3 minutes. But this is not an acceptable response time from a web-application perspective. I am considering creating data cubes based on the most frequently used join conditions and pre-populate them on a nightly basis or use triggers to update the cube simultaneously. I am hoping that this enhance the response times. I would greatly appreciate your suggestions or opinions on this idea. If you have an alternative/better way of achiving this please enlighten me. Thank very much. Srini Rajendran. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: NetSaint
We're using NetSaint here. Does the job for us, and it's a bit cheaper than CA Unicenter... --Walt Weaver Bozeman, Montana -Original Message- Sent: Tuesday, January 29, 2002 9:12 AM To: Multiple recipients of list ORACLE-L Has anybody heard of/used/liked/hated NetSaint? One of our UNIX administrators is pushing this as a cheap alternative to CA UniCenter, and he wants to start using it to monitor systems and databases. Please let me know your opinions, thoughts, and locations of any resources you are aware of. Thanx, Mike --- === Michael P. Vergara Guidant Corporation Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Weaver, Walt INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle process causes High CPU
We have problem with oracle process ora_snp0 that causes high CPU and core files on our system. Does someone have idea how to fix it? Please help. Below is information captured from a trace file: Dump file /export/home/oracle/product/8.0.5/rdbms/log/ssdb_snp0_16657.trc Oracle8 Enterprise Edition Release 8.0.5.2.1 - Production PL/SQL Release 8.0.5.2.0 - Production ORACLE_HOME = /export/home/oracle/product/8.0.5 System name:SunOS Node name: pbna1 Release:5.6 Version:Generic_105181-26 Machine:sun4u Instance name: SSDB Redo thread mounted by this instance: 1 Oracle process number: 8 Unix process pid: 16657, image: ora_snp0_SSDB *** 2002.01.29.03.13.33.000 *** SESSION ID:(7.11) 2002.01.29.03.13.32.000 Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x 5f4c6000 Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x 7f6c7d78 Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x 7f6c7d78Background_Core_Dump = FULL Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Install problem solved
Last week I posted the note below about installation problems we were experiencing. The Oracle installer just failed with no message. We have solved to problem and thought I would share the solution with the list. The installer was looking at a file '/usr/var/opt/oracle/orainst.loc', deciding that it didn't need to upgrade an existing database, and halting/failing. That is our interpretation anyway. Deleting this file caused the installer to run successfully. On the Compaq Tru64 we can't recall Oracle ever using a file in that path. Normally Oracle uses /etc for that sort of thing. Lots of other things were tried in this endeavor so I can't discount the fact that some of those changes might have helped resolve the problem. We found this especially puzzling because we installed 8.1.7 on another machine cleanly and this file was present, but apparently didn't upset the installer. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- From: DENNIS WILLIAMS Sent: Monday, January 21, 2002 10:12 AM To: '[EMAIL PROTECTED]' Subject: Oracle 8.1.7 install failure on Compaq Tru64 We are trying to install Oracle 8.1.7 on Compaq Tru64 with 0.S. 4.0F with the latest patch kit, and the EV5.6 chip set. The install just bombs off at 56% complete. No error messages, log messages, or trace files (hasn't gotten far enough to create ORACLE_HOME). The install works fine on another machine with the EV6 chip set. Compaq and Oracle say that EV5.6 should be acceptable, and haven't provided much in the way of resolution. If you are curious which chip set you have, enter the command /usr/sbin/psrinfo -v. Any information on this would be helpful. Thank you. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Class does not exist error
This is supposed to be BUG# 1260358 and fixed in 8.1.6.1, but I can't find any info on that BUG... You may want to try to execute the $ORACLE_HOME/rdbms/admin/iniplsj.sql script as user SYS. This is normally called as part of initjvm.sql, but some releases skipped it. If I remember correctly, I had to run that manually, too, a few weeks ago when I tried the e-mail thing. Of course, DO THIS ON A TEST DATABASE FIRST and don't blame me if it don't work. Good luck! :) Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Tuesday, January 29, 2002 8:00 AM To: Multiple recipients of list ORACLE-L Hi, Rick I'm not 100% sure, but it I think, the problem is Server/JServer version. The script will be OK on 8.1.7. 8.1.7 JVM is very different from 8.1.6 HTH Vadim -Original Message- Sent: Tuesday, January 29, 2002 8:15 AM To: Multiple recipients of list ORACLE-L Hi DBAs, Oracle 8.1.6, NT server, JServer 8.1.6, Win 200 client A list member sent me a pl/sql script for sending mail. It compiles ok when I run it I get the following error class oracle/plsql/net/TCPConnection does not exist Any ideas on how to correct this? I do not know if I have to do something on client side or server side Thanks Rick -- 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).
Re: NetSaint
Hi, As a alternative to TNG we tried that product, as a technitian i like the product and will again push it ;), but as a manager i wont go for that product cause of managability and scalability, TNG is very scalable and netsaint is not that much. just ask him who manages if he leaves (They asked me hi hi hi) Regards OraEtM!! From: Vergara, Michael (TEM) [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: NetSaint Date: Tue, 29 Jan 2002 08:12:05 -0800 Has anybody heard of/used/liked/hated NetSaint? One of our UNIX administrators is pushing this as a cheap alternative to CA UniCenter, and he wants to start using it to monitor systems and databases. Please let me know your opinions, thoughts, and locations of any resources you are aware of. Thanx, Mike --- === Michael P. Vergara Guidant Corporation Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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/intl.asp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eswar the MAD INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Business Intelligence Suites
Does anyone have any experience with Brio, Cognos, or any other Business Intelligence Suites? If so,what are some pros and cons of them? I have looked at Oracle's data mining suite, but it looks like it requires heavy development to deploy reports and tools(We don't have an in-house Java developer). I hope this isn't too offtopic(Hey I mentioned Oracle) Thanks for any info you can give me. -Brian -- # Brian Haas [EMAIL PROTECTED] Database Admin # # Phone: (541)774-5211 http://www.musiciansfriend.com # -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian Haas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 trace file on/off
Send them doggies home, KD, it's a done deal. ;-) -Original Message- You may turn the trace on or off that way, but how do you interrogate it to find its event settings? - Kirti -Original Message- Sent: Monday, January 28, 2002 6:42 PM To: 'Deshpande, Kirti'; [EMAIL PROTECTED] ORADEBUG SETORAPID, would make current session whatever you like, no? -Original Message- From what I know, there is no way to find if a session has turned on the tracing unless it is your own session. DBMS_SYSTEM.read_ev can you tell you if the current session is tracing or not, but it can not interrogate other sessions. The only way I know is to check the trace files generated in the udump directory.. but it is not fool-proof. And since you can not find out who is tracing at the moment, you can not stop it.. Ross, I sure would like to learn the trick. Can you please post it?? :) Thanks. - Kirti -- 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: 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).
RE: Function In Select Statment
That may indeed help, if you're very lucky. However forcing it to use that index could also result in an inefficient query path. Another possibility, also with drawbacks, is to have a materialized view which contains the function results as a column of the view. Ian MacGregor Stanford Linear Acclerator Center [EMAIL PROTECTED] -Original Message- From: Ron Rogers [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 29, 2002 8:36 AM To: Multiple recipients of list ORACLE-L Hamid, Why not create a function based index on the column that is being and the data returned will be faster. I do not know if it will help the sort for the order by but the data returned will be available faster. What does your sort area look like? Is it to small to handle the sort and paging out to disk? ROR mª¿ªm [EMAIL PROTECTED] 01/29/02 11:05AM Hi List, One of our developer using function in his select statment but the problem is when he is using order by one of the function results column the query is very slow, Is there any way to use hint for function or some thing to make quesry faster. Thanks in advance Hamid Alavi Office 818 737-0526 Cell818 402-1987 The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contReceived: from CONNECT-MTA by galotterain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: auditing tables
Oracle Designer will create journal tables, and the triggers to populate them. It might be worth capturing your DB design in Designer and using this feature (of course, I'm sure Designer isn't cheap, so that's a consideration as well). You'd gain the benefit of having your design stored in a repository, too. PB --- Rachel Carmichael [EMAIL PROTECTED] wrote: triggers -- that do an insert into an auditing table. Been there, done that: Insert -- add a row to the auditing table of all the new values with one extra column type =I Delete add a row to the auditing table with all the old values and type=D Update -- add two rows to the auditing table -- first with old values and type = O second with all the new values and type =N --- Foelz.Frank [EMAIL PROTECTED] wrote: TNX for your answers. What I need is exactly what Oracle doesn't support. Logging who changed what in a special area of our database. I think triggering the events will be much more specific and more easy to change. In case all our applications use the same database and user, I am trying to check out what application is changing monitored tables (i.e. c:\app\userapp\app.exe is changing table1). What do you think of that ?? greets __ Do You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! http://auctions.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: OFF TOPIC: RE: PL/SQL
Kirti - I haven't read that book, but I haven't seen a bad book in the for Dummies series yet, so I would imagine it is pretty good, especially for beginners. Maybe after you have gone through it you can let us know your opinion, especially whether it is more for beginning Oracle developers or beginning DBAs. Book recommendation is a question that seems to recur on this list. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, January 29, 2002 10:06 AM To: Multiple recipients of list ORACLE-L Has anyone read 'Oracle8i for Dummies' ?? I have checked it out from our local public library It's not a bad read, I am still in chapter 1, though.. learning some new interesting analogies to this techie stuff.. - Kirti -Original Message- Sent: Tuesday, January 29, 2002 8:55 AM To: Multiple recipients of list ORACLE-L beginner should start with RTFM, trying it on test box, and only than, if he still does not get it, post his question explaining his problems. Beth, you must not have seen Roland's questions. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, January 29, 2002 8:45 AM Roland, Besides reading the manuals, take a look at www.lazydba.com. They also host an Oracle email list that might be a more appropriate forum for your questions. I think they have a higher ratio of new DBAs on their list, and seldom mind answering the beginner questions. HTH, Beth (was that so hard guys?) -Original Message- Sent: Tuesday, January 29, 2002 5:21 AM To: Multiple recipients of list ORACLE-L Hear hear ! You tell 'm, Kevin ! I'm with you all the way. Anybody can ask me a simple question when they are looking for a quick answer, but you can't do a good job when you're always looking for quick answers. You have to LEARN. There's a difference between learning and constantly asking questions. Sorry, couldn't resist ... -Oorspronkelijk bericht- Van: Thomas, Kevin [mailto:[EMAIL PROTECTED]] Verzonden: dinsdag 29 januari 2002 9:00 Aan: Multiple recipients of list ORACLE-L Onderwerp: OFF TOPIC: RE: PL/SQL When I arrive in the morning to a mailbox containing 150+ messages from this list, I'm almost certainly guaranteed that 10% of them will be questions that can easily be found via otn or a manual. That 10% usually comes from the same person!! No wonder I'm irritated!!! }:o| -Original Message- Sent: 28 January 2002 17:35 To: Multiple recipients of list ORACLE-L Geez... lay off already. If you don't think the question is worthy of your time, then don't answer it. What a grouch. -Original Message- Sent: Monday, January 28, 2002 11:16 AM To: Multiple recipients of list ORACLE-L RRR TTTFF !! -Original Message- Sent: 28 January 2002 15:46 To: Multiple recipients of list ORACLE-L How can I in a pl/sql block write null if I want null to be inserted in a field when I use dynamic sql.? . I mean nothing is going to be inserted. Thanks in advance Roland -- 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: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seefelt, Beth INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want
Re: NetSaint
we use big brother, free and it works. not sure of the others you mentioned. i've been forced to use ca-unicenter before and its not worth 1% of what they charged. basically it sux :) [EMAIL PROTECTED] 01/29/02 11:12AM Has anybody heard of/used/liked/hated NetSaint? One of our UNIX administrators is pushing this as a cheap alternative to CA UniCenter, and he wants to start using it to monitor systems and databases. Please let me know your opinions, thoughts, and locations of any resources you are aware of. Thanx, Mike --- === Michael P. Vergara Guidant Corporation Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Top parent in START WITH...CONNECT BY
Hi, On 8.1.7.2 (soon to be .3) on HP/UX 11.0, a developer needs to get the top parent associated with a lower level row. Expanding on Oracle's EMP example: EMP MGR LEVEL King1 Greenberg King2 Faviet Greenberg 3 ChenGreenberg 3 Sciarra 1 Urman Sciarra 2 PoppUrman 3 Jesse Urman 3 ...I need to know that the top-level manager for Jesse is Sciarra. In our live data, however, we currently have 9 levels (engineering bill-of-materials) and there is no set maximum for levels. Anyone have an idea how to return: Jesse Urman Sciarra 3 ...for this? The START WITH...CONNECT BY can only give the PRIOR manager and not the top level. TIA! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- 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).
Where to store BLOB's
Hello all We are designing a new application. This application stores files that were FTP to the clients and keep then for resubmitting (if the user ask for them). There are two formats: 1) Standard records whose internal format is known. These files lets the user ask for a subset of the records, i.e. all the records for branch that were submitted in the last week, etc. . 2) Strange files that are moved as a file. Here the application is not aware of the internal format, i.e. excel files, and these files are going to be stored as Blob's and the user can ask only for the whole file again. I know that you can store Blob's in three ways: (already rtfm a little) 1) In the record (up to 4k), more goes to another tablespace. 2) In Oracle but in another tablespace (always). 3) As external files. I would like to learn from your experience what is the best, easiest to implement, easiest to admin, less demanding on Oracle and all the good stuff. TIA Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: OFF TOPIC: RE: PL/SQL
Igor, It's a good night-cap :) However, I can use a sign like that, considering what we are going through lately.. Implementing a HUGE system converted to access Oracle RDBMS. Converted from old IDMS COBOL code, to Pro*COBOL programs. Each table has 4 copy-book routines that are called from the main program (PROCEDURE DIVISION) :-) Yes, you guessed it right. I am not joking. Today, IBM is on site to fix the performance problems. Hope they find it in the H/W... because they did not code the App. Most DBAs are on the side line like dummies!!! Installation of this monster will proceed to meet dead lines and, of course, the budget. Next book on my list -- 'OCP for dummies!' Cheers ! - Kirti -Original Message- Sent: Tuesday, January 29, 2002 10:26 AM To: Multiple recipients of list ORACLE-L Kirti, Too much time on your hands? Does the one, who gets through it's last chapter, get 'Oracle Dummy DBA' sign? Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, January 29, 2002 11:05 AM Has anyone read 'Oracle8i for Dummies' ?? I have checked it out from our local public library It's not a bad read, I am still in chapter 1, though.. learning some new interesting analogies to this techie stuff.. - Kirti -- 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).
RE: Database Performance Question
Title: RE: Database Performance Question Parentitions and Maternalized Views are supposed to come out in 10i. (Paternalized views take longer, they required retrofitting onto the kernel command tree. ) -Original Message-From: Godlewski, Melissa [mailto:[EMAIL PROTECTED]]Sent: Tuesday, January 29, 2002 11:36 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Database Performance Question Partitions, Materialized views, bit map indexes. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 29, 2002 10:25 AM To: Multiple recipients of list ORACLE-L Subject: Database Performance Question Hello all: We have an application that is having slow response time against an 8i database, I would like to improve the response time. This is a web based application accessing the database with about 2000 users. Most of the application queries are based on complex joins on 4 big tables with each having over 5 million rows( biggest table has 18 million rows). I have tuned the Package queries for the best explain plan possible, but still do not seem to make dramatic change in the response time. Though, I was able to make significant headway tuning these packages by bringing down response times from 7 minutes to under 3 minutes. But this is not an acceptable response time from a web-application perspective. I am considering creating data cubes based on the most frequently used join conditions and pre-populate them on a nightly basis or use triggers to update the cube simultaneously. I am hoping that this enhance the response times. I would greatly appreciate your suggestions or opinions on this idea. If you have an alternative/better way of achiving this please enlighten me. Thank very much. Srini Rajendran. -- 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).
NetSaint vs BigBrother (was: NetSaint)
On Tue, Jan 29, 2002 at 08:12:05AM -0800, Vergara, Michael (TEM) wrote: Has anybody heard of/used/liked/hated NetSaint? One of our UNIX administrators is pushing this as a cheap alternative to CA UniCenter, and he wants to start using it to monitor systems and databases. Please let me know your opinions, thoughts, and locations of any resources you are aware of. I'd also be especially interested in any comparisons with BigBrother. Has anyone evaluated or used both? Which did you pick? etc. Thanks. Here are some interesting comparisons I've already found: http://userpages.umbc.edu/~smelam1/nsbb.pdf http://ftp.fcaglp.unlp.edu.ar/pub/home/esuarez/usenix/chan.pdf Tim. http://www.netsaint.org/ http://www.bb4.com/ http://bigsister.graeff.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Bunce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Database Performance Question
make sure you are not using any function like upper lower ... as part of the select statement. If yes then by creating function based index will improve the performance dramatically. [EMAIL PROTECTED] 01/29/02 10:35AM Partitions, Materialized views, bit map indexes. -Original Message- Sent: Tuesday, January 29, 2002 10:25 AM To: Multiple recipients of list ORACLE-L Hello all: We have an application that is having slow response time against an 8i database, I would like to improve the response time. This is a web based application accessing the database with about 2000 users. Most of the application queries are based on complex joins on 4 big tables with each having over 5 million rows( biggest table has 18 million rows). I have tuned the Package queries for the best explain plan possible, but still do not seem to make dramatic change in the response time. Though, I was able to make significant headway tuning these packages by bringing down response times from 7 minutes to under 3 minutes. But this is not an acceptable response time from a web-application perspective. I am considering creating data cubes based on the most frequently used join conditions and pre-populate them on a nightly basis or use triggers to update the cube simultaneously. I am hoping that this enhance the response times. I would greatly appreciate your suggestions or opinions on this idea. If you have an alternative/better way of achiving this please enlighten me. Thank very much. Srini Rajendran. -- 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: 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).
RE: Database Performance Question
Kirti: Thanks for the insight. Here are my Answers: 1. I feel database is the problem because when only a subset of the total data is used the performance is excellent (with one tenth of the total data). The no. of users are the same. Only amount data that is retrieved is enormous (almost 10 times) when we have the performance problem. 2. Partioning may/may not help as it still has to traverse through all of the partitions to get the data required in order to satisfy the join condition. May improve response time but not significantly. 3. I will look into this as well. 4. Connections on the database side are DEDICATED and on the web side they are shared.(Using Microsoft COM objects, have certain set of database connections as POOL that are shared by different users.) Please let me know what you think... Srini -Original Message- Sent: Tuesday, January 29, 2002 11:20 AM To: Multiple recipients of list ORACLE-L You have done very nicely so far in tuning those joins... but... More questions to you : 1. Why do you think this is still a database problem? 2. Will partitioning those larger tables help the queries? 3. What have you checked to make sure that the bottleneck is not the web-server? 4. Are these connections persistent or the app connects/disconnects when accessing the database? Looking for answers to these questions may help you locate other opportunities to improve upon.. - Kirti -Original Message- Sent: Tuesday, January 29, 2002 9:25 AM To: Multiple recipients of list ORACLE-L Hello all: We have an application that is having slow response time against an 8i database, I would like to improve the response time. This is a web based application accessing the database with about 2000 users. Most of the application queries are based on complex joins on 4 big tables with each having over 5 million rows( biggest table has 18 million rows). I have tuned the Package queries for the best explain plan possible, but still do not seem to make dramatic change in the response time. Though, I was able to make significant headway tuning these packages by bringing down response times from 7 minutes to under 3 minutes. But this is not an acceptable response time from a web-application perspective. I am considering creating data cubes based on the most frequently used join conditions and pre-populate them on a nightly basis or use triggers to update the cube simultaneously. I am hoping that this enhance the response times. I would greatly appreciate your suggestions or opinions on this idea. If you have an alternative/better way of achiving this please enlighten me. Thank very much. Srini Rajendran. -- 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: 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: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: RTFM questions (formally RE: PL/SQL)
I guess this is still on topic eh? LoL. -Original Message- And your point caller?? TIC ;o) -Original Message- Sent: 29 January 2002 15:41 To: Multiple recipients of list ORACLE-L No offense to anybody, but I think this is rather arrogant. The list is for anybody (unless the list owner decides it's just for experienced dba's). I am brand new to Oracle, having just started learning it this week. I can easily foresee having what some might consider stupid or RTFM questions, and being possibly unable to find the answer or having problems deciphering the manual. I myself am somewhat of a Word pro (and my vba code samples page is the #1 ranked site of its kind on most major search engines) and I help all kinds of newbies out on a Word list of which I am a member, as do all the other members of the list. Everybody on that list is extremely gracious and nobody complains -- and the people with questions get the help they need, with nobody sitting back going boy are you stupid / lazy. I am hoping that I can get the same kind of help here, when I am ready for it, that I and others give on other lists. --JoJo -Original Message- Sent: Monday, January 28, 2002 10:20 PM To: Multiple recipients of list ORACLE-L The problem is that if you always ask the group for help, you never learn where the information is within the manuals or other reference documentation and the group also gets cluttered with trivia. I agree with you that the list is here to help people and I personally do not mind the odd naive question from a new DBA, but it is the ...can't be bothered to look up the manual.. attitude that is most frustrating. When you ask the format of a command (for example) to the list, you are potentionally asking 1000's of people the same question who will all have to spend the time to filter these questions - we are all busy people and I personally do not want to use my time in this way. I'm sure you can see that this is a much more expensive option than asking the person next to you. Cheers, Craig. -Original Message- mailto:[EMAIL PROTECTED] ] Sent: Tuesday, 29 January 2002 2:55 PM To: Multiple recipients of list ORACLE-L Why do you bother being on this List: The list is here to help fellow DBA'S. Have you never said to one of your collegues , what is the format of this command, or how can I do that, when you simply cant be bothered to look it up in the manual (either your busy or just down right lazy): Sometimes this list is useful for just that. So why dont u lighten up dude. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com 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: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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).
Re: Function In Select Statment
For Oracle 8i use functiion based index. Thanks, Ashoke [EMAIL PROTECTED] 01/29/02 10:05AM Hi List, One of our developer using function in his select statment but the problem is when he is using order by one of the function results column the query is very slow, Is there any way to use hint for function or some thing to make quesry faster. Thanks in advance Hamid Alavi Office 818 737-0526 Cell818 402-1987 The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 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).
Re: Database Performance Question
You may want to look at using materialized views. They are easy to setup and can be refreshed manualy or automaticaly. Thanks, cj SRAJENDRAN@nlf s.comTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Database Performance Question om 01/29/2002 10:25 AM Please respond to ORACLE-L Hello all: We have an application that is having slow response time against an 8i database, I would like to improve the response time. This is a web based application accessing the database with about 2000 users. Most of the application queries are based on complex joins on 4 big tables with each having over 5 million rows( biggest table has 18 million rows). I have tuned the Package queries for the best explain plan possible, but still do not seem to make dramatic change in the response time. Though, I was able to make significant headway tuning these packages by bringing down response times from 7 minutes to under 3 minutes. But this is not an acceptable response time from a web-application perspective. I am considering creating data cubes based on the most frequently used join conditions and pre-populate them on a nightly basis or use triggers to update the cube simultaneously. I am hoping that this enhance the response times. I would greatly appreciate your suggestions or opinions on this idea. If you have an alternative/better way of achiving this please enlighten me. Thank very much. Srini Rajendran. -- 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: Casey Jorda INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: RTFM questions (formally RE: PL/SQL)
Title: RTFM questions (formally RE: PL/SQL) There is a good faq website listed at the base of each email sent to this list. Add to that *every* Oracle manual (authored by Oracle) is hosted in both pdf and (some) html format on the Oracle Technet site (http://otn.oracle.com/docs/content.html). Almost everybody with email access has internet access.. Just my 0.02 sickles Mark -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Sunrise DBASent: 29 January 2002 16:35To: Multiple recipients of list ORACLE-LSubject: Re: RTFM questions (formally RE: PL/SQL) Often, it isn't all that easy to find what you need in "the manual". I have a enough Oracle books to make the springs in my carsag, and sometimes, the answer just isn't there. Mostly yes, but sometimes no. Usually, I have to go through 3 or 4 books before I find an answer I can use. So, if the poor listee only has one or two books, perhaps he doesn't have one that has the answer. Maybe yousenior, high income guys can send him your spare books :-) Or better yet, put a faq together with a book list. Ken Hitchcox - Original Message - From: JoJo Al-Zawawi To: Multiple recipients of list ORACLE-L Sent: Tuesday, January 29, 2002 7:40 AM Subject: RE: RTFM questions (formally RE: PL/SQL) No offense to anybody, butI think this is rather arrogant. The list is for anybody (unless the list owner decides it's just for experienced dba's). I am brand new to Oracle, having just started learning it this week. I can easily foresee having what some might consider stupid orRTFM questions, and being possibly unable to find the answer or having problems deciphering the manual. I myself am somewhat of a Word pro (and my vba code samples page is the #1 ranked site of its kind on most major search engines) and I help all kinds of newbies out on a Word list of which I am a member, as do all the other members of the list. Everybody on that list is extremely gracious and nobody complains -- and the people with questions get the help they need, with nobody sitting back going "boy are you stupid / lazy". I am hoping that I can get the same kind of help here, when I am ready for it, that I and others give on other lists. --JoJo -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Craig MundaySent: Monday, January 28, 2002 10:20 PMTo: Multiple recipients of list ORACLE-LSubject: RTFM questions (formally RE: PL/SQL) The problem is that if you always ask the group for help, you never learn where the information is within the manuals or other reference documentation and the group also gets cluttered with trivia. I agree with you that the list is here to help people and I personally do not mind the odd naive question from a new DBA, but it is the "...can't be bothered to look up the manual.." attitude that is most frustrating. When you ask the format of a command (for example) to the list, you are potentionally asking 1000's of people the same question who will all have to spend the time to filter these questions - we are all busy people and I personally do not want to use my time in this way. I'm sure you can see that this is a much more expensive option than asking the person next to you. Cheers, Craig. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 29 January 2002 2:55 PM To: Multiple recipients of list ORACLE-L Subject: RE: PL/SQL Why do you bother being on this List: The list is here to help fellow DBA'S. Have you never said to one of your collegues , what is the format of this command, or how can I do that, when you simply cant be bothered to look it up in the manual (either your busy or just down right lazy): Sometimes this list is useful for just that. So why dont u lighten up dude. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RTFM questions (formally RE: PL/SQL)
Title: RTFM questions (formally RE: PL/SQL) Hi Ken... Do they have an internet connection? http://docs.oracle.com or http://tahiti.oracle.com It goes a long way... And, as I mentioned in my other email... This person has been pointed at the exact manual on numerous occasions but chooses not to do any reading... He needs to post more questions along the lines of "Where do I look to find the answer to..." and "I looked in the xxx manual but I don't understand ..." This is not a random whack at a poster who asks the occasional question... This rant isdirected at alist abuser... Tim -Original Message-From: Sunrise DBA [mailto:[EMAIL PROTECTED]]Sent: Tuesday, January 29, 2002 11:36 AMTo: Multiple recipients of list ORACLE-LSubject: Re: RTFM questions (formally RE: PL/SQL) Often, it isn't all that easy to find what you need in "the manual". I have a enough Oracle books to make the springs in my carsag, and sometimes, the answer just isn't there. Mostly yes, but sometimes no. Usually, I have to go through 3 or 4 books before I find an answer I can use. So, if the poor listee only has one or two books, perhaps he doesn't have one that has the answer. Maybe yousenior, high income guys can send him your spare books :-) Or better yet, put a faq together with a book list. Ken Hitchcox - Original Message - From: JoJo Al-Zawawi To: Multiple recipients of list ORACLE-L Sent: Tuesday, January 29, 2002 7:40 AM Subject: RE: RTFM questions (formally RE: PL/SQL) No offense to anybody, butI think this is rather arrogant. The list is for anybody (unless the list owner decides it's just for experienced dba's). I am brand new to Oracle, having just started learning it this week. I can easily foresee having what some might consider stupid orRTFM questions, and being possibly unable to find the answer or having problems deciphering the manual. I myself am somewhat of a Word pro (and my vba code samples page is the #1 ranked site of its kind on most major search engines) and I help all kinds of newbies out on a Word list of which I am a member, as do all the other members of the list. Everybody on that list is extremely gracious and nobody complains -- and the people with questions get the help they need, with nobody sitting back going "boy are you stupid / lazy". I am hoping that I can get the same kind of help here, when I am ready for it, that I and others give on other lists. --JoJo -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Craig MundaySent: Monday, January 28, 2002 10:20 PMTo: Multiple recipients of list ORACLE-LSubject: RTFM questions (formally RE: PL/SQL) The problem is that if you always ask the group for help, you never learn where the information is within the manuals or other reference documentation and the group also gets cluttered with trivia. I agree with you that the list is here to help people and I personally do not mind the odd naive question from a new DBA, but it is the "...can't be bothered to look up the manual.." attitude that is most frustrating. When you ask the format of a command (for example) to the list, you are potentionally asking 1000's of people the same question who will all have to spend the time to filter these questions - we are all busy people and I personally do not want to use my time in this way. I'm sure you can see that this is a much more expensive option than asking the person next to you. Cheers, Craig. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 29 January 2002 2:55 PM To: Multiple recipients of list ORACLE-L Subject: RE: PL/SQL Why do you bother being on this List: The list is here to help fellow DBA'S. Have you never said to one of your collegues , what is the format of this command, or how can I do that, when you simply cant be bothered to look it up in the manual (either your busy or just down right lazy): Sometimes this list is useful for just that. So why dont u lighten up dude. -- 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
RE: Database Performance Question
How many rows are you bringing back from a typical query, how good is the best filter condition and are you filtering that first before joining to the other tables in the explain plan? What is the query and explain plan? Iain Nicoll -Original Message- Sent: Tuesday, January 29, 2002 4:20 PM To: Multiple recipients of list ORACLE-L You have done very nicely so far in tuning those joins... but... More questions to you : 1. Why do you think this is still a database problem? 2. Will partitioning those larger tables help the queries? 3. What have you checked to make sure that the bottleneck is not the web-server? 4. Are these connections persistent or the app connects/disconnects when accessing the database? Looking for answers to these questions may help you locate other opportunities to improve upon.. - Kirti -Original Message- Sent: Tuesday, January 29, 2002 9:25 AM To: Multiple recipients of list ORACLE-L Hello all: We have an application that is having slow response time against an 8i database, I would like to improve the response time. This is a web based application accessing the database with about 2000 users. Most of the application queries are based on complex joins on 4 big tables with each having over 5 million rows( biggest table has 18 million rows). I have tuned the Package queries for the best explain plan possible, but still do not seem to make dramatic change in the response time. Though, I was able to make significant headway tuning these packages by bringing down response times from 7 minutes to under 3 minutes. But this is not an acceptable response time from a web-application perspective. I am considering creating data cubes based on the most frequently used join conditions and pre-populate them on a nightly basis or use triggers to update the cube simultaneously. I am hoping that this enhance the response times. I would greatly appreciate your suggestions or opinions on this idea. If you have an alternative/better way of achiving this please enlighten me. Thank very much. Srini Rajendran. -- 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: 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: Nicoll, Iain (Calanais) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: sqlplus question
What ring are you going to give to Kimberly? :-) -Original Message- Sent: Tuesday, January 29, 2002 11:41 AM To: Multiple recipients of list ORACLE-L Kewl! That means I get to start taking drugs again. I am a happy boy. I'll whiz over to the OT list and give Kimberly a ring. Does she like to climb mountains? -Original Message- Sent: Tuesday, January 29, 2002 8:25 AM To: Multiple recipients of list ORACLE-L Walt, don't worry. He's speaking WaReZ speak. You have to follow the White Rabbit to get out. For further instructions, see Kimberly. She enjoys questions like these. -Original Message- I'm lost here... --Walt -Original Message- Sent: Monday, January 28, 2002 10:50 PM To: Multiple recipients of list ORACLE-L Well, you can check the manual but use the package dbms_output.put_job that willfix it when you are inoracle but ifyoua re in unix environment you must use crontab Hope this is of help for you Roland -- 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: Weaver, Walt INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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).
adpatch question
Hi Folks! I'm in the middle of an 11.5.5 upgrade. Now, if you've done that type of thing before, you know those suckers just run forever, and if you leave it running overnight, you generally come in the next day to find that things failed overnight. Well, that's where I was. I left this sucker to run overnight, and, when I came in, sure enough, worker 4 had crapped out with a java error. I checked metalink, and it said skip it, and when you're done with 1808429 (the 11.5.5 upgrade patch), just run asfakreg.jlt manually. Fine. No big deal. I went into adctrl and everything was in a wait state except for ol number 4 which crapped out. I chose hidden option 8 (skip this thing) and the status changed to Skip restart. Great. Except it didn't. Evidently, having no response for X amount of time, all my workers stopped. Again, no big deal, just re-run adpatch and let it start where it crapped out. Well, now we run into a big deal, because it can't change the status from Skip restart to anything that will allow adpatch to start again (like, maybe, failed where it was before I fixed it). I'm thinking of going under the sheets, finding the $%^* table and updating the status myself. Anyone have any reason why that's not such a great idea? Anyone have any other sneaky ways to change the status? Anyone have a list of the hidden options that Oracle doesn't tell you about (like ol number 8 there?)? aTdHvAaNnKcSe! Bambi. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bellows, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Microsoft plans to bundle iFS copycat into it operating system
FYI, http://www.theregister.co.uk/content/4/23852.html They seem to have decided that iFS is not a bad idea, and they will integrate it into their future OS. Same strategy as for Novell's NDS and the Windows Active Directory in Windows2000. A Netscape equivalent into Windows95. OS/2 HPFS which was ported as NT's NTFS. On and on I suppose, if the strategy works, why not continue. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -- 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).
RE: Oracle process causes High CPU
What job(s) are you running? and if you strings core | head -40, what do you get? Inquiring Minds want to know, etc. -Original Message- Sent: Tuesday, January 29, 2002 12:06 PM To: Multiple recipients of list ORACLE-L We have problem with oracle process ora_snp0 that causes high CPU and core files on our system. Does someone have idea how to fix it? Please help. Below is information captured from a trace file: Dump file /export/home/oracle/product/8.0.5/rdbms/log/ssdb_snp0_16657.trc Oracle8 Enterprise Edition Release 8.0.5.2.1 - Production PL/SQL Release 8.0.5.2.0 - Production ORACLE_HOME = /export/home/oracle/product/8.0.5 System name:SunOS Node name: pbna1 Release:5.6 Version:Generic_105181-26 Machine:sun4u Instance name: SSDB Redo thread mounted by this instance: 1 Oracle process number: 8 Unix process pid: 16657, image: ora_snp0_SSDB *** 2002.01.29.03.13.33.000 *** SESSION ID:(7.11) 2002.01.29.03.13.32.000 Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x 5f4c6000 Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x 7f6c7d78 Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x 7f6c7d78Background_Core_Dump = FULL Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
RE: OFF TOPIC: RE: PL/SQL
Will do.. - Kirti -Original Message- Sent: Tuesday, January 29, 2002 11:26 AM To: Multiple recipients of list ORACLE-L Kirti - I haven't read that book, but I haven't seen a bad book in the for Dummies series yet, so I would imagine it is pretty good, especially for beginners. Maybe after you have gone through it you can let us know your opinion, especially whether it is more for beginning Oracle developers or beginning DBAs. Book recommendation is a question that seems to recur on this list. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, January 29, 2002 10:06 AM To: Multiple recipients of list ORACLE-L Has anyone read 'Oracle8i for Dummies' ?? I have checked it out from our local public library It's not a bad read, I am still in chapter 1, though.. learning some new interesting analogies to this techie stuff.. - Kirti -Original Message- Sent: Tuesday, January 29, 2002 8:55 AM To: Multiple recipients of list ORACLE-L beginner should start with RTFM, trying it on test box, and only than, if he still does not get it, post his question explaining his problems. Beth, you must not have seen Roland's questions. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, January 29, 2002 8:45 AM Roland, Besides reading the manuals, take a look at www.lazydba.com. They also host an Oracle email list that might be a more appropriate forum for your questions. I think they have a higher ratio of new DBAs on their list, and seldom mind answering the beginner questions. HTH, Beth (was that so hard guys?) -Original Message- Sent: Tuesday, January 29, 2002 5:21 AM To: Multiple recipients of list ORACLE-L Hear hear ! You tell 'm, Kevin ! I'm with you all the way. Anybody can ask me a simple question when they are looking for a quick answer, but you can't do a good job when you're always looking for quick answers. You have to LEARN. There's a difference between learning and constantly asking questions. Sorry, couldn't resist ... -Oorspronkelijk bericht- Van: Thomas, Kevin [mailto:[EMAIL PROTECTED]] Verzonden: dinsdag 29 januari 2002 9:00 Aan: Multiple recipients of list ORACLE-L Onderwerp: OFF TOPIC: RE: PL/SQL When I arrive in the morning to a mailbox containing 150+ messages from this list, I'm almost certainly guaranteed that 10% of them will be questions that can easily be found via otn or a manual. That 10% usually comes from the same person!! No wonder I'm irritated!!! }:o| -Original Message- Sent: 28 January 2002 17:35 To: Multiple recipients of list ORACLE-L Geez... lay off already. If you don't think the question is worthy of your time, then don't answer it. What a grouch. -Original Message- Sent: Monday, January 28, 2002 11:16 AM To: Multiple recipients of list ORACLE-L RRR TTTFF !! -Original Message- Sent: 28 January 2002 15:46 To: Multiple recipients of list ORACLE-L How can I in a pl/sql block write null if I want null to be inserted in a field when I use dynamic sql.? . I mean nothing is going to be inserted. Thanks in advance Roland -- 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: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seefelt, Beth INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note
RE: Microsoft plans to bundle iFS copycat into it operating syste
Okay ... does anyone know what are Microsoft's own inventions? Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- Sent: Tuesday, January 29, 2002 12:41 PM To: Multiple recipients of list ORACLE-L FYI, http://www.theregister.co.uk/content/4/23852.html They seem to have decided that iFS is not a bad idea, and they will integrate it into their future OS. Same strategy as for Novell's NDS and the Windows Active Directory in Windows2000. A Netscape equivalent into Windows95. OS/2 HPFS which was ported as NT's NTFS. On and on I suppose, if the strategy works, why not continue. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -- 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). *2 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *2
RE: Oracle trace file on/off
Here you go... 1) Find the OSPID for the suspected user (other than pmon, smon and their famiy) select s.username, p.spid from v$session s, v$process p where s.paddr = p.addr; 2) Use oradebug to connect to that spid (here I have 26073, and the session was tracing event 10046) SVRMGR oradebug setospid 26073 Oracle pid: 11, Unix process pid: 26073, image: oracle@myservername (TNS V1-V3) 3) Dump the events for the connected spid... SVRMGR oradebug dump events 1 Statement processed. 4) Look in the trace file in the udump directory.. *** 2002-01-29 09:58:55.847 Dump event group for level SESSION TC Addr Evt#(b10) Action TR AddrArmLife 400E1B68 10046 1 400e1ba8 0 0 TR Name TR level TR address TR arm TR life TR type CONTEXT 8 -1 2 0 ^^^ This session is tracing event 10046 context at level 8 5) Dump it again (from 3)... 6) Look in the trace file again *** 2002-01-29 10:01:57.316 WAIT #1: nam='SQL*Net message from client' ela= 34381 p1=1650815232 p2=1 p3=0 = PARSING IN CURSOR #1 len=56 dep=0 uid=80 oct=42 lid=80 tim=2447763925 hv=3475487367 ad='a0de14e0' alter session set events '10046 trace name context off' END OF STMT PARSE #1:c=0,e=2,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=4,tim=2447763926 EXEC #1:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=2447763927 -- Oops! The the smart A$$ turned off the trace, But got caught!!! Following is what you see in the trace file when the session is not tracing. Dump event group for level SESSION TC Addr Evt#(b10) Action TR AddrArmLife ~ I thank Ross for his nifty hints and his time last night, when I was having a 'brain fart' while testing this... I learned something new from him... :) Cheers! - Kirti -Original Message- Sent: Tuesday, January 29, 2002 11:06 AM To: Multiple recipients of list ORACLE-L Send them doggies home, KD, it's a done deal. ;-) -Original Message- You may turn the trace on or off that way, but how do you interrogate it to find its event settings? - Kirti -Original Message- Sent: Monday, January 28, 2002 6:42 PM To: 'Deshpande, Kirti'; [EMAIL PROTECTED] ORADEBUG SETORAPID, would make current session whatever you like, no? -Original Message- From what I know, there is no way to find if a session has turned on the tracing unless it is your own session. DBMS_SYSTEM.read_ev can you tell you if the current session is tracing or not, but it can not interrogate other sessions. The only way I know is to check the trace files generated in the udump directory.. but it is not fool-proof. And since you can not find out who is tracing at the moment, you can not stop it.. Ross, I sure would like to learn the trick. Can you please post it?? :) Thanks. - Kirti -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] -- 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).