RE: ORACLE 8i DBA
Title: RE: ORACLE 8i DBA hi Thanks alot I will Pick that Book today. Have a nice day with warm regards, deewaker g v -Original Message- From: Brijesh Lal [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 29, 2001 11:47 PM To: Multiple recipients of list ORACLE-L Subject: Re: ORACLE 8i DBA Hi Go for Oracle Certified professional DBA certification Exam guide By Jason S couchman Ulrike Schwinn This is one of the best for for ocp exams it contains lot of practice exams and is desinged for OCP only Other than this for crampsession u can go to brainbuzz.com site here u can find cramps neaded for OCP preparation and above all refer Oracle manuals they are the best for exam preparation Good luck Brijesh --- Deewaker G.V. [EMAIL PROTECTED] wrote: hi I am planning to take ORACLE 8i DBA Examination, Can you guys please guide w.r.t 1) Good Book to Refer 2) Steps to Prepare for all the 5 Papers 3) Cramsessions 4) Free downloadable Power Point Presentations If you feel some more which i need to gear up with. Kindly advice me with warm regards, Deewaker G V __ 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: Brijesh Lal INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE:
Thanks for your reply about the Reports parameter Reg G.SEnthil kumar -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Senthil Ganapathi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Script and control file
Hi, Within your *.sql script you can jump to the OS and give OS commands. e.g: host sqlldr. (start with host). I have used it with import and it works. Jack Quaglio Andrea Andrea.Quaglio@sem To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] agroup.itcc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Sent by: Subject: Script and control file [EMAIL PROTECTED] 29-05-2001 17:15 Please respond to ORACLE-L First of all, I'm a beginner to SQL/SQL Loader. Currently,I'm working with Oracle 8. I would like to know if it's possible invoke SQL Loader inside a script. Example: - inside the script I want to create a new table TABLE1 - copy some data inside TABLE1 using SQL loader - work on TABLE1 using SQL language. Is it possible do this inside a .sql file ? Thanks, Andrea -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Quaglio Andrea INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst Young. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. In carrying out its engagements, Ernst Young applies general terms and conditions, which contain a clause that limits its liability. A copy of these terms and conditions is available on request free of charge. = -- Please see
Re: Table size
select * from user_segments is a good start.. hth connor --- Viraj Luthra [EMAIL PROTECTED] wrote: Hello all, How do I come to what tables are present in a particular tablespace and then when I found the table, can I come to know what amount of space it consumes? eg. I want to know what tablespace does the table emp (user is scott) belong to and the space it consumes (eg 5M)? Please help. Thanks and Regards, raja Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viraj Luthra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
How to drop unique index
Hi Gurus, I tried to drop unique index using ALTER TABLE table_name DROP UNIQUE (column_name); unsuccessfully. How should I drop the unique index ? Please advise. Thanks. SQL SELECT * FROM USER_IND_COLUMNS WHERE TABLE_NAME='SPY_ADHOC_PAYMENT'; INDEX_NAME TABLE_NAME COLUMN_NAME -- -- -- U_SPYADH_2 SPY_ADHOC_PAYMENT STDNAME SQL SELECT INDEX_NAME,TABLE_OWNER,TABLE_NAME,UNIQUENESS FROM USER_INDEXES WHERE TABLE_NAME='SPY_ADHOC_PAYMENT'; INDEX_NAME TABLE_OWNERTABLE_NAME UNIQUENES -- -- U_SPYADH_2 SPYSPY_ADHOC_PAYMENT UNIQUE SQL ALTER TABLE SPY.SPY_ADHOC_PAYMENT DROP UNIQUE (STDNAME); ALTER TABLE SPY.SPY_ADHOC_PAYMENT DROP UNIQUE (STDNAME) * ERROR at line 1: ORA-02442: Cannot drop nonexistent unique key SQL ALTER TABLE SPY.SPY_ADHOC_PAYMENT DROP CONSTRAINT U_SPYADH_2; ALTER TABLE SPY.SPY_ADHOC_PAYMENT DROP CONSTRAINT U_SPYADH_2 * ERROR at line 1: ORA-02443: Cannot drop constraint - nonexistent constraint Regds, New Bee -Original Message- From: Manivannan.M [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 30, 2001 2:20 PM To: Multiple recipients of list ORACLE-L Subject:RE: catrep.sql Hi It will be there under $ORACLE_HOME/rdbms/admin regards, Manivannan.M -- On Tue, 29 May 2001, Timajo, Joel - Equicom wrote: hello oracle gurus! i just tried a default installation of oracle 8.0.6 to our hp-unix machine. i followed step by step the procedures as stated in the oracle installation guide. my problem is when it comes to the step (pp 4-2 of the installation guide) that says run the catrep.sql. where can i find this sql script? thanks! oracle newbie -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Manivannan.M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Is the ability to do field-level encryption free in Enterprise Edition?
From a money perspective - yes From a resource perspective - no, using the obfuscation toolkit does add lots of cpu to your processing (if you're handling lots of rows) hth connor --- [EMAIL PROTECTED] wrote: We are in the process of upgrading most of our databases to 8.1.7.1 (Enterprise Edition) on Sun Solaris 2.6. We need to be able to do field-level encryption of some of our data. I think that we should be able to do so with DBMS_OBFUSCATION. Is DBMS_OBFUSCATION free with 8.1.7.1 Enterprise Edition? Are there other standard methods/tools that we can use within Oracle to do this field-level encryption? If yes, are they free or part of an add-on bundle? If add-on, which add-on? I've been trying to research this on Technet but having difficulty correlating functionality with cost. My boss wants the answer today so I thought I'd throw it out to the crowd. Thanks in advance, 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). = 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).
io size of Unix machine
How can I find the logical or physical I/O size on a Sun Solaris machine ? Thanks, ~aslam application/ms-tnef
Testing tools
Hello if there any testing tools for QA staff / developer to test on bulk data which can measure it performance,efficient.of the program/PLSQL/sqlscript ??? The function of the tools is , prepare bulk data , testing , generate report . If no such tools , what might be an advice ? Becoz we intend to setup up a ISO 9001 standard on testing environment and testing technique. Anyone go through this before ? or any white paper about this ? Raymond fall asleep in waiting for the Q. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raymond Lee Meng Hong INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Number Vs. Varchar2 Datatype
Title: Number Vs. Varchar2 Datatype Hi list, We are in the design phase of our new database and eventually there a number of feilds which are actually numeric say DEPARTMENT NUMBER or EMPLOYEE CODE (they dont contain any alphabat or special character) , The main decision to be made right now is to choose the right datatype, Options ofcourse are VARCHAR2 or NUMBER, i know its better to have varchar2 cuz its a bit flexible, but i want some expert opinion, can u tell me any pros and cons of having NUMBER or Varchar2 datatype on a feild which is numeric, which may be PRIMARY KEY and also which is NOT always used in Calculations, which datatype is more efficient Its Oracle 8.1.7 on NT4, TIA, Arslan
Performance tuning
HI ALL, We have to load almost 3 millions records of average row size of 150 bytes. We are importing data using sqloader with ROWS=4000 and bindsize=845 . We have adjusted the rollback segment to almost 10 m with 8 extents enough for single transaction size and considering 30% rollback overhead. We adjusted the OPTIMAL TO 10 M to have avoid rollback extension Rollback segment, databuffer cache have hit ratio of 100%. The loading was fast only for first 10 commits but then it slowed like snail. LOADING TOOK 22 hours in the first run on ORACLE8i NT4 128 megs RAM . SGA figures in M : NAME VALUE - Fixed Size.0676384 Variable Size239.02734 Database Buffers 39.0625 Redo Buffers 7.8203125 - sum 285.97779 ( we can't use direct path due to functions in sqlldr controlfile). . Couldn't figure out the bottleneck yet. Any ideas. TIA Azhar Siddiq, DBA LMK Resources -- 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: Number Vs. Varchar2 Datatype
Title: Number Vs. Varchar2 Datatype this always a better decision to decide the datatypes of such columns keeping in mind the future requirements. u may come to a certain point where u think, number datatype to be better and somewhere to varchar2. u said number datatype which is not always used for calculation. actually a number datatype takes less space on disk(actual storage space) as u define it. and as compared to varchar2 if difference is of concern. it's a matter of requirement of application. - Original Message - From: Arslan Dar To: Multiple recipients of list ORACLE-L Sent: Wednesday, May 30, 2001 2:35 PM Subject: Number Vs. Varchar2 Datatype Hi list, We are in the design phase of our new database and eventually there a number of feilds which are actually numeric say DEPARTMENT NUMBER or EMPLOYEE CODE (they dont contain any alphabat or special character) , The main decision to be made right now is to choose the right datatype, Options ofcourse are VARCHAR2 or NUMBER, i know its better to have varchar2 cuz its a bit flexible, but i want some expert opinion, can u tell me any pros and cons of having NUMBER or Varchar2 datatype on a feild which is numeric, which may be PRIMARY KEY and also which is NOT always used in Calculations, which datatype is more efficient Its Oracle 8.1.7 on NT4, TIA, Arslan
Re: How to drop unique index
Suggestion given by Magesh should work for a non-constraint index. If it is index created by Oracle during the time when you created your unique constraint you won't be able to get rid of that index until you eliminate your constraint. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, May 30, 2001 3:31 AM Try out this Drop index U_SPYADH_2 ; Regards Magesh - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, May 30, 2001 5:50 PM Hi Gurus, I tried to drop unique index using ALTER TABLE table_name DROP UNIQUE (column_name); unsuccessfully. How should I drop the unique index ? Please advise. Thanks. SQL SELECT * FROM USER_IND_COLUMNS WHERE TABLE_NAME='SPY_ADHOC_PAYMENT'; INDEX_NAME TABLE_NAME COLUMN_NAME -- -- -- U_SPYADH_2 SPY_ADHOC_PAYMENT STDNAME SQL SELECT INDEX_NAME,TABLE_OWNER,TABLE_NAME,UNIQUENESS FROM USER_INDEXES WHERE TABLE_NAME='SPY_ADHOC_PAYMENT'; INDEX_NAME TABLE_OWNERTABLE_NAME UNIQUENES -- -- U_SPYADH_2 SPY SPY_ADHOC_PAYMENT UNIQUE SQL ALTER TABLE SPY.SPY_ADHOC_PAYMENT DROP UNIQUE (STDNAME); ALTER TABLE SPY.SPY_ADHOC_PAYMENT DROP UNIQUE (STDNAME) * ERROR at line 1: ORA-02442: Cannot drop nonexistent unique key SQL ALTER TABLE SPY.SPY_ADHOC_PAYMENT DROP CONSTRAINT U_SPYADH_2; ALTER TABLE SPY.SPY_ADHOC_PAYMENT DROP CONSTRAINT U_SPYADH_2 * ERROR at line 1: ORA-02443: Cannot drop constraint - nonexistent constraint Regds, New Bee -Original Message- From: Manivannan.M [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 30, 2001 2:20 PM To: Multiple recipients of list ORACLE-L Subject: RE: catrep.sql Hi It will be there under $ORACLE_HOME/rdbms/admin regards, Manivannan.M -- -- -- On Tue, 29 May 2001, Timajo, Joel - Equicom wrote: hello oracle gurus! i just tried a default installation of oracle 8.0.6 to our hp-unix machine. i followed step by step the procedures as stated in the oracle installation guide. my problem is when it comes to the step (pp 4-2 of the installation guide) that says run the catrep.sql. where can i find this sql script? thanks! oracle newbie -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Manivannan.M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: magesh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: lyudah INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public
RE:
That's a laugh, I went to a continuing education seminar once at Carleton University, in Ottawa. The seminar was called Effective Living. The teacher was a social worker, and he emphatically told everyone NEVER to ask why, just adapt to life and keep moving... I had unreconcilable disagreements with him, I guess I don't know how to live. : ) Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- From: Don Granaman [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, May 29, 2001 4:11 PM To: Multiple recipients of list ORACLE-L Subject:Re: when? But, more important, WHY??? -Don Granaman [certifiable OraSaurus] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, May 29, 2001 1:28 PM And Where. Terry Boivin, Patrice J wrote: When and how Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- From: Kevin Kostyszyn [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, May 29, 2001 1:41 PM To: Multiple recipients of list ORACLE-L Subject:RE: what -Original Message- Andrea Sent: Tuesday, May 29, 2001 11:47 AM To: Multiple recipients of list ORACLE-L who -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Quaglio Andrea INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Kevin Kostyszyn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Terry Ball INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed
Re: How to drop unique index
Hi, Did you try : SQL drop index index_name ; ?? HIH, Antonio Belloni CHAN Chor Ling Catherine (CSC) [EMAIL PROTECTED]@fatcity.com on 30/05/2001 05:50:25 Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Hi Gurus, I tried to drop unique index using ALTER TABLE table_name DROP UNIQUE (column_name); unsuccessfully. How should I drop the unique index ? Please advise. Thanks. SQL SELECT * FROM USER_IND_COLUMNS WHERE TABLE_NAME='SPY_ADHOC_PAYMENT'; INDEX_NAME TABLE_NAME COLUMN_NAME -- -- -- U_SPYADH_2 SPY_ADHOC_PAYMENT STDNAME SQL SELECT INDEX_NAME,TABLE_OWNER,TABLE_NAME,UNIQUENESS FROM USER_INDEXES WHERE TABLE_NAME='SPY_ADHOC_PAYMENT'; INDEX_NAME TABLE_OWNERTABLE_NAME UNIQUENES -- -- U_SPYADH_2 SPYSPY_ADHOC_PAYMENT UNIQUE SQL ALTER TABLE SPY.SPY_ADHOC_PAYMENT DROP UNIQUE (STDNAME); ALTER TABLE SPY.SPY_ADHOC_PAYMENT DROP UNIQUE (STDNAME) * ERROR at line 1: ORA-02442: Cannot drop nonexistent unique key SQL ALTER TABLE SPY.SPY_ADHOC_PAYMENT DROP CONSTRAINT U_SPYADH_2; ALTER TABLE SPY.SPY_ADHOC_PAYMENT DROP CONSTRAINT U_SPYADH_2 * ERROR at line 1: ORA-02443: Cannot drop constraint - nonexistent constraint Regds, New Bee -Original Message- From: Manivannan.M [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 30, 2001 2:20 PM To: Multiple recipients of list ORACLE-L Subject: RE: catrep.sql Hi It will be there under $ORACLE_HOME/rdbms/admin regards, Manivannan.M -- On Tue, 29 May 2001, Timajo, Joel - Equicom wrote: hello oracle gurus! i just tried a default installation of oracle 8.0.6 to our hp-unix machine. i followed step by step the procedures as stated in the oracle installation guide. my problem is when it comes to the step (pp 4-2 of the installation guide) that says run the catrep.sql. where can i find this sql script? thanks! oracle newbie -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Manivannan.M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Script examples for NT. (yuk!)
Quick question.. ALL of my experience has been on UNIX platforms... Recently, I have been asked to work on an Oracle DB that runs on NT.. My scripting capability in the NT world is weak at best. So I am trying to compare ksh type activities with the NT world. SO I was wondering if any of you would mind sharing a couple of NT type scripts with me.. For example-setting variables to the return of a SQL statement to be used in the shell,etc... Any help would be appreciated.. TIA Greg Loughmiller mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Loughmiller, Greg INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Error while executing stored procedure as system user
When you use privileges in stored procedures, you need to have the privilege explicitly. In other words, you cannot get the privilege from a role. If you do a grant create user to MyRole. Grant myRole to myUser. Then try to create user as myUser it will work, but if you try to create user from a procedure as myUser it will fail. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Tuesday, May 29, 2001 6:50 AM To: Multiple recipients of list ORACLE-L Dear DBA Gurus, I am able to execute the below code as an anonymous Pl/Sql block but when I incorporate it in a stored procedure the procedure gets created but I am getting the below errors while executing the procedure as system user: Anonymous Pl/Sql block Declare name varchar2(4):='test'; BEGIN EXECUTE IMMEDIATE 'create user ' ||name||' '||'identified by '||name||' '|| 'default tablespace users temporary tablespace temp'; EXECUTE IMMEDIATE 'grant connect, resource to ' ||name; EXECUTE IMMEDIATE 'create table '||name||'.aaa(a number)'; EXECUTE IMMEDIATE 'create table '||name||'.bbb(b number)'; END; Stored Procedure create or replace procedure create_user (name IN VARCHAR2) IS BEGIN EXECUTE IMMEDIATE 'create user ' ||name||' '||'identified by '||name||' '|| 'default tablespace users temporary tablespace temp'; EXECUTE IMMEDIATE 'grant connect, resource to ' ||name; EXECUTE IMMEDIATE 'create table '||name||'.aaa(a number)'; EXECUTE IMMEDIATE 'create table '||name||'.bbb(b number)'; END; / Procedure Created. Errors while executing the procedure exec create_user('test'); ERROR at line 1: ORA-01031: insufficient privileges ORA-06512: at SYSTEM.CREATE_USER, line 4 ORA-06512: at line 1 What might be the reason for the errors? Can anyone help me? TIA and 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: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: backspace in Oracle.
I have built Novell boxes that have 2100+ days of uptime :) Now that is stability that I have yet to see even unix have. Granted it is only Novell 3.12. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Sunday, May 27, 2001 8:10 PM To: Multiple recipients of list ORACLE-L Jared, I have an NT 4 server up for 242 days. Someone where I work suggested it should be sent to Microsoft for an examination (must be something wrong with it). Regards, Bruce -Original Message- Sent: Saturday, 26 May 2001 12:16 To: Multiple recipients of list ORACLE-L On Friday 25 May 2001 18:26, Weaver, Walt wrote: Ditto. I support Jared's backspace claims 100%, and I don't think he should be removed from the list. I sure appreciate that Walt! I've heard there are other operating systems out there besides Linux and Solaris. Is this true? A nasty rumor. There's an upstart startup in WA that claims to have something akin to an OS, but it keeps failing the 30 day stability test. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Analyze table and locking
Yes, table is exclusively locked when ANALYZE ... VALIDATE. Until 9i, I believe. Vadim Gorbounov Oracle DBA -Original Message-From: Robertson Lee - lerobe [mailto:[EMAIL PROTECTED]]Sent: Wednesday, May 30, 2001 7:22 AMTo: Multiple recipients of list ORACLE-LSubject: Analyze table and locking All, Just a quicky !! Anyone know if there are any locking issues while analyzing statistics for objects ?? TIA Lee The information contained in this communication isconfidential, is intended only for the use of the recipientnamed above, and may be legally privileged. If the reader of this message is not the intended recipient, you arehereby notified that any dissemination, distribution orcopying 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 computersystem.
RE: backspace in Oracle.
There isn't any known bug under NT. But there are many memory leaks and poor drivers, that tend to lead to early rebooting. In my experience. I think the worst problem with NT is not the os but the drivers, even though Even though I hate NT, for the money, it works well. But if you try to get i to do too much, then you are asking for trouble. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Sunday, May 27, 2001 11:11 PM To: Multiple recipients of list ORACLE-L Yeah, funny isn't it? I had my Sparc Station 5 up for just a few days short of a year once. During that time I added/delete/built many different pieces of open source software and ran 2 oracle databases. It crashed due to a Solaris bug that hits sometime after 248 days of uptime. Who knows, maybe there's a bug like that on NT, but how will anyone ever find out? Jared On Sunday 27 May 2001 19:30, Peter McLarty wrote: Apparently this quirky behaviour comes from running one and one only application on a system. I have heard rumours of this occurring on other sites when the use a server for a single task. So any rumours you have heard about its capability as a multitasking OS and being able to pass the 30 day test now they would be interesting. Hell one of our Domain controller can't handle being a print server Peter -Original Message- Bruce (CALBBAY) Sent: Monday, 28 May 2001 10:10 AM To: Multiple recipients of list ORACLE-L Jared, I have an NT 4 server up for 242 days. Someone where I work suggested it should be sent to Microsoft for an examination (must be something wrong with it). Regards, Bruce -Original Message- Sent: Saturday, 26 May 2001 12:16 To: Multiple recipients of list ORACLE-L On Friday 25 May 2001 18:26, Weaver, Walt wrote: Ditto. I support Jared's backspace claims 100%, and I don't think he should be removed from the list. I sure appreciate that Walt! I've heard there are other operating systems out there besides Linux and Solaris. Is this true? A nasty rumor. There's an upstart startup in WA that claims to have something akin to an OS, but it keeps failing the 30 day stability test. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Problem with many (160 - 170) sessions in the database on
just my input. where are the load metrics documented, meaning where does it say 5M or more per session? i want to know for future reference. we're putting in a solution, oracle 8i on windows 2000/windows 2000 advanced server ~4-to-8G of RAM so there are options if you need additional RAM in excess of 4G. no true *nix expertise here and it's our fledgling implementation but based on specs we should be covered. say it's 10M a session, 500 users is about 5G with plenty left over for O/S, SGA, etc... === Lerone Streeter System Analyst Abbott LBG [EMAIL PROTECTED] === -Original Message- Sent: Wednesday, May 30, 2001 2:11 AM To: Multiple recipients of list ORACLE-L I agree with Goulet. In contrast to ur rather powerful machine my NT server handles abuot 200 connections on a single database with just 1 CPU and 512 MB RAM. Ofcourse preformance is pathetic - but what can one do with Windows anyways ?? I asked management to junk the machine and in a months time we will migrate to a brand new Sun Solaris Server !! The only way we survive with the NT machine is boot it once a week !! Regards -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, May 29, 2001 10:51 PM To: Multiple recipients of list ORACLE-L Subject:Re:Problem with many (160 - 170) sessions in the database on Jonas, Solution, dump Windows and get onto Linux or buy a real Unix machine. Your asking a toy to do a man/woman's job. Dick Goulet Reply Separator Author: Jonas A Wetterberg [EMAIL PROTECTED] Date: 5/29/2001 8:50 AM Hello We are running into a little problem with an Oracle installation. The server OS is Windows NT, SP6, and the version of Oracle is 7.3.4.5.0. The server have 4 processes, we have about 1,7 G primary memory and about 2 G of memory on swap disk. We have 4 processes in the machine. One of these is reserved for the OS, and Oracle uses the other 3. We we reach around 170 sessions in the database, the database sometimes goes down and we have to perform a restart. The 3 process Oracle use are all at about 100% in task manager. The memory use is somewhere around 1,3 G. Then we can run the database for aboout 4 more hours, then we have to restart. Sometimes we have to restart around lunch everyday. Now I have heard the Windows NT have a limit of how much memory one process might use, and that limit is somewhere around 1,7 G, and that that might be our problem. We are planing to upgrade to Oracle 8.1.7 and to Windows NT 4 Enterprise Edition or to Windows 2000 Advanced Server. Does anyone know if this can help? Should we put more memory or more processes in the machine? Any help is appreacheated Regards /Jonas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonas A Wetterberg INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Streeter, Lerone A LBX INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Analyze table and locking
Hi Lee, Compute option locks a table, but 'estimate' doesn't Regards, Ed -Original Message- Sent: 30 ??? 2001 ?. 15:22 To: Multiple recipients of list ORACLE-L All, Just a quicky !! Anyone know if there are any locking issues while analyzing statistics for objects ?? TIA Lee 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: Shevtsov, Eduard INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Analyze table and locking
Ok, now I'm confused One reply - It depends. For instance, 'analyze index validate structure' takes out 'shared' lock on the table (preventing inserts/deletes/updates), while 'analyze index compute/estimate statistics' does not. Another --- Compute option locks a table, but 'estimate' doesn't Anyone have a definitive answer. PS. Thanks to the guys who have replied up to now. Lee 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: 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).
Re: How to drop unique index
If it is an unique index that enforces unique constraint you cannot simply drop it You have to drop unique constraint alter table tablename drop constraint constraintname; an example follows SQL desc qaqa1 NameNull?Type --- COL1 NUMBER(5) COL2 VARCHAR2(4000) SQL select * from user_constraints where table_name = 'QAQA1'; no rows selected SQL select * from user_indexes where table_name = 'QAQA1'; no rows selected SQL alter table qaqa1 add constraint zzz unique (col1); Table altered. SQL select * from user_constraints where table_name = 'QAQA1'; OWNER CONSTRAINT_NAMEC TABLE_NAME -- -- - --- MANTAOWNER ZZZU QAQA1 SQL select * from user_indexes where table_name = 'QAQA1'; INDEX_NAME INDEX_TYPE TABLE_OWNER -- --- ZZZNORMAL MANTAOWNER SQL drop index zzz; drop index zzz * ERROR at line 1: ORA-02429: cannot drop index used for enforcement of unique/primary key SQL alter table qaqa1 drop constraint zzz; Table altered. SQL select * from user_constraints where table_name = 'QAQA1'; no rows selected SQL select * from user_indexes where table_name = 'QAQA1'; no rows selected Gints Plivna -- 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: Analyze table and locking
I think thats the reason why we have two options - Estimate and Compute Statistics. Rajaram. -Original Message- From: Robertson Lee - lerobe [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, May 30, 2001 7:22 AM To: Multiple recipients of list ORACLE-L Subject:Analyze table and locking All, Just a quicky !! Anyone know if there are any locking issues while analyzing statistics for objects ?? TIA Lee NetZero Platinum No Banner Ads and Unlimited Access Sign Up Today - Only $9.95 per month! http://www.netzero.net -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajaram INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Installing Apache on Sun
shouldn't be any problems running apache on the same server. at least i've set up oracle on solaris 7 with apache installed. Jon Baker Database Engineer (1/5) [EMAIL PROTECTED] Rukmini Devi wrote: Hi List, SunOS5.7 Oracle 7.3.4 Oracle Apps.10.7 Listeners running 2 we are planning to install Apache on Sun server for web application. Oracle database is running on the same server. If we install Apache on the same server , Is there any problem to Oracle ? Can any one explain what are the prerequisites we have to take ? -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Baker INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE:
This person was actually allowed to teach. Never ask why, yes that's a super philosophy on life. -Original Message- Patrice J Sent: Wednesday, May 30, 2001 8:31 AM To: Multiple recipients of list ORACLE-L That's a laugh, I went to a continuing education seminar once at Carleton University, in Ottawa. The seminar was called Effective Living. The teacher was a social worker, and he emphatically told everyone NEVER to ask why, just adapt to life and keep moving... I had unreconcilable disagreements with him, I guess I don't know how to live. : ) Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- From: Don Granaman [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, May 29, 2001 4:11 PM To: Multiple recipients of list ORACLE-L Subject:Re: when? But, more important, WHY??? -Don Granaman [certifiable OraSaurus] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, May 29, 2001 1:28 PM And Where. Terry Boivin, Patrice J wrote: When and how Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- From: Kevin Kostyszyn [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, May 29, 2001 1:41 PM To: Multiple recipients of list ORACLE-L Subject:RE: what -Original Message- Andrea Sent: Tuesday, May 29, 2001 11:47 AM To: Multiple recipients of list ORACLE-L who -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Quaglio Andrea INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Kevin Kostyszyn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Terry Ball INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message
Re: Performance tuning
Azhar, I agree with the other responses (more RAM, don't use OPTIMAL on your RBS's) but would also suggestdropping all indexes except PK until the load is done, therebuild them. Also, does this table have any triggers? If so, if can you disable them during the load, that will help speed up the load. For help in setting the ROWS and BINDSIZE parameters, there is an article of mine that O'Reilly published on their web site (http://oracle.oreilly.com/news/oraclesqlload_0401.html) which details my experience which resulted in some big performance gains. HTH, Stephen [EMAIL PROTECTED] 05/30/01 02:19AM HI ALL,We have to load almost 3 millions records of average row size of 150 bytes.We are importing data using sqloader with ROWS=4000 and bindsize=845 .We have adjusted the rollback segment to almost 10 m with 8 extents enoughfor single transaction size and considering 30% rollback overhead. Weadjusted the OPTIMAL TO 10 M to have avoid rollback extensionRollback segment, databuffer cache have hit ratio of 100%.The loading was fast only for first 10 commits but then it slowed likesnail. LOADING TOOK 22 hours in the first run on ORACLE8i NT4 128 megs RAM.SGA figures in M :NAME VALUE -Fixed Size .0676384Variable Size 239.02734Database Buffers 39.0625Redo Buffers 7.8203125 -sum 285.97779( we can't use direct path due to functions in sqlldr controlfile). .Couldn't figure out the bottleneck yet.Any ideas.TIAAzhar Siddiq,DBALMK Resources-- 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-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: Performance tuning
I would not recommend using optimal as it will cause the segment to have to shrink. Your better of doing it manually on lulls of activity and size the segments bigger if need be. Segments should not be frequently shrinking. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Wednesday, May 30, 2001 5:19 AM To: Multiple recipients of list ORACLE-L HI ALL, We have to load almost 3 millions records of average row size of 150 bytes. We are importing data using sqloader with ROWS=4000 and bindsize=845 . We have adjusted the rollback segment to almost 10 m with 8 extents enough for single transaction size and considering 30% rollback overhead. We adjusted the OPTIMAL TO 10 M to have avoid rollback extension Rollback segment, databuffer cache have hit ratio of 100%. The loading was fast only for first 10 commits but then it slowed like snail. LOADING TOOK 22 hours in the first run on ORACLE8i NT4 128 megs RAM . SGA figures in M : NAME VALUE - Fixed Size.0676384 Variable Size239.02734 Database Buffers 39.0625 Redo Buffers 7.8203125 - sum 285.97779 ( we can't use direct path due to functions in sqlldr controlfile). . Couldn't figure out the bottleneck yet. Any ideas. TIA Azhar Siddiq, DBA LMK Resources -- 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: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Analyze table and locking
It depends. For instance, 'analyze index validate structure' takes out 'shared' lock on the table (preventing inserts/deletes/updates), while 'analyze index compute/estimate statistics' does not. For more info see 'Practical Oracle 8i' by Jonathan Lewis - very good book. Igor Neyman, OCP DBAPerceptron, Inc.(734)414-4627[EMAIL PROTECTED] - Original Message - From: Robertson Lee - lerobe To: Multiple recipients of list ORACLE-L Sent: Wednesday, May 30, 2001 7:21 AM Subject: Analyze table and locking All, Just a quicky !! Anyone know if there are any locking issues while analyzing statistics for objects ?? TIA Lee The information contained in this communication isconfidential, is intended only for the use of the recipientnamed above, and may be legally privileged. If the reader of this message is not the intended recipient, you arehereby notified that any dissemination, distribution orcopying 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 computersystem.
RE: Creating a sorted table
This is totally NOT accurate. Yes there are performance gains storing index data ordered. Perhaps great on range scans. Yes you can reorder tables and indexes. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Friday, May 25, 2001 7:41 PM To: Multiple recipients of list ORACLE-L Whyever would you want data inserted in order? There is no guarantee that Oracle will actually store the records in order, there is no performance gain, and you can always retrieve the records in order by using an order by statement -- if you really need ordered data, you could use a index-organized table with all of your columns, with the date as the first column. But methinks this would be dangerous for a heavy transaction table. (Gurus, please correct me if I'm wrong here) However, if you are still keen, you could do this through a PL/SQL block, something like the following: declare cursor get_data is select col1, col2, col3, ... from unordered_table order by whatever; begin for dataRec in get_data loop insert into ordered_table (col1, col2, col3, ...) values (dataRec.col1, dataRec.col2, dataRec.col3, ...) end loop; end; / Cheers! Diana Browett, Darren [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] lam.bc.ca cc: Sent by: Fax to: [EMAIL PROTECTED] Subject: Creating a sorted table 05/25/2001 06:45 PM Please respond to ORACLE-L We have un-ordered data in a table that needs to be inserted into a transaction table in order of the date that the transaction took place. Oracle does not allow INSERT . AS SELECT . ORDER BY. or CREATE TMP_TABLE . AS SELECT . ORDER BY.. Is there a method by which I can accomplish this. Thank you in advance Darren Browett Sys Admin City of Coquitlam -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Browett, Darren INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Creating a sorted table
Title: RE: Creating a sorted table That is version specific, but you can use an index hint to do this in older versions. "Walking on water and developing software from a specification are easy if both are frozen." Christopher R. Spence Oracle DBA Fuelspot -Original Message-From: Vijay_Krishna [mailto:[EMAIL PROTECTED]]Sent: Tuesday, May 29, 2001 7:00 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Creating a sorted table Hi infact creating the table as sorted data from another table works with oracle 8.1.6.3.0 as: create table agrs as select * from agreements order by agr_agreement_number desc; Is this OK?? Vijay -- From: Connor McDonald[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Monday, May 28, 2001 4:05 PM To: Multiple recipients of list ORACLE-L Subject: Re: Creating a sorted table There is a very good reason for having data "approximately" in physical order - it can dramatically improve your buffer hit rates. IOT's are great for this, but if you're on an earlier version then the occasional job to "pseudo-cluster" the data can be a very good thing... Cheers Connor --- [EMAIL PROTECTED] wrote: Whyever would you want data inserted in order? There is no guarantee that Oracle will actually store the records "in order", there is no performance gain, and you can always retrieve the records in order by using an order by statement -- if you really need ordered data, you could use a index-organized table with all of your columns, with the date as the first column. But methinks this would be dangerous for a heavy transaction table. (Gurus, please correct me if I'm wrong here) However, if you are still keen, you could do this through a PL/SQL block, something like the following: declare cursor get_data is select col1, col2, col3, ... from unordered_table order by whatever; begin for dataRec in get_data loop insert into ordered_table (col1, col2, col3, ...) values (dataRec.col1, dataRec.col2, dataRec.col3, ...) end loop; end; / Cheers! Diana "Browett, Darren" [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] lam.bc.ca cc: Sent by: Fax to: [EMAIL PROTECTED] Subject: Creating a sorted table 05/25/2001 06:45 PM Please respond to ORACLE-L We have un-ordered data in a table that needs to be inserted into a transaction table in order of the date that the transaction took place. Oracle does not allow "INSERT . AS SELECT . ORDER BY." or "CREATE TMP_TABLE . AS SELECT . ORDER BY.." Is there a method by which I can accomplish this. Thank you in advance Darren Browett Sys Admin City of Coquitlam -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Browett, Darren INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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). = 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"
RE: backspace in Oracle.
Uptime yes... BUT was there anything running on them as complex as a database? Just joking. I have used Novell in the past ver 2.something and it served the purpose very well. At my current work location we use 4.12 and it is okay at best. Upgrading to 5.1 this year before we install a financial package that won't run on Novell with an Oracle database.(Novell and Oracle fell out of bed). 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).
Re: How to drop unique index
that's not dropping a unique index, that's dropping a column! to drop an index: drop index indexname; doesn't matter if it is unique or not. If you are trying to drop a unique constraint, that's different. first find the name of the unique constraint on that table select constraint_name from user_constraints where constraint_type='U'; will give you all the unique constraints on that table. If there is more than one unique constraint, check in user_cons_columns to match the column to the constraint. Then you can alter table tablename drop constraint constraintname; Rachel From: CHAN Chor Ling Catherine (CSC) [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: How to drop unique index Date: Wed, 30 May 2001 00:50:25 -0800 Hi Gurus, I tried to drop unique index using ALTER TABLE table_name DROP UNIQUE (column_name); unsuccessfully. How should I drop the unique index ? Please advise. Thanks. SQL SELECT * FROM USER_IND_COLUMNS WHERE TABLE_NAME='SPY_ADHOC_PAYMENT'; INDEX_NAME TABLE_NAME COLUMN_NAME -- -- -- U_SPYADH_2 SPY_ADHOC_PAYMENT STDNAME SQL SELECT INDEX_NAME,TABLE_OWNER,TABLE_NAME,UNIQUENESS FROM USER_INDEXES WHERE TABLE_NAME='SPY_ADHOC_PAYMENT'; INDEX_NAME TABLE_OWNERTABLE_NAME UNIQUENES -- -- U_SPYADH_2 SPYSPY_ADHOC_PAYMENT UNIQUE SQL ALTER TABLE SPY.SPY_ADHOC_PAYMENT DROP UNIQUE (STDNAME); ALTER TABLE SPY.SPY_ADHOC_PAYMENT DROP UNIQUE (STDNAME) * ERROR at line 1: ORA-02442: Cannot drop nonexistent unique key SQL ALTER TABLE SPY.SPY_ADHOC_PAYMENT DROP CONSTRAINT U_SPYADH_2; ALTER TABLE SPY.SPY_ADHOC_PAYMENT DROP CONSTRAINT U_SPYADH_2 * ERROR at line 1: ORA-02443: Cannot drop constraint - nonexistent constraint Regds, New Bee -Original Message- From: Manivannan.M [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 30, 2001 2:20 PM To: Multiple recipients of list ORACLE-L Subject:RE: catrep.sql Hi It will be there under $ORACLE_HOME/rdbms/admin regards, Manivannan.M -- On Tue, 29 May 2001, Timajo, Joel - Equicom wrote: hello oracle gurus! i just tried a default installation of oracle 8.0.6 to our hp-unix machine. i followed step by step the procedures as stated in the oracle installation guide. my problem is when it comes to the step (pp 4-2 of the installation guide) that says run the catrep.sql. where can i find this sql script? thanks! oracle newbie -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Manivannan.M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ 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
Re: backspace in Oracle.
On Wed, May 30, 2001 at 05:01:22AM -0800, Christopher Spence wrote: I have built Novell boxes that have 2100+ days of uptime :) Now that is stability that I have yet to see even unix have. Granted it is only Novell 3.12. Novell uptime: http://www.theregister.co.uk/content/5/18265.html === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Analyze table and locking
Analyze index validate structure takes shared lock on the table disallowing any changes to the table or indexes. That's the only way to validate the structures. In earlier versions (7.3 ?) 'analyze ..compute' used to take table level locks. From 8 onwards, compute or estimate does not take any table level or row level locks at all... Thanks Riyaj Re-yas Shamsudeen Certified Oracle DBA i2 technologies www.i2.com Robertson Lee - lerobe [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/30/01 10:25 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Analyze table and locking Ok, now I'm confused One reply - It depends. For instance, 'analyze index validate structure' takes out 'shared' lock on the table (preventing inserts/deletes/updates), while 'analyze index compute/estimate statistics' does not. Another --- Compute option locks a table, but 'estimate' doesn't Anyone have a definitive answer. PS. Thanks to the guys who have replied up to now. Lee 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: 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).
Re: Performance tuning
Peter is right. Look at your SGA it's 285M. If you only have 128M on the machine you are running your at least 75% of your db in swap. I would recommend 512M MINIMUM on this system push for more if you can. RAM is relatively cheap right now for intel machines get some. After that you need to get some other system stats (i/o, cpu, waits, locks) and configuration data (SMP?, RAID??). Rodd Holman Original Message On 5/30/01, 6:21:45 AM, Peter McLarty [EMAIL PROTECTED] wrote regarding Re: Performance tuning : Okay fill us in why would you try and inane thing like that on only 128MB RAM. NT would be barely running on that without getting your instance up. I am not that good yet at calculating what amount of RAM you need for a given SGA but I am thinking that you are running in swap What is the disk configuration. Are you running RAID and if so what configuration. (Not RAID 5 I hope) Can you get this system up to 512MB at least. With this and a whole lot more you will get some better answers Peter Trainee Oracle DBA At 01:19 AM 30/05/2001 -0800, you wrote: HI ALL, We have to load almost 3 millions records of average row size of 150 bytes. We are importing data using sqloader with ROWS=4000 and bindsize=845 . We have adjusted the rollback segment to almost 10 m with 8 extents enough for single transaction size and considering 30% rollback overhead. We adjusted the OPTIMAL TO 10 M to have avoid rollback extension Rollback segment, databuffer cache have hit ratio of 100%. The loading was fast only for first 10 commits but then it slowed like snail. LOADING TOOK 22 hours in the first run on ORACLE8i NT4 128 megs RAM . SGA figures in M : NAME VALUE - Fixed Size.0676384 Variable Size239.02734 Database Buffers 39.0625 Redo Buffers 7.8203125 - sum 285.97779 ( we can't use direct path due to functions in sqlldr controlfile). . Couldn't figure out the bottleneck yet. Any ideas. TIA Azhar Siddiq, DBA LMK Resources -- 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: Peter McLarty INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Rodd Holman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Performance tuning
Azhar, Just two thoughts off the top of my head to improve loading of records: 1. Put database in noarchivelog mode to avoid redo generation (if possible). 2. Drop all indexes on target tables (if possible), then load data, then recreate all indexes on target tables. Jim Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) HI ALL, We have to load almost 3 millions records of average row size of 150 bytes. We are importing data using sqloader with ROWS=4000 and bindsize=845 . We have adjusted the rollback segment to almost 10 m with 8 extents enough for single transaction size and considering 30% rollback overhead. We adjusted the OPTIMAL TO 10 M to have avoid rollback extension Rollback segment, databuffer cache have hit ratio of 100%. The loading was fast only for first 10 commits but then it slowed like snail. LOADING TOOK 22 hours in the first run on ORACLE8i NT4 128 megs RAM . SGA figures in M : NAME VALUE - Fixed Size.0676384 Variable Size239.02734 Database Buffers 39.0625 Redo Buffers 7.8203125 - sum 285.97779 ( we can't use direct path due to functions in sqlldr controlfile). . Couldn't figure out the bottleneck yet. Any ideas. TIA Azhar Siddiq, DBA LMK Resources -- 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). -- Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT: random equipment seen ???/ RE: V$SESSION.OSUSER returns
If you every try and knock a cat off of something when she really does not want to go you will see that quite clearly. It really is quite amazing (and annoying). -Original Message- Sent: Tuesday, May 29, 2001 7:12 PM To: Multiple recipients of list ORACLE-L NT-Domain\NT-User ? Eric, duct tape not needed... they seem to adhere all on their own. One of the magical properties of cats. Rachel From: Eric D. Pierce [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: OT: random equipment seen ???/ RE: V$SESSION.OSUSER returns NT-Domain\NT-User ? Date: Tue, 29 May 2001 13:44:48 -0800 Christopher, trivial question, at: http://www.vampired.net/images/comproom.jpg what the heck is the object on top of the box on the left? looks like either a dental cleaning instrument, or a very small fishing pole like device. do you ever find it necessary to use duct tape to keep cats from falling off the top of your monitors? thanks, ep On 29 May 2001, at 10:28, Christopher scribbled with alacrity and cogency: Date sent: Tue, 29 May 2001 10:28:26 -0800 To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] I am such an evil man. -- 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: 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).
Re: Analyze table and locking
Yeah If you use compute statistics your table get locked and will take long time, But If you use estimate statistics it will be fast But not as accurate as before. Better to analyze at nights by setting time. Raghu. From: Robertson Lee - lerobe [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Analyze table and locking Date: Wed, 30 May 2001 03:21:46 -0800 All, Just a quicky !! Anyone know if there are any locking issues while analyzing statistics for objects ?? TIA Lee 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. _ 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: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Database slowdown after 100 days uptime
Hi Bruce As I understand ur server uptime is 242 days.Right!If this is the case then Please reboot the server would solve this problem.The similar kind of problem I faced in past. Hope this will help u.If you would like to more information then please visit metalink. Thanks -Seema From: Raymond Lee Meng Hong [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Database slowdown after 100 days uptime Date: Tue, 29 May 2001 18:15:47 -0800 As far as my experience ,my site also got this problem , that is why every weekend we run a shutdown and restart the Unix box also in order to clean up some of the unwanted redo log and refresh the memory as well. it seen like our system become 6*24 instead of 7*24 , but in the business view is we open only until Saturday. but now we have branch open in shopping mall ,and they work in Sunday ? -Original Message- Sent: Tuesday, May 29, 2001 10:31 PM To: Multiple recipients of list ORACLE-L Keep an eye on free memory -- one of our similar systems has to be restarted every 60 days to prevent the behaviour you're encountering. We haven't determined the source of the memory leak, but if we permit it to continue eventually the DB stops responding and cannot be shut down. This system does some analytical work for us so it has different connection and activity profiles than the others, so I've a limited basis for comparison, but the other 8.1.5 databse (this one's data source) shows similar problems over a longer period. My plan is to take it up to 8.1.7 as those systems are not showing that sort of problem. Reardon, Bruce (CALBBAY) wrote: Hi, We're running Oracle 8.1.5.1.1 on NT 4. On Saturday our database started getting much slower - to me, there didn't seem to be any major events showing up in v$session_wait, v$session_event Restarting the database instance and service solved the performance problems. Today, when reviewing logs of the queries I noticed that the database had been up for 100 days when it started slowing. The 100 days uptime may be unrelated, but has anyone seen this behaviour on any platform? For information, the server itself has been up for 242 days (240 days when the problem started occurring). Thanks, Bruce Reardon mailto:[EMAIL PROTECTED] -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raymond Lee Meng Hong INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Performance tuning
Why putting DB in noarchivelog will avoid redo generation? There will be no archiving, but redo will continue to be generated. Alex Hillman -Original Message- Sent: Wednesday, May 30, 2001 10:21 AM To: Multiple recipients of list ORACLE-L Azhar, Just two thoughts off the top of my head to improve loading of records: 1. Put database in noarchivelog mode to avoid redo generation (if possible). 2. Drop all indexes on target tables (if possible), then load data, then recreate all indexes on target tables. Jim Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) HI ALL, We have to load almost 3 millions records of average row size of 150 bytes. We are importing data using sqloader with ROWS=4000 and bindsize=845 . We have adjusted the rollback segment to almost 10 m with 8 extents enough for single transaction size and considering 30% rollback overhead. We adjusted the OPTIMAL TO 10 M to have avoid rollback extension Rollback segment, databuffer cache have hit ratio of 100%. The loading was fast only for first 10 commits but then it slowed like snail. LOADING TOOK 22 hours in the first run on ORACLE8i NT4 128 megs RAM . SGA figures in M : NAME VALUE - Fixed Size.0676384 Variable Size239.02734 Database Buffers 39.0625 Redo Buffers 7.8203125 - sum 285.97779 ( we can't use direct path due to functions in sqlldr controlfile). . Couldn't figure out the bottleneck yet. Any ideas. TIA Azhar Siddiq, DBA LMK Resources -- 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). -- Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: backspace in Oracle.
Ya, but I can keep a NT box for a long time to, if I don't touch it. -Original Message- Sent: Wednesday, May 30, 2001 6:01 AM To: Multiple recipients of list ORACLE-L I have built Novell boxes that have 2100+ days of uptime :) Now that is stability that I have yet to see even unix have. Granted it is only Novell 3.12. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Sunday, May 27, 2001 8:10 PM To: Multiple recipients of list ORACLE-L Jared, I have an NT 4 server up for 242 days. Someone where I work suggested it should be sent to Microsoft for an examination (must be something wrong with it). Regards, Bruce -Original Message- Sent: Saturday, 26 May 2001 12:16 To: Multiple recipients of list ORACLE-L On Friday 25 May 2001 18:26, Weaver, Walt wrote: Ditto. I support Jared's backspace claims 100%, and I don't think he should be removed from the list. I sure appreciate that Walt! I've heard there are other operating systems out there besides Linux and Solaris. Is this true? A nasty rumor. There's an upstart startup in WA that claims to have something akin to an OS, but it keeps failing the 30 day stability test. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).
RE: Creating a sorted table
Diana, You might wanna check out www.kx.com Those guys have a lightning rocket of a dbms, and it is based, in part, on storing data in search/sort-dependent order. (There is a bunch of background data on the site itself.) In any case, reading up on other dbms technologies has a place in any DBAs self-education. Else, we're just sitting around quoting anecdotes to one another! Hope this helps, Cheers, Ross || -Original Message- || From: Christopher Spence [mailto:[EMAIL PROTECTED]] || Sent: Wednesday, May 30, 2001 12:10 PM || To: Multiple recipients of list ORACLE-L || Subject: RE: Creating a sorted table || || || This is totally NOT accurate. || || Yes there are performance gains storing index data ordered. || Perhaps great || on range scans. Yes you can reorder tables and indexes. || || Walking on water and developing software from a || specification are easy if || both are frozen. || || Christopher R. Spence || Oracle DBA || Fuelspot || || || || -Original Message- || Sent: Friday, May 25, 2001 7:41 PM || To: Multiple recipients of list ORACLE-L || || || || Whyever would you want data inserted in order? There is no || guarantee that || Oracle will actually store the records in order, there is || no performance || gain, and you can always retrieve the records in order by || using an order by || statement -- if you really need ordered data, you could use a || index-organized table with all of your columns, with the || date as the first || column. But methinks this would be dangerous for a heavy transaction || table. (Gurus, please correct me if I'm wrong here) || || However, if you are still keen, you could do this through a || PL/SQL block, || something like the following: || || declare || cursor get_data is || select col1, col2, col3, ... || from unordered_table || order by whatever; || begin || for dataRec in get_data loop || insert into ordered_table (col1, col2, col3, ...) || values (dataRec.col1, dataRec.col2, dataRec.col3, ...) || end loop; || end; || / || || Cheers! || || Diana || || || || || || Browett, Darren || || [EMAIL PROTECTED]To: || Multiple recipients || of list ORACLE-L [EMAIL PROTECTED] || lam.bc.ca cc: || || Sent by: Fax to: || || [EMAIL PROTECTED] Subject: || Creating a || sorted table || || || || || 05/25/2001 06:45 PM || || Please respond to || || ORACLE-L || || || || || || || || || || We have un-ordered data in a table that needs to be inserted into a || transaction table in || order of the date that the transaction took place. || || Oracle does not allow INSERT . AS SELECT . ORDER BY. || or CREATE TMP_TABLE . AS SELECT . ORDER BY.. || || Is there a method by which I can accomplish this. || || Thank you in advance || || Darren Browett || Sys Admin || City of Coquitlam || -- || Please see the official ORACLE-L FAQ: http://www.orafaq.com || -- || Author: Browett, Darren || INET: [EMAIL PROTECTED] || || Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 || San Diego, California-- Public Internet access / || Mailing Lists || || To REMOVE yourself from this mailing list, send an E-Mail message || to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in || the message BODY, include a line containing: UNSUB ORACLE-L || (or the name of mailing list you want to be removed from). You may || also send the HELP command for other information (like subscribing). || || || || || -- || Please see the official ORACLE-L FAQ: http://www.orafaq.com || -- || Author: || INET: [EMAIL PROTECTED] || || Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 || San Diego, California-- Public Internet access / || Mailing Lists || || To REMOVE yourself from this mailing list, send an E-Mail message || to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in || the message BODY, include a line containing: UNSUB ORACLE-L || (or the name of mailing list you want to be removed from). You may || also send the HELP command for other information (like subscribing). || -- || Please see the official ORACLE-L FAQ: http://www.orafaq.com || -- || Author: Christopher Spence || INET: [EMAIL PROTECTED] || || Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 || San Diego, California-- Public Internet access / || Mailing Lists || || To REMOVE yourself from this mailing
RE: backspace in Oracle.
Six years? No downtime in any way? That would be...uh.unusual. I am sure the details are fascinating...do tell. || -Original Message- || From: Christopher Spence [mailto:[EMAIL PROTECTED]] || Sent: Wednesday, May 30, 2001 9:01 AM || To: Multiple recipients of list ORACLE-L || Subject: RE: backspace in Oracle. || || || I have built Novell boxes that have 2100+ days of uptime :) || || Now that is stability that I have yet to see even unix have. || Granted it is only Novell 3.12. || || || Walking on water and developing software from a || specification are easy if || both are frozen. || || Christopher R. Spence || Oracle DBA || Fuelspot || || || || -Original Message- || [mailto:[EMAIL PROTECTED]] || Sent: Sunday, May 27, 2001 8:10 PM || To: Multiple recipients of list ORACLE-L || || || Jared, || || I have an NT 4 server up for 242 days. || || Someone where I work suggested it should be sent to Microsoft for an || examination (must be something wrong with it). || || Regards, || Bruce || || -Original Message- || Sent: Saturday, 26 May 2001 12:16 || To: Multiple recipients of list ORACLE-L || || || On Friday 25 May 2001 18:26, Weaver, Walt wrote: || Ditto. I support Jared's backspace claims 100%, and I || don't think he || should || be removed from the list. || || I sure appreciate that Walt! || || I've heard there are other operating systems out there || besides Linux and || Solaris. Is this true? || || A nasty rumor. There's an upstart startup in WA that claims to have || something akin to an OS, but it keeps failing the 30 day || stability test. || || Jared || || || -- || Please see the official ORACLE-L FAQ: http://www.orafaq.com || -- || Author: Jared Still || INET: [EMAIL PROTECTED] || || Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 || San Diego, California-- Public Internet access / || Mailing Lists || || To REMOVE yourself from this mailing list, send an E-Mail message || to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in || the message BODY, include a line containing: UNSUB ORACLE-L || (or the name of mailing list you want to be removed from). You may || also send the HELP command for other information (like subscribing). || -- || Please see the official ORACLE-L FAQ: http://www.orafaq.com || -- || Author: 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). || -- || Please see the official ORACLE-L FAQ: http://www.orafaq.com || -- || Author: Christopher Spence || INET: [EMAIL PROTECTED] || || Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 || San Diego, California-- Public Internet access / || Mailing Lists || || To REMOVE yourself from this mailing list, send an E-Mail message || to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in || the message BODY, include a line containing: UNSUB ORACLE-L || (or the name of mailing list you want to be removed from). You may || also send the HELP command for other information (like subscribing). || -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: io size of Unix machine
Are you trying to find maximum size of the IO possible in Sun/Solaris ? Kernel parameter maxphys parameter determines the maximum size of the IO possible from the OS. By default, it is around 128k depending upon what hardware you use(sun4d=124k, sun4u=128ketc ). If you user veritas volume manager, then vol_maxio parameter is the maximum size of the IO possible through veritas layer. If you use disk suite then, md_maxphys is the maximum IO size. So, if you want to set your IO size, then set both parameters maxphys and vol_maxio to that value (assuming you are using veritas ). Also, I think, veritas has hard limit of 256k and Oracle has hard limit of 512k. Your values should depend upon the type of application, type of disk drives, stripe width etc.. Thanks Riyaj "Re-yas" Shamsudeen Certified Oracle DBA i2 technologies www.i2.com |++| || TAG DBA || || dbatag@tatainfotech.| To: | || com | Multiple recipients | || Sent by: | of list ORACLE-L | || [EMAIL PROTECTED] | [EMAIL PROTECTED]| ||| | || 05/30/01 03:56 AM| cc: | || Please respond to| Subject: | || ORACLE-L | io size of Unix | ||| machine | |++| How can I find the logical or physical I/O size on a Sun Solaris machine ? Thanks, ~aslam =?iso-8859-2?Q?attphuo7.dat?=
RE: Analyze table and locking
Not necessarily. 8i+ DOESN'T require _ANY_ lock to COMPUTE while collecting statistics (99.99% of total operation time). It needs short lock to start and complete analyze. Regards Vadim -Original Message- Sent: Wednesday, May 30, 2001 9:07 AM To: Multiple recipients of list ORACLE-L Hi Lee, Compute option locks a table, but 'estimate' doesn't Regards, Ed -Original Message- Sent: 30 ??? 2001 ?. 15:22 To: Multiple recipients of list ORACLE-L All, Just a quicky !! Anyone know if there are any locking issues while analyzing statistics for objects ?? TIA Lee 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: Shevtsov, Eduard INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vadim Gorbounov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: multiple versions of SQLPlus.exe [now evolved to: multiple versions of tnsnames.ora in NT/W2K]
On NT 4 with Developer 6i and Oracle 816/817 I have never been able to get Oracle db to work off of the tns_admin key. Only forms would work off of the tns_admin, and without that key forms would not connect to the dbs. Just thought I would mention that. Kev -Original Message- Sent: Wednesday, May 30, 2001 7:16 AM To: Multiple recipients of list ORACLE-L versions of tnsnames.ora in NT/W2K] You CAN actually set the TNS_ADMIN variable in the registry under HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/ - It may not be there at first, all you need to do is create a new key called TNS_ADMIN with a value of the path to your master tnsnames.ora file. HTH Mark -Original Message- Granaman Sent: Tuesday, May 29, 2001 09:45 To: Multiple recipients of list ORACLE-L versions of tnsnames.ora in NT/W2K] In Unix, one can create links to a master by $ ls -s some master tnsnames.ora some other location/file. (I know, I could, and probably should, use the TNS_ADMIN environmental variable instead.) There seems to be no equivalent of this in NT though. Creating a shortcut doesn't seem to work. Copying files around seems primitive at best. Am I missing something? [OK, OK! I'll reform and use the environmental variable!] -Don Granaman [certifiable OraSaurus] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, May 29, 2001 2:01 PM Dave, It seems to me that you are having a problem reading the proper TNSNAMES.ORA for the different DBs. What I would do in your situation is to search for all TNSNAMES.ORA files in your PC, since you have products installed in more than one home and more than one version you should have multiple. Edit them and see which ones contain the entries that you need, in one or more of them some entries will be missing, what you can do is copy/paste the missing entries, once you have the file you want then copy it to all the different Homes and you should be able to connect to the different DB's. [... snip ...] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Granaman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 (everybody has a bad day once in a while...)/ RE: Creating a sorted table
On 30 May 2001, at 8:10, Christopher Spence wrote: This is totally NOT accurate. http://www.amazon.com/exec/obidos/ASIN/B5BYQH ---excerpt--- Tales of the Arabian Nights Barbie and Ken Our Price: $99.99 This item will be released on June 29, 2001. You may order it now and we will ship it to you when it arrives. Get a free Air Hogs Hydro water rocket with purchase of $50 or more of toys and/or video games. Box Size (in inches): 13.0 x 14.0 x 14.0 Shipping: Currently, item can be shipped only within the U.S. Shipping weight: pounds. ASIN: B5BYQH SKN: 267719 From Toysrus.com Amazon.com From the Manufacturer Barbie doll and Ken doll re-create the romantic legend of how Scheherazade brought peace to a trouble Sultan with 1001 nights of captivating stories. Barbie as Sheherazade is absolutely ravishing in a spectacularly patterned skirt, with matching top, embellished with golden highlights. She wears pink and blue veils in her hair that spiral gracefully around her, adding an air of mystery. Ken as the Sultan is Barbie doll's *dashing companion*. He wears a *pink tunic* with golden trim over billowy golden pants. A blue and purple sash ties at his waist and serves as a place to rest his ***trusty sword***. His colorful turban shines with a *faux ruby* and is topped with a *golden plume*. ---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).
RE: random equipment seen ???/ RE: V$SESSION.OSUSER returns NT-D
mainekoon cats. Almost as big as dogs, and do pull sleds. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Wednesday, May 30, 2001 1:21 AM To: Multiple recipients of list ORACLE-L NT-D 10 sub pounding, she doesn't even flinch, go figure. Then right when I am about to cap the flag for the win, she jumps on the keyboard and jumps on my shoulder. Hense I ussually get killed then. Sounds to me like she knows exactly what she's doing! -- Anita Cats are more intelligent than dogs... when was the last time you saw 12 cats pulling a sled in the snow! --- Christopher Spence [EMAIL PROTECTED] wrote: Powered screw driver :) Boy I love that thing, I put a 6 philips on it and I can work on boxes really easily by setting it to very low toque. Nah, Kitana always stays up there when I am working. 21 monitor, tons of room to sit for a cat :) Considering it never gets turned off, it is always hot. Just wonder how she stays there when I am playing tribes 2, got my sound turned way up with a 10 sub pounding, she doesn't even flinch, go figure. Then right when I am about to cap the flag for the win, she jumps on the keyboard and jumps on my shoulder. Hense I ussually get killed then. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Tuesday, May 29, 2001 5:45 PM To: Multiple recipients of list ORACLE-L NT-Domain\NT-User ? Christopher, trivial question, at: http://www.vampired.net/images/comproom.jpg what the heck is the object on top of the box on the left? looks like either a dental cleaning instrument, or a very small fishing pole like device. do you ever find it necessary to use duct tape to keep cats from falling off the top of your monitors? thanks, ep On 29 May 2001, at 10:28, Christopher scribbled with alacrity and cogency: Date sent:Tue, 29 May 2001 10:28:26 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] I am such an evil man. -- 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: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be
RE: RE: RE:
Reminds me of a bad joke... What did the farmer say when his tractor broke? -Original Message- Sent: Wednesday, May 30, 2001 12:03 PM To: Kevin Kostyszyn; [EMAIL PROTECTED] Just because! Reply Separator Author: Kevin Kostyszyn [EMAIL PROTECTED] Date: 5/30/2001 11:42 AM Oh my, but why? -Original Message- Sent: Wednesday, May 30, 2001 11:48 AM To: Kevin Kostyszyn; Multiple recipients of list ORACLE-L Ours is not to wonder why, ours is just to do or die!! Reply Separator Author: Kevin Kostyszyn [EMAIL PROTECTED] Date: 5/30/2001 7:02 AM This person was actually allowed to teach. Never ask why, yes that's a super philosophy on life. -Original Message- Patrice J Sent: Wednesday, May 30, 2001 8:31 AM To: Multiple recipients of list ORACLE-L That's a laugh, I went to a continuing education seminar once at Carleton University, in Ottawa. The seminar was called Effective Living. The teacher was a social worker, and he emphatically told everyone NEVER to ask why, just adapt to life and keep moving... I had unreconcilable disagreements with him, I guess I don't know how to live. : ) Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- From: Don Granaman [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, May 29, 2001 4:11 PM To: Multiple recipients of list ORACLE-L Subject:Re: when? But, more important, WHY??? -Don Granaman [certifiable OraSaurus] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, May 29, 2001 1:28 PM And Where. Terry Boivin, Patrice J wrote: When and how Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- From: Kevin Kostyszyn [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, May 29, 2001 1:41 PM To: Multiple recipients of list ORACLE-L Subject:RE: what -Original Message- Andrea Sent: Tuesday, May 29, 2001 11:47 AM To: Multiple recipients of list ORACLE-L who -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Quaglio Andrea INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Kevin Kostyszyn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB
RE: Performance tuning
John, have you read Cary Millsap's paper on RAID 5? www.hotsos.com I believe. RAID 5 will require additional writes by DBWR which is going to be huge overhead during a dataload. - Ethan Post -Original Message- Sent: Wednesday, May 30, 2001 6:51 AM To: Multiple recipients of list ORACLE-L 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. Peter McLarty wrote Are you running RAID and if so what configuration. (Not RAID 5 I hope) Interesting. I am posting an excerpt from Doc 97597.1 Optimising Raid performance for Oracle RDBMS on NT RAID 5 is useful for Oracle datafiles but not for redo log files or rollback segments which are sequentially accessed. Datafiles belonging to the temporary tablespace are not suitable for a RAID 5 device. More benefits will be seen in situations where reads predominate over writes. I know that in this instance it is a data load that is being discussed but presumably once the data is loaded then it will be read more than once. Certainly the tone of the note suggests that raid 5 is not a definite no-no rather a 'be cautious as to which files are placed where'. It is my belief that often a single raid level is set for all files rather than a mix of raid 1 and raid 5 as appropriate. Peter, I fully agree that the level of memory utilised here is totally insufficient and is very likely to be the constraining factor in this case. John -- This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you have received this message in error, please inform us promptly by reply e-mail, then delete the e-mail and destroy any printed copy. Thank you. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: backspace in Oracle.
Hey, NT could be up for 2100+ days, I mean, by the time you get there it won't even be able to play solitaire, but it will be up. -Original Message- Spence Sent: Wednesday, May 30, 2001 9:01 AM To: Multiple recipients of list ORACLE-L I have built Novell boxes that have 2100+ days of uptime :) Now that is stability that I have yet to see even unix have. Granted it is only Novell 3.12. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Sunday, May 27, 2001 8:10 PM To: Multiple recipients of list ORACLE-L Jared, I have an NT 4 server up for 242 days. Someone where I work suggested it should be sent to Microsoft for an examination (must be something wrong with it). Regards, Bruce -Original Message- Sent: Saturday, 26 May 2001 12:16 To: Multiple recipients of list ORACLE-L On Friday 25 May 2001 18:26, Weaver, Walt wrote: Ditto. I support Jared's backspace claims 100%, and I don't think he should be removed from the list. I sure appreciate that Walt! I've heard there are other operating systems out there besides Linux and Solaris. Is this true? A nasty rumor. There's an upstart startup in WA that claims to have something akin to an OS, but it keeps failing the 30 day stability test. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
re: Script examples for NT. (yuk!)
http://www.ultratech-llc.com/KB/Scripts/?File=Scripting.BAT (also see bottom of this message for more URLs) http://www.ultratech-llc.com/KB/?File=!Contents.TXT --forwarded message follows-- [Date sent: Wed, 30 May 2001 10:32:11 -0400 To: Recipients of WINNT-L digests [EMAIL PROTECTED] ] -Original Message- From: Andrew S. Baker [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 29, 2001 8:46 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: Yet another scripting question However, if the user double clicks the script again, it should not map a new drive, it will only open an Explorer window showing them the contents of the already mapped drive. That will actually require a bit more code than you've used so far, since the ENV variables will not retain enough info between runs. Here's a script using the CD command, which I don't like (for this purpose). Rule #3 in scripting should be to always use the FOR command... :) ~ @ECHO OFF SETLOCAL SET DRIVELIST=z y x w v u t s r q p o n m l k j i h g f e d SET CHECKDRIVE=FALSE FOR %%D IN (%DRIVELIST%) DO CALL :CheckDrive %%D ECHO %CHECKDRIVE% ENDLOCAL GOTO :EOF :CheckDrive rem - %1 = Current Drive Letter CD %1:\ 2NUL IF %ERRORLEVEL% EQU 1 IF /I %CHOSEN%==FALSE SET CHECKDRIVE=%1: GOTO :EOF ~ As a replacement for CD, I chose PUSHD, especially since it already does the first part of what you want (chosing the highest available drive letter). ~ @ECHO OFF SETLOCAL SET RESOURCE=\\COMPUTER\SHARE SET CHECKDRIVE=NOT SET PUSHD %RESOURCE% IF %ERRORLEVEL% EQU 0 FOR /F DELIMS=\ %%D IN ('CD') DO SET CHECKDRIVE=%%D ECHO %CHECKDRIVE% POPD ENDLOCAL ~ Now, if you don't want the drive assigned again, you should check for the existence of the mapping before running the rest of the script See the following: http://www.ultratech-llc.com/KB/Scripts/?File=MapDrive.BAT The full script will be here at some point before tomorrow morning... == ASB - http://www.ultratech-llc.com/KB/?File=Troubleshoot.TXT == --- Forwarded message follows --- Date sent: Wed, 30 May 2001 01:38:54 -0700 Andrew S. Baker wrote: I ended up using PUSHD, since it is native to NT/2000 and does all the work of choosing the highest free drive. ==begin file c:\CMD\TEST\freedrive.cmd == 001. @echo off 002. setlocal 003. set tgt=%1 004. if /i %tgt% NEQ HIGHEST if /i %tgt% NEQ LOWEST ( 005.echo. 006.echo Specify an argument of HIGHEST to return the highest free drive letter 007.echo Specify an argument of LOWEST to return the lowest free drive letter 008.endlocalgoto :EOF 009. ) 010. set free_drives= 011. for %%a in ( 012. z y x w v u t s r q p o n m l k j i h g f e d c b 013. ) do call :test %%a 014. set free_drives=%free_drives:~1% 015. call :%tgt% 016. endlocalset %~n0=%free_drive%goto :EOF 017. 018. :test 019. if exist %1: goto :EOF 020. set free_drives=%free_drives% %1: 021. goto :EOF 022. 023. :lowest 024. for /f tokens=1 delims=: %%a in ( 025. %free_drives% 026. ) do set free_drive=%%a: 027. goto :EOF 028. 029. :highest 030. call :length %free_drives% 031. set /a pos = length - 3 032. call :exec set free_drive=%%free_drives:~%pos%,2%%% 033. goto :EOF 034. 035. :length 036. set S1=%* 037. set length=0 038. :lloop 039. if not defined S1 goto :EOF 040. set S1=%S1:~1% 041. set /a length+=1 042. goto :lloop 043. 044. :exec 045. %* 046. goto :EOF ==end file c:\CMD\TEST\freedrive.cmd == --- End of forwarded message --- http://www.ultratech-llc.com/KB/?File=!Contents.TXT ... SCRIPTING AUTOMATION * http://www.ultratech-llc.com/KB/?File=Assoc.TXT * http://www.ultratech-llc.com/KB/?File=Audit.TXT * http://www.ultratech-llc.com/KB/?File=AutoLogon.TXT * http://www.ultratech-llc.com/KB/?File=BatchJob.TXT * http://www.ultratech-llc.com/KB/?File=Browser.TXT * http://www.ultratech-llc.com/KB/?File=CopyPerms.TXT * http://www.ultratech-llc.com/KB/?File=DateTime.TXT * http://www.ultratech-llc.com/KB/?File=Delegate.TXT * http://www.ultratech-llc.com/KB/?File=DelOld.TXT * http://www.ultratech-llc.com/KB/?File=EnvVars.TXT * http://www.ultratech-llc.com/KB/?File=ERD.TXT * http://www.ultratech-llc.com/KB/?File=InUse.TXT * http://www.ultratech-llc.com/KB/?File=License.TXT * http://www.ultratech-llc.com/KB/?File=Monitoring.TXT * http://www.ultratech-llc.com/KB/?File=NetShell.TXT * http://www.ultratech-llc.com/KB/?File=NTRights.TXT * http://www.ultratech-llc.com/KB/?File=NTVer.TXT * http://www.ultratech-llc.com/KB/?File=OSType.TXT * http://www.ultratech-llc.com/KB/?File=Perms.TXT * http://www.ultratech-llc.com/KB/?File=Processes.TXT *
RE: OT: RE: Fire your DBA's you don't need them anymore...
Yeah, I'd say that proportion would have worked in my group too. And when I interviewed others, I rarely got any great people applying, and it's almost solely because at that level, dollars were so much better as independents, and the only people who wanted to come were visa-sponsors or relative newbies. Again, I really had a great run there, and I'm grateful. (I don't know why I need to keep saying that.) And, I'd even probably go back if I could work out the salary. But I haven't tried. Anyway, still rambling, Yosi -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, May 25, 2001 4:36 PM To: Multiple recipients of list ORACLE-L Subject: Re:OT: RE: Fire your DBA's you don't need them anymore... Yosi, I interviewed for one of those jobs here in Boston, MA. Although there was one VERY good individual in the bunch I was a little perplexed by the others. Most were very junior and had not been in an outside shop before, one was straight out of school and bootcamp and only one had done a real recovery. It also hit me as strange that other than the smart guy, none of them had ever created a database from scratch. Thankfully I did not take the job. Dick Goulet Reply Separator Author: Gene Sais [EMAIL PROTECTED] Date: 5/25/2001 11:52 AM From experience, I have used consultants from Oracle. The 1st one sent was right out of DBA school. We sent him back after 1 week. At that time, Oracle didn't allow you to interview their DBA's. According to Oracle, they were all good. The 2nd DBA Oracle sent had only NT experience, never been on a Unix machine. Ok, sent him back too. By this time, we were about to give up, then Oracle sent DBA #3 and she was sharp. The moral of the story, Oracle will send the juniors 1st b/c they save the good ones for the 3rd strike :) [EMAIL PROTECTED] 05/25/01 03:01PM I was once one of those superior i-dba consultants. I was pretty good, and as with this list, some of my colleagues were amazingly talented, knowledgable and great to work with. Others were, well, others. It's lots of fun to ridicule, disparage, deride, belittle, and mock Oracle Consulting, and don't even get me started about Oracle Support, and I do this all the time too, I just want to put in a good word for SOME of my old friends. Have a great weekend. Yosi -Original Message- From: PD Miller [mailto:[EMAIL PROTECTED]] Sent: Friday, May 25, 2001 1:58 PM To: Multiple recipients of list ORACLE-L Subject: RE: Fire your DBA's you don't need them anymore... I've just spent most of today repairing damage left at a site by some of Oracle's 'superior' consultants! At 8:27 -0800 25/5/01, Gary Weber wrote: Far as their superior i-dba team, I sure hope those are different people from the ones you get on first line of Support... Cheers Paul Miller -- - Banned and proud of it! Carib Data Limited mailto:[EMAIL PROTECTED] http://www.caribdata.co.uk -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: PD Miller INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or
RE: random equipment seen ???/ RE: V$SESSION.OSUSER returns NT-D
On Wed, 30 May 2001,Christopher Spence scribbled on the wall in glitter crayon: -mainekoon cats. Almost as big as dogs, and do pull sleds. and like laps. and if you don't make one for them, they just tangle your feet till you fall down and then climb in your lap.;-) -- 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. ~~ Computers are unreliable, but humans are even more unreliable. - Gilb -- 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: Analyze table and locking
Many thanks -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: 30 May 2001 17:10To: Multiple recipients of list ORACLE-LSubject: RE: Analyze table and lockingAnalyze index validate structure takes shared lock on the table disallowing any changes to the table or indexes. That's the only way to validate the structures. In earlier versions (7.3 ?) 'analyze ..compute' used to take table level locks. From 8 onwards, compute or estimate does not take any table level or row level locks at all... ThanksRiyaj "Re-yas" ShamsudeenCertified Oracle DBAi2 technologies www.i2.com Robertson Lee - lerobe [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/30/01 10:25 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Analyze table and lockingOk, now I'm confusedOne reply-It depends. For instance, 'analyze index validate structure' takes out'shared' lock on the table (preventing inserts/deletes/updates), while'analyze index compute/estimate statistics' does not.Another---Compute option locks a table, but 'estimate' doesn'tAnyone have a definitive answer.PS. Thanks to the guys who have replied up to now.LeeThe information contained in this communication isconfidential, is intended only for the use of the recipientnamed above, and may be legally privileged. If the reader of this message is not the intended recipient, you arehereby notified that any dissemination, distribution orcopying 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 computersystem.-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Robertson Lee - lerobeINET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Re: multiple versions of SQLPlus.exe [now evolved to: multiple versions of tnsnames.ora in NT/W2K]
If under HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE you have one or multiple folders, like: HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/HOME0 HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/HOME1 then you have to create TNS_ADMIN string value (not key) in each of those folders pointing to your master tnsnames.ora file. Works for me. Igor Neyman, OCP DBA Perceptron, Inc. (734)414-4627 [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, May 30, 2001 10:56 AM versions of tnsnames.ora in NT/W2K] On NT 4 with Developer 6i and Oracle 816/817 I have never been able to get Oracle db to work off of the tns_admin key. Only forms would work off of the tns_admin, and without that key forms would not connect to the dbs. Just thought I would mention that. Kev -Original Message- Sent: Wednesday, May 30, 2001 7:16 AM To: Multiple recipients of list ORACLE-L versions of tnsnames.ora in NT/W2K] You CAN actually set the TNS_ADMIN variable in the registry under HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/ - It may not be there at first, all you need to do is create a new key called TNS_ADMIN with a value of the path to your master tnsnames.ora file. HTH Mark -Original Message- Granaman Sent: Tuesday, May 29, 2001 09:45 To: Multiple recipients of list ORACLE-L versions of tnsnames.ora in NT/W2K] In Unix, one can create links to a master by $ ls -s some master tnsnames.ora some other location/file. (I know, I could, and probably should, use the TNS_ADMIN environmental variable instead.) There seems to be no equivalent of this in NT though. Creating a shortcut doesn't seem to work. Copying files around seems primitive at best. Am I missing something? [OK, OK! I'll reform and use the environmental variable!] -Don Granaman [certifiable OraSaurus] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, May 29, 2001 2:01 PM Dave, It seems to me that you are having a problem reading the proper TNSNAMES.ORA for the different DBs. What I would do in your situation is to search for all TNSNAMES.ORA files in your PC, since you have products installed in more than one home and more than one version you should have multiple. Edit them and see which ones contain the entries that you need, in one or more of them some entries will be missing, what you can do is copy/paste the missing entries, once you have the file you want then copy it to all the different Homes and you should be able to connect to the different DB's. [... snip ...] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Granaman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send
Is DBMS_OBFUSCATION free in Enterprise Edition?
We have Enterprise Edition 8.1.7.1 on Sun Solaris 2.6. My manager needs a definitive answer. Is DBMS_OBFUSCATION free with this version of Enterprise Edition server or is it part of an extra-cost add-on. All definitive answers welcome. I have a call in to Oracle but they have not yet responded. My manager wants to know today. Thanks, Cherie Machler Oracle DBA 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).
PL/SQL Error
Hi all Can someone help me out here? I am getting this error when I try to run this PL/SQL code from an ASP page. The error manual just says to check speeling. I DID. Is there anything I am missing? The DB is V7.3 I am trying to return the resultset to the page. PLS-00306: wrong number or types of arguments in call to 'COURSE_SELECT' Here is the PL/SQL code create or replace package course.course_bulletin is TYPE tbl_call_no IS TABLE of cmcmcrst.call_no%type INDEX BY BINARY_INTEGER; TYPE tbl_schl_cd IS TABLE of cmcmcrst.schl_cd%type INDEX BY BINARY_INTEGER; TYPE tbl_dept_cd IS TABLE of cmcmcrst.dept_cd%type INDEX BY BINARY_INTEGER; PROCEDURE course_select(i_ccyy IN NUMBER, o_call_no OUT tbl_call_no, o_schl_cd OUT tbl_schl_cd, o_dept_cd OUT tbl_dept_cd); end; create or replace package body course.course_bulletin as PROCEDURE course_select(i_ccyy IN NUMBER, o_call_no OUT tbl_call_no, o_schl_cd OUT tbl_schl_cd, o_dept_cd OUT tbl_dept_cd) IS CURSOR c1 is SELECT call_no,schl_cd,dept_cd FROM COURSE.cmcmcrst WHERE ccyy = i_ccyy AND term_cd = '2' AND instrl_cd = '0'; crscount NUMBER DEFAULT 1; BEGIN FOR c IN c1 LOOP o_call_no(crscount) := c.call_no; o_schl_cd(crscount) := c.schl_cd; o_dept_cd(crscount) := c.dept_cd; crscount := crscount + 1; END LOOP; END; end; -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bartolo, David INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How to send email from pl/sql in 806?
On Wednesday 30 May 2001 03:10, Saurabh Sharma wrote: should i give it all four arguments. but it still not executing saying ora-06512 There are always other error messages accompanying an ORA-6512. What are they? Jared -- 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: Database slowdown after 100 days uptime
Its not a general Oracle or Unix thing because we had out AIX boxes up and running Oracle 7.3.4 and 8.1.6 for many months at a time with no reboots. -Original Message- Sent: Wednesday, May 30, 2001 9:50 AM To: Multiple recipients of list ORACLE-L Hi Bruce As I understand ur server uptime is 242 days.Right!If this is the case then Please reboot the server would solve this problem.The similar kind of problem I faced in past. Hope this will help u.If you would like to more information then please visit metalink. Thanks -Seema From: Raymond Lee Meng Hong [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Database slowdown after 100 days uptime Date: Tue, 29 May 2001 18:15:47 -0800 As far as my experience ,my site also got this problem , that is why every weekend we run a shutdown and restart the Unix box also in order to clean up some of the unwanted redo log and refresh the memory as well. it seen like our system become 6*24 instead of 7*24 , but in the business view is we open only until Saturday. but now we have branch open in shopping mall ,and they work in Sunday ? -Original Message- Sent: Tuesday, May 29, 2001 10:31 PM To: Multiple recipients of list ORACLE-L Keep an eye on free memory -- one of our similar systems has to be restarted every 60 days to prevent the behaviour you're encountering. We haven't determined the source of the memory leak, but if we permit it to continue eventually the DB stops responding and cannot be shut down. This system does some analytical work for us so it has different connection and activity profiles than the others, so I've a limited basis for comparison, but the other 8.1.5 databse (this one's data source) shows similar problems over a longer period. My plan is to take it up to 8.1.7 as those systems are not showing that sort of problem. Reardon, Bruce (CALBBAY) wrote: Hi, We're running Oracle 8.1.5.1.1 on NT 4. On Saturday our database started getting much slower - to me, there didn't seem to be any major events showing up in v$session_wait, v$session_event Restarting the database instance and service solved the performance problems. Today, when reviewing logs of the queries I noticed that the database had been up for 100 days when it started slowing. The 100 days uptime may be unrelated, but has anyone seen this behaviour on any platform? For information, the server itself has been up for 242 days (240 days when the problem started occurring). Thanks, Bruce Reardon mailto:[EMAIL PROTECTED] -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raymond Lee Meng Hong INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access /
RE: RE: RE:
Actually I say: You know what the farmer said when the cow died? Geesh, it never did that before. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Wednesday, May 30, 2001 1:07 PM To: Multiple recipients of list ORACLE-L Reminds me of a bad joke... What did the farmer say when his tractor broke? -Original Message- Sent: Wednesday, May 30, 2001 12:03 PM To: Kevin Kostyszyn; [EMAIL PROTECTED] Just because! Reply Separator Author: Kevin Kostyszyn [EMAIL PROTECTED] Date: 5/30/2001 11:42 AM Oh my, but why? -Original Message- Sent: Wednesday, May 30, 2001 11:48 AM To: Kevin Kostyszyn; Multiple recipients of list ORACLE-L Ours is not to wonder why, ours is just to do or die!! Reply Separator Author: Kevin Kostyszyn [EMAIL PROTECTED] Date: 5/30/2001 7:02 AM This person was actually allowed to teach. Never ask why, yes that's a super philosophy on life. -Original Message- Patrice J Sent: Wednesday, May 30, 2001 8:31 AM To: Multiple recipients of list ORACLE-L That's a laugh, I went to a continuing education seminar once at Carleton University, in Ottawa. The seminar was called Effective Living. The teacher was a social worker, and he emphatically told everyone NEVER to ask why, just adapt to life and keep moving... I had unreconcilable disagreements with him, I guess I don't know how to live. : ) Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- From: Don Granaman [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, May 29, 2001 4:11 PM To: Multiple recipients of list ORACLE-L Subject:Re: when? But, more important, WHY??? -Don Granaman [certifiable OraSaurus] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, May 29, 2001 1:28 PM And Where. Terry Boivin, Patrice J wrote: When and how Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- From: Kevin Kostyszyn [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, May 29, 2001 1:41 PM To: Multiple recipients of list ORACLE-L Subject:RE: what -Original Message- Andrea Sent: Tuesday, May 29, 2001 11:47 AM To: Multiple recipients of list ORACLE-L who -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Quaglio Andrea INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Kevin Kostyszyn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego,
RE: session pga memory value is much higher than Sort_Area_Size
I had the same problem. First, i realized that - it seems - there are other things that will bump the PGA. For me it was insert /*+ append */. However, after upgrading from 8.1.5 to 8.1.7 the problem went away. Hope this helps, and your mileage may vary. Good luck, Yosi -Original Message- From: Srikannan Gopalsamy [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 29, 2001 6:58 PM To: Multiple recipients of list ORACLE-L Subject: session pga memory value is much higher than Sort_Area_Size We've set sort_area_size to 8M, but the session pga memory usage shows much higher than 8M, in fact its about 176M. The heap value for the shadow process also confirms the size of the PGA area. 01A4 180496K read/write/exec [ heap ] I thought that the PGA size should not go beyond sort_area_size. Are we missing anything here? Thank for your help. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Srikannan Gopalsamy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: OT: RE: Fire your DBA's you don't need them anymore...
Yeah, I think they've got a retention problem, since the money is better outside, and consultants have a good idea of what they're being billed for. But the internal resources are great, as are their internal email lists. Of course, now we've got much of their internal stuff on metalink - if you can get access - and the odtug lists and oracle-l are right up there too. All in all, I liked working there very very much, and if they'd been able to keep up with what the market was offering I never would have left. And for those of us looking now, we know where the market is going, and Oracle's salaries are getting more in line with everyone else's anyway. (Boy, am I rambling or what? I've got a migraine, the fiorinal didn't do it's usual magic, and I really ought to go home.) -Original Message- From: Hillman, Alex [mailto:[EMAIL PROTECTED]] Sent: Friday, May 25, 2001 6:08 PM To: Multiple recipients of list ORACLE-L Subject: RE: OT: RE: Fire your DBA's you don't need them anymore... Oracle charges for such guys 250-350 an hour and pay them 50-90K/year (15-20% bonus and 4 weeks of training per year). I would say that Oracle DBA knowing what he or she is doing can make more money in consulting. Alex Hillman PS. It would be very useful if US participants of this list post their rates or salaries on www.realrates.com - it is fully anonimous. Also there is very interesting contractors BBS -Original Message- Sent: Friday, May 25, 2001 4:36 PM To: Multiple recipients of list ORACLE-L Yosi, I interviewed for one of those jobs here in Boston, MA. Although there was one VERY good individual in the bunch I was a little perplexed by the others. Most were very junior and had not been in an outside shop before, one was straight out of school and bootcamp and only one had done a real recovery. It also hit me as strange that other than the smart guy, none of them had ever created a database from scratch. Thankfully I did not take the job. Dick Goulet Reply Separator Author: Gene Sais [EMAIL PROTECTED] Date: 5/25/2001 11:52 AM From experience, I have used consultants from Oracle. The 1st one sent was right out of DBA school. We sent him back after 1 week. At that time, Oracle didn't allow you to interview their DBA's. According to Oracle, they were all good. The 2nd DBA Oracle sent had only NT experience, never been on a Unix machine. Ok, sent him back too. By this time, we were about to give up, then Oracle sent DBA #3 and she was sharp. The moral of the story, Oracle will send the juniors 1st b/c they save the good ones for the 3rd strike :) [EMAIL PROTECTED] 05/25/01 03:01PM I was once one of those superior i-dba consultants. I was pretty good, and as with this list, some of my colleagues were amazingly talented, knowledgable and great to work with. Others were, well, others. It's lots of fun to ridicule, disparage, deride, belittle, and mock Oracle Consulting, and don't even get me started about Oracle Support, and I do this all the time too, I just want to put in a good word for SOME of my old friends. Have a great weekend. Yosi -Original Message- From: PD Miller [mailto:[EMAIL PROTECTED]] Sent: Friday, May 25, 2001 1:58 PM To: Multiple recipients of list ORACLE-L Subject: RE: Fire your DBA's you don't need them anymore... I've just spent most of today repairing damage left at a site by some of Oracle's 'superior' consultants! At 8:27 -0800 25/5/01, Gary Weber wrote: Far as their superior i-dba team, I sure hope those are different people from the ones you get on first line of Support... Cheers Paul Miller -- - Banned and proud of it! Carib Data Limited mailto:[EMAIL PROTECTED] http://www.caribdata.co.uk -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: PD Miller INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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
Re:RE:
Ours is not to wonder why, ours is just to do or die!! Reply Separator Author: Kevin Kostyszyn [EMAIL PROTECTED] Date: 5/30/2001 7:02 AM This person was actually allowed to teach. Never ask why, yes that's a super philosophy on life. -Original Message- Patrice J Sent: Wednesday, May 30, 2001 8:31 AM To: Multiple recipients of list ORACLE-L That's a laugh, I went to a continuing education seminar once at Carleton University, in Ottawa. The seminar was called Effective Living. The teacher was a social worker, and he emphatically told everyone NEVER to ask why, just adapt to life and keep moving... I had unreconcilable disagreements with him, I guess I don't know how to live. : ) Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- From: Don Granaman [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, May 29, 2001 4:11 PM To: Multiple recipients of list ORACLE-L Subject:Re: when? But, more important, WHY??? -Don Granaman [certifiable OraSaurus] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, May 29, 2001 1:28 PM And Where. Terry Boivin, Patrice J wrote: When and how Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- From: Kevin Kostyszyn [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, May 29, 2001 1:41 PM To: Multiple recipients of list ORACLE-L Subject:RE: what -Original Message- Andrea Sent: Tuesday, May 29, 2001 11:47 AM To: Multiple recipients of list ORACLE-L who -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Quaglio Andrea INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Kevin Kostyszyn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Terry Ball INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet
RE: Script examples for NT. (yuk!)
My suggestion would be to install cygwin (http://sources.redhat.com/cygwin/). -Original Message- From: GLoughmiller [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 30, 2001 8:25 AM To: ORACLE-L Cc: GLoughmiller Subject: Script examples for NT. (yuk!) Quick question.. ALL of my experience has been on UNIX platforms... Recently, I have been asked to work on an Oracle DB that runs on NT.. My scripting capability in the NT world is weak at best. So I am trying to compare ksh type activities with the NT world. SO I was wondering if any of you would mind sharing a couple of NT type scripts with me.. For example-setting variables to the return of a SQL statement to be used in the shell,etc... Any help would be appreciated.. TIA Greg Loughmiller mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Loughmiller, Greg INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Performance tuning
Raid 5 can consume as much as 60% overhead for writes. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Wednesday, May 30, 2001 12:51 PM To: Multiple recipients of list ORACLE-L John, have you read Cary Millsap's paper on RAID 5? www.hotsos.com I believe. RAID 5 will require additional writes by DBWR which is going to be huge overhead during a dataload. - Ethan Post -Original Message- Sent: Wednesday, May 30, 2001 6:51 AM To: Multiple recipients of list ORACLE-L 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. Peter McLarty wrote Are you running RAID and if so what configuration. (Not RAID 5 I hope) Interesting. I am posting an excerpt from Doc 97597.1 Optimising Raid performance for Oracle RDBMS on NT RAID 5 is useful for Oracle datafiles but not for redo log files or rollback segments which are sequentially accessed. Datafiles belonging to the temporary tablespace are not suitable for a RAID 5 device. More benefits will be seen in situations where reads predominate over writes. I know that in this instance it is a data load that is being discussed but presumably once the data is loaded then it will be read more than once. Certainly the tone of the note suggests that raid 5 is not a definite no-no rather a 'be cautious as to which files are placed where'. It is my belief that often a single raid level is set for all files rather than a mix of raid 1 and raid 5 as appropriate. Peter, I fully agree that the level of memory utilised here is totally insufficient and is very likely to be the constraining factor in this case. John -- This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you have received this message in error, please inform us promptly by reply e-mail, then delete the e-mail and destroy any printed copy. Thank you. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Problems with CharArrayType after upgrade from 7.3.4 to 8.1.7
Try changing to VARCHAR2(31) instead of VARCHAR(31). Although I know there is no difference in varchar and varchar2 definition. 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 ! *4 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *4 -- 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).
OT: Effective Living
Isn't that sort of like Taoism? Accept your lot, there must be good in it somewhere... Also, it seems to be the basis of many major religions to essentially never ask why. So, I guess it's a pretty popular philosophy. (Oh no, I feel a discourse by Eric coming on...) 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] Kevin Kostyszyn To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] kevin@dulciacc: n.com Fax to: Sent by: Subject: RE: root@fatcity. com 05/30/2001 11:02 AM Please respond to ORACLE-L This person was actually allowed to teach. Never ask why, yes that's a super philosophy on life. -Original Message- Patrice J Sent: Wednesday, May 30, 2001 8:31 AM To: Multiple recipients of list ORACLE-L That's a laugh, I went to a continuing education seminar once at Carleton University, in Ottawa. The seminar was called Effective Living. The teacher was a social worker, and he emphatically told everyone NEVER to ask why, just adapt to life and keep moving... I had unreconcilable disagreements with him, I guess I don't know how to live. : ) Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- From: Don Granaman [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, May 29, 2001 4:11 PM To: Multiple recipients of list ORACLE-L Subject: Re: when? But, more important, WHY??? -Don Granaman [certifiable OraSaurus] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, May 29, 2001 1:28 PM And Where. Terry Boivin, Patrice J wrote: When and how Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- From: Kevin Kostyszyn [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, May 29, 2001 1:41 PM To: Multiple recipients of list ORACLE-L Subject:RE: what -Original Message- Andrea Sent: Tuesday, May 29, 2001 11:47 AM To: Multiple recipients of list ORACLE-L who -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Quaglio Andrea INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message
Re: Missing DDL?
Sean, The indexfile parameter shows only the create table statements (REM'd out) and the additional indexes (i.e not indexes used to enforce PK constraints). To see all the DDL, use the SHOW=Y parameter along with LOG=filename. HTH, -- Anita --- O'Neill, Sean [EMAIL PROTECTED] wrote: Created a sandbox database using Database Administration utiltity, (8i Rel 3, PE, NT4). I ran full export of a database. I then used the imp utility with indexfile parameter to create the DDL for the database. I expected to be able to find the DDL for the tablespaces TOOLS, USERS and some others but can't. OK, so there are no tables created in them but I'm puzzled now as to how these tablespaces are created during import?. Probably missing something obvious, but anyones sane input would be appreciated!. Sean :) Rookie Data Base Administrator [0%] OCP Oracle8i DBA [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA Nobody loves me but my mother... and she could be jivin' too. - BB King -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Analyze table and locking
I have used compute statistics since version 7.3.2 up through 8.1.6, and never had it hold a table lock for the duration of the analyze. I don't know where people are getting the idea that compute statistics holds a lock and estimate doesn't. That just doesn't make sense. Why would compute need a lock? Are you saying I can estimate sample 99 percent, and get what amounts to a compute and avoid the supposed lock? Does that make any sense? No. Validate structure cascade holds a lock. The most the others do is grab some resource [very] briefly at the end to update the dictionary. People claiming that compute holds a lock, please post documentation to support that statement. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Wed, 30 May 2001, Raghu Kota wrote: Yeah If you use compute statistics your table get locked and will take long time, But If you use estimate statistics it will be fast But not as accurate as before. Better to analyze at nights by setting time. From: Robertson Lee - lerobe [EMAIL PROTECTED] Anyone know if there are any locking issues while analyzing statistics for objects ?? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OEM Book Recommendation
DBAs, As a keyboard lover, hate to do this. But I need to study OEM. Any good Books / URLs / DOCs / PDFs Thanks in advance, -Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul Dandekar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Performance tuning
Redo generation will not change. Just the archiving process, which on improperly laid out file system can be very painful process. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Wednesday, May 30, 2001 1:22 PM To: Multiple recipients of list ORACLE-L Why putting DB in noarchivelog will avoid redo generation? There will be no archiving, but redo will continue to be generated. Alex Hillman -Original Message- Sent: Wednesday, May 30, 2001 10:21 AM To: Multiple recipients of list ORACLE-L Azhar, Just two thoughts off the top of my head to improve loading of records: 1. Put database in noarchivelog mode to avoid redo generation (if possible). 2. Drop all indexes on target tables (if possible), then load data, then recreate all indexes on target tables. Jim Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) HI ALL, We have to load almost 3 millions records of average row size of 150 bytes. We are importing data using sqloader with ROWS=4000 and bindsize=845 . We have adjusted the rollback segment to almost 10 m with 8 extents enough for single transaction size and considering 30% rollback overhead. We adjusted the OPTIMAL TO 10 M to have avoid rollback extension Rollback segment, databuffer cache have hit ratio of 100%. The loading was fast only for first 10 commits but then it slowed like snail. LOADING TOOK 22 hours in the first run on ORACLE8i NT4 128 megs RAM . SGA figures in M : NAME VALUE - Fixed Size.0676384 Variable Size239.02734 Database Buffers 39.0625 Redo Buffers 7.8203125 - sum 285.97779 ( we can't use direct path due to functions in sqlldr controlfile). . Couldn't figure out the bottleneck yet. Any ideas. TIA Azhar Siddiq, DBA LMK Resources -- 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). -- Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: _sqlexec_progression_cost
I am using this parameter on 8.1.6.2 for the same bug: 1210242: CURSORS NOT SHARED WHEN TIMED_STATISTICS=TRUE DESPITE FIX FOR BUG 918002. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Tue, 29 May 2001, Jerry C wrote: Anybody have experience setting this parameter? It references a bug (1210242) that apparently causes certain cursors not to be shared if timed statistics is set to TRUE. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Creating a sorted table
Sure, and thanks. I appreciate the corrections, as one problem with doing this for a while is the aggregation of useless and no longer true facts, which I'm finding I have more and more of. They feel like barnacles. :) I've finally decided to go get my OCP, which I hope will help scrape some of the buggers off. This list always helps, too. 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: RE: Creating a sorted table com 05/30/2001 01:01 PM Please respond to ORACLE-L Diana, You might wanna check out www.kx.com Those guys have a lightning rocket of a dbms, and it is based, in part, on storing data in search/sort-dependent order. (There is a bunch of background data on the site itself.) In any case, reading up on other dbms technologies has a place in any DBAs self-education. Else, we're just sitting around quoting anecdotes to one another! Hope this helps, Cheers, Ross || -Original Message- || From: Christopher Spence [mailto:[EMAIL PROTECTED]] || Sent: Wednesday, May 30, 2001 12:10 PM || To: Multiple recipients of list ORACLE-L || Subject: RE: Creating a sorted table || || || This is totally NOT accurate. || || Yes there are performance gains storing index data ordered. || Perhaps great || on range scans. Yes you can reorder tables and indexes. || || Walking on water and developing software from a || specification are easy if || both are frozen. || || Christopher R. Spence || Oracle DBA || Fuelspot || || || || -Original Message- || Sent: Friday, May 25, 2001 7:41 PM || To: Multiple recipients of list ORACLE-L || || || || Whyever would you want data inserted in order? There is no || guarantee that || Oracle will actually store the records in order, there is || no performance || gain, and you can always retrieve the records in order by || using an order by || statement -- if you really need ordered data, you could use a || index-organized table with all of your columns, with the || date as the first || column. But methinks this would be dangerous for a heavy transaction || table. (Gurus, please correct me if I'm wrong here) || || However, if you are still keen, you could do this through a || PL/SQL block, || something like the following: || || declare || cursor get_data is || select col1, col2, col3, ... || from unordered_table || order by whatever; || begin || for dataRec in get_data loop || insert into ordered_table (col1, col2, col3, ...) || values (dataRec.col1, dataRec.col2, dataRec.col3, ...) || end loop; || end; || / || || Cheers! || || Diana || || || || || || Browett, Darren || || [EMAIL PROTECTED]To: || Multiple recipients || of list ORACLE-L [EMAIL PROTECTED] || lam.bc.ca cc: || || Sent by: Fax to: || || [EMAIL PROTECTED] Subject: || Creating a || sorted table || || || || || 05/25/2001 06:45 PM || || Please respond to || ||
Re: Problems with CharArrayType after upgrade from 7.3.4 to 8.1.7.1
Cherie, I have no idea if this could be the case, but I noticed that the type is based on the datatype VARCHAR, not VARCHAR2. According to the docs, this shouldn't make a difference, but they've been warning since the introduction of VARCHAR2 that they may do something different with VARCHAR at some point in the future, so it's best not to use it. From the PL/SQL manual: === VARCHAR2 Subtypes The VARCHAR2 subtypes below have the same range of values as their base type. For example, VARCHAR is just another name for VARCHAR2. STRING VARCHAR You can use these subtypes for compatibility with ANSI/ISO and IBM types. Note: Currently, VARCHAR is synonymous with VARCHAR2. However, in future releases of PL/SQL, to accommodate emerging SQL standards, VARCHAR might become a separate datatype with different comparison semantics. So, it is a good idea to use VARCHAR2 rather than VARCHAR. === Again, I don't see how that could affect the code...just a shot in the dark. Diana Duncan TITAN Technology Partners One Copley Parkway, Ste 540 Morrisville, NC 27560 VM: 919.466.7337 x 316 F: 919.466.7427 E: [EMAIL PROTECTED] Cherie_Machler @gelco.comTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Fax to: omSubject: Problems with CharArrayType after upgrade from 7.3.4 to 8.1.7.1 05/30/2001 01:40 PM Please respond to ORACLE-L After upgrading from Enterprise Edition 7.3.4 to 8.1.7.1 on Sun Solaris 2.6, we are having problems executing a procedure with CharArrayType as shown below. We don't get any error message. The package simply does not return any rows when there are rows out there that should be returned. The developer is trying to turn on some debug but I thought I would also ask if anyone sees anything that is a no-no now under 8.1.7.1. Is there something that I need to do in order to migrate this code that wasn't done automatically? CREATE OR REPLACE PACKAGE CCFILECD AS TYPE NumArrayType IS TABLE OF NUMBER INDEX BY BINARY_INTEGER; TYPE CharArrayType IS TABLE OF VARCHAR(31) INDEX BY BINARY_INTEGER; PROCEDURE GETFILECODES(file_code OUT CharArrayType, file_prefixOUT CharArrayType, start_pos OUT NumArrayType, length OUT NumArrayType, num_lines_to_skip OUT NumArrayType, record_length OUT NumArrayType, cntry_cd_proc OUT NumArrayType, curr_cd_proc OUT NumArrayType, count OUT NUMBER); END CCFILECD; Thanks for any advice you can give, Cherie Machler Oracle DBA 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: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
RE: connect on oracle database
Either MS ODBC or Oracle driver can do the connectivity. I found out that MS ODBC is more user-friendly. Just my $0.02. -Original Message- Sent: Wednesday, May 30, 2001 4:30 AM To: Multiple recipients of list ORACLE-L Hish, Crack out some manuals double quick - get some RDBMS training, and learn a little about what you are playing with here! Sybase and Informix are not actually applications - they are Relational Database Management Systems (RDBMSs) that are competitors to Oracle. To answer the question though - I think - you can probably connect to these databases through some kind of ODBC connectivity - or a Gateway product - though I have never done this.. HTH Mark -Original Message- Hassan Sent: Wednesday, May 30, 2001 11:20 To: Multiple recipients of list ORACLE-L hi DBA Masters: If i have any application (sybase / informex) not oracle tools make it. how to connect from this application on the oracle database?? thank you hish _ 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: Hisham Hassan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: PHU,JULIA (HP-Sunnyvale,ex2) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Performance tuning
Indeses are not critical for the application to run..It just helps them run faster at times. You could build you indexes with the no logging or unrecoverable option and that will save on the archivelog creation. Just be sure to take a backup after the indexes are rebuilt because you will not have archived the index info in archivelogs for recovery. I do it all the time for my files that have a large data load each day and it saves log writing time and log space. ROR mª¿ªm [EMAIL PROTECTED] 05/30/01 01:21PM Why putting DB in noarchivelog will avoid redo generation? There will be no archiving, but redo will continue to be generated. Alex Hillman -Original Message- Sent: Wednesday, May 30, 2001 10:21 AM To: Multiple recipients of list ORACLE-L Azhar, Just two thoughts off the top of my head to improve loading of records: 1. Put database in noarchivelog mode to avoid redo generation (if possible). 2. Drop all indexes on target tables (if possible), then load data, then recreate all indexes on target tables. Jim Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) HI ALL, We have to load almost 3 millions records of average row size of 150 bytes. We are importing data using sqloader with ROWS=4000 and bindsize=845 . We have adjusted the rollback segment to almost 10 m with 8 extents enough for single transaction size and considering 30% rollback overhead. We adjusted the OPTIMAL TO 10 M to have avoid rollback extension Rollback segment, databuffer cache have hit ratio of 100%. The loading was fast only for first 10 commits but then it slowed like snail. LOADING TOOK 22 hours in the first run on ORACLE8i NT4 128 megs RAM . SGA figures in M : NAME VALUE - Fixed Size.0676384 Variable Size239.02734 Database Buffers 39.0625 Redo Buffers 7.8203125 - sum 285.97779 ( we can't use direct path due to functions in sqlldr controlfile). . Couldn't figure out the bottleneck yet. Any ideas. TIA Azhar Siddiq, DBA LMK Resources -- 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). -- Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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
Re: Is DBMS_OBFUSCATION free in Enterprise Edition?
It's free. Diana Duncan TITAN Technology Partners One Copley Parkway, Ste 540 Morrisville, NC 27560 VM: 919.466.7337 x 316 F: 919.466.7427 E: [EMAIL PROTECTED] Cherie_Machler @gelco.comTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Fax to: omSubject: Is DBMS_OBFUSCATION free in Enterprise Edition? 05/30/2001 02:02 PM Please respond to ORACLE-L We have Enterprise Edition 8.1.7.1 on Sun Solaris 2.6. My manager needs a definitive answer. Is DBMS_OBFUSCATION free with this version of Enterprise Edition server or is it part of an extra-cost add-on. All definitive answers welcome. I have a call in to Oracle but they have not yet responded. My manager wants to know today. Thanks, Cherie Machler Oracle DBA 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: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Missing DDL?
And then prepare to go bleary eyed reading it :) while an indexfile produces a runnable sql text, show=y does not. Lines are wrapped in the middle of words, appear everywhere. But it will get you what you want to see Rachel From: A. Bardeen [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Missing DDL? Date: Wed, 30 May 2001 09:01:19 -0800 Sean, The indexfile parameter shows only the create table statements (REM'd out) and the additional indexes (i.e not indexes used to enforce PK constraints). To see all the DDL, use the SHOW=Y parameter along with LOG=filename. HTH, -- Anita --- O'Neill, Sean [EMAIL PROTECTED] wrote: Created a sandbox database using Database Administration utiltity, (8i Rel 3, PE, NT4). I ran full export of a database. I then used the imp utility with indexfile parameter to create the DDL for the database. I expected to be able to find the DDL for the tablespaces TOOLS, USERS and some others but can't. OK, so there are no tables created in them but I'm puzzled now as to how these tablespaces are created during import?. Probably missing something obvious, but anyones sane input would be appreciated!. Sean :) Rookie Data Base Administrator [0%] OCP Oracle8i DBA [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA Nobody loves me but my mother... and she could be jivin' too. - BB King -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ 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).
OT: Archiving not possible with SQL Server?
Halo, Windoz 2000/SQL Server 2000 Bringing an axuliary MS SQL db online. Trying to setup archiving. Am I reading documentation right, SQL does NOT automatically archive transaction log? This process must be setup via backup routine, which truncates the log upon completion? Lemme try some logic: Oracle's redo logs = MS transaction log(s) Oracle's archived logs = ? Gary Weber Senior DBA Charles Jones, LLC 609-530-1144, ext 5529 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gary Weber INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Performance tuning
Sorry - that's what I meant. No archive log generation. NOT no redo log generation. Thanks for pointing that out. Is it Friday yet? Jim Why putting DB in noarchivelog will avoid redo generation? There will be no archiving, but redo will continue to be generated. Alex Hillman -Original Message- Sent: Wednesday, May 30, 2001 10:21 AM To: Multiple recipients of list ORACLE-L Azhar, Just two thoughts off the top of my head to improve loading of records: 1. Put database in noarchivelog mode to avoid redo generation (if possible). 2. Drop all indexes on target tables (if possible), then load data, then recreate all indexes on target tables. Jim Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) HI ALL, We have to load almost 3 millions records of average row size of 150 bytes. We are importing data using sqloader with ROWS=4000 and bindsize=845 . We have adjusted the rollback segment to almost 10 m with 8 extents enough for single transaction size and considering 30% rollback overhead. We adjusted the OPTIMAL TO 10 M to have avoid rollback extension Rollback segment, databuffer cache have hit ratio of 100%. The loading was fast only for first 10 commits but then it slowed like snail. LOADING TOOK 22 hours in the first run on ORACLE8i NT4 128 megs RAM . SGA figures in M : NAME VALUE - Fixed Size.0676384 Variable Size239.02734 Database Buffers 39.0625 Redo Buffers 7.8203125 - sum 285.97779 ( we can't use direct path due to functions in sqlldr controlfile). . Couldn't figure out the bottleneck yet. Any ideas. TIA Azhar Siddiq, DBA LMK Resources -- 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). -- Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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). -- Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other
RE: PL/SQL Error
David, What I'd want to see is the actual call you are making in the ASP code. Your package is fine, the problem is with the variables (you have defined in the ASP code), that are used when this procedure is being called. If you can ensure that the variables have been declared as following you should be okay ... otherwise Oracle is right ... declare var1 course.course_bulletin.tbl_call_no; var2 course.course_bulletin.tbl_schl_cd; var3 course.course_bulletin.tbl_dept_cd; begin course.course_bulletin(i_ccyy, var1, var2, var3); end; __ 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 ! *1 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: multiple versions of SQLPlus.exe [now evolved to: multiple versions of tnsnames.ora in NT/W2K]
It is a good point that it's a string, I actually knew that, but it still doesn't explain why i can't get it to work. Not that it's that big of a deal. I'll try again, no harm in that. Kev -Original Message- Sent: Wednesday, May 30, 2001 12:36 PM To: Multiple recipients of list ORACLE-L versions of tnsnames.ora in NT/W2K] If under HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE you have one or multiple folders, like: HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/HOME0 HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/HOME1 then you have to create TNS_ADMIN string value (not key) in each of those folders pointing to your master tnsnames.ora file. Works for me. Igor Neyman, OCP DBA Perceptron, Inc. (734)414-4627 [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, May 30, 2001 10:56 AM versions of tnsnames.ora in NT/W2K] On NT 4 with Developer 6i and Oracle 816/817 I have never been able to get Oracle db to work off of the tns_admin key. Only forms would work off of the tns_admin, and without that key forms would not connect to the dbs. Just thought I would mention that. Kev -Original Message- Sent: Wednesday, May 30, 2001 7:16 AM To: Multiple recipients of list ORACLE-L versions of tnsnames.ora in NT/W2K] You CAN actually set the TNS_ADMIN variable in the registry under HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/ - It may not be there at first, all you need to do is create a new key called TNS_ADMIN with a value of the path to your master tnsnames.ora file. HTH Mark -Original Message- Granaman Sent: Tuesday, May 29, 2001 09:45 To: Multiple recipients of list ORACLE-L versions of tnsnames.ora in NT/W2K] In Unix, one can create links to a master by $ ls -s some master tnsnames.ora some other location/file. (I know, I could, and probably should, use the TNS_ADMIN environmental variable instead.) There seems to be no equivalent of this in NT though. Creating a shortcut doesn't seem to work. Copying files around seems primitive at best. Am I missing something? [OK, OK! I'll reform and use the environmental variable!] -Don Granaman [certifiable OraSaurus] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, May 29, 2001 2:01 PM Dave, It seems to me that you are having a problem reading the proper TNSNAMES.ORA for the different DBs. What I would do in your situation is to search for all TNSNAMES.ORA files in your PC, since you have products installed in more than one home and more than one version you should have multiple. Edit them and see which ones contain the entries that you need, in one or more of them some entries will be missing, what you can do is copy/paste the missing entries, once you have the file you want then copy it to all the different Homes and you should be able to connect to the different DB's. [... snip ...] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Granaman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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
RE: PL/SQL Error
David, How are you calling this procedure? Into what structures are you receiving the PL/SQL Out Arguments, which are PL/SQL tables? I'll bet that's your problem. Show us the code that calls this procedure and handles the output. BTW, if you checked the speeling of your PL/SQL as well as you did your message, there may be even more problems. ;-) Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- David Sent: Wednesday, May 30, 2001 12:07 PM To: Multiple recipients of list ORACLE-L Hi all Can someone help me out here? I am getting this error when I try to run this PL/SQL code from an ASP page. The error manual just says to check speeling. I DID. Is there anything I am missing? The DB is V7.3 I am trying to return the resultset to the page. PLS-00306: wrong number or types of arguments in call to 'COURSE_SELECT' Here is the PL/SQL code create or replace package course.course_bulletin is TYPE tbl_call_no IS TABLE of cmcmcrst.call_no%type INDEX BY BINARY_INTEGER; TYPE tbl_schl_cd IS TABLE of cmcmcrst.schl_cd%type INDEX BY BINARY_INTEGER; TYPE tbl_dept_cd IS TABLE of cmcmcrst.dept_cd%type INDEX BY BINARY_INTEGER; PROCEDURE course_select(i_ccyy IN NUMBER, o_call_no OUT tbl_call_no, o_schl_cd OUT tbl_schl_cd, o_dept_cd OUT tbl_dept_cd); end; create or replace package body course.course_bulletin as PROCEDURE course_select(i_ccyy IN NUMBER, o_call_no OUT tbl_call_no, o_schl_cd OUT tbl_schl_cd, o_dept_cd OUT tbl_dept_cd) IS CURSOR c1 is SELECT call_no,schl_cd,dept_cd FROM COURSE.cmcmcrst WHERE ccyy = i_ccyy AND term_cd = '2' AND instrl_cd = '0'; crscount NUMBER DEFAULT 1; BEGIN FOR c IN c1 LOOP o_call_no(crscount) := c.call_no; o_schl_cd(crscount) := c.schl_cd; o_dept_cd(crscount) := c.dept_cd; crscount := crscount + 1; END LOOP; END; end; -- -- 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 Error
Here is the ASP code ccyy = 2001 set cn = server.CreateObject(adodb.connection) set cmd = server.CreateObject(adodb.command) set rs = server.CreateObject(adodb.recordset) cn.ConnectionTimeout = 120 cn.CommandTimeout=30 cn.ConnectionString=DSN=db;UID=user;Password=pwd cn.Open cmd.ActiveConnection = cn cmd.CommandText = {call course.course_bulletin.course_select({resultset 1, o_call_no, o_schl_cd, o_dept_cd})} cmd.CommandType=adCmdText cmd.Parameters.Append cmd.CreateParameter(i_ccyy, adInteger, adParamInput, , clng(ccyy)) set rs.Source = cmd rs.Open -Original Message- Sent: Wednesday, May 30, 2001 12:01 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] I think the error is in the call to the procedure, not in the procedure itself -- the procedure looks fine at a glance. Could you post the ASP code that makes the call? 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] Bartolo, David To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] bartolo@USCOcc: LO.edu Fax to: Sent by: Subject: PL/SQL Error root@fatcity. com 05/30/2001 01:06 PM Please respond to ORACLE-L Hi all Can someone help me out here? I am getting this error when I try to run this PL/SQL code from an ASP page. The error manual just says to check speeling. I DID. Is there anything I am missing? The DB is V7.3 I am trying to return the resultset to the page. PLS-00306: wrong number or types of arguments in call to 'COURSE_SELECT' Here is the PL/SQL code create or replace package course.course_bulletin is TYPE tbl_call_no IS TABLE of cmcmcrst.call_no%type INDEX BY BINARY_INTEGER; TYPE tbl_schl_cd IS TABLE of cmcmcrst.schl_cd%type INDEX BY BINARY_INTEGER; TYPE tbl_dept_cd IS TABLE of cmcmcrst.dept_cd%type INDEX BY BINARY_INTEGER; PROCEDURE course_select(i_ccyy IN NUMBER, o_call_no OUT tbl_call_no, o_schl_cd OUT tbl_schl_cd, o_dept_cd OUT tbl_dept_cd); end; create or replace package body course.course_bulletin as PROCEDURE course_select(i_ccyy IN NUMBER, o_call_no OUT tbl_call_no, o_schl_cd OUT tbl_schl_cd, o_dept_cd OUT tbl_dept_cd) IS CURSOR c1 is SELECT call_no,schl_cd,dept_cd FROM COURSE.cmcmcrst WHERE ccyy = i_ccyy AND term_cd = '2' AND instrl_cd = '0'; crscount NUMBER DEFAULT 1; BEGIN FOR c IN c1 LOOP o_call_no(crscount) := c.call_no; o_schl_cd(crscount) := c.schl_cd; o_dept_cd(crscount) := c.dept_cd; crscount := crscount + 1; END LOOP; END; end; -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bartolo, David INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Bartolo, David INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Performance tuning
Since Data is being loaded in development environment. that is why we have 128 meg ram. (Regarding RAM i have no other choice) i have the NT performance monitor and it shows that it is not using swap heavily. NT swaps heavily with 128Mb ram running office, you must have some sort of magical system to run oracle with such a large table on it. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Wednesday, May 30, 2001 9:56 AM To: Multiple recipients of list ORACLE-L Actually we have to Since Data is being loaded in development environment. that is why we have 128 meg ram. (Regarding RAM i have no other choice) i have the NT performance monitor and it shows that it is not using swap heavily. Currently disk configuration is not RAID . however we have no disk limit problem. i have autoexetended datafiles. Regards Azhar Peter McLarty peter.mclarty@To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] incts.com cc: Sent by: Subject: Re: Performance tuning [EMAIL PROTECTED] m 05/30/2001 04:21 PM Please respond to ORACLE-L Okay fill us in why would you try and inane thing like that on only 128MB RAM. NT would be barely running on that without getting your instance up. I am not that good yet at calculating what amount of RAM you need for a given SGA but I am thinking that you are running in swap What is the disk configuration. Are you running RAID and if so what configuration. (Not RAID 5 I hope) Can you get this system up to 512MB at least. With this and a whole lot more you will get some better answers Peter Trainee Oracle DBA At 01:19 AM 30/05/2001 -0800, you wrote: HI ALL, We have to load almost 3 millions records of average row size of 150 bytes. We are importing data using sqloader with ROWS=4000 and bindsize=845 . We have adjusted the rollback segment to almost 10 m with 8 extents enough for single transaction size and considering 30% rollback overhead. We adjusted the OPTIMAL TO 10 M to have avoid rollback extension Rollback segment, databuffer cache have hit ratio of 100%. The loading was fast only for first 10 commits but then it slowed like snail. LOADING TOOK 22 hours in the first run on ORACLE8i NT4 128 megs RAM . SGA figures in M : NAME VALUE - Fixed Size.0676384 Variable Size239.02734 Database Buffers 39.0625 Redo Buffers 7.8203125 - sum 285.97779 ( we can't use direct path due to functions in sqlldr controlfile). . Couldn't figure out the bottleneck yet. Any ideas. TIA Azhar Siddiq, DBA LMK Resources -- 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: Peter McLarty INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Build an exact copy of a database using export / import
We use Clones of databases all the time. Its much faster than the Export/import run. We simply take the DB down, copy the data files to a new server in the same file layouts (i.e. ... same directory tree), copy over and change the init file for the new DB name, and bring it up. Then you have to alter the global name. Its a relatively simple process. If there are tablespaces that were in the original one that you do not want over then, at this point, drop any associated objects and drop the tablespaces. -Original Message- Sent: Wednesday, May 30, 2001 11:57 AM To: Multiple recipients of list ORACLE-L Well, depending on the size of the db and some other network stuff, I do the following. I shut down the real db, copy all of the data files, controlfiles and init file to a machine with Oracle on it. Then you can create the service (NT), alter any of the datafiles if necessary (on different logical drive) then you can just bring that bad boy up. Then I just give it a different alias, works for me. However, what do you mean it creates new tablespaces, I have never seen that happen, it just fails miserably for me if the tablespaces don't exist. You could do the full export, create a new user on the new machine and grant become any user to the new user. I believe that then the import would work, I've done it before. Sorry I don't have more, brain is still a littel soft from the weekend. Kev -Original Message- L. Sent: Wednesday, May 30, 2001 12:26 PM To: Multiple recipients of list ORACLE-L When I build a new test database I create the database and run all the required Oracle scripts. Then I do a full import of a production export. This works pretty well but I miss some of the grants and The full import wants to create tablespaces that I may or may not want created. I get a lot of errors on system objects. Does anyone have the proper steps to create an exact copy of a production database using export / import? Thanks! Ron Smith Database Administration [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Effective Living
Actually, I think following the Tao has more to do with being true, i.e. being who you are, which also naturally meshes with where nature is heading. Similar to other religions that tell you that if you follow certain precepts, you will be purer and therefore will be closer to heaven, God, whatever. Otherwise you are living in sin, which actually means off the mark, like an arrow that misses its target. Asking why is good if it brings back to your self, but if you are asking why and speculating ad nauseam you are off on a tangent. Like that inner chatter we sometimes hear in our heads. That instructor was Austrian, by the way, about fifty to fifty-five years old when I took that course, which was over ten years ago. So perhaps he went through WW2 when he was a child, who knows. I am also biased, being son of two psychologists, I don't like social workers all that much precisely because they don't like to take societal context into account. Mind you a lot of psychologists and psychiatrists do the same thing, ignore the context and just try to make the better better adjusted - ha ha Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, May 30, 2001 3:37 PM To: Multiple recipients of list ORACLE-L Subject:OT: Effective Living Isn't that sort of like Taoism? Accept your lot, there must be good in it somewhere... Also, it seems to be the basis of many major religions to essentially never ask why. So, I guess it's a pretty popular philosophy. (Oh no, I feel a discourse by Eric coming on...) 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] Kevin Kostyszyn To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] kevin@dulciacc: n.com Fax to: Sent by: Subject: RE: root@fatcity. com 05/30/2001 11:02 AM Please respond to ORACLE-L This person was actually allowed to teach. Never ask why, yes that's a super philosophy on life. -Original Message- Patrice J Sent: Wednesday, May 30, 2001 8:31 AM To: Multiple recipients of list ORACLE-L That's a laugh, I went to a continuing education seminar once at Carleton University, in Ottawa. The seminar was called Effective Living. The teacher was a social worker, and he emphatically told everyone NEVER to ask why, just adapt to life and keep moving... I had unreconcilable disagreements with him, I guess I don't know how to live. : ) Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- From: Don Granaman [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, May 29, 2001 4:11 PM To: Multiple recipients of list ORACLE-L Subject: Re: when? But, more important, WHY??? -Don Granaman [certifiable OraSaurus] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, May 29, 2001 1:28 PM And Where. Terry Boivin, Patrice J wrote: When and how Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- From: Kevin Kostyszyn [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, May 29, 2001 1:41 PM To: Multiple recipients of list ORACLE-L Subject:RE: what -Original Message- Andrea Sent: Tuesday, May 29, 2001 11:47 AM To: Multiple recipients of list ORACLE-L who
OT (communities of practice) listserv - forum facilitation FAQ
Bruce, Jared folks, See below for the info I was looking for yesterday (I gave you the wrong site, sorry). regards, ep cc: [EMAIL PROTECTED] http://www.co-i-l.com/coil/knowledge-garden/vcfaq/facfaq1.shtml version 0.9 FAQ Editor: George Pór About this FAQ When and why forums have to be facilitated? What are the main roles and responsibilities in facilitating forums? System Administrator Account Administrator Forum Convener Community Architect Moderator Content Facilitator Cybrarian About this FAQ Most of the roles and responsibilities described in this FAQ are part of a new kind of work with no ready-made job-descriptions. The responses are definitely not definitive; they will change as our understanding of the requirements for effectively facilitating virtual communities will deepen through the feedback from, and collaboration with facilitators reading and contributing to this FAQ. When and why forums have to be facilitated? Facilitate = make easy, promote, help forward action or result. (Oxford Dictionary) Online facilitators or hosts are the primary enablers of any virtual community. It is their enthusiasm and attention to the participants challenges in communicating and collaborating in cyberspace, that can make or brake fledgling online communities. Without their efforts it is difficult to build momentum, maintain the flow and generate the activity that will help to ensure return visits. (Denham Grey) Developing competence in facilitating the electronic meeting of minds that takes place in forums is a must in companies that want to turn the web tools and methods of coordination into a strategic advantage to achieve breakthrough results. The number of required facilitative functions is raising along the following continuum: Communities of interest (hobby groups) -- communities of practice (professional communities) -- communities of commitment (teams, taskforces, work groups). What are the main roles and responsibilities in facilitating forums? Responsibilities outlined under the following roles can be assumed by one or a few individuals in small virtual communities. In larger communities, they are divided among the participants of the facilitation team. System Administrator Participates in the administration of the server Contributes suggestions and implements software-related measures for maximizing uptime Maintains software integrity and forum security Provides other participants of the facilitation team and users with technical support Account Administrator Implements access privileges Issues or confirms user names and passwords in password-protected forums Forum Convener Forum Convener, sometimes also called chairperson, is a function of someone who has a major stake in the forums outcome(s), typically performed in task-oriented virtual communities. Community Architect Optimizes the community's structure and design to help it meet its purpose Using the appropriate combination of groupware features, designs virtual spaces to meet specific community functions Drafts guidelines for forum community norms (community covenant) Writes and edits user agreements Designs the structure of initial topics Seeds topics with context-setting materials Designs strategy and mechanisms for collecting and incorporating feedback from participants Moderator The moderator, also called host or organizer: Participates in the preliminary planning of the forum with the sysadmin, convener, and community architect Welcomes and acknowledges participants Stimulates participation and sustains interest Facilitates a healthy group dynamics conducive to higher quality contributions and achieving objectives in task-oriented forums Keeps the conversation focused on the purpose of the forum Provides pointers to sources of user support Models behaviors of effective communication and collaboration Provides closure: in task-oriented forums, s/he declares the forum or any topics of it closed, when its function is complete Content Facilitator
RE: backspace in Oracle.
Kim, Did you hear the one about the NT box that ran for SEVEN YEARS, playing solitaire? Yea, me neither, but it's a good story, just like the Novell one. :) || -Original Message- || From: Kimberly Smith [mailto:[EMAIL PROTECTED]] || Sent: Wednesday, May 30, 2001 12:36 PM || To: Multiple recipients of list ORACLE-L || Subject: RE: backspace in Oracle. || || || Ya, but I can keep a NT box for a long time to, if I don't touch it. || || || -Original Message- || Sent: Wednesday, May 30, 2001 6:01 AM || To: Multiple recipients of list ORACLE-L || || || I have built Novell boxes that have 2100+ days of uptime :) || || Now that is stability that I have yet to see even unix have. || Granted it is only Novell 3.12. || || || Walking on water and developing software from a || specification are easy if || both are frozen. || || Christopher R. Spence || Oracle DBA || Fuelspot || || || || -Original Message- || [mailto:[EMAIL PROTECTED]] || Sent: Sunday, May 27, 2001 8:10 PM || To: Multiple recipients of list ORACLE-L || || || Jared, || || I have an NT 4 server up for 242 days. || || Someone where I work suggested it should be sent to Microsoft for an || examination (must be something wrong with it). || || Regards, || Bruce || || -Original Message- || Sent: Saturday, 26 May 2001 12:16 || To: Multiple recipients of list ORACLE-L || || || On Friday 25 May 2001 18:26, Weaver, Walt wrote: || Ditto. I support Jared's backspace claims 100%, and I || don't think he || should || be removed from the list. || || I sure appreciate that Walt! || || I've heard there are other operating systems out there || besides Linux and || Solaris. Is this true? || || A nasty rumor. There's an upstart startup in WA that claims to have || something akin to an OS, but it keeps failing the 30 day || stability test. || || Jared || || || -- || Please see the official ORACLE-L FAQ: http://www.orafaq.com || -- || Author: Jared Still || INET: [EMAIL PROTECTED] || || Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 || San Diego, California-- Public Internet access / || Mailing Lists || || To REMOVE yourself from this mailing list, send an E-Mail message || to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in || the message BODY, include a line containing: UNSUB ORACLE-L || (or the name of mailing list you want to be removed from). You may || also send the HELP command for other information (like subscribing). || -- || Please see the official ORACLE-L FAQ: http://www.orafaq.com || -- || Author: 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). || -- || Please see the official ORACLE-L FAQ: http://www.orafaq.com || -- || Author: Christopher Spence || INET: [EMAIL PROTECTED] || || Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 || San Diego, California-- Public Internet access / || Mailing Lists || || To REMOVE yourself from this mailing list, send an E-Mail message || to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in || the message BODY, include a line containing: UNSUB ORACLE-L || (or the name of mailing list you want to be removed from). You may || also send the HELP command for other information (like subscribing). || -- || Please see the official ORACLE-L FAQ: http://www.orafaq.com || -- || Author: 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). || -- 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
RE: Your views on Quest - Shareplex
Title: RE: Your views on Quest - Shareplex -Original Message- From: MacGregor, Ian A. [mailto:[EMAIL PROTECTED]] We are looking into the product as well, but have yet to even toy with the product. There is a no chained rows restriction. I'm not sure what that statement means. Shareplex will replicate a table that has chained rows. Shareplex does not replicate transactions on sys objects. A table dropped on one side will not be dropped on the other. It apparently will replicate truncates however. It's one thing to read the logs and to find the time when a truncate caused writes to the data dictionary, but quite another to reconstruct the statement. Statement from a developer of Shareplex: Interesting statement as this is how we replicate DML. Providing functionality for DDL is not at all impossible for us. It is just one of the things on the list of enhancements that we plan for SharePlex, the priority of which is dependent on the market. Let me relate my personal experience working with Shareplex (BEFORE I was an employee with Quest Software). At a previous company we were looking for a replication tool at a company that did payroll taxes. There were large batch loads (bank records) every night, but especially at the end of each quarter and at the end of the year. We wanted to ensure that the replication tool we chose would be fast enough to keep up with the large data loads. When we tested Oracle Replication and Quest Shareplex, we found that Shareplex was significantly faster. I personally argued against it initially for some of the reasons posters here have mentioned (e.g. it uses unsupported means to accomplish its goal) but eventually we implemented Shareplex and were satisfied with the result. There can be some manual effort involved in reconciliation of discrepancies but we found that effort to be minor. Another factor that influenced our decision is that we were intending to use Shareplex for Oracle in conjunction with Shareplex FS to replicate datafiles created on the HP-UX server. -- Jacques R. Kilchoer (949) 754-8816 Quest Software, Inc. 8001 Irvine Center Drive Irvine, California 92618 U.S.A. http://www.quest.com
Re: PL/SQL Error
I think the error is in the call to the procedure, not in the procedure itself -- the procedure looks fine at a glance. Could you post the ASP code that makes the call? 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] Bartolo, David To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] bartolo@USCOcc: LO.edu Fax to: Sent by: Subject: PL/SQL Error root@fatcity. com 05/30/2001 01:06 PM Please respond to ORACLE-L Hi all Can someone help me out here? I am getting this error when I try to run this PL/SQL code from an ASP page. The error manual just says to check speeling. I DID. Is there anything I am missing? The DB is V7.3 I am trying to return the resultset to the page. PLS-00306: wrong number or types of arguments in call to 'COURSE_SELECT' Here is the PL/SQL code create or replace package course.course_bulletin is TYPE tbl_call_no IS TABLE of cmcmcrst.call_no%type INDEX BY BINARY_INTEGER; TYPE tbl_schl_cd IS TABLE of cmcmcrst.schl_cd%type INDEX BY BINARY_INTEGER; TYPE tbl_dept_cd IS TABLE of cmcmcrst.dept_cd%type INDEX BY BINARY_INTEGER; PROCEDURE course_select(i_ccyy IN NUMBER, o_call_no OUT tbl_call_no, o_schl_cd OUT tbl_schl_cd, o_dept_cd OUT tbl_dept_cd); end; create or replace package body course.course_bulletin as PROCEDURE course_select(i_ccyy IN NUMBER, o_call_no OUT tbl_call_no, o_schl_cd OUT tbl_schl_cd, o_dept_cd OUT tbl_dept_cd) IS CURSOR c1 is SELECT call_no,schl_cd,dept_cd FROM COURSE.cmcmcrst WHERE ccyy = i_ccyy AND term_cd = '2' AND instrl_cd = '0'; crscount NUMBER DEFAULT 1; BEGIN FOR c IN c1 LOOP o_call_no(crscount) := c.call_no; o_schl_cd(crscount) := c.schl_cd; o_dept_cd(crscount) := c.dept_cd; crscount := crscount + 1; END LOOP; END; end; -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bartolo, David INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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
RE: random equipment seen ???/ RE: V$SESSION.OSUSER returns NT-D
http://www.cfainc.org/breeds/profiles/articles/maine.html ---excerpt--- The Maine Coon Standard The Maine Coon Cat is a massive, broad chested cat with a long rectangular body and the fur is long and flowing. The males average around 12 to 15 pounds, with some going 20 pounds or more. The females are smaller, averaging 9 to 12 pounds. ... The Maine Coon is slow to mature, often not reaching full development until three to four years of age. ... The Maine Coon is a gentle, loyal breed. They make wonderful family pets and get along well with children and dogs. Depending on the breed of dog, the Maine Coon can be bigger than Fido. They are a vocal breed, with a variety of meows, trills and chirps to make up their vocabularies. They are sociable and like to help their owners with any project, especially when the owner is reading or working on the crossword puzzle. Since 1976, the Maine Coon Cat has been a rising star in the competitive reaches of the cat fancy. This popular breed of the late 19th century drifted into obscurity and imagined extinction well into the 1950s. Those of us who now work with and breed the Maine Coon owe a tremendous THANK YOU to those who worked and fought for recognition and the championship status we enjoy today. As any exhibitor can tell you, spectators can often be seen watching the Maine Coons being judged, exclaiming at the size, and even saying they have one or two like them at home - today, they probably do. The Maine Coon is the second most popular cat in CFA as seen by the numbers of kittens registered. America's first show cat is back, bigger and better than ever. ---end--- On 30 May 2001, at 6:56, Christopher Spence wrote: Date sent: Wed, 30 May 2001 06:56:50 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] mainekoon cats. Almost as big as dogs ... ... -- 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: Script examples for NT. (yuk!)
You can download CyGWin from Redhat for free that will give you a very nice cloned shell of linux environment, full compatable with Bash/Sh scripting. Wish i could find a ksh shell for it, but it has ALOT of the tools normally available with Unix. ps, kill, grep, tail, head, piping, shell scripts. I will generally write scripts in it and move it to unix with no compatibility problems. Exact url: http://sources.redhat.com/cygwin/ There are many other unix clones for NT, some are great, some are simily a directory with clone commands in it. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Wednesday, May 30, 2001 9:26 AM To: Multiple recipients of list ORACLE-L Quick question.. ALL of my experience has been on UNIX platforms... Recently, I have been asked to work on an Oracle DB that runs on NT.. My scripting capability in the NT world is weak at best. So I am trying to compare ksh type activities with the NT world. SO I was wondering if any of you would mind sharing a couple of NT type scripts with me.. For example-setting variables to the return of a SQL statement to be used in the shell,etc... Any help would be appreciated.. TIA Greg Loughmiller mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Loughmiller, Greg INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OEM Book Recommendation
Rahul ! I have not seen any **books** on OEM. But you can check in to OLN (!!) Oracle Learning Network and there are some classes on OEM. = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Performance tuning
No to be overly pedantic, but RAID5 does not change the number of write() calls made by DBWR. It will change the number of disk operations done by your hardware controller or your software raid drivers, but that's slightly different. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, May 30, 2001 2:02 PM Raid 5 can consume as much as 60% overhead for writes. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Wednesday, May 30, 2001 12:51 PM To: Multiple recipients of list ORACLE-L John, have you read Cary Millsap's paper on RAID 5? www.hotsos.com I believe. RAID 5 will require additional writes by DBWR which is going to be huge overhead during a dataload. - Ethan Post -Original Message- Sent: Wednesday, May 30, 2001 6:51 AM To: Multiple recipients of list ORACLE-L 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. Peter McLarty wrote Are you running RAID and if so what configuration. (Not RAID 5 I hope) Interesting. I am posting an excerpt from Doc 97597.1 Optimising Raid performance for Oracle RDBMS on NT RAID 5 is useful for Oracle datafiles but not for redo log files or rollback segments which are sequentially accessed. Datafiles belonging to the temporary tablespace are not suitable for a RAID 5 device. More benefits will be seen in situations where reads predominate over writes. I know that in this instance it is a data load that is being discussed but presumably once the data is loaded then it will be read more than once. Certainly the tone of the note suggests that raid 5 is not a definite no-no rather a 'be cautious as to which files are placed where'. It is my belief that often a single raid level is set for all files rather than a mix of raid 1 and raid 5 as appropriate. Peter, I fully agree that the level of memory utilised here is totally insufficient and is very likely to be the constraining factor in this case. John -- -- -- This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you have received this message in error, please inform us promptly by reply e-mail, then delete the e-mail and destroy any printed copy. Thank you. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: George Schlossnagle INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Effective Living
Yeah, but just because something is popular doesn't meen it is good. If we all lived our lives that way everyday I am not so sure we would get much accomplished? Oh no, the Database is down!! Why? I don't know, who cares. hehehe -Original Message- [EMAIL PROTECTED] Sent: Wednesday, May 30, 2001 2:37 PM To: Multiple recipients of list ORACLE-L Isn't that sort of like Taoism? Accept your lot, there must be good in it somewhere... Also, it seems to be the basis of many major religions to essentially never ask why. So, I guess it's a pretty popular philosophy. (Oh no, I feel a discourse by Eric coming on...) 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] Kevin Kostyszyn To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] kevin@dulciacc: n.com Fax to: Sent by: Subject: RE: root@fatcity. com 05/30/2001 11:02 AM Please respond to ORACLE-L This person was actually allowed to teach. Never ask why, yes that's a super philosophy on life. -Original Message- Patrice J Sent: Wednesday, May 30, 2001 8:31 AM To: Multiple recipients of list ORACLE-L That's a laugh, I went to a continuing education seminar once at Carleton University, in Ottawa. The seminar was called Effective Living. The teacher was a social worker, and he emphatically told everyone NEVER to ask why, just adapt to life and keep moving... I had unreconcilable disagreements with him, I guess I don't know how to live. : ) Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- From: Don Granaman [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, May 29, 2001 4:11 PM To: Multiple recipients of list ORACLE-L Subject: Re: when? But, more important, WHY??? -Don Granaman [certifiable OraSaurus] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, May 29, 2001 1:28 PM And Where. Terry Boivin, Patrice J wrote: When and how Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- From: Kevin Kostyszyn [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, May 29, 2001 1:41 PM To: Multiple recipients of list ORACLE-L Subject:RE: what -Original Message- Andrea Sent: Tuesday, May 29, 2001 11:47 AM To: Multiple recipients of list ORACLE-L who -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Quaglio Andrea INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Kevin Kostyszyn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include
RE: Performance tuning
I don't know what is causing this, but I would keep an eye on physical memory available vs. commit charge in Task Manager, I strongly recommend your commit charge never exceed your physical memory. I found that Oracle sometimes refuses to even start services when it runs out of physical memory, it doesn't like virtual memory very much. Shrinking the size of your SGA is preferable to exceeding the available physical memory, in my opinion. Keep in mind session memory space in your calculations, and the other programs you may be running on your machine. I recommend you stop all the services (in Services applet) that you dare stop, to lighten the load. In the virtual memory settings, allocate the amount you want, but try to avoid a range of values - when initial and max size values are different NT keeps polling the pagefile and memory statistics to figure out if the pagefile should grow or shrink. Better to do that manually up front, allocate at set amount. NT then stops doing extra work regarding memory allocation. Every little bit helps. I haven't used SQL*Loader, so I can't say much about that, except... when you start loading those first few rows, what does Commit Charge look like in Task Manager? Is it growing? If it is, notice how slowly NT does this. It can't be helped. If commit charge approaches physical memory available, you will hit a ceiling I think. Then things may well slow down to a crawl. Is there a buffer size you can set for SQL*Loader? I always set my exp buffer size to 100 to speed it up. Maybe you can do the same for SQL*Loader. That must use more memory though. Can you commit every few records? Could it be every 10 rows? Would it be better not to commit too often? As mentioned before, RAID 5 will prove slower than simple disk or RAID 01 or RAID 10. Do you have many indexes on the tables you are filling up? You may want to drop them and re-create them once the load is finished. This may sound silly but... do you have a virus checking program running on your server? Try to exclude the oradata directories from it. Just some ideas. That's what I would check first. If your RBS segments filled up, you would see an error somewhere, it seems to me. Is TEMP filling up? You never know. Oh another probably silly thing - if you are not using SCSI, download DMACheck from microsoft and test whether your DMA is turned on. That would speed up your disk by 40% or more. Servers use SCSI disks normally though, but sometimes people install Oracle on PCs or workstations with IDE drives. 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] HI ALL, We have to load almost 3 millions records of average row size of 150 bytes. We are importing data using sqloader with ROWS=4000 and bindsize=845 . We have adjusted the rollback segment to almost 10 m with 8 extents enough for single transaction size and considering 30% rollback overhead. We adjusted the OPTIMAL TO 10 M to have avoid rollback extension Rollback segment, databuffer cache have hit ratio of 100%. The loading was fast only for first 10 commits but then it slowed like snail. LOADING TOOK 22 hours in the first run on ORACLE8i NT4 128 megs RAM . SGA figures in M : NAME VALUE - Fixed Size.0676384 Variable Size239.02734 Database Buffers 39.0625 Redo Buffers 7.8203125 - sum 285.97779 ( we can't use direct path due to functions in sqlldr controlfile). . Couldn't figure out the bottleneck yet. Any ideas. TIA Azhar Siddiq, DBA LMK Resources -- 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 --
Re: OT: Archiving not possible with SQL Server?
And thus you discover the inane mechanism that SQL Server inherited from Sybase, by which both try to do concurrency. Guess what happens when a long running transaction marks the log near the end, and not too long afterward the log needs truncated? If memory serves, ( hasn't worked too well lately :) the database will hang. It may just truncate back to the mark, and start from there, but you always have the possibility of another long transaction starting. Can't remember the details, but what I do remember clearly is that it is a process that has to be closely watched, and I didn't particularly care for the way it worked. Jared On Wednesday 30 May 2001 11:41, Gary Weber wrote: Halo, Windoz 2000/SQL Server 2000 Bringing an axuliary MS SQL db online. Trying to setup archiving. Am I reading documentation right, SQL does NOT automatically archive transaction log? This process must be setup via backup routine, which truncates the log upon completion? Lemme try some logic: Oracle's redo logs = MS transaction log(s) Oracle's archived logs = ? Gary Weber Senior DBA Charles Jones, LLC 609-530-1144, ext 5529 -- 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).