oracle version
Hello All, OS: Solaris DB: Oracle Can somebody tell me how to know in what version or patchset level the oracle home is ? when I go and see in $ORACLE_HOME, I couldn't find whether it is 8.1.7.3 , 8.1.7.4 or 8.1.7.0 or some other. How to know exactly at which version the $ORACLE_HOME is? Thanks and regards, Srinivas __ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: kommareddy sreenivasa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
age out/ flushout sharedpool
Hi All, Is there a way to just flush out a single sql stement from shared pool. Alter system flush shared_pool; will flush whole pool. I want to find out exact time a select statement is taking for execution. when i first executed, it is taking 15 seconds, and the 2nd time, as all of you know , it is taking just a second. I want to just flush that particular SQL from shared pool and re-execute it. Is there a way for this.(changing case didn't help me) Thanks and regards, Srinivas __ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: kommareddy sreenivasa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
create control file failed
Hi All I am recreating the database from cold backup. But I am facing the following problem Oracle version : 8.1.7 Environment : HP SVRMGR CREATE CONTROLFILE REUSE SET DATABASE "HTK443M8" RESETLOGS ARCHIVELOG 2 MAXLOGFILES 32 3 MAXLOGMEMBERS 2 4 MAXDATAFILES 254 5 MAXINSTANCES 8 6 MAXLOGHISTORY 29041 7 LOGFILE 8 GROUP 1 '/oradba/oradata/HTK443M8/redo01.log' SIZE 500K, 9 GROUP 2 '/oradba/oradata/HTK443M8/redo02.log' SIZE 500K, 10 GROUP 3 '/oradba/oradata/HTK443M8/redo03.log' SIZE 500K, 11 GROUP 4 '/oradba/oradata/HTK443M8/redo04.log' SIZE 500K 12 DATAFILE 13 '/oradba/oradata/HTK443M8/system01.dbf', 14 '/oradba/oradata/HTK443M8/tools01.dbf', 15 '/oradba/oradata/HTK443M8/rbs01.dbf', 16 '/oradba/oradata/HTK443M8/temp01.dbf', 17 '/oradba/oradata/HTK443M8/users01.dbf', 18 '/oradba/oradata/HTK443M8/indx01.dbf', 19 '/oradba/oradata/HTK443M8/admin_01.dbf', 20 '/oradba/oradata/HTK443M8/bmpi_01.dbf', 21 '/oradba/oradata/HTK443M8/cnc_01.dbf', 22 '/oradba/oradata/HTK443M8/evnt_mast_01.dbf', 23 '/oradba/oradata/HTK443M8/evnt_othr_01.dbf', 24 '/oradba/oradata/HTK443M8/images_01.dbf', 25 '/oradba/oradata/HTK443M8/lists_01.dbf', 26 '/oradba/oradata/HTK443M8/matrl_01.dbf', 27 '/oradba/oradata/HTK443M8/audit_sis01.dbf', 28 '/oradba/oradata/HTK443M8/audit_sis_idx01.dbf', 29 '/oradba/oradata/HTK443M8/matrl_use_01.dbf', 30 '/oradba/oradata/HTK443M8/modules_01.dbf', 31 '/oradba/oradata/HTK443M8/obs_01.dbf', 32 '/oradba/oradata/HTK443M8/patients_01.dbf', 33 '/oradba/oradata/HTK443M8/pdt_01.dbf', 34 '/oradba/oradata/HTK443M8/personnel_01.dbf', 35 '/oradba/oradata/HTK443M8/quality_01.dbf', 36 '/oradba/oradata/HTK443M8/schedules_01.dbf', 37 '/oradba/oradata/HTK443M8/script_01.dbf', 38 '/oradba/oradata/HTK443M8/admin_idx_01.dbf', 39 '/oradba/oradata/HTK443M8/bmpi_idx_01.dbf', 40 '/oradba/oradata/HTK443M8/cnc_idx_01.dbf', 41 '/oradba/oradata/HTK443M8/rbs1_01.dbf', 42 '/oradba/oradata/HTK443M8/evnt_mast_idx_01.dbf', 43 '/oradba/oradata/HTK443M8/evnt_othr_idx_01.dbf', 44 '/oradba/oradata/HTK443M8/images_idx_01.dbf', 45 '/oradba/oradata/HTK443M8/lists_idx_01.dbf', 46 '/oradba/oradata/HTK443M8/matrl_idx_01.dbf', 47 '/oradba/oradata/HTK443M8/matrl_use_idx_01.dbf', 48 '/oradba/oradata/HTK443M8/modules_idx_01.dbf', 49 '/oradba/oradata/HTK443M8/rbs2_01.dbf', 50 '/oradba/oradata/HTK443M8/obs_idx_01.dbf', 51 '/oradba/oradata/HTK443M8/patients_idx_01.dbf', 52 '/oradba/oradata/HTK443M8/pdt_idx_01.dbf', 53 '/oradba/oradata/HTK443M8/personnel_idx_01.dbf', 54 '/oradba/oradata/HTK443M8/quality_idx_01.dbf', 55 '/oradba/oradata/HTK443M8/schedules_idx_01.dbf', 56 '/oradba/oradata/HTK443M8/script_idx_01.dbf', 57 '/oradba/oradata/HTK443M8/interface_01.dbf', 58 '/oradba/oradata/HTK443M8/drsys01.dbf', 59 '/oradba/oradata/HTK443M8/quest01.dbf', 60 '/oradba/oradata/HTK443M8/crystal_report_01.dbf', 61 '/oradba/oradata/HTK443M8/crystal_report_idx_01.dbf', 62 '/oradba/oradata/HTK443M8/interface_idx_01.dbf', 63 '/oradba/oradata/HTK443M8/sisweb_01.dbf', 64 '/oradba/oradata/HTK443M8/rules_engine_01.dbf' 65 CHARACTER SET US7ASCII 66 ;CREATE CONTROLFILE REUSE SET DATABASE "HTK443M8" RESETLOGS ARCHIVELOG*ORA-01503: CREATE CONTROLFILE failedORA-01565: error in identifying file '/oradba/oradata/HTK443M8/audit_sis01.dbf'ORA-27046: file size is not a multiple of logical block sizeAdditional information: 1SVRMGR spool off I verified with metalink, It is saying this is due to incorrect DB_BLOCK_SIZE parameter. But I am sure there is no change in this parameter. Any thoughts/suggestions in this regard very much appreciated. Banarasi Babu OCP, DBA
RE: Slow query
two functions versus one maybe -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: woensdag 5 maart 2003 7:34To: Multiple recipients of list ORACLE-LSubject: Slow queryDear all, Please find below the 2 queries : select dep_date from test_date1 where to_char(dep_date,'dd-mon-') = '12-jan-2002' select dep_date from test_date1 where TRUNC(dep_date) = to_DATE( '12-jan-2002','dd-mon-') The execution plan for both the queries shows a FTS on test_date1. Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE 1 0 SORT (AGGREGATE) 2 1 TABLE ACCESS (FULL) OF 'TEST_DATE1' The number of rows to be retrieved are 120010. The first query took 10msec to execute whereas the second took about 2 secs. Could anyone help me figure out what the problem would be. TIA Best RegardsJai
Re: Slow query
Which version of Oracle ? The second query has to do a trunc() and a to_date() on every single row. The first only has to do a to_char on every single row. There is a CPU difference between the two queries and if you run the execution plan through v9 with cpu_costing, you will find a difference in cost - though probably not enough to agree with your clock test. A simple test on 8.1.7.4 and 9.2.0.2 where I created a table of 128,000 rows with a date column scattered inside a single date showed that one query used about twice the CPU of the other in v9, and four times in v8. (Unfortunately, in all cases, the CPU reported by Oracle was consistently larger than the elapsed time reported by SQL*Plus). First check, though, is the test repeatable, or did something happen elsewhere to affect the elapsed time. (e.g. was one tested subject to a lot of delayed block cleanout). NB - The execution plan shown is not the plan for either of the two statements, and I am fairly sure that neither statement could actually return 120,000 rows in 10 ms. Do your timings refer to a test where you changed the query to do a count() ? Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon one-day tutorials: Cost Based Optimisation Trouble-shooting and Tuning Indexing Strategies (see http://www.jlcomp.demon.co.uk/tutorial.html ) UK___March 19th UK___April 8th UK___April 22nd USA_(FL)_May 2nd Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) USA_(CA, TX)_August The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: 05 March 2003 06:33 Dear all, Please find below the 2 queries : select dep_date from test_date1 where to_char(dep_date,'dd-mon-') = '12-jan-2002' select dep_date from test_date1 where TRUNC(dep_date) = to_DATE( '12-jan-2002','dd-mon-') The execution plan for both the queries shows a FTS on test_date1. Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE 10 SORT (AGGREGATE) 21 TABLE ACCESS (FULL) OF 'TEST_DATE1' The number of rows to be retrieved are 120010. The first query took 10msec to execute whereas the second took about 2 secs. Could anyone help me figure out what the problem would be. TIA Best Regards Jai -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Slow query
Dear all, Please find below the 2 queries : select dep_date from test_date1 where to_char(dep_date,'dd-mon-') = '12-jan-2002' select dep_date from test_date1 where TRUNC(dep_date) = to_DATE( '12-jan-2002','dd-mon-') The execution plan for both the queries shows a FTS on test_date1. Execution Plan 0 SELECT STATEMENT Optimizer=CHOOSE 10 SORT (AGGREGATE) 21 TABLE ACCESS (FULL) OF 'TEST_DATE1' The number of rows to be retrieved are 120010. The first query took 10msec to execute whereas the second took about 2 secs. Could anyone help me figure out what the problem would be. TIA Best Regards Jai --- --- Which problem? I guess that, if the execution plans are identical, what you are experiencing is just the effect of caching. For a reason or another the data already was in memory in one case, and had to be loaded from disk in the other one. Check your trace statistics under SQL*Plus, logical IOs will probably be more or less identical and physical IOs wildly different. Note that as long as you apply a function to dep_date, your only way to escape the FTS is (supposing 8.1.7 or above) function-based indexes. If dep_date is indexed, then you should use something like dep_date = some_date and dep_date some_date + 1 instead of trunc(dep_date) = some_date It will allow for range scans. Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: oracle version
From sql : select * from product_component_version; It can either be shown when logging into sqlplus (check the headers). Kind Regards, Hatzistavrou Yannis Database Administrator SchlumbergerSema Phone ext. 478 Email: [EMAIL PROTECTED] -Original Message- Sent: Wednesday, March 05, 2003 9:49 AM To: Multiple recipients of list ORACLE-L Hello All, OS: Solaris DB: Oracle Can somebody tell me how to know in what version or patchset level the oracle home is ? when I go and see in $ORACLE_HOME, I couldn't find whether it is 8.1.7.3 , 8.1.7.4 or 8.1.7.0 or some other. How to know exactly at which version the $ORACLE_HOME is? Thanks and regards, Srinivas __ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: kommareddy sreenivasa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hatzistavrou John INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: create control file failed
So the obvious question: What is the db_block_size and what is the size in bytes of /oradba/oradata/HTK443M8/audit_sis01.dbf as it was restored from backup? -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Wed, 5 Mar 2003, BanarasiBabu Tippa wrote: I am recreating the database from cold backup. But I am facing the following problem Oracle version : 8.1.7 Environment : HP SVRMGR CREATE CONTROLFILE REUSE SET DATABASE HTK443M8 RESETLOGS ARCHIVELOG 2 MAXLOGFILES 32 3 MAXLOGMEMBERS 2 4 MAXDATAFILES 254 5 MAXINSTANCES 8 6 MAXLOGHISTORY 29041 7 LOGFILE 8 GROUP 1 '/oradba/oradata/HTK443M8/redo01.log' SIZE 500K, 9 GROUP 2 '/oradba/oradata/HTK443M8/redo02.log' SIZE 500K, 10 GROUP 3 '/oradba/oradata/HTK443M8/redo03.log' SIZE 500K, 11 GROUP 4 '/oradba/oradata/HTK443M8/redo04.log' SIZE 500K 12 DATAFILE 13 '/oradba/oradata/HTK443M8/system01.dbf', 14 '/oradba/oradata/HTK443M8/tools01.dbf', 15 '/oradba/oradata/HTK443M8/rbs01.dbf', 16 '/oradba/oradata/HTK443M8/temp01.dbf', 17 '/oradba/oradata/HTK443M8/users01.dbf', 18 '/oradba/oradata/HTK443M8/indx01.dbf', 19 '/oradba/oradata/HTK443M8/admin_01.dbf', 20 '/oradba/oradata/HTK443M8/bmpi_01.dbf', 21 '/oradba/oradata/HTK443M8/cnc_01.dbf', 22 '/oradba/oradata/HTK443M8/evnt_mast_01.dbf', 23 '/oradba/oradata/HTK443M8/evnt_othr_01.dbf', 24 '/oradba/oradata/HTK443M8/images_01.dbf', 25 '/oradba/oradata/HTK443M8/lists_01.dbf', 26 '/oradba/oradata/HTK443M8/matrl_01.dbf', 27 '/oradba/oradata/HTK443M8/audit_sis01.dbf', 28 '/oradba/oradata/HTK443M8/audit_sis_idx01.dbf', 29 '/oradba/oradata/HTK443M8/matrl_use_01.dbf', 30 '/oradba/oradata/HTK443M8/modules_01.dbf', 31 '/oradba/oradata/HTK443M8/obs_01.dbf', 32 '/oradba/oradata/HTK443M8/patients_01.dbf', 33 '/oradba/oradata/HTK443M8/pdt_01.dbf', 34 '/oradba/oradata/HTK443M8/personnel_01.dbf', 35 '/oradba/oradata/HTK443M8/quality_01.dbf', 36 '/oradba/oradata/HTK443M8/schedules_01.dbf', 37 '/oradba/oradata/HTK443M8/script_01.dbf', 38 '/oradba/oradata/HTK443M8/admin_idx_01.dbf', 39 '/oradba/oradata/HTK443M8/bmpi_idx_01.dbf', 40 '/oradba/oradata/HTK443M8/cnc_idx_01.dbf', 41 '/oradba/oradata/HTK443M8/rbs1_01.dbf', 42 '/oradba/oradata/HTK443M8/evnt_mast_idx_01.dbf', 43 '/oradba/oradata/HTK443M8/evnt_othr_idx_01.dbf', 44 '/oradba/oradata/HTK443M8/images_idx_01.dbf', 45 '/oradba/oradata/HTK443M8/lists_idx_01.dbf', 46 '/oradba/oradata/HTK443M8/matrl_idx_01.dbf', 47 '/oradba/oradata/HTK443M8/matrl_use_idx_01.dbf', 48 '/oradba/oradata/HTK443M8/modules_idx_01.dbf', 49 '/oradba/oradata/HTK443M8/rbs2_01.dbf', 50 '/oradba/oradata/HTK443M8/obs_idx_01.dbf', 51 '/oradba/oradata/HTK443M8/patients_idx_01.dbf', 52 '/oradba/oradata/HTK443M8/pdt_idx_01.dbf', 53 '/oradba/oradata/HTK443M8/personnel_idx_01.dbf', 54 '/oradba/oradata/HTK443M8/quality_idx_01.dbf', 55 '/oradba/oradata/HTK443M8/schedules_idx_01.dbf', 56 '/oradba/oradata/HTK443M8/script_idx_01.dbf', 57 '/oradba/oradata/HTK443M8/interface_01.dbf', 58 '/oradba/oradata/HTK443M8/drsys01.dbf', 59 '/oradba/oradata/HTK443M8/quest01.dbf', 60 '/oradba/oradata/HTK443M8/crystal_report_01.dbf', 61 '/oradba/oradata/HTK443M8/crystal_report_idx_01.dbf', 62 '/oradba/oradata/HTK443M8/interface_idx_01.dbf', 63 '/oradba/oradata/HTK443M8/sisweb_01.dbf', 64 '/oradba/oradata/HTK443M8/rules_engine_01.dbf' 65 CHARACTER SET US7ASCII 66 ; CREATE CONTROLFILE REUSE SET DATABASE HTK443M8 RESETLOGS ARCHIVELOG * ORA-01503: CREATE CONTROLFILE failed ORA-01565: error in identifying file '/oradba/oradata/HTK443M8/audit_sis01.dbf' ORA-27046: file size is not a multiple of logical block size Additional information: 1 SVRMGR spool off I verified with metalink, It is saying this is due to incorrect DB_BLOCK_SIZE parameter. But I am sure there is no change in this parameter. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Changing of trigger owner
hello, Triggers were created in a user where synonyms of tables of other user s were existing. So i have to change owner of the trigger to the owner of the tables. Is it possible to change without dropping the triggers and recreating them. Thanx, Sudhakar -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: sudhakar Reddy INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
PL/SQL
Hello all, I wanted to know how to write scripts in PL/SQL. i mean how to start it ? directly write htem in sql SQL prompt itself ? and any good sites on PL/SQL to learn ? Thanks and Regards, Santosh
RE: oracle version
select banner from sys.v_$version; will give u the version number santosh -Original Message- sreenivasa Sent: Wednesday, March 05, 2003 1:19 PM To: Multiple recipients of list ORACLE-L Hello All, OS: Solaris DB: Oracle Can somebody tell me how to know in what version or patchset level the oracle home is ? when I go and see in $ORACLE_HOME, I couldn't find whether it is 8.1.7.3 , 8.1.7.4 or 8.1.7.0 or some other. How to know exactly at which version the $ORACLE_HOME is? Thanks and regards, Srinivas __ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: kommareddy sreenivasa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Santosh Varma INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle 9i RAC on Windows using firewire
Hi We are not a Unix shop and would like to build a test setup of 9iRAC on windows at the cheapest price. I have a document that explains how to do it using SCSI disks but the parts here are very expensive. I have heard that it is also possible to use firewire disks to achieve the same. Does anybody have a document detailing this setup? Technet mentions this only for LINUX and not for Windowz TIA Jacob A. van Zanen Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jack van Zanen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: PL/SQL
You can enter them directly at the SQL prompt or you can store them in database or keep them in files and run them with the @ command. The choice is yours :O) K. -Original Message- Sent: 05 March 2003 08:50 To: Multiple recipients of list ORACLE-L Hello all, I wanted to know how to write scripts in PL/SQL. i mean how to start it ? directly write htem in sql SQL prompt itself ? and any good sites on PL/SQL to learn ? Thanks and Regards, Santosh -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Geneva application
Title: Geneva application Hi, I wish to hear from those that have been administrating Oracle instances of Geneva billing application. Kind Regards, Hatzistavrou Yannis Database Administrator SchlumbergerSema Phone ext. 478 Email: [EMAIL PROTECTED]
Re: PL/SQL
Use keyboard! :-) Use any text editor like vim or scite (synatax coloring is better) to write you script and save it to the file. Then run your script from sqlplus prompt (sqlplus:@/home/...path and name of your file). JP On Wednesday 05 March 2003 09:49, you wrote: Hello all, I wanted to know how to write scripts in PL/SQL. i mean how to start it ? directly write htem in sql SQL prompt itself ? and any good sites on PL/SQL to learn ? Thanks and Regards, Santosh -- Pruner Jan [EMAIL PROTECTED] http://jan.pruner.cz/ - Only Robinson Crusoe had all his work done by Friday -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Question related to security
Title: RE: 9i OCP Upgrade Exam - Again That would let the account see ANY table in the database, wouldn't it? Pat. -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]Sent: Tuesday, March 04, 2003 6:05 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Question related to security grant select any table to your developer / Shouldn't this work? Raj - Rajendra dot Jamadagni at espn dot com Any views expressed here are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !! -Original Message-From: Meng, Dennis [mailto:[EMAIL PROTECTED]Sent: Tuesday, March 04, 2003 4:05 PMTo: Multiple recipients of list ORACLE-LSubject: Question related to security Hi all - I have an interesting problem at hand - we have a request from a developer that ask to access some tables owned by a user generated by third party app. Since I don't have the password for this user and system/sys do not have admin option on these tables, I can't grant select to the developer. Changing password for this app can be tricky and will be used as last resort. My question is is there anything else I can do to meet this request? Thanks Dennis
Access Internet Web pages from SQL or PL/SQL
i am getting the following error when i give the select statement.. what could be the reason ? SQL select utl_http.request('http://www.orafaq.net/') from dual;select utl_http.request('http://www.orafaq.net/') from dual *ERROR at line 1:ORA-06510: PL/SQL: unhandled user-defined exceptionORA-06512: at "SYS.UTL_HTTP", line 174ORA-06512: at line 1 Thanks and Regards, Santosh Varma
RE: Slow query
A small follow up question: Why will oracle do a to_date() on second query for each row returned, as the date mentioned is a literal and doesn't change for the duration of the query. Won't it be calculated once and used for all the rows with trunc() applied to each row? Regards Naveen -Original Message- Sent: Wednesday, March 05, 2003 3:04 PM To: Multiple recipients of list ORACLE-L Which version of Oracle ? The second query has to do a trunc() and a to_date() on every single row. The first only has to do a to_char on every single row. There is a CPU difference between the two queries and if you run the execution plan through v9 with cpu_costing, you will find a difference in cost - though probably not enough to agree with your clock test. A simple test on 8.1.7.4 and 9.2.0.2 where I created a table of 128,000 rows with a date column scattered inside a single date showed that one query used about twice the CPU of the other in v9, and four times in v8. (Unfortunately, in all cases, the CPU reported by Oracle was consistently larger than the elapsed time reported by SQL*Plus). First check, though, is the test repeatable, or did something happen elsewhere to affect the elapsed time. (e.g. was one tested subject to a lot of delayed block cleanout). NB - The execution plan shown is not the plan for either of the two statements, and I am fairly sure that neither statement could actually return 120,000 rows in 10 ms. Do your timings refer to a test where you changed the query to do a count() ? Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon one-day tutorials: Cost Based Optimisation Trouble-shooting and Tuning Indexing Strategies (see http://www.jlcomp.demon.co.uk/tutorial.html ) UK___March 19th UK___April 8th UK___April 22nd USA_(FL)_May 2nd Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) USA_(CA, TX)_August The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: 05 March 2003 06:33 Dear all, Please find below the 2 queries : select dep_date from test_date1 where to_char(dep_date,'dd-mon-') = '12-jan-2002' select dep_date from test_date1 where TRUNC(dep_date) = to_DATE( '12-jan-2002','dd-mon-') The execution plan for both the queries shows a FTS on test_date1. Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE 10 SORT (AGGREGATE) 21 TABLE ACCESS (FULL) OF 'TEST_DATE1' The number of rows to be retrieved are 120010. The first query took 10msec to execute whereas the second took about 2 secs. Could anyone help me figure out what the problem would be. TIA Best Regards Jai -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). DISCLAIMER: This message (including attachment if any) is confidential and may be privileged. Before opening attachments please check them for viruses and defects. MindTree Consulting Private Limited (MindTree) will not be responsible for any viruses or defects or any forwarded attachments emanating either from within MindTree or outside. If you have received this message by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle Tools
Hi gurus, Is there any Oracle tools available to use it in Handheld Computers.(like PDA or IPAQ) Thks in advance
8i databases under 9i listener?
Title: 8i databases under 9i listener? RS6000 running AIX 4.3.3. We are experiencing the following issues with our 8.1.7.4 databases under a 9.2.0.1 listener. 1) PL/SQL procedures utilizing UTL_FILE fail with INVALID_PATH errors when attempting to open a file. 2) Database links from WE8ISO8859P1 databases to UTF8 databases fail with ORA-3113. Database links work fine as long as the character set is the same on both databases. We've checked, and double-check, all environment variables, O/S permissions, and so forth. Oracle Support has been basically useless. Eventually, they stated that these problems are unique to the AIX platform, and not something that they've seen on HP or Solaris, and recommended running both the 8i and 9i listeners, in other words, they had no clue. The sequence of events went like this: Feb 7th -- 9.2.0.1 was installed on our test/development box, on which there are eight 8.1.7.4 instances running. Feb 14th -- We startup the 9i listener and shutdown the 8i listener. Feb 21st -- First upgrade of an 8.1.7.4 database to 9.2.0.1. The upgrade was successful. The funny thing is that none of the 8.1.7.4 databases had any problems with the 9i listener from Feb 14th to Feb 21st, either with UTL_FIL or with database links. But on Feb 21st, after the first 9.2.0.1 database upgrade, the 9i listener was bounced for the first time since it's inception, and then all the problems started. We are back to running both an 8i and 9i listener for the time being, but I have a lurking suspicion that something is not right somewhere, and could come back and bite us in the future. Jeffery D Thomas DBA Thomson Information Services Thomson, Inc. Email: [EMAIL PROTECTED] Indy DBA Master Documentation available at: http://gkmqp.tce.com/tis_dba Select 'Indy DBA' then 'DBA Web Pages' --- As of February 12, 2003 Thomson unified its email addresses on a worldwide basis. Please note my new email address: [EMAIL PROTECTED] Thomson is the leader in solutions and technologies for the entertainment and media industries and serves its customers under its four strategic brands: Technicolor, Grass Valley, RCA and THOMSON. More about Thomson: http://www.thomson.net/videochain
Re: PL/SQL
Aside from docs at technet.oracle.com, a perfect book for you is Beginning Oracle Programming, authored by Sean Dillon, Christopher Beck, and Tom Kyte. (ISBN # 1-861006-90-X) This book sells for around $50.00 in the U.S., but it is one of the most useful books I ever purchased. Darrell Landrum [EMAIL PROTECTED] 03/05/03 02:49AM Hello all, I wanted to know how to write scripts in PL/SQL. i mean how to start it ? directly write htem in sql SQL prompt itself ? and any good sites on PL/SQL to learn ? Thanks and Regards, Santosh -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Darrell Landrum INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle Tools
Sulatan, Have a look at xb.com. There is something called PocketDBA. KG --- Sultan [EMAIL PROTECTED] wrote: Hi gurus, Is there any Oracle tools available to use it in Handheld Computers.(like PDA or IPAQ) Thks in advance = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle Tools
Checkout Oracle Lite Babu Sultan [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Sent by: Subject: Oracle Tools [EMAIL PROTECTED] 03/05/03 06:49 AM Please respond to ORACLE-L Hi gurus, Is there any Oracle tools available to use it in Handheld Computers.(like PDA or IPAQ) Thks in advance _ This e-mail transmission and any attachments to it are intended solely for the use of the individual or entity to whom it is addressed and may contain confidential and privileged information. If you are not the intended recipient, your use, forwarding, printing, storing, disseminating, distribution, or copying of this communication is prohibited. If you received this communication in error, please notify the sender immediately by replying to this message and delete it from your computer. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle 9i RAC on Windows using firewire
Jack, www.tusc.com has a white paper that created a RAC with firewire and RedHat8.0 /w kernell upgrade for under $1500.00. Authored by M.Ault and presented at the SEOUG Conference last month. Ron [EMAIL PROTECTED] 03/05/03 06:34AM Hi We are not a Unix shop and would like to build a test setup of 9iRAC on windows at the cheapest price. I have a document that explains how to do it using SCSI disks but the parts here are very expensive. I have heard that it is also possible to use firewire disks to achieve the same. Does anybody have a document detailing this setup? Technet mentions this only for LINUX and not for Windowz TIA Jacob A. van Zanen Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jack van Zanen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
PLSQL stored procedure
Hi. i need some help. i'm trying to get a stored procedure source code from the database. After a lot of reding i found : select * from user_objects where object_type='PROCEDURE'; and i've got the name and Object_id of that prodedure but i have no ideea how to get the rest :( please help, adrian -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Adrian Ciocildau INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Tools
Hi Sultan, Yes there is :) PocketDBA is built exactly for this purpose, and at this time is the only DBA specific tool that I have seen in the market - apart from the up and coming EM2GO product, which AFAIK is not generally available yet. Expand Beyond are the authors of PocketDBA, and have a world wide network of resellers. You can locate your nearest reseller on their web site http://www.xb.com. Their CEO is (was? I haven't seen you post in a while Ari) a member of this list.. If you have any further questions about the tool that you want answered, you can send me a mail off list if you like (we are Expand Beyond's UK reseller). Regards Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -Original Message- Sent: 05 March 2003 11:49 To: Multiple recipients of list ORACLE-L Hi gurus, Is there any Oracle tools available to use it in Handheld Computers.(like PDA or IPAQ) Thks in advance -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Apache and mod_plsql
We are running 9iAS. If I understand this correctly, 9iAS is simply Apache with a PL/SQL module from Oracle. Our management would like to save the Oracle Support dollars for 9iAS, so I am looking into alternatives. We use the PL/SQL web packages, so my options are limited unless we choose to rewrite code. My questions are: 1) Is it possible to add the (or a) PL/SQL module to Apache without going through Oracle - or does the combination of the two simply give you 9iAS, which is an Oracle product? 2) Any comments or experience with DBPrism (http://www.plenix.com/dbprism/), which is the only possible alternative that I have found so far? I've been trying to read about modowa (http://www.sharemation.com/~dmcmahon/modowa.htm) but the server is down at the moment. Thank you, Jay **DISCLAIMER This e-mail message and any files transmitted with it are intended for the use of the individual or entity to which they are addressed and may contain information that is privileged, proprietary and confidential. If you are not the intended recipient, you may not use, copy or disclose to anyone the message or any information contained in the message. If you have received this communication in error, please notify the sender and delete this e-mail message. The contents do not represent the opinion of DE except to the extent that it relates to their official business. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: advanced replication knowledge resources
Hello Robert We are working with advance replication in 8.1.6.3.4. You need the following in the instances: global_names = true unique global name in each database job_queue_processes = 10 ( at least) archive enabled I will send you offline the script that I use to create replication. It does all the job from start to end. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, March 05, 2003 12:20 AM We'll need to set up multi-master replication between two 8.1.7 databases within the next few months. We're not experienced with replication beyond relatively simple snapshots and snapshot groups. Can anyone suggest good training, web, and/or printed resources we can use to get up to speed? I see Oracle offers 2 distributed systems courses and the book Oracle Distributed Systems by Charles Dye is available. Any experience with these references? Thanks for you help. Bob Stauffer DE Communications Ephrata, PA USA [EMAIL PROTECTED] **DISCLAIMER This e-mail message and any files transmitted with it are intended for the use of the individual or entity to which they are addressed and may contain information that is privileged, proprietary and confidential. If you are not the intended recipient, you may not use, copy or disclose to anyone the message or any information contained in the message. If you have received this communication in error, please notify the sender and delete this e-mail message. The contents do not represent the opinion of DE except to the extent that it relates to their official business. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robert Stauffer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Question related to security
Why don't you use the trick for restoring the password? select 'alter user APPUSER identified by values '''||password||''';' from sys.dba_users where username = 'APPUSER'; save the resulting alter user statement Now, change the password for your third part vendor app, login as the user, grant the select on the tables (preferably to a role), log out, and change the password back to what it was. Jay [EMAIL PROTECTED] 03/05/03 07:34AM That would let the account see ANY table in the database, wouldn't it? Pat. -Original Message- Sent: Tuesday, March 04, 2003 6:05 PM To: Multiple recipients of list ORACLE-L grant select any table to your developer / Shouldn't this work? Raj - Rajendra dot Jamadagni at espn dot com Any views expressed here are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !! -Original Message- Sent: Tuesday, March 04, 2003 4:05 PM To: Multiple recipients of list ORACLE-L Hi all - I have an interesting problem at hand - we have a request from a developer that ask to access some tables owned by a user generated by third party app. Since I don't have the password for this user and system/sys do not have admin option on these tables, I can't grant select to the developer. Changing password for this app can be tricky and will be used as last resort. My question is is there anything else I can do to meet this request? Thanks Dennis **DISCLAIMER This e-mail message and any files transmitted with it are intended for the use of the individual or entity to which they are addressed and may contain information that is privileged, proprietary and confidential. If you are not the intended recipient, you may not use, copy or disclose to anyone the message or any information contained in the message. If you have received this communication in error, please notify the sender and delete this e-mail message. The contents do not represent the opinion of DE except to the extent that it relates to their official business. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:PLSQL stored procedure
Adrian, Look in USER_SOURCE. The TEXT field will have the source code. Dick Goulet Reply Separator Author: Adrian Ciocildau [EMAIL PROTECTED] Date: 3/5/2003 5:34 AM Hi. i need some help. i'm trying to get a stored procedure source code from the database. After a lot of reding i found : select * from user_objects where object_type='PROCEDURE'; and i've got the name and Object_id of that prodedure but i have no ideea how to get the rest :( please help, adrian -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Adrian Ciocildau INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re[2]: PL/SQL
Santosh, Add to that Oracle Builtin Packages from O'Reilly. Dick Goulet Reply Separator Author: Darrell Landrum [EMAIL PROTECTED] Date: 3/5/2003 5:19 AM Aside from docs at technet.oracle.com, a perfect book for you is Beginning Oracle Programming, authored by Sean Dillon, Christopher Beck, and Tom Kyte. (ISBN # 1-861006-90-X) This book sells for around $50.00 in the U.S., but it is one of the most useful books I ever purchased. Darrell Landrum [EMAIL PROTECTED] 03/05/03 02:49AM Hello all, I wanted to know how to write scripts in PL/SQL. i mean how to start it ? directly write htem in sql SQL prompt itself ? and any good sites on PL/SQL to learn ? Thanks and Regards, Santosh -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Darrell Landrum INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Access Internet Web pages from SQL or PL/SQL
Works for me. -Original Message-From: Santosh Varma [mailto:[EMAIL PROTECTED]Sent: woensdag 5 maart 2003 13:05To: Multiple recipients of list ORACLE-LSubject: Access Internet Web pages from SQL or PL/SQL i am getting the following error when i give the select statement.. what could be the reason ? SQL select utl_http.request('http://www.orafaq.net/') from dual;select utl_http.request('http://www.orafaq.net/') from dual *ERROR at line 1:ORA-06510: PL/SQL: unhandled user-defined exceptionORA-06512: at "SYS.UTL_HTTP", line 174ORA-06512: at line 1 Thanks and Regards, Santosh Varma
Re[2]: Oracle Tools
We had a look at PocketDBA a year ago. Damn nice technology, problem we had was access to the wireless services at the time. They did not extend very far north of Boston Ma. Still don't get out to where we really need it, like the back woods of NH. It's a three tier sort of application. You have a client piece on your PDA, a server inside the firewall and then your databases. You'll need an encryption key to from someone (they specify sources) to run an encrypted SSL connection. NOTE: Use a fairly beefy machine for the internal server that preferably has nothing else to do. Dick Goulet Reply Separator Author: K Gopalakrishnan [EMAIL PROTECTED] Date: 3/5/2003 4:34 AM Sulatan, Have a look at xb.com. There is something called PocketDBA. KG --- Sultan [EMAIL PROTECTED] wrote: Hi gurus, Is there any Oracle tools available to use it in Handheld Computers.(like PDA or IPAQ) Thks in advance = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RMAN resync of catalog to controlfile
Robert, and all of you other RMAN gurus. scenario 1: repository unavailable, so rman backup was done using controlfile only. upon later successful connection to repository, the backup info was pushed from controlfile to repository(YEA). scenario 2: I have to rebuild the controlfile and have a rman repository. so i do a resync in rman, rebuild the controlfile and connect back to repository, doing a resync HOPING that the controlfile gets updated with info from repository, no such luck. I did a dump of the controlfile(via alter session set events 'immediate trace name controlf level 10'), looking for the section on BACKUP SET RECORDS and BACKUP PIECE RECORDS and there is nothing there. so my question is this: is the resync only a one way push, i understand oracle's mentality about not overwriting the backup records in the controlfile since that should be the true information, but is there a way to force oracle/rman to push the repository info back into the controlfile, i've not found a solution for this. if anyone is interested in the dump files, let me know and i'll make them available on the web so you can see what I'm talking about. thanks, joe Joseph S Testa Chief Technology Officer Data Management Consulting p: 614-791-9000 f: 614-791-9001 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joseph S Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle 9i RAC on Windows using firewire
Try OakTable Network. They have a paper on Windows RAC setup details. http://www.oaktable.net/userFiles.jsp. Arup Nanda - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, March 05, 2003 6:34 AM Hi We are not a Unix shop and would like to build a test setup of 9iRAC on windows at the cheapest price. I have a document that explains how to do it using SCSI disks but the parts here are very expensive. I have heard that it is also possible to use firewire disks to achieve the same. Does anybody have a document detailing this setup? Technet mentions this only for LINUX and not for Windowz TIA Jacob A. van Zanen Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jack van Zanen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arup Nanda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: PLSQL stored procedure
SYS.USER_SOURCE JP On Wednesday 05 March 2003 14:34, Adrian Ciocildau wrote: Hi. i need some help. i'm trying to get a stored procedure source code from the database. After a lot of reding i found : select * from user_objects where object_type='PROCEDURE'; and i've got the name and Object_id of that prodedure but i have no ideea how to get the rest :( please help, adrian -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle Tools
Sure, checkout the Oracle Lite from OTN. - Original Message - From: Sultan To: Multiple recipients of list ORACLE-L Sent: Wednesday, March 05, 2003 6:49 AM Subject: Oracle Tools Hi gurus, Is there any Oracle tools available to use it in Handheld Computers.(like PDA or IPAQ) Thks in advance
Re: PLSQL stored procedure
select text from dba_source --if you don't have access to dba_source try all_source or user_source where name = your source name here / [EMAIL PROTECTED] 03/05/03 06:34AM Hi. i need some help. i'm trying to get a stored procedure source code from the database. After a lot of reding i found : select * from user_objects where object_type='PROCEDURE'; and i've got the name and Object_id of that prodedure but i have no ideea how to get the rest :( please help, adrian -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Adrian Ciocildau INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Todd Arave INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Question related to security
Title: RE: 9i OCP Upgrade Exam - Again Pat, You have twochoices ... 1. either you log in as the schema and grant access to see selected tables This isn't possible (or is the last resort) 2. SELECT ANY Easy, but as you mention a potential security risk When I have limited choices with a vendor app, I'd rather not mess with vendor code without their approval (please don't confuse this to my messing around with writing code to workaround Oracle bugs, thank you). Raj - Rajendra dot Jamadagni at espn dot com Any views expressed here are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !! -Original Message-From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]Sent: Wednesday, March 05, 2003 7:35 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Question related to security That would let the account see ANY table in the database, wouldn't it? Pat. -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]Sent: Tuesday, March 04, 2003 6:05 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Question related to security grant select any table to your developer / Shouldn't this work? Raj - Rajendra dot Jamadagni at espn dot com Any views expressed here are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !! -Original Message-From: Meng, Dennis [mailto:[EMAIL PROTECTED]Sent: Tuesday, March 04, 2003 4:05 PMTo: Multiple recipients of list ORACLE-LSubject: Question related to security Hi all - I have an interesting problem at hand - we have a request from a developer that ask to access some tables owned by a user generated by third party app. Since I don't have the password for this user and system/sys do not have admin option on these tables, I can't grant select to the developer. Changing password for this app can be tricky and will be used as last resort. My question is is there anything else I can do to meet this request? Thanks Dennis 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: HP OpenView Service Desk
Ethan - We just have it in pilot with a single user, so I don't think that will help you. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, March 04, 2003 2:04 PM To: Multiple recipients of list ORACLE-L Anyone running Oracle to support HP OpenView Service Desk, would like to know # of users supported, options and size of system? Thanks, Ethan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: DUMP FILE SIZE
Check Oracle MetaLink Note 108723.1. There seems to be a problem when a numeric value is specified for max_dump_file_size, rather than a K or M at the end. In short, change max_dump_file_size to 10K from 10240, bounce it and retry.HTH.Arup Nanda- Original Message - From: shuan.tay(PCI) To: Multiple recipients of list ORACLE-L Sent: Tuesday, March 04, 2003 9:49 PMSubject: DUMP FILE SIZEDear all,There's a line in .trc file:"DUMP FILE SIZE IS LIMITED TO 0 BYTES"."show parameter dump" in sqlplus output:NAME TYPE VALUE --- --background_core_dump string partialbackground_dump_dest string $ORACLE_HOME/rdbms/tracecore_dump_dest string ?/dbsmax_dump_file_size string 10240shadow_core_dump string PARTIALuser_dump_dest string $ORACLE_HOME/rdbms/traceThe value for max_dump_file_size is exactly same as 10240.So what's wrong with that?The directory permission for the dump destination is drwxr-xr-xBy the way,I'm using Oracle 8.1.6 on Redhat 7.2Thanks in advance.
RE: Apache and mod_plsql
The O'Reilly book Oracle and Open Source says DBPrism is a continuation of / based on OWSKiller, and is one of the most astonishing success stories of Java, Oracle, and open source cooperation. (p.299). They explain how to install it, how to use it, adapters you can get for it, including Cocoon (a Java publishing framework). Pat. -Original Message- Sent: Wednesday, March 05, 2003 10:06 AM To: Multiple recipients of list ORACLE-L We are running 9iAS. If I understand this correctly, 9iAS is simply Apache with a PL/SQL module from Oracle. Our management would like to save the Oracle Support dollars for 9iAS, so I am looking into alternatives. We use the PL/SQL web packages, so my options are limited unless we choose to rewrite code. My questions are: 1) Is it possible to add the (or a) PL/SQL module to Apache without going through Oracle - or does the combination of the two simply give you 9iAS, which is an Oracle product? 2) Any comments or experience with DBPrism (http://www.plenix.com/dbprism/), which is the only possible alternative that I have found so far? I've been trying to read about modowa (http://www.sharemation.com/~dmcmahon/modowa.htm) but the server is down at the moment. Thank you, Jay **DISCLAIMER This e-mail message and any files transmitted with it are intended for the use of the individual or entity to which they are addressed and may contain information that is privileged, proprietary and confidential. If you are not the intended recipient, you may not use, copy or disclose to anyone the message or any information contained in the message. If you have received this communication in error, please notify the sender and delete this e-mail message. The contents do not represent the opinion of DE except to the extent that it relates to their official business. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: PL/SQL
Santosh - I went to http://www.google.com http://www.google.com and searched for the terms PL/SQL tutorial. I received several interesting-looking sites. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, March 05, 2003 2:50 AM To: Multiple recipients of list ORACLE-L Hello all, I wanted to know how to write scripts in PL/SQL. i mean how to start it ? directly write htem in sql SQL prompt itself ? and any good sites on PL/SQL to learn ? Thanks and Regards, Santosh -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Question related to security
Dennis - In reflecting on your question, I have to wonder whether you don't have a larger problem. Since your email address doesn't end in cia.gov, I have to ask whether you as a DBA can adequately manage this application. If I were given this request, I would tell the developer let's go find the person who can authorize your access and they will have the password. I have forgotten the password for some userids, but I would be reluctant to take responsibility for an application where we didn't have the password. Just my 2 cents worth. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, March 04, 2003 3:05 PM To: Multiple recipients of list ORACLE-L Hi all - I have an interesting problem at hand - we have a request from a developer that ask to access some tables owned by a user generated by third party app. Since I don't have the password for this user and system/sys do not have admin option on these tables, I can't grant select to the developer. Changing password for this app can be tricky and will be used as last resort. My question is is there anything else I can do to meet this request? Thanks Dennis -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Re[2]: Oracle Tools
Know what you mean about coverage. I was up at Bretton Woods NH skiing over the Christmas holidays and couldn't get a cell phone to work until I at all. Not sure if that was a bad thing though :-). - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, March 05, 2003 9:19 AM We had a look at PocketDBA a year ago. Damn nice technology, problem we had was access to the wireless services at the time. They did not extend very far north of Boston Ma. Still don't get out to where we really need it, like the back woods of NH. It's a three tier sort of application. You have a client piece on your PDA, a server inside the firewall and then your databases. You'll need an encryption key to from someone (they specify sources) to run an encrypted SSL connection. NOTE: Use a fairly beefy machine for the internal server that preferably has nothing else to do. Dick Goulet Reply Separator Author: K Gopalakrishnan [EMAIL PROTECTED] Date: 3/5/2003 4:34 AM Sulatan, Have a look at xb.com. There is something called PocketDBA. KG --- Sultan [EMAIL PROTECTED] wrote: Hi gurus, Is there any Oracle tools available to use it in Handheld Computers.(like PDA or IPAQ) Thks in advance = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chuck Hamilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Tools
What I meant to say was: and at this time is the only DBA specific tool that I have seen in the market for PDA technology -Original Message- Sent: 05 March 2003 13:35 To: Multiple recipients of list ORACLE-L Hi Sultan, Yes there is :) PocketDBA is built exactly for this purpose, and at this time is the only DBA specific tool that I have seen in the market - apart from the up and coming EM2GO product, which AFAIK is not generally available yet. Expand Beyond are the authors of PocketDBA, and have a world wide network of resellers. You can locate your nearest reseller on their web site http://www.xb.com. Their CEO is (was? I haven't seen you post in a while Ari) a member of this list.. If you have any further questions about the tool that you want answered, you can send me a mail off list if you like (we are Expand Beyond's UK reseller). Regards Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -Original Message- Sent: 05 March 2003 11:49 To: Multiple recipients of list ORACLE-L Hi gurus, Is there any Oracle tools available to use it in Handheld Computers.(like PDA or IPAQ) Thks in advance -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Question related to security
Title: RE: 9i OCP Upgrade Exam - Again Grant select on all tables is not what we were looking for exactly because of the reason brought up by Pat. The following solution provided by Jacques solved the problem - Execute Immediate is for Oracle 8.1 and later. In 7.3.4 you need to use the dbms_sql package for dynamic SQL. The procedure would be something like: create procedure third_party_app_user.grant_priv (table_name_in in varchar2, privileges_in in varchar2, grantee_in varchar2) as c_dynsql pls_integer ; ignore pls_integer ; begin c_dynsql := dbms_sql.open_cursor ; dbms_sql.parse (c_dynsql, 'grant ' || privileges_in || ' on ' || table_name_in || ' to ' || grantee_in, dbms_sql.native) ; ignore := dbms_sql.execute (c_dynsql) ; dbms_sql.close_cursor (c_dynsql) ; exception when others then if dbms_sql.is_open (c_dynsql) then dbms_sql.close_cursor (c_dynsql) ; end if ; raise ; end ; / -Original Message-From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]Sent: Wednesday, March 05, 2003 6:35 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Question related to security That would let the account see ANY table in the database, wouldn't it? Pat. -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]Sent: Tuesday, March 04, 2003 6:05 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Question related to security grant select any table to your developer / Shouldn't this work? Raj - Rajendra dot Jamadagni at espn dot com Any views expressed here are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !! -Original Message-From: Meng, Dennis [mailto:[EMAIL PROTECTED]Sent: Tuesday, March 04, 2003 4:05 PMTo: Multiple recipients of list ORACLE-LSubject: Question related to security Hi all - I have an interesting problem at hand - we have a request from a developer that ask to access some tables owned by a user generated by third party app. Since I don't have the password for this user and system/sys do not have admin option on these tables, I can't grant select to the developer. Changing password for this app can be tricky and will be used as last resort. My question is is there anything else I can do to meet this request? Thanks Dennis
RE: 8i databases under 9i listener?
Title: Message We are also finding difficulties with a mixed Oracle environment. We are running AIX 4.3.3-ML10, Oracle 8.1.7.3-EE-64 bit, PeopleSoft 8.18 and moving to Oracle 9.2.0.2. In the past, when moving to a new Oracle release, we would install the software, upgrade our listener, and then start to upgrade our instances, one by one. This go around, after upgrading our listener to 9.2.0.2, when PeopleSoft tries to connect to a 8.1.7.3 database using the 9.2.0.2 listener, the process fails with the message "ORA-01890 NLS error detected". This is happening both when a PS App Server is connecting to Oracle and when the PS client program connects in 2-tier mode. We didn't see this type of behavior with other tools (SQL+, Toad, etc.) connecting to Oracle, so we thought it was a PS problem and reported it to their support center without much progress. In the mean time, we have reconfigured so that we are now running 2 listeners on the box, one for Oracle 8i and one for Oracle 9iR2. So far, we have not found a problem with Oracle 9iR2 databases interacting with like listeners, but our testing continues. If anyone else on this list can shine some light on this problem, please do. -- *---* Stephen T. Murphy Manager, Database and Technical Support ITS - University Applications Development MSC-100 The University at Albany, S.U.N.Y Albany, New York 1 Phone: (518) 437-4523 Fax: (518) 437-4540 MailTo: [EMAIL PROTECTED] AIM: SMurphy199 -Original Message-From: Thomas Jeff [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 05, 2003 8:05 AMTo: Multiple recipients of list ORACLE-LSubject: 8i databases under 9i listener? RS6000 running AIX 4.3.3. We are experiencing the following issues with our 8.1.7.4 databases under a 9.2.0.1 listener. 1) PL/SQL procedures utilizing UTL_FILE fail with INVALID_PATH errors when attempting to open a file. 2) Database links from WE8ISO8859P1 databases to UTF8 databases fail with ORA-3113. Database links work fine as long as the character set is the same on both databases. We've checked, and double-check, all environment variables, O/S permissions, and so forth. Oracle Support has been basically useless. Eventually, they stated that these problems are unique to the AIX platform, and not something that they've seen on HP or Solaris, and recommended running both the 8i and 9i listeners, in other words, they had no clue. The sequence of events went like this: Feb 7th -- 9.2.0.1 was installed on our test/development box, on which there are eight 8.1.7.4 instances running. Feb 14th -- We startup the 9i listener and shutdown the 8i listener. Feb 21st -- First upgrade of an 8.1.7.4 database to 9.2.0.1. The upgrade was successful. The funny thing is that none of the 8.1.7.4 databases had any problems with the 9i listener from Feb 14th to Feb 21st, either with UTL_FIL or with database links. But on Feb 21st, after the first 9.2.0.1 database upgrade, the 9i listener was bounced for the first time since it's inception, and then all the problems started. We are back to running both an 8i and 9i listener for the time being, but I have a lurking suspicion that something is not right somewhere, and could come back and bite us in the future. Jeffery D Thomas DBA Thomson Information Services Thomson, Inc. Email: [EMAIL PROTECTED] Indy DBA Master Documentation available at: http://gkmqp.tce.com/tis_dba Select 'Indy DBA' then 'DBA Web Pages' --- As of February 12, 2003 Thomson unified its email addresses on a worldwide basis. Please note my new email address: [EMAIL PROTECTED] Thomson is the leader in solutions and technologies for the entertainment and media industries and serves its customers under its four strategic brands: Technicolor, Grass Valley, RCA and THOMSON. More about Thomson: http://www.thomson.net/videochain
RE: PLSQL stored procedure
Hi, The query is: SELECT text FROM user_source WHERE name = 'procname'; Regards, Charu -Original Message- Ciocildau Sent: Wednesday, March 05, 2003 3:04 PM To: Multiple recipients of list ORACLE-L Hi. i need some help. i'm trying to get a stored procedure source code from the database. After a lot of reding i found : select * from user_objects where object_type='PROCEDURE'; and i've got the name and Object_id of that prodedure but i have no ideea how to get the rest :( please help, adrian -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Adrian Ciocildau INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). * Disclaimer This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited. * Visit us at http://www.mahindrabt.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Charu Joshi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: PLSQL stored procedure
SELECT line, text FROM all_source WHEREname = 'YOUR_PROC_NAME' ORDER BY line HTH Istifad -Original Message- Sent: 05 March 2003 13:35 To: Multiple recipients of list ORACLE-L Hi. i need some help. i'm trying to get a stored procedure source code from the database. After a lot of reding i found : select * from user_objects where object_type='PROCEDURE'; and i've got the name and Object_id of that prodedure but i have no ideea how to get the rest :( please help, adrian -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Adrian Ciocildau INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). This e-mail and any attachment is for authorised use by the intended recipient(s) only. It may contain proprietary material, confidential information and/or be subject to legal privilege. It should not be copied, disclosed to, retained or used by, any other party. If you are not an intended recipient then please promptly delete this e-mail and any attachment and all copies and inform the sender. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Virk, Istifad INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle Internet File System
iFS 1.X.X and below is alternately with the 8.1.7 database and 9iAS 1.0.2.X 9iFS 9.0.1 is with the Database CD Pack {on a seperate CD} 9iFS 9.0.2 is part of 9iAS 9.0.2 {on a seperate CD} 9iFS 9.0.3 has been renamed as Oracle Files and is part of Oracle Collaboration Suite. Check the MetaLink certification pages for Internet File System [which goes upto 9.0.1] 9i Internet Application Server [where 9iFS 9.0.2 is listed under components for 9iAS 9.0.2] Oracle Collaboration Suite [where Oracle Files 9.0.3 is listed under components for OCS 9.0.3] Hemant At 04:19 PM 04-03-03 -0800, you wrote: I believe this is free with the Enterprise Edition of the database server, but I have not been able to confirm it. There is certainly no iFS option. Am I correct here or not? Can anyone point me to an Oracle document saying it is free. We are looking at collaboration tools such as SharePoint which takes a SQL Server back end. Oracle is pushing Collaboration Suite, but I am wary of any first release from Oracle especially in an area where their success as been non-existent. I have not seen any specifications for what is needed and iFS may be satisfactory. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Hemant K Chitale My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: PLSQL stored procedure
Look at user_source (or all_source if the procedure is in a different schema). Then select text from user_source where name = 'YOURPROCNAME'; [EMAIL PROTECTED] 03/05/03 07:34AM Hi. i need some help. i'm trying to get a stored procedure source code from the database. After a lot of reding i found : select * from user_objects where object_type='PROCEDURE'; and i've got the name and Object_id of that prodedure but i have no ideea how to get the rest :( please help, adrian -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Adrian Ciocildau INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Darrell Landrum INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Changing of trigger owner
Sudhakar, Unfortunately that's the only way to change teh trigger's ownership. But how does it matter, if you drop and recreate the triggers in another schema? Arup Nanda - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, March 05, 2003 5:19 AM hello, Triggers were created in a user where synonyms of tables of other user s were existing. So i have to change owner of the trigger to the owner of the tables. Is it possible to change without dropping the triggers and recreating them. Thanx, Sudhakar -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: sudhakar Reddy INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arup Nanda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: PLSQL stored procedure
select text from user_source where name = 'PROCEDURE_NAME' order by line; you can do the same for functions, packages and types select text from user_source where name = 'PACKAGE_NAME' and type = 'PACKAGE' order by line; select text from user_source where name = 'PACKAGE_NAME' and type = 'PACKAGE BODY' order by line; also can use dba_source. Cheers, Neil. -Original Message- Sent: 05 March 2003 13:35 To: Multiple recipients of list ORACLE-L Hi. i need some help. i'm trying to get a stored procedure source code from the database. After a lot of reding i found : select * from user_objects where object_type='PROCEDURE'; and i've got the name and Object_id of that prodedure but i have no ideea how to get the rest :( please help, adrian -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Adrian Ciocildau INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: McBain, Neil SITI-ITDIEEE INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Re[2]: Oracle Tools
Also have a look at MobileLynX. Can't figure out for the life of me why the don't advertise this thing. It does most if not all of what PocketDBA does but is also user extensible. It's actually an XML engine but they provide scripts for managing Unix and Oracle as part of the package. If you want to add your own scripts you can. You can use ksh, sh, perl, or anything else you want as long as you format the output as XML. The URL is http://www.mobilelynx.com - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, March 05, 2003 9:19 AM We had a look at PocketDBA a year ago. Damn nice technology, problem we had was access to the wireless services at the time. They did not extend very far north of Boston Ma. Still don't get out to where we really need it, like the back woods of NH. It's a three tier sort of application. You have a client piece on your PDA, a server inside the firewall and then your databases. You'll need an encryption key to from someone (they specify sources) to run an encrypted SSL connection. NOTE: Use a fairly beefy machine for the internal server that preferably has nothing else to do. Dick Goulet Reply Separator Author: K Gopalakrishnan [EMAIL PROTECTED] Date: 3/5/2003 4:34 AM Sulatan, Have a look at xb.com. There is something called PocketDBA. KG --- Sultan [EMAIL PROTECTED] wrote: Hi gurus, Is there any Oracle tools available to use it in Handheld Computers.(like PDA or IPAQ) Thks in advance = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chuck Hamilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: PLSQL stored procedure
Hi, Take a look at: user_source all_source dba_source or for actual table where it is stored, log in as sys and have a look a source$ Regards, Morten Egan Adrian Ciocildau wrote: Hi. i need some help. i'm trying to get a stored procedure source code from the database. After a lot of reding i found : select * from user_objects where object_type='PROCEDURE'; and i've got the name and Object_id of that prodedure but i have no ideea how to get the rest :( please help, adrian -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Morten Egan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fine Grained Access Control (FGCA)
Hi Guys, I am trying to setup FGCA for our customers on their reporting system. I have got this working for a single table, however, when a policy needs to be added for multiple tables. It fails returning no rows from the second table. Oracle documentation is not very helpful this arena. Can anyone provide any pointers to white papers or documents on this subject. Thanks MenonDo you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, and more
RE: Oracle 9i RAC on Windows using firewire
Jack, Have you had a chat with Tom to see if they have upgraded the current $1000 RAC paper for windows? I think it was mentioned in the paper that they planned to.. Mark -Original Message- Sent: 05 March 2003 14:06 To: Multiple recipients of list ORACLE-L Jack, www.tusc.com has a white paper that created a RAC with firewire and RedHat8.0 /w kernell upgrade for under $1500.00. Authored by M.Ault and presented at the SEOUG Conference last month. Ron [EMAIL PROTECTED] 03/05/03 06:34AM Hi We are not a Unix shop and would like to build a test setup of 9iRAC on windows at the cheapest price. I have a document that explains how to do it using SCSI disks but the parts here are very expensive. I have heard that it is also possible to use firewire disks to achieve the same. Does anybody have a document detailing this setup? Technet mentions this only for LINUX and not for Windowz TIA Jacob A. van Zanen Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jack van Zanen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Question related to security
Title: RE: 9i OCP Upgrade Exam - Again I am surprised ... which user did you run this as? You mention in your original email that you don't jave the password for the owner and sys/system don't have admin rights ... Can you solve the puzzle? If you don't have privs with grant option, how could you grant it to someone else? plus this being dbms_sql, you need to have those privs directly granted to you ... Raj - Rajendra dot Jamadagni at espn dot com Any views expressed here are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !! -Original Message-From: Meng, Dennis [mailto:[EMAIL PROTECTED]Sent: Wednesday, March 05, 2003 9:35 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Question related to security Grant select on all tables is not what we were looking for exactly because of the reason brought up by Pat. The following solution provided by Jacques solved the problem - Execute Immediate is for Oracle 8.1 and later. In 7.3.4 you need to use the dbms_sql package for dynamic SQL. The procedure would be something like: create procedure third_party_app_user.grant_priv (table_name_in in varchar2, privileges_in in varchar2, grantee_in varchar2) as c_dynsql pls_integer ; ignore pls_integer ; begin c_dynsql := dbms_sql.open_cursor ; dbms_sql.parse (c_dynsql, 'grant ' || privileges_in || ' on ' || table_name_in || ' to ' || grantee_in, dbms_sql.native) ; ignore := dbms_sql.execute (c_dynsql) ; dbms_sql.close_cursor (c_dynsql) ; exception when others then if dbms_sql.is_open (c_dynsql) then dbms_sql.close_cursor (c_dynsql) ; end if ; raise ; end ; / -Original Message-From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]Sent: Wednesday, March 05, 2003 6:35 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Question related to security That would let the account see ANY table in the database, wouldn't it? Pat. -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]Sent: Tuesday, March 04, 2003 6:05 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Question related to security grant select any table to your developer / Shouldn't this work? Raj - Rajendra dot Jamadagni at espn dot com Any views expressed here are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !! -Original Message-From: Meng, Dennis [mailto:[EMAIL PROTECTED]Sent: Tuesday, March 04, 2003 4:05 PMTo: Multiple recipients of list ORACLE-LSubject: Question related to security Hi all - I have an interesting problem at hand - we have a request from a developer that ask to access some tables owned by a user generated by third party app. Since I don't have the password for this user and system/sys do not have admin option on these tables, I can't grant select to the developer. Changing password for this app can be tricky and will be used as last resort. My question is is there anything else I can do to meet this request? Thanks Dennis 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
How Reliable is Explain Plan in 9.2
Just had a fellow tell me that explain plan in completely unreliable in 9.2 and getting accurate results requires direct SGA access on executing SQL (he is working in a RAC environment). They are running Precise, a good product, but this sounds like something a sales person told him. I can only recall that occasionally the plan executed is not the plan you see in explain plan. Anyone know the truth of this issue? - Ethan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle Tools
BTW is 9i lite just a database engine for PDAs, or does it allow you to administer databases over a network from a PDA? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chuck Hamilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: PLSQL stored procedure
u should use dbastudio -Original Message- Sent: quarta-feira, 5 de Março de 2003 13:35 To: Multiple recipients of list ORACLE-L Hi. i need some help. i'm trying to get a stored procedure source code from the database. After a lot of reding i found : select * from user_objects where object_type='PROCEDURE'; and i've got the name and Object_id of that prodedure but i have no ideea how to get the rest :( please help, adrian -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Adrian Ciocildau INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paulo Gomes INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: advanced replication knowledge resources
One good book to have is Oracle Built-in Packages from O'Reilly. It does more than merely show the syntax for the packages, but shows how the packages are used. There is a chapter on Advanced Replication. I have found this book to be one of the more useful books that I have bought. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How Reliable is Explain Plan in 9.2
Title: RE: How Reliable is Explain Plan in 9.2 Ethan, I am *shocked* we are running RAC 9202 ... I haven't seen anomalies ... does your friend have any example? Raj - Rajendra dot Jamadagni at espn dot com Any views expressed here are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !! -Original Message- From: Post, Ethan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 05, 2003 11:35 AM To: Multiple recipients of list ORACLE-L Subject: How Reliable is Explain Plan in 9.2 Just had a fellow tell me that explain plan in completely unreliable in 9.2 and getting accurate results requires direct SGA access on executing SQL (he is working in a RAC environment). They are running Precise, a good product, but this sounds like something a sales person told him. I can only recall that occasionally the plan executed is not the plan you see in explain plan. Anyone know the truth of this issue? - Ethan 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: advanced replication knowledge resources
Robert - I have studied this issue quite a bit and my opinion (based on reading, not experience) is that the success in replication is in the organization, not the technology. The question is whether your organization and application are ready for replication. It sounds like you have some experience, so I will just recommend Marie Buretta's book Data Replication. I have a checklist based on this book if you want to email me privately. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, March 04, 2003 4:20 PM To: Multiple recipients of list ORACLE-L We'll need to set up multi-master replication between two 8.1.7 databases within the next few months. We're not experienced with replication beyond relatively simple snapshots and snapshot groups. Can anyone suggest good training, web, and/or printed resources we can use to get up to speed? I see Oracle offers 2 distributed systems courses and the book Oracle Distributed Systems by Charles Dye is available. Any experience with these references? Thanks for you help. Bob Stauffer DE Communications Ephrata, PA USA [EMAIL PROTECTED] **DISCLAIMER This e-mail message and any files transmitted with it are intended for the use of the individual or entity to which they are addressed and may contain information that is privileged, proprietary and confidential. If you are not the intended recipient, you may not use, copy or disclose to anyone the message or any information contained in the message. If you have received this communication in error, please notify the sender and delete this e-mail message. The contents do not represent the opinion of DE except to the extent that it relates to their official business. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robert Stauffer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle 9i RAC on Windows using firewire
Hi, It is true that the firewire stuff IS linux only. It was written by Wim Coekaerts (who I used to work together with in Oracle Dev.), who also wrote (together with his group) the cluster file system for linux. I haven't personally tried it yet, but an old collegue(sp?) of mine has tried it. Speedwise it still has some more ground to cover, but for a demo/test setup it's excellent and cheap. Regards, Morten Jack van Zanen wrote: Hi We are not a Unix shop and would like to build a test setup of 9iRAC on windows at the cheapest price. I have a document that explains how to do it using SCSI disks but the parts here are very expensive. I have heard that it is also possible to use firewire disks to achieve the same. Does anybody have a document detailing this setup? Technet mentions this only for LINUX and not for Windowz TIA Jacob A. van Zanen Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Morten Egan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Apache and mod_plsql
MOD_PLSQL is licensed under GPL and its home page is on http://www.selfsoft.com/progs/mod_plsql In my opinion Apache with PHP is equally good as mod_plsql. The main advantage of the modules is that they become a part of Apache httpd process, so you don't have to go through CGI and process switching, everything is handled within the httpd process. -Original Message- From: Jay Hostetter [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 05, 2003 9:06 AM To: Multiple recipients of list ORACLE-L Subject: Apache and mod_plsql We are running 9iAS. If I understand this correctly, 9iAS is simply Apache with a PL/SQL module from Oracle. Our management would like to save the Oracle Support dollars for 9iAS, so I am looking into alternatives. We use the PL/SQL web packages, so my options are limited unless we choose to rewrite code. My questions are: 1) Is it possible to add the (or a) PL/SQL module to Apache without going through Oracle - or does the combination of the two simply give you 9iAS, which is an Oracle product? 2) Any comments or experience with DBPrism (http://www.plenix.com/dbprism/), which is the only possible alternative that I have found so far? I've been trying to read about modowa (http://www.sharemation.com/~dmcmahon/modowa.htm) but the server is down at the moment. Thank you, Jay **DISCLAIMER This e-mail message and any files transmitted with it are intended for the use of the individual or entity to which they are addressed and may contain information that is privileged, proprietary and confidential. If you are not the intended recipient, you may not use, copy or disclose to anyone the message or any information contained in the message. If you have received this communication in error, please notify the sender and delete this e-mail message. The contents do not represent the opinion of DE except to the extent that it relates to their official business. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: FW: oracle version
Hi, I need it to check from O/S level. not from database level. can somebody give any hints. Thanks and Regards, Srinivas -Original Message- From: Hatzistavrou John [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 05, 2003 3:19 PM To: Multiple recipients of list ORACLE-L Subject: RE: oracle version From sql : select * from product_component_version; It can either be shown when logging into sqlplus (check the headers). Kind Regards, Hatzistavrou Yannis Database Administrator SchlumbergerSema Phone ext. 478 Email: [EMAIL PROTECTED] -Original Message- Sent: Wednesday, March 05, 2003 9:49 AM To: Multiple recipients of list ORACLE-L Hello All, OS: Solaris DB: Oracle Can somebody tell me how to know in what version or patchset level the oracle home is ? when I go and see in $ORACLE_HOME, I couldn't find whether it is 8.1.7.3 , 8.1.7.4 or 8.1.7.0 or some other. How to know exactly at which version the $ORACLE_HOME is? Thanks and regards, Srinivas __ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: kommareddy sreenivasa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hatzistavrou John INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: kommareddy sreenivasa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RMAN resync of catalog to controlfile
Joe - I'm confused. If you rebuild the controlfile, what good is the backup information stored in the catalog? Other than maybe deciding to revert to a time before the rebuild, and you're going to need the catalog for that anyway. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, March 05, 2003 8:19 AM To: Multiple recipients of list ORACLE-L Robert, and all of you other RMAN gurus. scenario 1: repository unavailable, so rman backup was done using controlfile only. upon later successful connection to repository, the backup info was pushed from controlfile to repository(YEA). scenario 2: I have to rebuild the controlfile and have a rman repository. so i do a resync in rman, rebuild the controlfile and connect back to repository, doing a resync HOPING that the controlfile gets updated with info from repository, no such luck. I did a dump of the controlfile(via alter session set events 'immediate trace name controlf level 10'), looking for the section on BACKUP SET RECORDS and BACKUP PIECE RECORDS and there is nothing there. so my question is this: is the resync only a one way push, i understand oracle's mentality about not overwriting the backup records in the controlfile since that should be the true information, but is there a way to force oracle/rman to push the repository info back into the controlfile, i've not found a solution for this. if anyone is interested in the dump files, let me know and i'll make them available on the web so you can see what I'm talking about. thanks, joe Joseph S Testa Chief Technology Officer Data Management Consulting p: 614-791-9000 f: 614-791-9001 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joseph S Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re[2]: Re[2]: Oracle Tools
Looks like the web site may be down. Reply Separator Author: Chuck Hamilton [EMAIL PROTECTED] Date: 3/5/2003 8:19 AM Also have a look at MobileLynX. Can't figure out for the life of me why the don't advertise this thing. It does most if not all of what PocketDBA does but is also user extensible. It's actually an XML engine but they provide scripts for managing Unix and Oracle as part of the package. If you want to add your own scripts you can. You can use ksh, sh, perl, or anything else you want as long as you format the output as XML. The URL is http://www.mobilelynx.com - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, March 05, 2003 9:19 AM We had a look at PocketDBA a year ago. Damn nice technology, problem we had was access to the wireless services at the time. They did not extend very far north of Boston Ma. Still don't get out to where we really need it, like the back woods of NH. It's a three tier sort of application. You have a client piece on your PDA, a server inside the firewall and then your databases. You'll need an encryption key to from someone (they specify sources) to run an encrypted SSL connection. NOTE: Use a fairly beefy machine for the internal server that preferably has nothing else to do. Dick Goulet Reply Separator Author: K Gopalakrishnan [EMAIL PROTECTED] Date: 3/5/2003 4:34 AM Sulatan, Have a look at xb.com. There is something called PocketDBA. KG --- Sultan [EMAIL PROTECTED] wrote: Hi gurus, Is there any Oracle tools available to use it in Handheld Computers.(like PDA or IPAQ) Thks in advance = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chuck Hamilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORA-00018: maximum number of sessions exceeded
You can use LICENSE_MAX_SESSIONS to associate with your license, although I don't know why you would want to do it if your database is in-house [if you are an ASP you might want to restrict the number of sessions running against the database on *your* server]. SESSIONS has nothing to do with License. It is best left at its default [ie NOT defined in the initSID.ora] whereby it becomes PROCESSES*1.1 Else, if you really do have multiple sessions, you could set it higher. Hemant At 06:58 AM 04-03-03 -0800, you wrote: Tim and Dennis: Thanks for your responses: SVRMGR show parameter session NAMETYPEVALUE --- --- -- license_max_sessionsinteger 0 license_sessions_warninginteger 0 session_cached_cursors integer 10 sessionsinteger 300 SVRMGR The SESSION parameter is hard-coded in our init.ora file to the value 300. The value for PROCESSES is set to 512. We have hard-coded our SESSION parameter because our number of licenses is set to 300 however, my intuition tells me that the SESSION parameter should not be set based on our number of licenses. Can anybody confirm this for me? I have also set up a TAR with Oracle Support, and they too say we need to increase the SESSION parameter (but we want to confirm it has no link to licenses). Thanks again! Sam Bootsma 416-415-5000 x4933 -Original Message- From: Tim Gorman [mailto:[EMAIL PROTECTED] Sent: March 3, 2003 4:54 PM To: Multiple recipients of list ORACLE-L Subject: Re: ORA-00018: maximum number of sessions exceeded I don't recall if the V$RESOURCE_LIMIT view existing in 7.3.4, but you might want to check. It is a better diagnostic point for that particular resource... The init.ora parameter SESSIONS is related to the ORA-00018 error message, not any of the licensing parameters. Please use SHOW PARAMETER SESSIONS in SVRMGR to display its value. Generally, people let the value of the SESSIONS parameter default to 1.1 * PROCESSES, but you can increase it if you like. Hope this helps... - Original Message - From: mailto:[EMAIL PROTECTED]Sam Bootsma To: mailto:[EMAIL PROTECTED]Multiple recipients of list ORACLE-L Sent: Monday, March 03, 2003 2:24 PM Subject: ORA-00018: maximum number of sessions exceeded We are running Oracle 7.3.4.5.0 on an IBM/AIX RISC System/6000: Version 2.3.4.0.0. This afternoon, our users started getting the error message ORA-00018: maximum number of sessions exceeded. As time went on, the number of sessions was decreasing (as shown by the count of rows in v$session). However, Oracle still did not allow connections. This lasted for about 40 minutes. The sessions parameter in the initialization parameter file showed 300. Querying v$session showed 246 rows. Querying v$license reported: SQL select * from v$license; SESSIONS_MAX SESSIONS_WARNING SESSIONS_CURRENT SESSIONS_HIGHWATER USERS_MAX -- - 00 204248 0 There seems to be a contradiction here: 300 sessions in init.ora; sessions_highwater at 248, and Oracle not allowing connections because the maximum has been reached. Has anybody encountered this problem before. Is there a simple reason for this erratic behavior? Management is looking for an answer as to why this has happened. Thanks for any input! Sam Bootsma mailto:[EMAIL PROTECTED][EMAIL PROTECTED] Hemant K Chitale My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:RE: How Reliable is Explain Plan in 9.2
Ethan, Seeing as your friend is running Precise I have heard similar pronouncements from them about the accurracy of explain plan for several versions of Oracle I'm not suprised. True, they make a very nice product, but them again explain plan is something they do themselves. Yup, sounds like a sales droid got to him. Dick Goulet Reply Separator Author: Jamadagni; Rajendra [EMAIL PROTECTED] Date: 3/5/2003 9:59 AM Ethan, I am *shocked* we are running RAC 9202 ... I haven't seen anomalies ... does your friend have any example? Raj - Rajendra dot Jamadagni at espn dot com Any views expressed here are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !! -Original Message- Sent: Wednesday, March 05, 2003 11:35 AM To: Multiple recipients of list ORACLE-L Just had a fellow tell me that explain plan in completely unreliable in 9.2 and getting accurate results requires direct SGA access on executing SQL (he is working in a RAC environment). They are running Precise, a good product, but this sounds like something a sales person told him. I can only recall that occasionally the plan executed is not the plan you see in explain plan. Anyone know the truth of this issue? - Ethan !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 3.2//EN HTML HEAD META HTTP-EQUIV=Content-Type CONTENT=text/html; charset=iso-8859-1 META NAME=Generator CONTENT=MS Exchange Server version 5.5.2654.45 TITLERE: How Reliable is Explain Plan in 9.2/TITLE /HEAD BODY PFONT SIZE=2Ethan,/FONT /P PFONT SIZE=2I am *shocked* we are running RAC 9202 .../FONT BRFONT SIZE=2I haven't seen anomalies ... does your friend have any example?/FONT /P PFONT SIZE=2Raj/FONT BRFONT SIZE=2-/FONT BRFONT SIZE=2Rajendra dot Jamadagni at espn dot com/FONT BRFONT SIZE=2Any views expressed here are strictly personal./FONT BRFONT SIZE=2QOTD: Any clod can have facts, having an opinion is an art !!/FONT /P BR PFONT SIZE=2-Original Message-/FONT BRFONT SIZE=2From: Post, Ethan [A HREF=mailto:[EMAIL PROTECTED]mailto:[EMAIL PROTECTED]/A]/FONT BRFONT SIZE=2Sent: Wednesday, March 05, 2003 11:35 AM/FONT BRFONT SIZE=2To: Multiple recipients of list ORACLE-L/FONT BRFONT SIZE=2Subject: How Reliable is Explain Plan in 9.2/FONT /P BR PFONT SIZE=2Just had a fellow tell me that explain plan in completely unreliable in 9.2/FONT BRFONT SIZE=2and getting accurate results requires direct SGA access on executing SQL (he/FONT BRFONT SIZE=2is working in a RAC environment).nbsp; They are running Precise, a good product,/FONT BRFONT SIZE=2but this sounds like something a sales person told him.nbsp; I can only recall/FONT BRFONT SIZE=2that occasionally the plan executed is not the plan you see in explain plan./FONT BRFONT SIZE=2Anyone know the truth of this issue?/FONT /P PFONT SIZE=2- Ethan /FONT /P /BODY /HTML 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
Oracle Bug Reports...
... can be rather interesting at times, when there's time to check out a few. http://metalink.oracle.com/metalink/plsql/showDoc?db=BUGid=2666174 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RMAN resync of catalog to controlfile
Joe, Yes, to my knowledge, the resync is only intended to bring the repository up to date with control file. I doubt you will ever see the mechanism to reverse this functionality (e.g. put backup records in the control file after the fact) since when an entry is made in the control file, a counter (control file sequence number if I remember correctly) is incremented thereby giving a chronological state of the control file in the same sense the SCN shows the status of oracle files. HTH, -Ron- -Original Message- Sent: Wednesday, March 05, 2003 8:19 AM To: Multiple recipients of list ORACLE-L Robert, and all of you other RMAN gurus. scenario 1: repository unavailable, so rman backup was done using controlfile only. upon later successful connection to repository, the backup info was pushed from controlfile to repository(YEA). scenario 2: I have to rebuild the controlfile and have a rman repository. so i do a resync in rman, rebuild the controlfile and connect back to repository, doing a resync HOPING that the controlfile gets updated with info from repository, no such luck. I did a dump of the controlfile(via alter session set events 'immediate trace name controlf level 10'), looking for the section on BACKUP SET RECORDS and BACKUP PIECE RECORDS and there is nothing there. so my question is this: is the resync only a one way push, i understand oracle's mentality about not overwriting the backup records in the controlfile since that should be the true information, but is there a way to force oracle/rman to push the repository info back into the controlfile, i've not found a solution for this. if anyone is interested in the dump files, let me know and i'll make them available on the web so you can see what I'm talking about. thanks, joe Joseph S Testa Chief Technology Officer Data Management Consulting p: 614-791-9000 f: 614-791-9001 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joseph S Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Yount INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 8i databases under 9i listener?
Title: Message We had something similar, but only when attempting a serverSQL+ connection, which I found was due to someone messing up the ORA_NLS33 setting. --- As of February 12, 2003 Thomson unified its email addresses on a worldwide basis. Please note my new email address: [EMAIL PROTECTED] Thomson is the leader in solutions and technologies for the entertainment and media industries and serves its customers under its four strategic brands: Technicolor, Grass Valley, RCA and THOMSON. More about Thomson: http://www.thomson.net/videochain -Original Message-From: Stephen Murphy [mailto:[EMAIL PROTECTED]Sent: Wednesday, March 05, 2003 10:06 AMTo: Multiple recipients of list ORACLE-LSubject: RE: 8i databases under 9i listener? We are also finding difficulties with a mixed Oracle environment. We are running AIX 4.3.3-ML10, Oracle 8.1.7.3-EE-64 bit, PeopleSoft 8.18 and moving to Oracle 9.2.0.2. In the past, when moving to a new Oracle release, we would install the software, upgrade our listener, and then start to upgrade our instances, one by one. This go around, after upgrading our listener to 9.2.0.2, when PeopleSoft tries to connect to a 8.1.7.3 database using the 9.2.0.2 listener, the process fails with the message "ORA-01890 NLS error detected". This is happening both when a PS App Server is connecting to Oracle and when the PS client program connects in 2-tier mode. We didn't see this type of behavior with other tools (SQL+, Toad, etc.) connecting to Oracle, so we thought it was a PS problem and reported it to their support center without much progress. In the mean time, we have reconfigured so that we are now running 2 listeners on the box, one for Oracle 8i and one for Oracle 9iR2. So far, we have not found a problem with Oracle 9iR2 databases interacting with like listeners, but our testing continues. If anyone else on this list can shine some light on this problem, please do. -- *---* Stephen T. Murphy Manager, Database and Technical Support ITS - University Applications Development MSC-100 The University at Albany, S.U.N.Y Albany, New York 1 Phone: (518) 437-4523 Fax: (518) 437-4540 MailTo: [EMAIL PROTECTED] AIM: SMurphy199 -Original Message-From: Thomas Jeff [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 05, 2003 8:05 AMTo: Multiple recipients of list ORACLE-LSubject: 8i databases under 9i listener? RS6000 running AIX 4.3.3. We are experiencing the following issues with our 8.1.7.4 databases under a 9.2.0.1 listener. 1) PL/SQL procedures utilizing UTL_FILE fail with INVALID_PATH errors when attempting to open a file. 2) Database links from WE8ISO8859P1 databases to UTF8 databases fail with ORA-3113. Database links work fine as long as the character set is the same on both databases. We've checked, and double-check, all environment variables, O/S permissions, and so forth. Oracle Support has been basically useless. Eventually, they stated that these problems are unique to the AIX platform, and not something that they've seen on HP or Solaris, and recommended running both the 8i and 9i listeners, in other words, they had no clue. The sequence of events went like this: Feb 7th -- 9.2.0.1 was installed on our test/development box, on which there are eight 8.1.7.4 instances running. Feb 14th -- We startup the 9i listener and shutdown the 8i listener. Feb 21st -- First upgrade of an 8.1.7.4 database to 9.2.0.1. The upgrade was successful. The funny thing is that none of the 8.1.7.4 databases had any problems with the 9i listener from Feb 14th to Feb 21st, either with UTL_FIL or with database links. But on Feb 21st, after the first 9.2.0.1 database upgrade, the 9i listener was bounced for the first time since it's inception, and then all the problems started. We are back to running both an 8i and 9i listener for the time being, but I have a lurking suspicion that something is not right somewhere, and could come back and bite us in the future. Jeffery D Thomas DBA Thomson Information Services Thomson, Inc. Email: [EMAIL PROTECTED] Indy DBA Master Documentation available at: http://gkmqp.tce.com/tis_dba Select 'Indy DBA' then 'DBA Web Pages' --- As of February 12, 2003 Thomson unified its email addresses on a worldwide basis. Please note my new email address: [EMAIL PROTECTED] Thomson is the leader in solutions and technologies for the entertainment and media industries and serves its customers under its four strategic brands: Technicolor, Grass Valley, RCA and THOMSON. More about
RE: Oracle Bug Reports...
Title: RE: Oracle Bug Reports... Thanks Jared for bringing this to our attention.. So many bugs .. how can we track 'em all? Raj - Rajendra dot Jamadagni at espn dot com Any views expressed here are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 05, 2003 1:29 PM To: Multiple recipients of list ORACLE-L Subject: Oracle Bug Reports... ... can be rather interesting at times, when there's time to check out a few. http://metalink.oracle.com/metalink/plsql/showDoc?db=BUG=2666174 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: RMAN resync of catalog to controlfile
resync is only one way, unfortunatly. I don't know of any way to update the control file with backup records from the recovery catalog. RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 3/5/2003 8:19 AM Robert, and all of you other RMAN gurus. scenario 1: repository unavailable, so rman backup was done using controlfile only. upon later successful connection to repository, the backup info was pushed from controlfile to repository(YEA). scenario 2: I have to rebuild the controlfile and have a rman repository. so i do a resync in rman, rebuild the controlfile and connect back to repository, doing a resync HOPING that the controlfile gets updated with info from repository, no such luck. I did a dump of the controlfile(via alter session set events 'immediate trace name controlf level 10'), looking for the section on BACKUP SET RECORDS and BACKUP PIECE RECORDS and there is nothing there. so my question is this: is the resync only a one way push, i understand oracle's mentality about not overwriting the backup records in the controlfile since that should be the true information, but is there a way to force oracle/rman to push the repository info back into the controlfile, i've not found a solution for this. if anyone is interested in the dump files, let me know and i'll make them available on the web so you can see what I'm talking about. thanks, joe Joseph S Testa Chief Technology Officer Data Management Consulting p: 614-791-9000 f: 614-791-9001 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joseph S Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How Reliable is Explain Plan in 9.2
Consider how important explain plan is, I highly doubt it's completely unreliable. -Original Message- Sent: Wednesday, March 05, 2003 8:35 AM To: Multiple recipients of list ORACLE-L Just had a fellow tell me that explain plan in completely unreliable in 9.2 and getting accurate results requires direct SGA access on executing SQL (he is working in a RAC environment). They are running Precise, a good product, but this sounds like something a sales person told him. I can only recall that occasionally the plan executed is not the plan you see in explain plan. Anyone know the truth of this issue? - Ethan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Re[2]: Re[2]: Oracle Tools
Hmm, I'm not having any trouble getting to it. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, March 05, 2003 1:14 PM Looks like the web site may be down. Reply Separator Author: Chuck Hamilton [EMAIL PROTECTED] Date: 3/5/2003 8:19 AM Also have a look at MobileLynX. Can't figure out for the life of me why the don't advertise this thing. It does most if not all of what PocketDBA does but is also user extensible. It's actually an XML engine but they provide scripts for managing Unix and Oracle as part of the package. If you want to add your own scripts you can. You can use ksh, sh, perl, or anything else you want as long as you format the output as XML. The URL is http://www.mobilelynx.com - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, March 05, 2003 9:19 AM We had a look at PocketDBA a year ago. Damn nice technology, problem we had was access to the wireless services at the time. They did not extend very far north of Boston Ma. Still don't get out to where we really need it, like the back woods of NH. It's a three tier sort of application. You have a client piece on your PDA, a server inside the firewall and then your databases. You'll need an encryption key to from someone (they specify sources) to run an encrypted SSL connection. NOTE: Use a fairly beefy machine for the internal server that preferably has nothing else to do. Dick Goulet Reply Separator Author: K Gopalakrishnan [EMAIL PROTECTED] Date: 3/5/2003 4:34 AM Sulatan, Have a look at xb.com. There is something called PocketDBA. KG --- Sultan [EMAIL PROTECTED] wrote: Hi gurus, Is there any Oracle tools available to use it in Handheld Computers.(like PDA or IPAQ) Thks in advance = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chuck Hamilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chuck Hamilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego,
RE: PLSQL stored procedure
Title: RE: PLSQL stored procedure our go get TOAD freeware... even has a line by line debugger with watches. -Original Message- From: Darrell Landrum [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 05, 2003 7:06 AM To: Multiple recipients of list ORACLE-L Subject: Re: PLSQL stored procedure Look at user_source (or all_source if the procedure is in a different schema). Then select text from user_source where name = 'YOURPROCNAME'; [EMAIL PROTECTED] 03/05/03 07:34AM Hi. i need some help. i'm trying to get a stored procedure source code from the database. After a lot of reding i found : select * from user_objects where object_type='PROCEDURE'; and i've got the name and Object_id of that prodedure but i have no ideea how to get the rest :( please help, adrian -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Adrian Ciocildau INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Darrell Landrum INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How Reliable is Explain Plan in 9.2
Title: Re: How Reliable is Explain Plan in 9.2 Yes, explain plan will become increasingly unreliable as the cbo takes more and more factors and current conditions current into account. Some of the factors that can change the outcome of a parse from session to session are: for Oracle 8 - different session parameters (db_file_multiblock_read_count, hash_multiblock_io_count, sort_area_size, hash_area_size) for Oracle 9i additionally - you can let Oracle dynamically set the sort_area_size and other memory parameters so you have a moving target now - bind variable peeking - the first parse determines the plan for all following sql depending on its bind value - system statistics in effect at the time of parse. If the system statistics get changed, existing plans do not get invalidated, but if you do an explain the cbo will use the current values - dynamic sampling where the optimizer tries to improve on its estimates by sampling predicate values at the time of parsing. from comments I heard, it will get worse (as far as explain differing from reality is concerned) with Oracle 10. The optimizer will try and learn from past executions of a sql and modify the plan if appropriate. At 08:35 AM 3/5/2003 -0800, you wrote: Just had a fellow tell me that explain plan in completely unreliable in 9.2 and getting accurate results requires direct SGA access on executing SQL (he is working in a RAC environment). They are running Precise, a good product, but this sounds like something a sales person told him. I can only recall that occasionally the plan executed is not the plan you see in explain plan. Anyone know the truth of this issue? Wolfgang Breitling Centrex Consulting Corporation http://www.centrexcc.com This email communication is intended as a private communication for the sole use of the primary addressee and those individuals listed for copies in the original message. The information contained in this email is private and confidential and if you are not an intended recipient you are hereby notified that copying, forwarding or other dissemination or distribution of this communication by any means is prohibited. If you are not specifically authorized to receive this email and if you believe that you received it in error please notify the original sender immediately. We honour similar requests relating to the privacy of email communications. Cette communication par courrier lectronique est une communication prive l'usage exclusif du destinataire principal ainsi que des personnes dont les noms figurent en copie. Les renseignements contenus dans ce courriel sont confidentiels et si vous n'tes pas le destinataire prvu, vous tes avis, par les prsentes que toute reproduction, tout transfert ou toute autre forme de diffusion de cette communication par quelque moyen que ce soit est interdit. Si vous n'tes pas spcifiquement autoris recevoir ce courriel ou si vous croyez l'avoir reu par erreur, veuillez en aviser l'expditeur original immdiatement. Nous respectons les demandes similaires qui touchent la confidentialit des communications par courrier lectronique.
OEM and monitoring clustered databases
I've had problems trying to use OEM (9.0.1) to monitor clustered databases. The problem is that each database is set up in it's own resource group, therefore each has it's own virtual hostname. Even though I may have several databases all running on the same physical host, they all have different virtual hostnames that move with the database when it fails over to another node in the cluster. When you discover a node, it picks up all of the databases on the node and registers them with the OMS as being on that node. Once one of them fails over it's no longer on that node and can't be monitored from OEM anymore. I'm sure others on this list are using this type of failover for high availability. How did you get around it? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chuck Hamilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How Reliable is Explain Plan in 9.2
Title: Re: How Reliable is Explain Plan in 9.2 Wolfgang ... Now that explain plan is unreliable and will be even more in10i, I'll always keep a silver dollar in my pocket. The coin toss is still right(in almost) 50% of the time. Jeez ... what's next ... in 11i, SELECT statement *may* return data and in some cases would actually perform inserts into some other tables, because that's what you *wanted to do* anyways ... right? I want my dBase IV back ... Raj - Rajendra dot Jamadagni at espn dot com Any views expressed here are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !! -Original Message-From: Wolfgang Breitling [mailto:[EMAIL PROTECTED]Sent: Wednesday, March 05, 2003 2:09 PMTo: Multiple recipients of list ORACLE-LSubject: Re: How Reliable is Explain Plan in 9.2 Yes, explain plan will become increasingly unreliable as the cbo takes more and more factors and current conditions current into account. Some of the factors that can change the outcome of a parse from session to session are: for Oracle 8 - different session parameters (db_file_multiblock_read_count, hash_multiblock_io_count, sort_area_size, hash_area_size) for Oracle 9i additionally - you can let Oracle dynamically set the sort_area_size and other memory parameters so you have a moving target now - bind variable peeking - the first parse determines the plan for all following sql depending on its bind value - system statistics in effect at the time of parse. If the system statistics get changed, existing plans do not get invalidated, but if you do an explain the cbo will use the current values - dynamic sampling where the optimizer tries to improve on its estimates by sampling predicate values at the time of parsing. from comments I heard, it will get "worse" (as far as explain differing from reality is concerned) with Oracle 10. The optimizer will try and learn from past executions of a sql and modify the plan if appropriate. At 08:35 AM 3/5/2003 -0800, you wrote: Just had a fellow tell me that explain plan in completely unreliable in 9.2 and getting accurate results requires direct SGA access on executing SQL (he is working in a RAC environment). They are running Precise, a good product, but this sounds like something a sales person told him. I can only recall that occasionally the plan executed is not the plan you see in explain plan. Anyone know the truth of this issue? Wolfgang Breitling Centrex Consulting Corporation http://www.centrexcc.com This email communication is intended as a private communication for the sole use of the primary addressee and those individuals listed for copies in the original message. The information contained in this email is private and confidential and if you are not an intended recipient you are hereby notified that copying, forwarding or other dissemination or distribution of this communication by any means is prohibited. If you are not specifically authorized to receive this email and if you believe that you received it in error please notify the original sender immediately. We honour similar requests relating to the privacy of email communications. Cette communication par courrier électronique est une communication privée à l'usage exclusif du destinataire principal ainsi que des personnes dont les noms figurent en copie. Les renseignements contenus dans ce courriel sont confidentiels et si vous n'êtes pas le destinataire prévu, vous êtes avisé, par les présentes que toute reproduction, tout transfert ou toute autre forme de diffusion de cette communication par quelque moyen que ce soit est interdit. Si vous n'êtes pas spécifiquement autorisé à recevoir ce courriel ou si vous croyez l'avoir reçu par erreur, veuillez en aviser l'expéditeur original immédiatement. Nous respectons les demandes similaires qui touchent la confidentialité des communications par courrier électronique. *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1
Re: Metalink Oracle Support Improving.......
Since I work in a bank, our security guy will flip if we suggest such an option. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, March 03, 2003 5:18 PM Today I found out that the OWS personnel can use 'Oracle Direct Connect' to view your actions on the Client PC. One of our Developers resolved his problem, with PreCompilers, when the support analyst 'saw' his actions via this tool. There is some information at http://metalink.oracle.com/odc/east (or west)... - Kirti -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Slow query
You would have thought to, but it doesn't seem to be the case. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon one-day tutorials: Cost Based Optimisation Trouble-shooting and Tuning Indexing Strategies (see http://www.jlcomp.demon.co.uk/tutorial.html ) UK___March 19th UK___April 8th UK___April 22nd USA_(FL)_May 2nd Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) USA_(CA, TX)_August The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: 05 March 2003 11:34 A small follow up question: Why will oracle do a to_date() on second query for each row returned, as the date mentioned is a literal and doesn't change for the duration of the query. Won't it be calculated once and used for all the rows with trunc() applied to each row? Regards Naveen -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How Reliable is Explain Plan in 9.2
I haven't seen any problems yet. On the contrary - there are facilities in the EXPLAIN PLAN which are not available through v$sql_plan , such as recursive SQL for subquery factoring, and a couple of columns (but I can't remember which ones at the moment). Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon one-day tutorials: Cost Based Optimisation Trouble-shooting and Tuning Indexing Strategies (see http://www.jlcomp.demon.co.uk/tutorial.html ) UK___March 19th UK___April 8th UK___April 22nd USA_(FL)_May 2nd Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) USA_(CA, TX)_August The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: 05 March 2003 16:35 Just had a fellow tell me that explain plan in completely unreliable in 9.2 and getting accurate results requires direct SGA access on executing SQL (he is working in a RAC environment). They are running Precise, a good product, but this sounds like something a sales person told him. I can only recall that occasionally the plan executed is not the plan you see in explain plan. Anyone know the truth of this issue? - Ethan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Apache and mod_plsql
If you don't plan to have many users, I think you could make do with the Oracle HTTP Server (Powered by Apache) that comes bundled with the database from 8.1.6 and onwards. No need to rewrite any code, as it comes with mod_plsql and the PL/SQL Web Toolkit. You could also consider ChangeGroup PL/SQL Server Pages (see http://www.changegroup.biz/da/cgpsp.psp). That would require a rewrite, but it shouldn't be that hard... Regards, Michael Garfield Sørensen, CeDeT - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: 5. marts 2003 16:50 The O'Reilly book Oracle and Open Source says DBPrism is a continuation of / based on OWSKiller, and is one of the most astonishing success stories of Java, Oracle, and open source cooperation. (p.299). They explain how to install it, how to use it, adapters you can get for it, including Cocoon (a Java publishing framework). Pat. -Original Message- Sent: Wednesday, March 05, 2003 10:06 AM To: Multiple recipients of list ORACLE-L We are running 9iAS. If I understand this correctly, 9iAS is simply Apache with a PL/SQL module from Oracle. Our management would like to save the Oracle Support dollars for 9iAS, so I am looking into alternatives. We use the PL/SQL web packages, so my options are limited unless we choose to rewrite code. My questions are: 1) Is it possible to add the (or a) PL/SQL module to Apache without going through Oracle - or does the combination of the two simply give you 9iAS, which is an Oracle product? 2) Any comments or experience with DBPrism (http://www.plenix.com/dbprism/), which is the only possible alternative that I have found so far? I've been trying to read about modowa (http://www.sharemation.com/~dmcmahon/modowa.htm) but the server is down at the moment. Thank you, Jay **DISCLAIMER This e-mail message and any files transmitted with it are intended for the use of the individual or entity to which they are addressed and may contain information that is privileged, proprietary and confidential. If you are not the intended recipient, you may not use, copy or disclose to anyone the message or any information contained in the message. If you have received this communication in error, please notify the sender and delete this e-mail message. The contents do not represent the opinion of DE except to the extent that it relates to their official business. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?Q?Michael_Garfield_S=F8rensen?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RMAN resync of catalog to controlfile
the catalog has all of the current backup info, so if i lose the repository(before taking a backup after rebuilding the controlfile), I'm SOL. I logged a tar and oracle's response is, no way to push catalog info back into the controlfile. joe Joe - I'm confused. If you rebuild the controlfile, what good is the backup information stored in the catalog? Other than maybe deciding to revert to a time before the rebuild, and you're going to need the catalog for that anyway. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, March 05, 2003 8:19 AM To: Multiple recipients of list ORACLE-L Robert, and all of you other RMAN gurus. scenario 1: repository unavailable, so rman backup was done using controlfile only. upon later successful connection to repository, the backup info was pushed from controlfile to repository(YEA). scenario 2: I have to rebuild the controlfile and have a rman repository. so i do a resync in rman, rebuild the controlfile and connect back to repository, doing a resync HOPING that the controlfile gets updated with info from repository, no such luck. I did a dump of the controlfile(via alter session set events 'immediate trace name controlf level 10'), looking for the section on BACKUP SET RECORDS and BACKUP PIECE RECORDS and there is nothing there. so my question is this: is the resync only a one way push, i understand oracle's mentality about not overwriting the backup records in the controlfile since that should be the true information, but is there a way to force oracle/rman to push the repository info back into the controlfile, i've not found a solution for this. if anyone is interested in the dump files, let me know and i'll make them available on the web so you can see what I'm talking about. thanks, joe Joseph S Testa Chief Technology Officer Data Management Consulting p: 614-791-9000 f: 614-791-9001 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joseph S Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Joseph S Testa Chief Technology Officer Data Management Consulting p: 614-791-9000 f: 614-791-9001 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joseph S Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: How Reliable is Explain Plan in 9.2
That is my thinking but I will take Wolfgang's comments into consideration. -Original Message- Sent: Wednesday, March 05, 2003 12:39 PM To: Multiple recipients of list ORACLE-L Ethan, Seeing as your friend is running Precise I have heard similar pronouncements from them about the accurracy of explain plan for several versions of Oracle I'm not suprised. True, they make a very nice product, but them again explain plan is something they do themselves. Yup, sounds like a sales droid got to him. Dick Goulet Reply Separator Author: Jamadagni; Rajendra [EMAIL PROTECTED] Date: 3/5/2003 9:59 AM Ethan, I am *shocked* we are running RAC 9202 ... I haven't seen anomalies ... does your friend have any example? Raj - Rajendra dot Jamadagni at espn dot com Any views expressed here are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
access to oracle $ tables in 9.2.0
Title: access to oracle $ tables in 9.2.0 Previously, an account with the DBA role could directly query oracle's internal tables (user$, seg$, ts$, etc). Now in 9.2.0.2, it appears we can't. Does anybody know what version this changed in or where (or if) it was documented. A quick search on MetaLink came up empty. Matt Matt Adams - GE Appliances - [EMAIL PROTECTED] We have enough youth. How about a fountain of intelligence?
Re: Oracle Tools
9i lite is a light weight database for PDA's. I know that at one point Oracle was developing a DBA tool for PDA's, but I dont know the status of this product, or if it has been cancelled since then. But of course you can wait for EM in 10i which is browser based, so that should be able to run in the pocket version of internet explorer Regards, Morten Egan Chuck Hamilton wrote: BTW is 9i lite just a database engine for PDAs, or does it allow you to administer databases over a network from a PDA? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Morten Egan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How Reliable is Explain Plan in 9.2
I think there's a big emotional difference between unreliable and won't necessarily give you the plan under the current circumstances that it gave at the time of execution - which has been true since the utility came out. It is true, of course, that the reasons for the variation have become increasingly subtle - but in theory the DBA should still be sufficiently in control of all the necessary parameters to cater for the likely variations. Of course, when the real-time learning module get included, then we're stuffed. BTW - - system statistics in effect at the time of parse. If the system statistics get changed, existing plans do not get invalidated, but if you do an explain the cbo will use the current values I read this in the manuals recently - but the first time I tested it, I got a plan invalidation, re-parse and new execution path. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon one-day tutorials: Cost Based Optimisation Trouble-shooting and Tuning Indexing Strategies (see http://www.jlcomp.demon.co.uk/tutorial.html ) UK___March 19th UK___April 8th UK___April 22nd USA_(FL)_May 2nd Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) USA_(CA, TX)_August The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: 05 March 2003 19:09 Yes, explain plan will become increasingly unreliable as the cbo takes more and more factors and current conditions current into account. Some of the factors that can change the outcome of a parse from session to session are: for Oracle 8 - different session parameters (db_file_multiblock_read_count, hash_multiblock_io_count, sort_area_size, hash_area_size) for Oracle 9i additionally - you can let Oracle dynamically set the sort_area_size and other memory parameters so you have a moving target now - bind variable peeking - the first parse determines the plan for all following sql depending on its bind value - system statistics in effect at the time of parse. If the system statistics get changed, existing plans do not get invalidated, but if you do an explain the cbo will use the current values - dynamic sampling where the optimizer tries to improve on its estimates by sampling predicate values at the time of parsing. from comments I heard, it will get worse (as far as explain differing from reality is concerned) with Oracle 10. The optimizer will try and learn from past executions of a sql and modify the plan if appropriate. At 08:35 AM 3/5/2003 -0800, you wrote: Just had a fellow tell me that explain plan in completely unreliable in 9.2 and getting accurate results requires direct SGA access on executing SQL (he is working in a RAC environment). They are running Precise, a good product, but this sounds like something a sales person told him. I can only recall that occasionally the plan executed is not the plan you see in explain plan. Anyone know the truth of this issue? Wolfgang Breitling Centrex Consulting Corporation http://www.centrexcc.com This email communication is intended as a private communication for the sole use of the primary addressee and those individuals listed for copies in the original message. The information contained in this email is private and confidential and if you are not an intended recipient you are hereby notified that copying, forwarding or other dissemination or distribution of this communication by any means is prohibited. If you are not specifically authorized to receive this email and if you believe that you received it in error please notify the original sender immediately. We honour similar requests relating to the privacy of email communications. Cette communication par courrier electronique est une communication privee a l'usage exclusif du destinataire principal ainsi que des personnes dont les noms figurent en copie. Les renseignements contenus dans ce courriel sont confidentiels et si vous n'etes pas le destinataire prevu, vous etes avise, par les presentes que toute reproduction, tout transfert ou toute autre forme de diffusion de cette communication par quelque moyen que ce soit est interdit. Si vous n'etes pas specifiquement autorise a recevoir ce courriel ou si vous croyez l'avoir recu par erreur, veuillez en aviser l'expediteur original immediatement. Nous respectons les demandes similaires qui touchent la confidentialite des communications par courrier electronique. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself
Monitoring/BA Tools
Anyone use third party tools for monitoring Oracle (which I like to think I'm not a complete novice at), *and* MSSQL (um which I am). I have an unusual opportunity to buy third party software whilst we wait for the MSSQL training to kick in and I'd like to buy something genuinely useful for an experienced Oracle DBA dumped with 8 sqlservers , including a payroll system.Usefull not pretty would be my criteria - though pretty BCHR graphs might convince the purse string holders that they have a good deal as well. Niall -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Bug Reports...
No worries. The bug says it's fixed in 10.0. Just upgrade. Anyone can do it, since 10.0 removes the need for a DBA. Whoa. Gotta cut back on the black tea here... Rich Rich JesseSystem/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Wednesday, March 05, 2003 12:29 PM To: Multiple recipients of list ORACLE-L ... can be rather interesting at times, when there's time to check out a few. http://metalink.oracle.com/metalink/plsql/showDoc?db=BUGid=2666174 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: FW: oracle version
did u try the inventory logs ? Babu kommareddy sreenivasa To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] [EMAIL PROTECTED]cc: om Subject: Re: FW: oracle version Sent by: [EMAIL PROTECTED] 03/05/03 01:09 PM Please respond to ORACLE-L Hi, I need it to check from O/S level. not from database level. can somebody give any hints. Thanks and Regards, Srinivas -Original Message- From: Hatzistavrou John [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 05, 2003 3:19 PM To: Multiple recipients of list ORACLE-L Subject: RE: oracle version From sql : select * from product_component_version; It can either be shown when logging into sqlplus (check the headers). Kind Regards, Hatzistavrou Yannis Database Administrator SchlumbergerSema Phone ext. 478 Email: [EMAIL PROTECTED] -Original Message- Sent: Wednesday, March 05, 2003 9:49 AM To: Multiple recipients of list ORACLE-L Hello All, OS: Solaris DB: Oracle Can somebody tell me how to know in what version or patchset level the oracle home is ? when I go and see in $ORACLE_HOME, I couldn't find whether it is 8.1.7.3 , 8.1.7.4 or 8.1.7.0 or some other. How to know exactly at which version the $ORACLE_HOME is? Thanks and regards, Srinivas __ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: kommareddy sreenivasa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hatzistavrou John INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: kommareddy sreenivasa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051
Re: Apache and mod_plsql
hmmm I remember something about licensing with Oracle HTTP Server. AFAIK you are NOT allowed to use it for this kind of appl. I think you need to buy the IAS. Can anyone remember the specifics around this, or am I way off here? /morten Michael Garfield Srensen wrote: If you don't plan to have many users, I think you could make do with the Oracle HTTP Server (Powered by Apache) that comes bundled with the database from 8.1.6 and onwards. No need to rewrite any code, as it comes with mod_plsql and the PL/SQL Web Toolkit. You could also consider ChangeGroup PL/SQL Server Pages (see http://www.changegroup.biz/da/cgpsp.psp). That would require a rewrite, but it shouldn't be that hard... Regards, Michael Garfield Srensen, CeDeT - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: 5. marts 2003 16:50 The O'Reilly book Oracle and Open Source says DBPrism is a continuation of / based on OWSKiller, and is "one of the most astonishing success stories of Java, Oracle, and open source cooperation." (p.299). They explain how to install it, how to use it, adapters you can get for it, including Cocoon (a Java publishing framework). Pat. -Original Message- Sent: Wednesday, March 05, 2003 10:06 AM To: Multiple recipients of list ORACLE-L We are running 9iAS. If I understand this correctly, 9iAS is simply Apache with a PL/SQL module from Oracle. Our management would like to save the Oracle Support dollars for 9iAS, so I am looking into alternatives. We use the PL/SQL web packages, so my options are limited unless we choose to rewrite code. My questions are: 1) Is it possible to add the (or "a") PL/SQL module to Apache without going through Oracle - or does the combination of the two simply give you 9iAS, which is an Oracle product? 2) Any comments or experience with DBPrism (http://www.plenix.com/dbprism/), which is the only possible alternative that I have found so far? I've been trying to read about modowa (http://www.sharemation.com/~dmcmahon/modowa.htm) but the server is down at the moment. Thank you, Jay **DISCLAIMER This e-mail message and any files transmitted with it are intended for the use of the individual or entity to which they are addressed and may contain information that is privileged, proprietary and confidential. If you are not the intended recipient, you may not use, copy or disclose to anyone the message or any information contained in the message. If you have received this communication in error, please notify the sender and delete this e-mail message. The contents do not represent the opinion of DE except to the extent that it relates to their official business. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How Reliable is Explain Plan in 9.2
Title: Message As far as I can tell, the Explain Plan is 100% reliable. It shows how the query would execute if it was run from that session at that momement in time. If you want to see how a query in the SGA actually ran, query the Oracle9i v$sql_plan view. Kevin -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 05, 2003 2:30 PMTo: Multiple recipients of list ORACLE-LSubject: RE: How Reliable is Explain Plan in 9.2 Wolfgang ... Now that explain plan is unreliable and will be even more in10i, I'll always keep a silver dollar in my pocket. The coin toss is still right(in almost) 50% of the time. Jeez ... what's next ... in 11i, SELECT statement *may* return data and in some cases would actually perform inserts into some other tables, because that's what you *wanted to do* anyways ... right? I want my dBase IV back ... Raj - Rajendra dot Jamadagni at espn dot com Any views expressed here are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !! -Original Message-From: Wolfgang Breitling [mailto:[EMAIL PROTECTED]Sent: Wednesday, March 05, 2003 2:09 PMTo: Multiple recipients of list ORACLE-LSubject: Re: How Reliable is Explain Plan in 9.2 Yes, explain plan will become increasingly unreliable as the cbo takes more and more factors and current conditions current into account. Some of the factors that can change the outcome of a parse from session to session are: for Oracle 8 - different session parameters (db_file_multiblock_read_count, hash_multiblock_io_count, sort_area_size, hash_area_size) for Oracle 9i additionally - you can let Oracle dynamically set the sort_area_size and other memory parameters so you have a moving target now - bind variable peeking - the first parse determines the plan for all following sql depending on its bind value - system statistics in effect at the time of parse. If the system statistics get changed, existing plans do not get invalidated, but if you do an explain the cbo will use the current values - dynamic sampling where the optimizer tries to improve on its estimates by sampling predicate values at the time of parsing. from comments I heard, it will get "worse" (as far as explain differing from reality is concerned) with Oracle 10. The optimizer will try and learn from past executions of a sql and modify the plan if appropriate. At 08:35 AM 3/5/2003 -0800, you wrote: Just had a fellow tell me that explain plan in completely unreliable in 9.2 and getting accurate results requires direct SGA access on executing SQL (he is working in a RAC environment). They are running Precise, a good product, but this sounds like something a sales person told him. I can only recall that occasionally the plan executed is not the plan you see in explain plan. Anyone know the truth of this issue? Wolfgang Breitling Centrex Consulting Corporation http://www.centrexcc.com This email communication is intended as a private communication for the sole use of the primary addressee and those individuals listed for copies in the original message. The information contained in this email is private and confidential and if you are not an intended recipient you are hereby notified that copying, forwarding or other dissemination or distribution of this communication by any means is prohibited. If you are not specifically authorized to receive this email and if you believe that you received it in error please notify the original sender immediately. We honour similar requests relating to the privacy of email communications. Cette communication par courrier électronique est une communication privée à l'usage exclusif du destinataire principal ainsi que des personnes dont les noms figurent en copie. Les renseignements contenus dans ce courriel sont confidentiels et si vous n'êtes pas le destinataire prévu, vous êtes avisé, par les présentes que toute reproduction, tout transfert ou toute autre forme de diffusion de cette communication par quelque moyen que ce soit est interdit. Si vous n'êtes pas spécifiquement autorisé à recevoir ce courriel ou si vous croyez l'avoir reçu par erreur, veuillez en aviser l'expéditeur original immédiatement. Nous respectons les demandes similaires qui touchent la confidentialité des communications par courrier électronique.
Re: Apache and mod_plsql
The problem with that idea is that the webserver portion will be installed in a DMZ, away from the database. Which got me thinking...what if I just installed the http portion of the database install on the webserver box? I would be using the http listener that comes with the database, but I wouldn't be using the database on the same machine. I wonder what licensing issues that raises? Jay [EMAIL PROTECTED] 03/05/03 02:19PM If you don't plan to have many users, I think you could make do with the Oracle HTTP Server (Powered by Apache) that comes bundled with the database from 8.1.6 and onwards. No need to rewrite any code, as it comes with mod_plsql and the PL/SQL Web Toolkit. You could also consider ChangeGroup PL/SQL Server Pages (see http://www.changegroup.biz/da/cgpsp.psp). That would require a rewrite, but it shouldn't be that hard... Regards, Michael Garfield Sørensen, CeDeT - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: 5. marts 2003 16:50 The O'Reilly book Oracle and Open Source says DBPrism is a continuation of / based on OWSKiller, and is one of the most astonishing success stories of Java, Oracle, and open source cooperation. (p.299). They explain how to install it, how to use it, adapters you can get for it, including Cocoon (a Java publishing framework). Pat. -Original Message- Sent: Wednesday, March 05, 2003 10:06 AM To: Multiple recipients of list ORACLE-L We are running 9iAS. If I understand this correctly, 9iAS is simply Apache with a PL/SQL module from Oracle. Our management would like to save the Oracle Support dollars for 9iAS, so I am looking into alternatives. We use the PL/SQL web packages, so my options are limited unless we choose to rewrite code. My questions are: 1) Is it possible to add the (or a) PL/SQL module to Apache without going through Oracle - or does the combination of the two simply give you 9iAS, which is an Oracle product? 2) Any comments or experience with DBPrism (http://www.plenix.com/dbprism/), which is the only possible alternative that I have found so far? I've been trying to read about modowa (http://www.sharemation.com/~dmcmahon/modowa.htm) but the server is down at the moment. Thank you, Jay **DISCLAIMER This e-mail message and any files transmitted with it are intended for the use of the individual or entity to which they are addressed and may contain information that is privileged, proprietary and confidential. If you are not the intended recipient, you may not use, copy or disclose to anyone the message or any information contained in the message. If you have received this communication in error, please notify the sender and delete this e-mail message. The contents do not represent the opinion of DE except to the extent that it relates to their official business. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Bug Reports...
Wait... I thought it was 9i that did away with the need for DBAs... -Original Message- Sent: Wednesday, March 05, 2003 2:00 PM To: Multiple recipients of list ORACLE-L No worries. The bug says it's fixed in 10.0. Just upgrade. Anyone can do it, since 10.0 removes the need for a DBA. Whoa. Gotta cut back on the black tea here... Rich Rich JesseSystem/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Wednesday, March 05, 2003 12:29 PM To: Multiple recipients of list ORACLE-L ... can be rather interesting at times, when there's time to check out a few. http://metalink.oracle.com/metalink/plsql/showDoc?db=BUGid=2666174 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies. Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for any damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: April Wells INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Date format is unreadable
I try to query a report to check user activity but I could not read date column. Is there a way to reformat the column to be readable? Date colum calls "time_stamp" as shown below. SQL desc user_activity_log Name Null? Type - -- TIME_STAMP NOT NULL NUMBER(20) NODE_NAME NOT NULL VARCHAR2(20) USER_NAME NOT NULL VARCHAR2(20) CLIENT_IP NOT NULL VARCHAR2(15) DESCRIPTION NOT NULL VARCHAR2(2048) SQL select user_name,client_ip,node_name,time_stamp from user_activity_log where user_name = 'admin' order by time_stamp; USER_NAME CLIENT_IP NODE_NAME TIME_STAMP --- -- admin NA Insight Server 1.0397E+12 admin NA Insight Server 1.0402E+12 admin NA Insight Server 1.0433E+12