RE: Enterprise Manger
Hi Bambi, To find out what version of OEM you installed you could open up a NT command prompt and type oemctrl status oms and then cancel out of the box that comes up asking for the OMS login. This works for OEM 2.1 and OEM 2.2, not sure if it works for 2.0.4 and below. 2.1 came with 8.1.6 2.2 came with 8.1.7 2.0.4 is installed into its own home. HTH, Bruce Reardon mailto:[EMAIL PROTECTED] -Original Message- Sent: Thursday, 10 May 2001 7:56 Ruth -- I think it's v2.1, but it's hard to tell since there's no About. HTH, Bambi. -Original Message- Date: Wed, 09 May 2001 05:41:14 -0800 What is the version of OEM? Ruth - Original Message - Sent: Tuesday, May 08, 2001 4:17 PM Greetings, Fellow OraHax! Long time no see. I've been off doing interesting things for awhile and have been pretty quiet. I've got a problem and I'm pretty embarrassed by it. Let me write embedded SQL/Korn shell or do funky DBA things all day but don't make me use a GUI! But, well, we do what we have to. Anyway, I have Enterprise Manager running on a remote NT box. I have created a repository owner (entmgr) and made sure that the service is running. If I try going into enterprise manager with just the SID, I get VTK-1000. If I try to log in specifying the machine name (which I tried on a lark... it doesn't make sense to me to specify the machine name), I get invalid login credential supplied. aTdHvAaNnKcSe! Bambi. -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: comp.oracle.databases.server vs ORACLE-L: deathmatch
Eric D. Pierce wrote: As far as the Culture of any Oracle-NT-L, I can see the possible advantage of having some weighty expert personalities involved. The culture, and therefore utility, of an email list community is almost always enhanced when the list is created with a good core group of people that can provide a sense of leadership, purpose and vision. regards, ep uh oh. You want leadership, purpose and vision from users of Microsoft products? I think that I'll humbly retract the entire idea now. sorry. back to wishing that my db's were running on *nix. btw, LETS GO PENS!!! 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 To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle 9i Articles - self tuning, launch delayed to
Eric D. Pierce wrote: Summary Self-tuning, self-managing Oracle9i monitors your system to provide high availability, reliability and minimized downtime. Whether you are a hosting service, in-house data center, or IT organization, you can rely on Oracle9i and its system management products to provide optimal quality of service to all users. Eric, I believe that I see the emergence of new BOFH excuse of the day material: (I will quote from a former life - Chemical Process Control - An Introduction to Theory and Practice. I knew that someday, Laplace Transforms would be somehow useful. Hello again, imaginary numbers.) Windup-error Here the tuning interval was so large, that the disturbances experienced recently are so diluted by the non-peak time intervals that the ability to discern problems is like trying to find a bomb the size of a lipstick container in all of the purses in a New York commute morning. analogy - cache hit ratios when correlated subqueries are reusing cursors/code billions of times. concepts - autoextending datafiles that cannot reuse extents - purely capacitive process. Dead time Well, if init.ora parameters are only changed when the instance is terminated, uptime = dead time, in a self-tuning paradigm. analogy #1 - unplugging the leads to the controller mechanism. analogy #2 - disconnecting the phone, power off the cell phone, close the email client. Phase Lag an offset between the input and output signals. analogy - a dog chasing his/her tail - but never quite catching it. In further detail, the distance between the dog snout and tip of the tail, divided by the circumference of the perimeter of the (outer) circling dog fur (in radians). M ... pie. Crossover Frequency This has nothing to do with bisexuals. It has to do with system stability once the control loop is closed. If the gain margin at the crossover frequency is too large, the system will be unstable. In this case, the operating system and DBA will be blamed. Open loop tuning = advice Closed loop tuning = implemented advice, now put to the test. Consultants have long since left. Run. We don't actually implement solutions, we just recommend them. Amplitude Ratio This has to do with a self-tuning mechanism, and rival tuning goals of server and user processes competing for resources (e.g. memory). A critically dampened tuning algorithm will overshoot the optimal target by 17% and converge on the ideal solution without a sinousoidal response signal. Most others will oscillate in a perpertual fashion. Unfortunately, a 17% overestimation in available memory will cause the paging daemon to chime in, causing the DBA and SysAdmin to disable the auto-tuning in favor of going with what has worked for the past nn years. The Bhopal disaster (MIC) was caused when field personnel disabled 3 layers of control systems and additional safety systems. You can't optimize globally and tune locally. Maybe the holistic method has a point. Acronyms P Proportional Control PI Proportional Integral Control PD Proportional Derivative Control PID Proportional Integral Derivative Control Bode stability criterion we'll save that for the advanced session. Tune in tomorrow. Paul used to be a Chem Engr. Database Blowups are far better than Chemical Process Industry plant blowups. AFAIK, no one has died from a database crash. -- 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 To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Data Reporting tools
Dick, Go with Discoverer. As the admin, you can build a subset of the data and push it out to the power users with the data labeled any way you like. You can also give you power users the ability to create their own views if you are so inclined. They accomplish this through the GUI, with no 'direct' access to the database (of course they do, you need to set up their permissions etc., but you can lock it down pretty tight and what they're really creating is data about data which you can excise without harm to your DB at any time). Training is a snap, the interface is familiar and fairly intuitive, particularly for those with Access/Excel skills and experience. I used Discoverer for our Engineering teams to access Remedy (ugh!) data. Crystal Reports was the 'preferred' solution by the vendor, who wanted to send 20+ people to user training for a week to get them up to speed. The Discoverer solution was much simpler and more cost-effective for all involved. They were quite proud of their ability to create ad-hoc reports, and very lavish with their praise of the 'support' they were getting from the DBA! Regards, David A. Barbour Ruiz, Mary A (CAP, CDI) wrote: Hi Dick: I have a similar project on my plate. I like Business Objects. Actually, we do not want users to have to know table/column names and need a product where we can build a data repository. I am not sure if we need a complete end-to-end solution as many BI companies seem ready to provide. Other vendors on our short list are - Oracle (Discoverer), Cognos, Brio, Informatica (not sure if we need it) and Sagent (has a nice ETL product). Mary Ruiz /Atlanta -Original Message- Sent: Thursday, May 10, 2001 2:11 PM To: Multiple recipients of list ORACLE-L To ALL, I've been given a project to find a way to make data easily available to end users, preferably via a thin client (read that as browser based). We're looking at Discoverer 3000 and 9iAS, but the boss wants to know what other options are out there. The general idea would be to have a client/server based tool that we could deploy to the power users (of which we have only a few). These individuals are NOT programmers nor in the IS group, but they know the data. We want them to create the queries/reports (with graphics included which the Discoverer viewer does not do) and then publish them via the database. This is a lot of what Discoverer does, but are there other tools out there that do the same? Any recommendations??? Dick Goulet Senior Oracle DBA Vicor Corporation -- 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: Ruiz, Mary A (CAP, CDI) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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).
PL/SQL-procedures
How can I write procedure which runs 3 different subprocedures.? 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: What columns are in the Primary Key
select * from user_cons_columns where constraint_name=(select constraint_name from user_constraints where table_name = '1' and constraint_type='P'); .. Bunyamin .. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 10, 2001 8:22 PM Hi! Is there a data dictionary view that gives me all the columns in a primary key of a table? I can query user_constraints to find out about all constraints on a table: select * from user_constraints where table_name='TBACCOUNTS' OWNER CONSTRAINT_NAME C TABLE_NAME SEARCH_CONDITION -- --- - - VIVOUSER SYS_C003011 C TBACCOUNTS COMPANYID IS NOT NULL VIVOUSER SYS_C003012 C TBACCOUNTS STORELOCID IS NOT NULL VIVOUSER SYS_C003013 C TBACCOUNTS ACCOUNTID IS NOT NULL VIVOUSER PK_ACCOUNTS P TBACCOUNTS How can I get what columns are in the primary key PK_ACCOUNTS ? I have more NOT NULL columns in the table than in the PK. Any idea? This is 8.1.6 on Win2k. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Helmut Daiminger INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Bunyamin K. Karadeniz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ORA-06553: PLS-707: unsupported construct or internal error [2603]
Thanks to those who replied, the LD_LIBRARY_PATH was set in the profile for oracle, unsetting this did the trick. Zabair _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: zabair ahmed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Pl/sql loop assistance
Hi Jacques, It is not reliable if there is row migration. @ Regards, @ Steve Adams @ http://www.ixora.com.au/ @ http://www.christianity.net.au/ -Original Message- Sent: Friday, 11 May 2001 3:07 To: Multiple recipients of list ORACLE-L -Original Message- From: Jared Still [mailto:[EMAIL PROTECTED]] I'll have to disagree with not using commit within a loop. If you identify what a transaction is within your code, and write it accordingly, using commit where appropriate, you will not get ORA-1002 or ORA-1555, at least not due to your own code. This reminds me, Mr. Still, you posted an example once to the list about doing a fetch in rowid order to avoid revisiting the same block when doing a full table scan of a table, so that reading and updating every row in a table would avoid the dreaded snapshot too old. I told a developer about that today and showed him a code sample, but he says he still had a snapshot too old. Would it be possible for you to post that snippet of code again? Jacques R. Kilchoër x8816 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Adams INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
desc SQL*PLUS
Hello DBA's I have recently upgraded from 8.1.6.0 to 8.1.6.3. I seem to be having a weird problem in sql*plus, in that whenever I do a describe on a table it comes up with the following error :- SQL desc emp; ERROR: ORA-03113: end-of-file on communication channel I can run select statements without any problems ! TIA Sajid Iqbal -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sajid Iqbal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Ora - 4091 error while trying to insert a record into a table
Dear DBA Gurus, I have Table A and Table B whose structures are almost similar except Table B has a date-time field column. Whenever I insert a new record into Table A I want to insert the same record into the Table B along with the date-time stamp at which the new record is inserted into Table A. For achieving this I wrote an after insert trigger on Table A for each row. The trigger got created successfully. But whenever I try to insert a new record into Table A I get the Ora - 4091, mutating table error. How do I achieve this without any errors? Any workarounds? Any help in this regard will be greatly 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).
Arkeia Backup software
Does anyone use this? It looks funky and I am interested in any opinions before I try it out. Im trying to get out of the Legato/Veritas vicious circle of Very Expensive and only Moderately Useful backup software. http://www.arkeia.com Regards Mark ERG Group -- The contents of this email and any attachments are confidential and may only be read by the intended recipient. - -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Teehan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Updating a table :Using dynamically generated table_Names
Use dynamic SQL, it is so simple now that there is execute immediate instead of prepare, execute, bind,... --- Vikas Kawatra [EMAIL PROTECTED] a écrit : can someone tell me a way to select all tables from multiple schemas - and then update records in each of these tables based on a certain criterea. I wrote a script below - which explains logically what I need to do - but I don't think I can use a cursor output in the UPDATE as I have below. Suggestions ? thanks vikas DECLARE CURSOR cuTab IS SELECT table_name,column_name FROM dba_tab_columns WHERE column_name ='END_DATE' AND owner='CIS'; recCuTab cuTab%ROWTYPE; BEGIN FOR recCuTab IN cuTab LOOP UPDATE recCuTab.table_name --Get an error here !! SET end_date = TO_DATE('4712-12-31','-MM-DD') WHERE end_date TO_DATE('12-31-4712','mm-dd-') AND end_date TO_DATE('1-1-4712','mm-dd-'); END LOOP; -- 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). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Pour faire vos courses sur le Net, Yahoo! Shopping : http://fr.shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle9i block structures
Hi, Do you know if Oracle9i block structures are modified ? thanks in advance... -- Use itrprof SQL Analyzer. It formats SQL_TRACE/Event10046 traces and gives tuning advises. It's web based, no download, no configuration. Just click http://www.unal-bilisim.com/products/itrprof/itrprof_index.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: Oracle9i block structures
I only know that you can have multiple blocksize in a DB. --- Danisment Gazi Unal (Unal Bilisim) [EMAIL PROTECTED] a écrit : Hi, Do you know if Oracle9i block structures are modified ? thanks in advance... -- Use itrprof SQL Analyzer. It formats SQL_TRACE/Event10046 traces and gives tuning advises. It's web based, no download, no configuration. Just click http://www.unal-bilisim.com/products/itrprof/itrprof_index.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). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Pour faire vos courses sur le Net, Yahoo! Shopping : http://fr.shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: COLLECTION ITERATOR PICKLER FETCH
Hi Scott, Pickling is serializing arbitrary object-oriented data structures. That is, converting them into a byte stream for storage, transmission over a network or iterative navigation as in this case. It is a more complex process than you might imagine. If you want more information, search the web for information on Python's pickle module. @ Regards, @ Steve Adams @ http://www.ixora.com.au/ @ http://www.christianity.net.au/ -Original Message- Sent: Friday, 11 May 2001 3:11 To: Multiple recipients of list ORACLE-L Sometimes I really love the developers at Oracle.. This should be good fodder for Eric P. Does anyone have experience with infamous pickler Fetch which shows up in this explain plan the select is on index organized nested tables (Nested objects)? It's obvious that someone in internals has a good sense of humor. I guess this is the way Oracle dereferences the embedded collections? SELECT STATEMENT SORT GROUP BY NESTED LOOPS NESTED LOOPS NESTED LOOPS NESTED LOOPS ` BLAH BLAH BLAH COLLECTION ITERATOR PICKLER FETCH VIEW AD_AGG_DATA_MASTER UNION-ALL PARTITION FILTER TABLE ACCESS BY INDEX ROWID AD_23 INDEX RANGE SCAN AD_23_IDX_1 FILTER TABLE ACCESS BY INDEX ROWID AD_24 INDEX RANGE SCAN AD_24_IDX_1 FILTER TABLE ACCESS BY INDEX ROWID AD_25 INDEX RANGE SCAN AD_25_IDX_1 Scott Crabtree Veritas Certified Survivor -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Crabtree INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Steve Adams INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Ora - 4091 error while trying to insert a record into a table - RESOLVED
Hi Gurus, I got the solution. Here is the modified code: create or replace trigger trig_dept1 after insert on dept for each row begin insert into dept1(deptno, dname, loc, date_time) values(:new.deptno, :new.dname, :new.loc, sysdate); end; Thanks Rob Fegan and Amol Joshi for correcting me. Regards, Ranganath -Original Message- Sent: Friday, May 11, 2001 2:35 PM To: Multiple recipients of list ORACLE-L Dear DBA Gurus, I have Table A and Table B whose structures are almost similar except Table B has a date-time field column. Whenever I insert a new record into Table A I want to insert the same record into the Table B along with the date-time stamp at which the new record is inserted into Table A. For achieving this I wrote an after insert trigger on Table A for each row. The trigger got created successfully. But whenever I try to insert a new record into Table A I get the Ora - 4091, mutating table error. How do I achieve this without any errors? Any workarounds? Any help in this regard will be greatly 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). -- 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: RMAN Question
Are the tables you are loading in direct mode in the same tablespace as your other tables ? If this is the case, then you will not be able to perform a complete recovery on the tablespace affecting the other logged tables. Whenever I have a mix like you have, some logged and some not, I keep the tables/indexes seperate. I hope this helps -Original Message- Sent: 10 May 2001 18:16 To: Multiple recipients of list ORACLE-L DBAs, I have two of my tables and index in nologging mode as I am loading data using SQL*Loader direct path mode. I have scheduled RMAN hot backup everday. When I issue REPORT UNRECOVERABLE, I am getting both the Data and Index datafiles are unrecoverable. I know that I wont be able to recover the tables in nologging mode. What I would like to know is about the recovery possibility of other tables in logging mode. Will there be any problem during recovery as these datafiles are in unrecoverable status? 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: holders INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Order of columns in a table
LOL!! -Original Message- Pierce Sent: Thursday, May 10, 2001 10:17 To: Multiple recipients of list ORACLE-L HELP On 10 May 2001, at 12:53, SuzyV scribbled with alacrity and cogency: Am I an idiot?? ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Password with special character
Hi all, Can Oracle User change their password with special characters? Thank you very much Sinady -- 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).
import from corrupted export file.
hi all, how to take an import from a corrupted export file. the error message is abnormal end of expoort file. Thanks, Mohit -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohit Goyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Silver vs. Gold support
FOR YOUR INFORMATION ESIS and EPFAL are now part of Logica. The Internet email addresses of the staff has changed to the following - [EMAIL PROTECTED] eg [EMAIL PROTECTED] Emails using the old format will continue to be delivered until 30th June 2001. I have worked on 3 sites with Gold support and I have never noticed any difference between those and the Silver support sites. I believe that Oracle provide analysis of no of calls opened, closed, outstanding and by person on a monthly or quarterly basis for those on Gold support. Being on the sharp end I have never been thankful for Gold support and it certainly costs a lot more. John -Original Message- From: Kimberly Smith [mailto:[EMAIL PROTECTED]] Sent: 10 May 2001 18:16 To: Multiple recipients of list ORACLE-L Subject:Silver vs. Gold support My manager is thinking of moving us up to Gold support. Does anyone out there have it and if so could you give me you general impression on having that over Silver. She says that at sites she used to work at it means having a dedicated resource on site. Their phone support for SEV1 calls is basically sucks unless you hit the day shift. Kimberly Smith Database Administrator EDS - Fujitsu/GMD Phone: (503) 669-6050 Fax: (503) 669-5705 Email : [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). This e-mail and any files transmitted with it, are confidential to Logica and are intended solely for the use of the individual or entity to whom they are addressed. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hallas, John INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: import from corrupted export file.
Hi, first of all, be sure that export file is not copied in ASCII mode. if so, You can do: - take a look at import log. find where it's cancelled - I guess internal data structers in export file is not so big. It's so likely that corruption occured on your data. modify binary export file by an binary editor. there may be a note in metalink which explains some structures in expor files. hope this helps... Mohit Goyal wrote: hi all, how to take an import from a corrupted export file. the error message is abnormal end of expoort file. Thanks, Mohit -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohit Goyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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. It formats SQL_TRACE/Event10046 traces and gives tuning advises. It's web based, no download, no configuration. Just click http://www.unal-bilisim.com/products/itrprof/itrprof_index.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:PICKLER FETCH
A PICKLER FETCH is a fetch that is issued against a table. But before it actually takes place and anything is returned to you it must be: cleansed of any impurities, placed in a dark mysterious place, covered with an un-named substance that makes it feel crunchy when retrieved, allowed to age for a long period of time, and be handled by an internally secret processes. When returned to you it looks similar to what you wanted but it not exactly and you must try again. There are many varieties to this FETCH. Some are the Bread And Butter of the database provider and some are varieties not related to being Kosher. The cure to the PICKLER FETCH problem is the use a larger vat, a faster ageing process, or upgrade the internally secret process. All of which will cost you more . ROR mª¿ªm -- 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).
Drop schema and all related objects
Hi DBA's, How can I drop schema (user and all it's objects). I have one main user in the application and wants to drop user and all related objects. Can anyone help me in this regard. Thanks Mujeeb Chowdhry Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mujeeb Chowdhry INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Drop schema and all related objects
connect as sys or system. drop user username cascade; The user and all objects will be removed. james --- Mujeeb Chowdhry [EMAIL PROTECTED] wrote: Hi DBA's, How can I drop schema (user and all it's objects). I have one main user in the application and wants to drop user and all related objects. Can anyone help me in this regard. Thanks Mujeeb Chowdhry Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mujeeb Chowdhry INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: james ellis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Which tables are in buffer cache.?
Mark, how do you manually remove objects from buffer cache? I saw you writing before that you know how to do it and I would be very interested to know also if it is not trade secret of course. Alex Hillman -Original Message- Sent: Friday, May 04, 2001 11:11 PM To: Multiple recipients of list ORACLE-L Been here: this is a really interesting exercise! You can query v$bh (or its x$ base table) which has a record for every buffer cache block. Link on object ID's While tuning a 3000Tx/sec OLTP database I could get constant 24*7 performance by by examining objects in the buffer cache and manually removing unwanted objects at end of business day. This prevents required objects being aged out and having to be reloaded. Typical scenario is to remove the index for the partition for 'todays' transactions to make room in the buffer cache for 'tomorrows' transactions. Its good fun tuning at this level. I wrote a gui via perl DBI that dumped the bcache contents (similar to the oracle tablespace manager gui) and allows objects to be manually/automatically removed from memory. I think DB2 can do this already. Does 9i allow definition of custom buffer pools (buffer_pool_Transactions for example), each with its own aging algorithm? Ive got the 9i beta cd here but havent even opened it. Too busy. Mark Teehan Singapore From: Bunyamin K.Karadeniz [EMAIL PROTECTED] Date: Wed, 2 May 2001 09:23:57 +0300 Subject: Which tables are in buffer cache.? This is a multi-part message in MIME format. --=_NextPart_000_00E6_01C0D2E9.9D9A9360 Content-Type: text/plain; charset=iso-8859-9 Content-Transfer-Encoding: quoted-printable Hi all gurus, =20 I want to learn the way to ook at=20 Which tables are in buffer cache./Analyzed? Is there a system view showing these tables?? Thanks to All. Bunyamin K.Karadeniz Database Group / Information Systems Department=20 HAVELSAN Ankara /TURKEY Tel : +903122873565 / 1681 Mobile Tel : +90 535 3357729 ERG Group -- The contents of this email and any attachments are confidential and may only be read by the intended recipient. - -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Teehan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Password with special character
Hi Thye Hock Gan, Thank you for your info. I am using Oracle 8.1.6 Solaris 7 Install patch bug122 for SQL*PLUS How can I change user password with special character alter user teddy identified by bear12#$; is not working because of alter user teddy identified by 'bear12#$'; also not working I have password_verification profile with verify_function that provided by Oracle Administrator Guide that must at least 1 special character in user password. Thank you, Sinardy -Original Message- Sent: Friday, 11 May 2001 6:34 PM To: LazyDBA mailing list This are characters you can use: !#$%()'*+,-/:;+_ if I'm not mistaken. Try them anyway. --- Sinardy Xing [EMAIL PROTECTED] wrote: Hi all, Can Oracle User change their password with special characters? Thank you very much Sinady 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 __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ 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).
File open event
Can Somebody please explain to me what this event is , I am not able to find good documentation on this issue. EVENT TOTAL_WAIT TOTAL_TIME TIME_WAITE AVERAGE_WA -- -- -- file identify38343 0 3135 .08176199 file open9436698 03934742 .416961738 Thanks in Advance _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ARUN K C INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Contigency plan
Hi all, Do you guys have any good references (books or URLs) that teach some good Oracle potential problems with solutions for my contingency plan? Thank you, Sinardy -- 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).
RE: RE: Silver vs. Gold support
so the support bill we just paid should get refunded because it was for Silver Support which no longer exists? and I pay for support but they desupport the products I have paid support for, and instead of giving me the new software release so that the support I paid for is still relevant, they will charge me for the update. And not give me a prorated refund. Ya know, if I'm gonna get screwed I'd at least like to enjoy it From: Eric D. Pierce [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: RE: Silver vs. Gold support Date: Thu, 10 May 2001 13:17:06 -0800 Apparently now Bronze/Silver is just called Product Support, and Gold is called Premium. All 24x7. Upgrades have been split off. Of course now Metalink has to also be renamed (Oracle Ink9i, or OInk9i?) since there is no more Metal, right. :) http://www.oracle.com/support/index.html?support_ebus.html ---excerpt--- ... Oracle Support is leveraging the power of the Internet to deliver simpler and sharply focused support services, while making their purchase faster and easier. To facilitate web-based transactions, Product Support is now priced as a percentage of list license price. [7% of license cost (annual?)] Additionally, software updates can be purchased separately on a subscription basis, [15% of license cost, annual] and our OracleBRONZE and OracleSILVER services have been consolidated into a single 24 x7 technical assistance service and removed from the price list. OracleGOLD, OracleLifecycle and our Oracle Expertise service capabilities are now offered within the Premium Support menu. ... ---end--- -- 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). _ 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).
Impact of query tuning
I just thought I should advertise this... usually people just complain. Hi Patrice, I have added indexes on the foreign keys in the [schema_name] tables. Also, I tuned the SQL statements I was using to perform the desired deletes. Results: The one delete job that ran for over 6 hours was performed in under 5 seconds!!! These changes have dramatically increased not only the delete process on the biochem tables but all activities I have performed. A sincere thanks for your help!! Heh heh. Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
XA Transaction Support - How to check for?
I just got the following question from a Microsoft consultant who's helping another department resolve some problems: Is Oracle XA Transaction Support enabled on the Oracle DB?' I have no idea how to check this. If asked, I would have guessed that it was automatically enabled, but this isn't an area I know much about. I've been looking through the documentation without finding anything to tell me where to look (did the obvious things like check for any parameters with %xa% in them). Can anyone tell me how to check this? Or at least direct me to where in the docs I should be looking? Thanks! Oracle v. 8.0.4.3 (but finally got permission to upgrade later this year :). 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).
Re: Drop schema and all related objects
Hi, Drop user user_name cascade; will drop the user including objects. Hope this helps, Muths At 05:40 AM 5/11/01 -0800, you wrote: Hi DBA's, How can I drop schema (user and all it's objects). I have one main user in the application and wants to drop user and all related objects. Can anyone help me in this regard. Thanks Mujeeb Chowdhry Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mujeeb Chowdhry INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Muthaiah INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Contigency plan
http://www.drj.com - disaster recovery journal For those of us who are beyond paranoid ... and would be carrying the tapes to the remote data center. Paul Sinardy Xing wrote: Hi all, Do you guys have any good references (books or URLs) that teach some good Oracle potential problems with solutions for my contingency plan? Thank you, Sinardy -- 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 To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
PL/SQL Question
I need to whip out a PL/SQL procedure real quick today and have a quick question for fellow-listers ( since today is Friday, hopefully I don't get RTFMed on this one :) ) The purpose of my procedure is to collect stats from v$session_wait periodically ( every second for example) and pump the data into a stats table. But how to make the procedure to wait for a specified time? I know of the option of using dbms_jobs to handle this. But I am wondering if there is a similar function in PL/SQL similar as the Unix 'sleep' command. TIA Dennis Meng Database Administrator Focal Communications 847-954-8328 -- 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: Drop schema and all related objects
Try drop user username cascade; Mujeeb Chowdhry wrote: Hi DBA's, How can I drop schema (user and all it's objects). I have one main user in the application and wants to drop user and all related objects. Can anyone help me in this regard. Thanks Mujeeb Chowdhry Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mujeeb Chowdhry INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Scott Canaan ([EMAIL PROTECTED]) (716) 475-7886 Life is like a sewer, what you get out of it depends on what you put into it - Tom Lehrer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
I want to re-install system, how can I backup and recover?
hi, Because a hacker hackered our system, I have to re-install the solaris. How can I backup the oracle database? Just backup all the physical files? I am not a back up and recover expert. Please help me... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Chen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Drop schema and all related objects
DORP USER username CASCADE; Michael Armstead Application Database Administrator, OCP-Certified US Pharmaceuticals IT Glaxo SmithKline -Original Message- From: Mujeeb Chowdhry [SMTP:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 9:40 AM To: Multiple recipients of list ORACLE-L Subject: Drop schema and all related objects Hi DBA's, How can I drop schema (user and all it's objects). I have one main user in the application and wants to drop user and all related objects. Can anyone help me in this regard. Thanks Mujeeb Chowdhry Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mujeeb Chowdhry INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Drop schema and all related objects
Let's try to spell it correctly this time: DROP USER username CASCADE; Michael Armstead Application Database Administrator, OCP-Certified US Pharmaceuticals IT Glaxo SmithKline -Original Message- From: Armstead, Michael A Sent: Friday, May 11, 2001 9:24 AM To: '[EMAIL PROTECTED]' Subject: RE: Drop schema and all related objects DORP USER username CASCADE; Michael Armstead Application Database Administrator, OCP-Certified US Pharmaceuticals IT Glaxo SmithKline -Original Message- From: Mujeeb Chowdhry [SMTP:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 9:40 AM To: Multiple recipients of list ORACLE-L Subject:Drop schema and all related objects Hi DBA's, How can I drop schema (user and all it's objects). I have one main user in the application and wants to drop user and all related objects. Can anyone help me in this regard. Thanks Mujeeb Chowdhry Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mujeeb Chowdhry INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Drop schema and all related objects
Drop User username Cascade ; Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- Chowdhry Sent: Friday, May 11, 2001 8:40 AM To: Multiple recipients of list ORACLE-L Hi DBA's, How can I drop schema (user and all it's objects). I have one main user in the application and wants to drop user and all related objects. Can anyone help me in this regard. Thanks Mujeeb Chowdhry Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Contigency plan
On Fri, 11 May 2001,Paul Drake scribbled on the wall in glitter crayon: -http://www.drj.com - disaster recovery journal - -For those of us who are beyond paranoid ... and would be carrying the -tapes to the remote data center. - -Paul Never underestimate the bandwidth of a station wagon full of tapes. -- 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. ~~ The computing field is always in need of new cliches. - Alan Perlis -- 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: Veritas Backup Exec, Oracle Agent (Win2000)
Eric, We're using Veritas NetBackup DataCenter (at our colocation facility) for Win2k and it's been pretty good. We had a problem earlier this year that eventually prompted Veritas to issue a patched version of one of the executables. They were very responsive, but it was probably due to the clout of our colocation host. Veritas distributes some nice scripts for use with RMan (we use 8.1.6). Don't know if they do the same for Backup Exec. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- Pierce Sent: Thursday, May 10, 2001 6:11 PM To: Multiple recipients of list ORACLE-L re: Veritas Backup Exec, Oracle Agent for Windows 2000 Does anyone use the above combo? Any probs/ issues/ tips? thanks, ep -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: PL/SQL Question
Use dbms_lock.sleep() HTH Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art ! * 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).
Oracle error -20001
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).
Re: mod_plsql and PL/SQL pages
Cyril Thankappan wrote: with the advent of PL/SQL pages is Oracle continuing development of MOD_PLSQL or is MOD_PLSQL merely provided for backward compatibility? At run time, the Oracle server and Oracle's version of Apache use modplsql to process PL/SQL Server Pages, so I'd say modplsql is part of the core product set. I am pretty sure they are adding new features fixes to modplsql in Oracle9i. 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: Export question.
OK, To answer a couple of questions, I did use compute statistics to get the stats. I did not use compress=y. The table should have been 420Mb according to the avg_row_len*num_rows calculation. The export file came out at 5.7Gb. When I imported it fell over at 1Gb. I set my initial extent to what I calculated it at earlier and next extent to 4Mb and tablespace (1Gb) filled up. I'm still confused as to how this happened. Never mind its the weekend, out to a top class restaurant tonight, its the English FA Cup Final on Saturday (lots of beer) and the weather is glorious.. Oracle ? Oracle Who Regards Lee -Original Message- Sent: 10 May 2001 17:01 To: Multiple recipients of list ORACLE-L When you export it do not! use compress=Y. When you import the table be sure to prebuild the table with the initial and next extent sizes to be appropriate for this table. This will reorg it unstead of putting it back the way it was. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 10, 2001 11:31 AM All, I have recently ran an analysis on a table and when calculating the table size using num_rows*avg_row_len this came out at about 420Mb. Nothing strange about that, however the amount of space this table is taking up is about 4.6Gb ! Instant case for a reorg I thought, however, I am currently exporting this table and suddenly noticed that the dump file is now in excess of 1.5Gb and still going strong. Does export merely backup the data or does it also backup other stuff (unused blocks, preallocated etc.) Regards Lee Robertson The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Alert log
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).
RE: PL/SQL Question
There is indeed a sleep, in dbms_lock, taking a single argument seconds. -Original Message- Sent: Friday, May 11, 2001 11:20 AM To: Multiple recipients of list ORACLE-L I need to whip out a PL/SQL procedure real quick today and have a quick question for fellow-listers ( since today is Friday, hopefully I don't get RTFMed on this one :) ) The purpose of my procedure is to collect stats from v$session_wait periodically ( every second for example) and pump the data into a stats table. But how to make the procedure to wait for a specified time? I know of the option of using dbms_jobs to handle this. But I am wondering if there is a similar function in PL/SQL similar as the Unix 'sleep' command. TIA Dennis Meng Database Administrator Focal Communications 847-954-8328 -- 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: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: PL/SQL Question
Dennis, How about dbms_lock.sleep(seconds) ? Jared On Friday 11 May 2001 08:20, [EMAIL PROTECTED] wrote: I need to whip out a PL/SQL procedure real quick today and have a quick question for fellow-listers ( since today is Friday, hopefully I don't get RTFMed on this one :) ) The purpose of my procedure is to collect stats from v$session_wait periodically ( every second for example) and pump the data into a stats table. But how to make the procedure to wait for a specified time? I know of the option of using dbms_jobs to handle this. But I am wondering if there is a similar function in PL/SQL similar as the Unix 'sleep' command. TIA Dennis Meng Database Administrator Focal Communications 847-954-8328 -- 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).
saving billions? / fwd: GE Scales Back Amid Struggle To Connect Suppliers
fyi (follow up to the thread about Oracle's claims to save billions by converting business practices with internet technology) ---original message follows--- Date sent: Thu, 10 May 2001 02:03:28 -0400 (EDT) TODAY'S NEWS * GE Scales Back Amid Struggle To Connect Suppliers ... * OPINION: Rob Preston: There's No Shame In Realization That E-Biz Is Tough ... *** GE Scales Back Amid Struggle To Connect Suppliers General Electric Co., a harbinger of the e-business future for many companies, is scaling back its expectations of the Internet. In the process, GE is calling into question whether it's even possible to build a fully Net-enabled supply chain. The $130 billion conglomerate, which boldly predicted last June that it would use Internet technology to cut $10 billion in costs by mid-2002, conceded last week that it will only record $1.6 billion in savings this year. One big reason for the revised estimates: GE is having trouble connecting customers and suppliers to Web-trading systems. While executives wouldn't say how many suppliers it works with on the Web to perform critical functions, such as order-taking and logistics management, experts placed the figure at roughly 25 percent, or 7,500, of GE's 30,000 suppliers. Another 7,500 or so connect to GE using electronic data interchange (EDI) networks that predate the Internet. That leaves 15,000 that rely mainly on manual processes to conduct business with GE. GE executives wouldn't reset the timetable for 100 percent supplier Web-enablement, but a step toward that goal will be reached in November, by which point GE will use the Web to pay all suppliers electronically, officials said. --Chuck Moozakis Read on: http://update.internetweek.com/cgi-bin4/flo?y=eDfk0BdpN70V30Nma0Au *** ... *** OPINION: Rob Preston: There's No Shame In Realization That E-Biz Is Tough No one said e-business transformation would be easy. At least Jack Welch never did. When Welch, General Electric's no-nonsense chairman, first marshaled his top executives two years ago to drive most every company process and partner interaction onto the Internet, the understanding--as with all Welch directives--was for swift and unswerving compliance. But he knew that the Internet wouldn't transform the 120-year-old company overnight, even if the execs he had whipped into a frenzy proceeded to tout every incremental e-business milestone. The company has come to realize that Internet-enabling its sprawling value chain of strategic suppliers and business customers--the place where real e-transformation takes place--will take longer than the internal stuff. But there's no shame in this realization. E-business is a constantly moving target. The best companies learn from their mistakes and miscalculations--and they move on. --Rob Preston Get the whole story: http://update.internetweek.com/cgi-bin4/flo?y=eDfk0BdpN70V30Nmh0A2 *** ... Did someone forward this to you? Get your own issue... http://update.internetweek.com/cgi-bin4/flo?y=eDfk0BdpN70V30LsY0Aq ... -- 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 9i Articles - self tuning, launch delayed to
Paul, Clarification: I didn't write the material, I was just posting an excerpt from an Oracle document. Anyway, I vastly enjoyed your comments. so. I take it that you also found the lack of detail about self tuning to be problematic. :) Presumably we now have a lot to look forward to in terms of reading Oracle9i tuning documentation, scattered stuff in a bewildering variety of official Oracle manuals, various tech notes, TAR dialogues, suport forums, listservs, and of course 3rd party tuning books. I love the madness! Thanks for the very generous offer of help w/ Veritas/Win2K. Will ponder after talking to the Win2k SA folks. Since the Veritas Win2K BE Oracle agent are fairly cheap, and we get an almost 1/2 off education discount, we are buying it. regards, ep On 10 May 2001, at 23:35, Paul Drake wrote: Date sent: Thu, 10 May 2001 23:35:21 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Eric D. Pierce wrote: [excerpted from: http://www.oracle.com/ip/deploy/database/9i/continuity/index.html?manageas.html ] Summary Self-tuning, self-managing Oracle9i monitors your system to provide high availability, reliability and minimized downtime. Whether you are a hosting service, in-house data center, or IT organization, you can rely on Oracle9i and its system management products to provide optimal quality of service to all users. Eric, I believe that I see the emergence of new BOFH excuse of the day material: ... -- 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: Drop schema and all related objects
Title: RE: Drop schema and all related objects -Original Message- From: james ellis [mailto:[EMAIL PROTECTED]] connect as sys or system. drop user username cascade; The user and all objects will be removed. --- Mujeeb Chowdhry [EMAIL PROTECTED] wrote: How can I drop schema (user and all it's objects). I have one main user in the application and wants to drop user and all related objects. Can anyone help me in this regard. In My Humble Opinion, connecting as sys or system should be reserved for tasks that cannot be accomplished through another user. Instead, you could connect as any user that has DBA role (or the appropriate privileges) and then issue the drop statement. Also, it can often prove useful later to first do an export of the user and all the objects owned by that user, BEFORE doing the drop user cascade. -- Jacques R. Kilchoer (949) 754-8816 Quest Software, Inc. 8001 Irvine Center Drive Irvine, California 92618 U.S.A. http://www.quest.com
RE: RE: Silver vs. Gold support
On Fri, 11 May 2001,Mohan, Ross scribbled on the wall in glitter crayon: -Is this truly the beloved authoress of Oracle DBA 101 I hear? - -You speak sourly of our Lord in front of his very home? snicker snicker Ross be careful. Remember do not meddle in the affairs of dragons, for you are crunchy and go well with ketchup.;-) She's not the only one upset, they just nailed us here for Silver support big time. And I can't ever get logged into metawhat to put in the iTAR I have to have before I call support to get the silver support we paid for that doesn't even exist anymore. -- 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. ~~ If at first you don't succeed, you must be a programmer. -- 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: PL/SQL Question
while trunc(sysdate, ss) = 30 loop I think this should do whatever's in the loop every minute on the 30 second point. -Original Message- Sent: Friday, May 11, 2001 11:20 AM To: Multiple recipients of list ORACLE-L I need to whip out a PL/SQL procedure real quick today and have a quick question for fellow-listers ( since today is Friday, hopefully I don't get RTFMed on this one :) ) The purpose of my procedure is to collect stats from v$session_wait periodically ( every second for example) and pump the data into a stats table. But how to make the procedure to wait for a specified time? I know of the option of using dbms_jobs to handle this. But I am wondering if there is a similar function in PL/SQL similar as the Unix 'sleep' command. TIA Dennis Meng Database Administrator Focal Communications 847-954-8328 -- 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 e-mail message has been scanned for the presence of all known computer viruses by the MessageLabs Virus Control Center. However, it is still recommended that you use local virus scanning software to monitor for the presence of viruses. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dasko, Dan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Contigency plan
LOL! There are enough disasters in the world to support a journal? : ) (I know, I know... it's to plan ahead, just in case. I still think this was funny though. It's Friday, OK?) 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: Friday, May 11, 2001 11:36 AM To: Multiple recipients of list ORACLE-L Subject:Re: Contigency plan http://www.drj.com - disaster recovery journal For those of us who are beyond paranoid ... and would be carrying the tapes to the remote data center. Paul -- 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: When to go for ORACLE NAMES Server
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 spelling of 'ListGuru') and in || the message BODY, include a line containing: UNSUB ORACLE-L || (or the name of mailing list you want to be removed from). You may || also send the HELP command for other information (like subscribing). || -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:When to go for ORACLE NAMES Server
We have 20+ instances this mess called PeopleSoft, so keeping track of TNSNAMES is a real tedious thing to do. Consequently we migrated to Oracle Names have loved it ever since. If your going to get on Onames, use either 7.3.4's version of 8.1.6's. 8.0.x's version has way too many bugs. Dick Goulet Reply Separator Author: Johnson Poovathummoottil [EMAIL PROTECTED] Date: 5/11/2001 8:15 AM 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 spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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).
Why do I still see index partitions when I dropped the underlying table
This one's got me stumped. We are on 8.0.4 on Sun Solaris 2.6. I have some locally indexed partitions on a table that's partitioned by time. I dropped the '96 and '95 partitions of the underlying table and I no longer see them. I used the following statements: alter table xx truncate partition 95 drop storage; alter table xx drop partition 95; According to the documentation, the corresponding '95 and '96 index partitions (for a locally indexed table which I confirmed that it is using the LOCALITY column of dba_ind_partitions) should be dropped automatically. However, when I query dba_ind_partitions view, I can still see them. Documentation says I can not specifically drop index partitions of locally indexed tables (can only do this for globally indexed tables). I actually tried to drop these partitions and Oracle gave me an error message saying I couldn't do it because it was a local index. I thought these index partition 95 and 96 would go away. Why do I still see them? We will rebuild the index tonight but I can't rebuild the whole index right now - too much performance degredation. I'm just curious about what is going on. Do I need to refresh something? Is there anything low-impact I can do right now to make these index partitions go away? Do I even need to care? Thanks for any kind soul with answers. Cherie Machler Gelco Information Network -- 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
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 spelling of 'ListGuru') and in || the message BODY, include a line containing: UNSUB ORACLE-L || (or the name of mailing list you want to be 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: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: Silver vs. Gold support
I am confused now, I thought Oracle was rolling up the support costs into the license cost calculations now that they discontinued the Bronze, Silver, Gold support options. This is like income tax forms! Why can't they just create an income tax form that is only half a page long! I can't believe that politicians never promise this during election campaigns, you would think that would be a sure ticket to being elected. Likewise with Oracle, and other vendors - why complicate things needlessly? Life is bad enough as it is, why try to mess things up for other people even more. 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: Rachel Carmichael [SMTP:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 11:21 AM To: Multiple recipients of list ORACLE-L Subject:RE: RE: Silver vs. Gold support so the support bill we just paid should get refunded because it was for Silver Support which no longer exists? and I pay for support but they desupport the products I have paid support for, and instead of giving me the new software release so that the support I paid for is still relevant, they will charge me for the update. And not give me a prorated refund. Ya know, if I'm gonna get screwed I'd at least like to enjoy it From: Eric D. Pierce [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: RE: Silver vs. Gold support Date: Thu, 10 May 2001 13:17:06 -0800 Apparently now Bronze/Silver is just called Product Support, and Gold is called Premium. All 24x7. Upgrades have been split off. Of course now Metalink has to also be renamed (Oracle Ink9i, or OInk9i?) since there is no more Metal, right. :) http://www.oracle.com/support/index.html?support_ebus.html ---excerpt--- ... Oracle Support is leveraging the power of the Internet to deliver simpler and sharply focused support services, while making their purchase faster and easier. To facilitate web-based transactions, Product Support is now priced as a percentage of list license price. [7% of license cost (annual?)] Additionally, software updates can be purchased separately on a subscription basis, [15% of license cost, annual] and our OracleBRONZE and OracleSILVER services have been consolidated into a single 24 x7 technical assistance service and removed from the price list. OracleGOLD, OracleLifecycle and our Oracle Expertise service capabilities are now offered within the Premium Support menu. ... ---end--- -- 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). _ 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). -- Please see the
Re: PostGres WAS: RE: Oracle 9i Articles - self tuning, launch delaye
Yes, it's open source. My personal project uses Apache, PHP and Postgres on Linux servers -- pure open source. Guess how long the servers and the web server and hence the site have been up? Pretty much since we installed. Love it!!! For those of you who don't know, PHP is a server-side templating language based on Perl, and it is dreamy. I'm honestly not sure if your mail is arriving in MIME format -- it just looks like plain text to me. I'm unfortunately on a Lotus Notes email client now, and I haven't figured out how to turn off all the rich text, etc. Anyone else out there know how to do it? I humbly apologize if I'm cluttering up the list, and I'll switch to something else if that will help. 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] Mohan, Ross MohanR@STARSTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] -SMI.comcc: Sent by: Fax to: root@fatcity.Subject: PostGres WAS: RE: Oracle 9i Articles - self tuning, launch com delaye 05/10/2001 06:50 PM Please respond to ORACLE-L 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: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: Silver vs. Gold support
Yes, I join you in significant frustration with oracle. ( Although I had a visitation from an OWS goddess just recently that ameliorates my rancor significantly.) Things like Postgres www.postgresql.org and Kdb www.kx.com are becoming increasingly interesting to me. But, even if I leave the happy world of Power Units, Armani suits, and self-tuning apps, I will still stay on this list, just to ask people my favorite question: Are you an idiot? With Love, Eternal Joy, and Ketchup, etc. || -Original Message- || From: Thater, William [mailto:[EMAIL PROTECTED]] || Sent: Friday, May 11, 2001 1:09 PM || To: Mohan, Ross || Cc: Multiple recipients of list ORACLE-L || Subject: RE: RE: Silver vs. Gold support || || || On Fri, 11 May 2001,Mohan, Ross scribbled on the wall in || glitter crayon: || || -Is this truly the beloved authoress of Oracle DBA 101 I hear? || - || -You speak sourly of our Lord in front of his very home? || snicker snicker || || Ross be careful. Remember do not meddle in the affairs of || dragons, for you are crunchy and go well with ketchup.;-) || || She's not the only one upset, they just nailed us here for || Silver support big time. || || And I can't ever get logged into metawhat to put in the iTAR || I have to have before I call support to get the silver || support we paid for that doesn't even exist anymore. || || -- || 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. || ~~ || If at first you don't succeed, you must be a programmer. || -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Which tables are in buffer cache.?
I think if you offline a tablespace (or is it read-only? I can't remember), then any relevant buffers are flushed out... hth connor --- Hillman, Alex [EMAIL PROTECTED] wrote: Mark, how do you manually remove objects from buffer cache? I saw you writing before that you know how to do it and I would be very interested to know also if it is not trade secret of course. Alex Hillman -Original Message- Sent: Friday, May 04, 2001 11:11 PM To: Multiple recipients of list ORACLE-L Been here: this is a really interesting exercise! You can query v$bh (or its x$ base table) which has a record for every buffer cache block. Link on object ID's While tuning a 3000Tx/sec OLTP database I could get constant 24*7 performance by by examining objects in the buffer cache and manually removing unwanted objects at end of business day. This prevents required objects being aged out and having to be reloaded. Typical scenario is to remove the index for the partition for 'todays' transactions to make room in the buffer cache for 'tomorrows' transactions. Its good fun tuning at this level. I wrote a gui via perl DBI that dumped the bcache contents (similar to the oracle tablespace manager gui) and allows objects to be manually/automatically removed from memory. I think DB2 can do this already. Does 9i allow definition of custom buffer pools (buffer_pool_Transactions for example), each with its own aging algorithm? Ive got the 9i beta cd here but havent even opened it. Too busy. Mark Teehan Singapore From: Bunyamin K.Karadeniz [EMAIL PROTECTED] Date: Wed, 2 May 2001 09:23:57 +0300 Subject: Which tables are in buffer cache.? This is a multi-part message in MIME format. --=_NextPart_000_00E6_01C0D2E9.9D9A9360 Content-Type: text/plain; charset=iso-8859-9 Content-Transfer-Encoding: quoted-printable Hi all gurus, =20 I want to learn the way to ook at=20 Which tables are in buffer cache./Analyzed? Is there a system view showing these tables?? Thanks to All. Bunyamin K.Karadeniz Database Group / Information Systems Department=20 HAVELSAN Ankara /TURKEY Tel : +903122873565 / 1681 Mobile Tel : +90 535 3357729 ERG Group -- The contents of this email and any attachments are confidential and may only be read by the intended recipient. - -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Teehan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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). = 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).
RE: Password with special character
If you're using the a profile with a password_verify function, then you shouldn't be using ALTER USER to change a user's password. If you are trying to change the password through SQL*Plus, then you should instead be using the SQL*Plus PASSWORD command: SQL PASSWORD username Using this command will validate the user's new password using the password_verify function that is specified in the user's profile, and will allow for the password to contain the special characters that you are trying to use. When you use ALTER USER it doesn't use that password_verify function, and because it is a DDL command, it limits you to Oracle's object naming restrictions, which will not allow you to use most special characters. For more information on this, see the Oracle8i Administrators Guide, pp 21-15 under Password Complexity Verification, and also the SQL*Plus Users Guide and Reference Release 8.1.6, pp 8-76 for details on using the PASSWORD command. Both of these documents are available on Metalink. -::YEX::- ))) -Original Message- Sent: Friday, 11 May, 2001 10:01 AM To: Multiple recipients of list ORACLE-L Hi Thye Hock Gan, Thank you for your info. I am using Oracle 8.1.6 Solaris 7 Install patch bug122 for SQL*PLUS How can I change user password with special character alter user teddy identified by bear12#$; is not working because of alter user teddy identified by 'bear12#$'; also not working I have password_verification profile with verify_function that provided by Oracle Administrator Guide that must at least 1 special character in user password. Thank you, Sinardy -Original Message- Sent: Friday, 11 May 2001 6:34 PM To: LazyDBA mailing list This are characters you can use: !#$%()'*+,-/:;+_ if I'm not mistaken. Try them anyway. --- Sinardy Xing [EMAIL PROTECTED] wrote: Hi all, Can Oracle User change their password with special characters? Thank you very much Sinady 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 __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yexley Robert D SSgt AFIT/SCA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: desc SQL*PLUS
We had a similar thing when we upgraded OS last weekend. Re-linking sqlplus from the correct (i.e. new) ORACLE_HOME resolved our problem. HTH Stephen [EMAIL PROTECTED] 05/11/01 01:35AM Hello DBA's I have recently upgraded from 8.1.6.0 to 8.1.6.3. I seem to be having a weird problem in sql*plus, in that whenever I do a describe on a table it comes up with the following error :- SQL desc emp; ERROR: ORA-03113: end-of-file on communication channel I can run select statements without any problems ! TIA Sajid Iqbal -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sajid Iqbal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Drop schema and all related objects
If there is a lot of objects in the schema you may need to increase parameter enqueue_resources. If not enougn enqueues this command will give you an error and user and some objects will not be dropped. If you don't want to increase this parameter you can repeate this command until user will be dropped. Alex Hillman -Original Message- Sent: Friday, May 11, 2001 9:56 AM To: Multiple recipients of list ORACLE-L connect as sys or system. drop user username cascade; The user and all objects will be removed. james --- Mujeeb Chowdhry [EMAIL PROTECTED] wrote: Hi DBA's, How can I drop schema (user and all it's objects). I have one main user in the application and wants to drop user and all related objects. Can anyone help me in this regard. Thanks Mujeeb Chowdhry Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mujeeb Chowdhry INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: james ellis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: RE: Silver vs. Gold support
On Fri, 11 May 2001,Mohan, Ross scribbled on the wall in glitter crayon: -question: Are you an idiot? Yes, but everybody already knows that.;-) -- 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. ~~ If at first you don't succeed, you must be a programmer. -- 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: PL/SQL-procedures
Write a package. David A. Barbour [EMAIL PROTECTED] wrote: How can I write procedure which runs 3 different subprocedures.? 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). -- 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: RE: Silver vs. Gold support
I was also under the impression that Oracle was just splitting up the cost for Upgrades and Support mainly because these two pieces can be dealt with differently for tax purposes. I have no clue what makes large (or even moderately small) corporations happy, but apparently this is one thing that does as my Finance dept has asked me in the past if I could split support costs into upgrade/support. (boy, talk about your run-on and on and on sentences) Henry -Original Message- Sent: Friday, May 11, 2001 11:27 AM To: Multiple recipients of list ORACLE-L I am confused now, I thought Oracle was rolling up the support costs into the license cost calculations now that they discontinued the Bronze, Silver, Gold support options. This is like income tax forms! Why can't they just create an income tax form that is only half a page long! I can't believe that politicians never promise this during election campaigns, you would think that would be a sure ticket to being elected. Likewise with Oracle, and other vendors - why complicate things needlessly? Life is bad enough as it is, why try to mess things up for other people even more. 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: Rachel Carmichael [SMTP:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 11:21 AM To: Multiple recipients of list ORACLE-L Subject:RE: RE: Silver vs. Gold support so the support bill we just paid should get refunded because it was for Silver Support which no longer exists? and I pay for support but they desupport the products I have paid support for, and instead of giving me the new software release so that the support I paid for is still relevant, they will charge me for the update. And not give me a prorated refund. Ya know, if I'm gonna get screwed I'd at least like to enjoy it From: Eric D. Pierce [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: RE: Silver vs. Gold support Date: Thu, 10 May 2001 13:17:06 -0800 Apparently now Bronze/Silver is just called Product Support, and Gold is called Premium. All 24x7. Upgrades have been split off. Of course now Metalink has to also be renamed (Oracle Ink9i, or OInk9i?) since there is no more Metal, right. :) http://www.oracle.com/support/index.html?support_ebus.html ---excerpt--- ... Oracle Support is leveraging the power of the Internet to deliver simpler and sharply focused support services, while making their purchase faster and easier. To facilitate web-based transactions, Product Support is now priced as a percentage of list license price. [7% of license cost (annual?)] Additionally, software updates can be purchased separately on a subscription basis, [15% of license cost, annual] and our OracleBRONZE and OracleSILVER services have been consolidated into a single 24 x7 technical assistance service and removed from the price list. OracleGOLD, OracleLifecycle and our Oracle Expertise service capabilities are now offered within the Premium Support menu. ... ---end--- -- 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). _ 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
Re: PL/SQL Question
Dan, While this does not work as is, but probably could be in some fashion, you win the days raspberry for the most obfuscated answer. :) Jared On Friday 11 May 2001 09:56, Dasko, Dan wrote: while trunc(sysdate, ss) = 30 loop I think this should do whatever's in the loop every minute on the 30 second point. -Original Message- Sent: Friday, May 11, 2001 11:20 AM To: Multiple recipients of list ORACLE-L I need to whip out a PL/SQL procedure real quick today and have a quick question for fellow-listers ( since today is Friday, hopefully I don't get RTFMed on this one :) ) The purpose of my procedure is to collect stats from v$session_wait periodically ( every second for example) and pump the data into a stats table. But how to make the procedure to wait for a specified time? I know of the option of using dbms_jobs to handle this. But I am wondering if there is a similar function in PL/SQL similar as the Unix 'sleep' command. TIA Dennis Meng Database Administrator Focal Communications 847-954-8328 -- 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).
RMAN compatibility
Hi, I've installed RMAN 8.1.7 with my db on NT. I also use it to back up another NT cluster instance, also 8.1.7. I also wanted to use it to backup a HPUX 8.1.5 instance but i get an error Target DB is not compatible with version of RMAN. Now I get two answers from Oracle. The first one says that I cannot use RMAN release 8.1.7 on prior versions of Oracle. The second says that I can but refers to note 121125.1 which is not available for public viewing. When I mentioned that note to the first response on a call back she stated that that note doesn't exist. Anyway, I was wondering if anyone had any experience with this and any suggestions about how to solve the problem. TIA, mikeo __ 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: mike oneil INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RE: Drop schema and all related objects
Thanks to all who replied, it works. [EMAIL PROTECTED] 05/11 1:42 PM -Original Message- From: james ellis [mailto:[EMAIL PROTECTED]] connect as sys or system. drop user username cascade; The user and all objects will be removed. --- Mujeeb Chowdhry [EMAIL PROTECTED] wrote: How can I drop schema (user and all it's objects). I have one main user in the application and wants to drop user and all related objects. Can anyone help me in this regard. In My Humble Opinion, connecting as sys or system should be reserved for tasks that cannot be accomplished through another user. Instead, you could connect as any user that has DBA role (or the appropriate privileges) and then issue the drop statement. Also, it can often prove useful later to first do an export of the user and all the objects owned by that user, BEFORE doing the drop user cascade. -- Jacques R. Kilchoer (949) 754-8816 Quest Software, Inc. 8001 Irvine Center Drive Irvine, California 92618 U.S.A. http://www.quest.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mujeeb Chowdhry INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: PL/SQL Question
[EMAIL PROTECTED] wrote: I am wondering if there is a similar function in PL/SQL similar as the Unix 'sleep' command. Use dbms_lock.sleep -- it's pretty much like Unix sleep, but requires you to grant execute on dbms_lock to whichever account needs it. 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).
OT - RE: PostGres
Diana, Sounds like an excellent alternative to higher end systems (shoots self in oracle-foot). Have you tested how well it scales yet? Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 10:27 AM To: Multiple recipients of list ORACLE-L Subject: Re: PostGres WAS: RE: Oracle 9i Articles - self tuning, launch delaye Yes, it's open source. My personal project uses Apache, PHP and Postgres on Linux servers -- pure open source. Guess how long the servers and the web server and hence the site have been up? Pretty much since we installed. Love it!!! For those of you who don't know, PHP is a server-side templating language based on Perl, and it is dreamy. -- 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: RE: Silver vs. Gold support
Is this truly the beloved authoress of Oracle DBA 101 I hear? You speak sourly of our Lord in front of his very home? snicker snicker || -Original Message- || From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] || Sent: Friday, May 11, 2001 10:21 AM || To: Multiple recipients of list ORACLE-L || Subject: RE: RE: Silver vs. Gold support || || || so the support bill we just paid should get refunded because || it was for || Silver Support which no longer exists? and I pay for support || but they || desupport the products I have paid support for, and instead || of giving me the || new software release so that the support I paid for is still || relevant, they || will charge me for the update. And not give me a prorated refund. || || Ya know, if I'm gonna get screwed I'd at least like to enjoy it || || || || || From: Eric D. Pierce [EMAIL PROTECTED] || Reply-To: [EMAIL PROTECTED] || To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] || Subject: RE: RE: Silver vs. Gold support || Date: Thu, 10 May 2001 13:17:06 -0800 || || Apparently now Bronze/Silver is just called Product || Support, and Gold is called Premium. All 24x7. || || Upgrades have been split off. || || Of course now Metalink has to also be renamed (Oracle Ink9i, or || OInk9i?) since there is no more Metal, right. :) || || || http://www.oracle.com/support/index.html?support_ebus.html || || ---excerpt--- || || ... || Oracle Support is leveraging the power of the Internet || to deliver simpler and sharply focused support services, || while making their purchase faster and easier. To || facilitate web-based transactions, Product Support is || now priced as a percentage of list license price. || [7% of license cost (annual?)] || Additionally, software updates can be purchased separately || on a subscription basis, || [15% of license cost, annual] || and our OracleBRONZE and OracleSILVER services have been || consolidated into a single 24 x7 technical assistance || service and removed from the price list. OracleGOLD, || OracleLifecycle and our Oracle Expertise service || capabilities are now offered within the Premium Support || menu. || || ... || || ---end--- || || || -- || 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). || || _ || 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). || -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: PL/SQL Question
dbms_lock.sleep(second in number); [EMAIL PROTECTED] 05/11/01 11:20AM I need to whip out a PL/SQL procedure real quick today and have a quick question for fellow-listers ( since today is Friday, hopefully I don't get RTFMed on this one :) ) The purpose of my procedure is to collect stats from v$session_wait periodically ( every second for example) and pump the data into a stats table. But how to make the procedure to wait for a specified time? I know of the option of using dbms_jobs to handle this. But I am wondering if there is a similar function in PL/SQL similar as the Unix 'sleep' command. TIA Dennis Meng Database Administrator Focal Communications 847-954-8328 -- 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: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 9i Articles - self tuning, launch delayed to
Eric, Sales and marketing have 1 job and that is to sell and market. These marketing things are teasers not necessarily giving detailed information. I have not checked but there may be some Oracle9i stuff on OLN. I think OLN has a trial membership (for 30 days?). However I am not sure of the detail. I do know that 9i still offers the old way of tuning, however you can have Oracle do it for you if you want. The automatic tuning allows Oracle to adjust memory structures dynamically and when oracle adjusts these structures it write that information to the SPFILE. The SPFILE is the oracle managed init.ora. This dynamic tuning can also be temporary instead of persistent. 9i also brings back the ability to monitor the buffer cache. This will help you in determining if you need to add or subtract buffers. As far as the MTTR goes, you have this in 8i as well. Oracle8i has you specify the MTTR information in blocks where oracle9i has you specify it in seconds, then oracle9i will determine how many blocks and how often the blocks need to be written to the redo logs for faster instance recovery. Oracle managed files are nothing special. Oracle already creates the datafile for you. Oracle9i allows you to specify an init.ora parameter to specify where the datafiles get created by default. This also works for log files. This way you say CREATE TABLESPACE test and oracle will create the datafile in the specified location from the init.ora. Oracle managed UNDO are also just rollback segments that are managed by Oracle and not you. The oracle managed UNDO are still segments just like the ones you create. The oracle managed UNDO(AUTO) has features that you can't get with old way of doing UNDO (Manual). The AUTO undo automatically creates UNDO segments based on init.ora parameters that I haven't quite figured out yet. The AUTO undo also allows retention of UNDO for a specified period of time. I haven't tested this but have been told that AUTO undo can steal extents from other rollback segments if that specific rollback segment needs more space (extents) and cannot extend in the current tablespace. Scott dude, The article is not actually providing details, it is just reporting that Oracle has provided details. Who got them, when, how, where is a different story. :) It is weird how the article doesn't cite any specific sources at Oracle. I even looked in www.oracle.com's press releases page (yuk), and so forth, and couldn't see anything. Although there is a Press Portal at www.oracle.com that seems to require registration prior to access. In terms of general 9i product information, there is a lot of stuff (see below), but I couldn't find *anything* at the first or second level of the 9i info that jumped out at me as being focused clearly explaining self tuning details. The data sheet on Oracle9i Manageability (URL below) refers http://www.oracle.com/ip/deploy/database/9i/continuity/index.html?manageas.html to startup/backup issues, and indicates that a persistent INIT.ORA feature is used to bring self tuned parameter settings across shutdowns. Sounds like an incredibly giant pile of cr*p to me. The assumption they are presumably arguing *against* is that self-tuned features would somehow be non-persistent. The circumstances under which a self tuning database would forget what it had done previously is unexplained. Apparently the people that produce the marketing drivel at Oracle either have no clue about this specific topic, or the material was presented to them in an incoherent maner (or both). At any rate it is exceptionally unhelpful to the reader (especially those without a lot of time to waste) to hae to attempt to make sense out of such garbage. Moving right along... In the Resource Management section (same URL): - self-managing rollback segments (some detail) - multi-block size db files for portability - memory management: * SGA self tuning (buffer cache and shared pool) * SGA tuning advisories * transparent management of working memory for SQL execution by self tuning the initialization runtime parameters controlling allocation of private memory - Oracle Managed Files (auto creation of db files) - control downtime ... specify mean time to recover (MTTR) ... in number of seconds ... coupled with dynamic initialization parameters ... improve database availability (which means ??, I don't know) - new capability ... resumable statements ... temporarily suspend ... operation ... process encounters out of space errors ... fix problem ... resume the operation from the point of interruption ... without disrupting normal database operations [new section:] End-to-End Management of Oracle's Internet Infrastructure ... is continuous system availability, reliability, and performance ... important
RE: After Update on TABLE_NAME For Each Row... Triggers and
I ran a few tests of this on both a 7.3.4 and 8.1.6 database and found there is definitely a difference in the way Oracle handles FK constraints. In my tests, I created a PARENT and CHILD table, with FK constraint, and with a trigger on the CHILD. I used two differenct after update triggers: one slept for 2 seconds (sleepy), one inserted old and new data into a RESULTS table. I then ran two updates, one successful and one unsuccessful due to the FK. Tracing was on. I'll paste parts of the trace files at the end. The main points are that: In 7.3.4 Oracle checks the FK by running SELECT null FROM parent WHERE id=:1 If this succeeeds, run the trigger, otherwise get the FK name for the error message In 8.1.6 the trigger is run regardless, and rolled back if necessary. I see the Insert for the RESULTS table even when the FK is violated. I also see the extra 2 second wait in the trace file for my sleepy trigger. The problem is that the entries in the RESULTS table can be rolled back, but not the 2 second sleep. Sounds like a bug to me. Henry sqlplus system/manager EOF DROP TABLE child_temp / DROP TABLE parent_temp / CREATE TABLE parent_temp (id number) / CREATE TABLE child_temp (id number) / ALTER TABLE parent_temp ADD CONSTRAINT pk_id PRIMARY KEY (id) / ALTER TABLE child_temp ADD CONSTRAINT fk_id FOREIGN KEY (id) REFERENCES parent_temp / INSERT INTO parent_temp VALUES (1) / INSERT INTO parent_temp VALUES (2) / ALTER SESSION SET EVENTS '10046 trace name context forever, level 4' / INSERT INTO child_temp VALUES (1) / UPDATE child_temp SET id=2 WHERE id=1 / UPDATE child_temp SET id=3 WHERE id=2 / EOF sqlplus system/manager EOF CREATE OR REPLACE TRIGGER sleepy AFTER UPDATE ON system.child_temp FOR EACH ROW BEGIN dbms_lock.sleep(2); END; / /* or use DROP TABLE results_temp / CREATE TABLE results_temp (old number, new number) / CREATE OR REPLACE TRIGGER results AFTER UPDATE ON system.child_temp FOR EACH ROW BEGIN INSERT INTO results_temp VALUES (:old.id, :new.id); END; / */ ALTER SESSION SET EVENTS '10046 trace name context forever, level 4' / UPDATE child_temp SET id=1 WHERE id=2 / UPDATE child_temp SET id=3 WHERE id=1 / EOF Edited trace files Oracle7 Server Release 7.3.4.0.1 - Production = PARSING IN CURSOR #1 len=38 dep=0 uid=5 oct=6 lid=5 tim=12613128 hv=710801591 ad='801c1e34' UPDATE child_temp SET id=1 WHERE id=2 = PARSING IN CURSOR #2 len=56 dep=1 uid=0 oct=3 lid=0 tim=12613128 hv=2218816300 ad='802ecc4c' select null from SYSTEM.PARENT_TEMP where ID = :1 EXEC #2:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=12613128 FETCH #2:c=0,e=0,p=0,cr=2,cu=0,mis=0,r=1,dep=1,og=4,tim=12613128 = PARSING IN CURSOR #4 len=112 dep=2 uid=0 oct=3 lid=0 tim=12613130 hv=2862726689 ad='80301e5c' select u.name,o.name from obj$ o,user$ u,trigger$ t where t.baseobject=:1 and t.obj#=o.obj# and o.owner#=u.user# = PARSING IN CURSOR #3 len=44 dep=1 uid=5 oct=2 lid=5 tim=12613130 hv=1893271645 ad='801b8e90' INSERT INTO RESULTS_TEMP VALUES ( :b1,:b2 ) = PARSING IN CURSOR #2 len=124 dep=1 uid=0 oct=3 lid=0 tim=12613131 hv=1953436077 ad='802f0a9c' select i.file#, i.block#, i.cols, s.groups from ind$ i, seg$ s where obj# = :1 and i.file# = s.file# and i.block# = s.block# = PARSING IN CURSOR #1 len=38 dep=0 uid=5 oct=6 lid=5 tim=12613131 hv=710800563 ad='801b321c' UPDATE child_temp SET id=3 WHERE id=1 = PARSING IN CURSOR #2 len=56 dep=1 uid=0 oct=3 lid=0 tim=12613131 hv=2218816300 ad='802ecc4c' select null from SYSTEM.PARENT_TEMP where ID = :1 EXEC #2:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=12613131 FETCH #2:c=0,e=0,p=0,cr=1,cu=0,mis=0,r=0,dep=1,og=4,tim=12613131 = PARSING IN CURSOR #3 len=80 dep=1 uid=0 oct=3 lid=0 tim=12613131 hv=3971794324 ad='802a67e8' select o.name, c.name from con$ c, user$ o where c.con# = :1 and owner# = user# XCTEND rlbk=0, rd_only=0 XCTEND rlbk=0, rd_only=1 Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production PARSING IN CURSOR #1 len=38 dep=0 uid=5 oct=6 lid=5 tim=168651643 hv=1710742153 ad='82d88fa4' UPDATE child_temp SET id=1 WHERE id=2 END OF STMT = PARSING IN CURSOR #3 len=48 dep=2 uid=0 oct=3 lid=0 tim=168651645 hv=1005331575 ad='82dda048' select user# from sys.user$ where name = 'OUTLN' END OF STMT PARSE #3:c=1,e=1,p=0,cr=0,cu=0,mis=1,r=0,dep=2,og=4,tim=168651645 BINDS #3: = PARSING IN CURSOR #3 len=175 dep=2 uid=0 oct=3 lid=0 tim=168651645 hv=1491008679 ad='82f1293c' select u.name,o.name, t.update$, t.insert$, t.delete$, t.enabled from obj$ o,user$ u,trigger$ t where t.baseobject=:1 and t.obj#=o.obj# and o.owner#=u.user# order by o.obj# = PARSING IN CURSOR #2 len=44 dep=1 uid=5 oct=2 lid=5 tim=168651646 hv=1493239216 ad='82d9436c' INSERT INTO RESULTS_TEMP VALUES (
Fwd: oracle replication
FYI I am forwarding this to the list, so please address replies to the original sender. -- Forwarded Message -- Date: Fri, 11 May 2001 12:45:43 +0530 Hi jared This is Nihar from india. I am having some query regarding Oracle Replication. Basically i am having 2 diffrent server running oracle 8i on solaris.One is in usa and one is in india.Now the table i want to replicate is users database. I want to have unique username on both the end. but Us users database should be there on usa server and same for the indian database users. can u just help me in deciding replication method and can u pls tell me how should i go bout it..? though i am not an oracle developer pls explain me in details if u have time. thanks and regards - NIHAR SANGHVI NetMagic Solutions Pvt. Ltd. 22,Nirlon Complex,Western Express Highway, Goregaon (E), Mumabai 400 063 Phone: 8723003 extn: 144 www.netmagicsolutions.com --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Password with special character
Sinardy Xing wrote: Hi all, Can Oracle User change their password with special characters? As with other Oracle identifiers, you have to put double quotes around the password to include nonstandard stuff. SQL ALTER USER SCOTT IDENTIFIED BY *^%$$# L; User altered. SQL CONNECT scott/*^%$$# L Connected. Supposedly, lower case letters aren't supported in these passwords, but I've seen it work just fine. Incidentally, double quotes are not supported by the SQL*Plus password command, which is a shame. I've logged a TAR on this problem. 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: PostGres WAS: RE: Oracle 9i Articles - self tuning, launch
Love it! It's open to change.how cool. || -Original Message- || From: Gary Boyd [mailto:[EMAIL PROTECTED]] || Sent: Thursday, May 10, 2001 9: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: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:Oracle error -20001
Pat, I could be totally off base here, but I believe that errors in the -2 to -20100 range are user defined via the RAISE_APPLICATION_ERROR procedure. That being the case you may not be able to find the error unless you have the source code. Dick Goulet Reply Separator Author: Pat Hildebrand [EMAIL PROTECTED] Date: 5/11/2001 9:20 AM 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: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Contigency plan
For those of us who are beyond paranoid ... and would be carrying the tapes to the remote data center. HEY! I resemble that remark! Rachel From: Paul Drake [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Contigency plan Date: Fri, 11 May 2001 06:35:47 -0800 http://www.drj.com - disaster recovery journal For those of us who are beyond paranoid ... and would be carrying the tapes to the remote data center. Paul Sinardy Xing wrote: Hi all, Do you guys have any good references (books or URLs) that teach some good Oracle potential problems with solutions for my contingency plan? Thank you, Sinardy -- 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 To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: When to go for ORACLE NAMES Server
Too much of a kill? Not at all. We are currently running ONAMES, and are planning on going OID as soon as we can get some time. OID (Oracle's LDAP) has other benefits like being able to authenticate more than just Oracle connections. ONAMES is relatively easy to setup. For your configuration, you will probably want to have a region database (repository), as well as more than one NAMES server running on different boxes for redundancy. With that setup, you can lose the region DB with no loss of service (each NAMES server keeps a local cache which is updated periodically), or either ONAMES server with no loss of connection for your clients. I hate to say it, but the Java Net8 Assistant does help quite a bit in setting up ONAMES. That is, when it doesn't hang or crash... When your ONAMES is setup, you will need to modify every client's SQLNET.ORA file to tell the client to resolve database aliases thru Names. Something like this: NAMES.PREFERRED_SERVERS = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = myserver1)(PORT = 1575)) (ADDRESS = (PROTOCOL = TCP)(HOST = myserver2)(PORT = 1575)) ) NAMES.DIRECTORY_PATH= (ONAMES) -Original Message- From: Johnson Poovathummoottil [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 11:15 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? -- 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).
AW: PL/SQL Question
Hi: use the procedure: dbms_lock.sleep(seconds); HTH -- Von: [EMAIL PROTECTED][SMTP:[EMAIL PROTECTED]] Gesendet: Freitag, 11. Mai 2001 17:20 An: Multiple recipients of list ORACLE-L Betreff: PL/SQL Question I need to whip out a PL/SQL procedure real quick today and have a quick question for fellow-listers ( since today is Friday, hopefully I don't get RTFMed on this one :) ) The purpose of my procedure is to collect stats from v$session_wait periodically ( every second for example) and pump the data into a stats table. But how to make the procedure to wait for a specified time? I know of the option of using dbms_jobs to handle this. But I am wondering if there is a similar function in PL/SQL similar as the Unix 'sleep' command. TIA Dennis Meng Database Administrator Focal Communications 847-954-8328 -- 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: Haunschmidt Andreas VASL/FAS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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
Title: RE: When to go for ORACLE NAMES Server There is one thing to be aware of. In a very large environment, (which you may or may not have) you don't always want everyone to be able to connect to everywhere. By using tnsnames.ora files, we can control which clients are allowed to connect to which servers (yes, the same thing can be accomplished using the protocol.ora file, but we prefer it this way). ymmv -blah blah blah R. Matt Adams - GE Appliances - [EMAIL PROTECTED] Meddle not in the affairs of troff, for it is subtle and quick to anger. -Original Message- From: Jared Still [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 2:37 PM To: Multiple recipients of list ORACLE-L 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 spelling of 'ListGuru') and in || the message BODY, include a line containing: UNSUB ORACLE-L || (or the name of mailing list you want to be 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: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: PL/SQL Question
Try DBMS_LOCK.SLEEP ( seconds IN NUMBER); Regards Karthik Ramachandran [EMAIL PROTECTED] 05/11/01 11:20AM I need to whip out a PL/SQL procedure real quick today and have a quick question for fellow-listers ( since today is Friday, hopefully I don't get RTFMed on this one :) ) The purpose of my procedure is to collect stats from v$session_wait periodically ( every second for example) and pump the data into a stats table. But how to make the procedure to wait for a specified time? I know of the option of using dbms_jobs to handle this. But I am wondering if there is a similar function in PL/SQL similar as the Unix 'sleep' command. TIA Dennis Meng Database Administrator Focal Communications 847-954-8328 -- 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: Karthik Ramachandran INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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
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 spelling of || 'ListGuru') and in || || the message BODY, include a line containing: UNSUB ORACLE-L || || (or the name of mailing list you want to be removed || from). You may || || also send the HELP command for other information (like || subscribing). || -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: When to go for ORACLE NAMES Server
Title: RE: When to go for ORACLE NAMES Server -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] We have 20+ instances this mess called PeopleSoft, so keeping track of TNSNAMES is a real tedious thing to do. Consequently we migrated to Oracle Names have loved it ever since. If your going to get on Onames, use either 7.3.4's version of 8.1.6's. 8.0.x's version has way too many bugs. I personally had the opposite experience. When I tried to set up Oracle Names, I first tried Oracle Names for Oracle NT 7.3.4. I never was successful in starting it, and when I called Oracle support the person on the phone said I've never managed to make it work either. When I tried Oracle Names 8.0 on HP-UX it worked right the very first time. If one wanted to set it up (it's not really that much more difficult than starting up a listener), I would asking someone to provide sample configuration files (i.e. names.ora and sqlnet.ora). With examples of those two files it should be easy. -- Jacques R. Kilchoer (949) 754-8816 Quest Software, Inc. 8001 Irvine Center Drive Irvine, California 92618 U.S.A. http://www.quest.com
Re: 9i Real Application Clusters
Rajnedra, Oracle9i RAC is what we now call Oracle Parallel Server. Oracle9i RAC is still BETA, so there may not be any white papers at the moment. I have looked and have not found any white papers on RAC. Scott Dear Friends Does anyone have any knowledge or experience with Oracle 9i Real Application Cluster stuff? If you have I'd like to hear from you about what it is and your insight. I think it is not out yet, some of you may have had the opportunity to find what it is. ... Thanks in advance Raj __ Rajendra JamadagniMIS, 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). -- 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: Alert log
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).
Re: PL/SQL Question
dbms_lock.sleep will do this... Thanks Riyaj Re-yas Shamsudeen Certified Oracle DBA i2 technologies www.i2.com [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/11/01 10:20 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:PL/SQL Question I need to whip out a PL/SQL procedure real quick today and have a quick question for fellow-listers ( since today is Friday, hopefully I don't get RTFMed on this one :) ) The purpose of my procedure is to collect stats from v$session_wait periodically ( every second for example) and pump the data into a stats table. But how to make the procedure to wait for a specified time? I know of the option of using dbms_jobs to handle this. But I am wondering if there is a similar function in PL/SQL similar as the Unix 'sleep' command. TIA Dennis Meng Database Administrator Focal Communications 847-954-8328 -- 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: RE: Silver vs. Gold support
On Fri, 11 May 2001,Boivin, Patrice J scribbled on the wall in glitter crayon: -Likewise with Oracle, and other vendors - why complicate things needlessly? -Life is bad enough as it is, why try to mess things up for other people even -more. Because they can? -- 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. ~~ If at first you don't succeed, you must be a programmer. -- 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: Why do I still see index partitions when I dropped the
Cherie, I take it that you built your indexes as create index xxx on table(col) local (partition x1 on tablespace 95, partition x2 on tablespace 96..) then you truncated the table in the partition 95 and then dropped the partition. If I remember correctly the index for the dropped partition is still there and you can clean it up by using the (alter index xxx rebuild partition x1) if the partition still exists but is empty. In your case I think that you will have to rebuild the complete index again because you have changed the make-up of the table layout. Updates and corrections please. ROR mª¿ªm [EMAIL PROTECTED] 05/11/01 01:11PM This one's got me stumped. We are on 8.0.4 on Sun Solaris 2.6. I have some locally indexed partitions on a table that's partitioned by time. I dropped the '96 and '95 partitions of the underlying table and I no longer see them. I used the following statements: alter table xx truncate partition 95 drop storage; alter table xx drop partition 95; According to the documentation, the corresponding '95 and '96 index partitions (for a locally indexed table which I confirmed that it is using the LOCALITY column of dba_ind_partitions) should be dropped automatically. However, when I query dba_ind_partitions view, I can still see them. Documentation says I can not specifically drop index partitions of locally indexed tables (can only do this for globally indexed tables). I actually tried to drop these partitions and Oracle gave me an error message saying I couldn't do it because it was a local index. I thought these index partition 95 and 96 would go away. Why do I still see them? We will rebuild the index tonight but I can't rebuild the whole index right now - too much performance degredation. I'm just curious about what is going on. Do I need to refresh something? Is there anything low-impact I can do right now to make these index partitions go away? Do I even need to care? Thanks for any kind soul with answers. Cherie Machler Gelco Information Network -- 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: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: import from corrupted export file.
ftp the file to the server again in binary mode instead of ascii... Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: Mohit Goyal [SMTP:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 6:55 AM To: Multiple recipients of list ORACLE-L Subject: import from corrupted export file. hi all, how to take an import from a corrupted export file. the error message is abnormal end of expoort file. Thanks, Mohit -- 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: Oracle9i block structures
Unal, What part of the block sturcture? Segment Header, Datablock Header? There are things in the blocks that are no different than they where in 6,7,8 or 8i. However with some of the new features such bitmap freelists, low highwater mark, high high waterwater, and changes to pctfree. There are some modifications to the block header and the segment header. They way rows are stored in the block pretty much remain the same. This is pretty much what I have learned to this point. Scott Hi, Do you know if Oracle9i block structures are modified ? thanks in advance... -- Use itrprof SQL Analyzer. It formats SQL_TRACE/Event10046 traces and gives tuning advises. It's web based, no download, no configuration. Just click http://www.unal-bilisim.com/products/itrprof/itrprof_index.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). -- 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: I want to re-install system, how can I backup and recover?
well if you are lucky and all the files are there, yes, backup the physical datafiles and when you bring the database up again, Oracle will recover. You MAY have to open the database resetlogs. Questions though: is the database still up? Can you shut it down cleanly (shutdown) and then do a cold backup of all the files? You are golden then. if the database is NOT up, do you run the database in archivelog or nonarchivelog mode. This will determine what you have to do to restart/recover the database. But no matter what take a backup of ALL the physical files on your system. This gives you a place to go back to if you do something incorrectly. Always good to have somewhere to go to start over. Rachel From: Robert Chen [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: I want to re-install system, how can I backup and recover? Date: Fri, 11 May 2001 08:35:39 -0800 hi, Because a hacker hackered our system, I have to re-install the solaris. How can I backup the oracle database? Just backup all the physical files? I am not a back up and recover expert. Please help me... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Chen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
Can I partition my primary key constraint index?
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).
RE: Password with special character
Title: RE: Password with special character -Original Message- From: Sinardy Xing [mailto:[EMAIL PROTECTED]] I am using Oracle 8.1.6 Solaris 7 Install patch bug122 for SQL*PLUS How can I change user password with special character alter user teddy identified by bear12#$; is not working because of alter user teddy identified by 'bear12#$'; also not working I have password_verification profile with verify_function that provided by Oracle Administrator Guide that must at least 1 special character in user password. Two things: a) the is a special character for SQL*Plus, used for string substitution. b) Passwords, like database object names, must be surrounded by double quotes when they contain special characters. e.g. SQL -- turn off substitution SQL set define off SQL -- surround password by for special char. SQL alter user jrk identified by bear12#$ ; User altered. -- Jacques R. Kilchoer (949) 754-8816 Quest Software, Inc. 8001 Irvine Center Drive Irvine, California 92618 U.S.A. http://www.quest.com