OEM 2.2: Test email message works but real email doesn't
Hi there, when I do test mails ... working fine. But When I schedule jobs does not seems to be working ... there are no email blockouts. Any hints or ideas? Best regards Henrik Henrik Bachmannmailto:[EMAIL PROTECTED] B.I.M.-Consulting Magdeburghttp://www.bim-consulting.de/ D-39108 Magdeburg -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bachmann, Henrik INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: DATABASE COMPARE SCRIPT
Title: RE: When to go for ORACLE NAMES Server -- DATATYPE.sql -- -- To check datatype consistency between two environments -- -- SELECT table_name, column_name, data_type, data_length, data_precision, data_scale, nullable FROM all_tab_columns -- first environment WHERE owner = 'OWNER' MINUS SELECT table_name, column_name, data_type, data_length, data_precision, data_scale, nullable FROM all_tab_columns@my_db_link -- second environment WHERE owner = 'OWNER2' order by table_name, column_name; - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Saturday, May 12, 2001 12:20 AM Subject: DATABASE COMPARE SCRIPT I am trying to find out the schema differences between two databases. Differences like Column size,column datatype,column data length, indexes,tables,constraints etc. If anyone has a script or know where I can get one that will accomplish this, please let me know. Thank you.
RE: Alert log
Hi I think this parameter is available from 8.1.6 where us I am in 8.1.5..Any idea how to control it in 8.1.5? Raj -Original Message- Sent: 12 May 2001 00:18 To: Multiple recipients of list ORACLE-L Raj, It's new archiving tracing introduced in 8i. If you're on 8.1.6 or later you can control the level of tracing with the LOG_ARCHIVE_TRACE parameter. See the following docs: Note 94055.1 Init.ora Parameter LOG_ARCHIVE_TRACE Reference Note Note 104405.1 ARCH tracefile messages VALIDATE, PREPARE, INITIALIZE, SPOOL, FINISH HTH, -- Anita --- Raj Gopalan [EMAIL PROTECTED] wrote: DBAs My alert.log is clogged with following message.. ARC0: received prod ARC0: Beginning to archive log# 4 seq# 286600 ARC0: Completed archiving log# 4 seq# 286600 ARC0: re-scanning for new log files ARC0: prodding the archiver Fri May 11 16:10:01 2001 ARC1: received prod Fri May 11 16:26:00 2001 LGWR: prodding the archiver Thread 1 advanced to log sequence 286602 Current log# 1 seq# 286602 mem# 0: /hcg1/datafiles/redolog_group1.log Current log# 1 seq# 286602 mem# 1: /hcg2/datafiles/redolog_group1.log Fri May 11 16:26:00 2001 ARC0: received prod ARC0: Beginning to archive log# 5 seq# 286601 ARC0: Completed archiving log# 5 seq# 286601 ARC0: re-scanning for new log files ARC0: prodding the archiver Fri May 11 16:26:03 2001 ARC1: received prod I can understand that log switch is occuring but what these ARC0 messages doing here? I dont remember of enabling any parameter or setting for this.. Could you help me in locating the cause for these messages in alert.log.. TIA Cheers Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Gopalan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Gopalan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
AFTER LOGON ON SCHEMA Trigger 8.1.6 .. HELP!
Hi Everybody, I am using oracle 8.1.6 db. I want to create a trigger which fires for every new object created in a particular schema. Basically, i want to grant privileges for this newly created object to Roles, Users dynamically as and when the new object created. When i tried , the trigger got created but on creating a table in that schema reported that " DDLs are not allowed in System triggers except ALTERCOMPILE... " - command failed. Is there any workaround to achieve issuing DDLs ? Thanks. Regards, Arul.
Re: AFTER LOGON ON SCHEMA Trigger 8.1.6 .. HELP!
Arul, Ak Hi Everybody, Ak I am using oracle 8.1.6 db. Ak I want to create a trigger which fires for every new object created in a Ak particular schema. Basically, i want to grant privileges for this newly Ak created object to Roles, Users dynamically as and when the new object Ak created. Ak When i tried , the trigger got created but on creating a table in that Ak schema reported that DDLs are not allowed in System triggers except Ak ALTERCOMPILE... - command failed. Ak Is there any workaround to achieve issuing DDLs ? include pragma autonomous_transaction; as shown below CREATE OR REPLACE TRIGGER FORMROLE_DEL AFTER DELETE ON FORMROLE FOR EACH ROW DECLARE pragma autonomous_transaction; BEGIN ... END FORMROLE_DEL [EMAIL PROTECTED] Ura! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ura! INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Alert log
Rafiq But I want my db to be archived.. Raj -Original Message- Sent: 11 May 2001 21:46 To: Multiple recipients of list ORACLE-L Your archiving is TRUE instead of false Check for log_archive_start FALSE change this parameter to false and rebounce your database. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Fri, 11 May 2001 08:46:06 -0800 DBAs My alert.log is clogged with following message.. ARC0: received prod ARC0: Beginning to archive log# 4 seq# 286600 ARC0: Completed archiving log# 4 seq# 286600 ARC0: re-scanning for new log files ARC0: prodding the archiver Fri May 11 16:10:01 2001 ARC1: received prod Fri May 11 16:26:00 2001 LGWR: prodding the archiver Thread 1 advanced to log sequence 286602 Current log# 1 seq# 286602 mem# 0: /hcg1/datafiles/redolog_group1.log Current log# 1 seq# 286602 mem# 1: /hcg2/datafiles/redolog_group1.log Fri May 11 16:26:00 2001 ARC0: received prod ARC0: Beginning to archive log# 5 seq# 286601 ARC0: Completed archiving log# 5 seq# 286601 ARC0: re-scanning for new log files ARC0: prodding the archiver Fri May 11 16:26:03 2001 ARC1: received prod I can understand that log switch is occuring but what these ARC0 messages doing here? I dont remember of enabling any parameter or setting for this.. Could you help me in locating the cause for these messages in alert.log.. TIA Cheers Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Gopalan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Gopalan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 error -20001
Unless things have changed, 2 thru 20999 are user specified error numbers, not generated by Oracle. [EMAIL PROTECTED] 05/11/01 01:20PM Has anyone any idea what this means? It is coming up when trying to use a procedure in a PL/SQL package to display a web page. With some negative errors we are able to remove them by reloading all for the application in the OAS manager but not this one. Searching MetaLink I come up with suggestions to patch Applications 11i or upgrade Developer 6 - neither of which are in use here. I also came up with cause not determined. Environment: Sun OS 5.7 Oracle8i Enterprise Edition release 8.1.6.0.0 OAS 4.0 - we are using a secure server Both the package and package body are valid. Any help in unraveling this would be greaterly appreciated. Pat -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pat Hildebrand INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Sawmiller INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: DBSNMP user?
You can run the catnsnmp.sql script from rdbms/admin to get rid of it... Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- From: SuzyV [SMTP:[EMAIL PROTECTED]] Sent: Sunday, May 13, 2001 3:25 AM To: Multiple recipients of list ORACLE-L Subject:Re: DBSNMP user? And has DBA privs and well-known default passwd, which I alter to a random string (not using OEM here...) Holman, Rodney wrote: Ron, That's the good old Oracle Intelligent Agent for Enterprise Manager. It is the ID that talks to the OEM console for events reporting. Rodd Holman Original Message On 5/11/01, 2:45:31 PM, Smith, Ron L. [EMAIL PROTECTED] wrote regarding DBSNMP user?: I have a user that keeps showing up in my NT database called DBSNMP. The OS user name is SYSTEM. Does anyone know where this user might be coming from? Ron Smith Database Administration [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Holman, Rodney INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SuzyV INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Alert log
Raj, Nope, none that I know of. Yet another reason to upgrade ;) -- Anita --- Raj Gopalan [EMAIL PROTECTED] wrote: Hi I think this parameter is available from 8.1.6 where us I am in 8.1.5..Any idea how to control it in 8.1.5? Raj -Original Message- Sent: 12 May 2001 00:18 To: Multiple recipients of list ORACLE-L Raj, It's new archiving tracing introduced in 8i. If you're on 8.1.6 or later you can control the level of tracing with the LOG_ARCHIVE_TRACE parameter. See the following docs: Note 94055.1 Init.ora Parameter LOG_ARCHIVE_TRACE Reference Note Note 104405.1 ARCH tracefile messages VALIDATE, PREPARE, INITIALIZE, SPOOL, FINISH HTH, -- Anita --- Raj Gopalan [EMAIL PROTECTED] wrote: DBAs My alert.log is clogged with following message.. ARC0: received prod ARC0: Beginning to archive log# 4 seq# 286600 ARC0: Completed archiving log# 4 seq# 286600 ARC0: re-scanning for new log files ARC0: prodding the archiver Fri May 11 16:10:01 2001 ARC1: received prod Fri May 11 16:26:00 2001 LGWR: prodding the archiver Thread 1 advanced to log sequence 286602 Current log# 1 seq# 286602 mem# 0: /hcg1/datafiles/redolog_group1.log Current log# 1 seq# 286602 mem# 1: /hcg2/datafiles/redolog_group1.log Fri May 11 16:26:00 2001 ARC0: received prod ARC0: Beginning to archive log# 5 seq# 286601 ARC0: Completed archiving log# 5 seq# 286601 ARC0: re-scanning for new log files ARC0: prodding the archiver Fri May 11 16:26:03 2001 ARC1: received prod I can understand that log switch is occuring but what these ARC0 messages doing here? I dont remember of enabling any parameter or setting for this.. Could you help me in locating the cause for these messages in alert.log.. TIA Cheers Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Gopalan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Gopalan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Insert Cardinalities into the data dictionary directly
If the production environment is already available, you could use DBMS_STATS.EXPORT_TABLE_STATS on the production table and import those stats into your development instance. Regards, Chris Gait On 18 Apr 2001, at 11:00, Murali Vallath wrote: Thanks for the feedback, I am coming from the Oracle Rdb world, where these row counts/cardinialities could be inserted into the data dictionary to simulate the optimizer behaviour similar to a production environment. I see your point, this could be a negative impact to the optimizer. Thanks for the input.] Murali -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Unix
How can I modify a Unix file in an other editor not using vi, for instance I would like to use a Windows based editor? Roland Sköldblom -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: When to go for ORACLE NAMES Server
I beleave intelligent agent requires tnsnames.ora also. Alex Hillman -Original Message- Sent: Monday, May 14, 2001 1:47 AM To: Multiple recipients of list ORACLE-L On Sunday 13 May 2001 18:51, Mohan, Ross wrote: Sounds like client-based Forms would be OK with ONS, then. Or, izzit? Forms 5 wouldn't work on Solaris with ONS. I'm not sure about forms 6 or 6i. MetaBlink is stuck right now or I'd try and verify this through support. Jared - ross ( i won't FedEx you a burger, but write yerself a raincheck) || -Original Message- || From: Jared Still [mailto:[EMAIL PROTECTED]] || Sent: Friday, May 11, 2001 11:50 PM || To: Multiple recipients of list ORACLE-L || Subject: Re: When to go for ORACLE NAMES Server || || || || Ross, || || What I was referring to was using Oracle Forms directly on || Unix, *not* through iAS. iAS takes care of that stuff for || you. || || Lesse, I tried using forms 5.x on Solaris a couple of years || ago, and much to my dismay found that tnsnames.ora was || *required* in order to connect to a database. This was || on a box that worked just fine with ORANAMES when || connecting via sqlplus or Perl. || || Reports had the same problem. || || I was troubleshooting some forms of the 6i variety on Solaris || a few months ago, and since I still had the tnsnames.ora setup || on that box from the previous go round with forms, I honestly || don't know if Forms 6i required it or not. || || The trouble shooting was in native forms mode on Solaris 2.6, || though the forms were moved to another box and run in iAS, || which functioned just fine with ORANAMES. || || I don't have ORANAMES setup here at home or I would try || and test this here. || || Jared || || On Friday 11 May 2001 10:45, Mohan, Ross wrote: || Jared, || || You may have just earned yourself a dinner. (And I || promise you will not receive it the way you did my || $0.02 recently ;-) || || Can you tell me more...alot more would be grand...about || how Forms needs tnsnames? || || *thanks* || || Ross || || || -Original Message- || || From: Jared Still [mailto:[EMAIL PROTECTED]] || || Sent: Friday, May 11, 2001 1:43 PM || || To: [EMAIL PROTECTED]; Mohan, Ross || || Subject: Re: When to go for ORACLE NAMES Server || || || || || || || || Somewhat of a pain to setup for the first time, for sure. || || || || But after you get it implemented, you will never want to || || go back. || || || || One caveat: There is a fair amount of software around || || that *requires* tnsnames.ora or it won't work. Oracle || || Forms on unix comes to mind. Yes, Oracle's own software || || does not fully utilize names. || || || || This is a minor problem when compared to the benefits though. || || || || Jared || || || || On Friday 11 May 2001 10:50, Mohan, Ross wrote: || || if the tediousness exceeds your perception of the || || || || difficulty, do Names. || || || || if not, not. || || || || In my very limited experience, a truly robust, || || || || well-managed Names service || || || || is great, but takes some work to set up, test, and document. || || || || YMMV || || || || || -Original Message- || || || From: Johnson Poovathummoottil [mailto:[EMAIL PROTECTED]] || || || Sent: Friday, May 11, 2001 12:15 PM || || || To: Multiple recipients of list ORACLE-L || || || Subject: When to go for ORACLE NAMES Server || || || || || || || || || There is another thread going on about no database on || || || a single server, I have another question to ask. || || || || || || We have nearly 30 databases across Sun and Win 2000 || || || Platforms. We are finding it tedious to keep track of || || || tnsnames.ora. While looking out for a solution we hit || || || at ORACLE Names server. I hear it is going to give way || || || to ORACLE Internet directory. But after reading a || || || little I think using either would be too much of a || || || kill for the problem. || || || || || || Any opinions? || || || || || || || || || __ || || || Do You Yahoo!? || || || Yahoo! Auctions - buy the things you want at great prices || || || http://auctions.yahoo.com/ || || || -- || || || Please see the official ORACLE-L FAQ: http://www.orafaq.com || || || -- || || || Author: Johnson Poovathummoottil || || || INET: [EMAIL PROTECTED] || || || || || || Fat City Network Services-- (858) 538-5051 FAX: || || || || (858) 538-5051 || || || || || San Diego, California-- Public Internet access / || || || Mailing Lists || || || || || || To REMOVE yourself from this mailing list, send an || || || || E-Mail message || || || || || to: [EMAIL PROTECTED] (note EXACT
Re: DBSNMP user?
It doesn't seem to have DBA here (mostly 8.1.6 databases)... perhaps you were generalizing? It does have RESOURCE tho, which is plenty bad since it pulls in UNLIMITED TABLESPACE behind the scenes. -Original Message- From: lvordos [mailto:[EMAIL PROTECTED]] Sent: Sunday, May 13, 2001 1:25 AM To: ORACLE-L Cc: lvordos Subject: Re: DBSNMP user? And has DBA privs and well-known default passwd, which I alter to a random string (not using OEM here...) Holman, Rodney wrote: Ron, That's the good old Oracle Intelligent Agent for Enterprise Manager. It is the ID that talks to the OEM console for events reporting. Rodd Holman Original Message On 5/11/01, 2:45:31 PM, Smith, Ron L. [EMAIL PROTECTED] wrote regarding DBSNMP user?: I have a user that keeps showing up in my NT database called DBSNMP. The OS user name is SYSTEM. Does anyone know where this user might be coming from? Ron Smith Database Administration [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Holman, Rodney INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SuzyV INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Problem in fetching Table Info
Hi Gurus, I am facing some problem while fetching data from oracle. I have to fetch all info like column_name,data_type,data_length,Nullable and primary key for particular table. For that i had prepared 2 quiries like: select A.column_name,A.data_type, 2 decode(A.data_type,'NUMBER', 3 decode(A.data_precision,NULL,A.data_length,A.data_precision), 4 A.data_length) as Length, 5 A.nullable from 6* user_tab_columns A where table_name = 'TEST' Which gives me info as : COLUMN_NAMEDATA_TYPE LENGTH N -- - -- - FLD1 NUMBER 5 N FLD2 NUMBER 3 N FLD3 VARCHAR2 10 N FLD4 VARCHAR2 30 Y FLD5 VARCHAR2 100 Y FLD6 VARCHAR2 50 Y FLD7 NUMBER22 Y Which is fine,but along with this i want info like which fields are pkey for which i have one more query: select C.column_name,B.constraint_type from user_constraints B,user_cons_columns C where B.constraint_name=C.constraint_name and B.table_name='TEST' which gives me info as to which are pkeys in table, But when i join these 2 quiries i get only 3 fields which are in primary key like FLD1,FLD2,FLD3 COLUMN_NAMEDATA_TYPE LENGTH N C -- - -- - - FLD1 NUMBER 5 N P FLD2 NUMBER 3 N P FLD3 VARCHAR2 10 N P whereas i want all other fields also along with that. Output should be as : COLUMN_NAMEDATA_TYPE LENGTH N -- - -- - FLD1 NUMBER 5 N P FLD2 NUMBER 3 N P FLD3 VARCHAR2 10 N P FLD4 VARCHAR2 30 Y FLD5 VARCHAR2 100 Y FLD6 VARCHAR2 50 Y FLD7 NUMBER22 Y I tried following query for this: 1 select A.column_name,A.data_type, 2 decode(A.data_type,'NUMBER', 3 decode(A.data_precision,NULL,A.data_length,A.data_precision), 4 A.data_length) as Length, 5 A.nullable,B.constraint_type from 6 user_tab_columns A, 7 user_constraints B, 8 user_cons_columns C 9 where 10 B.constraint_name=C.constraint_name and 11 A.column_name=C.column_name(+) and 12 A.table_name=B.table_name and 13* A.table_name = 'GEMS Could any one Help me in this?? TIA Manoj. __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Soman Manoj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Running remote scripts
Rajesh, You can't run interactive commands using rsh. You should be able to put all your commands into a script(s) and execute those. Otherwise try rlogin. Regards, David A. Barbour Rajesh Dayal wrote: Hi All, Env. is TRU64 Unix and Oracle 7.3.4 This is a standby server configuration. I want to run certain scripts(on secondary server), based on some incident on primary server. And on top of that, every thing has to be fully automated(using cron). I got stuck at a point where I need to run some script on secondary without explicitly logging on secondary server. I tried using rsh, but it executes just one single command. I would appreciate if some one can guide me on this. TIA, Rajesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: PostGres WAS: RE: Oracle 9i Articles - self tuning, launch
LOL! Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- From: Gary Boyd [SMTP:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001 10:16 PM To: Multiple recipients of list ORACLE-L Subject:Re: PostGres WAS: RE: Oracle 9i Articles - self tuning, launch Interesting page in the docs http://postgresql.readysetnet.com/users-lounge/docs/7.1/admin/recovery.html At 02:50 PM 05/10/2001 -0800, you wrote: Is it Open Source? also, from your mail, is it true I am sending to you in MIME format? I thought I had turned that off || -Original Message- || From: [EMAIL PROTECTED] || [mailto:[EMAIL PROTECTED]] || Sent: Thursday, May 10, 2001 5:53 PM || To: Multiple recipients of list ORACLE-L || Subject: RE: Oracle 9i Articles - self tuning, launch delayed to || || || || Oooh, I *like* Postgres. I'm having super much fun with it || on a personal || project right now, and I must say they really trump Oracle || on a few things. || Of course, I don't know how it handles large amounts of data || or users or || transactions yet...and I know nothing about the tunability. || But it really || seems to make the easy things easy and the hard things easier which || Oracle certainly doesn't even attempt to do. || || I know, I know, it's an Oracle list, but it's nice to step || out of the box || occasionally. || || Diana Duncan || TITAN Technology Partners || One Copley Parkway, Ste 540 || Morrisville, NC 27560 || VM: 919.466.7337 x 316 || F: 919.466.7427 || E: [EMAIL PROTECTED] || -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gary Boyd INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Imedia query optimization
Title: RE: Imedia query optimization Ranganath, I have found that intermedia queries really bite the biggie without a hint. Read up on the hints /*+ FIRST_ROWS DOMAIN_INDEX_NO_SORT */ There is a chapter in the doco on tuning intermedia queries that discusses the reasons why these hints work. HTH Lisa Rutland Koivu Oracle Database Administrator Certified Self-Important Database Deity Slayer of Unix Administrators Wanton Kickboxing Goddess [EMAIL PROTECTED] NeoMedia 2201 Second St., Suite 600 Fort Myers, FL 33901, USA Phone: 941-337-3434 Fax: 941-337-3668 www.neom.com http://www.neom.com www.paperclick.com http://www.paperclick.com www.qode.com http://www.qode.com P a p e r C l i c k . c o m http://www.paperclick.com/home.htm Enter Your PaperClick Code Here! -Original Message- From: Ranganath K [mailto:[EMAIL PROTECTED]] Sent: Monday, May 14, 2001 7:00 AM To: Multiple recipients of list ORACLE-L Subject: Imedia query optimization Dear DBA Gurus, When I execute the below Intermedia search query which returns around 5 lakh records the query takes a long time to execute. How do I optimize the query to run faster? Below are the details of the table, query and the execution plan below: 1) Table Description: --- * Category Table: PK_CATEGORY_ID NUMBER NOT NULL, PARENT_CATEGORY NUMBER NOT NULL, NAME VARCHAR2 (1000) NOT NULL, DEPTH VARCHAR2 (4000) NOT NULL, STATUS NUMBER NOT NULL, UPDATED_DATETIME DATE, PRIMARY KEY (PK_CATEGORY_ID); * Site Table: PK_SITE_ID NUMBER NOT NULL, FK_CATEGORY NUMBER NOT NULL, TITLE CLOB, URL VARCHAR2 (4000) NOT NULL, DESCRIPTION CLOB, STATUS NUMBER NOT NULL, PAGE_HITS NUMBER NOT NULL, EDITOR_CHOICE VARCHAR2 (10), PRIMARY KEY (PK_SITE_ID); 2) Foreign Key Constraints: --- * ALTER TABLE SITE ADD CONSTRAINT FKSITE FOREIGN KEY (FK_CATEGORY) REFERENCES SAMPLEVIEW.CATEGORY (PK_CATEGORY_ID) ; 3) Query --- select depth from category, site where (site.fk_category in (select pk_category_id from category where category.status = 0)) and site.status = 0 and ((contains (title,'escorts') 0)or (contains (description, 'escorts') 0)) and pk_category_id = fk_category group by depth; 4) Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=107477 Card=22470 Bytes=136572660) 1 0 SORT (GROUP BY) (Cost=107477 Card=22470 Bytes=136572660) 2 1 NESTED LOOPS (Cost=19 Card=22470 Bytes=136572660) 3 2 NESTED LOOPS (Cost=4 Card=15 Bytes=60945) 4 3 TABLE ACCESS (BY INDEX ROWID) OF 'SITE' (Cost=2 Card =1 Bytes=4037) 5 4 BITMAP CONVERSION (TO ROWIDS) 6 5 BITMAP OR 7 6 BITMAP CONVERSION (FROM ROWIDS) 8 7 SORT (ORDER BY) 9 8 DOMAIN INDEX OF 'SITE2TITLEIDEX' (Cost=1) 10 6 BITMAP CONVERSION (FROM ROWIDS) 11 10 SORT (ORDER BY) 12 11 DOMAIN INDEX OF 'SITE1DESCIDX' (Cost=1) 13 3 TABLE ACCESS (BY INDEX ROWID) OF 'CATEGORY' (Cost=1 Card=1499 Bytes=38974) 14 13 INDEX (UNIQUE SCAN) OF 'SYS_C001314' (UNIQUE) 15 2 TABLE ACCESS (BY INDEX ROWID) OF 'CATEGORY' (Cost=1 Card=149802 Bytes=301851030) 16 15 INDEX (UNIQUE SCAN) OF 'SYS_C001314' (UNIQUE) Any help in this regard will be highly appreciated. TIA and Warm Regards, Ranganath -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ranganath K INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: DBSNMP user?
I believe as of 8.1.6, Oracle removed DBA from DBSNMP (and MDSYS and CTXSYS and ORDSYS and..) From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: DBSNMP user? Date: Mon, 14 May 2001 05:55:42 -0800 It doesn't seem to have DBA here (mostly 8.1.6 databases)... perhaps you were generalizing? It does have RESOURCE tho, which is plenty bad since it pulls in UNLIMITED TABLESPACE behind the scenes. -Original Message- From: lvordos [mailto:[EMAIL PROTECTED]] Sent: Sunday, May 13, 2001 1:25 AM To: ORACLE-L Cc: lvordos Subject: Re: DBSNMP user? And has DBA privs and well-known default passwd, which I alter to a random string (not using OEM here...) Holman, Rodney wrote: Ron, That's the good old Oracle Intelligent Agent for Enterprise Manager. It is the ID that talks to the OEM console for events reporting. Rodd Holman Original Message On 5/11/01, 2:45:31 PM, Smith, Ron L. [EMAIL PROTECTED] wrote regarding DBSNMP user?: I have a user that keeps showing up in my NT database called DBSNMP. The OS user name is SYSTEM. Does anyone know where this user might be coming from? Ron Smith Database Administration [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Holman, Rodney INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SuzyV INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Can I partition my primary key constraint index?
Diana, Can I build the initial local primary key index using the storage and tablespace clause to place the index in the correct index tablespace to begin with. This index is multiple gigs and my database is tight on space right now. I'm not sure that I have enough room to put the index in the data tablespace and then move it to the appropriate index partition tablespaces? Do you put each of your primary key index partitions in a separate tablespace? The last DBA put all of our indexes into three tablespaces (small, medium, large) which doesn't work very well when you go to get rid of a partition. Thanks, Cherie Diana_Duncan@ttpa rtners.com To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Re: Can I partition my primary key constraint index? 05/13/01 02:55 PM Please respond to ORACLE-L Yes, Cherie, you can. When creating the primary key constraint, use the USING INDEX clause to specify any storage parameters you want for the automatically created primary key index. I always use the clause, because I am a picky DBA and I want my indices in their own tablespace and with their own storage parameters. Also, if you specify that the index is LOCAL, the partitioning will follow the same algorithm as the table. Unfortunately, if you do LOCAL, the index partitions will automatically be placed in the same tablespace as the table, but you can move the partitions if you wish. HTH, Diana Duncan TITAN Technology Partners One Copley Parkway, Ste 540 Morrisville, NC 27560 VM: 919.466.7337 x 316 F: 919.466.7427 E: [EMAIL PROTECTED] Cherie_Machler @gelco.comTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Fax to: omSubject: Can I partition my primary key constraint index? 05/11/2001 04:51 PM Please respond to ORACLE-L Oracle will automatically create an index for your primary key constraint. I have a lot of large partitioned tables in my data warehouse. All of my primary key indexes are non-partitioned. I would like them to be partitioned. When I drop the constraint and re-enable it, can I specify at that time that I want the index to be partitioned? Or do I need to drop my index and rebuild it to be partitioned after the fact? Is there any problem with having partitioned primary key indexes? Thanks, Cherie -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may
RE: When to go for ORACLE NAMES Server
Nope! Most of the TNSNAMES.ORA files on my servers are empty, and IA still works (at least as much as can be expected). Perhaps LISTENER.ORA is what you were thinking of? Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Hillman, Alex [mailto:[EMAIL PROTECTED]] Sent: Monday, May 14, 2001 09:55 To: Multiple recipients of list ORACLE-L Subject: RE: When to go for ORACLE NAMES Server I beleave intelligent agent requires tnsnames.ora also. Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: PostGres WAS: RE: Oracle 9i Articles - self tuning, launch
Title: RE: PostGres WAS: RE: Oracle 9i Articles - self tuning, launch OMG is that FUNNY I just woke everyone with my 'quiet' laugh ! -Original Message- From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]] Sent: Monday, May 14, 2001 11:51 AM To: Multiple recipients of list ORACLE-L Subject: RE: PostGres WAS: RE: Oracle 9i Articles - self tuning, launch LOL! Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- From: Gary Boyd [SMTP:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001 10:16 PM To: Multiple recipients of list ORACLE-L Subject: Re: PostGres WAS: RE: Oracle 9i Articles - self tuning, launch Interesting page in the docs http://postgresql.readysetnet.com/users-lounge/docs/7.1/admin/recovery.html At 02:50 PM 05/10/2001 -0800, you wrote: Is it Open Source? also, from your mail, is it true I am sending to you in MIME format? I thought I had turned that off || -Original Message- || || [mailto:[EMAIL PROTECTED]] || Sent: Thursday, May 10, 2001 5:53 PM || To: Multiple recipients of list ORACLE-L || || || || || Oooh, I *like* Postgres. I'm having super much fun with it || on a personal || project right now, and I must say they really trump Oracle || on a few things. || Of course, I don't know how it handles large amounts of data || or users or || transactions yet...and I know nothing about the tunability. || But it really || seems to make the easy things easy and the hard things easier which || Oracle certainly doesn't even attempt to do. || || I know, I know, it's an Oracle list, but it's nice to step || out of the box || occasionally. || || Diana Duncan || TITAN Technology Partners || One Copley Parkway, Ste 540 || Morrisville, NC 27560 || VM: 919.466.7337 x 316 || F: 919.466.7427 || E: [EMAIL PROTECTED] || -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gary Boyd INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: comp.oracle.databases.server vs ORACLE-L: deathmatch
Funny, the threads on my MS Outlook at home never show up as threads... I end up with little entries all over the place. Might as well rely on e-mail. The volume on the newsgroup is much higher, but perhaps as a result there is a LOT of junk going through there, a lot of spam. Some of it is offensive, nobody seems to be moderating that newsgroup at all. The listserv doesn't have that problem, the last time someone sent job offers to the members of this list, the sender received phone calls, and a flurry of e-mails to tell him to cease and desist. On the newsgroup I haven't seen it happen. Maybe if the spam was removed from the newsgroup, I would spend more time reading its threads. The threads also seem to cover a broader range of topics than this listserv does. I prefer this list because I do database admin, and although I subscribed to the ODTUG listserv for developers, I like to keep the two areas separate (DBA and development). Once in a while in the evening I access the newsgroup to see what is going on there, but often I end up sifting through hundreds of entries, deleting 80% of them or more. I agree that there are knowledgeable people on the newsgroup as well. I prefer this listserv. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- From: Paul Drake [SMTP:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001 4:40 AM To: Multiple recipients of list ORACLE-L Subject:comp.oracle.databases.server vs ORACLE-L: deathmatch I have to say that the newsgroup comp.oracle.databases.server is much more NT Friendly. (IOUG: Did anything happen from IOUG concerning the ORACLE-NT-L mailing list?) Not just Jonathan Lewis, but Sybrand Baker, Howard Rodgers, Ricky Sanchez put out some pretty good stuff. I'd post to the ORACLE-L from work - but its a long story. Basically, I'm subscribed at work in DIGEST mode, but I can't get out of it. So I post when I get home from the home mail account that I can't use from work. Yes, most of the newsgroup is junk, but lately, I'd say that the signal-to-noise ratio is comperable to ORACLE-L. Best thing is - its threaded. Email just plain sucks. Threading rules (not in an OS - just in messages). and there's (practically) no lag. So in a deathmatch, the interested newsgroup readers/posters would have won the competition 2 hours before the first post was received by all the ORACLE-L subscribers. just my opinion. the attached is typical for the material I see in the newsgroup. Paul Original Message Date: Wed, 09 May 2001 04:56:31 GMT Organization: Excite@Home - The Leader in Broadband pricing hikes http://home.com/hike_revenue_faster Newsgroups: comp.databases.oracle.server References: u0SJ6.9519$[EMAIL PROTECTED] Syltrem wrote: Hi! When you shutdown an NT system, how do you ensure that the Oracle DB is shutdown properly? Other than connecting manually and doing a shutdown immediate, that is. I would like the process of shutting down Oracle to be automatic. Thanks! -- If you installed the Oracle Administration Assistant for Windows NT, there is a panel that contains a radio button as to selecting the shutdown mode ('normal','immediate','abort'). to access it select: Start - Programs - Oracle-Ora81 - Database Administration - Oracle Administration Assistant for Windows NT under the 'Databases' node, right click on the particular database and select startup shutdown options in the Oracle Instance panel, you have a checkbox for Shut down instance when service is stopped under that is the radio button set for the shutdown options. click ok - and close the MMC console. If you are running W2K server or Pro - MMC is included. If you are running NT4 - you need to have installed the MMC for the Oracle Admin Asst plug-in. hth, Paul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Drake INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
RE: DBSNMP user?
Is OracleOraHome81Agent the OEM agent? -Original Message- Sent: Monday, May 14, 2001 8:05 AM To: Multiple recipients of list ORACLE-L You can run the catnsnmp.sql script from rdbms/admin to get rid of it... Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- From: SuzyV [SMTP:[EMAIL PROTECTED]] Sent: Sunday, May 13, 2001 3:25 AM To: Multiple recipients of list ORACLE-L Subject:Re: DBSNMP user? And has DBA privs and well-known default passwd, which I alter to a random string (not using OEM here...) Holman, Rodney wrote: Ron, That's the good old Oracle Intelligent Agent for Enterprise Manager. It is the ID that talks to the OEM console for events reporting. Rodd Holman Original Message On 5/11/01, 2:45:31 PM, Smith, Ron L. [EMAIL PROTECTED] wrote regarding DBSNMP user?: I have a user that keeps showing up in my NT database called DBSNMP. The OS user name is SYSTEM. Does anyone know where this user might be coming from? Ron Smith Database Administration [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Holman, Rodney INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SuzyV INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message
Re: AFTER LOGON ON SCHEMA Trigger 8.1.6 .. HELP!
Allowing people to create objects on the fly sounds like bad news to me... Anyway, one possible workaround would be to have your trigger schedule a dbms_job to perform the grants. Then your grants would take place shortly after the ddl had been performed... hth connor --- Arul kumar [EMAIL PROTECTED] wrote: Hi Everybody, I am using oracle 8.1.6 db. I want to create a trigger which fires for every new object created in a particular schema. Basically, i want to grant privileges for this newly created object to Roles, Users dynamically as and when the new object created. When i tried , the trigger got created but on creating a table in that schema reported that DDLs are not allowed in System triggers except ALTERCOMPILE... - command failed. Is there any workaround to achieve issuing DDLs ? Thanks. Regards, Arul. = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
imp/exp privilege ?
Good morning all, Scenario: UserA/sid=testA UserB/sid=testB Problem: How can I create the environment that allows UserA to export his schema, and UserB can import fromuser=UserA touser=UserB. I do NOT want to grant the roles imp_full_database/exp_full_database to these users, because this allows them too many dba-type privileges including create tablespace, etc. Any help would be greatly appreciated. TIA Nechama Glasrot Oracle DBA Seisint, Inc. 6601 Park of Commerce Blvd. Boca Raton, Florida 33487 nglasrot mailto:[EMAIL PROTECTED] This transmission may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glasrot, Nechama INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Should Archive Log File OS Size be the same?
Oracle 8.1.5 and 7.3.4.5 No Alter System switch logfile performed. NT 4.0 I am testing some recovery plans, and I tried to restore a cold backup and roll the database forward. However, when I went to apply the 1st archive log since the cold backup it complained about a size of the transaction and indicated the archive log was corrupted. When I review all the archive logs on the production system I notice the OS size of the files are not always the exact same. Should they be the exact same size assuming that no one does an alter system switch logfile command? The archive logs are 10MB each and some appear to be off 1-4k Normal = 10241, Others = 10,237,10240,10238) Thanks, Jim Jim Walski ClassicPlan Chino, CA 91710 email [EMAIL PROTECTED] http://www.classicplan.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Walski INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
wwsec_sso_enabler
Hello, while building my portlet i came across this strengh expression: wwsec_sso_enabler_private What is it? Where can I find documentation covering this topic Thank you in advance Pawel -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Duplicate DB to different host using RMAN/Veritas Netbackup .
Hi, Babu, Please, check if you have the following steps done: 1. NetBackup SERVER side: create permission files to allow alternate client restore: File NETBACKUP PATH/db/altnames/restore client name should contain primary backup client name 2. NetBackup CLIENT side: a/ set UNIX env variable NB_ORA_CLIENT=backup client; export NB_ORA_CLIENT, b/ set ORACLE_SID to original DB SID 3. restore infrastructure (like appropriate directories, UNIX permissions, init.ora) should be ready. HTH Vadim Gorbounov Brainbench Master Oracle DBA www.brainbench.com -Original Message- Sent: Friday, May 11, 2001 7:50 PM To: Multiple recipients of list ORACLE-L ...he Dear List, I have a target database on host A and trying to duplicate to host B and getting the following errors. It seems to me that host B is unable to read the RMAN backup (tape file) created by host A. I tried setting NSR_CLIENT variable at unix level, but without any success. If I take disk backup, I could create the duplicate database without any problem. Could someone give me any advice. The error message is as foollows: We are using Veritas Netbackup and Oracle 8.1.6.2 (64bit) on HP-UX 11.0 RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-03015: error occurred in stored script duprtest_from_tape RMAN-03002: failure during compilation of command RMAN-03013: command type: Duplicate Db RMAN-03015: error occurred in stored script Memory Script RMAN-03002: failure during compilation of command RMAN-03013: command type: restore RMAN-03007: retryable error occurred during execution of command: IRESTORE RMAN-07004: unhandled exception during command execution on channel ch1 RMAN-10035: exception raised in RPC: ORA-19507: failed to retrieve sequential file, handle=Spl_DB_97cphqgk_1_1, parms= ORA-27029: skgfrtrv: sbtrestore returned error ORA-19511: sbtrestore: Backup file not found. RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.RESTOREBACKUPPIECE Thanks ... Babu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Janardhana Babu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vadim Gorbounov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle 8i installation problem on Pentium 4
Hi, everyone: I had problem installing Oracle 8.1.7.0 on my Petium 4 machine running Windows Me. I changed the scripts to use -nojit option, however, when I was installing, only Oracle Cllients was installed. Any idea? TIA Matt -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
NOLOGGING/LOGGING
Title: RE: Intermedia I am curious to know if the NOLOGGING option would work in an update or insert statement, I mean by using NOLOGGING in an update statement can writes to the redo log be turned off fora particular update or insert operation for that matter. Specially for huge updates where heavy log switches are possible filling up the archive log directory. Please let me know if this can be done. example in a situation where 10 Million rows need to updated. update temp NOLOGGING set zip=11003 where city='Boston' / Thank you
svrmgrl return code
Title: svrmgrl return code on unix (hpux 11) can svrmgrl return any value other than a zero (0)? even a exit 1 returns a 0 to the calling script R. Matt Adams - GE Appliances - [EMAIL PROTECTED] Meddle not in the affairs of troff, for it is subtle and quick to anger.
RE: comp.oracle.databases.server vs ORACLE-L: deathmatch
I just tried c.d.o.* (example news:comp.databases.oracle.server ) with Netscape 4.75, and threading works fine as far as I can tell. Based on what is stored of those newsgroups here (only goes back about 1 or 2 weeks), I didn't see any huge amount of spam. regards, ep On 14 May 2001, at 7:56, Boivin, Patrice J wrote: Date sent: Mon, 14 May 2001 07:56:13 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Funny, the threads on my MS Outlook at home never show up as threads... I end up with little entries all over the place. Might as well rely on e-mail. ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Can I partition my primary key constraint index?
Cherie, Hm, good question. I think I remember (unfortunately, this was at my previous job, so I don't have the scripts) that in order to specify LOCAL, you lost control of the storage parameters -- they automatically default to the same as the table. But it's certainly worth a try. I created separate data and index tablespaces for each partition, which made the dropping of a partition and it's associated space quite simple. Diana Duncan TITAN Technology Partners One Copley Parkway, Ste 540 Morrisville, NC 27560 VM: 919.466.7337 x 316 F: 919.466.7427 E: [EMAIL PROTECTED] Cherie_Machler @gelco.comTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Fax to: omSubject: Re: Can I partition my primary key constraint index? 05/14/2001 10:17 AM Please respond to ORACLE-L Diana, Can I build the initial local primary key index using the storage and tablespace clause to place the index in the correct index tablespace to begin with. This index is multiple gigs and my database is tight on space right now. I'm not sure that I have enough room to put the index in the data tablespace and then move it to the appropriate index partition tablespaces? Do you put each of your primary key index partitions in a separate tablespace? The last DBA put all of our indexes into three tablespaces (small, medium, large) which doesn't work very well when you go to get rid of a partition. Thanks, Cherie Diana_Duncan@ttpa rtners.com To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Re: Can I partition my primary key constraint index? 05/13/01 02:55 PM Please respond to ORACLE-L Yes, Cherie, you can. When creating the primary key constraint, use the USING INDEX clause to specify any storage parameters you want for the automatically created primary key index. I always use the clause, because I am a picky DBA and I want my indices in their own tablespace and with their own storage parameters. Also, if you specify that the index is LOCAL, the partitioning will follow the same algorithm as the table. Unfortunately, if you do LOCAL, the index partitions will automatically be placed in the same tablespace as the table, but you can move the partitions if you wish. HTH, Diana Duncan TITAN Technology Partners One Copley Parkway, Ste 540 Morrisville, NC 27560 VM: 919.466.7337 x 316 F: 919.466.7427 E: [EMAIL PROTECTED] Cherie_Machler @gelco.comTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Fax to: omSubject: Can I partition my primary key constraint index? 05/11/2001 04:51 PM Please respond to ORACLE-L Oracle will automatically create an index for your primary key constraint. I have a lot of large partitioned tables in my data warehouse. All of my primary key indexes are non-partitioned. I would like them to be partitioned. When I drop the constraint and re-enable it, can I specify at that time that I want the index to be partitioned? Or do I need to drop my index and rebuild it to be partitioned after the fact? Is there any problem with having
RE: Dead Lock in Temporary Tables 8.1.6 ... HELP !
Hi, Arul, Do you have index on this table? If yes, can you drop this index and try how it works? You may hit a bug. HTH Vadim -Original Message- Sent: Monday, May 14, 2001 6:40 AM To: Multiple recipients of list ORACLE-L Hi Ora DBAs, I am working on Oracle 8.1.6 version on SUN SOLARIS 5.6 platform. We r using a backend procedure which first TRUNCATEs a table ( GLOBAL TEMPORARY TABLE - created with ON COMMIT PRESERVE ROWS !) and then populates with data. After making a connection to the database, first time when executed reports a DEAD LOCK on the table and comes out. Same procedure, if executed once again doesn't report any error. It reports the error only for the first time after a connection is established. Why ? I am sure there was no other user using that table at the time of procedure execution. Thanks in advance. Regards, Arul. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arul kumar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vadim Gorbounov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Can I partition my primary key constraint index?
Ok, I'll jump in here 'cause I may be able to simplify the issue. Starting with Oracle 8, you can create a Primary Key that uses an existing index. This makes the administration stuff easier. You can create your own locally partitioned unique index (using regular CREATE INDEX syntax). Once the index is created, you can create the PK (ALTER TABLE x ADD CONSTRAINT y PRIMARY KEY (z);). The existing index will be used if Oracle can use it. This works with partitioned tables as long as the PK index is equipartitioned with the base table. Kevin -Original Message- Sent: Monday, May 14, 2001 10:17 AM To: Multiple recipients of list ORACLE-L Diana, Can I build the initial local primary key index using the storage and tablespace clause to place the index in the correct index tablespace to begin with. This index is multiple gigs and my database is tight on space right now. I'm not sure that I have enough room to put the index in the data tablespace and then move it to the appropriate index partition tablespaces? Do you put each of your primary key index partitions in a separate tablespace? The last DBA put all of our indexes into three tablespaces (small, medium, large) which doesn't work very well when you go to get rid of a partition. Thanks, Cherie Diana_Duncan@ttpa rtners.com To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Re: Can I partition my primary key constraint index? 05/13/01 02:55 PM Please respond to ORACLE-L Yes, Cherie, you can. When creating the primary key constraint, use the USING INDEX clause to specify any storage parameters you want for the automatically created primary key index. I always use the clause, because I am a picky DBA and I want my indices in their own tablespace and with their own storage parameters. Also, if you specify that the index is LOCAL, the partitioning will follow the same algorithm as the table. Unfortunately, if you do LOCAL, the index partitions will automatically be placed in the same tablespace as the table, but you can move the partitions if you wish. HTH, Diana Duncan TITAN Technology Partners One Copley Parkway, Ste 540 Morrisville, NC 27560 VM: 919.466.7337 x 316 F: 919.466.7427 E: [EMAIL PROTECTED] Cherie_Machler @gelco.comTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Fax to: omSubject: Can I partition my primary key constraint index? 05/11/2001 04:51 PM Please respond to ORACLE-L Oracle will automatically create an index for your primary key constraint. I have a lot of large partitioned tables in my data warehouse. All of my primary key indexes are non-partitioned. I would like them to be partitioned. When I drop the constraint and re-enable it, can I specify at that time that I want the index to be partitioned? Or do I need to drop my index and rebuild it to be partitioned after the fact? Is there any problem with having partitioned primary key indexes? Thanks, Cherie -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Toepke, Kevin M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet
RE: Oracle 8i installation problem on Pentium 4
Please see bug #1507768 on MetaLink. If you look towards the bottom at 3/23/2001 you will see an update that describes replacing some DLLs with ones from a newer version of JRE that performs the CPUID on a P4 correctly. I had this same issue at home, but on Win2000, and the 3/23 note worked great. HTH -wk -Original Message- Sent: Monday, May 14, 2001 11:31 AM To: Multiple recipients of list ORACLE-L Hi, everyone: I had problem installing Oracle 8.1.7.0 on my Petium 4 machine running Windows Me. I changed the scripts to use -nojit option, however, when I was installing, only Oracle Cllients was installed. Any idea? TIA Matt -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Warren Kassel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Installing Multiple Oracle Clients
1) What is the easiest way to do these local installations? With the old 16-bit version of the Oracle client, you could do a network install, then have the workstations reference that installation by changing ini files. I don't think that the 32-bit version of the client supports network installs. Has anybody had success with response files? What is the trick to getting them to work? Anyway, I'm looking for an alternative to visiting each workstation. I used response file for 8.1.6 on Solaris 2.6 with xterm from a windows machine. Works great! 1. Create home dir and get .profile etc and set environment 2. Remote mount CD 3. Install Client with .rsp 4. Scripted FTP : tnsnames.ora 5. Test connection All through a sequence of commands. No mouse clicking. Now going to machine. No taking out putting in CDs... -Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul Dandekar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: NOLOGGING/LOGGING
There was similar Q from Vikas@innoventry a few days back You cannot turn off logging. Reason: Search through your mails dated 3 days back. Rajaram. -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Monday, May 14, 2001 12:36 PM To: Multiple recipients of list ORACLE-L Subject:NOLOGGING/LOGGING I am curious to know if the NOLOGGING option would work in an update or insert statement, I mean by using NOLOGGING in an update statement can writes to the redo log be turned off for a particular update or insert operation for that matter. Specially for huge updates where heavy log switches are possible filling up the archive log directory. Please let me know if this can be done. example in a situation where 10 Million rows need to updated. update temp NOLOGGING set zip=11003 where city='Boston' / Thank you NetZero Platinum No Banner Ads and Unlimited Access Sign Up Today - Only $9.95 per month! http://www.netzero.net -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajaram INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: http://www.mindspring.com/~hayden/white.htm
Hi, starting here: http://www.google.com/search?q=hayden+oracle+white+paperhl=enlr=safe=offstart=10sa=N Look at page #2 of results (there are a *LOT* of hayden worthington hits about Oracle performance white papers. Most of the links are the same, or similar to yours, and they are DEAD LINKS. However, on the Tim Onions page: http://www.timonions.com/tlinks.html There is a link w/ title of Hayden Worthington?: http://www.allenhayden.com/ On that page, see the resume, page 3 specifically references hayden worthington: http://www.allenhayden.com/resume3.html so, I think that is probably it! The actual hayden white papers: (looks like free registration is required) http://www.allenhayden.com/whitepapers.html email: [EMAIL PROTECTED] follow up link to the thread on self tuning/self managing features in Oracle9i: http://www.zdnet.com/ecommerce/stories/main/0,10475,2716337,00.html The Hayden site is outstanding, thanks for bringing it to my attention! regards, ep cc: [EMAIL PROTECTED] On 13 May 2001, at 23:45, Shevtsov, Eduard wrote: Date sent: Sun, 13 May 2001 23:45:24 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Hello List, I believe this address is well-known for DBAs. I was looking for some good articles there, but it seems the link doesn't work anymore. Does someone know where the pages have been moved to ? Thanks for your help. Ed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shevtsov, Eduard INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle 8i installation problem on Pentium 4
Matt, AFAIK, there aren't any products certified with Windows ME (it isn't even listed as a platform on the certification page on metalink). Isn't that the successor to Windows98, though? In which case all it would support would be client tools anyway. HTH, -- Anita --- [EMAIL PROTECTED] wrote: Hi, everyone: I had problem installing Oracle 8.1.7.0 on my Petium 4 machine running Windows Me. I changed the scripts to use -nojit option, however, when I was installing, only Oracle Cllients was installed. Any idea? TIA Matt -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Running remote scripts
ssh is your friend. oli [EMAIL PROTECTED] wrote Hi All, Env. is TRU64 Unix and Oracle 7.3.4 This is a standby server configuration. I want to run certain scripts(on secondary server), based on some incident on primary server. And on top of that, every thing has to be fully automated(using cron). I got stuck at a point where I need to run some script on secondary without explicitly logging on secondary server. I tried using rsh, but it executes just one single command. I would appreciate if some one can guide me on this. TIA, Rajesh -- Oliver Artelt Oracle Certified DBA cubeoffice GmbH Co.KG # jordanstrasse 7 # 39112 magdeburg telefon: +49 (0)391 6 11 28 10 # telefax: +49 (0)391 6 11 28 19 email: [EMAIL PROTECTED] # web: http://www.cubeoffice.de -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Oliver Artelt INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: svrmgrl return code
Matt, Control backslash gives me 131. Is that enough ;) - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: Adams, Matthew (GEA, 088130) [SMTP:[EMAIL PROTECTED]] Sent: Monday, May 14, 2001 11:36 AM To: Multiple recipients of list ORACLE-L Subject: svrmgrl return code on unix (hpux 11) can svrmgrl return any value other than a zero (0)? even a exit 1 returns a 0 to the calling script R. Matt Adams - GE Appliances - [EMAIL PROTECTED] Meddle not in the affairs of troff, for it is subtle and quick to anger. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Installing Multiple Oracle Clients
I really did not understand what you did. A little bit more details please. My understanding of the question was - how to install Oracle client on multiple Windows machines. Alex Hillman -Original Message- Sent: Monday, May 14, 2001 1:51 PM To: Multiple recipients of list ORACLE-L 1) What is the easiest way to do these local installations? With the old 16-bit version of the Oracle client, you could do a network install, then have the workstations reference that installation by changing ini files. I don't think that the 32-bit version of the client supports network installs. Has anybody had success with response files? What is the trick to getting them to work? Anyway, I'm looking for an alternative to visiting each workstation. I used response file for 8.1.6 on Solaris 2.6 with xterm from a windows machine. Works great! 1. Create home dir and get .profile etc and set environment 2. Remote mount CD 3. Install Client with .rsp 4. Scripted FTP : tnsnames.ora 5. Test connection All through a sequence of commands. No mouse clicking. Now going to machine. No taking out putting in CDs... -Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul Dandekar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Can I partition my primary key constraint index?
Kevin, Thanks for your comments. I already have the existing (non-partitioned) index out there. Is there any way to convert this to a locally partitioned index? I see ways to split existing partitioned indexes into additional partitions but I don't see any documentation on changing a regular index into paritioned index. It's quite large and cumbersome so I hate to just drop it and recreate it. Isn't a local index by definition equipartitioned against the base table? I don't have to intentionally do anything to have that happen except place the LOCAL clause in the CREATE INDEX command, right? Under what cirmcumstances might Oracle not be able to use the existing index when I add the primary key constraint? Thanks, Cherie Toepke, Kevin M To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] [EMAIL PROTECTED]cc: ndant.com Subject: RE: Can I partition my primary key constraint index? Sent by: [EMAIL PROTECTED] m 05/14/01 12:36 PM Please respond to ORACLE-L Ok, I'll jump in here 'cause I may be able to simplify the issue. Starting with Oracle 8, you can create a Primary Key that uses an existing index. This makes the administration stuff easier. You can create your own locally partitioned unique index (using regular CREATE INDEX syntax). Once the index is created, you can create the PK (ALTER TABLE x ADD CONSTRAINT y PRIMARY KEY (z);). The existing index will be used if Oracle can use it. This works with partitioned tables as long as the PK index is equipartitioned with the base table. Kevin -Original Message- Sent: Monday, May 14, 2001 10:17 AM To: Multiple recipients of list ORACLE-L Diana, Can I build the initial local primary key index using the storage and tablespace clause to place the index in the correct index tablespace to begin with. This index is multiple gigs and my database is tight on space right now. I'm not sure that I have enough room to put the index in the data tablespace and then move it to the appropriate index partition tablespaces? Do you put each of your primary key index partitions in a separate tablespace? The last DBA put all of our indexes into three tablespaces (small, medium, large) which doesn't work very well when you go to get rid of a partition. Thanks, Cherie Diana_Duncan@ttpa rtners.com To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Re: Can I partition my primary key constraint index? 05/13/01 02:55 PM Please respond to ORACLE-L Yes, Cherie, you can. When creating the primary key constraint, use the USING INDEX clause to specify any storage parameters you want for the automatically created primary key index. I always use the clause, because I am a picky DBA and I want my indices in their own tablespace and with their own storage parameters. Also, if you specify that the index is LOCAL, the partitioning will follow the same algorithm as the table. Unfortunately, if you do LOCAL, the index partitions will automatically be placed in the same tablespace as the table, but you can move the partitions if you wish. HTH, Diana Duncan TITAN Technology Partners One Copley Parkway, Ste 540 Morrisville, NC
RE: Oracle 8i installation problem on Pentium 4
Matt, What version of Oracle 8.1.7 are you trying to install? Actually, for which platform is your CD? The only version that you can install on ME is Personal Oracle, not Enterprise Edition or Standard Edition. Ed Haskins Oracle DBA Verizon Wireless -Original Message- Sent: Monday, May 14, 2001 12:31 PM To: Multiple recipients of list ORACLE-L Hi, everyone: I had problem installing Oracle 8.1.7.0 on my Petium 4 machine running Windows Me. I changed the scripts to use -nojit option, however, when I was installing, only Oracle Cllients was installed. Any idea? TIA Matt -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Haskins, Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: NOLOGGING/LOGGING
Thanks Rajaram ! Here's the bottom line : NOLOGGING doesn't apply to conventional DML at all ! It applies only to CREATE/ALTER objects and Direct Load Inserts such as using SqlLoader or INSERT as SELECT -Original Message- Sent: Monday, May 14, 2001 10:56 AM To: Multiple recipients of list ORACLE-L There was similar Q from Vikas@innoventry a few days back You cannot turn off logging. Reason: Search through your mails dated 3 days back. Rajaram. -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Monday, May 14, 2001 12:36 PM To: Multiple recipients of list ORACLE-L Subject:NOLOGGING/LOGGING I am curious to know if the NOLOGGING option would work in an update or insert statement, I mean by using NOLOGGING in an update statement can writes to the redo log be turned off for a particular update or insert operation for that matter. Specially for huge updates where heavy log switches are possible filling up the archive log directory. Please let me know if this can be done. example in a situation where 10 Million rows need to updated. update temp NOLOGGING set zip=11003 where city='Boston' / Thank you NetZero Platinum No Banner Ads and Unlimited Access Sign Up Today - Only $9.95 per month! http://www.netzero.net -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajaram INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vikas Kawatra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: NOLOGGING/LOGGING
thanks -Original Message- Sent: Monday, May 14, 2001 2:39 PM To: Multiple recipients of list ORACLE-L Thanks Rajaram ! Here's the bottom line : NOLOGGING doesn't apply to conventional DML at all ! It applies only to CREATE/ALTER objects and Direct Load Inserts such as using SqlLoader or INSERT as SELECT -Original Message- Sent: Monday, May 14, 2001 10:56 AM To: Multiple recipients of list ORACLE-L There was similar Q from Vikas@innoventry a few days back You cannot turn off logging. Reason: Search through your mails dated 3 days back. Rajaram. -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Monday, May 14, 2001 12:36 PM To: Multiple recipients of list ORACLE-L Subject:NOLOGGING/LOGGING I am curious to know if the NOLOGGING option would work in an update or insert statement, I mean by using NOLOGGING in an update statement can writes to the redo log be turned off for a particular update or insert operation for that matter. Specially for huge updates where heavy log switches are possible filling up the archive log directory. Please let me know if this can be done. example in a situation where 10 Million rows need to updated. update temp NOLOGGING set zip=11003 where city='Boston' / Thank you NetZero Platinum No Banner Ads and Unlimited Access Sign Up Today - Only $9.95 per month! http://www.netzero.net -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajaram INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vikas Kawatra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Installing Multiple Oracle Clients
Hi, It's not used by many people. But, If you have many clients, you can install client softwares on application server or different home on database server. do followings: - map a server in which client softwares will be installed, such as 'L:' - install client softwares to 'L:' - export Oracle registry - import registry to other clients according to my test in previous years, Oracle just creates windows programs folders on client boxes which is not defined in registry. this is not important. during connection, client software is copied to client from server. if performance is acceptable, you can use these configuration without installing to many clients. Jay Hostetter wrote: We are preparing to upgrade our Oracle client installation on our NT workstations. For the most part, we are still running the 7.3 Oracle client. We are preparing to install 8.1.6, 8.0.5, and possibly 8.0.4 versions of the Oracle client. Unfortunately, we have various 3rd party applications that are only certified with specific versions of the client - and of course they are not all the same Oracle client versions. The 8.1.6 client will be the default Oracle home, then we will install 8.0.5 and 8.0.4 on those PCs that require it. We will use .bat files for those applications that need the 8.0.4 or 8.0.5 version of the client. The .bat files will change the PATH and ORACLE_HOME, then call the application. It looks like we are going to have to visit each PC to do a local install of the appropriate Oracle client(s). I am looking for input in two areas: 1) What is the easiest way to do these local installations? With the old 16-bit version of the Oracle client, you could do a network install, then have the workstations reference that installation by changing ini files. I don't think that the 32-bit version of the client supports network installs. Has anybody had success with response files? What is the trick to getting them to work? Anyway, I'm looking for an alternative to visiting each workstation. 2) Is there an alternative to using .bat files for referencing a different Oracle client? Do many folks take the risk of using a newer version of the Oracle client for an application, even though that application is not certified with that version of the Oracle client? Thanks for the input. Jay Hostetter Oracle DBA D. E. Communications Ephrata, PA USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Use itrprof SQL Analyzer. itrprof SQL Analyzer is a web based tool which analyzes SQL_TRACE/Event10046 trace files of Oracle, finds bottlenecks and offersinformation on how to tune them. No download, no setup, just click http://www.unal-bilisim.com/products/itrprof/itrprof.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: http://www.mindspring.com/~hayden/white.htm
Eric, thanks for your help! I've found what I was looking for. Regards, Ed Hi, starting here: http://www.google.com/search?q=hayden+oracle+white+paperhl=enlr=safe=offstart=10sa=N Look at page #2 of results (there are a *LOT* of hayden worthington hits about Oracle performance white papers. Most of the links are the same, or similar to yours, and they are DEAD LINKS. However, on the Tim Onions page: http://www.timonions.com/tlinks.html There is a link w/ title of Hayden Worthington?: http://www.allenhayden.com/ On that page, see the resume, page 3 specifically references hayden worthington: http://www.allenhayden.com/resume3.html so, I think that is probably it! The actual hayden white papers: (looks like free registration is required) http://www.allenhayden.com/whitepapers.html email: [EMAIL PROTECTED] follow up link to the thread on self tuning/self managing features in Oracle9i: http://www.zdnet.com/ecommerce/stories/main/0,10475,2716337,00.html The Hayden site is outstanding, thanks for bringing it to my attention! regards, ep -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shevtsov, Eduard INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
sys.IDL_UB1$
Does anyone know what the SYS.IDL_UB1$ table is? It suddenly grew to app. 100Meg in my Development database. I tried searching on it on Ixora on Friday but as soon as I did my computer crashed. Now that I'm back up I decided it might be safer to post here :). Thanks in advance, Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OT: a bit of a brag...
My eldest graduated from college Saturday. A double major in Spanish and German, cum laude, and a Fullbright scholar. I'm proud of the boy!;-) Follow the link below for a nice picture and a little blurb. http://www.naz.edu/academics/fulbright/scholars.cfm -- Bill Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ Microwave: Signal from a friendly micro... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 8i installation problem on Pentium 4
I had this problem while installing on my Pentium 4 machine. I raised a tar for this and as per their instructions, I could install 817 on Pentium. I quoting the contents of the tar for your reference. If you have any problems, please contact me directly. Oracle Tar instructions: Please review bug 1507768 and doc id 131299.1 out on metalink, you can view them by doing an 'advanced' search This is a known issue with the OUI and Intel pentium 4. The workaround is listed in note 131299.1 If you have problems with this you can follow the simplied instructions below.. Problem: Oracle Universal Installer will not run on Intel Pentium Machines Solution: 1. Create a temporary directory on your server. 2. Copy the contents of the Oracle Server CD to the temporary directory created in step 1. 3. Search the directory structure created in step 1 for the existence of the filename symcjit.dll. 4. Rename each copy of the symcjit.dll to symcjit.old. 5. Run the setup.exe from the \install\win32 directory and install Oracle 8.1.x. Rao [EMAIL PROTECTED] -Original Message- Sent: Monday, May 14, 2001 12:31 PM To: Multiple recipients of list ORACLE-L Hi, everyone: I had problem installing Oracle 8.1.7.0 on my Petium 4 machine running Windows Me. I changed the scripts to use -nojit option, however, when I was installing, only Oracle Cllients was installed. Any idea? TIA Matt -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: a bit of a brag...
Congratulations. Apparently you did a great job. Michael Armstead Application Database Administrator, OCP-Certified US Pharmaceuticals IT Glaxo SmithKline -Original Message- From: Thater, William [SMTP:[EMAIL PROTECTED]] Sent: Monday, May 14, 2001 4:20 PM To: Multiple recipients of list ORACLE-L Subject: OT: a bit of a brag... My eldest graduated from college Saturday. A double major in Spanish and German, cum laude, and a Fullbright scholar. I'm proud of the boy!;-) Follow the link below for a nice picture and a little blurb. http://www.naz.edu/academics/fulbright/scholars.cfm -- Bill Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ Microwave: Signal from a friendly micro... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Armstead, Michael A INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: sys.IDL_UB1$
Jay, I think these tables deal with p-code chunks for pl/sql objects ... do you have lots of server side code? It is possible that you can truncate these tables, but then you'll have to recompile ALL (including SYS/SYSTEM) owned packages and user packages. Not recommended without help from OWS ... Here is Oracle Technical note . pre Doc ID: Note:43018.1 Type: FAQ Status: PUBLISHED Content Type: TEXT/PLAIN Creation Date: 30-APR-1998 Last Revision Date: 30-APR-1998 Introduction: = The Designer/2000 User Installation Guide (UIG) describes an 'optional' step to alter the storage parameters of SYS tables: IDL_UB1$ and IDL_UB2$. Occasionally, we take calls from customers who misunderstand why this step is optional and why it is mentioned in the UIG at all. Sometimes we also have to check these tables during certain installation problems, and this article is intended to give a brief overview of what these tables are used for and how you can check the current storage parameters of them. Alter Table Storage Parameters == alter table IDL_UB1$ pctfree 0 pctused 50 storage (next 500K pctincrease 0); alter table IDL_UB2$ pctfree 0 pctused 50 storage (next 500K pctincrease 0); Overview Of Tables == These alter storage statements should reduce the amount of space being used to store the Designer/2000 PL/SQL packages in the SYSTEM tablespace. However, if the users are also going to create their own PL/SQL packages and procedures on the database, then these storage values may have to be reviewed to ensure there is sufficient space for them. NOTE: these tables and their corresponding views are meant for kernel internal usage only and should NOT be queried by users! Checking Storage Values === col segment_name format a8 col sum(bytes) format 99 col sum(blocks) format col extents format col next_extent format col max_extents format col pct_increase format 999 select segment_name, sum(bytes), sum(blocks), extents, next_extent, max_extents, pct_increase from dba_segments wheresegment_name like 'IDL_UB%' group by segment_name,extents, initial_extent, next_extent, max_extents, pct_increase; Example Output == SEGMENT SUM(BYTES) SUM(BLOCKS) EXTENTS NEXT_EXTENT MAX_EXTENTS PCT_INCREASE --- -- --- --- --- --- IDL_UB1$ 105256960 51395 28 5242880 1210 IDL_UB2$ 26808320 13090 14 5242880 1210 /pre __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art ! * 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 ESPN at (860) 766-2000 and delete this e-mail message from your computer, Thank you. * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: a bit of a brag...
Conratulations, Dad! You deserve to have a bit of a brag. And Well Done to Edward too. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, May 14, 2001 4:20 PM My eldest graduated from college Saturday. A double major in Spanish and German, cum laude, and a Fullbright scholar. I'm proud of the boy!;-) Follow the link below for a nice picture and a little blurb. http://www.naz.edu/academics/fulbright/scholars.cfm -- Bill Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ Microwave: Signal from a friendly micro... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: sys.IDL_UB1$
I believe that table holds the PL/SQL source code. [EMAIL PROTECTED] 05/14/01 03:30PM Does anyone know what the SYS.IDL_UB1$ table is? It suddenly grew to app. 100Meg in my Development database. I tried searching on it on Ixora on Friday but as soon as I did my computer crashed. Now that I'm back up I decided it might be safer to post here :). Thanks in advance, Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Sawmiller INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Intermedia
Lisa, I just went through Intermedia install on HPUX 11 and Ora 8.1.6 (32 bit) with no apparent problems. Been able to create Intermedia indexes and all is working well. Could you share what problems you've encountered? Thanks, Gary Weber -Original Message- Sent: Monday, May 14, 2001 10:11 AM To: Multiple recipients of list ORACLE-L Bryan, What O/S are you on? I had specific problems with the intermedia install on HP/UX that required some changes in the install procedure, per support. I have a few scripts - if you would like me to send them to you, please email me directly. Lisa Rutland Koivu Oracle Database Administrator Certified Self-Important Database Deity Slayer of Unix Administrators Wanton Kickboxing Goddess [EMAIL PROTECTED] NeoMedia 2201 Second St., Suite 600 Fort Myers, FL 33901, USA Phone: 941-337-3434 Fax: 941-337-3668 www.neom.com http://www.neom.com http://www.neom.com www.paperclick.com http://www.paperclick.com http://www.paperclick.com www.qode.com http://www.qode.com http://www.qode.com P a p e r C l i c k . c o m http://www.paperclick.com/home.htm http://www.paperclick.com/home.htm Enter Your PaperClick Code Here! -Original Message- mailto:[EMAIL PROTECTED] ] Sent: Friday, May 11, 2001 4:51 PM To: Multiple recipients of list ORACLE-L Does anyone have instructions or know where to find concise instructions on setting up the Intermedia database objects (i.e. CTXSYS and what not) in an 8.1.6 instance? Like what scripts to run or is there a utility. TIA Bryan M. Miller Junior Oracle DBA IT Operations Telergy Inc. Email: [EMAIL PROTECTED] Phone: (315)362-2642 Pager: (315)647-1908 -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gary Weber INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OT: a bit of a brag...
Congrats! now if you can post a cigar for each of us. ;o) --- Thater, William [EMAIL PROTECTED] wrote: My eldest graduated from college Saturday. A double major in Spanish and German, cum laude, and a Fullbright scholar. I'm proud of the boy!;-) Follow the link below for a nice picture and a little blurb. http://www.naz.edu/academics/fulbright/scholars.cfm -- Bill Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ Microwave: Signal from a friendly micro... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Rocky Welch Senior Consultant - Internet Services Group Arthur Andersen __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rocky Welch INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: a bit of a brag...
Wonderful. But now I really feel old! -Original Message- Sent: Monday, May 14, 2001 1:51 PM To: Multiple recipients of list ORACLE-L Congratulations. Apparently you did a great job. Michael Armstead Application Database Administrator, OCP-Certified US Pharmaceuticals IT Glaxo SmithKline -Original Message- From: Thater, William [SMTP:[EMAIL PROTECTED]] Sent: Monday, May 14, 2001 4:20 PM To: Multiple recipients of list ORACLE-L Subject: OT: a bit of a brag... My eldest graduated from college Saturday. A double major in Spanish and German, cum laude, and a Fullbright scholar. I'm proud of the boy!;-) Follow the link below for a nice picture and a little blurb. http://www.naz.edu/academics/fulbright/scholars.cfm -- Bill Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ Microwave: Signal from a friendly micro... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Armstead, Michael A INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OT:Tomato Story
After all of the MicroSoft bashing, this should be fun!! An unemployed man goes to apply for a job with Microsoft as a janitor. The manager there arranges for him to take an aptitude test (Section:Floors, sweeping and cleaning). After the test, the manager says, You will be employed at minimum wage, $5.15 an hour. Let me have your e-mail address, so that I can send you a form to complete and tell you where to report for work on your first day. Taken aback, the man protests that he has neither a computer nor an e-mail address. To this the MS manager replies, Well, then, that means that you virtually don't exist and can therefore hardly expect to be employed. Stunned, the man leaves. Not knowing where to turn and having only $10 in his wallet, he decides to buy a 25 lb flat of tomatoes at the supermarket. Within less than 2 hours, he sells all the tomatoes individually at 100% profit. Repeating the process several times more that day, he ends up with almost $100 before going to sleep that night. And thus it dawns on him that he could quite easily make a living selling tomatoes. Getting up early every day and going to bed late, he multiplies his profits quickly. After a short time he acquires a cart to transport several dozen boxes of tomatoes, only to have to trade it in again so that he can buy a pick-up truck to support his expanding business. By the end of the second year, he is the owner of a fleet of pick-up trucks and manages a staff of a hundred former unemployed people, all selling tomatoes. Planning for the future of his wife and children, he decides to buy some life insurance. Consulting with an insurance adviser, he picks an insurance plan to fit his new circumstances. At the end of the telephone conversation, the adviser asks him for his e-mail address in order to send the final documents electronically. When the man replies that he has no e-mail, the adviser is stunned, What, you don't have e-mail? How on earth have you managed to amass such wealth without the Internet, e-mail and e-commerce? Just imagine where you would be now, if you had been connected to the Internet from the very start! After a moment of thought, the tomato millionaire replied, Why, of course! I would be a floor cleaner at Microsoft! Moral of this story: 1. The Internet, e-mail and e-commerce do not need to rule your life. 2. If you don't have e-mail, but work hard, you can still become a millionaire. 3. Seeing that you got this story via e-mail, you're probably closer to becoming a janitor than you are to becoming a millionaire. 4. If you do have a computer and e-mail, you have already been taken to the cleaners by Microsoft. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OT: a bit of a brag...
Congrats! I hope my boys' resume looks as impressive someday. (I'll give them a few years yet as they're just 5 and 9 now). Stephen Andert [EMAIL PROTECTED] 05/14/01 01:20PM My eldest graduated from college Saturday. A double major in Spanish and German, cum laude, and a Fullbright scholar. I'm proud of the boy!;-) Follow the link below for a nice picture and a little blurb. http://www.naz.edu/academics/fulbright/scholars.cfm -- Bill Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ Microwave: Signal from a friendly micro... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Tomato Story
Title: RE: Tomato Story -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] An unemployed man goes to apply for a job with Microsoft as a janitor. The manager there arranges for him to take an aptitude test (Section:Floors, sweeping and cleaning). ... It would bet that the joke was inspired by Somerset Maugham's excellent short story The Verger, featuring a man who is illiterate. I found an online version of the Somerset Maugham short story here. In my opinion, it's well worth taking 10 minutes of your time to read. http://www.geocities.com/Athens/Olympus/7695/VERGER.HTM
RE: Tomato Story
Dick, That's the best parable I've read in longer than I can remember... grin Thanks, Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Monday, May 14, 2001 4:06 PM To: Multiple recipients of list ORACLE-L Subject: OT:Tomato Story After all of the MicroSoft bashing, this should be fun!! An unemployed man goes to apply for a job with Microsoft as a janitor. The manager there arranges for him to take an aptitude test (Section:Floors, sweeping and cleaning). After the test, the manager says, You will be employed at minimum wage, $5.15 an hour. Let me have your e-mail address, so that I can send you a form to complete and tell you where to report for work on your first day. Taken aback, the man protests that he has neither a computer nor an e-mail address. To this the MS manager replies, Well, then, that means that you virtually don't exist and can therefore hardly expect to be employed. Stunned, the man leaves. Not knowing where to turn and having only $10 in his wallet, he decides to buy a 25 lb flat of tomatoes at the supermarket. Within less than 2 hours, he sells all the tomatoes individually at 100% profit. Repeating the process several times more that day, he ends up with almost $100 before going to sleep that night. And thus it dawns on him that he could quite easily make a living selling tomatoes. Getting up early every day and going to bed late, he multiplies his profits quickly. After a short time he acquires a cart to transport several dozen boxes of tomatoes, only to have to trade it in again so that he can buy a pick-up truck to support his expanding business. By the end of the second year, he is the owner of a fleet of pick-up trucks and manages a staff of a hundred former unemployed people, all selling tomatoes. Planning for the future of his wife and children, he decides to buy some life insurance. Consulting with an insurance adviser, he picks an insurance plan to fit his new circumstances. At the end of the telephone conversation, the adviser asks him for his e-mail address in order to send the final documents electronically. When the man replies that he has no e-mail, the adviser is stunned, What, you don't have e-mail? How on earth have you managed to amass such wealth without the Internet, e-mail and e-commerce? Just imagine where you would be now, if you had been connected to the Internet from the very start! After a moment of thought, the tomato millionaire replied, Why, of course! I would be a floor cleaner at Microsoft! Moral of this story: 1. The Internet, e-mail and e-commerce do not need to rule your life. 2. If you don't have e-mail, but work hard, you can still become a millionaire. 3. Seeing that you got this story via e-mail, you're probably closer to becoming a janitor than you are to becoming a millionaire. 4. If you do have a computer and e-mail, you have already been taken to the cleaners by Microsoft. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: sys.IDL_UB1$
Miller, Jay wrote: Does anyone know what the SYS.IDL_UB1$ table is? It suddenly grew to app. 100Meg in my Development database. Someone probably loaded (or generated) a ton of PL/SQL into the database. Although I've never attempted a truncate on these tables, some Metalink sources claim that doing so might work. See http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=FORp_id=58586.996 http://metalink.oracle.com/metalink/plsql/ml2_documents.showNOT?p_id=1021102.6p_showHeader=1p_showHelp=1 IDL_UB1$ is one of four tables that hold compiled PL/SQL code: IDL_UB1$ IDL_CHAR$ IDL_UB2$ IDL_SB4$ As to what is actually inside these tables, here's a related extract from the PL/SQL docs: PL/SQL is based on the programming language Ada. As a result, PL/SQL uses a variant of Descriptive Intermediate Attributed Notation for Ada (DIANA), which is a tree-structured intermediate language. It is defined using a meta-notation called Interface Definition Language (IDL). DIANA provides for communication internal to compilers and other tools. At compile time, PL/SQL source code is translated into machine-readable m-code. Both the DIANA and m-code for a procedure or package are stored in the database. At run time, they are loaded into the shared (memory) pool. The DIANA is used to compile dependent procedures; the m-code is simply executed. These four tables hold the DIANA and the so-code m-code. I think m-code is short for machine-dependent byte code but there is a sizable machine-indenpendent part as well. If you have a look at sql.bsq, you can see that Oracle documents the type column of these tables as follows: part number not null, /* part: 0 = diana, 1 = portable pcode, 2 = machine-dependent pcode */ Good luck Bill _ http://www.datacraft.com/http://plnet.org/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Pribyl INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Tomato Story
ROTFL!! This is a good one, Dick! John -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, May 14, 2001 2:06 PM To: Multiple recipients of list ORACLE-L Subject: OT:Tomato Story After all of the MicroSoft bashing, this should be fun!! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: sys.IDL_UB1$
I always wondered what DIANA stood for... :) Diana Duncan TITAN Technology Partners One Copley Parkway, Ste 540 Morrisville, NC 27560 VM: 919.466.7337 x 316 F: 919.466.7427 E: [EMAIL PROTECTED] Bill Pribyl bill@datacraTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ft.com cc: Sent by: Fax to: root@fatcity.Subject: Re: sys.IDL_UB1$ com 05/14/2001 06:10 PM Please respond to ORACLE-L Miller, Jay wrote: Does anyone know what the SYS.IDL_UB1$ table is? It suddenly grew to app. 100Meg in my Development database. Someone probably loaded (or generated) a ton of PL/SQL into the database. Although I've never attempted a truncate on these tables, some Metalink sources claim that doing so might work. See http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=FORp_id=58586.996 http://metalink.oracle.com/metalink/plsql/ml2_documents.showNOT?p_id=1021102.6p_showHeader=1p_showHelp=1 IDL_UB1$ is one of four tables that hold compiled PL/SQL code: IDL_UB1$ IDL_CHAR$ IDL_UB2$ IDL_SB4$ As to what is actually inside these tables, here's a related extract from the PL/SQL docs: PL/SQL is based on the programming language Ada. As a result, PL/SQL uses a variant of Descriptive Intermediate Attributed Notation for Ada (DIANA), which is a tree-structured intermediate language. It is defined using a meta-notation called Interface Definition Language (IDL). DIANA provides for communication internal to compilers and other tools. At compile time, PL/SQL source code is translated into machine-readable m-code. Both the DIANA and m-code for a procedure or package are stored in the database. At run time, they are loaded into the shared (memory) pool. The DIANA is used to compile dependent procedures; the m-code is simply executed. These four tables hold the DIANA and the so-code m-code. I think m-code is short for machine-dependent byte code but there is a sizable machine-indenpendent part as well. If you have a look at sql.bsq, you can see that Oracle documents the type column of these tables as follows: part number not null, /* part: 0 = diana, 1 = portable pcode, 2 = machine-dependent pcode */ Good luck Bill _ http://www.datacraft.com/http://plnet.org/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: sys.IDL_UB1$
Hi Jay, Does anyone know what the SYS.IDL_UB1$ table is? It suddenly grew to app. 100Meg in my Development database. I tried searching on it on Ixora on Friday but as soon as I did my computer crashed. Now that I'm back up I decided it might be safer to post here :). Did you recently install Dev/2000 or load up *lots* of new procedures / packages? Not surprising this happened on a development database - AFAIK this SYS owned table stores pieces of the source and is subject to *lots* of chained rows... John Kanagaraj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT: a bit of a brag...
Congratulations from me too, Bill. -Original Message- Sent: Monday, May 14, 2001 5:06 PM To: Multiple recipients of list ORACLE-L Congratulation on a job well done in raising your family and instilling the proper values. It's not a brag it's a well deserved BOAST. ROR mª¿ªm [EMAIL PROTECTED] 05/14/01 04:20PM My eldest graduated from college Saturday. A double major in Spanish and German, cum laude, and a Fullbright scholar. I'm proud of the boy!;-) Follow the link below for a nice picture and a little blurb. http://www.naz.edu/academics/fulbright/scholars.cfm -- Bill Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ Microwave: Signal from a friendly micro... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
SQL statement performance
Oracle : 8.0.5 Platform : Sun SQL statement: select distinct(spid) spid, name, commonname from ( select distinct queryspid spid from results union select distinct subjspid spid from results ) a, species where a.spid=species.id ; Table Species only has 33 records, while table results has about 800 records. There are indexes on queryspid and subjspid. This query is somehow slow. Is there any easy way to speed it up? Thanks. _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guang Mei INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
change tablespace for table in Peoplesoft
If I move table to different tablespace and then change tablespace for this table in People tools table using application designer - will I have any additional problems during upgrade?. If yes - what are they? Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: cdump, bdump, udump
Title: RE: cdump, bdump, udump I used to be of the same school of thought as you. But on Solaris 2.7 with Oracle v8.1.7 I have seen the various processes hang on to the old log for days if I mv alertSID.log alertSID.log.old ; touch alertSID.log 7113:oracle@e6500a ls -Fla /dw01/app/oracle/admin/BART/bdump/alert_BART.log -rw-r--r-- 1 oracle oinstall 484498 May 14 16:12 /dw01/app/oracle/admin/BART/bdump/alert_BART.log 7113:oracle@e6500a fuser /dw01/app/oracle/admin/BART/bdump/alert_BART.log /dw01/app/oracle/admin/BART/bdump/alert_BART.log: 28913o 28911o 28909o 28907o 28905o 28902o 28900o 28898o 28896o 7113:oracle@e6500a ps -ef | egrep PID|28913|28911|28909|28907|28905|28902|28900|28898|28896 | grep -v grep UID PID PPID C STIME TTY TIME CMD oracle 28898 1 0 15:55:56 ? 0:00 ora_dbw0_BART oracle 28905 1 0 15:55:57 ? 0:00 ora_smon_BART oracle 28911 1 0 15:55:58 ? 0:00 ora_p000_BART oracle 28909 1 0 15:55:57 ? 0:00 ora_arc0_BART oracle 28907 1 0 15:55:57 ? 0:00 ora_reco_BART oracle 28902 1 0 15:55:56 ? 0:00 ora_ckpt_BART oracle 28913 1 0 15:55:58 ? 0:00 ora_p001_BART oracle 28900 1 0 15:55:56 ? 0:00 ora_lgwr_BART oracle 28896 1 0 15:55:56 ? 0:00 ora_pmon_BART -Original Message- From: Terry Ball [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 25, 2001 1:32 PM To: Multiple recipients of list ORACLE-L Subject: Re: cdump, bdump, udump With the alert.log you are incorrect. Oracle only get a handle on the file when it writes to it. The rest of the time, it does not need nor keep a handle on the alert.log. You can move or delete the file and neither Oracle nor the OS care. A new alert.log will be created as soon as Oracle needs to write to one. Terry Ron Rogers wrote: Team, Correct me if I am wrong, please.. If you delete the alert.log file with the database up and running, the oracle still thinks the file exists and writes to a non existant file that you can't see. The proper method of reducing the file size is to copy the file to a backup location, and edit the original and delete rows from the file. OR if you do not need to keep the original log for analysis you could copu /dev/null alert.log. Just a house keeping note. ROR mª¿ªm [EMAIL PROTECTED] 04/24/01 09:21AM Sinardy, First, I suggest you find some time and sit down and READ the Oracle documentation. Otherwise you are going to get a large number of RTFM emails, and some flaming as well. Now.. the alert log is created (if it does not already exist) or written to every time Oracle wants to record an event that has happened in the database/instance. So log switches will be in there, database shutdown and startup messages, errors dealing with the infrastructure of the database (failure to extend a rollback segment, failure to get space in the temp segment, disasterous database errors etc) There are other messages as well, I'm not going to list every one. Bdump contains trace files that relate to the Oracle background process -- anything generated by smon, pmon, etc Udump contains trace files that relate to specific user Oracle processes Cdump contains core dumps, associated with one or another trace files in the bdump directory. Rachel From: Sinardy Xing [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: cdump, bdump, udump Date: Tue, 24 Apr 2001 03:40:27 -0800 Hi all, When those logs will created ? Thank you Sinardy -Original Message- Sent: Tuesday, 24 April 2001 9:41 AM To: LazyDBA mailing list Hi DBAs and SAs, I had a task to do housekeep ...\bdump\alertSID.log What logs usually Oracle system need to housekeep, and what are these directory cdump, bdump and udump for ? Thank you for your time Sinardy Think you know someone who can answer the above question? Forward it to them! to unsubscribe, send a blank email to [EMAIL PROTECTED] to subscribe send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author:
RE: Can I partition my primary key constraint index?
Title: RE: Can I partition my primary key constraint index? ahhh, mostly right. I found in v8.1.6 that if I use a non-unique index to enforce a unique/primary key constraint that the index does not drop when you drop the constraint. -Original Message- From: Vadim Gorbounov [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 2:56 PM To: Multiple recipients of list ORACLE-L Subject: RE: Can I partition my primary key constraint index? Hello, Cherie, Short note first - when you drop primary key the associated index will be dropped too. To partition the index you will create this index first and then alter table table name add constraint index name primary key(column list); HTH Vadim Gorbounov Brainbench Master Oracle DBA www.brainbench.com -Original Message- Sent: Friday, May 11, 2001 4:51 PM To: Multiple recipients of list ORACLE-L Oracle will automatically create an index for your primary key constraint. I have a lot of large partitioned tables in my data warehouse. All of my primary key indexes are non-partitioned. I would like them to be partitioned. When I drop the constraint and re-enable it, can I specify at that time that I want the index to be partitioned? Or do I need to drop my index and rebuild it to be partitioned after the fact? Is there any problem with having partitioned primary key indexes? Thanks, Cherie -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vadim Gorbounov INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Problem in fetching Table Info
Manoj, Nothing helps your sql skills like traversing the data dictionary, put on your hip waders get out your TUSC posters, a magnifying glass, a bottle of scotch and dive in. Here is one way, by no means the best or the only. SELECT A.column_name, A.data_type, DECODE(A.data_type,'NUMBER', DECODE(A.data_precision,NULL,A.data_length,A.data_precision), A.data_length) as Length, A.nullable, min(con_p) || min(con_c) || min(con_r), column_id FROM user_tab_columns A, (select B.constraint_name con_name, DECODE(B.constraint_type,'P','P',null) con_p, DECODE(B.constraint_type,'C','C',null) con_c, DECODE(B.constraint_type,'R','R',null) con_r, B.table_name tname, C.Column_name col_name FROMuser_constraints B, user_cons_columns C WHERE B.constraint_name = C.constraint_name AND B.Table_name = 'AG_PRODUCT' ) my_all_cons WHERE A.column_name= my_all_cons.col_name (+) AND A.table_name = my_all_cons.tname (+) AND A.table_name = 'AG_PRODUCT' GROUP BY A.column_name, A.data_type, DECODE(A.data_type,'NUMBER', DECODE(A.data_precision,NULL,A.data_length,A.data_precision), A.data_length), A.nullable, column_id ORDER BY COLUMN_ID If you like recursive SQL, take the table_name out of the inline view and join my_all_cons.tname = A.table_name in the outer. Great for watching recursive sql for those with Unabridged Data Dictionaries HTH, Scott Crabtree -Original Message- Sent: Monday, May 14, 2001 11:31 AM To: Multiple recipients of list ORACLE-L Hi Gurus, I am facing some problem while fetching data from oracle. I have to fetch all info like column_name,data_type,data_length,Nullable and primary key for particular table. For that i had prepared 2 quiries like: select A.column_name,A.data_type, 2 decode(A.data_type,'NUMBER', 3 decode(A.data_precision,NULL,A.data_length,A.data_precision), 4 A.data_length) as Length, 5 A.nullable from 6* user_tab_columns A where table_name = 'TEST' Which gives me info as : COLUMN_NAMEDATA_TYPE LENGTH N -- - -- - FLD1 NUMBER 5 N FLD2 NUMBER 3 N FLD3 VARCHAR2 10 N FLD4 VARCHAR2 30 Y FLD5 VARCHAR2 100 Y FLD6 VARCHAR2 50 Y FLD7 NUMBER22 Y Which is fine,but along with this i want info like which fields are pkey for which i have one more query: select C.column_name,B.constraint_type from user_constraints B,user_cons_columns C where B.constraint_name=C.constraint_name and B.table_name='TEST' which gives me info as to which are pkeys in table, But when i join these 2 quiries i get only 3 fields which are in primary key like FLD1,FLD2,FLD3 COLUMN_NAMEDATA_TYPE LENGTH N C -- - -- - - FLD1 NUMBER 5 N P FLD2 NUMBER 3 N P FLD3 VARCHAR2 10 N P whereas i want all other fields also along with that. Output should be as : COLUMN_NAMEDATA_TYPE LENGTH N -- - -- - FLD1 NUMBER 5 N P FLD2 NUMBER 3 N P FLD3 VARCHAR2 10 N P FLD4 VARCHAR2 30 Y FLD5 VARCHAR2 100 Y FLD6 VARCHAR2 50 Y FLD7 NUMBER22 Y I tried following query for this: 1 select A.column_name,A.data_type, 2 decode(A.data_type,'NUMBER', 3 decode(A.data_precision,NULL,A.data_length,A.data_precision), 4 A.data_length) as Length, 5 A.nullable,B.constraint_type from 6 user_tab_columns A, 7 user_constraints B, 8 user_cons_columns C 9 where 10 B.constraint_name=C.constraint_name and 11 A.column_name=C.column_name(+) and 12 A.table_name=B.table_name and 13* A.table_name = 'GEMS Could any one Help me in this?? TIA Manoj. __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Soman Manoj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message
Re: strange problem
When using sqlplus to do the select you are most probably using the privileges that have been assigned to you in a role. Privileges assigned to a user through a role are not used (or applied) inside PL/SQL blocks (procedures/functions). You need to have the appropriate privilege explicitly granted to the user who is executing the procedure/function. In your case you will need to explicitly grant select on the v$session view (or base table, sys.v_$session) to the user account that is executing the procedure. Glen Narender Akula wrote: hi gurus, I am able to select from every hting from v$session at command line. but when i write in procedure it fails why. SQL> select osuser from v$session where username = 'IMAGE_INDEX' and rownum = 1; OSUSER -- MLOBO this is ok... CREATE OR REPLACE PROCEDURE n2 IS tmpVar varchar2(100); BEGIN select osuser into tmpvar from v$session where username = 'MLOBO' and rownum = 1; dbms_output.put_line ('name '||tmpvar); EXCEPTION WHEN NO_DATA_FOUND THEN Null; WHEN OTHERS THEN Null; END n2; this is failing says sys.V_$session must be declared. what could be reason ? > narender.akula > > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Narender Akula INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Glen Mitchell NZ Phone: +64 9 3730400 Energy Research Lab URL: http://www.peace.com Peace Software Email: [EMAIL PROTECTED]
Re: strange problem
hi gurus, I am able to select from every hting from v$session at command line. but when i write in procedure it fails why. SQL select osuser from v$session where username = 'IMAGE_INDEX' and rownum = 1; OSUSER -- MLOBO this is ok... CREATE OR REPLACE PROCEDURE n2 IS tmpVar varchar2(100); BEGIN select osuser into tmpvar from v$session where username = 'MLOBO' and rownum = 1; dbms_output.put_line ('name '||tmpvar); EXCEPTION WHEN NO_DATA_FOUND THEN Null; WHEN OTHERS THEN Null; END n2; this is failing says sys.V_$session must be declared. what could be reason ? How was select on v$session granted to user who owns the procedure? If via a role this is the expected result. Pat -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pat Hildebrand INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: strange problem
Hi Narender, You will need to grant explicit select privilege to the user id for accessing the underlying view sys.v_$session to be able to do this in a PL/SQL procedure. The id may have access to the v$session via a role. And that would not work in a PL/SQL procedure. HTH.. Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: Narender Akula [SMTP:[EMAIL PROTECTED]] Sent: Monday, May 14, 2001 7:16 PM To: Multiple recipients of list ORACLE-L Subject: strange problem hi gurus, I am able to select from every hting from v$session at command line. but when i write in procedure it fails why. SQL select osuser from v$session where username = 'IMAGE_INDEX' and rownum = 1; OSUSER -- MLOBO this is ok... CREATE OR REPLACE PROCEDURE n2 IS tmpVar varchar2(100); BEGIN select osuser into tmpvar from v$session where username = 'MLOBO' and rownum = 1; dbms_output.put_line ('name '||tmpvar); EXCEPTION WHEN NO_DATA_FOUND THEN Null; WHEN OTHERS THEN Null; END n2; this is failing says sys.V_$session must be declared. what could be reason ? narender.akula -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Narender Akula INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Mean/Median
Any scripts (sql or pl/sql) out there to compute various statistical things in Oracle? Would depend on just what you are looking for. A quick look at Oracle's SQL functions showed avg, st. deviation, and variance although no median but that should be easier to write than some of the others. Pat -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pat Hildebrand INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 / Informix - sql interface
All, We have an Informix database and looking to setup a sql interface to an Oracle database. Both database servers are Sun E-class servers running O/S 2.6. All assistance is greatly appreciated. Thanks in advance. Roy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Roy Ferguson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
does oracle supports oracle 8.1.7. on sun solaris 8 (64bit) - pro
hi Gurus, I would like know wheather oracle supports oracle 8.1.7. on sun solaris 8 (64bit) ? Where do i find more info.I searched in product life cycle in metalink.. i could not find much info.. can some body tell or where to look. what are the pros and cons ? does any body had problems or issues after upgrade the OS from 7 to 8 ? narender.akula http://www.terralinkltd.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Narender Akula INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
strange problem
hi gurus, I am able to select from every hting from v$session at command line. but when i write in procedure it fails why. SQL select osuser from v$session where username = 'IMAGE_INDEX' and rownum = 1; OSUSER -- MLOBO this is ok... CREATE OR REPLACE PROCEDURE n2 IS tmpVar varchar2(100); BEGIN select osuser into tmpvar from v$session where username = 'MLOBO' and rownum = 1; dbms_output.put_line ('name '||tmpvar); EXCEPTION WHEN NO_DATA_FOUND THEN Null; WHEN OTHERS THEN Null; END n2; this is failing says sys.V_$session must be declared. what could be reason ? narender.akula -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Narender Akula INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: strange problem
hi pat... thanks for info. I granted explicit previleges to user, narender -Original Message- Sent: Tuesday, May 15, 2001 2:50 PM To: Multiple recipients of list ORACLE-L hi gurus, I am able to select from every hting from v$session at command line. but when i write in procedure it fails why. SQL select osuser from v$session where username = 'IMAGE_INDEX' and rownum = 1; OSUSER -- MLOBO this is ok... CREATE OR REPLACE PROCEDURE n2 IS tmpVar varchar2(100); BEGIN select osuser into tmpvar from v$session where username = 'MLOBO' and rownum = 1; dbms_output.put_line ('name '||tmpvar); EXCEPTION WHEN NO_DATA_FOUND THEN Null; WHEN OTHERS THEN Null; END n2; this is failing says sys.V_$session must be declared. what could be reason ? How was select on v$session granted to user who owns the procedure? If via a role this is the expected result. Pat -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pat Hildebrand INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Narender Akula INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Unknown Oracle user
Hello all, I was scanning through several Oracle 8.1.7 databases that I inherited recently, and noticed that there was a user ID by the name of RAO in each of the databases, with DBA privileges. For some reason, I recall seeing somewhere that this user is created when installing a particular product. Does this sound familiar to anyone? Thanks, Lou Avrami -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Louis Avrami INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Multi-platform Editors - Was: Unix
Hi Roland, (DISCLAIMER - I have no interest in Pacemaker software, other than that Paul has a good product) I use an editor called CRiSP extensively - it is a GUI-based version of a character based editor called Brief (from Underware), that got bought by Borland (remember them ...). It runs under Windows, Unix, Linux It has lots and lots of features (including the ability to FTP a file from a UNIX server, allow you to edit it locally, and then FTP it back, if you really want to). But you could also edit the file directly on the server if you wanted to. It is also the only editor that I know that will allow you to highlight a COLUMN, and then do regular expression changes on the column. Unlimited Undo's, file compares, extensible etc. etc. Colouration of reserved words (including SQL) - very configurable -. Pricing is extremely good as well (GBP 150.00 for Win/Nt), and he is constantly working to improve it. You can also buy locked or Floating licenses. Works well with your favourite complier to become an IDE (allows you to compile from within the editor, picks up the output and displays the errors and highlights the offending lines) Go to www.pacemaker.co.uk and have a look - you can also download an evaluation copy there. Regards Oweson Flynn -- Certified Oracle DBA The Flynn Consultancy Tel: 082-600-7-006 Fax: (011) 782-9313 EMail: [EMAIL PROTECTED] -Original Message- [EMAIL PROTECTED] Sent: 14 May 2001 16:01 To: Multiple recipients of list ORACLE-L How can I modify a Unix file in an other editor not using vi, for instance I would like to use a Windows based editor? Roland Sköldblom -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). *** This message may contain information which is confidential and subject to legal privilege. If you are not the intended recipient, you may not peruse, use, disseminate, distribute or copy this message. If you have received this message in error, please notify the sender immediately by email, facsimile or telephone and return and/or destroy the original message. *** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Oweson Flynn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Mean/Median
On Monday 14 May 2001 19:55, Pat Hildebrand wrote: Would depend on just what you are looking for. A quick look at Oracle's SQL functions showed avg, st. deviation, and variance although no median but that should be easier to write than some of the others. Pat Ha! Here's the script I have for median. Feel free to simplify it. :) And if you do, I want a copy. I can't claim authorship of this, I borrowed it from somewhere. Jared -- middle value is chosen as median when there is an -- odd number of values -- average of 2 middle values is chosen median -- when there is an even number of values drop table median; create table median ( value number ); insert into median values ( 111 ); insert into median values ( 543 ); insert into median values ( 566 ); insert into median values ( 643 ); insert into median values ( 456 ); insert into median values ( 98 ); insert into median values ( 877 ); insert into median values ( 867 ); insert into median values ( 687 ); insert into median values ( 6886 ); -- uncomment this row for an odd number of values --insert into median values ( 982 ); commit; break on report compute avg label 'Median' of value on report column value heading 'values|averaged|in median' select rownum, value from ( select value from median where value is not null union select 1 from dual where 1=2 ) group by value, rownum having rownum = ( select decode( mod(total_freq,2), 1,trunc(total_freq/2 + 1), 0,trunc(total_freq/2) ) from ( select count(*) total_freq from median where value is not null ) ) and rownum = ( select decode( mod(total_freq,2), 1,trunc(total_freq/2 + 1), 0,trunc(total_freq/2 + 1) ) from ( select count(*) total_freq from median where value is not null ) ) / Aˤ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).