Re: * I'm Looking for an Oracle Financials DBA for Miami, Florida..
Gregory Conron schrieb: On June 16, 2001 04:35 am, Jared Still wrote: Many of us consider this a service, especially the way that jobs are at the moment. Amazing the difference a year can make, eh? Hi Just curious: How bad is the job situation in the US right now ? I'm wondering since we consider moving there (my wife is american). | Regards, | | Stefan Jahnke | | BOV AG | | @:D2 Vodafone, Abt.: FIBM | -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stefan Jahnke INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fw:
Hi List Members, I wonderif preceding ORACLE-L messages are kept.How can I reachall messages that have been sent to the list up to now? BURCIN USTUN KILIC
How to size db_block_size?
Dear All, Is there a recommended approach on how to decide on the db_block_size for your database? I am looking to create a database that during the day will be used for light OLTP, but during the day and night will have heavish batch jobs. Therefore I was intent on using 8k or 16k blocks. Most likely 8k blocks. But is there an approach to actually chosing the correct db_block_size? Cheers for any help in advance. Justin _ 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: Justin Coleman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE:
What I mean is our database can not startup anymore...some datafiles are missing.. m-t-x Our greatest glory is not in never falling but in rising every time we fall -Original Message- Sent: Tuesday, June 19, 2001 11:57 AM To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]' A broken database ??? Dear Hermanto, more details would really help... -- From: Hermanto P[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Tuesday, June 19, 2001 12:40 PM To: Multiple recipients of list ORACLE-L Dear Subscribers, I have a broken database that I wish to recover. The old database come from other SID Could you please help me how to recover ? m-t-x Our greatest glory is not in never falling but in rising every time we fall -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hermanto P INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Hermanto P INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 Rajesh, The part of broken database is datafiles (data-datafile and control-file). It caused by immediate shutdown from electricity consumption. And affect the database (corrupted). We have online backup..including archive log. OS = HP-UX tester B.10.20 E 9000/802 1414693381 8-user license. Thanks before.. m-t-x Our greatest glory is not in never falling but in rising every time we fall -Original Message- Sent: Tuesday, June 19, 2001 01:30 PM To: Multiple recipients of list ORACLE-L We appreciate your quote m-t-x Our greatest glory is not in never falling but in rising every time we fall But would appreciate more if you could provide details of broken database, e.g. -- What part of database is broken (control file, online redolog file, data-datafile, temp-datafile, rbs-datafile). -- What was the cause of failure -- What kind of backups you have( If you have any) -- OS and version details HTH, Rajesh OC DBA (8 8i) -Original Message- Sent: Tuesday, June 19, 2001 9:40 AM To: Multiple recipients of list ORACLE-L Dear Subscribers, I have a broken database that I wish to recover. The old database come from other SID Could you please help me how to recover ? m-t-x Our greatest glory is not in never falling but in rising every time we fall -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hermanto P INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hermanto P INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: NT Script
Hi, If you spool the files from sqlplus you can add the following lines of code column datum new_value datum noprint select to_char(sysdate,'ddmm') datum from dual; spool file_name_datum..lst Jack Kevin Kostyszyn To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] kevin@dulcian cc: .comSubject: NT Script Sent by: [EMAIL PROTECTED] om 18-06-2001 19:12 Please respond to ORACLE-L Hello all, I know, I know, NT. Anyway, I was wondering if anyone knew how to append the system date to a file created through a script. Basically, what I want to do is have files set up to run exports every night, however, I need to be able to appened the system date to the file when it is created so I don't just over write the file that was created the night before. Does anyone know how to do this, it would be greatly appreciated!! Sincerely, Kevin Kostyszyn DBA Dulcian, Inc www.dulcian.com [EMAIL PROTECTED] -- 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). = 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,
RE: JDeveloper Connection to Oracle DB
Hi Alex, I am relatively new to the world of Oracle so I would appreciate it if you could elaborate more on the subject. I downloaded a jdbc driver from oracle.com but I am not sure where to place it or how to use it. I tried to use the Oracle JDBC OCI-8 driver type when creating the connection from JDeveloper but I kept on getting the following error: no ocijdbc8 in java.library.path. I would appreciate any help in my situation. Elias S. Mouchantaf Tel. (+961) 3 740319 [EMAIL PROTECTED] www.moshnet.com Quoting Hillman, Alex [EMAIL PROTECTED]: JDBC thin driver does not use Net8. Another JDBC driver uses Net8 - OCI calls. Alex Hillman -Original Message- Sent: Saturday, June 16, 2001 5:00 PM To: Multiple recipients of list ORACLE-L Elias, I don't know much about JDBC, but I suspect that like ODBC it sits on top of the Net8 layer. By default, Personal Oracle on Win95/98 doesn't automatically start the listener the way the TNSlistener service does on NT/Win2K, so try manually starting the listener from the command prompt: lsnrctl start You can set the listener to start up up automatically by changing the registry entry LISTENER_STARTUP to AUTO hkey_local_machine\oracle\home0 HTH, -- Anita --- Elias Mouchantaf [EMAIL PROTECTED] wrote: Hi, I have installed JDeveloper 3.0 and I am running Oracle 8i personal edition on a Windows 98 platform. I am trying to create a connection to the DB from JDeveloper. I specify the Oracle JDBC Thin as driver and I select Existing TNS Names as the connection method and I choose the service running. When I click on the Test Connection button I get an error message that reads: Io Exception: The Network adapter could not establish the connection. I tried to resolve the problem but was unable to. I would appreciate any help. Thank you, Elias S. Mouchantaf Tel. (+961) 3 740319 [EMAIL PROTECTED] www.moshnet.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Elias Mouchantaf INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists -- -- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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!? Spot the hottest trends in music, movies, and more. http://buzz.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: 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: Elias Mouchantaf INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 size db_block_size?
Title: RE: How to size db_block_size? Hi Justin, A larger data block size provides greater efficiency in disk and memory I/O (access and storage of data). Such cases include: a) Oracle is on a large computer system with a large amount of memory and fast disk drives. For example, databases controlled by mainframe computers with vast hardware resources typically use a data block size of 4K or greater. b) The operating system that runs Oracle uses a small operating system block size. For example, if the operating system block size is 1K and the data block size matches this, Oracle may be performing an excessive amount of disk I/O during normal operation. For best performance in this case, a database block should consist of multiple operating system blocks. Hope that this would helps you. Nirmal. -Original Message- From: Justin Coleman [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, June 19, 2001 10:06 AM To: Multiple recipients of list ORACLE-L Subject: How to size db_block_size? Dear All, Is there a recommended approach on how to decide on the db_block_size for your database? I am looking to create a database that during the day will be used for light OLTP, but during the day and night will have heavish batch jobs. Therefore I was intent on using 8k or 16k blocks. Most likely 8k blocks. But is there an approach to actually chosing the correct db_block_size? Cheers for any help in advance. Justin _ 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: Justin Coleman INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 find the size of all the tables under a particular schema using vsize
Dear DBA Gurus, I need to find the size of one row of all the tables under a particular schema using vsize clause. How do I do this? Please help. 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).
Re: Export from sql plus
Hi, set colsep ';' (or whatever you want) set pages 0 (to avoid headers) set lines 2000 (or at least high enough) set trimspool on (trims trailing blanks while spooling) spool output.lst select * from table; spool off Mark Liggayu markliggayu@allweatherwi To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ndows.com cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Sent by: [EMAIL PROTECTED] Subject: Export from sql plus 19-06-2001 00:10 Please respond to ORACLE-L Is it possible to export the whole content of a table to a file. If is it , what is the command to do this? Thanks, Mark -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Liggayu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 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
How to find the table size?
Dear DBA Gurus, Assume I have an emp table under Scott Schema with the following structure. Name Null?Type - - --- EMPNO NOT NULL NUMBER(4) ENAMEVARCHAR2(10) JOBVARCHAR2(9) MGRNUMBER(4) HIREDATE DATE SALNUMBER(7,2) COMM NUMBER(7,2) DEPTNO NUMBER(2) I need to calculate the size of the table assuming one of the rows is having all the columns maxsize possible. Say, 4+10+9+4+7+7+7+2=50. I need to do this for all the tables under a particular schema. How do I do this using Sql or Pl/Sql? Any help in this regard will be very much appreciated. 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).
RE: How to size db_block_size?
Well, you'd want your database block size to be an integer multiple of your file system block size, to minimize I/O, because Oracle reads and writes in blocks, if there is any overlap that means you are using an file system level I/O for a partial block. I remember hearing that Oracle were recommending a block size of 8k for almost everything now. It used to be that one would select a block size of 2k or 4k for OLTP and 8 or 16k for DSS. g. -Original Message- Sent: 19 June 2001 08:06 To: Multiple recipients of list ORACLE-L Dear All, Is there a recommended approach on how to decide on the db_block_size for your database? I am looking to create a database that during the day will be used for light OLTP, but during the day and night will have heavish batch jobs. Therefore I was intent on using 8k or 16k blocks. Most likely 8k blocks. But is there an approach to actually chosing the correct db_block_size? Cheers for any help in advance. Justin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 size db_block_size?
http://www.ixora.com.au/tips/creation/block_size.htm provides a good explanation of how and why to select a large db block size// -- From: Nirmal Kumar Muthu Kumaran[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Tuesday, June 19, 2001 3:30 PM To: Multiple recipients of list ORACLE-L Subject: RE: How to size db_block_size? Hi Justin, A larger data block size provides greater efficiency in disk and memory I/O (access and storage of data). Such cases include: a) Oracle is on a large computer system with a large amount of memory and fast disk drives. For example, databases controlled by mainframe computers with vast hardware resources typically use a data block size of 4K or greater. b) The operating system that runs Oracle uses a small operating system block size. For example, if the operating system block size is 1K and the data block size matches this, Oracle may be performing an excessive amount of disk I/O during normal operation. For best performance in this case, a database block should consist of multiple operating system blocks. Hope that this would helps you. Nirmal. -Original Message- From: Justin Coleman [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, June 19, 2001 10:06 AM To: Multiple recipients of list ORACLE-L Subject:How to size db_block_size? Dear All, Is there a recommended approach on how to decide on the db_block_size for your database? I am looking to create a database that during the day will be used for light OLTP, but during the day and night will have heavish batch jobs. Therefore I was intent on using 8k or 16k blocks. Most likely 8k blocks. But is there an approach to actually chosing the correct db_block_size? Cheers for any help in advance. Justin _ 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: Justin Coleman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 size db_block_size?
Title: RE: How to size db_block_size? Hi all, just want to ask, How do we know the OS Block size from our system ? We use Sun Solaris 2.7 any command to show OS Block Size ? Thanks Regards Herman - Original Message - From: Nirmal Kumar Muthu Kumaran To: Multiple recipients of list ORACLE-L Sent: Tuesday, June 19, 2001 4:30 PM Subject: RE: How to size db_block_size? Hi Justin, A larger data block size provides greater efficiency in disk and memory I/O (access and storage of data). Such cases include: a) Oracle is on a large computer system with a large amount of memory and fast disk drives. For example, databases controlled by mainframe computers with vast hardware resources typically use a data block size of 4K or greater. b) The operating system that runs Oracle uses a small operating system block size. For example, if the operating system block size is 1K and the data block size matches this, Oracle may be performing an excessive amount of disk I/O during normal operation. For best performance in this case, a database block should consist of multiple operating system blocks. Hope that this would helps you. Nirmal. -Original Message- From: Justin Coleman [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, June 19, 2001 10:06 AM To: Multiple recipients of list ORACLE-L Subject: How to size db_block_size? Dear All, Is there a recommended approach on how to decide on the db_block_size for your database? I am looking to create a database that during the day will be used for light OLTP, but during the day and night will have heavish batch jobs. Therefore I was intent on using 8k or 16k blocks. Most likely 8k blocks. But is there an approach to actually chosing the correct db_block_size? Cheers for any help in advance. Justin _ 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: Justin Coleman INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
create DBA user need help...
Hi all, I recreated DBA role that provided by Oracle8i, 1. Create New_DBA_role identified by change_me; 2. Select 'GRANT ' || privilege || ' TO new_dba_role' FROM dba_sys_privs; Create new dba user 3.Create user new_dba identified by password default tablespace userdata quota unlimited on userdata ; 4. GRANT SYSDBA TO new_dba; What other privilege or role that I need so that I am able to shutdown and startup database. I am using OS authentication method. Best Regards Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
ftp
Hi Someone posted the address of the oracle ftp site a while back. As I've forgotten it, could they repost it. TIA David Lord Senior DBA, Hays Commercial Services, IT Solutions ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lord 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).
Ynt: SQL Trace ( Perl script help needed)
hello Siva, You can concatenate raw SQL_TRACE files as a single file, then upload this file to itrprof. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, June 19, 2001 2:30 AM Hello Gurus, I was trying to pull distinct sql's and their total execute count from a bunch of 250 trace output files(output from tkprof trace files). How can I achive this. What i need the cumulative sum of execute count from different files for each sql's. As u all know sql can extend more than one line so ! I know this can be handled using perl script. file1.prf . select * from tablename1 where col1=:1 and col2=:2 call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse5 0.00 0.00 0 0 0 0 Execute 5 0.02 0.02 0600 0 0 Fetch5 0.00 0.00 0 0 0 0 --- -- -- -- -- -- -- total 15 0.02 0.02 0600 0 0 ... select * from tablename2 where col1=:1 and col2=:2 call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse5 0.00 0.00 0 0 0 0 Execute 5 0.02 0.02 0600 0 0 Fetch5 0.00 0.00 0 0 0 0 --- -- -- -- -- -- -- total 15 0.02 0.02 0600 0 0 file2.prf select * from tablename1 where col1=:1 and col2=:2 call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse5 0.00 0.00 0 0 0 0 Execute 5 0.02 0.02 0600 0 0 Fetch5 0.00 0.00 0 0 0 0 --- -- -- -- -- -- -- total 15 0.02 0.02 0600 0 0 select * from tablename3 where col1=:1 and col2=:2 call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse5 0.00 0.00 0 0 0 0 Execute 5 0.02 0.02 0600 0 0 Fetch5 0.00 0.00 0 0 0 0 --- -- -- -- -- -- -- total 15 0.02 0.02 0600 0 0 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Valiveru, Siva INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: unal-bilisim INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OT RE: 9i On Linux - time to start bashing.
Then there's our good friends at Siebel, who are telling us Yes, we do say 96M for the PC client in the manual, but we really mean 256M, and 512M ideally Hello ? Earth to Siebel ? --- Mohan, Ross [EMAIL PROTECTED] wrote: Well, maybe I am smoking crack, but Win2K Pro is running dandily on my 266 MHz, 96 MB RAM laptop. Couldn't be happier with it. -Original Message- Sent: Friday, June 15, 2001 6:12 PM To: Multiple recipients of list ORACLE-L I think that 192 MB makes sense - as MS definitely wants 128 MB just to get Windows 2000 Pro up. Services like Remote Registry Service and License Logging need lots of RAM. :) (enabled by default) So do SubSeven and BackOrifice2000. -Original Message- Sent: Friday, June 15, 2001 6:00 PM To: Multiple recipients of list ORACLE-L A minimum of 128M on the client??!! Who do they think they are?? Microsoft? -Original Message- Sent: Friday, June 15, 2001 3:02 PM To: Multiple recipients of list ORACLE-L From Linux release notes: http://otn.oracle.com/docs/products/oracle9i/pdf/9i_lin_relnotes.pdf The following requirements must be met to perform a typical Oracle9i software installation. Memory: A minimum of 512 MB of is required to install Oracle9i Server. A minimum of 512 MB is required to install Oracle9i Management and Integration. A minimum of 128 MB is required to install Oracle9i Client. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, June 15, 2001 4:20 PM Can any of you just confirm that Oracle 9i requires 500M of memory on Linux? Thank, Waleed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Drake INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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
Re: Size of SYS1ORCL.ORA
Sounds to me like most of your database objects are in SYSTEM tablespace (ie SYS1ORCL.ORA). Try select owner, tablespace_name, count(*) from dba_segments group by owner If you've got lots of things in SYSTEM that are not owned by SYS, SYSTEM then its a) time to fix a lot of this up b) get a consultant/senior DBA to come do a review of your system - there's probably a lot of things that can be improved upon c) glean as much knowledge from them in the process hth connor --- Rok Kodrun [EMAIL PROTECTED] wrote: Hi PLEASE HELP! I have Oracle Workgroup Server 7.3 for Windows NT. How to manage size of database files, when they grow to big? For example, my SYS1ORCL.ORA file has over 376 MB. What to do, to decrease it? I'm running out of disk space and all the user data are on separate tablespace USER_DATA, which has 10MB. The database runs on the machine for couple of years already, without any problems, but we will soon have one - probably. What to do? Rok Kodrun Institute Joef Stefan Ljubljana Slovenia = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to size db_block_size?
Title: RE: How to size db_block_size?
Just one thought.
You check the block size of redolog files using
following
script ( -- Author:Steve
Adams)
select max(l.lebsz)
log_block_sizefrom sys.x$kccle lwhere
l.inst_id = userenv('Instance')/
This would give the OS Block Size. I
am sure someone would
correct me if I am wrong...
Rajesh
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Herman SusantioSent:
Tuesday, June 19, 2001 1:14 PMTo: Multiple recipients of list
ORACLE-LSubject: Re: How to size
db_block_size?
Hi all,
just want to ask,
How do we know the OS Block size from our system
?
We use Sun Solaris 2.7
any command to show OS Block Size ?
Thanks Regards
Herman
- Original Message -
From:
Nirmal Kumar
Muthu Kumaran
To: Multiple
recipients of list ORACLE-L
Sent: Tuesday, June 19, 2001 4:30
PM
Subject: RE: How to size
db_block_size?
Hi Justin,
A larger data block size provides
greater efficiency in disk and memory I/O (access and storage of data). Such
cases include:
a) Oracle is on a large computer
system with a large amount of memory and fast disk drives. For example,
databases controlled by mainframe computers with vast hardware resources
typically use a data block size of 4K or greater.
b) The operating system that runs
Oracle uses a small operating system block size. For example, if the
operating system block size is 1K and the data block size matches this,
Oracle may be performing an excessive amount of disk I/O during normal
operation. For best performance in this case, a database block should
consist of multiple operating system blocks.
Hope that this would helps
you.
Nirmal.
-Original Message- From: Justin Coleman [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, June 19, 2001 10:06 AM To: Multiple recipients of list ORACLE-L Subject: How to size db_block_size?
Dear All,
Is there a recommended approach on how to
decide on the db_block_size for your
database? I am looking to create a database that during the day will
be used for light OLTP, but during the
day and night will have heavish batch jobs. Therefore I was intent on using 8k or 16k blocks.
Most likely 8k blocks. But is
there an approach to actually chosing the correct db_block_size?
Cheers for any help in advance.
Justin
_
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: Justin Coleman
INET:
[EMAIL PROTECTED]
Fat City Network Services --
(858) 538-5051 FAX: (858) 538-5051 San Diego, California --
Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list,
send an E-Mail message to:
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing:
UNSUB ORACLE-L (or the name of mailing
list you want to be removed from). You may also send the HELP command for other information (like
subscribing).
Latchs
Hi folks. I'd like to know about different latchs, wait events and locks. Meaning of willing to wait and immediate ratio and all anothers things in relation with that. Anybody knows about documents, books, notes in Metalink, etc about that?. Thank you very much in advence. Regards. Miguel. Este mensaje y los documentos que, en su caso, lleve anexos, pueden contener información confidencial. Por ello, se informa a quien lo reciba por error que la información contenida en el mismo es reservada y su uso no autorizado está prohibido legalmente, por lo que en tal caso le rogamos que nos lo comunique por la misma vía o por teléfono (901 113 113) , se abstenga de realizar copias del mensaje o remitirlo o entregarlo a otra persona y proceda a borrarlo de inmediato. -- 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: Latchs
the best resource .. http://www.amazon.com/exec/obidos/ASIN/156592598X/ixora/102-4862016-6200168 -- From: [EMAIL PROTECTED][SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Tuesday, June 19, 2001 5:55 PM To: Multiple recipients of list ORACLE-L Subject: Latchs Hi folks. I'd like to know about different latchs, wait events and locks. Meaning of willing to wait and immediate ratio and all anothers things in relation with that. Anybody knows about documents, books, notes in Metalink, etc about that?. Thank you very much in advence. Regards. Miguel. Este mensaje y los documentos que, en su caso, lleve anexos, pueden contener información confidencial. Por ello, se informa a quien lo reciba por error que la información contenida en el mismo es reservada y su uso no autorizado está prohibido legalmente, por lo que en tal caso le rogamos que nos lo comunique por la misma vía o por teléfono (901 113 113) , se abstenga de realizar copias del mensaje o remitirlo o entregarlo a otra persona y proceda a borrarlo de inmediato. -- 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: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
status of oracle 9i install on red hat linux
machine: celeron 450Mhz, 256M of ram, 512M of swap. it installed, yea. Here are the problems: 1. do not even attempt to run the gui tools(dbca, netasst) with the install, it will bomb. 2. none of the binaries will link, just click ignore for all of the errors, we will deal with them later. 3. after you've got the binaries installed: $ORACLE_HOME/bin/genclntsh will need edited. follow instructions for installing 8.1.7 on rh 7.1. I've got the link book marked and for those of you w/o metalink let me know and i can paste the important parts. :) 4. run genclntsh according to the instructions. 5. then attempt relink all, mine errored out, i did a relink of each component, hint: if you type relink by itself it will show you the options. 6. run dbca to build skeleton scripts to build a database. thats as far as i got at 3AM when i went to bed(some 3.5 hours ago), building the database tonite, I'll keep everyone posted. if this all works, i'll be attempting on my 192M laptop :) joe -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: EXPORT questions
Dear Seema, If you take export using sys user you will be exporting the base tables also which is not good when recreating your database from scratch and using import to transfer database accross. To avoid this we use the system user which only exports the views and not the base tables. Regards Seema Singh oracledbam@hoTo: Multiple recipients of list ORACLE-L tmail.com[EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Subject: EXPORT questions om 19-Jun-2001 03:48 AM Please respond to ORACLE-L Sender Info: No Sender Info found in the address Book hi What is diffrent between the full export taken by sys user and system user? Why people prefer the system user to take full export? If any one can take full export with sys user in FGAC case then how to import incase of recovery means from sys user itself likefollowing command. imp userid=sys/chane-on-install file=test.exp fromuser=one touser=one Thanks in advance. -Seema _ 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). __ Visit us at www.singaporeair.com. __ -- 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: ftp
ftp://oracle-ftp.oracle.com ftp://oracle-ftp.oracle.com Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- From: Lord David [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, June 19, 2001 6:47 AM To: Multiple recipients of list ORACLE-L Subject:ftp Hi Someone posted the address of the oracle ftp site a while back. As I've forgotten it, could they repost it. TIA David Lord Senior DBA, Hays Commercial Services, IT Solutions ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lord 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: 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).
smart array 12000
Is there anybody who knows about Smart Array 12000 disks. I need to install datafiles on these disks . Is it a RAID5 system?
Re: Sql*Loader and assign a ROLLBACK segment
Philippe, If you have a large rollback segment that you want to use for a particular operation you can use the SET TRANSACTION USE ROLLBACK SEGMENT xxx command to assign the use of a rollback segment. To make sure you are the only operation using it, set it offline first and wait for the other transactions to finish. then set it online and issue the set transaction command with your function. then set it offline again while it is in use and no other operation will be able to use it. If you set it offline while it is in use the operation using it will continue until completed or inturrupted. ROR mª¿ªm [EMAIL PROTECTED] 06/18/01 08:50PM Hello, I have a sql*loader script which failed due to the non possibility to extend a rollback segment in the TBS ROLLBACK_DATA. Oracle version 8.1.6.2 on AIX 4.3.3. I have a huge rollback segment in the TBS ROLLBACK_DATA, but how tell to sql*loader to use this rollback segment ? I have not found any option to assign a rollback segment in the doc. I just found the UNRECOVERABLE option and i will try with it. Any other ideas, suggestions welcome. Best regards Philippe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ftp
Are you talking about the Metalink ftp site? If so, it is 205.227.44.220 Sign on as anonymous with the password as your email address. -Original Message- Sent: Tuesday, June 19, 2001 5:47 AM To: Multiple recipients of list ORACLE-L Hi Someone posted the address of the oracle ftp site a while back. As I've forgotten it, could they repost it. TIA David Lord Senior DBA, Hays Commercial Services, IT Solutions ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lord 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: Terrian, Tom INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: transfer of large datafile Oracle7.3.4.4 databases to 8.1.7.
Then I strongly encourage you NOT to use the EXTEND clause or the Storage Manager to extend the size of those big files. Instead, if you have to extend them, create a second file. : ) Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- From: Cale, Rick T (Richard) [SMTP:[EMAIL PROTECTED]] Sent: Monday, June 18, 2001 5:55 PM To: Multiple recipients of list ORACLE-L Subject:RE: transfer of large datafile Oracle7.3.4.4 databases to 8.1.7. On NT 4.0, Oracle 8.0.5 2gig filesize is not a limitation of either NTFS or Oracle. I have several datafiles in the 3-5gig size. Rick -Original Message- Sent: Monday, June 18, 2001 4:31 PM To: Multiple recipients of list ORACLE-L 8.1.7. Just make sure , when you do this, that your max_datafile parameter on the Database is set high enough. -Original Message- Sent: Monday, June 18, 2001 12:51 PM To: Multiple recipients of list ORACLE-L 8.1.7. 1.3 FYI, Oracle Support confirmed that I hit a 2G file size limit for Oracle databases on NT. This probably led to data dictionary corruption. I don't know if this is an NTFS limitation or Oracle on NT problem, but at this point I don't care, I can fix this by creating multiple smaller datafiles per tablespace. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- From: Boivin, Patrice J [SMTP:[EMAIL PROTECTED]] Sent: Monday, June 18, 2001 1:01 PM To: Multiple recipients of list ORACLE-L Subject:transfer of large datafile Oracle7.3.4.4 databases to 8.1.7.1.3 Has anyone successfully transferred large datafile Oracle databases from Oracle7.3. to 8.1.7? By large datafile database I mean a database that has files over 2G in size. This may not apply to all, it may apply only to those who extended the files beyond 2G. Just curious, since many of you appear to have made thet move from Oracle 7.3.4. to 8.1.6. or 8.1.7.. Here we did a full export of the db (Tru64 UNIX), ftp'ed it to another server (NT 4), then ran the 8.1.7 import to re-create the users and other global information. I aborted the import when the import started to create tables. Then I deleted user accounts I didn't need on the development database, and did a user import for the schemas that I needed. Using SQL I then re-created all the public synonyms, since the import utility did not re-create those. However the Change Manager tells me that the SYSTEM tablespace doesn't exist in the new database. Meanwhile the new database is open, and we can query from it. All the accounts appear to be accessible. Some objects (packages, procedures, views) are invalid, but not many. The developers are now going through twelve packages and one procedure that did not compile successfully, probably due to tightening of the code standards. Anyway when I run the import utility in show=y mode, I see in the import SQL code something that I saw last year: create tablespace statements with datafile sizes that are 1.7 billion Gigabytes. grin We don't have enough disk to hold that much data, and besides I don't think that NT can support files that size. I know that UNIX can't. e.g. CREATE TABLESPACE USERS DATAFILE '/oracle2/oradata/xx/users01.dbf' SI ZE 1844674407360320 DEFAULT STORAGE (INITIAL 40960 NEXT 40960 MIN EXTENTS 1 MAXEXTENTS 505 PCTINCREASE 0) ONLINE PERMANENT Last year Oracle Support told me to pre-create the
Re: * I'm Looking for an Oracle Financials DBA for Miami,
DBA jobs listings on ComputerJobs.com for the Florida area have gone from 1572 to 846 over the past 6 months. The job ads you see are repeated each week and are posted by more than one recruiter for the same job. Contact with the recruiter results in the job is filled or some other lame excuse. It appears that they are building a resume database incase the market opens up again. In the past weeks we have been contacted 2 or 3 times a week by recruiters inquiring if we have any opening that they can fill? I think the market is tight right now and downsizing will continue for a while until the economy picks up. Weekly the papers report another company in the Atlanta, GA area going through the size adjustment. ROR mª¿ªm [EMAIL PROTECTED] 06/19/01 03:15AM Gregory Conron schrieb: On June 16, 2001 04:35 am, Jared Still wrote: Many of us consider this a service, especially the way that jobs are at the moment. Amazing the difference a year can make, eh? Hi Just curious: How bad is the job situation in the US right now ? I'm wondering since we consider moving there (my wife is american). | Regards, | | Stefan Jahnke | | BOV AG | | @:D2 Vodafone, Abt.: FIBM | -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stefan Jahnke INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Intermedia Questions, Any Gurus on This Subject?
Help anybody, version 8.1.6.3 on UNIX 1. Storage clause of an intermedia index build. How to specify the buffer pool to KEEP or CACHE the index? 2. How to specify the tablespace for such a DOMAIN index. When put in tablespace clause, says its invalid option for domain index. Thanx = Vicky D. Foster, Oracle DBA email: [EMAIL PROTECTED] __ Do You Yahoo!? Spot the hottest trends in music, movies, and more. http://buzz.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Oracle DBA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Size of SYS1ORCL.ORA
I would recommend adding where owner not in ('SYS','SYSTEM') cause those you
cannot control.
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, June 19, 2001 5:56 AM
To: Multiple recipients of list ORACLE-L
Sounds to me like most of your database objects are in
SYSTEM tablespace (ie SYS1ORCL.ORA).
Try
select owner, tablespace_name, count(*)
from dba_segments
group by owner
If you've got lots of things in SYSTEM that are not
owned by SYS, SYSTEM then its
a) time to fix a lot of this up
b) get a consultant/senior DBA to come do a review of
your system - there's probably a lot of things that
can be improved upon
c) glean as much knowledge from them in the process
hth
connor
--- Rok Kodrun [EMAIL PROTECTED] wrote: Hi
PLEASE HELP!
I have Oracle Workgroup Server 7.3 for Windows NT.
How to manage size of database files, when they grow
to big?
For example, my SYS1ORCL.ORA file has over 376 MB.
What to do, to decrease
it? I'm running out of disk space and all the user
data are on separate
tablespace USER_DATA, which has 10MB. The database
runs on the machine for
couple of years already, without any problems, but
we will soon have one -
probably.
What to do?
Rok Kodrun
Institute Jozef Stefan
Ljubljana
Slovenia
=
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).
--
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: How to find the size of all the tables under a particular
why not analyze the table and look at avg_row_len column on user_tables? joe [EMAIL PROTECTED] 06/19/01 04:30AM Dear DBA Gurus, I need to find the size of one row of all the tables under a particularschema using vsize clause. How do I do this? Please help.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-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).
STARTUP ??
os :WINDOWS ADVANCED SERVER 2000 DB: ORACLE 8.1.6 MY question is how to execute a script on each startup of database on NT ?? Thanks Bunyamin
RE: ftp
Thanks all, I'll remember to bookmark it this time. David Lord -Original Message- Sent: 19 June 2001 13:05 To: Multiple recipients of list ORACLE-L ftp://oracle-ftp.oracle.com ftp://oracle-ftp.oracle.com Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- From: Lord David [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, June 19, 2001 6:47 AM To: Multiple recipients of list ORACLE-L Subject:ftp Hi Someone posted the address of the oracle ftp site a while back. As I've forgotten it, could they repost it. TIA David Lord Senior DBA, Hays Commercial Services, IT Solutions ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lord 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: 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). ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lord 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).
What the difference between qio and direct I/O option in VxFS
Dear List, What the difference between qio and direct I/O option in Veritas file system VxFS?? KC
Re: * I'm Looking for an Oracle Financials DBA for Miami,
Florida has always been a weak market compared to rest of the USA. I remember in NYC, you could go get another job at a lunchtime interview. DC area has a good job market. Pick up the NY Times or Washington Post. Not sure on the rest of the country. BTW, the financials job in Miami is at DelMonte and they have been looking for over a year. [EMAIL PROTECTED] 06/19/01 09:06AM DBA jobs listings on ComputerJobs.com for the Florida area have gone from 1572 to 846 over the past 6 months. The job ads you see are repeated each week and are posted by more than one recruiter for the same job. Contact with the recruiter results in the job is filled or some other lame excuse. It appears that they are building a resume database incase the market opens up again. In the past weeks we have been contacted 2 or 3 times a week by recruiters inquiring if we have any opening that they can fill? I think the market is tight right now and downsizing will continue for a while until the economy picks up. Weekly the papers report another company in the Atlanta, GA area going through the size adjustment. ROR mª¿ªm [EMAIL PROTECTED] 06/19/01 03:15AM Gregory Conron schrieb: On June 16, 2001 04:35 am, Jared Still wrote: Many of us consider this a service, especially the way that jobs are at the moment. Amazing the difference a year can make, eh? Hi Just curious: How bad is the job situation in the US right now ? I'm wondering since we consider moving there (my wife is american). | Regards, | | Stefan Jahnke | | BOV AG | | @:D2 Vodafone, Abt.: FIBM | -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stefan Jahnke INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Intermedia Questions, Any Gurus on This Subject?
There is a wealth of docs regarding this issue in OTN also check http://www.oracle.com/products/intermedia -Original Message- From: Oracle DBA [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, June 19, 2001 15:11 To: Multiple recipients of list ORACLE-L Subject: Intermedia Questions, Any Gurus on This Subject? Help anybody, version 8.1.6.3 on UNIX 1. Storage clause of an intermedia index build. How to specify the buffer pool to KEEP or CACHE the index? 2. How to specify the tablespace for such a DOMAIN index. When put in tablespace clause, says its invalid option for domain index. Thanx = Vicky D. Foster, Oracle DBA email: [EMAIL PROTECTED] __ Do You Yahoo!? Spot the hottest trends in music, movies, and more. http://buzz.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Oracle DBA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Hatzistavrou Giannis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Intermedia Questions, Any Gurus on This Subject?
Title: RE: Intermedia Questions, Any Gurus on This Subject?
Hi Vicky,
You need to create a preference to define the storage clause with CTX_DDL. I did this at a former employer and I don't have the scripts handy, sorry to say. The documentation does go over this in detail. You can specify just about everything for storage of your imt index in the preference. You can even put the separate pieces of the index in separate ts's. Buffer pool though, I'm not sure. See below a cutout from the doco.
Specifying Storage Attributes
The following examples specify that the index tables are to be created in the foo tablespace with an initial extent of 1K:
begin
ctx_ddl.create_preference('mystore', 'BASIC_STORAGE');
ctx_ddl.set_attribute('mystore', 'I_TABLE_CLAUSE',
'tablespace foo storage (initial 1K)');
ctx_ddl.set_attribute('mystore', 'K_TABLE_CLAUSE',
'tablespace foo storage (initial 1K)');
ctx_ddl.set_attribute('mystore', 'R_TABLE_CLAUSE',
'tablespace foo storage (initial 1K)');
ctx_ddl.set_attribute('mystore', 'N_TABLE_CLAUSE',
'tablespace foo storage (initial 1K)');
ctx_ddl.set_attribute('mystore', 'I_INDEX_CLAUSE',
'tablespace foo storage (initial 1K)');
end;
HTH
Lisa Koivu
Oracle Database Administrator
954-935-4117
The information in the electronic mail message is Cendant confidential and may be legally privileged, it is intended solely for the addressee(s) access to this internet electronic mail message by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it is prohibited and may be unlawful.
The sender believes that this E-mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking protective and remedial action about viruses and other defects. Cendant Corporation or Affiliates are not liable for any loss or damage arising in any way from this message or its attachments.
-Original Message-
From: Oracle DBA [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, June 19, 2001 9:11 AM
To: Multiple recipients of list ORACLE-L
Subject: Intermedia Questions, Any Gurus on This Subject?
Help anybody, version 8.1.6.3 on UNIX
1. Storage clause of an intermedia index build. How
to specify the buffer pool to KEEP or CACHE the index?
2. How to specify the tablespace for such a DOMAIN
index. When put in tablespace clause, says its invalid
option for domain index.
Thanx
=
Vicky D. Foster,
Oracle DBA
email: [EMAIL PROTECTED]
__
Do You Yahoo!?
Spot the hottest trends in music, movies, and more.
http://buzz.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Oracle DBA
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Re: * I'm Looking for an Oracle Financials DBA for Miami,
The Minneapolis / St. Paul area is not very active for Oracle people now. We have about 175 Oracle shops in the area. Ken Janusz, CPIM Florida has always been a weak market compared to rest of the USA. I remember in NYC, you could go get another job at a lunchtime interview. DC area has a good job market. Pick up the NY Times or Washington Post. Not sure on the rest of the country. BTW, the financials job in Miami is at DelMonte and they have been looking for over a year. [EMAIL PROTECTED] 06/19/01 09:06AM DBA jobs listings on ComputerJobs.com for the Florida area have gone from 1572 to 846 over the past 6 months. The job ads you see are repeated each week and are posted by more than one recruiter for the same job. Contact with the recruiter results in the job is filled or some other lame excuse. It appears that they are building a resume database incase the market opens up again. In the past weeks we have been contacted 2 or 3 times a week by recruiters inquiring if we have any opening that they can fill? I think the market is tight right now and downsizing will continue for a while until the economy picks up. Weekly the papers report another company in the Atlanta, GA area going through the size adjustment. ROR mª¿ªm [EMAIL PROTECTED] 06/19/01 03:15AM Gregory Conron schrieb: On June 16, 2001 04:35 am, Jared Still wrote: Many of us consider this a service, especially the way that jobs are at the moment. Amazing the difference a year can make, eh? Hi Just curious: How bad is the job situation in the US right now ? I'm wondering since we consider moving there (my wife is american). | Regards, | | Stefan Jahnke | | BOV AG | | @:D2 Vodafone, Abt.: FIBM | -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stefan Jahnke INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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: how to insert quote in a column
'''joy'''
-Original Message-
Sent: Monday, June 18, 2001 6:25 PM
To: Multiple recipients of list ORACLE-L
Hi,
I have a column defined as varchar2..i need to insert name like 'joy' in
it with quote
how can we insert quote(') to column.
Thanks
Harvinder
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Harvinder 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 / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or 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 oracle remotely
Does anyine have a current link to the VNC binaries for AIX 4.3? The link documented on the VNC home page at ATT Cambridge Labs is a dead URL. Regards, Gary _ Good judgement comes from experience. Experience comes from bad judgement. __ We do it using an X based system such as VNC. Out machines are at co-locations around the US.
Re: Latchs
Oracle8i Internal Sevices by steve Adams. From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Latchs Date: Tue, 19 Jun 2001 02:55:21 -0800 Hi folks. I'd like to know about different latchs, wait events and locks. Meaning of willing to wait and immediate ratio and all anothers things in relation with that. Anybody knows about documents, books, notes in Metalink, etc about that?. Thank you very much in advence. Regards. Miguel. Este mensaje y los documentos que, en su caso, lleve anexos, pueden contener información confidencial. Por ello, se informa a quien lo reciba por error que la información contenida en el mismo es reservada y su uso no autorizado está prohibido legalmente, por lo que en tal caso le rogamos que nos lo comunique por la misma vía o por teléfono (901 113 113) , se abstenga de realizar copias del mensaje o remitirlo o entregarlo a otra persona y proceda a borrarlo de inmediato. -- 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). _ 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: Externally Identified User - Serious Weirdness
I don't think BSIDBA and OPS$BSIDBA are the same Oracle user. (Check in dba_users). So ops$bsidba probably doesn't own the tables? (Maybe the install went wrong because of the value of the initializaion parameter os_authent_prefix which I think could be null or could be ops$ or some other value) I'm not sure how you could run the program and make it log in as bsidba; most probably you'll have to supply a username and pwd. Are there really new apps written in COBOL? :-) chaim Ron Rogers [EMAIL PROTECTED] on 06/18/2001 04:45:03 PM Please respond to [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Chaim Katz/Completions/Bombardier) David, Is FA_IDNT a view that you didn't know about that the package uses? Just a thought. ROR mª¿ªm [EMAIL PROTECTED] 06/18/01 03:16PM Hope everybody had a good weekend - Working on HP-UX and Oracle 8.1.7.0.0 I've got a third party app that 's written in COBOL and stores some of the information it needs to generate screens in the database. I am trying to practice restoring this beast, and it turns out I must run a utility to recompile some of the COBOL. All users in this database are identified externally and have OPS$ as the prefix to their username. The table(s) in question are owned by Oracle user BSIDBA. The UNIX user BSIDBA runs the program and the user in v$session shows up as OPS$BSIDBA. I get an ora-00942 on a select count (*) from one of the tables. Generally, this means some type of privilege is missing, but this user owns the table! Just in case, I granted select on the table to OPS$BSIDBA, got a 'grant succeeded', reran the COBOL piece, and got the same error. Set up tracing, ran it again, ran tkprof against the output, and sure enough: The following statement encountered a error during parse: select count(*) from FA_IDNT Error encountered: ORA-00942 I've granted everything I can think of to everyone I can find (this is - or will be - a development instance) and am still getting the error. Metalink hasn't revealed any secrets. Anybody seen anything like this or have an idea of something else I can try - the vendor has given up, says it's a DB problem. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OT RE: * I'm Looking for an Oracle Financials DBA for Miami,
This is interesting, at home I received an e-mail from a recruiter from Florida, who said that he had hundreds of positions to fill, etc. etc. I just answered: if this is not spam, let me know. He replied: It's not spam!! But I strongly suspect that he is in fact just building a database of résumés, sometimes I wonder if there isn't a market for these things, résumé banks on the Web are popping up here and there. I doubt that employers actually rely on these, they are much more likely in my opinion to go to local IT recruiting firms. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- From: Gene Sais [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, June 19, 2001 10:56 AM To: Multiple recipients of list ORACLE-L Subject:Re: * I'm Looking for an Oracle Financials DBA for Miami, Florida has always been a weak market compared to rest of the USA. I remember in NYC, you could go get another job at a lunchtime interview. DC area has a good job market. Pick up the NY Times or Washington Post. Not sure on the rest of the country. BTW, the financials job in Miami is at DelMonte and they have been looking for over a year. [EMAIL PROTECTED] 06/19/01 09:06AM DBA jobs listings on ComputerJobs.com for the Florida area have gone from 1572 to 846 over the past 6 months. The job ads you see are repeated each week and are posted by more than one recruiter for the same job. Contact with the recruiter results in the job is filled or some other lame excuse. It appears that they are building a resume database incase the market opens up again. In the past weeks we have been contacted 2 or 3 times a week by recruiters inquiring if we have any opening that they can fill? I think the market is tight right now and downsizing will continue for a while until the economy picks up. Weekly the papers report another company in the Atlanta, GA area going through the size adjustment. ROR mª¿ªm [EMAIL PROTECTED] 06/19/01 03:15AM Gregory Conron schrieb: On June 16, 2001 04:35 am, Jared Still wrote: Many of us consider this a service, especially the way that jobs are at the moment. Amazing the difference a year can make, eh? Hi Just curious: How bad is the job situation in the US right now ? I'm wondering since we consider moving there (my wife is american). | Regards, | | Stefan Jahnke | | BOV AG | | @:D2 Vodafone, Abt.: FIBM | -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stefan Jahnke INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other
Jdeveloper Compatibility
Hi all, I have a question wondering if someone could help me out. Has anyone heard of compatibility issues with Jdeveloper 3.2.3 on Winnt and versions of Oracle DB's. I have someone here telling me that it won't work with Oracle 8.1.6 SE, and it is causing me MAJOR issues. So if anyone know's anything it would be greatly appreciated. Sincerely, Kevin Kostyszyn DBA Dulcian, Inc www.dulcian.com [EMAIL PROTECTED] -- 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).
Disk configuration
Dear List, Someone told me when a disk receive a write request, it write to the nearest free space on disk where the disk read/write head is currently positioning, is this information correct?? If this is true, is this a bad thing for database application?? That mean we can't really control where the file go, for performance purpose we may want to put certain files on the outer tracks of a disk, if the write location is depending on where the read/write head is, how can we avoid that, can we create subdisks from the outer track of a disk and create a logical volume from it?? KC
RE: JDeveloper Connection to Oracle DB
Sorry, this might be a stupid question but, is the db ON the same machine as JDeveloper. If it is, are you sure the db is running, is the machine on a network? If it isn't, were there any errors encountered during installation? -Original Message- Mouchantaf Sent: Tuesday, June 19, 2001 4:40 AM To: Multiple recipients of list ORACLE-L Hi again, I would like to clarify the problem once again since it seems that I might have left some details out. I have installed JDeveloper 3.0 and I am running Oracle 8i personal edition on a Windows 98 platform. I am trying to create a connection to the DB from JDeveloper. I specify the Oracle JDBC Thin as driver since I need to use applets, and I select Existing TNS Names as the connection method and I choose the service running. When I click on the Test Connection button I get an error message that reads: Io exception: The Network adapter could not establish the connection. I tried to resolve the problem but was unable to. I had the listener started using the command: lsnrctl start. I am able to ping the server. There are no firewalls invovled. According to the documentation, the Thin driver uses the sqlnet. I tried using the IP address instead of the TNSNames and I still got the same error message. I would appreciate any help. Thank you, Elias S. Mouchantaf Tel. (+961) 3 740319 [EMAIL PROTECTED] www.moshnet.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Elias Mouchantaf INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Intermedia Questions, Any Gurus on This Subject?
You need to create preferences to specify storage parameters like:
begin
ctx_ddl.create_preference('storage_small','BASIC_STORAGE');
ctx_ddl.set_attribute('storage_small','I_TABLE_CLAUSE','tablespace
LOBADM_01_SMALL_DATA');
ctx_ddl.set_attribute('storage_small','K_TABLE_CLAUSE','tablespace
LOBADM_01_SMALL_DATA');
ctx_ddl.set_attribute('storage_small','R_TABLE_CLAUSE','tablespace
LOBADM_01_SMALL_DATA');
ctx_ddl.set_attribute('storage_small','N_TABLE_CLAUSE','tablespace
LOBADM_01_SMALL_DATA');
ctx_ddl.set_attribute('storage_small','I_INDEX_CLAUSE','tablespace
LOBADM_01_SMALL_INDX');
ctx_ddl.set_attribute('storage_small','P_TABLE_CLAUSE','tablespace
LOBADM_01_SMALL_DATA');
end;
/
Then create index like:
create index lobadm.client_full_nm_indx on lobadm.client(full_nm)
indextype is ctxsys.context
parameters('storage lobadm.storage_small')
/
Hope this helps
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mike J Kurth
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or 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 oracle remotely
http://www.uk.research.att.com/vnc/ is up and running for me. Jon Baker Database Engineer (1/5) [EMAIL PROTECTED] www.netsec.net [EMAIL PROTECTED] wrote: Does anyine have a current link to the VNC binaries for AIX 4.3? The link documented on the VNC home page at ATT Cambridge Labs is a dead URL. Regards, Gary _ Good judgement comes from experience. Experience comes from bad judgement. __ We do it using an X based system such as VNC. Out machines are at co-locations around the US. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: jon 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: Latchs
Also look for Anjo Kolk's (sp?) paper Oracle7 Wait Events and Enqueues on http://www.evdbt.com Scott Shafer San Antonio, TX 210-581-6217 I hate the country, all those animals walking around un-cooked. -Original Message- From: Rahul [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, June 19, 2001 6:05 AM To: Multiple recipients of list ORACLE-L Subject: RE: Latchs the best resource .. http://www.amazon.com/exec/obidos/ASIN/156592598X/ixora/102-4862016-620016 8 -- From: [EMAIL PROTECTED][SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Tuesday, June 19, 2001 5:55 PM To: Multiple recipients of list ORACLE-L Subject:Latchs Hi folks. I'd like to know about different latchs, wait events and locks. Meaning of willing to wait and immediate ratio and all anothers things in relation with that. Anybody knows about documents, books, notes in Metalink, etc about that?. Thank you very much in advence. Regards. Miguel. Este mensaje y los documentos que, en su caso, lleve anexos, pueden contener información confidencial. Por ello, se informa a quien lo reciba por error que la información contenida en el mismo es reservada y su uso no autorizado está prohibido legalmente, por lo que en tal caso le rogamos que nos lo comunique por la misma vía o por teléfono (901 113 113) , se abstenga de realizar copias del mensaje o remitirlo o entregarlo a otra persona y proceda a borrarlo de inmediato. -- 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: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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).
FW: 9i On Linux
Joe, Did you get time to do your RH Linux tests this weekend? If you're in Dresden, you probably didn't have much else to do. If you did test, how'd it go? Michael Armstead Application Database Administrator, OCP-Certified US Pharmaceuticals IT Glaxo SmithKline -Original Message- From: JOE TESTA [SMTP:[EMAIL PROTECTED]] Sent: Friday, June 15, 2001 4:31 PM To: Multiple recipients of list ORACLE-L Subject: Re: 9i On Linux i've got 256M, dont run SUSE but will attempt it on rh 7.1 this weekend. joe [EMAIL PROTECTED] 06/15/01 04:20PM Can any of you just confirm that Oracle 9i requires 500M of memory on Linux? Thank, Waleed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Armstead, Michael A INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Java
Hi Do you know what is meen: ORA-29547 Java system class not available: oracle/aurora/rdbms/Compiler Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alon Ben-Zvi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: * I'm Looking for an Oracle Financials DBA for Miami,
opportunities are scarce in all facets of computing across the US, yes it is amazing the difference a year can make. a friend sent this link the other day: http://www.salon.com/tech/wire/2001/06/15/new_homeless/index.html I've got friends in Atlanta, Detroit, san Francisco, new york, and a few other places; they all had some dismal stories. the industry is suffering a bit of late. the overall unemployment rate is up in comparison to the last couple of years. http://stats.bls.gov/wh/cpsbref3.htm === Lerone Streeter System Analyst Abbott LBG [EMAIL PROTECTED] === -Original Message- Sent: Tuesday, June 19, 2001 9:56 AM To: Multiple recipients of list ORACLE-L Florida has always been a weak market compared to rest of the USA. I remember in NYC, you could go get another job at a lunchtime interview. DC area has a good job market. Pick up the NY Times or Washington Post. Not sure on the rest of the country. BTW, the financials job in Miami is at DelMonte and they have been looking for over a year. [EMAIL PROTECTED] 06/19/01 09:06AM DBA jobs listings on ComputerJobs.com for the Florida area have gone from 1572 to 846 over the past 6 months. The job ads you see are repeated each week and are posted by more than one recruiter for the same job. Contact with the recruiter results in the job is filled or some other lame excuse. It appears that they are building a resume database incase the market opens up again. In the past weeks we have been contacted 2 or 3 times a week by recruiters inquiring if we have any opening that they can fill? I think the market is tight right now and downsizing will continue for a while until the economy picks up. Weekly the papers report another company in the Atlanta, GA area going through the size adjustment. ROR mª¿ªm [EMAIL PROTECTED] 06/19/01 03:15AM Gregory Conron schrieb: On June 16, 2001 04:35 am, Jared Still wrote: Many of us consider this a service, especially the way that jobs are at the moment. Amazing the difference a year can make, eh? Hi Just curious: How bad is the job situation in the US right now ? I'm wondering since we consider moving there (my wife is american). | Regards, | | Stefan Jahnke | | BOV AG | | @:D2 Vodafone, Abt.: FIBM | -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stefan Jahnke INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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).
Re: FW: 9i On Linux
yea got it installed on 256M of ram last night, there is another msg on the listserv about my findings, if you dont see it let me know and I'll resend it from home tonite. basically, i got the binaries installed(but none of them would relink), hacked the $ORACLE_HOME/bin/genclntsh based on installing 8.1.7 on rh 7.1 and regenerated the share libs, relinked everything manually after getting out of installer. built scripts to build db, will run them this evening. rh 7.1, 256M of ram will also be attempting it on my laptop tonite as i've just loaded up rh 7.1 on it about 10 mins ago. joe "Armstead, Michael A" [EMAIL PROTECTED] 06/19/01 10:14AM Joe,Did you get time to do your RH Linux tests this weekend? If you're inDresden, you probably didn't have much else to do. If you did test, how'd itgo?Michael Armstead Application Database Administrator, OCP-CertifiedUS Pharmaceuticals ITGlaxo SmithKline -Original Message- From: JOE TESTA [SMTP:[EMAIL PROTECTED]] Sent: Friday, June 15, 2001 4:31 PM To: Multiple recipients of list ORACLE-L Subject: Re: 9i On Linux i've got 256M, dont run SUSE but will attempt it on rh 7.1 this weekend. joe [EMAIL PROTECTED] 06/15/01 04:20PM Can any of you just confirm that Oracle 9i requires 500M of memory on Linux? Thank, Waleed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: STARTUP ??
Hello, If you have the NT Resource Kit check out AUTOEXNT The AutoExNT service allows you to start a batch file, AUTOEXNT.BAT, at boot time without having to log onto the computer on which it will run. AutoExNT includes an /interactive option (analogous to the /interactive option of the AT command) that allows you to see the processes started. To use AutoExNT, you must be running Windows NT 3.5 or later. -- Chris J. Guidry P.Eng. ATCO Electric, Metering Services Phone: (780) 420-4142 Fax: (780) 420-3854 Email: [EMAIL PROTECTED] -Original Message- From: Bunyamin K. Karadeniz [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, June 19, 2001 07:46 AM To: Multiple recipients of list ORACLE-L Subject: STARTUP ?? os : WINDOWS ADVANCED SERVER 2000 DB: ORACLE 8.1.6 MY question is how to execute a script on each startup of database on NT ?? Thanks Bunyamin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guidry, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Disk configuration
As that person if Santa exists. The datafiles allocate their extents upon their creation, so a new insert will write within that space, "Walking on water and developing software from a specification are easy if both are frozen." Christopher R. Spence Oracle DBA Fuelspot -Original Message-From: KC [mailto:[EMAIL PROTECTED]]Sent: Tuesday, June 19, 2001 10:36 AMTo: Multiple recipients of list ORACLE-LSubject: Disk configuration Dear List, Someone told me when a disk receive a write request, it write to the nearest free space on disk where the disk read/write head is currently positioning, is this information correct?? If this is true, is this a bad thing for database application?? That mean we can't really control where the file go, for performance purpose we may want to put certain files on the outer tracks of a disk, if the write location is depending on where the read/write head is, how can we avoid that, can we create subdisks from the outer track of a disk and create a logical volume from it?? KC
RE: Disk configuration
It all depends on what kind of os/filesystem/and disks you have. I know that under AIX, using SSA drives we could actually tell where on the disk we wanted the filesystem to go. This way we could position certain things in the faster location. But personally, I would not go thru the trouble. I have never had a DB slowdown so far because of placement on the drive. Admittadly, I have had probelms based on putting conflicting tables/indexes on the same drive you want to keep things that could be access simultaneously on different media. But other than that no other conflicts. -Original Message-From: KC [mailto:[EMAIL PROTECTED]]Sent: Tuesday, June 19, 2001 9:36 AMTo: Multiple recipients of list ORACLE-LSubject: Disk configuration Dear List, Someone told me when a disk receive a write request, it write to the nearest free space on disk where the disk read/write head is currently positioning, is this information correct?? If this is true, is this a bad thing for database application?? That mean we can't really control where the file go, for performance purpose we may want to put certain files on the outer tracks of a disk, if the write location is depending on where the read/write head is, how can we avoid that, can we create subdisks from the outer track of a disk and create a logical volume from it?? KC
RE: Java
From MetaLink Do the following Set the CLASSPATH to ORACLE_HOME/javavm/lib/aurora.zip Then run the initjvm.sql script from ORACLE_HOME/javavm/install. Rick -Original Message- Sent: Tuesday, June 19, 2001 11:16 AM To: Multiple recipients of list ORACLE-L Hi Do you know what is meen: ORA-29547 Java system class not available: oracle/aurora/rdbms/Compiler Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alon Ben-Zvi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Java
Hi Do you know what is mean: ORA-29547 Java system class not available: oracle/aurora/rdbms/Compiler Thanks
OCP Testing Software
I have used SelfTest Software in the past to prepare for the OCP tests. Is there another similar company that is as good or better? Thanks, Ken Janusz, CPIM -- 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: How to size db_block_size?
Title: RE: How to size db_block_size?
ok I'm
confused.
if i
run df -g i get this
(/dev/vg00/lvol3 ) :
8192 file system block size 1024 fragment size
and if i
run
select max(l.lebsz)
log_block_sizefrom sys.x$kccle lwhere
l.inst_id = userenv('Instance');
i
get
LOG_BLOCK_SIZE__
1024
does this meanmy os block size is
1k?
if so how do i change it to
8k?
-Original
Message-From: Christopher Spence
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, June 19, 2001 9:26
AMTo: Multiple recipients of list ORACLE-LSubject: RE:
How to size db_block_size?
df
-g
"Walking on water and developing software from
a specification are easy if both are frozen."
Christopher R. Spence Oracle DBA Fuelspot
-Original Message-From: Herman Susantio
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, June 19, 2001 5:14
AMTo: Multiple recipients of list ORACLE-LSubject: Re:
How to size db_block_size?
Hi all,
just want to ask,
How do we know the OS Block size from our
system ?
We use Sun Solaris 2.7
any command to show OS Block Size
?
Thanks Regards
Herman
- Original Message -
From:
Nirmal
Kumar Muthu Kumaran
To: Multiple recipients of list
ORACLE-L
Sent: Tuesday, June 19, 2001 4:30
PM
Subject: RE: How to size
db_block_size?
Hi Justin,
A larger data block size provides
greater efficiency in disk and memory I/O (access and storage of data).
Such cases include:
a) Oracle is on a large computer
system with a large amount of memory and fast disk drives. For example,
databases controlled by mainframe computers with vast hardware resources
typically use a data block size of 4K or greater.
b) The operating system that runs
Oracle uses a small operating system block size. For example, if the
operating system block size is 1K and the data block size matches this,
Oracle may be performing an excessive amount of disk I/O during normal
operation. For best performance in this case, a database block should
consist of multiple operating system blocks.
Hope that this would helps
you.
Nirmal.
-Original Message-
From: Justin Coleman
[SMTP:[EMAIL PROTECTED]] Sent: Tuesday,
June 19, 2001 10:06 AM To: Multiple recipients of list ORACLE-L Subject:
How to size db_block_size?
Dear All,
Is there a recommended approach on how to
decide on the db_block_size for your
database? I am looking to create a database that during the day
will be used for light OLTP, but
during the day and night will have heavish batch jobs. Therefore I was intent on using 8k or 16k
blocks. Most likely 8k blocks. But is there an approach to actually chosing the
correct db_block_size?
Cheers for any help in advance.
Justin
_
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: Justin
Coleman INET:
[EMAIL PROTECTED]
Fat City Network Services
-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California
-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list,
send an E-Mail message to:
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing:
UNSUB ORACLE-L (or the name of
mailing list you want to be removed from). You may
also send the HELP command for other
information (like subscribing).
Re: Java
Alon, Sounds to me like you're missing the classesXX.zip file in $ORACLE_HOME/wherever_you_defined_the_lib David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Alon Ben-Zvi Alon.Ben-Zvi@demTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] antra.com cc: Sent by: Subject: Java [EMAIL PROTECTED] 06/19/2001 10:15 AM Please respond to ORACLE-L Hi Do you know what is meen: ORA-29547 Java system class not available: oracle/aurora/rdbms/Compiler Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alon Ben-Zvi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Java
It means that the Java system classes aren't installed. Try logging in as SYSTEM and running CREATE OR REPLACE JAVA SYSTEM. This will take a while, but it should fix your problem. g. -Original Message- Sent: Tuesday, June 19, 2001 4:56 PM To: Multiple recipients of list ORACLE-L Hi Do you know what is mean: ORA-29547 Java system class not available: oracle/aurora/rdbms/Compiler Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 find highest process useing more CPU
Hi Is there any way to find which process is taking much cpu except top command on Solaris Unix. If some one have any script let me know. With regards -Seema _ 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).
Compaq servers and 9i
http://www.theregister.co.uk/content/2/19805.html http://www.theregister.co.uk/content/2/19805.html Compaq Alpha box steals 9i benchmark laurels By Andrew Orlowski in San Francisco Posted: 19/06/2001 at 11:49 GMT Compaq is first out of the blocks with a barnstorming midrange benchmark for a system running Oracle 9i. If you've got $13 million to spare - which is a lot for a midrange system, quite frankly - you can get a 32-way AlphaServer GS320 to run 230,533 Benchmark C transactions per minute using Oracle 9i. That works out as $56.62 per transaction. The system clocked 188,000 users, and ran Compaq's Tru64 Unix. (Which was Digital Unix, and OSF/1 before that). Compaq's configuration also includes 16 PIIIs. The $13 million figure is for the cost of the system over three years. The AlphaServer itself is billed at under half a million dollars, that's a quarter of the cost of licensing Oracle 9i software. As usual in these systems, storage accounts for most of the rest. By comparison, the Unix systems to beat in the TPC-C Top Ten include a 32way Solaris SPARC Fujitsu system, the PrimePower 2000, which clocks 222,772 TPC-C at $51.40, making it the highest non-clustered performer; an IBM RS/6000 S85 'pServer' clocking 220,807 at $43.30, and an HP 9000 Superdome clocking 197,024 at $53.77 per transaction. The full, 234 page PDF for the AlphaServer can be found here. Not everyone likes to measure their hardware against the synthetic TPC-C benchmarks. TPC-C scores have been criticised for mixing clustered and non-clustered results in the same league table, and more importantly, failing to replicate real word application conditions. But it's an itch no vendor seems to be able to resist scratching. ® Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: * I'm Looking for an Oracle Financials DBA for Miami,
Title: RE: * I'm Looking for an Oracle Financials DBA for Miami, I also think that, if you are willing to move, Oracle DBA's can ALWAYS find jobs. Move to either large population areas where either Federal or State Govt's are, and there always consultant opportunities. I can't imagine that a DBA would have problems finding work in either DC, NYC or Boston (sorry, I'm from the east coast - not too familiar with the rest of the country). Even in my small neck of the woods (Albany, NY) there are DBA positions available with state govt. Tom Mercadante Oracle Certified Professional -Original Message-From: Bowes, Chris [mailto:[EMAIL PROTECTED]]Sent: Tuesday, June 19, 2001 12:59 PMTo: Multiple recipients of list ORACLE-LSubject: RE: * I'm Looking for an Oracle Financials DBA for Miami, I really think it matters where in the job field you're talking. I know of at least 3 people who in the last 6 months changed jobs and their picks of jobs from multiple opportunities. One in Florida, one in Atlanta and one in San Francisco. In 2 of the 3 cases (FL and ATL), when the candidate chose which offer s/he wanted, the ones that were told 'no' didn't want to take no for an answer and kept bugging the candidate. The Florida and San Francisco candidates were Oracle DBA's the other (Atlanta) was a web programmer who could interface with Oracle. If you used to work at www.wowlookatthisgreatsitewehopetomakeaprofitsoonuntilthenletsbuysomemorecoolexpensivestuff.com then, yes, you could in trouble if that's all you know. We in the Oracle community and the Sqlserver community have had our opportunities cut down some, but they're still out there. --Chris [EMAIL PROTECTED]
Re: how to find highest process useing more CPU
/usr/ucb/ps -uax This will give u the /son of a b***'s' taking the most CPU Sam - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, June 19, 2001 9:13 PM On Tue, Jun 19, 2001 at 08:46:04AM -0800, Seema Singh wrote: Hi Is there any way to find which process is taking much cpu except top command on Solaris Unix. If some one have any script let me know. With regards -Seema Try looking up the documentation for ps for example... ps -e -o pcpu,pid,user,args | sort -nr | head -- Tommy Wareing Software Engineer Oxford English Dictionary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tommy Wareing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Sam Roberts INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
duel error
hi i accidentally dropped duel table from sys..then recreated it. now when i am using rman during running the catrman.sql for recovery_catalog it is flashing error select '08.00.05' from dual * ERROR at line 2: ORA-00942: table or view does not exist u'r help is highly appreciated Shirish Khapre, SE Rolta India Ltd. Off Ph No. (+91) (022) 832,826,8300568 Ext'n 2730 Minds are like parachutes. They only function when they are open -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shirish Khapre INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: using User defined functions in Check constraint
Title: using User defined functions in Check constraint Hussain While you can use any Oracle supplied function within a check constraint, you cannot use a self-written function. But you can perform the same thing by using a database table trigger on the table itself. You can basically validate anything you want from any schema you wish using a database trigger (with some exceptions). A pre-insert trigger on the table would work just fine. Check them out in the documentation. hope this helps Tom Mercadante Oracle Certified Professional -Original Message-From: Arslan Dar [mailto:[EMAIL PROTECTED]]Sent: Tuesday, June 19, 2001 1:14 PMTo: Multiple recipients of list ORACLE-LSubject: using User defined functions in Check constraint Hello All Can we use user made functions in the check constraints?. Like In the check constraitns, we can use oracle functions, like LENGTH(NAME)=9. What we want to do is to check a value, which before being saved in the database(when we press save, registration no. of a patient, gets prefixed with the area code where the patient is being registrered), checks whether the values prefixed with the data are present in a table in another schema, for this purpose we want to use a function(selfmade). This we do to get a unique value irrespective of the area. If not, is there a work around, to check such a value from a different schematable in a check constraint.Oracle 8.1.7 on winnt 4 TIAHussainDBA SKMCH RC
Re: how to find highest process useing more CPU
use the following command it will tell who is using the cpu /usr/ucb/ps auxw|head From: Seema Singh [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: how to find highest process useing more CPU Date: Tue, 19 Jun 2001 08:46:04 -0800 Hi Is there any way to find which process is taking much cpu except top command on Solaris Unix. If some one have any script let me know. With regards -Seema _ 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). _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ARUN K C INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
r25des/r25desm
I've bumped into a problem with Reports 25 designer: When I try to load an rdf or rex into the database, the application dies. On my NT box, if I use r25mov32.exe or r25con32.exe, I get: REP-26540: Abnormal condition: Internal error while reading SQL*Reportwriter V1.1's Rexfile If I use r25des32.exe and go to FileAdminConvert, the application just blinks and goes away. On the Sun box, if I use r25desm, I get Bus Error (coredump) if I use r25mrepm, I get the same REP-26540 if I use r25convm, I get Bus error What do I do to get the report saved in the database? Kenneth Komoto mailto:[EMAIL PROTECTED] Office of the Registrar Phone: (530)752-7197 University of CaliforniaFax : (530)752-0329 Davis, Ca 95616 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Komoto INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: duel error
Make sure you grant select from dual to public. HTH, -Rocky --- Shirish Khapre [EMAIL PROTECTED] wrote: hi i accidentally dropped duel table from sys..then recreated it. now when i am using rman during running the catrman.sql for recovery_catalog it is flashing error select '08.00.05' from dual * ERROR at line 2: ORA-00942: table or view does not exist u'r help is highly appreciated Shirish Khapre, SE Rolta India Ltd. Off Ph No. (+91) (022) 832,826,8300568 Ext'n 2730 Minds are like parachutes. They only function when they are open -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shirish Khapre INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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!? Spot the hottest trends in music, movies, and more. http://buzz.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rocky Welch INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: duel error
my guess is the public synonym is still there, grant select on dual to public. if the synonym isnot there recreate it also. joe [EMAIL PROTECTED] 06/19/01 01:51PM hii accidentally dropped duel table from sys..then recreated it.now when i am using rman during running the catrman.sql for recovery_catalogit is flashing errorselect '08.00.05' from dual*ERROR at line 2:ORA-00942: table or view does not existu'r help is highly appreciatedShirish Khapre, SE Rolta India Ltd.Off Ph No. (+91) (022) 832,826,8300568Ext'n 2730Minds are like parachutes. They only function when they are open-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Shirish Khapre 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: duel error
Who were you logged on as when you recreated it? Did you create a public synonym for user.dual? You should create the table as sys.dual and create the public synonym for it. That should fix your problem HTH, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, June 19, 2001 1:51 PM hi i accidentally dropped duel table from sys..then recreated it. now when i am using rman during running the catrman.sql for recovery_catalog it is flashing error select '08.00.05' from dual * ERROR at line 2: ORA-00942: table or view does not exist u'r help is highly appreciated Shirish Khapre, SE Rolta India Ltd. Off Ph No. (+91) (022) 832,826,8300568 Ext'n 2730 Minds are like parachutes. They only function when they are open -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shirish Khapre INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
New system, cart blanche, what to buy
All, For a position that would (possibly) like me to set up an Oracle infrastructure from scratch, on Unix. Given the opportunity to choose from any system, what hardware would you pick? From the small bit of information I've been able to glean, it'll be fairly large, and need failover. I obviosuly can't guess the size of the system, but one part of the question is vendor. I'm familiar with Solaris, but HP seems to be platform of choice these days. And each vendor has their own storage methodologies, and their own HA clustering mechanisms. And there's always OPS. Any opinions, pointers, caveats? (Is this a broad enough question? :-) Yosi -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
ps -ef | grep sqlplus
hi, do you know how to hide oracle passwords from ps -ef? we pass in our pw in cron, and it shows up when you run ps -ef (to check unix processes). i recognize that is this NOT a smart thing to do... can anyone recommend a better way of supplying oracle passwords when scripts are connecting to oracle? do you use config files that store pws? just curious what everyone else is doing to plug this security hole. thanks, kris -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kris Austin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: duel error
And one more thing. The table dual has one column called dummy with is defined as varchar2(1). and contains ONE row with the value of 'X'. [EMAIL PROTECTED] 06/19/01 02:13PM Who were you logged on as when you recreated it? Did you create a public synonym for user.dual? You should create the table as sys.dual and create the public synonym for it. That should fix your problem HTH, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, June 19, 2001 1:51 PM hi i accidentally dropped duel table from sys..then recreated it. now when i am using rman during running the catrman.sql for recovery_catalog it is flashing error select '08.00.05' from dual * ERROR at line 2: ORA-00942: table or view does not exist u'r help is highly appreciated Shirish Khapre, SE Rolta India Ltd. Off Ph No. (+91) (022) 832,826,8300568 Ext'n 2730 Minds are like parachutes. They only function when they are open -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shirish Khapre INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: William Beilstein INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: * I'm Looking for an Oracle Financials DBA for Miami,
That would be good advice also for people form New York and / or California that might be interested in migrating to the USA for work also, with all the dot com layoffs. Check www.monster.com www.dice.com www.net-temps.com for jobs positions and put your resume to see response before deciding to migrate to USA. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Tue, 19 Jun 2001 05:56:13 -0800 Florida has always been a weak market compared to rest of the USA. I remember in NYC, you could go get another job at a lunchtime interview. DC area has a good job market. Pick up the NY Times or Washington Post. Not sure on the rest of the country. BTW, the financials job in Miami is at DelMonte and they have been looking for over a year. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Page, Bruce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: duel error
You could always just run catalog.sql as sys. -Original Message- Sent: Tuesday, June 19, 2001 11:32 AM To: Multiple recipients of list ORACLE-L Your email says duel. You created dual, with an a, right? And did you grant select on dual to public? And create a public synonym for it? HTH, Yosi Shirish Khapre wrote: hi i accidentally dropped duel table from sys..then recreated it. now when i am using rman during running the catrman.sql for recovery_catalog it is flashing error select '08.00.05' from dual * ERROR at line 2: ORA-00942: table or view does not exist u'r help is highly appreciated Shirish Khapre, SE Rolta India Ltd. Off Ph No. (+91) (022) 832,826,8300568 Ext'n 2730 Minds are like parachutes. They only function when they are open -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shirish Khapre INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Thanks, Yosi - Yosi Greenfield Oracle Certified DBA [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: ps -ef | grep sqlplus
We recognized the same problem and found this program as an answer: http://www.orafaq.org/scripts/c_src/hide.txt Michael Armstead Application Database Administrator, OCP-Certified US Pharmaceuticals IT Glaxo SmithKline -Original Message- From: Kris Austin [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, June 19, 2001 2:38 PM To: Multiple recipients of list ORACLE-L Subject: ps -ef | grep sqlplus hi, do you know how to hide oracle passwords from ps -ef? we pass in our pw in cron, and it shows up when you run ps -ef (to check unix processes). i recognize that is this NOT a smart thing to do... can anyone recommend a better way of supplying oracle passwords when scripts are connecting to oracle? do you use config files that store pws? just curious what everyone else is doing to plug this security hole. thanks, kris -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kris Austin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Armstead, Michael A INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ps -ef | grep sqlplus
We use an externally identified account here to sign on to the database from cron for DBA related tasks. Since only the dba team knows the oracle Unix password it works for us well. -Original Message- Sent: Tuesday, June 19, 2001 11:38 AM To: Multiple recipients of list ORACLE-L hi, do you know how to hide oracle passwords from ps -ef? we pass in our pw in cron, and it shows up when you run ps -ef (to check unix processes). i recognize that is this NOT a smart thing to do... can anyone recommend a better way of supplying oracle passwords when scripts are connecting to oracle? do you use config files that store pws? just curious what everyone else is doing to plug this security hole. thanks, kris -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kris Austin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: duel error
Did you remember the Grants and the Insert ??
create table dual /* pl/sql's standard pckg requires dual.
*/
(dummy varchar2(1))/* note, the optimizer knows sys.dual is single row
*/
storage (initial 1)
/
insert into dual values('X')
/
create public synonym dual for dual
/
grant select on dual to public with grant option
-Original Message-
Sent: Tuesday, June 19, 2001 12:52 PM
To: Multiple recipients of list ORACLE-L
hi
i accidentally dropped duel table from sys..then recreated it.
now when i am using rman during running the catrman.sql for recovery_catalog
it is flashing error
select '08.00.05' from dual
*
ERROR at line 2:
ORA-00942: table or view does not exist
u'r help is highly appreciated
Shirish Khapre, SE Rolta India Ltd.
Off Ph No. (+91) (022) 832,826,8300568
Ext'n 2730
Minds are like parachutes. They only function when they are open
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Shirish Khapre
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be 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).
RE: transfer of large datafile Oracle7.3.4.4 databases to 8.1.7. 1.3
More info on this, the error occurs during the export. The bug was fixed in 8.0.5, says Oracle Support, but because I am using an Oracle 7.3. export file we get the oversized file errors during the import, even if we are using the 8.1.7 import utility.. Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- From: Boivin, Patrice J [SMTP:[EMAIL PROTECTED]] Sent: Monday, June 18, 2001 2:51 PM To: Multiple recipients of list ORACLE-L Subject:RE: transfer of large datafile Oracle7.3.4.4 databases to 8.1.7. 1.3 FYI, Oracle Support confirmed that I hit a 2G file size limit for Oracle databases on NT. This probably led to data dictionary corruption. I don't know if this is an NTFS limitation or Oracle on NT problem, but at this point I don't care, I can fix this by creating multiple smaller datafiles per tablespace. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- From: Boivin, Patrice J [SMTP:[EMAIL PROTECTED]] Sent: Monday, June 18, 2001 1:01 PM To: Multiple recipients of list ORACLE-L Subject:transfer of large datafile Oracle7.3.4.4 databases to 8.1.7.1.3 Has anyone successfully transferred large datafile Oracle databases from Oracle7.3. to 8.1.7? By large datafile database I mean a database that has files over 2G in size. This may not apply to all, it may apply only to those who extended the files beyond 2G. Just curious, since many of you appear to have made thet move from Oracle 7.3.4. to 8.1.6. or 8.1.7.. Here we did a full export of the db (Tru64 UNIX), ftp'ed it to another server (NT 4), then ran the 8.1.7 import to re-create the users and other global information. I aborted the import when the import started to create tables. Then I deleted user accounts I didn't need on the development database, and did a user import for the schemas that I needed. Using SQL I then re-created all the public synonyms, since the import utility did not re-create those. However the Change Manager tells me that the SYSTEM tablespace doesn't exist in the new database. Meanwhile the new database is open, and we can query from it. All the accounts appear to be accessible. Some objects (packages, procedures, views) are invalid, but not many. The developers are now going through twelve packages and one procedure that did not compile successfully, probably due to tightening of the code standards. Anyway when I run the import utility in show=y mode, I see in the import SQL code something that I saw last year: create tablespace statements with datafile sizes that are 1.7 billion Gigabytes. grin We don't have enough disk to hold that much data, and besides I don't think that NT can support files that size. I know that UNIX can't. e.g. CREATE TABLESPACE USERS DATAFILE '/oracle2/oradata/xx/users01.dbf' SI ZE 1844674407360320 DEFAULT STORAGE (INITIAL 40960 NEXT 40960 MIN EXTENTS 1 MAXEXTENTS 505 PCTINCREASE 0) ONLINE PERMANENT Last year Oracle Support told me to pre-create the tablespaces, do the full import, and ignore the error reports during the import. They said that because the tablespaces do exist, import will produce an error but it will move on and do its thing. Given that I am creating new databases and we wish to migrate our major production databases, I would much prefer it if there were no errors anywhere. Another issue with this bug is that when
RE: ps -ef | grep sqlplus
I can't get this page to come up but I suspect it is an old piece of code that pads a bunch of spaces so that the password is hidden when a user does a ps -ef command. Beware, this is not foolproof. There are X-Windows utilities in almost all incarnations of UNIX that show the complete line, no matter how long it is. Also, I think in Solaris that you could probably find it in /proc which is readable by the world. There are a lot of arguments against this, but I have always found externally identified accounts the easiest and least difficult to manage solution to this problem. The main caveat is maintaining two separate schemas when performing grants. If you do it from the start then it is quite easy. So, make yourself an ops$oracle account and grant it DBA. Then run the jobs from the oracle crontab and start sqlplus like this: sqlplus / Easy enough! I'm sure there will be security comments against this. If someone has compromised your oracle UNIX account, then logging into the database without a password as a dba is probably the least of your worries. Hope this helps. --Michael -Original Message- Sent: Tuesday, June 19, 2001 3:04 PM To: Multiple recipients of list ORACLE-L We recognized the same problem and found this program as an answer: http://www.orafaq.org/scripts/c_src/hide.txt Michael Armstead Application Database Administrator, OCP-Certified US Pharmaceuticals IT Glaxo SmithKline -Original Message- From: Kris Austin [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, June 19, 2001 2:38 PM To: Multiple recipients of list ORACLE-L Subject: ps -ef | grep sqlplus hi, do you know how to hide oracle passwords from ps -ef? we pass in our pw in cron, and it shows up when you run ps -ef (to check unix processes). i recognize that is this NOT a smart thing to do... can anyone recommend a better way of supplying oracle passwords when scripts are connecting to oracle? do you use config files that store pws? just curious what everyone else is doing to plug this security hole. thanks, kris -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kris Austin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Armstead, Michael A INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jenkins, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: [RE: ps -ef | grep sqlplus]
Look at OPS$ user accounts in the DOC's. Yigal Kimberly Smith [EMAIL PROTECTED] wrote: We use an externally identified account here to sign on to the database from cron for DBA related tasks. Since only the dba team knows the oracle Unix password it works for us well. -Original Message- Sent: Tuesday, June 19, 2001 11:38 AM To: Multiple recipients of list ORACLE-L hi, do you know how to hide oracle passwords from ps -ef? we pass in our pw in cron, and it shows up when you run ps -ef (to check unix processes). i recognize that is this NOT a smart thing to do... can anyone recommend a better way of supplying oracle passwords when scripts are connecting to oracle? do you use config files that store pws? just curious what everyone else is doing to plug this security hole. thanks, kris -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kris Austin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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). Get free email and a permanent address at http://www.amexmail.com/?A=1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yigal Ran INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ps -ef | grep sqlplus
Here is our method: 1. We save the passwords in a file using the OS level command CRYPT. 2. To run something we call a script file from Cron that first goes and gets the encrypted password from config file. 3. Then we decrypt the password using CRYPT. 4. Then we start the sql process with the /nolog option. 5. Then we connect to the database using the connect userid/password@database command. This has a few advantages: 1. The passwords are not visible on the command line. 2. The passwords are not in every script file. They are only kept in one config file. 3. The config file only keeps encrypted passwords. -Original Message- Sent: Tuesday, June 19, 2001 1:38 PM To: Multiple recipients of list ORACLE-L hi, do you know how to hide oracle passwords from ps -ef? we pass in our pw in cron, and it shows up when you run ps -ef (to check unix processes). i recognize that is this NOT a smart thing to do... can anyone recommend a better way of supplying oracle passwords when scripts are connecting to oracle? do you use config files that store pws? just curious what everyone else is doing to plug this security hole. thanks, kris -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kris Austin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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).
Re: [RE: ps -ef | grep sqlplus]
Look at OPS$ user accounts in the DOC's. Yigal Kimberly Smith [EMAIL PROTECTED] wrote: We use an externally identified account here to sign on to the database from cron for DBA related tasks. Since only the dba team knows the oracle Unix password it works for us well. -Original Message- Sent: Tuesday, June 19, 2001 11:38 AM To: Multiple recipients of list ORACLE-L hi, do you know how to hide oracle passwords from ps -ef? we pass in our pw in cron, and it shows up when you run ps -ef (to check unix processes). i recognize that is this NOT a smart thing to do... can anyone recommend a better way of supplying oracle passwords when scripts are connecting to oracle? do you use config files that store pws? just curious what everyone else is doing to plug this security hole. thanks, kris -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kris Austin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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). Get free email and a permanent address at http://www.amexmail.com/?A=1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yigal Ran INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 find the table size?
I need to calculate the size of the table assuming one of the rows is having all the columns maxsize possible. I don't understand your question. Do you want to plan in advance to make an estimate of how large a table will be, or are you looking at an existing database and wanting to find out how large the tables are right now? - Greg -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: duel error
Dual is not a table. It just a placeholder. At 11:04 AM 6/19/01 -0800, you wrote: You could always just run catalog.sql as sys. -Original Message- Sent: Tuesday, June 19, 2001 11:32 AM To: Multiple recipients of list ORACLE-L Your email says duel. You created dual, with an a, right? And did you grant select on dual to public? And create a public synonym for it? HTH, Yosi Shirish Khapre wrote: hi i accidentally dropped duel table from sys..then recreated it. now when i am using rman during running the catrman.sql for recovery_catalog it is flashing error select '08.00.05' from dual * ERROR at line 2: ORA-00942: table or view does not exist u'r help is highly appreciated Shirish Khapre, SE Rolta India Ltd. Off Ph No. (+91) (022) 832,826,8300568 Ext'n 2730 Minds are like parachutes. They only function when they are open -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shirish Khapre INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Thanks, Yosi - Yosi Greenfield Oracle Certified DBA [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Hal Wigoda INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: duel error
Wrong, DUAL is a table owner by the SYS user that contains one row. Check your DBA_TABLES and DBA_OBJECTS views. [EMAIL PROTECTED] 06/19/01 03:56PM Dual is not a table. It just a placeholder. At 11:04 AM 6/19/01 -0800, you wrote: You could always just run catalog.sql as sys. -Original Message- Sent: Tuesday, June 19, 2001 11:32 AM To: Multiple recipients of list ORACLE-L Your email says duel. You created dual, with an a, right? And did you grant select on dual to public? And create a public synonym for it? HTH, Yosi Shirish Khapre wrote: hi i accidentally dropped duel table from sys..then recreated it. now when i am using rman during running the catrman.sql for recovery_catalog it is flashing error select '08.00.05' from dual * ERROR at line 2: ORA-00942: table or view does not exist u'r help is highly appreciated Shirish Khapre, SE Rolta India Ltd. Off Ph No. (+91) (022) 832,826,8300568 Ext'n 2730 Minds are like parachutes. They only function when they are open -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shirish Khapre INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Thanks, Yosi - Yosi Greenfield Oracle Certified DBA [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Hal Wigoda INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: William Beilstein INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: duel error
I think Dual is a table. 1 SELECT TABLE_NAME FROM SYS.DBA_TABLES 2* WHERE TABLE_NAME='DUAL' SQL / TABLE_NAME -- DUAL SQL DESC DUAL NameNull?Type --- DUMMYVARCHAR2(1) -Original Message- Sent: Tuesday, June 19, 2001 3:56 PM To: Multiple recipients of list ORACLE-L Dual is not a table. It just a placeholder. At 11:04 AM 6/19/01 -0800, you wrote: You could always just run catalog.sql as sys. -Original Message- Sent: Tuesday, June 19, 2001 11:32 AM To: Multiple recipients of list ORACLE-L Your email says duel. You created dual, with an a, right? And did you grant select on dual to public? And create a public synonym for it? HTH, Yosi Shirish Khapre wrote: hi i accidentally dropped duel table from sys..then recreated it. now when i am using rman during running the catrman.sql for recovery_catalog it is flashing error select '08.00.05' from dual * ERROR at line 2: ORA-00942: table or view does not exist u'r help is highly appreciated Shirish Khapre, SE Rolta India Ltd. Off Ph No. (+91) (022) 832,826,8300568 Ext'n 2730 Minds are like parachutes. They only function when they are open -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shirish Khapre INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Thanks, Yosi - Yosi Greenfield Oracle Certified DBA [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Hal Wigoda INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: New system, cart blanche, what to buy
My feelings are that the list strongly likes AIX as far as getting more bang for your buck. - E -Original Message- Sent: Tuesday, June 19, 2001 11:38 AM To: Multiple recipients of list ORACLE-L All, For a position that would (possibly) like me to set up an Oracle infrastructure from scratch, on Unix. Given the opportunity to choose from any system, what hardware would you pick? From the small bit of information I've been able to glean, it'll be fairly large, and need failover. I obviosuly can't guess the size of the system, but one part of the question is vendor. I'm familiar with Solaris, but HP seems to be platform of choice these days. And each vendor has their own storage methodologies, and their own HA clustering mechanisms. And there's always OPS. Any opinions, pointers, caveats? (Is this a broad enough question? :-) Yosi -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- This e-mail 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: MOVE PARTITION
alter table tblname move partition partition_name tablespace tbs_name -Original Message- Sent: Monday, June 18, 2001 11:17 AM To: Multiple recipients of list ORACLE-L Helo all, How can i move one or more paritions from one tablespace to another. I checked the objects for TSPITR, in that some of objects are in SYSTEM tablespace. Any help pls. Nirmal. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tortorelli, Mary Jo INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
strange problem after installing Oracle816
Hi all, I installed Oracle8.1.6 on a SunOS 5.6 box. That box already had 815 and 817 installed. When I'm in 816 Oracle_HOME/bin, sqlplus works fine but when I do svrmgrl which does exist, I got this: ld.so.1: svrmgrl: fatal: relocation error: file svrmgrl: symbol kghla42_: referenced symbol not found Killed I got the same error when run in 817home/bin, but in 815/bin, it works just fine. The PATH only have 815home/bin in it. Is it the path problem??? but I was in 816home/bin when I executed svrmgrl. Thank you! Andrea __ Do You Yahoo!? Spot the hottest trends in music, movies, and more. http://buzz.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrea Oracle INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Transportable tablespace problem in 817
This is a bug. You've probably got an ORA-600 too in your alert log. I had the same
problem and upgraded to 8.1.7.1 to fix it.
Saul Solomon
Senior Database Administrator
PPG Industries
[EMAIL PROTECTED]
412 434-3504
-Original Message-
Sent: Tuesday, June 19, 2001 4:22 PM
To: Multiple recipients of list ORACLE-L
I'm trying to a transportable but the export session is hanging.
The v$session says the session is actually active.
Anybody here has any such experience?
Any ideas to resolve this?
Thanks
Kumanan
SQL set autoprint on serveroutput on
SQL exec dbms_tts.transport_set_check ('DATA',TRUE);
PL/SQL procedure successfully completed.
SQL select * from sys.transport_set_violations;
VIOLATIONS
Index KBALASUN.PK_USERS_USERID in tablespace INDEXTS enforces primary
constriant
s of table KBALASUN.USERS in tablespace DAT
SQL exec dbms_tts.transport_set_check ('DATA,INDEXTS',TRUE);
PL/SQL procedure successfully completed.
SQL select * from sys.transport_set_violations;
no rows selected
alter tablespace data read only;
alter tablespace data read only;
/tmp ora $ env
NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1
ORACLE_SID=KBDB
ORA_NLS33=/export/home/oracle/product/8.1.7/ocommon/nls/admin/data
ORACLE_HOME=/export/home/oracle/product/8.1.7
/tmp ora $ exp transport_tablespace=y tablespaces=DATA,INDEXTS
file=testtrans.dmp
Export: Release 8.1.7.0.0 - Production on Tue Jun 19 19:30:37 2001
(c) Copyright 2000 Oracle Corporation. All rights reserved.
Username: sys as sysdba
Password:
Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
JServer Release 8.1.7.0.0 - Production
Export done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character
set
Note: table data (rows) will not be exported
About to export transportable tablespace metadata...
its just hanging forever.
**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
[EMAIL PROTECTED]
This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.
www.mimesweeper.com
**
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kumanan Balasundaram
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be 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: Solomon, Saul 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).
RE: * I'm Looking for an Oracle Financials DBA for Miami,
This advise was applicable to those living outside USA and not living in NEWYORK/CALIFORNIA as they are already well aware of such sites... Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Tue, 19 Jun 2001 10:55:59 -0800 That would be good advice also for people form New York and / or California that might be interested in migrating to the USA for work also, with all the dot com layoffs. Check www.monster.com www.dice.com www.net-temps.com for jobs positions and put your resume to see response before deciding to migrate to USA. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Tue, 19 Jun 2001 05:56:13 -0800 Florida has always been a weak market compared to rest of the USA. I remember in NYC, you could go get another job at a lunchtime interview. DC area has a good job market. Pick up the NY Times or Washington Post. Not sure on the rest of the country. BTW, the financials job in Miami is at DelMonte and they have been looking for over a year. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Page, Bruce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
sql query read from text file
Hi If i have one file a.txt and I want to put that content in where clause of sql statement then how can I do it. Example : a.txt content 98989 67676 898989 Select x,y,z from abc where x in (98989,67676,898989) / Actuall I want to do it in unix.I want to know the first 2 or 3 high CPU using processes then by putting this pid we can get the oracle user name and what sql statement that oracle user are executing. if some have any similar kind of scripts let me know. Thanks -Seema _ 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: duel error
Uh Hal,
You should read the books. Dual is a table.
And whoever suggested to re-run catalog was not quite correct.
Dual is created in the sql.bsq file.
the actual script says:
=== from sql.bsq ===
create table dual /* pl/sql's standard pckg requires dual.
*/
(dummy varchar2(1))/* note, the optimizer knows sys.dual is single row
*/
storage (initial 1)
/
insert into dual values('X')
/
create public synonym dual for dual
/
grant select on dual to public with grant option
=== from sql.bsq ===
there! I did my research for the day! :)
Tom Mercadante
-Original Message-
Sent: Tuesday, June 19, 2001 3:56 PM
To: Multiple recipients of list ORACLE-L
Dual is not a table.
It just a placeholder.
At 11:04 AM 6/19/01 -0800, you wrote:
You could always just run catalog.sql as sys.
-Original Message-
Sent: Tuesday, June 19, 2001 11:32 AM
To: Multiple recipients of list ORACLE-L
Your email says duel. You created dual, with an a, right?
And did you grant select on dual to public? And create a
public synonym for it?
HTH,
Yosi
Shirish Khapre wrote:
hi
i accidentally dropped duel table from sys..then recreated it.
now when i am using rman during running the catrman.sql for
recovery_catalog
it is flashing error
select '08.00.05' from dual
*
ERROR at line 2:
ORA-00942: table or view does not exist
u'r help is highly appreciated
Shirish Khapre, SE Rolta India Ltd.
Off Ph No. (+91) (022) 832,826,8300568
Ext'n 2730
Minds are like parachutes. They only function when they are open
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Shirish Khapre
INET: [EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mercadante, Thomas F
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Transportable tablespace problem in 817
I'm trying to a transportable but the export session is hanging.
The v$session says the session is actually active.
Anybody here has any such experience?
Any ideas to resolve this?
Thanks
Kumanan
SQL set autoprint on serveroutput on
SQL exec dbms_tts.transport_set_check ('DATA',TRUE);
PL/SQL procedure successfully completed.
SQL select * from sys.transport_set_violations;
VIOLATIONS
Index KBALASUN.PK_USERS_USERID in tablespace INDEXTS enforces primary
constriant
s of table KBALASUN.USERS in tablespace DAT
SQL exec dbms_tts.transport_set_check ('DATA,INDEXTS',TRUE);
PL/SQL procedure successfully completed.
SQL select * from sys.transport_set_violations;
no rows selected
alter tablespace data read only;
alter tablespace data read only;
/tmp ora $ env
NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1
ORACLE_SID=KBDB
ORA_NLS33=/export/home/oracle/product/8.1.7/ocommon/nls/admin/data
ORACLE_HOME=/export/home/oracle/product/8.1.7
/tmp ora $ exp transport_tablespace=y tablespaces=DATA,INDEXTS
file=testtrans.dmp
Export: Release 8.1.7.0.0 - Production on Tue Jun 19 19:30:37 2001
(c) Copyright 2000 Oracle Corporation. All rights reserved.
Username: sys as sysdba
Password:
Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
JServer Release 8.1.7.0.0 - Production
Export done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character
set
Note: table data (rows) will not be exported
About to export transportable tablespace metadata...
its just hanging forever.
**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
[EMAIL PROTECTED]
This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.
www.mimesweeper.com
**
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kumanan Balasundaram
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
