Re: What is Oracle made from ?
Hmm, I thought that powerpoint was the development environment for microsoft products ;-) Anjo. Abdul Aleem wrote: I don't think so, I think they just don't know Aleem -Original Message- Sent: Thursday, April 18, 2002 7:53 AM To: Multiple recipients of list ORACLE-L Subject:RE: What is Oracle made from ? Apparently folks are bored today. -Original Message- Engsig Sent: Wednesday, April 17, 2002 11:04 AM To: Multiple recipients of list ORACLE-L Obviously, the reality is that it is made of Powerpoint slides On Wednesday 17 April 2002 19:28, Farnsworth, Dave wrote: And all this time I had thought it was made from widgets and gizmos. ;o) -Original Message- Sent: Wednesday, April 17, 2002 11:03 AM To: Multiple recipients of list ORACLE-L Nope just C Anjo. Kimberly Smith wrote: I believe its C++ now but it was C. -Original Message- Xing Sent: Tuesday, April 16, 2002 11:48 PM To: Multiple recipients of list ORACLE-L Hi all, Just for my own info, Is Oracle written in C ? 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). -- 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). -- Bjørn Engsig, Miracle A/S http://MiracleAS.dk -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Bj=F8rn=20Engsig?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Abdul Aleem INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Anjo Kolk INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note
Import excelfile into Oracle table
Hallo, anyone who can give me a good example of pl/sql code, which does the folllowing: Import an excelfile into a table. (I know I can use sqlloader(which I have used several times) but i would like to make a call to that pl/sql procedure from MsAccess. Thanks in advance Roland -- 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: Script for identifying objects having freelists contention
SELECT s.segment_name,s.segment_type,s.freelists,w.wait_time,w.seconds_in_wait,w.state FROM dba_segments s , V$session_wait w WHERE s.header_file=w.p1 AND s.header_block=w.p2; Bunyamin K. Karadeniz Oracle DBA / DeveloperCivilian IT DepartmentHavelsan A.S. Eskisehir yolu 7.km Ankara TurkeyPhone: +90 312 2873565 / 1217Mobile : +90 535 3357729 The degree of normality in a database is inversely proportional to that of its DBA. - Original Message - From: Aponte, Tony To: Multiple recipients of list ORACLE-L Sent: Thursday, April 18, 2002 8:13 AM Subject: RE: Script for identifying objects having freelists contention Steve Adams' site is a good start. http://www.ixora.com.au/ Tony Aponte -Original Message-From: Anand Prakash [mailto:[EMAIL PROTECTED]]Sent: Wednesday, April 17, 2002 5:29 PMTo: Multiple recipients of list ORACLE-LSubject: Script for identifying objects having freelists contention Does anyone have the scripts (or URL) for identifying objects having freelists contention? Thanks. Anand Prakash
RE: Upgrade 8.0.5 to 8.1.7.3
Call me paranoid. I'll go for the two phase upgrade (when it's time and all tests are completed) and make end-user suffer a little more down-time (bye bye weekend) We upgraded our peoplesoft test environment already and that is being tested, sofar w/o problems Besides I've heard that there may be another patchset 8.1.7.4 (maybe even 8.1.7.5) coming.Maybe those patch sets aren't so picky anymore. Jack Mercadante, Thomas FTo: '[EMAIL PROTECTED]' [EMAIL PROTECTED] [EMAIL PROTECTED]cc: '[EMAIL PROTECTED]' [EMAIL PROTECTED] te.ny.usSubject: RE: Upgrade 8.0.5 to 8.1.7.3 17-04-2002 17:19 Jack, I went from 805 to 816 with no problem at all (this was before 817 was available). The differences between 816 and 817 were minor. I would go for it. If you want, create a test 805 database and migrate it to 8172 directly to see what happens. You should do this *anyway* to make sure you don't have any issues. I would even go so far as to create a small 805 database, create all of your objects in it (using export/import) and migrate it. this way, you get no surprises. hope this helps Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, April 17, 2002 10:43 AM To: Multiple recipients of list ORACLE-L Hi All, we are in the process of upgrading to 8.1.7.3 some of our databases (now 8.0.5) According to the Doc's thsi has to be done in two steps Upgrade to 8.1.7.0.0 followed by and upgrade to 8.1.7.3.0. This means that we have to upgrade all our databases in one go, or install another base 8.1.7 install to do some databases later. On our test system however we have upgraded directly form 8.0.5 and all seems to be fine. Anybody care to comment/share their opinions/experiences TIA Jack === 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.
Installing Tora on RH 6.2
Hi Gurus I have downloaded .rpm file o Tora ..the tool used to access Oracle on Linux. I want to install it on my linux box where I have oracle 8i (8.1.6) I have connected to the root user and gave following command and got the error below # rpm -ivh tora-1.2.2-1gc-glibc21.i686.rpm error: failed dependencies: libDCOP.so.1 is needed by tora-1.2.2-1gc libXft.so.1 is needed by tora-1.2.2-1gc libXrender.so.1 is needed by tora-1.2.2-1gc libcrypto.so.0 is needed by tora-1.2.2-1gc libfreetype.so.6 is needed by tora-1.2.2-1gc libkdecore.so.3 is needed by tora-1.2.2-1gc libkdefakes.so.3 is needed by tora-1.2.2-1gc libkdesu.so.1 is needed by tora-1.2.2-1gc libkdeui.so.3 is needed by tora-1.2.2-1gc libkfile.so.3 is needed by tora-1.2.2-1gc libkhtml.so.3 is needed by tora-1.2.2-1gc libkio.so.3 is needed by tora-1.2.2-1gc libkjava.so.1 is needed by tora-1.2.2-1gc libkparts.so.1 is needed by tora-1.2.2-1gc libkssl.so.2 is needed by tora-1.2.2-1gc libksycoca.so.3 is needed by tora-1.2.2-1gc libmng.so.1 is needed by tora-1.2.2-1gc libqt-mt.so.2 is needed by tora-1.2.2-1gc libssl.so.0 is needed by tora-1.2.2-1gc libstdc++-libc6.1-2.so.3 is needed by tora-1.2.2-1gc libmysqlclient.so.9 is needed by tora-1.2.2-1gc Amol Get Your Private, Free E-mail from Indiatimes at http://email.indiatimes.com Buy Music, Video, CD-ROM, Audio-Books and Music Accessories from http://www.planetm.co.in -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: amolsonaikar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Accessing Synonym
you have to grant that user rights on that specific table grant select on inventory.table to user; -Oorspronkelijk bericht- Van: Abdul Aleem [SMTP:[EMAIL PROTECTED]] Verzonden:donderdag 18 april 2002 8:18 Aan: Multiple recipients of list ORACLE-L Onderwerp:Accessing Synonym Hi, I tried to create a public synonym for a table in schema inventory, but it does not seem to be working, i.e., when I connect as another user, and try to select from the synonym it says table or view does not exist. I would appreciate any help. Aleem Following are the commands from SQL*Plus: SQL connect inventory/invent@test_server mailto:inventory/invent@test_server Connected. SQL create public synonym company for company; Synonym created. SQL connect scott/tiger@test_server mailto:scott/tiger@test_server Connected. SQL select * from company; select * from company * ERROR at line 1: ORA-00942: table or view does not exist SQL select * from inventory.company; select * from inventory.company * ERROR at line 1: ORA-00942: table or view does not exist -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Abdul Aleem INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: MySQL vs. Oracle database
I have not been so much with MySQL , But want to share my experience. Firstly , it is very fast ...This makes me suspicious , I wonder if it is trusted to be integral . Seem like no control ..Does not contain rollbacks , may be this .. Then how does it rollback ? I have used a version where stored procs ,functions are unavailable .. Wonder if it has now.. Bunyamin K. Karadeniz Oracle DBA / Developer Civilian IT Department Havelsan A.S. Eskisehir yolu 7.km Ankara Turkey Phone: +90 312 2873565 / 1217 Mobile : +90 535 3357729 The degree of normality in a database is inversely proportional to that of its DBA. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, April 17, 2002 10:31 PM -- Weaver, Walt [EMAIL PROTECTED] I don't think you're wrong. MySQL gets dissed frequently on this list, but it's really a nice little product. IMHO it's much closer to Oracle than Access. It works well for us. Doesn't scale like Oracle, but works well. In some ways it scales better than Oracle. For load+query (a.k.a., warehouse) operations it can be faster than Oracle because it doesn't get tangled up with rollbacks, etc. On systms with many instances it also can be much simpler to administer. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bunyamin K. Karadeniz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
DBMS_SHARED_POOL.KEEP
I want to pin most run packages , I have loeded
them into a table. For this I have written ,
create or replace procedure pin_packages_defined
assql_sentence varchar2(200);cursor_name
INTEGER;rows_processed INTEGER;CURSOR tab_cur
IS SELECT owner,object_name FROM
arsiv.pin_aday_objeler;tab_row
tab_cur%ROWTYPE;BEGINFOR tab_row IN tab_cur
LOOP--EXECUTE IMMEDIATE 'EXEC
SYS.DBMS_SHARED_POOL.KEEP('||tab_row.owner||'.'||tab_row.object_name||')';
cursor_name :=
dbms_sql.open_cursor;sql_sentence :='SYS.DBMS_SHARED_POOL.KEEP('''||tab_row.owner||'.'||tab_row.object_name||''')';
dbms_output.put_line(sql_sentence);dbms_sql.parse(cursor_name,sql_sentence,
dbms_sql.native);rows_processed :=
dbms_sql.execute(cursor_name);dbms_sql.close_cursor(cursor_name);END
LOOP;END;
But , It does not execute , Is it impossible
to execute DBMS_SHARED_POOL.KEEP dynamically ...I tried DBMS_JOB , It did not
work too.
How can I do this?
Bunyamin K.
Karadeniz Oracle
DBA / DeveloperCivilian IT DepartmentHavelsan A.S. Eskisehir yolu
7.km Ankara TurkeyPhone: +90 312 2873565 / 1217Mobile : +90 535
3357729
The degree of normality in a database is
inversely proportional to that of its DBA.
Re: MySQL vs. Oracle database
By default MySQL has no transactions You have to add special component to access transactional safe tables called Berkeley db tables. You can commit and rollback on only these tables. For others every wrong (not syntactically, but for example inserting characters into number column) insert and update will succeed. If MySQL cannot insert provided values it uses default values. One of the biggest pains is (maybe was, I don't know about MySQL 4.xxx) that it has no foreign keys : I have created class diagramms for both Oracle and Mysql servers for my studies in University. It cannot be treated as feature comparison but just simple overview of these two images will show the situation i.e. compare object count on these images :-) And I have to say that Oracle diagramm isn't complete! Oracle server class diagramm http://www.itsystems.lv/gints/files/oracle/oracle_s.htm Mysql server class diagramm http://www.itsystems.lv/gints/files/mysql/mysql.htm Gints Plivna IT Sistçmas, Meríeïa 13, LV1050 Rîga http://www.itsystems.lv/gints/ Bunyamin K. Karadeniz To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] bunyamink@havelscc: an.com.tr Subject: Re: MySQL vs. Oracle database Sent by: [EMAIL PROTECTED] 2002.04.18 10:43 Please respond to ORACLE-L I have not been so much with MySQL , But want to share my experience. Firstly , it is very fast ...This makes me suspicious , I wonder if it is trusted to be integral . Seem like no control ..Does not contain rollbacks , may be this .. Then how does it rollback ? I have used a version where stored procs ,functions are unavailable .. Wonder if it has now.. Bunyamin K. Karadeniz Oracle DBA / Developer Civilian IT Department Havelsan A.S. Eskisehir yolu 7.km Ankara Turkey Phone: +90 312 2873565 / 1217 Mobile : +90 535 3357729 The degree of normality in a database is inversely proportional to that of its DBA. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, April 17, 2002 10:31 PM -- Weaver, Walt [EMAIL PROTECTED] I don't think you're wrong. MySQL gets dissed frequently on this list, but it's really a nice little product. IMHO it's much closer to Oracle than Access. It works well for us. Doesn't scale like Oracle, but works well. In some ways it scales better than Oracle. For load+query (a.k.a., warehouse) operations it can be faster than Oracle because it doesn't get tangled up with rollbacks, etc. On systms with many instances it also can be much simpler to administer. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of
Re:Import excelfile into Oracle table
Hi, You'd better do the following: * Convert the excel file to .csv file. * Use utl_file package to read the data and insert to Oracle Tables. M.Emre HANCIOGLU Masterfoods GmbH
Ang: Re:Import excelfile into Oracle table
Ok, thanks can you give me a good example on how to write the pl/sql code? Thanks in advance. Roland [EMAIL PROTECTED]@fatcity.com den 2002-04-18 01:10 PST Sänd svar till [EMAIL PROTECTED] Sänt av: [EMAIL PROTECTED] Till: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Kopia: Hi, You'd better do the following: * Convert the excel file to .csv file. * Use utl_file package to read the data and insert to Oracle Tables. M.Emre HANCIOGLU Masterfoods GmbH -- 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: HIGH CPU WITH MULTIPLE CONCURRENT USERS (long)
There appear to be a number of contradictory items in your posting; presumably due to the passage of time and the number of variations and experiments that have take place. You seem to indicate that a simple select on a single table using an IN list takes 2 seconds to complete, but the time escalates to 7 seconds when you run 10 concurrent copies. Also that there is a suggestion that this 2 seconds is due to a wait between parsing and fetching. Two seconds is a very long time for a simple query. How long is the IN list, what is the execution plan, are you using bind variables, is there an nvl() function involved in columns referenced in the WHERE clause, and have you tried a 10053 trace ? How are you determining that there is a two-second wait between the parse and the fetch, and when you say WAIT, can I infer from your comments about CPU usage that you mean that there is some indication of 2 seconds of lost time but a) Oracle does not show a wait in v$session_wait b) the CPU does not go idle. There are a number of possible anomalies in the information that you have sent to Oracle, and your init.ora has a number of strange settings which may be affecting things (possibly because of bugs, possibly because of resource demands and forced code paths). However, based on your initial description, I think Oracle is chewing up CPU trying to optimize your query, and I would take steps to check whether this is actually the case (e.g. keep reducing the size of the IN list). Jonathan Lewis http://www.jlcomp.demon.co.uk Author of: Practical Oracle 8i: Building Efficient Databases Next Seminar - Australia - July/August http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html -Original Message- Sent: Wednesday, April 17, 2002 1:58 AM To: Multiple recipients of list ORACLE-L A co-worker is having a fairly serious issue with performance tuning of a system. The system is in the stress testing phase prior to rolling out into production. I have not included all the information as so far they have exceeded three TARs and are working on the fourth one right now. Oracle has become fairly heavily involved and is sending in the Advanced services team is now involved. He has identified that the main issue is a wait after the parsing of the SQL and during the fetch portion of the execution. The short version is running the same SQL statement ( basically nothing more than a simple query against a single table) the machine starts bogging down with a simulated 20+ users sessions and the system starts to choke at 100+ user sessions. We are talking a fairly decent midrange system. The query is a select with 5 columns extracted and a where clause that uses the in clause to select the same rows for each query. The question is has anyone seen this type of behavior before? If you have seen this before what was the root cause? Did you find a solution? Oracle acknowledges that the scenario is reproducible within their test environment, but the core team is stating that it is working as designed. Oracle is working with us, but why not check with other sources. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: What is Oracle made from ?
I always wondered who got the shaft, I had assumed it was customers. On 17 Apr 2002 at 9:23, Jan Pruner wrote: No, it is of the most gentle substrate of the shaft of moon light. [EMAIL PROTECTED] wrote: I believe its C++ now but it was C. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Archiving Data Strategies.
Council on Library and Information Resources http://www.clir.org/home.html - http://www.clir.org/pubs/issues/issues25.html#plan - -- http://www.clir.org/pubs/reports/rothenberg/contents.html Avoiding Technological Quicksand: Finding a Viable Technical Foundation for Digital Preservation by Jeff Rothenberg January 1998 Contents Preface Executive Summary Introduction The Digital Longevity Problem Preservation in the Digital Age The Scope of the Problem Technical Dimensions of the Problem The Inadequacy of Most Proposed Approaches Criteria for an Ideal Solution The Emulation Solution Research Required for the Emulation Approach Summary References ---end--- On 15 Apr 2002 at 9:49, [EMAIL PROTECTED] wrote: Ian, I've put of replying to this for a couple of weeks now. I see that no one else has replied either, at least to the list. Archiving data is a rather complex subject. ... Biddell, Ian [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 03/27/02 01:53 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Archiving Data Strategies. Hi All, I previously posted this question to the Lazydba List and got a couple of replies, but thought I would also send it to this list as well to see if I can just get a couple more (so excuses to those people that have already seen it) I am currently discussing with a customer their requirements for archiving data as their system is 4 years old and billing data is piling up which obviously is affecting performance. I am pushing for an Oracle upgrade, they are currently on 7.3.4 and I am trying to get them to go to 9i. The main reason for this is so they can use partitioning. My question to the List is to try and find out other people's experiences in archiving complex and integral data and whether most have gone the partitioning path or some other path (ie. Something like separate tables and data migration). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:Re:Import excelfile into Oracle table
Here is an example. As far as I know, utl_file package reads data from unix box. So the file path below should be on Unix and be careful about your rights writing or reading from this path.
DECLARE
outfile_handle UTL_FILE.FILE_TYPE;
v_test VARCHAR2(1000) ;
BEGIN
outfile_handle := UTL_FILE.FOPEN('FILE PATH','file_name','A');
v_test := 'This is a Test ' ;
-- To write a line into the file
UTL_FILE.PUT_LINE(outfile_handle, v_test) ;
-- To close the file
UTL_FILE.FCLOSE (outfile_handle) ;
EXCEPTION
WHEN UTL_FILE.INVALID_FILEHANDLE
THEN
DBMS_OUTPUT.PUT_LINE('Invalid File Handle');
UTL_FILE.FCLOSE_ALL;
WHEN UTL_FILE.INVALID_MODE
THEN
UTL_FILE.FCLOSE_ALL;
DBMS_OUTPUT.PUT_LINE('Invalid Mode');
WHEN UTL_FILE.INTERNAL_ERROR
THEN
UTL_FILE.FCLOSE_ALL;
DBMS_OUTPUT.PUT_LINE('Internal Error');
WHEN UTL_FILE.INVALID_OPERATION
THEN
UTL_FILE.FCLOSE_ALL;
DBMS_OUTPUT.PUT_LINE('Invalid Operation');
WHEN UTL_FILE.INVALID_PATH
THEN
UTL_FILE.FCLOSE_ALL;
DBMS_OUTPUT.PUT_LINE('Invalid Path');
WHEN UTL_FILE.READ_ERROR
THEN
UTL_FILE.FCLOSE_ALL;
DBMS_OUTPUT.PUT_LINE('Read Error');
WHEN UTL_FILE.WRITE_ERROR
THEN
UTL_FILE.FCLOSE_ALL;
DBMS_OUTPUT.PUT_LINE('Write Error');
WHEN NO_DATA_FOUND
THEN
UTL_FILE.FCLOSE_ALL;
DBMS_OUTPUT.PUT_LINE('No Data Found');
WHEN VALUE_ERROR
THEN
UTL_FILE.FCLOSE_ALL;
DBMS_OUTPUT.PUT_LINE('Value Error' || step || ' ' || SUBSTR(V_BUFF,25,7) || step);
WHEN OTHERS
THEN
UTL_FILE.FCLOSE_ALL;
DBMS_OUTPUT.PUT_LINE('Error!' || substr(sqlerrm,1,75) || step);
utl_file.fclose_all;
END ;
M.Emre HANCIOGLU
Masterfoods Services GmbH
ISI Application Support
Tel : +49 2162 500-576
Fax: +49 2162 41497
E-Mail: [EMAIL PROTECTED]
[EMAIL PROTECTED]
ica.se
Sent by: [EMAIL PROTECTED]
18.04.02 11:38
Please respond to ORACLE-L
To:
Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:
Ang: Re:Import excelfile into Oracle table
Ok, thanks can you give me a good example on how to write the pl/sql code?
Thanks in advance.
Roland
[EMAIL PROTECTED]@fatcity.com den 2002-04-18 01:10 PST
Sänd svar till [EMAIL PROTECTED]
Sänt av: [EMAIL PROTECTED]
Till: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Kopia:
Hi,
You'd better do the following:
* Convert the excel file to .csv file.
* Use utl_file package to read the data and insert to Oracle Tables.
M.Emre HANCIOGLU
Masterfoods GmbH
--
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: PK field - number of char
Brian, Your figures for the number of bytest are incorrect. A 38 digit number (max Oracle can handle) takes approximately 20 bytes, a 38 character varchar2 takes 39 bytes. To answer the original question: The only difference would be in converting the external format of the data (e.g. a double or int in the number case) to the internal format and in the space used; as soon as it is under the hood of Oracle both numbers and varchar2s are simply a variable length string of bytes, which needs to be saved in the index and compared. If your data really is numerical, you save space (and hence potentially some time inside the kernel) if it is stored as number but you pay with a potentailly somewhat slower conversion between internal and external format. In practical terms, it probably doesn't matter enough to care, so your decision should be based on what you really have, i.e. numerical data should be stored in number, text data in varchar2. Thanks, Bjørn. On Thursday 18 April 2002 00:53, Brian Haas wrote: Tom, Well you got me sort of. I ran a few quick tests on a table with 500K rows. The return times were almost always identical. The main difference between a Pk with a number and a char/varchar is storage. a 40 digit number takes 4bytes of space. A 40 character string takes 10 bytes. This translated into the character datatype moving 30 more bytes per query over sql*net than the number datatype. On a heavily used application hitting a backend Oracle DB via sql*net, those extra bytes could make a difference in response time. but I guess that is more of a network bottleneck than a database one. here are my results: char(40) Pk: Elapsed: 00:00:00.52 Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=2 Card=1 Bytes=10) 10 INDEX (UNIQUE SCAN) OF 'PKTEST_CHAR_PK' (UNIQUE) (Cost=2 C ard=1 Bytes=10) Statistics -- 0 recursive calls 0 db block gets 3 consistent gets 0 physical reads 0 redo size 239 bytes sent via SQL*Net to client 253 bytes received via SQL*Net from client 3 SQL*Net roundtrips to/from client 0 sorts (memory) 0 sorts (disk) 1 rows processed number datatype: Elapsed: 00:00:00.51 Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=2 Card=1 Bytes=4) 10 INDEX (UNIQUE SCAN) OF 'PKTEST_PK' (UNIQUE) (Cost=2 Card=1 Bytes=4) Statistics -- 0 recursive calls 0 db block gets 3 consistent gets 0 physical reads 0 redo size 218 bytes sent via SQL*Net to client 246 bytes received via SQL*Net from client 3 SQL*Net roundtrips to/from client 0 sorts (memory) 0 sorts (disk) 1 rows processed -Brian On Wed, 2002-04-17 at 11:52, Mercadante, Thomas F wrote: All, Does anyone have any specific metrics demonstrating that a PK that is based on a number field is faster than a PK based on a character field? I've seen it mentioned a couple of times today under the Design Question topic. It doesn't make any sense to me that one or the other would be faster. After all, we are talking about comparison searches within the B-Tree index structure. Why searching down the tree for a number is any faster than a char is lost on me. -- Bjørn Engsig, Miracle A/S http://MiracleAS.dk -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Bj=F8rn=20Engsig?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Security Hole
For those of you with Metalink access, there is now a patch to this bug for 9.0.1.3 Patch number is 2121935. Platforms covered are: HP 9000 series HP-UX 64-bit Sun Sparc Solaris 64-bit IBM RS/6000 64-bit Sun Sparc Solaris Digital Alpha OpenVMS LINUX Intel Compaq Tur64 UNIX Jonathan Lewis http://www.jlcomp.demon.co.uk Author of: Practical Oracle 8i: Building Efficient Databases Next Seminar - Australia - July/August http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html -Original Message- To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: 16 April 2002 11:37 |This just in from comp.databases.oracle.server. | |See metalink bug 2121935. | |Using ANSI syntax joins (CROSS JOIN, LEFT OUTER etc) |allows you to view data from tables on which you have no |privilege. For example, try this COMPLETE script: | |connect / as sysdba |create user us1 identified by us1; |grant create session to us1; | |connect us1/us1 | |select userid, password |from |sys.link$ cross join dual |; | | | |Worse still, if you have the privilege to create views |then this loophole allows you to seek and destroy |ANY DATA in the database that you might want to. | |The bug is fixed in 9iR2. I didn't see any note |about a backport, or a security alert on OTN. | |Conclusion: | |9.0.1 should not be in use on production system |until Oracle supplies a fix. | | | |Jonathan Lewis |http://www.jlcomp.demon.co.uk | |Author of: |Practical Oracle 8i: Building Efficient Databases | |Next Seminar - Australia - July/August |http://www.jlcomp.demon.co.uk/seminar.html | |Host to The Co-Operative Oracle Users' FAQ |http://www.jlcomp.demon.co.uk/faq/ind_faq.html | | | | -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: datafile sizing ?
Darren, It also depends on the extent sizes you use for the tables in the tablespace. Will each extent completely use the datafile or will there be wasted space in the smaller datafiles. As an example: if there is 100 M free space and the extent is 150 M it will not fit in the datafile and will use the next free space in the new datafile, wasting the 100 M free space. That can add up to a lot of space over time. Also remember to set the MAXDATAFILE to a limit allowable by the os. once you reach the limit if it is set small you have to rebuild the database to raise the limit. Different os's have different limits. Ron ROR mª¿ªm [EMAIL PROTECTED] 04/17/02 08:34PM Darren, discuss this with your SA. There may be a limit on the os side you need to be aware of. Also, consider MTTR. Seems to me that MTTR won't be that different between a 500MB file and a 2GB file. Beyond that, it's your comfort level. Personally I like having larger files for ease of administration. Lisa Koivu Oracle Database Monkey Mama Fairfield Resorts, Inc. 954-935-4117 -Original Message- From: Browett, Darren [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 5:48 PM To: Multiple recipients of list ORACLE-L Subject: datafile sizing ? I am currently building a new 8i database, and have the oppurtunity to consolidate some of my datafiles. In the current configuration I have 4 500Mb datafiles that make up a tablespace. Is it okay to create a 2Gb datafile, or am I better off to create 2 1Gb datafile's, or stay with 4 500Mb datafiles. Thanks Darren -- -- -- Darren Browett P.Eng This message was transmitted Data Administratorusing 100% recycled electrons Information and Communication Technology City of Coquitlam P:(604)927 - 3614 E:[EMAIL PROTECTED] -- -- --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Browett, Darren INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: RAC
Jonathan, At the seminars I have attended it was pointed out that the :true RAC is COMPAQ only. The seminar was hosted by Oracle/Compaq. Compaq RAC allows multiple CPU's to mount and use/share the same datafiles in a true RAC configuration. The drives including the os drive are on a SAN and shared by the CPU's so knowledge is shared. It was pointed out the new Linux RAC can only share a RAW device and not a datafile. I don't know if this is true as I have not tried it yet. The speaker at the seminar said that with other OS's a RAC is like a High Availability (HA) option, one CPU is doing nothing until the first one fails or you only run different applications and datafiles on one CPU and other applications and datafiles on the second CPU. if one fails you have to mount the datafiles and switch applications to the active CPU. To use a true RAC you have to use Compaq and I think the market share of the OS's are not True64, so there are probably not a lot of users of RAC. Ron ROR mª¿ªm [EMAIL PROTECTED] 04/17/02 10:18PM I was talking w/someone today, and we realized that neither of us knows of anyone actually using RAC in production. So now I'm curious. Is anyone? Jonathan Gennick --- Brighten the corner where you are mailto:[EMAIL PROTECTED] http://Gennick.com * http://MichiganWaterfalls.com * http://ValleySpur.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: data cleansing question
Lisam I also would check with the end-users of the data. Marc's points are valid - but if the end-users (or programmers) accessing the data do not have experience with a relational system, they will stumble and grumble about having to learn to use the NVL function. I personally feel that this is a good learning experience for them (drag them screaming and kicking into the relational world). But sometimes, the fight is just not worth it. If this is a small isolated database with few users, then just say screw-it - populate it exactly as it exists on the IBM mainframe. If you want to educate them in the real-world, then trim the fields to replace the zeros with nulls. hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, April 17, 2002 8:38 PM To: Multiple recipients of list ORACLE-L Hi Marc, No and no, as far as I know. I should double check on the user requirements, you are right. (It would be helpful if THEY knew) Thanks, you bring up a good point. LK -Original Message- From: Marc Perkowitz [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 8:04 PM To: Multiple recipients of list ORACLE-L Subject: Re: data cleansing question Do you have mainframe programs that will be brought over to use this mainframe data? If so, they will likely have problems with nulls. If there will only be new programs accessing this data, then it sounds fine. Will there by any statistical work on these columns? Averages, for example, will be different with zeroes versus nulls. Marc Perkowitz Senior Consultant TWJ Consulting, LLP 847-256-8866 x15 www.twjconsulting.com - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, April 17, 2002 5:43 PM For those of you who have had to deal with data cleansing - I am working on importing mainframe data into Oracle. This unglamorous job involves validating (and sometimes compensating for) what is bad data in Oracle's eyes but not on the mainframe - crazy crap like a date = 22/22/2022. I also find that the mainframe programs are padding null fields with 0's. I wonder how many of you take the route of removing the zeros and storing null in that field? Some of the important numeric fields I think I'll leave that way (past_due_amt, etc.) but several others in this 218-field table are full of zeroes. My gut feel is to null out the insignificant 0'd out fields - that I have pushed to the bottom of the table - to not only save space, but for data integrity. 0 in 75 fields means nothing to me or to anyone else, as far as I can tell. Thoughts? Thanks everyone Lisa Koivu Oracle Database Hormone Dispenser. Fairfield Resorts, Inc. 954-935-4117 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Marc Perkowitz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858)
RE: PK field - number or char
Brian Bjorn, Thanks for the replies. Sql*Net traffic, in my mind, is insignificant. If we are trying to determine query speed, most of the tests should be done with more than one table in the query, with a join against the table in question. It is not very often that we will be querying one table (really talking about code tables - or static lookup tables - state codes, country codes etc.) and if we are, the speed doesn't matter in my mind. It is the constant join against the table that is more common and would have the larger impact if the index was significantly slower for a char field rather than a number field that I was thinking about. And these types of joins (passing the sql query across the network) would have the same network cost - the sql string is not any larger. I just had the feeling that if this ws an issue, Oracle would have warned us a *long* time ago that char index values are slower than number index values (or someone on this list would have figued it out long ago). thanks Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, April 17, 2002 6:53 PM To: Multiple recipients of list ORACLE-L Tom, Well you got me sort of. I ran a few quick tests on a table with 500K rows. The return times were almost always identical. The main difference between a Pk with a number and a char/varchar is storage. a 40 digit number takes 4bytes of space. A 40 character string takes 10 bytes. This translated into the character datatype moving 30 more bytes per query over sql*net than the number datatype. On a heavily used application hitting a backend Oracle DB via sql*net, those extra bytes could make a difference in response time. but I guess that is more of a network bottleneck than a database one. here are my results: char(40) Pk: Elapsed: 00:00:00.52 Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=2 Card=1 Bytes=10) 10 INDEX (UNIQUE SCAN) OF 'PKTEST_CHAR_PK' (UNIQUE) (Cost=2 C ard=1 Bytes=10) Statistics -- 0 recursive calls 0 db block gets 3 consistent gets 0 physical reads 0 redo size 239 bytes sent via SQL*Net to client 253 bytes received via SQL*Net from client 3 SQL*Net roundtrips to/from client 0 sorts (memory) 0 sorts (disk) 1 rows processed number datatype: Elapsed: 00:00:00.51 Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=2 Card=1 Bytes=4) 10 INDEX (UNIQUE SCAN) OF 'PKTEST_PK' (UNIQUE) (Cost=2 Card=1 Bytes=4) Statistics -- 0 recursive calls 0 db block gets 3 consistent gets 0 physical reads 0 redo size 218 bytes sent via SQL*Net to client 246 bytes received via SQL*Net from client 3 SQL*Net roundtrips to/from client 0 sorts (memory) 0 sorts (disk) 1 rows processed -Brian On Wed, 2002-04-17 at 11:52, Mercadante, Thomas F wrote: All, Does anyone have any specific metrics demonstrating that a PK that is based on a number field is faster than a PK based on a character field? I've seen it mentioned a couple of times today under the Design Question topic. It doesn't make any sense to me that one or the other would be faster. After all, we are talking about comparison searches within the B-Tree index structure. Why searching down the tree for a number is any faster than a char is lost on me. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian Haas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: 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
RE: DBMS_SHARED_POOL.KEEP
Bunyamin,
Either try
removing the 'EXEC' or try putting a begin and end around the
call?
EXECUTE IMMEDIATE
'SYS.DBMS_SHARED_POOL.KEEP('||tab_row.owner||'.'||tab_row.object_name||')';
or
EXECUTE IMMEDIATE 'BEGIN
SYS.DBMS_SHARED_POOL.KEEP('||tab_row.owner||'.'||tab_row.object_name||')' || ';
END';
This is a great idea,
by the way! Let us know how it works!
Tom Mercadante Oracle Certified Professional
-Original Message-From: Bunyamin K. Karadeniz
[mailto:[EMAIL PROTECTED]]Sent: Thursday, April 18, 2002
4:28 AMTo: Multiple recipients of list ORACLE-LSubject:
DBMS_SHARED_POOL.KEEP
I want to pin most run packages , I have loeded
them into a table. For this I have written ,
create or replace procedure pin_packages_defined
assql_sentence varchar2(200);cursor_name
INTEGER;rows_processed INTEGER;CURSOR tab_cur
IS SELECT owner,object_name FROM
arsiv.pin_aday_objeler;tab_row
tab_cur%ROWTYPE;BEGINFOR tab_row IN
tab_cur LOOP--EXECUTE
IMMEDIATE 'EXEC
SYS.DBMS_SHARED_POOL.KEEP('||tab_row.owner||'.'||tab_row.object_name||')';
cursor_name :=
dbms_sql.open_cursor;sql_sentence :='SYS.DBMS_SHARED_POOL.KEEP('''||tab_row.owner||'.'||tab_row.object_name||''')';
dbms_output.put_line(sql_sentence);dbms_sql.parse(cursor_name,sql_sentence,
dbms_sql.native);rows_processed :=
dbms_sql.execute(cursor_name);dbms_sql.close_cursor(cursor_name);END
LOOP;END;
But , It does not execute , Is it
impossible to execute DBMS_SHARED_POOL.KEEP dynamically ...I tried DBMS_JOB ,
It did not work too.
How can I do this?
Bunyamin K.
Karadeniz
Oracle DBA / DeveloperCivilian IT DepartmentHavelsan A.S.
Eskisehir yolu 7.km Ankara TurkeyPhone: +90 312 2873565 /
1217Mobile : +90 535 3357729
The degree of normality in a database is
inversely proportional to that of its
DBA.
RE: OBJECT DESING
Seema, PCTINCREASE - always 0. PCTFREE - for lookup (code) tables = 10 for others, I use 20. My theory is that lookup tables have little or no updates, so this value should be small. If you have a high-update tables (columns that are updated a 8lot* after the record was created, you may want a higher value here. PCTUSED - for lookup (code) tables = 90, for others, I use 80. Again, for lookup tables with little or no updates, I fill the data blocks as high as possible. For other tables, I currently use 80 as a starting point. You will get many opinions here - read the docs to determine what you think is best for you. Hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, April 17, 2002 5:38 PM To: Multiple recipients of list ORACLE-L Hi WHat is best practices for PCTFREE,PCTUSED AND PCT_INCREASE value at object level? Thx -seema _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).
System datafile corruption.
Guys, I have a system datafile that returns dbv errors for a SYSTEM datafile. The fault has existed for a long time undiscovered so recovery from backup is not possible. The database still does not exhibit any problems except for dbv! The errors are all 'Block Type = Undo data block', so I assume the fault is in the system rollback segment. I'm sure I can't drop/recreate the SYSTEM rbs, so does anyone have any suggestions apart from a full export and import? Dbv extract is below: Block Checking: DBA = 67108870, Block Type = Undo data block ERROR: Undo Block Corrupted. Error Code = 2008 ktu4ubck: size(108) of undo record #1 corrupted. UNDO BLK HEADER: xid: 0x.08a.0151 seq: 0x198 cnt: 0x4d irb: 0x4d icl: 0x0 flg: 0x000 0 Rec Offset | Rec Offset | Rec Offset | Rec Offset | Rec Offset --- 0x00 0x1fe8 | 0x01 0x1f80 | 0x02 0x1f2e | 0x03 0x1ee0 | 0x04 0x1e76 . . 0x4b 0x027c | 0x4c 0x0212 | 0x4d 0x01b0 Hex dump: 0x000b6b94(+): 00 0a 00 10 00 3c 00 10 00 02 00 00 2a 11 00 00 . . 0x000b6bf4(+0060): 00 9d 00 00 78 bc 01 00 grep 'Block Type' dbv_log | wc -l 127 Regards, Mike Jenner Database Administrator -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jenner Mike INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RAC
I saw this here too, the 9iRAC servers are each about the size of a laptop! They did a demonstration cluster with OPS with the clustered servers sitting on a table. I asked a pointed question to one of the presenters re. iAS, whether it uses less memory than it used to when it first came out. It took him a while to answer, finally he just said that it uses less memory server-side, but it still uses a lot. He didn't mention how much. 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] -Original Message- Sent: Thursday, April 18, 2002 9:38 AM To: Multiple recipients of list ORACLE-L Subject:Re: RAC Jonathan, At the seminars I have attended it was pointed out that the :true RAC is COMPAQ only. The seminar was hosted by Oracle/Compaq. Compaq RAC allows multiple CPU's to mount and use/share the same datafiles in a true RAC configuration. The drives including the os drive are on a SAN and shared by the CPU's so knowledge is shared. It was pointed out the new Linux RAC can only share a RAW device and not a datafile. I don't know if this is true as I have not tried it yet. The speaker at the seminar said that with other OS's a RAC is like a High Availability (HA) option, one CPU is doing nothing until the first one fails or you only run different applications and datafiles on one CPU and other applications and datafiles on the second CPU. if one fails you have to mount the datafiles and switch applications to the active CPU. To use a true RAC you have to use Compaq and I think the market share of the OS's are not True64, so there are probably not a lot of users of RAC. Ron ROR mª¿ªm [EMAIL PROTECTED] 04/17/02 10:18PM I was talking w/someone today, and we realized that neither of us knows of anyone actually using RAC in production. So now I'm curious. Is anyone? Jonathan Gennick --- Brighten the corner where you are mailto:[EMAIL PROTECTED] http://Gennick.com * http://MichiganWaterfalls.com * http://ValleySpur.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: 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: Training for Oracle 8i
Hi Peter, A test box, documentation and time to play is what worked for me. Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 954-935-4117 -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 1:53 AM To: Multiple recipients of list ORACLE-L Subject: Training for Oracle 8i Dear Guru: I have a number of staff needs to upgrade their skills from Oracle 7.3.4 to Oracle 8.1.7. Going to Oracle Education Center will be too expensive given that I am looking at 7 person. Anyone have experience with electronic training using the Oracle CD-ROM training package, NETg On-line training, or other third party training tools? If yes, any recommendations? Pete -- 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: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Ang: Re:Import excelfile into Oracle table
RTFM where the Fine Manual = PL/SQL for Dummies or Teach Yourself PL/SQL in 21 Days [EMAIL PROTECTED] wrote: Ok, thanks can you give me a good example on how to write the pl/sql code? Thanks in advance. Roland [EMAIL PROTECTED]@fatcity.com den 2002-04-18 01:10 PST Sänd svar till [EMAIL PROTECTED] Sänt av: [EMAIL PROTECTED] Till: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Kopia: Hi, You'd better do the following: * Convert the excel file to .csv file. * Use utl_file package to read the data and insert to Oracle Tables. M.Emre HANCIOGLU Masterfoods GmbH -- 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: Charlie Mengler INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
World's largest database...
http://www.computerworld.com/storyba/0,4125,NAV47_STO70250,00.html I thought we had someone on this list from this group, and was just wondering if this particular database was in Oracle or not. Jim -- _ Jim Hawkins Oracle Database Administrator [EMAIL PROTECTED] St. Louis, MO USA __ Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: DBMS_SHARED_POOL.KEEP
Tried and does not work ..
Bunyamin K.
Karadeniz Oracle
DBA / DeveloperCivilian IT DepartmentHavelsan A.S. Eskisehir yolu
7.km Ankara TurkeyPhone: +90 312 2873565 / 1217Mobile : +90 535
3357729
The degree of normality in a database is inversely proportional to that
of its DBA.
- Original Message -
From:
Mercadante, Thomas F
To: Multiple recipients of list ORACLE-L
Sent: Thursday, April 18, 2002 4:18
PM
Subject: RE: DBMS_SHARED_POOL.KEEP
Bunyamin,
Either try
removing the 'EXEC' or try putting a begin and end around the
call?
EXECUTE IMMEDIATE
'SYS.DBMS_SHARED_POOL.KEEP('||tab_row.owner||'.'||tab_row.object_name||')';
or
EXECUTE IMMEDIATE 'BEGIN
SYS.DBMS_SHARED_POOL.KEEP('||tab_row.owner||'.'||tab_row.object_name||')' ||
'; END';
This is a great
idea, by the way! Let us know how it works!
Tom Mercadante Oracle Certified Professional
-Original Message-From: Bunyamin K. Karadeniz
[mailto:[EMAIL PROTECTED]]Sent: Thursday, April 18, 2002
4:28 AMTo: Multiple recipients of list
ORACLE-LSubject: DBMS_SHARED_POOL.KEEP
I want to pin most run packages , I have loeded
them into a table. For this I have written ,
create or replace procedure pin_packages_defined
assql_sentence varchar2(200);cursor_name
INTEGER;rows_processed INTEGER;CURSOR tab_cur
IS SELECT owner,object_name FROM
arsiv.pin_aday_objeler;tab_row
tab_cur%ROWTYPE;BEGINFOR tab_row IN
tab_cur LOOP--EXECUTE
IMMEDIATE 'EXEC
SYS.DBMS_SHARED_POOL.KEEP('||tab_row.owner||'.'||tab_row.object_name||')';
cursor_name :=
dbms_sql.open_cursor;sql_sentence :='SYS.DBMS_SHARED_POOL.KEEP('''||tab_row.owner||'.'||tab_row.object_name||''')';
dbms_output.put_line(sql_sentence);dbms_sql.parse(cursor_name,sql_sentence,
dbms_sql.native);rows_processed :=
dbms_sql.execute(cursor_name);dbms_sql.close_cursor(cursor_name);END
LOOP;END;
But , It does not execute , Is it
impossible to execute DBMS_SHARED_POOL.KEEP dynamically ...I tried DBMS_JOB
, It did not work too.
How can I do
this?
Bunyamin K.
Karadeniz
Oracle DBA / DeveloperCivilian IT DepartmentHavelsan A.S.
Eskisehir yolu 7.km Ankara TurkeyPhone: +90 312 2873565 /
1217Mobile : +90 535 3357729
The degree of normality in a database is
inversely proportional to that of its
DBA.
RE: What is Oracle made from ?
I thought it was BASIC...after all, their still pushing Visual Basic down our throats while the rest of the world has moved on... Everyone knows that Bill Gates invented DOS and Basic...and Steve Ballmer was jealous so he invented the Internet... My humble apologies Jared... -Original Message- Sent: Thursday, April 18, 2002 3:13 AM To: Multiple recipients of list ORACLE-L Hmm, I thought that powerpoint was the development environment for microsoft products ;-) Anjo. Abdul Aleem wrote: I don't think so, I think they just don't know Aleem -Original Message- Sent: Thursday, April 18, 2002 7:53 AM To: Multiple recipients of list ORACLE-L Subject:RE: What is Oracle made from ? Apparently folks are bored today. -Original Message- Engsig Sent: Wednesday, April 17, 2002 11:04 AM To: Multiple recipients of list ORACLE-L Obviously, the reality is that it is made of Powerpoint slides On Wednesday 17 April 2002 19:28, Farnsworth, Dave wrote: And all this time I had thought it was made from widgets and gizmos. ;o) -Original Message- Sent: Wednesday, April 17, 2002 11:03 AM To: Multiple recipients of list ORACLE-L Nope just C Anjo. Kimberly Smith wrote: I believe its C++ now but it was C. -Original Message- Xing Sent: Tuesday, April 16, 2002 11:48 PM To: Multiple recipients of list ORACLE-L Hi all, Just for my own info, Is Oracle written in C ? 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). -- 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). -- Bjørn Engsig, Miracle A/S http://MiracleAS.dk -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Bj=F8rn=20Engsig?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Abdul Aleem INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the
RE: Upgrade 8.0.5 to 8.1.7.3
Huh. 8.1.7.4. or 8.1.7.5. After what I went through with 8.1.7.3.1., I am leery of applying any more Oracle patchsets. Last I heard they planned to release 8.1.7.3.2, but I didn't hear anything about major patchsets coming out. Aren't they now developing 9i Release 2 or 3 (not sure, we are at 8.1.7 here) due out this summer, and 10i now? 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] -Original Message- Sent: Thursday, April 18, 2002 4:48 AM To: Multiple recipients of list ORACLE-L Subject:RE: Upgrade 8.0.5 to 8.1.7.3 Call me paranoid. I'll go for the two phase upgrade (when it's time and all tests are completed) and make end-user suffer a little more down-time (bye bye weekend) We upgraded our peoplesoft test environment already and that is being tested, sofar w/o problems Besides I've heard that there may be another patchset 8.1.7.4 (maybe even 8.1.7.5) coming.Maybe those patch sets aren't so picky anymore. Jack Mercadante, Thomas FTo: '[EMAIL PROTECTED]' [EMAIL PROTECTED] [EMAIL PROTECTED]cc: '[EMAIL PROTECTED]' [EMAIL PROTECTED] te.ny.usSubject: RE: Upgrade 8.0.5 to 8.1.7.3 17-04-2002 17:19 Jack, I went from 805 to 816 with no problem at all (this was before 817 was available). The differences between 816 and 817 were minor. I would go for it. If you want, create a test 805 database and migrate it to 8172 directly to see what happens. You should do this *anyway* to make sure you don't have any issues. I would even go so far as to create a small 805 database, create all of your objects in it (using export/import) and migrate it. this way, you get no surprises. hope this helps Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, April 17, 2002 10:43 AM To: Multiple recipients of list ORACLE-L Hi All, we are in the process of upgrading to 8.1.7.3 some of our databases (now 8.0.5) According to the Doc's thsi has to be done in two steps Upgrade to 8.1.7.0.0 followed by and upgrade to 8.1.7.3.0. This means that we have to upgrade all our databases in one go, or install another base 8.1.7 install to do some databases later. On our test system however we have upgraded directly form 8.0.5 and all seems to be fine. Anybody care to comment/share their opinions/experiences TIA Jack === 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.
Re: RAC
Ron, This information is incorrect. RAC is available on there platforms without shared file systems. I have RAC running on SUN, NT and Linux. All of these platforms have shared raw devices and are concurrently accessed. RAC on shared file systems is only supported on Tru64, OpenVMS and starting in July it will be supported on Solaris using Veritas's CFS (9iR2+ Only). Oracle is also developing a CFS that will ship later this summer or fall that will be supported with 9iR2. The other thing is that RAC does not support SAN drives at this time. Only single instance environments support SAN environments with specific equipment. Scott --- Ron Rogers [EMAIL PROTECTED] wrote: Jonathan, At the seminars I have attended it was pointed out that the :true RAC is COMPAQ only. The seminar was hosted by Oracle/Compaq. Compaq RAC allows multiple CPU's to mount and use/share the same datafiles in a true RAC configuration. The drives including the os drive are on a SAN and shared by the CPU's so knowledge is shared. It was pointed out the new Linux RAC can only share a RAW device and not a datafile. I don't know if this is true as I have not tried it yet. The speaker at the seminar said that with other OS's a RAC is like a High Availability (HA) option, one CPU is doing nothing until the first one fails or you only run different applications and datafiles on one CPU and other applications and datafiles on the second CPU. if one fails you have to mount the datafiles and switch applications to the active CPU. To use a true RAC you have to use Compaq and I think the market share of the OS's are not True64, so there are probably not a lot of users of RAC. Ron ROR mª¿ªm [EMAIL PROTECTED] 04/17/02 10:18PM I was talking w/someone today, and we realized that neither of us knows of anyone actually using RAC in production. So now I'm curious. Is anyone? Jonathan Gennick --- Brighten the corner where you are mailto:[EMAIL PROTECTED] http://Gennick.com * http://MichiganWaterfalls.com * http://ValleySpur.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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). __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RAC
I meant iFS of course, not iAS! Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Thursday, April 18, 2002 10:53 AM To: Multiple recipients of list ORACLE-L Subject:RE: RAC I saw this here too, the 9iRAC servers are each about the size of a laptop! They did a demonstration cluster with OPS with the clustered servers sitting on a table. I asked a pointed question to one of the presenters re. iAS, whether it uses less memory than it used to when it first came out. It took him a while to answer, finally he just said that it uses less memory server-side, but it still uses a lot. He didn't mention how much. 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] -Original Message- Sent: Thursday, April 18, 2002 9:38 AM To: Multiple recipients of list ORACLE-L Subject:Re: RAC Jonathan, At the seminars I have attended it was pointed out that the :true RAC is COMPAQ only. The seminar was hosted by Oracle/Compaq. Compaq RAC allows multiple CPU's to mount and use/share the same datafiles in a true RAC configuration. The drives including the os drive are on a SAN and shared by the CPU's so knowledge is shared. It was pointed out the new Linux RAC can only share a RAW device and not a datafile. I don't know if this is true as I have not tried it yet. The speaker at the seminar said that with other OS's a RAC is like a High Availability (HA) option, one CPU is doing nothing until the first one fails or you only run different applications and datafiles on one CPU and other applications and datafiles on the second CPU. if one fails you have to mount the datafiles and switch applications to the active CPU. To use a true RAC you have to use Compaq and I think the market share of the OS's are not True64, so there are probably not a lot of users of RAC. Ron ROR mª¿ªm [EMAIL PROTECTED] 04/17/02 10:18PM I was talking w/someone today, and we realized that neither of us knows of anyone actually using RAC in production. So now I'm curious. Is anyone? Jonathan Gennick --- Brighten the corner where you are mailto:[EMAIL PROTECTED] http://Gennick.com * http://MichiganWaterfalls.com * http://ValleySpur.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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
Oracle 9i Application Server
Greetings Gurus Im new to Oracle. Could you please tell me what is the difference between Oracle 9i and Oracle Application Server ? Regards, Gagandeep Singh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gagandeep 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: Accessing Synonym
Does the table inventory.company exist? Abdul Aleem dmitTo: Multiple recipients of list ORACLE-L @beaconhouse.[EMAIL PROTECTED] edu.pk cc: Sent by: rootSubject: Accessing Synonym 04/18/2002 02:18 AM Please respond to ORACLE-L Hi, I tried to create a public synonym for a table in schema inventory, but it does not seem to be working, i.e., when I connect as another user, and try to select from the synonym it says table or view does not exist. I would appreciate any help. Aleem Following are the commands from SQL*Plus: SQL connect inventory/invent@test_server mailto:inventory/invent@test_server Connected. SQL create public synonym company for company; Synonym created. SQL connect scott/tiger@test_server mailto:scott/tiger@test_server Connected. SQL select * from company; select * from company * ERROR at line 1: ORA-00942: table or view does not exist SQL select * from inventory.company; select * from inventory.company * ERROR at line 1: ORA-00942: table or view does not exist -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Abdul Aleem INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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).
SQLLDR core dumping
Hi I installed 9iAS 1.0.2.2.2 on Solaris 8. All went well except the Portal component failed. When I tried to re-run the opca (portal configuration assistant) it failed on a segmentation fault in SQLLDR. Oracle support seems to be stumped by this. Has anyone else run into this? Thanks, Ben Poels Queen's University -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ben Poels INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: World's largest database...
At the Oracle Technology Day here they mentioned that one of the largest databases belongs to the Church Of Latter Day Saints, if you can believe it. They mentioned it in a seminar which also talked about iFS, I don't know they were implying that it relies on iFS. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Thursday, April 18, 2002 11:03 AM To: Multiple recipients of list ORACLE-L Subject:World's largest database... http://www.computerworld.com/storyba/0,4125,NAV47_STO70250,00.html I thought we had someone on this list from this group, and was just wondering if this particular database was in Oracle or not. Jim -- _ Jim Hawkins Oracle Database Administrator [EMAIL PROTECTED] St. Louis, MO USA -- 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: MySQL vs. Oracle database
In our testing the Berkeley table types were hopelessly slow and bloated, taking up much more space than MyISAM or InnoDB table types. We had more success with the InnoDB table type, and will be implementing them some time in the future. InnoDB supports referential integrity. The table types aren't really a special component; they're implemented via an argument when the source is compiled. --Walt Weaver Bozeman, Montana -Original Message- Sent: Thursday, April 18, 2002 3:03 AM To: Multiple recipients of list ORACLE-L By default MySQL has no transactions You have to add special component to access transactional safe tables called Berkeley db tables. You can commit and rollback on only these tables. For others every wrong (not syntactically, but for example inserting characters into number column) insert and update will succeed. If MySQL cannot insert provided values it uses default values. One of the biggest pains is (maybe was, I don't know about MySQL 4.xxx) that it has no foreign keys : I have created class diagramms for both Oracle and Mysql servers for my studies in University. It cannot be treated as feature comparison but just simple overview of these two images will show the situation i.e. compare object count on these images :-) And I have to say that Oracle diagramm isn't complete! Oracle server class diagramm http://www.itsystems.lv/gints/files/oracle/oracle_s.htm Mysql server class diagramm http://www.itsystems.lv/gints/files/mysql/mysql.htm Gints Plivna IT Sistçmas, Meríeïa 13, LV1050 Rîga http://www.itsystems.lv/gints/ Bunyamin K. Karadeniz To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] bunyamink@havelscc: an.com.tr Subject: Re: MySQL vs. Oracle database Sent by: [EMAIL PROTECTED] 2002.04.18 10:43 Please respond to ORACLE-L I have not been so much with MySQL , But want to share my experience. Firstly , it is very fast ...This makes me suspicious , I wonder if it is trusted to be integral . Seem like no control ..Does not contain rollbacks , may be this .. Then how does it rollback ? I have used a version where stored procs ,functions are unavailable .. Wonder if it has now.. Bunyamin K. Karadeniz Oracle DBA / Developer Civilian IT Department Havelsan A.S. Eskisehir yolu 7.km Ankara Turkey Phone: +90 312 2873565 / 1217 Mobile : +90 535 3357729 The degree of normality in a database is inversely proportional to that of its DBA. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, April 17, 2002 10:31 PM -- Weaver, Walt [EMAIL PROTECTED] I don't think you're wrong. MySQL gets dissed frequently on this list, but it's really a nice little product. IMHO it's much closer to Oracle than Access. It works well for us. Doesn't scale like Oracle, but works well. In some ways it scales better than Oracle. For load+query (a.k.a., warehouse) operations it can be faster than Oracle because it doesn't get tangled up with rollbacks, etc. On systms with many instances it also can be much simpler to administer. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bunyamin K. Karadeniz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ:
Re: HIGH CPU WITH MULTIPLE CONCURRENT USERS (long)
Hi Richard, Consider hiring Steve Adams (Ixora) to work for you. His rates are reasonable and he has worked problems exactly like this dozens of times. He is the most competent troubleshooter of these types of problems I have ever worked with and I highly recommend you consider retaining his services. That being said... :-) Your shared pool size of 1G is ridiculous. Try 150M, unset spin_count, throw the rest in db_block_buffers, and please show us the statspack output after that. Also, go to www.ixora.com.au, and download a few scripts: latch_sleeps.sql, latch_where.sql. The output might be interesting. Finally, run a select * from v$sqlarea where version_count 100. Any sql statement in that list is probably part of your problem, and finding out why it's getting invalidated will be part of your solution. HTH, Paul ---www.pythian.com -- [EMAIL PROTECTED] -- 877-PYTHIANSmarter than adding another team member, Pythian has new services forsupplementing DBAs: get our help with monitoring, 24x7 on-call, dailyverifications, storage management, performance and more. - Original Message - From: Paul Troiano To: Multiple recipients of list ORACLE-L Sent: Wednesday, April 17, 2002 11:48 PM Subject: Re: HIGH CPU WITH MULTIPLE CONCURRENT USERS (long) Never mind. I just saw that oracle was able to reproduce it internally. - Original Message - From: Richard Eastham To: Multiple recipients of list ORACLE-L Sent: Tuesday, April 16, 2002 11:58 PM Subject: HIGH CPU WITH MULTIPLE CONCURRENT USERS (long) A co-worker is having a fairly serious issue with performance tuning of a system. The system is in the stress testing phase prior to rolling out into production. I have not included all the information as so far they have exceeded three TARs and are working on the fourth one right now. Oracle has become fairly heavily involved and is sending in the Advanced services team is now involved. He has identified that the main issue is a wait after the parsing of the SQL and during the fetch portion of the execution. The short version is running the same SQL statement ( basically nothing more than a simple query against a single table) the machine starts bogging down with a simulated 20+users sessions and the system starts to choke at 100+ user sessions. We are talking a fairlydecent midrange system. The query is a select with 5 columns extracted and a where clause that uses the in clause to select the same rows for each query. The question is has anyone seen this type of behavior before? If you have seen this before what was the root cause? Did you find a solution? Oracle acknowledges that the scenario is reproducible within their test environment, but the core team is stating that it is working as designed. Oracle is working with us, but why not check with other sources. A summary of where we are at: (4th TAR) We tried to simulate the same performance degradation on an entirely different environment. We have been able to do the same. We had requested Oracle to simulate the test case in their environment. They have been able simulate the performance degradation. Their analysis is also provided in this attachment. To summarize, they have simulated where 1 user query runs in 2 seconds and 10-user query takes 7 seconds on a 4-processor server. The development team of Oracle has answered to this degradation as normal and as designed. However, the degradation is very high and is in contrast with their alleged benchmark results (67000 transactions per minute on a 8 processor hardware). For us the degradation is so high that we are not able to run 150 transactions per minute on a 4-processor server. The simulation within oracle also supports this degradation 15-APR-02 22:09:08 GMTPasting information into the tar on bug:2321553 Abstract: HIGH CPU WITH MULTIPLE CONCURRENT USERS since currently unavailable on MetaLink:"PROBLEM:Customer has a production database that was installed on a Sun Solaris 2.8. The Solaris was a fresh install. The database was a fresh install. Customer is having the following problems:.1. Performance problems with multiple users - more users more performance problems2. The query runs fine, explain plan runs fine, query just takes moer time with more users - same query3. Customer tested multi-user connection from the box via sqlplus ( no network ) - same issue4. Customer removed the application from the env and ran multi-user test - same problem.5. Customer loaded data in another 8.1.7 database on Win 2000 - same
RE: Ang: Re:Import excelfile into Oracle table
Or sql*loader. csv isn't the best choice of file format in my opinion (will any of your fields have commas in them?) but sql*loader will pick up the file and slam it in faster than you can blink an eye. Lisa Koivu Oracle Database Monkey Mama Fairfield Resorts, Inc. 954-935-4117 -Original Message- From: Charlie Mengler [SMTP:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 10:03 AM To: Multiple recipients of list ORACLE-L Subject: Re: Ang: Re:Import excelfile into Oracle table RTFM where the Fine Manual = PL/SQL for Dummies or Teach Yourself PL/SQL in 21 Days [EMAIL PROTECTED] wrote: Ok, thanks can you give me a good example on how to write the pl/sql code? Thanks in advance. Roland [EMAIL PROTECTED]@fatcity.com den 2002-04-18 01:10 PST Sänd svar till [EMAIL PROTECTED] Sänt av: [EMAIL PROTECTED] Till: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Kopia: Hi, You'd better do the following: * Convert the excel file to .csv file. * Use utl_file package to read the data and insert to Oracle Tables. M.Emre HANCIOGLU Masterfoods GmbH -- 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: Charlie Mengler INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RAC
I remember they mentioned that Compaq Tru64 (and perhaps VMS) has a cluster file system which runs over fiber optic line between the cluster servers. The servers use it to stay in synch and to share information. For the datafiles, they recommended using one of the Tru64 file systems instead of RAW. The Compaq people said that direct I/O works with (one?) of their file systems. I remember a couple of years ago I was told that Tru64 4.0d didn't do true direct I/O, it was simulated. Oracle told me not to assume that Tru64 supported direct I/O for non-RAW partitions back then. Apparently that has been fixed. When they compared load sharing with other cluster servers, the only one they mentioned as an example was the Windows2000 cluster server, probably because it's popular. 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] -Original Message- Sent: Thursday, April 18, 2002 10:59 AM To: Multiple recipients of list ORACLE-L Subject:Re: RAC Ron, This information is incorrect. RAC is available on there platforms without shared file systems. I have RAC running on SUN, NT and Linux. All of these platforms have shared raw devices and are concurrently accessed. RAC on shared file systems is only supported on Tru64, OpenVMS and starting in July it will be supported on Solaris using Veritas's CFS (9iR2+ Only). Oracle is also developing a CFS that will ship later this summer or fall that will be supported with 9iR2. The other thing is that RAC does not support SAN drives at this time. Only single instance environments support SAN environments with specific equipment. Scott --- Ron Rogers [EMAIL PROTECTED] wrote: Jonathan, At the seminars I have attended it was pointed out that the :true RAC is COMPAQ only. The seminar was hosted by Oracle/Compaq. Compaq RAC allows multiple CPU's to mount and use/share the same datafiles in a true RAC configuration. The drives including the os drive are on a SAN and shared by the CPU's so knowledge is shared. It was pointed out the new Linux RAC can only share a RAW device and not a datafile. I don't know if this is true as I have not tried it yet. The speaker at the seminar said that with other OS's a RAC is like a High Availability (HA) option, one CPU is doing nothing until the first one fails or you only run different applications and datafiles on one CPU and other applications and datafiles on the second CPU. if one fails you have to mount the datafiles and switch applications to the active CPU. To use a true RAC you have to use Compaq and I think the market share of the OS's are not True64, so there are probably not a lot of users of RAC. Ron ROR mª¿ªm [EMAIL PROTECTED] 04/17/02 10:18PM I was talking w/someone today, and we realized that neither of us knows of anyone actually using RAC in production. So now I'm curious. Is anyone? Jonathan Gennick --- Brighten the corner where you are mailto:[EMAIL PROTECTED] http://Gennick.com * http://MichiganWaterfalls.com * http://ValleySpur.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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). __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego,
RE: RAC
fwiw, I have heard that licensing for RAC is incredibly expensive. But does that really suprise anyone? Lisa Koivu Oracle Database Hormone Oven Fairfield Resorts, Inc. 954-935-4117 -Original Message- From: Boivin, Patrice J [SMTP:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 9:53 AM To: Multiple recipients of list ORACLE-L Subject: RE: RAC I saw this here too, the 9iRAC servers are each about the size of a laptop! They did a demonstration cluster with OPS with the clustered servers sitting on a table. I asked a pointed question to one of the presenters re. iAS, whether it uses less memory than it used to when it first came out. It took him a while to answer, finally he just said that it uses less memory server-side, but it still uses a lot. He didn't mention how much. 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] -Original Message- Sent: Thursday, April 18, 2002 9:38 AM To: Multiple recipients of list ORACLE-L Subject: Re: RAC Jonathan, At the seminars I have attended it was pointed out that the :true RAC is COMPAQ only. The seminar was hosted by Oracle/Compaq. Compaq RAC allows multiple CPU's to mount and use/share the same datafiles in a true RAC configuration. The drives including the os drive are on a SAN and shared by the CPU's so knowledge is shared. It was pointed out the new Linux RAC can only share a RAW device and not a datafile. I don't know if this is true as I have not tried it yet. The speaker at the seminar said that with other OS's a RAC is like a High Availability (HA) option, one CPU is doing nothing until the first one fails or you only run different applications and datafiles on one CPU and other applications and datafiles on the second CPU. if one fails you have to mount the datafiles and switch applications to the active CPU. To use a true RAC you have to use Compaq and I think the market share of the OS's are not True64, so there are probably not a lot of users of RAC. Ron ROR mª¿ªm [EMAIL PROTECTED] 04/17/02 10:18PM I was talking w/someone today, and we realized that neither of us knows of anyone actually using RAC in production. So now I'm curious. Is anyone? Jonathan Gennick --- Brighten the corner where you are mailto:[EMAIL PROTECTED] http://Gennick.com * http://MichiganWaterfalls.com * http://ValleySpur.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
Re: What is Oracle made from ?
Correction. Basic was invented by two college professors at Dartmouth College in the early 1960's to replace Fortran for analytical analysis. They needed a language that was quick and easy to use and throw away the code after you did your analysis. It was not meant to be efficient since you threw it away after you used the program. And about 10 years ago they both said that if they knew what people were going to use Basic for they would not have invented it. Ken Janusz, CPIM - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, April 18, 2002 9:08 AM I thought it was BASIC...after all, their still pushing Visual Basic down our throats while the rest of the world has moved on... Everyone knows that Bill Gates invented DOS and Basic...and Steve Ballmer was jealous so he invented the Internet... My humble apologies Jared... -Original Message- Sent: Thursday, April 18, 2002 3:13 AM To: Multiple recipients of list ORACLE-L Hmm, I thought that powerpoint was the development environment for microsoft products ;-) Anjo. Abdul Aleem wrote: I don't think so, I think they just don't know Aleem -Original Message- Sent: Thursday, April 18, 2002 7:53 AM To: Multiple recipients of list ORACLE-L Subject:RE: What is Oracle made from ? Apparently folks are bored today. -Original Message- Engsig Sent: Wednesday, April 17, 2002 11:04 AM To: Multiple recipients of list ORACLE-L Obviously, the reality is that it is made of Powerpoint slides On Wednesday 17 April 2002 19:28, Farnsworth, Dave wrote: And all this time I had thought it was made from widgets and gizmos. ;o) -Original Message- Sent: Wednesday, April 17, 2002 11:03 AM To: Multiple recipients of list ORACLE-L Nope just C Anjo. Kimberly Smith wrote: I believe its C++ now but it was C. -Original Message- Xing Sent: Tuesday, April 16, 2002 11:48 PM To: Multiple recipients of list ORACLE-L Hi all, Just for my own info, Is Oracle written in C ? 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). -- 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). -- Bjørn Engsig, Miracle A/S http://MiracleAS.dk -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Bj=F8rn=20Engsig?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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 --
RE: DBMS_SHARED_POOL.KEEP
Um,
why can't you do this...
create or replace
procedure pin_packages_defined assql_sentence
varchar2(200);cursor_name
INTEGER;rows_processed INTEGER;CURSOR tab_cur
IS SELECT owner,object_name FROM
arsiv.pin_aday_objeler;tab_row
tab_cur%ROWTYPE;BEGINFOR tab_row IN tab_cur
LOOP DBMS_SHARED_POOL.KEEP(tab_row.owner||'.'||tab_row.object_name);
END LOOP;
-Original Message-From: Bunyamin K. Karadeniz
[mailto:[EMAIL PROTECTED]]Sent: 18 April 2002
09:28To: Multiple recipients of list ORACLE-LSubject:
DBMS_SHARED_POOL.KEEP
I want to pin most run packages , I have loeded
them into a table. For this I have written ,
create or replace procedure pin_packages_defined
assql_sentence varchar2(200);cursor_name
INTEGER;rows_processed INTEGER;CURSOR tab_cur
IS SELECT owner,object_name FROM
arsiv.pin_aday_objeler;tab_row
tab_cur%ROWTYPE;BEGINFOR tab_row IN
tab_cur LOOP--EXECUTE
IMMEDIATE 'EXEC
SYS.DBMS_SHARED_POOL.KEEP('||tab_row.owner||'.'||tab_row.object_name||')';
cursor_name :=
dbms_sql.open_cursor;sql_sentence :='SYS.DBMS_SHARED_POOL.KEEP('''||tab_row.owner||'.'||tab_row.object_name||''')';
dbms_output.put_line(sql_sentence);dbms_sql.parse(cursor_name,sql_sentence,
dbms_sql.native);rows_processed :=
dbms_sql.execute(cursor_name);dbms_sql.close_cursor(cursor_name);END
LOOP;END;
But , It does not execute , Is it
impossible to execute DBMS_SHARED_POOL.KEEP dynamically ...I tried DBMS_JOB ,
It did not work too.
How can I do this?
Bunyamin K.
Karadeniz
Oracle DBA / DeveloperCivilian IT DepartmentHavelsan A.S.
Eskisehir yolu 7.km Ankara TurkeyPhone: +90 312 2873565 /
1217Mobile : +90 535 3357729
The degree of normality in a database is
inversely proportional to that of its
DBA.
**
This message (including any attachments) is confidential and may be
legally privileged. If you are not the intended recipient, you should
not disclose, copy or use any part of it - please delete all copies
immediately and notify the Hays Group Email Helpdesk at
[EMAIL PROTECTED]
Any information, statements or opinions contained in this message
(including any attachments) are given by the author. They are not
given on behalf of Hays unless subsequently confirmed by an individual
other than the author who is duly authorised to represent Hays.
A member of the Hays plc group of companies.
Hays plc is registered in England and Wales number 2150950.
Registered Office Hays House Millmead Guildford Surrey GU2 4HJ.
**
RE: World's largest database...
'fraid not, though Oracle would love it to be their RDBMS it's Objectivity/DB. Mike -Original Message- Sent: 18 April 2002 15:03 To: Multiple recipients of list ORACLE-L http://www.computerworld.com/storyba/0,4125,NAV47_STO70250,00.html I thought we had someone on this list from this group, and was just wondering if this particular database was in Oracle or not. Jim -- _ Jim Hawkins Oracle Database Administrator [EMAIL PROTECTED] St. Louis, MO USA __ Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). This email and any attached to it are confidential and intended only for the individual or entity to which it is addressed. If you are not the intended recipient, please let us know by telephoning or emailing the sender. You should also delete the email and any attachment from your systems and should not copy the email or any attachment or disclose their content to any other person or entity. The views expressed here are not necessarily those of Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you. Churchill Insurance Group plc. Company Registration Number - 2280426. England. Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1 1DP. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hately Mike INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Ang: Re:Import excelfile into Oracle table
I have found that using tilde (~) delimited flat files a safe way to go with SQL*Loader. You won't find any data using tildes. Ken Janusz, CPIM - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, April 18, 2002 9:28 AM Or sql*loader. csv isn't the best choice of file format in my opinion (will any of your fields have commas in them?) but sql*loader will pick up the file and slam it in faster than you can blink an eye. Lisa Koivu Oracle Database Monkey Mama Fairfield Resorts, Inc. 954-935-4117 -Original Message- From: Charlie Mengler [SMTP:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 10:03 AM To: Multiple recipients of list ORACLE-L Subject: Re: Ang: Re:Import excelfile into Oracle table RTFM where the Fine Manual = PL/SQL for Dummies or Teach Yourself PL/SQL in 21 Days [EMAIL PROTECTED] wrote: Ok, thanks can you give me a good example on how to write the pl/sql code? Thanks in advance. Roland [EMAIL PROTECTED]@fatcity.com den 2002-04-18 01:10 PST Sänd svar till [EMAIL PROTECTED] Sänt av: [EMAIL PROTECTED] Till: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Kopia: Hi, You'd better do the following: * Convert the excel file to .csv file. * Use utl_file package to read the data and insert to Oracle Tables. M.Emre HANCIOGLU Masterfoods GmbH -- 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: Charlie Mengler INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: KENNETH JANUSZ INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
forced code path?
One of Mr Jonathan Lewis' posts refers to 'forced code paths'. What is a 'forced code path'? regards madhu There are a number of possible anomalies in the information that you have sent to Oracle, and your init.ora has a number of strange settings which may be affecting things (possibly because of bugs, possibly because of resource demands and forced code paths). However, based on your initial description, I think Oracle is chewing up CPU trying to optimize your query, and I would take steps to check whether this is actually the case (e.g. keep reducing the size of the IN list). _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Madhusudhanan Sampath INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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:Import excelfile into Oracle table
I heard , ( I think in the same list ) ... FILE PATH can be a path to
your NT local machine too... ( even can have multiple UTL_FILE_DIR locations on
NT machine )
So we should be able to read a file on NT machine to load the data to the
Oracle using UTL_FILE package.
--Madhu
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]Sent: Thursday, April 18, 2002
5:13 AMTo: Multiple recipients of list ORACLE-LSubject:
Re:Re:Import excelfile into Oracle tableHere is an example. As far as I know, utl_file package
reads data from unix box. So the file path below should be on Unix and be
careful about your rights writing or reading from this path.
DECLARE outfile_handle UTL_FILE.FILE_TYPE; v_test VARCHAR2(1000) ; BEGIN outfile_handle := UTL_FILE.FOPEN('FILE PATH','file_name','A');
v_test := 'This is a Test ' ;
-- To write a line into the
file UTL_FILE.PUT_LINE(outfile_handle, v_test) ; -- To close the file UTL_FILE.FCLOSE (outfile_handle) ; EXCEPTION WHEN
UTL_FILE.INVALID_FILEHANDLE THEN DBMS_OUTPUT.PUT_LINE('Invalid File Handle'); UTL_FILE.FCLOSE_ALL; WHEN UTL_FILE.INVALID_MODE THEN UTL_FILE.FCLOSE_ALL; DBMS_OUTPUT.PUT_LINE('Invalid Mode'); WHEN UTL_FILE.INTERNAL_ERROR THEN UTL_FILE.FCLOSE_ALL; DBMS_OUTPUT.PUT_LINE('Internal Error'); WHEN UTL_FILE.INVALID_OPERATION THEN UTL_FILE.FCLOSE_ALL; DBMS_OUTPUT.PUT_LINE('Invalid Operation'); WHEN UTL_FILE.INVALID_PATH THEN UTL_FILE.FCLOSE_ALL; DBMS_OUTPUT.PUT_LINE('Invalid Path'); WHEN UTL_FILE.READ_ERROR THEN UTL_FILE.FCLOSE_ALL; DBMS_OUTPUT.PUT_LINE('Read Error'); WHEN UTL_FILE.WRITE_ERROR THEN UTL_FILE.FCLOSE_ALL; DBMS_OUTPUT.PUT_LINE('Write Error'); WHEN NO_DATA_FOUND THEN
UTL_FILE.FCLOSE_ALL; DBMS_OUTPUT.PUT_LINE('No Data Found'); WHEN VALUE_ERROR THEN UTL_FILE.FCLOSE_ALL; DBMS_OUTPUT.PUT_LINE('Value Error' || step || ' ' ||
SUBSTR(V_BUFF,25,7) || step); WHEN
OTHERS THEN UTL_FILE.FCLOSE_ALL; DBMS_OUTPUT.PUT_LINE('Error!' || substr(sqlerrm,1,75) || step);
utl_file.fclose_all; END ; M.Emre HANCIOGLUMasterfoods Services GmbHISI
Application SupportTel : +49 2162 500-576Fax: +49 2162
41497E-Mail: [EMAIL PROTECTED]
[EMAIL PROTECTED] ica.se Sent by:
[EMAIL PROTECTED]
18.04.02 11:38 Please respond to ORACLE-L
To:
Multiple recipients of list
ORACLE-L [EMAIL PROTECTED]
cc:
Subject:
Ang: Re:Import excelfile into
Oracle table Ok, thanks
can you give me a good example on how to write the pl/sql
code?Thanks in
advance.Roland[EMAIL PROTECTED]@fatcity.com den 2002-04-18 01:10
PSTSänd svar till
[EMAIL PROTECTED]Sänt av:
[EMAIL PROTECTED]Till: Multiple
recipients of list ORACLE-L
[EMAIL PROTECTED]Kopia:Hi,You'd better do the following:* Convert the excel file
to .csv file.* Use utl_file package to read the data and insert to Oracle
Tables.M.Emre
HANCIOGLUMasterfoods
GmbH--Please see the official ORACLE-L FAQ:
http://www.orafaq.com--Author:INET:
[EMAIL PROTECTED]Fat City Network
Services -- (858) 538-5051 FAX: (858) 538-5051San
Diego, California-- Public Internet access /
Mailing
ListsTo
REMOVE yourself from this mailing list, send an E-Mail messageto:
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing
list you want to be removed from). You mayalso send the HELP command
for other information (like subscribing).
Re: SQLLDR core dumping
I had the same problem. We're on Solaris 8, Oracle 8.1.7.2, 9iAS. I worked with Oracle support for a long time on this issue and they could never solve the problem. It has something to do with the environment variables. I ended up creating a user with only the most necessary environment variables (for Oracle 8i only, none of the ones for 9iAS) and sqlldr works OK. If you ever find a solution for this problem I'll appreciate it if you tell me what you did. Thanks Ana E. Choto Systems Programmer American University e-Operations - Information Technology Phone (202) 885-2275 Fax (202) 885-2224 Ben Poels [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ueensu.ca cc: Sent by: Subject: SQLLDR core dumping [EMAIL PROTECTED] om 04/18/2002 10:23 AM Please respond to ORACLE-L Hi I installed 9iAS 1.0.2.2.2 on Solaris 8. All went well except the Portal component failed. When I tried to re-run the opca (portal configuration assistant) it failed on a segmentation fault in SQLLDR. Oracle support seems to be stumped by this. Has anyone else run into this? Thanks, Ben Poels Queen's University -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ben Poels INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Ana Choto INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: PK field - number of char
Tom, If you are generating keys as you should be, they will be numeric. Jared On Wednesday 17 April 2002 11:52, Mercadante, Thomas F wrote: All, Does anyone have any specific metrics demonstrating that a PK that is based on a number field is faster than a PK based on a character field? I've seen it mentioned a couple of times today under the Design Question topic. It doesn't make any sense to me that one or the other would be faster. After all, we are talking about comparison searches within the B-Tree index structure. Why searching down the tree for a number is any faster than a char is lost on me. Just curious if anyone has a reference someplace pointing this out. Thanks Tom Mercadante Oracle Certified (Stupified today) Professional -Original Message- Sent: Wednesday, April 17, 2002 2:21 PM To: Multiple recipients of list ORACLE-L If you go with the first option, you will likely be able to get out of joining your STATE table to the referencing tables in a bunch of cases (since the 2-letter abbreviation is interpretable on its own). But if you'll wind up having to do the join anyway (e.g., to display the STATE_DESC) then those joins will likely be faster on a numeric... HTH, -Roy Roy Pardee Programmer/Analyst SWFPAC Lockheed Martin IT Extension 8487 -Original Message- Sent: Wednesday, April 17, 2002 10:19 AM To: Multiple recipients of list ORACLE-L To simplify my question, if I am creating a STATE table to hold all the states of the US, should I create it like this... Name Null?Type - STATE_CODENOT NULL CHAR(2) -- PK STATE_DESCNOT NULL VARCHAR2(50) or like this... Name Null?Type - STATE_ID NOT NULL NUMBER -- PK STATE_CODENOT NULL CHAR(2) STATE_DESCNOT NULL VARCHAR2(50) I'm trying to figure out which is more efficient, STATE_CODE or STATE_ID, when doing a PK lookup, dealing with FKs, etc. Many TIA!!! Chris -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Accessing Synonym
Hi, Try : SQL connect inventory/invent@test_server SQL grant select on company to public; Regards, Mike Hately -Original Message- Sent: 18 April 2002 15:29 To: Multiple recipients of list ORACLE-L Does the table inventory.company exist? Abdul Aleem dmitTo: Multiple recipients of list ORACLE-L @beaconhouse.[EMAIL PROTECTED] edu.pk cc: Sent by: rootSubject: Accessing Synonym 04/18/2002 02:18 AM Please respond to ORACLE-L Hi, I tried to create a public synonym for a table in schema inventory, but it does not seem to be working, i.e., when I connect as another user, and try to select from the synonym it says table or view does not exist. I would appreciate any help. Aleem Following are the commands from SQL*Plus: SQL connect inventory/invent@test_server mailto:inventory/invent@test_server Connected. SQL create public synonym company for company; Synonym created. SQL connect scott/tiger@test_server mailto:scott/tiger@test_server Connected. SQL select * from company; select * from company * ERROR at line 1: ORA-00942: table or view does not exist SQL select * from inventory.company; select * from inventory.company * ERROR at line 1: ORA-00942: table or view does not exist This email and any attached to it are confidential and intended only for the individual or entity to which it is addressed. If you are not the intended recipient, please let us know by telephoning or emailing the sender. You should also delete the email and any attachment from your systems and should not copy the email or any attachment or disclose their content to any other person or entity. The views expressed here are not necessarily those of Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you. Churchill Insurance Group plc. Company Registration Number - 2280426. England. Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1 1DP. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hately Mike INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: HIGH CPU WITH MULTIPLE CONCURRENT USERS (long)
Here we go again. The numbers make sense and I do not think there is anything wrong. Here is the thoery: When you run five jobs on four CPUs it takes five seconds. The query requires certain amount of CPU units times Seconds. Assume each query requires (x) CPU units Seconds. Running five jobs concurrently (time slices on CPUs) requires 5 * (x) CPU seconds. This amount of work is split on four CPUs. Means one CPU will handle 5/4 * (x) CPU seconds. Since 5/4 * (x) = 5 then x = 4 CPU seconds (the amount of CPU time needed for one query). Running 100 concurrent jobs means the need to process 100 * x = 400 cpu units seconds. Again (sharing the cpu's time slice) each cpu has to handle 400/4 = 100 cpu seconds. This means each job will stay in the system for 100 seconds. If you want to get the exact picture then run one job and get the CPU usage using tkprof. This will be (x). regards, Waleed -Original Message- To: Multiple recipients of list ORACLE-L Sent: 4/17/02 11:48 PM Never mind. I just saw that oracle was able to reproduce it internally. - Original Message - To: Multiple recipients of list ORACLE-L mailto:[EMAIL PROTECTED] Sent: Tuesday, April 16, 2002 11:58 PM A co-worker is having a fairly serious issue with performance tuning of a system. The system is in the stress testing phase prior to rolling out into production. I have not included all the information as so far they have exceeded three TARs and are working on the fourth one right now. Oracle has become fairly heavily involved and is sending in the Advanced services team is now involved. He has identified that the main issue is a wait after the parsing of the SQL and during the fetch portion of the execution. The short version is running the same SQL statement ( basically nothing more than a simple query against a single table) the machine starts bogging down with a simulated 20+ users sessions and the system starts to choke at 100+ user sessions. We are talking a fairly decent midrange system. The query is a select with 5 columns extracted and a where clause that uses the in clause to select the same rows for each query. The question is has anyone seen this type of behavior before? If you have seen this before what was the root cause? Did you find a solution? Oracle acknowledges that the scenario is reproducible within their test environment, but the core team is stating that it is working as designed. Oracle is working with us, but why not check with other sources. _ A summary of where we are at: (4th TAR) 1. We tried to simulate the same performance degradation on an entirely different environment. We have been able to do the same. 2. We had requested Oracle to simulate the test case in their environment. They have been able simulate the performance degradation. Their analysis is also provided in this attachment. 3. To summarize, they have simulated where 1 user query runs in 2 seconds and 10-user query takes 7 seconds on a 4-processor server. 4. The development team of Oracle has answered to this degradation as normal and as designed. However, the degradation is very high and is in contrast with their alleged benchmark results (67000 transactions per minute on a 8 processor hardware). For us the degradation is so high that we are not able to run 150 transactions per minute on a 4-processor server. The simulation within oracle also supports this degradation _ 15-APR-02 22:09:08 GMT Pasting information into the tar on bug:2321553 Abstract: HIGH CPU WITH MULTIPLE CONCURRENT USERS since currently unavailable on MetaLink: PROBLEM: Customer has a production database that was installed on a Sun Solaris 2.8. The Solaris was a fresh install. The database was a fresh install. Customer is having the following problems: . 1. Performance problems with multiple users - more users more performance problems 2. The query runs fine, explain plan runs fine, query just takes moer time with more users - same query 3. Customer tested multi-user connection from the box via sqlplus ( no network ) - same issue 4. Customer removed the application from the env and ran multi-user test - same problem. 5. Customer loaded data in another 8.1.7 database on Win 2000 - same performance problem with more users. . . DIAGNOSTIC ANALYSIS: Analysis by NSAWYER.US --- I have looked over the RDA and have found nothing that would cause the CPU to run high. - the more I review the issue the more it seems to be less a tuning issue and more a memory leak problem. But cannot find any report of it in the trace. . Looking for any bugs that could be related to this type of behavior. - I have found none. . Analysis Reviewed the statpack and noticed that a query parses and retrieves for a split second, but the data is not return for 10 to 20 seconds. What is going during that extra time. This might be
Re: World's largest database...
Why no ask Ian MacGregor he's the DBA at the SLA. RBG - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, April 18, 2002 10:03 AM http://www.computerworld.com/storyba/0,4125,NAV47_STO70250,00.html I thought we had someone on this list from this group, and was just wondering if this particular database was in Oracle or not. Jim -- _ Jim Hawkins Oracle Database Administrator [EMAIL PROTECTED] St. Louis, MO USA __ Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: PK field - number of char
Tom, If you're keeping up on the other threads, you will see that we are in fact in complete agreement. As for the char vs. number , which is faster in an index debate that arises from time to time, I personally think it's a silly waste of time. No disrespect intended, maybe it's the first time you've seriously considered it. Folks that worry about the the nanoseconds they may be wasting by using the 'wrong' one are being penny wise and pound foolish. Much greater gains are to be made elsewhere in every application. Just my shillings worth, Jared On Thursday 18 April 2002 07:37, Mercadante, Thomas F wrote: Jared, I disagree. In some cases, I would support and use natural values for Primary keys. In the case of State Codes, County Codes, Yes/No codes and other that are too obvious, I really do not see the value of using an sequence number for the PK. I have a YES/NO table in my database. The Web developers use a drop-down field to allow the users to select the value they want (YES or NO). If the developers were required to to support the sequence number, it makes the coding a tiny bit more complicated (obviously, you and I can think of dozens of ways to make it insignificant). I guess I'm thinking that this is one of those personal preference things. My original question was looking for a good reason why I should NOT use chars in an index (thus forcing me to always use a sequence as the PK). So far, I see no reason not to . See ya. Tom Mercadante Oracle Certified Professional -Original Message- From: Jared Still [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 10:27 AM To: [EMAIL PROTECTED]; Mercadante, Thomas F Subject: Re: PK field - number of char Tom, If you are generating keys as you should be, they will be numeric. Jared On Wednesday 17 April 2002 11:52, Mercadante, Thomas F wrote: All, Does anyone have any specific metrics demonstrating that a PK that is based on a number field is faster than a PK based on a character field? I've seen it mentioned a couple of times today under the Design Question topic. It doesn't make any sense to me that one or the other would be faster. After all, we are talking about comparison searches within the B-Tree index structure. Why searching down the tree for a number is any faster than a char is lost on me. Just curious if anyone has a reference someplace pointing this out. Thanks Tom Mercadante Oracle Certified (Stupified today) Professional -Original Message- Sent: Wednesday, April 17, 2002 2:21 PM To: Multiple recipients of list ORACLE-L If you go with the first option, you will likely be able to get out of joining your STATE table to the referencing tables in a bunch of cases (since the 2-letter abbreviation is interpretable on its own). But if you'll wind up having to do the join anyway (e.g., to display the STATE_DESC) then those joins will likely be faster on a numeric... HTH, -Roy Roy Pardee Programmer/Analyst SWFPAC Lockheed Martin IT Extension 8487 -Original Message- Sent: Wednesday, April 17, 2002 10:19 AM To: Multiple recipients of list ORACLE-L To simplify my question, if I am creating a STATE table to hold all the states of the US, should I create it like this... Name Null?Type - STATE_CODENOT NULL CHAR(2) -- PK STATE_DESCNOT NULL VARCHAR2(50) or like this... Name Null?Type - STATE_ID NOT NULL NUMBER -- PK STATE_CODENOT NULL CHAR(2) STATE_DESCNOT NULL VARCHAR2(50) I'm trying to figure out which is more efficient, STATE_CODE or STATE_ID, when doing a PK lookup, dealing with FKs, etc. Many TIA!!! Chris -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Upgrade 8.0.5 to 8.1.7.3
Whilst not recommending export/import as the method, I've sometimes created a migration planned that inferred unload-then-reload and then post migration used the extra time for moving objects around for io balancing, converting to lmt's, rebuilding indexes et al. Sometimes downtime is hard to come by, and lying through your teeth that the upgrade will take 10 hours is sometimes a good way to get it :-) Cheers Connor --- Jeremiah Wilton [EMAIL PROTECTED] wrote: On Wed, 17 Apr 2002, Browett, Darren wrote: The previous DBA, also used the export/import method, and is the method I am most likely going to use. Can someone explain why anyone would opt for export/import as a path to do an 8.0 to 8.1 upgrade? Doesn't the basic upgrade just consist of starting the instance on the new ORACLE_HOME and running an upgrade script? Why would someone undergo the disruption and complexity of a full export/import when you can just leave the data where it is? -- Jeremiah Wilton http://www.speakeasy.net/~jwilton Create the new ORACLE_HOME (8.1.7) Patch to rev desired (8.1.7.2 or 8.1.7.3) Export from 8.0.5 Import to 8.1.7.x Upgrade application. Test like crazy. -Original Message- Sent: April 17, 2002 7:43 AM To: Multiple recipients of list ORACLE-L we are in the process of upgrading to 8.1.7.3 some of our databases (now 8.0.5) According to the Doc's thsi has to be done in two steps Upgrade to 8.1.7.0.0 followed by and upgrade to 8.1.7.3.0. This means that we have to upgrade all our databases in one go, or install another base 8.1.7 install to do some databases later. On our test system however we have upgraded directly form 8.0.5 and all seems to be fine. Anybody care to comment/share their opinions/experiences -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = 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!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- 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: initjvm and rmjvm failing
Note 159801.1 (Full JVM Removal on 8.1.7) on Metalink may help. Haven't tried it myself but I fear I'm about to. Jim -Original Message- Sent: Wednesday, April 17, 2002 12:08 AM To: Multiple recipients of list ORACLE-L Hi All I am trying to add Java support to one of the databases and it keeps failing. It seems that after the first run it didn't get it right and rmjvm doesn't seem to run properly after. there still appears to be a large bunch of objects in the database. Any ideas as to how to clean it up I can rebuild it if i need to, this is more of a learning task, I normally create them with Java in the first place. Any ideas 8.1.7 on Solaris 8 Thanks -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = -- This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Conboy, Jim INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle 9i Application Server
go to technet.oracle.com and look for documentation, its time for you to start reading :) joe Gagandeep Singh wrote: Greetings Gurus Im new to Oracle. Could you please tell me what is the difference between Oracle 9i and Oracle Application Server ? Regards, Gagandeep Singh -- Joseph S Testa Data Management Consulting http://www.dmc-it.com 614-791-9000 -- 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: DBMS_SHARED_POOL.KEEP
You
are calling a PL/SQL package from PL/SQL. Just get rid of all the execute
immediate
exec
stuff and call the package directly :
sys.dbms_shared_pool.keep();
-Original Message-From: Bunyamin K. Karadeniz
[mailto:[EMAIL PROTECTED]]Sent: Thursday, April 18, 2002
4:28 AMTo: Multiple recipients of list ORACLE-LSubject:
DBMS_SHARED_POOL.KEEP
I want to pin most run packages , I have loeded
them into a table. For this I have written ,
create or replace procedure pin_packages_defined
assql_sentence varchar2(200);cursor_name
INTEGER;rows_processed INTEGER;CURSOR tab_cur
IS SELECT owner,object_name FROM
arsiv.pin_aday_objeler;tab_row
tab_cur%ROWTYPE;BEGINFOR tab_row IN
tab_cur LOOP--EXECUTE
IMMEDIATE 'EXEC
SYS.DBMS_SHARED_POOL.KEEP('||tab_row.owner||'.'||tab_row.object_name||')';
cursor_name :=
dbms_sql.open_cursor;sql_sentence :='SYS.DBMS_SHARED_POOL.KEEP('''||tab_row.owner||'.'||tab_row.object_name||''')';
dbms_output.put_line(sql_sentence);dbms_sql.parse(cursor_name,sql_sentence,
dbms_sql.native);rows_processed :=
dbms_sql.execute(cursor_name);dbms_sql.close_cursor(cursor_name);END
LOOP;END;
But , It does not execute , Is it
impossible to execute DBMS_SHARED_POOL.KEEP dynamically ...I tried DBMS_JOB ,
It did not work too.
How can I do this?
Bunyamin K.
Karadeniz
Oracle DBA / DeveloperCivilian IT DepartmentHavelsan A.S.
Eskisehir yolu 7.km Ankara TurkeyPhone: +90 312 2873565 /
1217Mobile : +90 535 3357729
The degree of normality in a database is
inversely proportional to that of its
DBA.
RE: RE: World's largest database...
I can believe that - I think they are the group that offers all the geneaology services to track family histories. I'll bet that's one heck of database too! Jim Boivin, Patrice J [EMAIL PROTECTED] wrote: At the Oracle Technology Day here they mentioned that one of the largest databases belongs to the Church Of Latter Day Saints, if you can believe it. They mentioned it in a seminar which also talked about iFS, I don't know they were implying that it relies on iFS. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Thursday, April 18, 2002 11:03 AM To: Multiple recipients of list ORACLE-L Subject: World's largest database... http://www.computerworld.com/storyba/0,4125,NAV47_STO70250,00.html I thought we had someone on this list from this group, and was just wondering if this particular database was in Oracle or not. Jim -- _ Jim Hawkins Oracle Database Administrator [EMAIL PROTECTED] St. Louis, MO USA -- 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). -- _ Jim Hawkins Oracle Database Administrator [EMAIL PROTECTED] St. Louis, MO USA __ Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: MySQL vs. Oracle database
load+query (a.k.a., warehouse) operations it can be faster than Oracle because it doesn't get tangled up with rollbacks, etc. Hmmm... We did some load testing here (with Perl::DBI) and MySQL was very fast with just a few concurrent users but as soon as we cranked up the number of concurrent users MySQL bogged down but Oracle kept going. For read consistency I think MySQL is actually putting locks on tables during a query and when you have some intense queries with a lot of concurrent users they have to wait in line like 1000 rowdy kindergardeners. Steve Orr -Original Message- Sent: Wednesday, April 17, 2002 1:32 PM To: Multiple recipients of list ORACLE-L -- Weaver, Walt [EMAIL PROTECTED] I don't think you're wrong. MySQL gets dissed frequently on this list, but it's really a nice little product. IMHO it's much closer to Oracle than Access. It works well for us. Doesn't scale like Oracle, but works well. In some ways it scales better than Oracle. For load+query (a.k.a., warehouse) operations it can be faster than Oracle because it doesn't get tangled up with rollbacks, etc. On systms with many instances it also can be much simpler to administer. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 -- 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).
Re: World's largest database...
If it's the same one that Ian MacGregor spoke of some time ago, it's a distributed database in Objectivity, not Oracle. Jared On Thursday 18 April 2002 07:03, Jim Hawkins wrote: http://www.computerworld.com/storyba/0,4125,NAV47_STO70250,00.html I thought we had someone on this list from this group, and was just wondering if this particular database was in Oracle or not. Jim -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Symbolic links for datafiles...
Generally running 'df' against a file will tell you its filesystem $ ls -l x lrwxrwxrwx 1 oracle dba 25 Apr 18 15:56 x - /export/home/oracle/admin $ df x /export/home (/dev/dsk/c0t1d0s0 ): 4491432 blocks 918387 files Maybe just dump out v$datafile and df each one hth connor --- Jim Hawkins [EMAIL PROTECTED] wrote: Anybody know the answer to this question? This is on HP-UX. I am managing a database that has symbolic links for data files. On this instance, I am using STATSPACK to track performance. I need to tie IO rates back to real mount points so that I can work on balancing IO. How do I tie the names in DBA_DATA_FILES to actual mount points? I need this very quickly. Thanks in advance, Jim -- _ Jim Hawkins Oracle Database Administrator [EMAIL PROTECTED] St. Louis, MO USA __ Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = 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!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- 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: PK field - number of char
Jared, I disagree. In some cases, I would support and use natural values for Primary keys. In the case of State Codes, County Codes, Yes/No codes and other that are too obvious, I really do not see the value of using an sequence number for the PK. I have a YES/NO table in my database. The Web developers use a drop-down field to allow the users to select the value they want (YES or NO). If the developers were required to to support the sequence number, it makes the coding a tiny bit more complicated (obviously, you and I can think of dozens of ways to make it insignificant). I guess I'm thinking that this is one of those personal preference things. My original question was looking for a good reason why I should NOT use chars in an index (thus forcing me to always use a sequence as the PK). So far, I see no reason not to . See ya. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, April 18, 2002 10:27 AM To: [EMAIL PROTECTED]; Mercadante, Thomas F Tom, If you are generating keys as you should be, they will be numeric. Jared On Wednesday 17 April 2002 11:52, Mercadante, Thomas F wrote: All, Does anyone have any specific metrics demonstrating that a PK that is based on a number field is faster than a PK based on a character field? I've seen it mentioned a couple of times today under the Design Question topic. It doesn't make any sense to me that one or the other would be faster. After all, we are talking about comparison searches within the B-Tree index structure. Why searching down the tree for a number is any faster than a char is lost on me. Just curious if anyone has a reference someplace pointing this out. Thanks Tom Mercadante Oracle Certified (Stupified today) Professional -Original Message- Sent: Wednesday, April 17, 2002 2:21 PM To: Multiple recipients of list ORACLE-L If you go with the first option, you will likely be able to get out of joining your STATE table to the referencing tables in a bunch of cases (since the 2-letter abbreviation is interpretable on its own). But if you'll wind up having to do the join anyway (e.g., to display the STATE_DESC) then those joins will likely be faster on a numeric... HTH, -Roy Roy Pardee Programmer/Analyst SWFPAC Lockheed Martin IT Extension 8487 -Original Message- Sent: Wednesday, April 17, 2002 10:19 AM To: Multiple recipients of list ORACLE-L To simplify my question, if I am creating a STATE table to hold all the states of the US, should I create it like this... Name Null?Type - STATE_CODENOT NULL CHAR(2) -- PK STATE_DESCNOT NULL VARCHAR2(50) or like this... Name Null?Type - STATE_ID NOT NULL NUMBER -- PK STATE_CODENOT NULL CHAR(2) STATE_DESCNOT NULL VARCHAR2(50) I'm trying to figure out which is more efficient, STATE_CODE or STATE_ID, when doing a PK lookup, dealing with FKs, etc. Many TIA!!! Chris -- 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).
RE: MySQL vs. Oracle database
Hi Walt, et al. It's quite possible to use MySQL as a backend database for web hosting and get good performance and decent reliability. I haven't heard of Access being used for that sort of thing. Actually Access is used quite widely as a backend database for web servers. The usual set-up for an NT web server is to have IIS (web server agent), that accesses either a SQLServer or Access database via asp pages. We use an Access database at the backend of our cool-tools.co.uk site. Just wondering why do you think MySQL is closer to Access than to Oracle. I have played with MySQL a little and it is a relational database like Oracle (not sure if access is one), uses a SQL, can have logging and archiving just like Oracle. Again I'm not sure whether access have all this. Actually, whoever it was that said this (I forget) is right, MySQL is more like Access (or maybe the older versions of SQLServer (read 7)), than it is to Oracle. Access is a relational database just like the rest, it's just that it's more of a desktop or workgroup level database than an enterprise level database. It handles table relationships etc. just the same however, and is also SQL based via the back end. I just wrote an entire application for an introductions agency (dating agency ;P) that runs entirely on an access database as a side job for a friend of my fathers.. It's SQLServer/Oracle's little brother by all accounts, only it includes things such as forms designing etc. as part of the package.. Damn I'm starting to sound like a Micro$lop sales man now!! But I have to say, for what I needed to do - it was great! HTH Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -Original Message- Walt Sent: 17 April 2002 18:45 To: Multiple recipients of list ORACLE-L Well, MySQL and Oracle are very different, but there's a world of difference between MySQL and Access too. It's quite possible to use MySQL as a backend database for web hosting and get good performance and decent reliability. I haven't heard of Access being used for that sort of thing. --Walt Weaver Bozeman, Montana -Original Message- Sent: Wednesday, April 17, 2002 11:03 AM To: Multiple recipients of list ORACLE-L Check google. Anyway they are completely different. MySQL is more like Access than Oracle. On Wed, 17 Apr 2002, Nguyen, David M wrote: What is different between MySQL and Oracle database? Someone says they are the same as they are just database. From DBA or developer point of view, what do you say? Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Weaver, Walt INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public
Re: Oracle 9i Application Server
This Oracle web site will give you all the documentation you need for 9i. You can download it in .pdf format to your PC for quick reference. http://download-west.oracle.com/otndoc/oracle9i/901_doc/nav/docindex.htm Ken Janusz, CPIM - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, April 18, 2002 10:18 AM go to technet.oracle.com and look for documentation, its time for you to start reading :) joe Gagandeep Singh wrote: Greetings Gurus Im new to Oracle. Could you please tell me what is the difference between Oracle 9i and Oracle Application Server ? Regards, Gagandeep Singh -- Joseph S Testa Data Management Consulting http://www.dmc-it.com 614-791-9000 -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: KENNETH JANUSZ INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: World's largest database...
http://www.slac.stanford.edu/BFROOT/www/Computing/Offline/Databases/Conditio ns/Evaluations/Report.pdf -Original Message- Sent: 18 April 2002 15:23 To: Multiple recipients of list ORACLE-L 'fraid not, though Oracle would love it to be their RDBMS it's Objectivity/DB. Mike -Original Message- Sent: 18 April 2002 15:03 To: Multiple recipients of list ORACLE-L http://www.computerworld.com/storyba/0,4125,NAV47_STO70250,00.html I thought we had someone on this list from this group, and was just wondering if this particular database was in Oracle or not. Jim -- _ Jim Hawkins Oracle Database Administrator [EMAIL PROTECTED] St. Louis, MO USA __ Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). This email and any attached to it are confidential and intended only for the individual or entity to which it is addressed. If you are not the intended recipient, please let us know by telephoning or emailing the sender. You should also delete the email and any attachment from your systems and should not copy the email or any attachment or disclose their content to any other person or entity. The views expressed here are not necessarily those of Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you. Churchill Insurance Group plc. Company Registration Number - 2280426. England. Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1 1DP. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hately Mike INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Reorganize table
Hi Friends, I need to reorganize my big fat table sized 23Gb, I don't have much space for export on my filesystem( I keep one or two filesystems ready for my expansion each size 4Gb) in the same table I have more than 5Gb free fragmented space, But I can't use it!! So what is best way to reorganize this monster table?? Thanks in advance Raghu. _ Join the worlds largest e-mail service with MSN Hotmail. 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).
See what happened in Naples in Palestine
Attention des images très gore. Âmes sensible s'abstenir. Est ce qu'il y a des êtres humains qui peuvent arrêter ces barbares ? !! Img2.jpg The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail. This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact [EMAIL PROTECTED] for clarification. Img3.jpg The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail. This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact [EMAIL PROTECTED] for clarification. Img4.jpg The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail. This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact [EMAIL PROTECTED] for clarification. Img5.jpg The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail. This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact [EMAIL PROTECTED] for clarification. Img6.jpg The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail. This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact [EMAIL PROTECTED] for clarification. Img1.jpg
RE: System datafile corruption.
Mike: Have you upgraded versions lately? We had the same error pop up in our System tablespace, but the 'problem' wasn't real. It was an artifact left over from the upgrade of (I think) 7.x to 8.x. There are parts of the SYSTEM rollback segment that had never been touched, and these showed up as corrupt in dbv. Look in MetaLink, that's where we found the problem and the solution. The solution was to create a script that used the SYSTEM rollback segment for many (MANY) transactions and used up all the available extents in that rollback segment. Once it ran, dbv was happy. Good Luck! Mike -Original Message- Sent: Thursday, April 18, 2002 6:28 AM To: Multiple recipients of list ORACLE-L Guys, I have a system datafile that returns dbv errors for a SYSTEM datafile. The fault has existed for a long time undiscovered so recovery from backup is not possible. The database still does not exhibit any problems except for dbv! The errors are all 'Block Type = Undo data block', so I assume the fault is in the system rollback segment. I'm sure I can't drop/recreate the SYSTEM rbs, so does anyone have any suggestions apart from a full export and import? Dbv extract is below: Block Checking: DBA = 67108870, Block Type = Undo data block ERROR: Undo Block Corrupted. Error Code = 2008 ktu4ubck: size(108) of undo record #1 corrupted. UNDO BLK HEADER: xid: 0x.08a.0151 seq: 0x198 cnt: 0x4d irb: 0x4d icl: 0x0 flg: 0x000 0 Rec Offset | Rec Offset | Rec Offset | Rec Offset | Rec Offset --- 0x00 0x1fe8 | 0x01 0x1f80 | 0x02 0x1f2e | 0x03 0x1ee0 | 0x04 0x1e76 . . 0x4b 0x027c | 0x4c 0x0212 | 0x4d 0x01b0 Hex dump: 0x000b6b94(+): 00 0a 00 10 00 3c 00 10 00 02 00 00 2a 11 00 00 . . 0x000b6bf4(+0060): 00 9d 00 00 78 bc 01 00 grep 'Block Type' dbv_log | wc -l 127 Regards, Mike Jenner Database Administrator -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
DBMS_MAIL
Has anyone used this package to send e-mails to an Exchange server? Is it possible? 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] -- 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: MySQL vs. Oracle database
Thanks for clarification, all my knowledge about transactional tables are from MySQL docs. I'v used only not transactional safe tables for some web projects. Gints Plivna IT Sistçmas, Meríeïa 13, LV1050 Rîga http://www.itsystems.lv/gints/ Weaver, Walt wweaver@rightnowTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] .comcc: Sent by: Subject: RE: MySQL vs. Oracle database [EMAIL PROTECTED] 2002.04.18 17:38 Please respond to ORACLE-L In our testing the Berkeley table types were hopelessly slow and bloated, taking up much more space than MyISAM or InnoDB table types. We had more success with the InnoDB table type, and will be implementing them some time in the future. InnoDB supports referential integrity. The table types aren't really a special component; they're implemented via an argument when the source is compiled. --Walt Weaver Bozeman, Montana -Original Message- Sent: Thursday, April 18, 2002 3:03 AM To: Multiple recipients of list ORACLE-L By default MySQL has no transactions You have to add special component to access transactional safe tables called Berkeley db tables. You can commit and rollback on only these tables. For others every wrong (not syntactically, but for example inserting characters into number column) insert and update will succeed. If MySQL cannot insert provided values it uses default values. One of the biggest pains is (maybe was, I don't know about MySQL 4.xxx) that it has no foreign keys : I have created class diagramms for both Oracle and Mysql servers for my studies in University. It cannot be treated as feature comparison but just simple overview of these two images will show the situation i.e. compare object count on these images :-) And I have to say that Oracle diagramm isn't complete! Oracle server class diagramm http://www.itsystems.lv/gints/files/oracle/oracle_s.htm Mysql server class diagramm http://www.itsystems.lv/gints/files/mysql/mysql.htm Gints Plivna IT Sistçmas, Meríeïa 13, LV1050 Rîga http://www.itsystems.lv/gints/ Bunyamin K. Karadeniz To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] bunyamink@havelscc: an.com.tr Subject: Re: MySQL vs. Oracle database Sent by: [EMAIL PROTECTED] 2002.04.18 10:43 Please respond to ORACLE-L I have not been so much with MySQL , But want to share my experience. Firstly , it is very fast ...This makes me suspicious , I wonder if it is trusted to be integral . Seem like no control ..Does not contain rollbacks , may be this .. Then how does it rollback ? I have used a version where stored procs ,functions are unavailable .. Wonder if it has now.. Bunyamin K. Karadeniz Oracle DBA / Developer Civilian IT Department Havelsan A.S. Eskisehir yolu 7.km Ankara Turkey Phone: +90 312 2873565 / 1217 Mobile : +90 535 3357729 The degree of normality in a database is inversely proportional to that of its DBA. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, April 17, 2002 10:31 PM -- Weaver, Walt [EMAIL PROTECTED] I don't think you're wrong. MySQL gets dissed frequently on this list, but it's really
RE: db2/udb and new skillz
Dear Lisa others ! i've been in the same situation before. I also felt (and still do) that Oracle DBA alone in the resume is not enough, and i need something more than it to feel comfortable in this recessive economy. I posted almost the same question to the list and (after receiving number of replies from the dear list memebers) i figured out that my alternatives are : UNIX sysadmin , java programming , ERP (Oracle apps , SAP etc.) or another DBMS in addition to Oracle. I think that the last option (another DBMS) is the least attractive one comparing to the others , because: 1) in a big company , usualy there are different teams/sub-teams responsible for different DBMSs and therefore u belong to either Oracle team or another , but not to both. 2) a small company usualy uses only 1 DB brand. I , personally, invest my time in learning UNIX sysadmin and enjoy it a lot. I absolutely believe that if u like Oracle DBAing , you'll love UNIX sysadmin-ing , or something like this... Although , networking is my weak side too... -Original Message- Sent: Wed, April 17, 2002 8:21 PM To: Multiple recipients of list ORACLE-L My fellow Databasers, I just found out my employer has an unlimited license for DB2/UDB. I am kind of excited at the prospect of learning a new dbms that isn't SQL Server. I am also feeling the need to expand my skills. Glancing at the job market under just Oracle isn't promising right now. I also have a feeling my job will eventually be transferred to Orlando or Las Vegas. (Vegas is gorgeous, but I'm not going.) I am not the best programmer. I can program my way out of a paper bag, I can write pl/sql fairly quickly and well, but I don't see myself enjoying learning the ins and outs of Perl, Java or C++. I don't think well that way. It would also be a struggle for me to learn unix administration, I think. Networking is by far my weakest link (no pun intended) So my questions are: How many of you are responsible for Oracle and DB2/UDB? What other software (besides erp's) do you find yourself meddling in/being held responsible for? (I also may have the chance to learn Peopleslop, but that would also involve a move to Orlando. NOT) If you were to add a skill to your resume, what would it be? Thanks in advance for any replies. In order to keep the list traffic down, feel free to reply to me directly. Peace, Oracle and Happiness, Lisa Koivu Oracle Database MONKEY MAMA Fairfield Resorts, Inc. 954-935-4117 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Andrey Bronfin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: World's largest database...
500tb, guess a good reason to use Rman! Do notice its not called Rwoman :) [EMAIL PROTECTED] 04/18/02 10:53AM Why no ask Ian MacGregor he's the DBA at the SLA. RBG - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, April 18, 2002 10:03 AM http://www.computerworld.com/storyba/0,4125,NAV47_STO70250,00.html I thought we had someone on this list from this group, and was just wondering if this particular database was in Oracle or not. Jim -- _ Jim Hawkins Oracle Database Administrator [EMAIL PROTECTED] St. Louis, MO USA __ Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: 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: System datafile corruption.
Why don't you verify that the corrupted block belongs to the segment you think it does, or belongs to a segment at all? select owner||'.'||segment_name, segment_type from dba_extents where file_id = file# and 67108870 between block_id and (block_id + blocks - 1); -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Thu, 18 Apr 2002, Jenner Mike wrote: I have a system datafile that returns dbv errors for a SYSTEM datafile. The fault has existed for a long time undiscovered so recovery from backup is not possible. The database still does not exhibit any problems except for dbv! The errors are all 'Block Type = Undo data block', so I assume the fault is in the system rollback segment. I'm sure I can't drop/recreate the SYSTEM rbs, so does anyone have any suggestions apart from a full export and import? Dbv extract is below: Block Checking: DBA = 67108870, Block Type = Undo data block ERROR: Undo Block Corrupted. Error Code = 2008 ktu4ubck: size(108) of undo record #1 corrupted. UNDO BLK HEADER: xid: 0x.08a.0151 seq: 0x198 cnt: 0x4d irb: 0x4d icl: 0x0 flg: 0x000 0 Rec Offset | Rec Offset | Rec Offset | Rec Offset | Rec Offset --- 0x00 0x1fe8 | 0x01 0x1f80 | 0x02 0x1f2e | 0x03 0x1ee0 | 0x04 0x1e76 . . 0x4b 0x027c | 0x4c 0x0212 | 0x4d 0x01b0 Hex dump: 0x000b6b94(+): 00 0a 00 10 00 3c 00 10 00 02 00 00 2a 11 00 00 . . 0x000b6bf4(+0060): 00 9d 00 00 78 bc 01 00 grep 'Block Type' dbv_log | wc -l 127 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: PK field - number of char
Jared, you said: As for the char vs. number , which is faster in an index debate that arises from time to time, I personally think it's a silly waste of time. I totally agree. As I said, I saw some recent positings stating that numbers were faster than chars and asked if anyone had any metrics stating such (in case I missed something someplace). My intuition was that there was no difference. However, things change and I was just checking to keep up. thanks for replying. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, April 18, 2002 10:45 AM To: Mercadante, Thomas F; [EMAIL PROTECTED] Tom, If you're keeping up on the other threads, you will see that we are in fact in complete agreement. As for the char vs. number , which is faster in an index debate that arises from time to time, I personally think it's a silly waste of time. No disrespect intended, maybe it's the first time you've seriously considered it. Folks that worry about the the nanoseconds they may be wasting by using the 'wrong' one are being penny wise and pound foolish. Much greater gains are to be made elsewhere in every application. Just my shillings worth, Jared On Thursday 18 April 2002 07:37, Mercadante, Thomas F wrote: Jared, I disagree. In some cases, I would support and use natural values for Primary keys. In the case of State Codes, County Codes, Yes/No codes and other that are too obvious, I really do not see the value of using an sequence number for the PK. I have a YES/NO table in my database. The Web developers use a drop-down field to allow the users to select the value they want (YES or NO). If the developers were required to to support the sequence number, it makes the coding a tiny bit more complicated (obviously, you and I can think of dozens of ways to make it insignificant). I guess I'm thinking that this is one of those personal preference things. My original question was looking for a good reason why I should NOT use chars in an index (thus forcing me to always use a sequence as the PK). So far, I see no reason not to . See ya. Tom Mercadante Oracle Certified Professional -Original Message- From: Jared Still [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 10:27 AM To: [EMAIL PROTECTED]; Mercadante, Thomas F Subject: Re: PK field - number of char Tom, If you are generating keys as you should be, they will be numeric. Jared On Wednesday 17 April 2002 11:52, Mercadante, Thomas F wrote: All, Does anyone have any specific metrics demonstrating that a PK that is based on a number field is faster than a PK based on a character field? I've seen it mentioned a couple of times today under the Design Question topic. It doesn't make any sense to me that one or the other would be faster. After all, we are talking about comparison searches within the B-Tree index structure. Why searching down the tree for a number is any faster than a char is lost on me. Just curious if anyone has a reference someplace pointing this out. Thanks Tom Mercadante Oracle Certified (Stupified today) Professional -Original Message- Sent: Wednesday, April 17, 2002 2:21 PM To: Multiple recipients of list ORACLE-L If you go with the first option, you will likely be able to get out of joining your STATE table to the referencing tables in a bunch of cases (since the 2-letter abbreviation is interpretable on its own). But if you'll wind up having to do the join anyway (e.g., to display the STATE_DESC) then those joins will likely be faster on a numeric... HTH, -Roy Roy Pardee Programmer/Analyst SWFPAC Lockheed Martin IT Extension 8487 -Original Message- Sent: Wednesday, April 17, 2002 10:19 AM To: Multiple recipients of list ORACLE-L To simplify my question, if I am creating a STATE table to hold all the states of the US, should I create it like this... Name Null?Type - STATE_CODENOT NULL CHAR(2) -- PK STATE_DESCNOT NULL VARCHAR2(50) or like this... Name Null?Type - STATE_ID NOT NULL NUMBER -- PK STATE_CODENOT NULL CHAR(2) STATE_DESCNOT NULL VARCHAR2(50) I'm trying to figure out which is more efficient, STATE_CODE or STATE_ID, when doing a PK lookup, dealing with FKs, etc. Many TIA!!! Chris -- 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:
ORA-00600: internal error code, arguments: [4400], [48]
I am getting an ORA-00600: internal error code, arguments: [4400], [48] in my production data warehouse database. Running on version 8.1.7.2.1 Solaris 10.20 32 bit. We are also having trouble with Packages that load data into the database reporting a normal completion but in fact it only loads a portion of the records. A rerun of the Package runs to completion and loads all the rows. No error is reported in the alertlog during the time of the data load. Any help would be appreciated. Ron Smith DBA Kerr-McGee Corp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: forced code path?
It doesn't mean anything exciting or exotic, I was just trying to express the idea that sometimes Oracle will execute one piece of (internal) code because of an init.ora parameter, hint, visible set of table statistics etc. rather than taking another path which you might typically expect it to take. Jonathan Lewis http://www.jlcomp.demon.co.uk Author of: Practical Oracle 8i: Building Efficient Databases Next Seminar - Australia - July/August http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 18 April 2002 16:23 |One of Mr Jonathan Lewis' posts refers to 'forced code paths'. What is a |'forced code path'? | |regards |madhu | |There are a number of possible anomalies in the |information that you have sent to Oracle, and your |init.ora has a number of strange settings which may |be affecting things (possibly because of bugs, |possibly because of resource demands and forced |code paths). However, based on your initial description, |I think Oracle is chewing up CPU trying to optimize |your query, and I would take steps to check whether |this is actually the case (e.g. keep reducing the size |of the IN list). | | -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: DBMS_MAIL
I believe it only supports SMTP mail, not MAPI. I have used it to send email to an Exchange server that was running the SMTP connector, so yes it can be used as long as your Exchange server accepts smtp mail. You do not have access to the exchange distribution lists or global address book like you would with a Mapi API. -Original Message- Sent: Thursday, April 18, 2002 11:38 AM To: Multiple recipients of list ORACLE-L Has anyone used this package to send e-mails to an Exchange server? Is it possible? 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] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seefelt, Beth INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Number of CPUs vs. Speed of CPUs
We are in the process of sizing a new server for multiple Oracle instances. What factors are useful as input in determining how many CPUs and the relative speed of them? For example, do we want fewer, faster CPUs or do we want more, slower CPUs? Are there any good guidelines to determine what the number of CPUs should be? Thanks in advance - Lisa -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: YTTRI Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: World's largest database...
It could be renamed in the next release: Recovery With Out MANagement. RWOMAN! Ron ROR mô¿ôm [EMAIL PROTECTED] 04/18/02 12:28PM 500tb, guess a good reason to use Rman! Do notice its not called Rwoman :) [EMAIL PROTECTED] 04/18/02 10:53AM Why no ask Ian MacGregor he's the DBA at the SLA. RBG - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, April 18, 2002 10:03 AM http://www.computerworld.com/storyba/0,4125,NAV47_STO70250,00.html I thought we had someone on this list from this group, and was just wondering if this particular database was in Oracle or not. Jim -- _ Jim Hawkins Oracle Database Administrator [EMAIL PROTECTED] St. Louis, MO USA __ Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: 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: 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: datafile sizing ?
Hello Darren,ROR and all, How about using locally managed tablespaces and allocating uniform extent size ( say 4M ) , when we create a tablespace with multiple small datafiles ( say 500 M ) I would prefer to have a standard for the size of the datafile . --Madhu -Original Message- Sent: Thursday, April 18, 2002 7:23 AM To: Multiple recipients of list ORACLE-L Darren, It also depends on the extent sizes you use for the tables in the tablespace. Will each extent completely use the datafile or will there be wasted space in the smaller datafiles. As an example: if there is 100 M free space and the extent is 150 M it will not fit in the datafile and will use the next free space in the new datafile, wasting the 100 M free space. That can add up to a lot of space over time. Also remember to set the MAXDATAFILE to a limit allowable by the os. once you reach the limit if it is set small you have to rebuild the database to raise the limit. Different os's have different limits. Ron ROR mª¿ªm [EMAIL PROTECTED] 04/17/02 08:34PM Darren, discuss this with your SA. There may be a limit on the os side you need to be aware of. Also, consider MTTR. Seems to me that MTTR won't be that different between a 500MB file and a 2GB file. Beyond that, it's your comfort level. Personally I like having larger files for ease of administration. Lisa Koivu Oracle Database Monkey Mama Fairfield Resorts, Inc. 954-935-4117 -Original Message- From: Browett, Darren [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 5:48 PM To: Multiple recipients of list ORACLE-L Subject: datafile sizing ? I am currently building a new 8i database, and have the oppurtunity to consolidate some of my datafiles. In the current configuration I have 4 500Mb datafiles that make up a tablespace. Is it okay to create a 2Gb datafile, or am I better off to create 2 1Gb datafile's, or stay with 4 500Mb datafiles. Thanks Darren -- -- -- Darren Browett P.Eng This message was transmitted Data Administratorusing 100% recycled electrons Information and Communication Technology City of Coquitlam P:(604)927 - 3614 E:[EMAIL PROTECTED] -- -- --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Browett, Darren INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Reddy, Madhusudana INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message
Re: Ang: Re:Import excelfile into Oracle table
A simple search of Google: http://www.google.com/search?sourceid=navclientq=utl%5Ffile+example Gives the following on the first page: http://www.geocities.com/suresh_vemulapalli/utl.htm http://utplsql.sourceforge.net/Doc/admin.html http://www.classicity.com/oracle/htdocs/forums/ClsyForumID125/11.html# http://download-east.oracle.com/otndoc/oracle9i/901_doc/appdev.901/a89852/utl_file.htm Brian P. MacLean Oracle DBA, OCP8i Roland.Skoldbl [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Ang: Re:Import excelfile into Oracle table om 04/18/02 02:38 AM Please respond to ORACLE-L Ok, thanks can you give me a good example on how to write the pl/sql code? Thanks in advance. Roland [EMAIL PROTECTED]@fatcity.com den 2002-04-18 01:10 PST Sänd svar till [EMAIL PROTECTED] Sänt av: [EMAIL PROTECTED] Till: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Kopia: Hi, You'd better do the following: * Convert the excel file to .csv file. * Use utl_file package to read the data and insert to Oracle Tables. M.Emre HANCIOGLU Masterfoods GmbH -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Compare (diff) Oracle DB and MS-SQLServer DB
One of our teams started programming in SQLServer, but now we are live in a production ORACLE environment. Due to several issues, such as licensing,skills, etc., the development must stay on SQLServer. Is there a tool or whatever to find out the deltas between a SQLServerDB and an Oracle DB? Or any suggestions. Ray _ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Gordon INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: MySQL vs. Oracle database
Gints, Tried and could not access the web-site, you point to. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, April 18, 2002 5:03 AM By default MySQL has no transactions You have to add special component to access transactional safe tables called Berkeley db tables. You can commit and rollback on only these tables. For others every wrong (not syntactically, but for example inserting characters into number column) insert and update will succeed. If MySQL cannot insert provided values it uses default values. One of the biggest pains is (maybe was, I don't know about MySQL 4.xxx) that it has no foreign keys : I have created class diagramms for both Oracle and Mysql servers for my studies in University. It cannot be treated as feature comparison but just simple overview of these two images will show the situation i.e. compare object count on these images :-) And I have to say that Oracle diagramm isn't complete! Oracle server class diagramm http://www.itsystems.lv/gints/files/oracle/oracle_s.htm Mysql server class diagramm http://www.itsystems.lv/gints/files/mysql/mysql.htm Gints Plivna IT Sistçmas, Meríeïa 13, LV1050 Rîga http://www.itsystems.lv/gints/ Bunyamin K. Karadeniz To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] bunyamink@havelscc: an.com.tr Subject: Re: MySQL vs. Oracle database Sent by: [EMAIL PROTECTED] 2002.04.18 10:43 Please respond to ORACLE-L I have not been so much with MySQL , But want to share my experience. Firstly , it is very fast ...This makes me suspicious , I wonder if it is trusted to be integral . Seem like no control ..Does not contain rollbacks , may be this .. Then how does it rollback ? I have used a version where stored procs ,functions are unavailable .. Wonder if it has now.. Bunyamin K. Karadeniz Oracle DBA / Developer Civilian IT Department Havelsan A.S. Eskisehir yolu 7.km Ankara Turkey Phone: +90 312 2873565 / 1217 Mobile : +90 535 3357729 The degree of normality in a database is inversely proportional to that of its DBA. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, April 17, 2002 10:31 PM -- Weaver, Walt [EMAIL PROTECTED] I don't think you're wrong. MySQL gets dissed frequently on this list, but it's really a nice little product. IMHO it's much closer to Oracle than Access. It works well for us. Doesn't scale like Oracle, but works well. In some ways it scales better than Oracle. For load+query (a.k.a., warehouse) operations it can be faster than Oracle because it doesn't get tangled up with rollbacks, etc. On systms with many instances it also can be much simpler to administer. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bunyamin K. Karadeniz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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
Help with Locking Issue
I have been spending most of my morning trying to resolve a locking issue. I think I could me missing the forest for the trees. This is what happens: a user kicks off two identical jobs from two different PCs. Each of these jobs is doing the same thing, but against different rows of data (they are processing work orders in our system, but each job is processing a different work order). One session will wait until the other session completes. I am trying to figure out what they are waiting on. At first I assumed a locked record, but I don't think that is the case. I did quite a bit of research on MetaLink. I even rebuilt the table in case INITRANS and PCTFREE might be too small, but that didn't seem to help either. Here is the output from the query in note 1020047.6. Sess Op Sys OBJ NAME or ID USERNAME User IDTERMINAL TRANS_ID TY Lock Mode Req Mode -- - -- --- --- 12 KEN468 ken468 KEN468-1 FIXED_ASSET_ACTIV TM Row Excl 12 KEN468 ken468 KEN468-1 Trans-196694 TX Exclusive 14 KEN468 Batch BATCHFIXED_ASSET_ACTIV TM Row Excl 14 KEN468 Batch BATCHTrans-196694 TX --Waiting-- Share 14 KEN468 Batch BATCHTrans-65597 TX Exclusive So session 14 is waiting for a share lock. Session 12 has an exclusive lock that is blocking session 14. How do I find out what session 12 has locked that is needed by session 14? Thanks, Jay -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: DBMS_MAIL
Never mind, I found the answer: It's not possible. Instead, since 8.1.6., it's better to use the utl_smtp package. e.g. from MetaLInk: DECLARE conn UTL_SMTP.CONNECTION; crlf VARCHAR2( 2 ):= CHR( 13 ) || CHR( 10 ); mesg VARCHAR2( 1000 ); BEGIN conn:= utl_smtp.open_connection( 'smtp01.us.oracle.com', 25 ); utl_smtp.helo( conn, 'smtp01.us.oracle.com' ); utl_smtp.mail( conn, '[EMAIL PROTECTED]' ); utl_smtp.rcpt( conn, '[EMAIL PROTECTED]' ); utl_smtp.rcpt( conn, 'cc:[EMAIL PROTECTED]' ); mesg:= 'Date: ' || TO_CHAR( SYSDATE, 'dd Mon yy hh24:mi:ss' ) || crlf || 'From: User1 [EMAIL PROTECTED]' || crlf || 'Subject: Just testing' || crlf || 'To: User2 [EMAIL PROTECTED]' || crlf || 'Cc: User1 [EMAIL PROTECTED]' || crlf || '' || crlf || ' This is just a test, please disregard. ' || crlf || ''; utl_smtp.data( conn, mesg ); utl_smtp.quit( conn ); END; / I am getting ready to test that now, to see if it works. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Thursday, April 18, 2002 12:38 PM To: Multiple recipients of list ORACLE-L Subject:DBMS_MAIL Has anyone used this package to send e-mails to an Exchange server? Is it possible? 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] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Reorganize table
Raghu, I think that because of your limited space you are between the rock and a hard place. Make sure you have a good BACKUP. I would even try for more than one good backup as you don't know if the backup tape was good until you try a restoral. I would try creating a table that I could load a portion of the data from the monster table, export the data from the portion table and then truncate the portion table. Load the portion table with more data from the monster table and follow the process until all the data from the monster table has been exported. I would keep the exports on a different machine until the re-org is completed. After the data is exported you can truncate the monster table and import the data back into the portion table and then load the data into the monster table from the portion table. all of you data should then be back in the monster table and fragmentation removed. I understand your situation. I have 72 GIG disk with 3 GIG free and some datafiles are 3.8 GIG with tables over 6 GIG. I am waiting to migrate to a new server some time next year. Ron ROR mª¿ªm [EMAIL PROTECTED] 04/18/02 11:38AM Hi Friends, I need to reorganize my big fat table sized 23Gb, I don't have much space for export on my filesystem( I keep one or two filesystems ready for my expansion each size 4Gb) in the same table I have more than 5Gb free fragmented space, But I can't use it!! So what is best way to reorganize this monster table?? Thanks in advance Raghu. _ Join the worldÆs largest e-mail service with MSN Hotmail. 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). -- 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: MySQL vs. Oracle database
1000 rowdy kindergardeners. I can relate to that analogy... I can also laugh when I picture it in my mind. Ron ROR mª¿ªm [EMAIL PROTECTED] 04/18/02 11:13AM load+query (a.k.a., warehouse) operations it can be faster than Oracle because it doesn't get tangled up with rollbacks, etc. Hmmm... We did some load testing here (with Perl::DBI) and MySQL was very fast with just a few concurrent users but as soon as we cranked up the number of concurrent users MySQL bogged down but Oracle kept going. For read consistency I think MySQL is actually putting locks on tables during a query and when you have some intense queries with a lot of concurrent users they have to wait in line like 1000 rowdy kindergardeners. Steve Orr -- 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: MySQL vs. Oracle database
What makes you think that MySQL has read consistency? For read consistency I think MySQL is actually putting locks on tables during a query and when you have some intense queries with a lot of concurrent users they have to wait in line like 1000 rowdy kindergardeners. __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.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).
Re: RAC
It's true that the *best* platform for 9iRAC is Tru64, as it is the base port for that product. But 9iRAC (with reduced feature set) is currently available across most major Oracle ports already -- it just doesn't include many of the advanced clustering features that come as part of Tru64 and the Oracle9i RAC implementation on that port. Perhaps others on this list can verify, correct, or augment, but this is my basic understanding... * Oracle9i is still base-ported on Solaris, but 9iRAC is base-ported on Tru64... * Oracle has licensed a great deal of technology from Compaq for 9iRAC, including clustered file-systems. At the present release of Oracle (9.0.1), the full set of these 9iRAC features are available only on Tru64, but starting with 9.0.2 Oracle will be making many of them available on other major ports as well... So Compaq does have a right to claim that it is the only true 9iRAC solution today. Since many of the upcoming 9iRAC product features are native to Tru64, in cases of feature overlap it will be interesting to see if future versions of 9iRAC utilize the existing Tru64 features (as the current version of 9.0.1 does) or the newly-included Oracle features? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, April 18, 2002 6:38 AM Jonathan, At the seminars I have attended it was pointed out that the :true RAC is COMPAQ only. The seminar was hosted by Oracle/Compaq. Compaq RAC allows multiple CPU's to mount and use/share the same datafiles in a true RAC configuration. The drives including the os drive are on a SAN and shared by the CPU's so knowledge is shared. It was pointed out the new Linux RAC can only share a RAW device and not a datafile. I don't know if this is true as I have not tried it yet. The speaker at the seminar said that with other OS's a RAC is like a High Availability (HA) option, one CPU is doing nothing until the first one fails or you only run different applications and datafiles on one CPU and other applications and datafiles on the second CPU. if one fails you have to mount the datafiles and switch applications to the active CPU. To use a true RAC you have to use Compaq and I think the market share of the OS's are not True64, so there are probably not a lot of users of RAC. Ron ROR mª¿ªm [EMAIL PROTECTED] 04/17/02 10:18PM I was talking w/someone today, and we realized that neither of us knows of anyone actually using RAC in production. So now I'm curious. Is anyone? Jonathan Gennick --- Brighten the corner where you are mailto:[EMAIL PROTECTED] http://Gennick.com * http://MichiganWaterfalls.com * http://ValleySpur.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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: World's largest database...
The 0.5 petabyte database at SLAC does not use Oracle; it uses Objectivity. Objectivity is a small company which makes an OODB. When the project started there was no way that Oracle could possibly handle this. It is still doubtful: Oracle does not truly support Hierarchical Storage Systems; using one huge RAC ties limits your machine vendors; some limits such as 64,000 partitions probably need to be increased. CERN is however very interested in using Oracle for their Large Hadronic Collider, but that's about seven years off. That database will surpass BABAR's which as of 00:01:13 this morning (April 18 2002) was storing 549.6 TB has been stored in 324603 files. CERN's possible use of Oracle is not due to failures in Objectivity, but due to that company's inability to capture market share. They are hoping the problems which prevent Oracle from handling large databases can be fixed by then.I am also hoping for this, but I fear Oracle may prove to be an uncooperative prohibitedly expensive partner. Here we have plans to turn up the luminosity. If approved the database will reach one exabyte by the end of the experiment. I don't believe the genealogy databases are even close to 500 TB. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 8:29 AM To: Multiple recipients of list ORACLE-L I can believe that - I think they are the group that offers all the geneaology services to track family histories. I'll bet that's one heck of database too! Jim Boivin, Patrice J [EMAIL PROTECTED] wrote: At the Oracle Technology Day here they mentioned that one of the largest databases belongs to the Church Of Latter Day Saints, if you can believe it. They mentioned it in a seminar which also talked about iFS, I don't know they were implying that it relies on iFS. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Thursday, April 18, 2002 11:03 AM To: Multiple recipients of list ORACLE-L Subject: World's largest database... http://www.computerworld.com/storyba/0,4125,NAV47_STO70250,00.html I thought we had someone on this list from this group, and was just wondering if this particular database was in Oracle or not. Jim -- _ Jim Hawkins Oracle Database Administrator [EMAIL PROTECTED] St. Louis, MO USA -- 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). -- _ Jim Hawkins Oracle Database Administrator [EMAIL PROTECTED] St. Louis, MO USA __ Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian 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: Number of CPUs vs. Speed of CPUs
How many CPU's will the box hold? This # should be your requirement, as you can always negotiate down... Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: YTTRI Lisa [SMTP:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 10:58 AM To: Multiple recipients of list ORACLE-L Subject: Number of CPUs vs. Speed of CPUs We are in the process of sizing a new server for multiple Oracle instances. What factors are useful as input in determining how many CPUs and the relative speed of them? For example, do we want fewer, faster CPUs or do we want more, slower CPUs? Are there any good guidelines to determine what the number of CPUs should be? Thanks in advance - Lisa -- 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: Training for Oracle 8i
Peter - For 7 folks, I would bargain with a local training company to put on an in-house program customized for your needs. Unfortunately the training market is depressed so you can bargain lower rates. My manager got the rate cut in half. Oracle 8i programs are pretty mature by now. Pick and choose what applies to your site. I would at least get some prices and run it past your management chain. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, April 18, 2002 8:53 AM To: Multiple recipients of list ORACLE-L Hi Peter, A test box, documentation and time to play is what worked for me. Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 954-935-4117 -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 1:53 AM To: Multiple recipients of list ORACLE-L Subject: Training for Oracle 8i Dear Guru: I have a number of staff needs to upgrade their skills from Oracle 7.3.4 to Oracle 8.1.7. Going to Oracle Education Center will be too expensive given that I am looking at 7 person. Anyone have experience with electronic training using the Oracle CD-ROM training package, NETg On-line training, or other third party training tools? If yes, any recommendations? Pete -- 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: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Reorganize table
If you can't export, can you do ctas (create table as select..) ? Either way it's going to take a long, long time... Lisa Koivu Oracle Database Monkey. Fairfield Resorts, Inc. 954-935-4117 -Original Message- From: Raghu Kota [SMTP:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 11:39 AM To: Multiple recipients of list ORACLE-L Subject: Reorganize table Hi Friends, I need to reorganize my big fat table sized 23Gb, I don't have much space for export on my filesystem( I keep one or two filesystems ready for my expansion each size 4Gb) in the same table I have more than 5Gb free fragmented space, But I can't use it!! So what is best way to reorganize this monster table?? Thanks in advance Raghu. _ Join the world's largest e-mail service with MSN Hotmail. 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Quick Question
Sorry about this RTFM question, but I need a quick answer. I have a remote database in the UTF8 character set. When I export that DB I get this message: Export done in US7ASCII character set and UTF8 NCHAR character set server uses UTF8 character set (possible charset conversion) What can I set my NLS_LANG parameter to so that I get a full UTF8 export? Thanks, Mike --- === Michael P. Vergara Oracle DBA Guidant Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: EXP-00010 I need help
You have to have permission to export a database or scheman which is not your own. At least dba privs.. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, April 18, 2002 12:58 PM This is a valid user in database but not to export somebody has any idee o solve it. /sscedre/data/spcedw/admin/export[oracle]# exp userid=system/manager file=CTXSYS.dmp log=CTXSYS.log owner=CTXSYS Export: Release 8.1.7.2.0 - Production on Thu Apr 18 17:43:10 2002 (c) Copyright 2000 Oracle Corporation. All rights reserved. Connected to: Oracle8i Enterprise Edition Release 8.1.7.2.0 - 64bit Production With the Partitioning option JServer Release 8.1.7.2.0 - 64bit Production Export done in WE8ISO8859P15 character set and WE8ISO8859P1 NCHAR character set server uses WE8ISO8859P1 character set (possible charset conversion) About to export specified users ... EXP-00010: CTXSYS is not a valid username or not an exportable username Export terminated successfully with warnings. Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: KENNETH JANUSZ INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Bernard, Gilbert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: MySQL vs. Oracle database
Here's a quote from a most definitive resource, New Riders' book MySQL by Paul DuBois, The server has two kinds of locking. It uses internal locking to keep requests from clients from interfering with each other-- for example, to keep one client's SELECT query from being interrupted by another client's UPDATE query. (p. 472.) Steve Orr Bozeman, Montana -Original Message- Sent: Thursday, April 18, 2002 11:19 AM To: Multiple recipients of list ORACLE-L What makes you think that MySQL has read consistency? For read consistency I think MySQL is actually putting locks on tables during a query and when you have some intense queries with a lot of concurrent users they have to wait in line like 1000 rowdy kindergardeners. -- 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).
Re: Compare (diff) Oracle DB and MS-SQLServer DB
Oracle offers Migration Kit. Check OTN. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, April 18, 2002 1:28 PM One of our teams started programming in SQLServer, but now we are live in a production ORACLE environment. Due to several issues, such as licensing,skills, etc., the development must stay on SQLServer. Is there a tool or whatever to find out the deltas between a SQLServerDB and an Oracle DB? Or any suggestions. Ray _ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Gordon INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Reorganize table
You can export and compress on the fly This unix... mknod export_pipe p compress export_pipe export_file.dmp.Z exp userid file=export_pipe log=export.log table=(big_fat_table) compress=n Try it. I hope it compress to less than 5G. -Original Message- Sent: Thursday, April 18, 2002 10:19 AM To: Multiple recipients of list ORACLE-L If you can't export, can you do ctas (create table as select..) ? Either way it's going to take a long, long time... Lisa Koivu Oracle Database Monkey. Fairfield Resorts, Inc. 954-935-4117 -Original Message- From: Raghu Kota [SMTP:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 11:39 AM To: Multiple recipients of list ORACLE-L Subject: Reorganize table Hi Friends, I need to reorganize my big fat table sized 23Gb, I don't have much space for export on my filesystem( I keep one or two filesystems ready for my expansion each size 4Gb) in the same table I have more than 5Gb free fragmented space, But I can't use it!! So what is best way to reorganize this monster table?? Thanks in advance Raghu. _ Join the world's largest e-mail service with MSN Hotmail. 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Wong, Bing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Number of CPUs vs. Speed of CPUs
If pricing is a factor, and you're considering per-cpu pricing, then lean towards fewer, faster CPUs. I think Intel announced a 2Ghz processor this week... :-) Paul --- www.pythian.com -- [EMAIL PROTECTED] -- 877-PYTHIAN Smarter than adding another team member, Pythian has new services for supplementing DBAs: get our help with monitoring, 24x7 on-call, daily verifications, storage management, performance and more. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, April 18, 2002 11:58 AM We are in the process of sizing a new server for multiple Oracle instances. What factors are useful as input in determining how many CPUs and the relative speed of them? For example, do we want fewer, faster CPUs or do we want more, slower CPUs? Are there any good guidelines to determine what the number of CPUs should be? Thanks in advance - Lisa -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: YTTRI Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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 Vallee INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
