Re: Add/Drop partition and CBO statistics
Hi, Tanel: Thanks for your detailed suggestion. Dropped partition is removed from the db and oracle won't think of it again. There is a documented BUG : BUGNO: 2306067 PROBLEM: ADD/COALESCE/MERGE/SPLIT partition sets the table stats to NULL in spite of no-aggregation of index stats. This bug seems to have severe impact on CBO statistics, but I cannot reproduce it on my solaris 8172/linux 9204.Can someone reproduce? If yes, can you post your detailed version and steps? For the new partitions added, there is no data inside when it is added, new records are inserted into this partitions(range partition).In the begin of the month, there is a few records in the new added partition, as time goes by, the partition is full and new partition is added. THe existing partitiones are seldom modified after initial insert/later update.So it is difficult to decide when to analyze the new added partition.If I analyze the partition when it is added, statistics soon get out of date as new records are continuesly inserted into this partition. I used dbms_stats to gather statistics: exec dbms_stats.gather_table_stats(ownname='USERTEST',TABNAME='TESTPART', CASCADE=TRUE) DDL invalid the SQLs and procedures, which will cause reparse/recompile, and need to hold a lot of shared pool/library cache latch, but in my case, those latch are not the main wait event, as statspack report latch section looks like that: NoWait Waiter Latch Name Where Misses Sleeps Sleeps -- --- -- --- cache buffers chains kcbgtcr: kslbegin0320,308 ### cache buffers chains kcbrls: kslbegin 0583 1,142 cache buffers chains kcbgcur: kslbegin0 2 1 cache buffers chains kcbchg: kslbegin: bufs not 0 1 1 checkpoint queue latch kcbk0rrd: update recovery0 1 0 enqueue hash chains ksqrcl 0 64 13 enqueue hash chains ksqgtl3 0 34 85 enqueue hash chains ksqcnl 0 6 6 enqueues ksqgtl2 0 54 18 enqueues ksqdel 0 46 1 enqueues ksqrcl 0 32 36 enqueues ksqgel: create enqueue 0 29 112 enqueues ksqies 0 14 8 global tx free list k2gfegte 0 4 4 global tx hash mapping K2GTBlatch 0 82 82 library cachekglpnal: child: alloc spac 0 87 48 library cachekglpnal: child: before pro 0 83 136 library cachekgldte: child 0 0 70 136 Reusing partitiones are not avaliable for us,as we partition the tables according to primary key, which can't be reused.:( Thanks Regards Zhu Chao. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 02, 2003 9:29 PM Hi! When you delete a partition, naturally it's statistics get deleted as well. Now when you add another partition, it is initially without statistics, which means CBO has either to use default statistics or depending on optimizer_dynamic_sampling parameters value to read few blocks from your partition and extrapolate stats from there. This may lead to bad execution plans. The correct way would be to analyze your partition after adding it, but if you can't do it because don't want to cause additional load, you might want to use dbms_stats to manually set statistics to your new partition. You should first get the statistics from somewhere, possibly from a similar partition. Then you can do the real analyzing later on if you need. Note that global table statistics aren't recalculated when you drop a partition. (Well, the documentation claims that if you set _minimal_stats_aggregation to false, then global stats are recalculated, but I haven't managed to get it working). Part of your problem is probably that ALTER TABLE DROP/ADD partition command you use to modify partitions will make all of table's dependent objects (views, pl/sql) invalid, they require recompiling what means library cache locks latching. Also, all dependent SQL in library cache is invalidated as well, meaning hard parses - library cache/shared pool latching. In some cases this issue can be relieved by recycling partitions and using alter table truncate partition for emptying partitions, this doesn't at least invalidate dependent
RE: Perl / MySQL
I agree ... the lack of SP in mysql (soon to be released in the new version) is really not acceptable ... this is going to really help !! Not that I use mysql or anything ... really ... honest ... :) (oh smeg!!) -Original Message- DENNIS WILLIAMS Sent: Tuesday, December 02, 2003 8:00 PM To: Multiple recipients of list ORACLE-L Now we know MySQL is really ready to give Oracle some competition: Perl Interface to MySQL by Russell J.T. Dyer http://click.unixreview.email-publisher.com/maabITzaa2A6Ea2sdufb/ In the December installment in his MySQL series, Russell reviews the basics of building a MySQL interface with Perl. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: nelson flores INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ** can two processes use the same rollback extent
A single block can only be 'owned' by one transaction at a time, but when a transaction commits, it may put its last undo block into that segment's 'free pool' list if there is a lot of free space left in the block so that it can be made available for new transactions . (Gaja Vaidyanatha quoted 400 bytes as the limit). Regards Jonathan Lewis http://www.jlcomp.demon.co.uk The educated person is not the person who can answer the questions, but the person who can question the answers -- T. Schick Jr One-day tutorials: http://www.jlcomp.demon.co.uk/tutorial.html Three-day seminar: see http://www.jlcomp.demon.co.uk/seminar.html UK___November 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] Sent: Wednesday, December 03, 2003 3:59 AM i can answer the first part of your question.. YES, two transactions can write on the same extent of an RBS, i think the restriction is at the block level, this was true until 8i, might have changed in 9 + -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: cache buffer chains latch
My current understanding is: a)For normal buffer gets, the latch is acquired, the chain is scanned the buffer is pinned the latch is released the buffer is used -- the latch is acquired the pin is dropped (although the pin may be held for the duration of the SQL or pl/sql call if Oracle expects to revisit the buffer) b)Consistent gets - examination the latch is acquired the chain is scanned if the buffer can be found it read the latch is dropped Iin case (b), Oracle can make use of a shared read latch - where the underlying CPU supports it. But I may be wrong - especially about (b), and I haven't identified all the cases where an examination is legal. Question 2 - the best answers come from Steve Adams. But in summary, think library cache latch children - you may need to validate several objects in the library cache at once, and they could be covered by different child latches. Latches have a level#, from 0 to 9, and there is a precedence of latch acquisition across levels that is designed to stop latch acquisition deadlocks (again see S.A.). The holding of multiple latches also explains the presence of the column named (something like) waits_holding in v$latch. You have waited for this latch whilst holding another latch. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk The educated person is not the person who can answer the questions, but the person who can question the answers -- T. Schick Jr One-day tutorials: http://www.jlcomp.demon.co.uk/tutorial.html Three-day seminar: see http://www.jlcomp.demon.co.uk/seminar.html UK___November 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] Sent: Wednesday, December 03, 2003 4:19 AM Hi All, My system is suffering in cache buffer chain,I found the reason. My general questions is 1) When the process holding the latch how long the latch will be held ,until the hase chain is read or the process goes to the particular block and return the rows(output) ? 2) When the situation will occur for the process to hold two latches(different or same) simultaneously ? Please reply. Syed. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Plan stability
Thanks for hint, I didn't know there's something like this bundled. Unfortunately, when I tried to create outline I got error The outline could not be viewed. ORA-01405: fetched column value is NULL I have create/alter/drop any outline privilege, I even tried it as dba, but no luck. So, there must be another problem. Any guesses? rw If you want to force Oracle to use a particular plan, plan stability is orders of magnitude easier! Only if you happen to have the licence for the 9.2 performance tuning pack, and can use the dinky little GUI for drawing and manipulating outlines. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wartiak Rastislav INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Unix scripts on Windows 2000 after installing MKS tool kit
Hi
Has anybody experience with using unix scripts on Windows 2000 after
installing MKS toolkit?
Are those scripts run without major modification (after changing
path/folder
related info).
My client wants to run their unix shell scripts on their Windows platform
after installing MKS toolkit version 8.6.
Regards
Rafiq
Hi,
Last week I installed my dataguard scripts with a customer using MKS. I
developed them on Linux and Solaris. No serious problems, except with
dynamic generation of pathnames from database views (replace '\' by '/')
and some colon-related problems when using rcp/scp (e.g.
rcp ${SHOST}:D:\ORACLE\ORADATA\SID\SYSTEM01.ORA \
${DHOST}:D:\ORACLE\ORADATA\SID\SYSTEM01.ORA )
doesn't work. replace D: by D= (and replace backslashes, of course), and
all's fine.
I got ssh to work, although setting passwordless authentication didn't
work. Because the customer has a closed environment, rsh/rcp was
sufficient. Be aware that NTFS is needed to set protection for .rhosts and
rsa/dsa private key files.
Success, Carel-Jan
-- There will allways be another last 10 bugs --
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Carel-Jan Engel
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Re: ** can two processes use the same rollback extent
Yes Jonathan: I think that 400 byte concept came from one of the TPC benchmarks during Oracle 7 (or ORacle 6) days where the average undo size for a transcation was around 380+ bytes. So they had rounded that to 400 bytes and a maximum of 5 blocks will be linked to the freelist in the undo segment header. THis is called 'free extent pool' and the structure and the blocks are clearly visible in the undo header dumps. Regards, K Gopalakrishnan Bangalore, INDIA - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 03, 2003 1:59 PM A single block can only be 'owned' by one transaction at a time, but when a transaction commits, it may put its last undo block into that segment's 'free pool' list if there is a lot of free space left in the block so that it can be made available for new transactions . (Gaja Vaidyanatha quoted 400 bytes as the limit). Regards Jonathan Lewis http://www.jlcomp.demon.co.uk The educated person is not the person who can answer the questions, but the person who can question the answers -- T. Schick Jr One-day tutorials: http://www.jlcomp.demon.co.uk/tutorial.html Three-day seminar: see http://www.jlcomp.demon.co.uk/seminar.html UK___November 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] Sent: Wednesday, December 03, 2003 3:59 AM i can answer the first part of your question.. YES, two transactions can write on the same extent of an RBS, i think the restriction is at the block level, this was true until 8i, might have changed in 9 + -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 and Active Directory
Denham, I have been looking at OID since the company I am contracted to is also looking at using Active Directory. I tried using OID v2 (Oracle 8i) and it was terrible, I found it to be totally unreliable and very cumbersome to try and administer. OID v3 (Oracle 9i) is better and a few people on this list have stated to only consider using v3 not v2. However I am now confused we had an Oracle Salesman in last week and he stated that Active Directory (AD) replication was not available in OID v3 and he said to wait for Oracle 10G AS Release 9.0.4 which is the first version of OID to include AD integration. I have not had time yet to verify what version does have AD integration. Looks like you will need Oracle 9i/OID v3 or Oracle 10G AS Release 9.0.4 to allow an AD setup for Oracle 7.3.x.x and 8.1.7.x.x. I will update when I get more time to look into this. HTH, Neil. -Original Message- Sent: 02 December 2003 13:04 To: Multiple recipients of list ORACLE-L Hello List, The Company I work for is planning to go the Active Directory route. Does anyone know of any issues with the following versions of Oracle 7.3.x.x and 8.1.7.x.x? Regards Denham Eva -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Denham Eva INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: McBain, Neil SITI-ITDIEEE INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Arithmetics
Hi list In PL/SQL, 174413 - 169281.6 (as FLOAT) results in 5131.4 as it should. In Perl, it results in 5131.399. In C++ (GCC on both Linux and MS Windows) it results in 5131.4. I find it pretty irritating that perl doesn't handle that correctly. I know, it's always a problem with floating point arithmetics, but how is it, that perl already says good bye to accurate results while PL/SQL and C both still give the correct result ? Is there any work around or something I have to consider when doing floating point arithmetics in Perl ? I need to have accurate values without rounding them for statistic calculations. TIA, Stefan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stefan Jahnke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: cache buffer chains latch
Going by the original poster's use of the word suffering, there were at least 2 unprintable bugs in 8i prior to 8.1.7.4, if the versions are relevant in this case. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 03, 2003 9:39 PM My current understanding is: a)For normal buffer gets, the latch is acquired, the chain is scanned the buffer is pinned the latch is released the buffer is used -- the latch is acquired the pin is dropped (although the pin may be held for the duration of the SQL or pl/sql call if Oracle expects to revisit the buffer) b)Consistent gets - examination the latch is acquired the chain is scanned if the buffer can be found it read the latch is dropped Iin case (b), Oracle can make use of a shared read latch - where the underlying CPU supports it. But I may be wrong - especially about (b), and I haven't identified all the cases where an examination is legal. Question 2 - the best answers come from Steve Adams. But in summary, think library cache latch children - you may need to validate several objects in the library cache at once, and they could be covered by different child latches. Latches have a level#, from 0 to 9, and there is a precedence of latch acquisition across levels that is designed to stop latch acquisition deadlocks (again see S.A.). The holding of multiple latches also explains the presence of the column named (something like) waits_holding in v$latch. You have waited for this latch whilst holding another latch. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk The educated person is not the person who can answer the questions, but the person who can question the answers -- T. Schick Jr One-day tutorials: http://www.jlcomp.demon.co.uk/tutorial.html Three-day seminar: see http://www.jlcomp.demon.co.uk/seminar.html UK___November 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] Sent: Wednesday, December 03, 2003 4:19 AM Hi All, My system is suffering in cache buffer chain,I found the reason. My general questions is 1) When the process holding the latch how long the latch will be held ,until the hase chain is read or the process goes to the particular block and return the rows(output) ? 2) When the situation will occur for the process to hold two latches(different or same) simultaneously ? Please reply. Syed. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Binley Lim INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Arithmetics
That is because you don't use printf/ sprintf. Printf/sprintf helps you handle this thing correctly. Try executing the following code: #!/usr/bin/perl -w use strict; my $x=1.9; my $y=sprintf(%3.2f,$x); print $y\n; *** The result will be 2.0. Herzliche Gruessen. On 2003.12.03 05:54, Stefan Jahnke wrote: Hi list In PL/SQL, 174413 - 169281.6 (as FLOAT) results in 5131.4 as it should. In Perl, it results in 5131.399. In C++ (GCC on both Linux and MS Windows) it results in 5131.4. I find it pretty irritating that perl doesn't handle that correctly. I know, it's always a problem with floating point arithmetics, but how is it, that perl already says good bye to accurate results while PL/SQL and C both still give the correct result ? Is there any work around or something I have to consider when doing floating point arithmetics in Perl ? I need to have accurate values without rounding them for statistic calculations. TIA, Stefan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stefan Jahnke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
On Leave : 03-Dec to 17-Dec
Thank you for your email. I am sorry that I am not able to respond to you immediately as I am currently away. I am on Leave and out of Singapore 03-Dec to 17-Dec. Please resend Database action requests to my colleague Renga (Email : MUTHUKUMARASAMY Renga/IT/CHRT/ST Group, [EMAIL PROTECTED], Telephone 63604626] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Add/Drop partition and CBO statistics
Sometimes you want to run queries on partitions (using partition pruning or just using tablename partition (...)) and sometimes to run queries on whole tables. Currently I'm working on project where I have partitioned tables with data to process. First, I run checks on whole tables (to make sure data is valid) and then process partition by partition just to work with smaller blocks of data. So I have global indexes to support validation queries and local indexes to support actual data processing. rw Agreed that scanning one big index is faster than many partitions. Then raises the questions - I thought partitioning is for: 1) ease of archiving/dropping off old partitions - drop old and create new partitions in a sliding window. A single large global index negates a lot of this ease - even though it is true that deletes on non-partitioned tables would be even more inconvenient. 2) efficiencies in partition pruning for queries. If you are querying whole table - why bother with partitioning? The point then becomes you don't need to partition in the first place, or your partitioning scheme is not appropriate? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wartiak Rastislav INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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_support on 8i
I checked for 8.1.6.3.4 and 8.1.7.0 on windows. Not there. Yechiel AdarMehish - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Wednesday, December 03, 2003 12:19 AM Subject: dbms_support on 8i Does anyone know which patch level of 8i includes the dbmssupp.sql and .plb files? I have databases here that are at 8.1.7.4, but the files are not there. 9i has them, but none of the 8i databases. Thanks, Jared PS. Metalink was no help for this. Neither was google.
RE: Anyone run into this strange ORA-00904 error ??
Title: Message Thanks for all the ideas folks we decided to restore the TEST database instead of pursue so we would have less down time (problem was relatively recent). THEN in the middle of cold backup restore, I started seeing the same thing in my development instance . !!! I got help from a fellow DBA and we managed to track it down, but I was too stressed out from dealing with this all day to respond to let everyone know what happened. Bambi's idea was closet to problem When you havea function-based index, based on a user function and you do a fromuser/touser import, the touser tables that had the function-based index will get ORA-904, until the function-based index is dropped and re-created. According to Oracle, it is supposed to work this way. **I** think they should at least have an import warning. For those of you who wish to test for yourself (on 8.1.7), here is the test case we came up with: == 1 == Create BTU1 user == drop user btu1 cascade; create user btu1 identified by btu1 ; grant connect,resource to btu1; grant query rewrite to btu1; . == 2 == Create table and function-based index === connect btu1/btu1 create or replace package this_pkg IS function f_upper (in1 varchar2 ) return varchar2 deterministic; PRAGMA RESTRICT_REFERENCES( f_upper, WNDS, RNDS, WNPS); end this_pkg; / . create or replace package body this_pkg IS function f_upper ( in1 varchar2 ) return varchar2 is begin return upper(in1); end; end this_pkg; / create table btu1_table ( col1 number, col2 varchar2(30)) / insert into btu1_table values (1, 'hello') / insert into btu1_table values (2, 'goodbye') / create index btu1_index on btu1_table ( substr ( this_pkg.f_upper ( col2 ) ,1,30) ) / . == 3 == export this user == exp dba/passwd file=btu1.dmp owner=btu1 . == 4 == Create 2nd user to import objects into drop user btu2 cascade; create user btu2 identified by btu2 ; grant connect,resource to btu2; grant query rewrite to btu2; . == 5 == Import objects into anothe user == imp dba/passwd file=btu1.dmp fromuser=btu1 touser=btu2 . Export file created by EXPORT:V08.01.07 via conventional path import done in WE8EBCDIC1047 character set and WE8EBCDIC1047 NCHAR character set . importing BTU1's objects into BTU2 . . importing table "BTU1_TABLE" 2 rows imported Import terminated successfully without warnings. . == 6 == Select the newly imported objects and get ORA-904 sqlplus btu2/btu2 SQL select * from btu1_table; select * from btu1_table * ERROR at line 1: ORA-00904: invalid column name Babette Turner-Underwood work: [EMAIL PROTECTED] home: [EMAIL PROTECTED] 954-3752 (Mon - Fri 7am - 3pm) -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bellow, BambiSent: 2003-12-02 6:14 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Anyone run into this strange ORA-00904 error ?? I have run into this problem in the past in two different situations. The first is where there is a reserved word somewhere that you managed to sneak through somehow... the second is where there is an internal view created for some reason that barfs... e.g., VW_NSO_1.$NSO_COL_1. Check your alert log. If it's the latter, it's a bug. If it's the former, tryspecifying the columns and adding a column alias where the column could conceivably be a reserved word. You didn't give us all the column names, but try something like this... select internal_identifier int_id, title_cd,nonissue, nonissue2, boy_this_could_be_a_problem a,nonissue3... from your_table where x=y HTH, Bambi. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 02, 2003 10:34 AMTo: Multiple recipients of list ORACLE-LSubject: Anyone run into this strange ORA-00904 error ?? We started having a weird problem that looks like some kind of data dictionary corruption. My first choice is to run catalog / catproc. This did nothing to resolve the problem. Why am I able to describe an object, but get ORA-00904 when I try to select from the table... SQL desc ispownre3.individual_names; Name Null? Type - -- INTERNAL_IDENTIFIER NUMBER(12) TITLE_CD NUMBER(3) . . . SQL select * from ispownre3.individual_names; select * from ispownre3.individual_names * ERROR at line 1: ORA-00904: invalid column name
partitioning option licensing
Hi, We're looking into migrating from SQL server to Oracle. Does anyone know if Partitioning option is still licensed separately? Thanks. pat _ Our best dial-up offer is back. Get MSN Dial-up Internet Service for 6 months @ $9.95/month now! http://join.msn.com/?page=dept/dialup -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Patricia Zhu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
log_archive_dest_2
Hi All, When I set log_archive_dest_2 to a valid local destination Dynamically on 8.1.7.0 it is not generating the archive files.. It is generating the archive files on on log_archive_dest_1 I even tried with the following settings .. 1] both log_archive_dest_1 and log_archive_dest_2 made MANDATORY 2] log_archive_min_succed_dest = 2 2] log_archive_process = 10 Still it is not creating archives in the second location. Am i missing something? Thanks and Regards B S Pradhan
Reporting database
Hi Listers, I'm about producing document to my boss about different strategies to build Informational database (reporting database) and ETL. Our production database is 9i supporting Oracle Financials 11i. I'm concerned about the strategies that have a minimum impact on the overload of production database. Could you please give me your advise and experience. Any input well be very appreciated. Have nice day, Kader __ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kader Ben INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: partitioning option licensing
Title: RE: partitioning option licensing As of 9iR2, partitioning is still licensed separately as a $10K (retail) extra charge per processor. So, the total retail comes to a painful $50K per processor for 9i + Partitioning. Also, remember that support costs X% of the licensing per year, depending on your support level. You'll have to confirm the exact numbers with your sales rep. You can estimate about 22%, as I recall. We just increased our licensing a few months ago. Get the fastest processors you can. Anyone know how 10g will be licensed? Best regards, David B. Wagoner Database Administrator Arsenal Digital Solutions Web: http://www.arsenaldigital.com the most trusted source for STORAGE MANAGEMENT SERVICES The contents of this e-mail message may be privileged and/or confidential. If you are not the intended recipient, any review, dissemination, copying, distribution or other use of the contents of this message or any attachment by you is strictly prohibited. If you receive this communication in error, please notify us immediately by return e-mail or by telephone (919-466-6700), and please delete this message and all attachments from your system. Thank you. -Original Message- From: Patricia Zhu [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 03, 2003 8:54 AM To: Multiple recipients of list ORACLE-L Subject: partitioning option licensing Hi, We're looking into migrating from SQL server to Oracle. Does anyone know if Partitioning option is still licensed separately? Thanks. pat _ Our best dial-up offer is back. Get MSN Dial-up Internet Service for 6 months @ $9.95/month now! http://join.msn.com/?page=dept/dialup -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Patricia Zhu INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: partitioning option licensing
-Original Message- Hi, We're looking into migrating from SQL server to Oracle. Does anyone know if Partitioning option is still licensed separately? Thanks. pat Having just met with an Oracle rep yesterday. Yes, it is still licensed separately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Simpson, Ken INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: log_archive_dest_2
Try archive log stop; and archive log start; after setting the parameters.. Tanel. Hi All, When I set log_archive_dest_2 to a valid local destination Dynamically on 8.1.7.0 it is not generating the archive files.. It is generating the archive files on on log_archive_dest_1 I even tried with the following settings .. 1] both log_archive_dest_1 and log_archive_dest_2 made MANDATORY 2] log_archive_min_succed_dest = 2 2] log_archive_process = 10 Still it is not creating archives in the second location. Am i missing something? Thanks and Regards B S Pradhan
Re: RE: partitioning option licensing
never pay retail with oracle licensing. who pays the full $10k? If your buying other stuff you should be able to knock off alot. Never pay the full amount. From: David Wagoner [EMAIL PROTECTED] Date: 2003/12/03 Wed AM 09:24:38 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: partitioning option licensing As of 9iR2, partitioning is still licensed separately as a $10K (retail) extra charge per processor. So, the total retail comes to a painful $50K per processor for 9i + Partitioning. Also, remember that support costs X% of the licensing per year, depending on your support level. You'll have to confirm the exact numbers with your sales rep. You can estimate about 22%, as I recall. We just increased our licensing a few months ago. Get the fastest processors you can. Anyone know how 10g will be licensed? Best regards, David B. Wagoner Database Administrator Arsenal Digital Solutions Web: http://www.arsenaldigital.com the most trusted source for STORAGE MANAGEMENT SERVICES The contents of this e-mail message may be privileged and/or confidential. If you are not the intended recipient, any review, dissemination, copying, distribution or other use of the contents of this message or any attachment by you is strictly prohibited. If you receive this communication in error, please notify us immediately by return e-mail or by telephone (919-466-6700), and please delete this message and all attachments from your system. Thank you. -Original Message- Sent: Wednesday, December 03, 2003 8:54 AM To: Multiple recipients of list ORACLE-L Hi, We're looking into migrating from SQL server to Oracle. Does anyone know if Partitioning option is still licensed separately? Thanks. pat _ Our best dial-up offer is back. Get MSN Dial-up Internet Service for 6 months @ $9.95/month now! http://join.msn.com/?page=dept/dialup -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Patricia Zhu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Title: RE: partitioning option licensing As of 9iR2, partitioning is still licensed separately as a $10K (retail) extra charge per processor. So, the total retail comes to a painful $50K per processor for 9i + Partitioning. Also, remember that support costs X% of the licensing per year, depending on your support level. You'll have to confirm the exact numbers with your sales rep. You can estimate about 22%, as I recall. We just increased our licensing a few months ago. Get the fastest processors you can. Anyone know how 10g will be licensed? Best regards, David B. Wagoner Database Administrator Arsenal Digital Solutions Web: http://www.arsenaldigital.com the most trusted source for STORAGE MANAGEMENT SERVICES The contents of this e-mail message may be privileged and/or confidential. If you are not the intended recipient, any review, dissemination, copying, distribution or other use of the contents of this message or any attachment by you is strictly prohibited. If you receive this communication in error, please notify us immediately by return e-mail or by telephone (919-466-6700), and please delete this message and all attachments from your system. Thank you. -Original Message- From: Patricia Zhu [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 03, 2003 8:54 AM To: Multiple recipients of list ORACLE-L Subject: partitioning option licensing Hi, We're looking into migrating from SQL server to Oracle. Does anyone know if Partitioning option is still licensed separately? Thanks. pat _ Our best dial-up offer is back. Get MSN Dial-up Internet Service for 6 months @ $9.95/month now! http://join.msn.com/?page=dept/dialup -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Patricia Zhu INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be
Oracle Internet Directory and Active Directory Integration
Title: Oracle Internet Directory and Active Directory Integration Embarrassed by Google/OTN, after stating I had not had time to verify what version integrates with AD, I spent 10 mins on Google and OTN (Oracle Technology Network) and hey presto :- With Oracle9i Application Server 9.0.4, Oracle will offer prepackaged connectivity solutions for NT Domains and ADS. These solutions will allow Oracle customers to perform two-way synchronization of directory data between the Windows and Oracle environments. Therefore the answer is any version prior to Oracle 9i Application Server 9.0.4 does not have out-of-the-box integration with Active Directory.
Re: xml formatting problem after upgrade to 9.2.0.3 from 9.2.0.1
Jake, You may want to check the xml or xmldb form on otn.oracle.com. I seem to recall seeing a similar question. I tried to run a search, but the site is 404 at this time for me.Jake Johnson [EMAIL PROTECTED] wrote: Since I upgraded to 9.2.0.3 my xml is no longer indented. Any ideas?9.2.0.1JDEFAZIOJWMILLE2SNGHATTAJALARAGHAM9.2.0.3JDEFAZIOJWMILLE2SNGHATTAJALARAGHAM-- Thanks,Jake Johnson[EMAIL PROTECTED]__Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices onRims, Tires, and Wheel Packages.-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Jake JohnsonINET: [EMAIL PROTECTED]Fat City Network ! Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To 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). Do you Yahoo!? Free Pop-Up Blocker - Get it now
Re: Anyone run into this strange ORA-00904 error ??
Sometimes the upper case and lower case get mixed up in the data dictionary. I know that Oracle claims case insensitivity but it happens. Take a look at sys.col$ and sys.obj$. --- Krishna Kakatur [EMAIL PROTECTED] wrote: Did you check grants on the table? This happens sometimes, with some oracle versions, in the following situation: step1: user1 creates tab1 and grants all to user2. (without grant option) step2: user2 creates view1 based on tab1 and grants all to user3. Now, when user3 tries to access view1 he gets this kind of error. This can be resolved by issuing the foll sql in step1 GRANT ALL ON tab1 TO user2 WITH ADMIN OPTION; -- Thanks, Krishna ~~ NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. ~~ [EMAIL PROTECTED] wrote: We started having a weird problem that looks like some kind of data dictionary corruption. My first choice is to run catalog / catproc. This did nothing to resolve the problem. Why am I able to describe an object, but get ORA-00904 when I try to select from the table... SQL desc ispownre3.individual_names; Name Null? Type - -- INTERNAL_IDENTIFIER NUMBER(12) TITLE_CD NUMBER(3) . . . SQL select * from ispownre3.individual_names; select * from ispownre3.individual_names * ERROR at line 1: ORA-00904: invalid column name -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Krishna Kakatur INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Peter Barnett INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 and Active Directory
1) I also heard that OID is not good before 9.2.0.4. You can however install 9.2.0.4 with OID and use it for authenticating users that are connecting to 8.1.6 (and probably 8.1.7 but I did not tested it). 2) MS has a product called MIIS. It should update the OID with any changes done in AD. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 02, 2003 3:04 PM Hello List, The Company I work for is planning to go the Active Directory route. Does anyone know of any issues with the following versions of Oracle 7.3.x.x and 8.1.7.x.x? Regards Denham Eva -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Denham Eva INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
ora-01008 oci migration
Hi, We are migrating from oracle 7.3.4.3 to oracle 9.2.0.4 without changing clientcode which is built with oci 7 for oracle 7 db. Code gives this error while printing all bind variables with values such that I can only conclude all variables are bound. Binding doesn't produce an error. Error appears on calling function oexn Details: HP-UX 10.20 (client) HP-UX 11.11 oracle 9.2.0.4 database Hope you can help soon Tnx, Jeroen P.S. I know this is a bit OT but I have limited oci-experience and no developers with this experience
RE: Anyone run into this strange ORA-00904 error ??
I have also seen a case where new line or other weird ASCII charater find they way into the name that could cause this behavior. -Original Message- Sent: Wednesday, December 03, 2003 10:14 AM To: Multiple recipients of list ORACLE-L Sometimes the upper case and lower case get mixed up in the data dictionary. I know that Oracle claims case insensitivity but it happens. Take a look at sys.col$ and sys.obj$. --- Krishna Kakatur [EMAIL PROTECTED] wrote: Did you check grants on the table? This happens sometimes, with some oracle versions, in the following situation: step1: user1 creates tab1 and grants all to user2. (without grant option) step2: user2 creates view1 based on tab1 and grants all to user3. Now, when user3 tries to access view1 he gets this kind of error. This can be resolved by issuing the foll sql in step1 GRANT ALL ON tab1 TO user2 WITH ADMIN OPTION; -- Thanks, Krishna ~~ NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. ~~ [EMAIL PROTECTED] wrote: We started having a weird problem that looks like some kind of data dictionary corruption. My first choice is to run catalog / catproc. This did nothing to resolve the problem. Why am I able to describe an object, but get ORA-00904 when I try to select from the table... SQL desc ispownre3.individual_names; Name Null? Type - -- INTERNAL_IDENTIFIER NUMBER(12) TITLE_CD NUMBER(3) . . . SQL select * from ispownre3.individual_names; select * from ispownre3.individual_names * ERROR at line 1: ORA-00904: invalid column name -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Krishna Kakatur INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Peter Barnett INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle 9i on Fedora
Hi, I am running into a problem installing Oracle 9i on Fedora. I get the following error when starting the Oracle installer. error while loading shared libraries: libstdc++-libc6.1-1.so.2: cannot open shared object file: No such file or directory I figured I would ask if anybody has worked through a solution before I start pounding away on the same wheel. Thanks much, -- Joe Frohne Rawson Oaks Consulting, Remote Oracle Admins http://www.rawsonoaks.com [EMAIL PROTECTED] or [EMAIL PROTECTED] Oak Creek, WI, USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Frohne INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Which storage solution is good or you will recommend
We lost a board on our 9970 and it phoned home and a hitachi tech was here the next day to replace it and we didn't even know it was broken. They replace boards and upgrade firmware live. We had the same experience with EMC. Talk about service! Can you imagine getting a phone call... Hi, this is Oracle support. About that ora-600 in your alert.log... What 600 in my alert log? Well, indications are that you are *going* to have a 600 problem within the next 48 hours, and we'd just like to correct this situation before you run into problems... -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bellow, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Which storage solution is good or you will recommend
Bambi ... Day Dreaming again ... are we? Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Sent: Wednesday, December 03, 2003 11:39 AM To: Multiple recipients of list ORACLE-L Can you imagine getting a phone call... Hi, this is Oracle support. About that ora-600 in your alert.log... What 600 in my alert log? Well, indications are that you are *going* to have a 600 problem within the next 48 hours, and we'd just like to correct this situation before you run into problems... ** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 on Fedora
Dear fellow Cheesehead, If anyone has figured out 9i on Fedora, Werner Puschitz has: http://www.puschitz.com GL! Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- Sent: Wednesday, December 03, 2003 10:34 AM To: Multiple recipients of list ORACLE-L Hi, I am running into a problem installing Oracle 9i on Fedora. I get the following error when starting the Oracle installer. error while loading shared libraries: libstdc++-libc6.1-1.so.2: cannot open shared object file: No such file or directory I figured I would ask if anybody has worked through a solution before I start pounding away on the same wheel. Thanks much, -- Joe Frohne Rawson Oaks Consulting, Remote Oracle Admins http://www.rawsonoaks.com [EMAIL PROTECTED] or [EMAIL PROTECTED] Oak Creek, WI, USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ** can two processes use the same rollback extent
IIRC, a segment will not wrap into an extent that has an active transaction in it, but rather allocate a new extent. So the answer is...it depends. Daniel Fink A Joshi wrote: Hi, One rollback segment can be used by multiple transactions/processes but what about the extents? Is it safe to assume that only one transaction/process can use one extent? What is a good way to size the extent for warehousing tasks? Or guess the rollback generated and size needed. Thank You Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard
RE: Which storage solution is good or you will recommend
The high end arrays from EMC and Hitachi, and to a lesser extent NetApp, all have this sort of dial-home functionality. I can't speak for Hitachi (though I've heard good things), but the Symmetrix will dial home for events that seem completely inocuous (a host is rebooted that is attached to the storage, for example), and in many cases a lab tech will dial back into the array to take a look. This could happen many many times a month and is one of the reasons a premium is paid for high-end arrays. Thanks, Matt -- Matthew Zito GridApp Systems Email: [EMAIL PROTECTED] Cell: 646-220-3551 Phone: 212-358-8211 x 359 http://www.gridapp.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bellow, Bambi Sent: Wednesday, December 03, 2003 11:39 AM To: Multiple recipients of list ORACLE-L Subject: RE: Which storage solution is good or you will recommend We lost a board on our 9970 and it phoned home and a hitachi tech was here the next day to replace it and we didn't even know it was broken. They replace boards and upgrade firmware live. We had the same experience with EMC. Talk about service! Can you imagine getting a phone call... Hi, this is Oracle support. About that ora-600 in your alert.log... What 600 in my alert log? Well, indications are that you are *going* to have a 600 problem within the next 48 hours, and we'd just like to correct this situation before you run into problems... -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bellow, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Matthew Zito INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
what is the difference between shared nothing and shared everything?
this has to do with RAC right? oracle uses shared everything and ibm uses shared nothing right? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
FW: raw traces - EXEC: c=10,000 e=40
Wolfgang, The OS has always provided microsecond data to the Oracle kernel (see the 'man gettimeofday' and 'man getrusage'). It's only in release 9 that the Oracle kernel stopped truncating the data at the centisecond digit (by doing an integer division of 1). Oracle gets elapsed times by comparing pairs of gettimeofday() calls (truss to find out for yourself). The e=40us is actually accurate to within +/-1us (not counting measurement intrusion effect). The c value is potentially way off, as I explained in the other note. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Performance Diagnosis 101: 12/16 Detroit, 1/27 Atlanta - SQL Optimization 101: 12/8 Dallas, 2/16 Dallas - Hotsos Symposium 2004: March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- Wolfgang Breitling Sent: Tuesday, December 02, 2003 3:54 PM To: Multiple recipients of list ORACLE-L In Oracle 9, Oracle tries to measure times in microseconds (as opposed to centiseconds pre-9). However, many Systems only slice time far coarser than that so Oracle has to fake it to some degree and that faking may be different between cpu time and elapsed time. Take your cpu times for example. They are all 1 microseconds which is exactly 1/100 = 0.01 = 1 centiseconds. That's a bit too much of a coincidence for me. Who knows where Oracle get the elapsed times from. I wouldn't put too much faith in the accuracy of an purported elapsed time of 40 microseconds. Unless we are getting at least into the milliseconds range I would regard all elapsed times as rounding errors. At 02:09 PM 12/2/2003, you wrote: Hi! I haven't read Cary's book yet (although it's already waiting on my bookshelf), but I think CPU time c is measured in timeslice steps (100ms) and elapsed time e is taken from system timer or smth like that. Others will know better :) Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 02, 2003 10:49 PM Reading Cary's book I understand that c and e are measured via different system calls (haven't truss'ed [well tusc'ed] them yet - I am on HP-UX 11.11), but would anybody know what the reasonable upper limit of c-e might be? I am looking at the trace file where c is more than two orders of magnitude greater than e, which make me wonder if I a have some anomaly on my system Some examples: EXEC #98:c=1,e=433,p=0,cr=2,cu=2,mis=0,r=1,dep=1,og=4,tim=1777312113968 EXEC #110:c=1,e=390,p=0,cr=1,cu=3,mis=0,r=1,dep=1,og=4,tim=1777312181650 PARSE #103:c=1,e=40,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1777314524922 Oracle 9.2.0.4.0 on HP-UX 11.11 Thanks, Boris Dali. __ Post your free ad now! http://personals.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boris Dali INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). --
what happened to baarf.net?
anyone got the articles about why raid 5 is bad for databases? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 on Fedora
I haven't tried with Fedora and I don't intend until core 2 is out, but what you need is standard C++ rel 6.1. On RH-9, the required RPM is compat-libstdc++-7.3-2.96.118 On 12/03/2003 11:34:24 AM, Joe Frohne wrote: Hi, I am running into a problem installing Oracle 9i on Fedora. I get the following error when starting the Oracle installer. error while loading shared libraries: libstdc++-libc6.1-1.so.2: cannot open shared object file: No such file or directory I figured I would ask if anybody has worked through a solution before I start pounding away on the same wheel. Thanks much, -- Joe Frohne Rawson Oaks Consulting, Remote Oracle Admins http://www.rawsonoaks.com [EMAIL PROTECTED] or [EMAIL PROTECTED] Oak Creek, WI, USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Frohne INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: FW: raw traces - EXEC: c=10,000 e=40
Thanks for the clarification. At 10:29 AM 12/3/2003, you wrote: Wolfgang, The OS has always provided microsecond data to the Oracle kernel (see the 'man gettimeofday' and 'man getrusage'). It's only in release 9 that the Oracle kernel stopped truncating the data at the centisecond digit (by doing an integer division of 1). Oracle gets elapsed times by comparing pairs of gettimeofday() calls (truss to find out for yourself). The e=40us is actually accurate to within +/-1us (not counting measurement intrusion effect). The c value is potentially way off, as I explained in the other note. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: raw traces - EXEC: c=10,000 e=40
Is this true? strace-ing on linux shows gettimeofday calls (for e) and getrusage (for c) - just like Cary describes. On HP however tusc-ing a simple select * from dual issued from sqlplus I see: calls sys call - 1 gettimeofday() 1 getrusage() 15times() Which sys call is used for what? Guess I can turn timed_statistics off and see how it affects the (amount of) sys calls issued Thanks, Boris Dali. --- Niall Litchfield [EMAIL PROTECTED] wrote: me reads Jonathan's description and blushes/me So it'll be a *feature* and not a bug then. IIRC e comes from POSIX gettimeofday calls on all platforms except Windows -- where it looks like GetTickCount. If this is true then the accuracy of e will be limited by the accuracy of gettimeofday. Niall -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Niall Litchfield Sent: 02 December 2003 22:24 To: Multiple recipients of list ORACLE-L Subject: RE: raw traces - EXEC: c=10,000 e=40 I'd be highly, highly suspicious of the cpu time c. 1. You should be able to verify (roughly the elapsed time) of the statement, if by no other means than running in sqlplus with timing on. 2. 3 statements with *exactly* the same cpu time - all in very very round numbers. Seems unlikely to me. Might be an hp-ux bug but as I don't have HP-UX to play with that is speculation of the first order. Niall -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Boris Dali Sent: 02 December 2003 20:49 To: Multiple recipients of list ORACLE-L Subject: raw traces - EXEC: c=10,000 e=40 Reading Cary's book I understand that c and e are measured via different system calls (haven't truss'ed [well tusc'ed] them yet - I am on HP-UX 11.11), but would anybody know what the reasonable upper limit of c-e might be? I am looking at the trace file where c is more than two orders of magnitude greater than e, which make me wonder if I a have some anomaly on my system Some examples: EXEC #98:c=1,e=433,p=0,cr=2,cu=2,mis=0,r=1,dep=1,og=4,tim=1777312113968 EXEC #110:c=1,e=390,p=0,cr=1,cu=3,mis=0,r=1,dep=1,og=4,tim=1777 312181650 PARSE #103:c=1,e=40,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1777314524922 Oracle 9.2.0.4.0 on HP-UX 11.11 Thanks, Boris Dali. __ Post your free ad now! http://personals.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boris Dali INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Post your free ad now! http://personals.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boris Dali INET: [EMAIL PROTECTED] Fat City Network Services--
Re: ** can two processes use the same rollback extent
And to further refine that statement and IIRC, a transaction will not use an extent E, that already has an active transaction in it, when the transaction has filled up the previous extent S, and is now looking to wrap into a new extent E. However, a fresh transaction can always be allocated space in an extent that already has an active transaction in it. Regards Raj Daniel Fink [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] un.COM cc: Sent by: Subject: Re: ** can two processes use the same rollback extent [EMAIL PROTECTED] ity.com 12/03/2003 12:04 PM Please respond to ORACLE-L IIRC, a segment will not wrap into an extent that has an active transaction in it, but rather allocate a new extent. So the answer is...it depends. Daniel Fink A Joshi wrote: Hi, One rollback segment can be used by multiple transactions/processes but what about the extents? Is it safe to assume that only one transaction/process can use one extent? What is a good way to size the extent for warehousing tasks? Or guess the rollback generated and size needed. Thank You -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Perl / MySQL
This isn't new: am I missing something here? DENNIS WILLIAMS [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/02/2003 07:59 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Perl / MySQL Now we know MySQL is really ready to give Oracle some competition: Perl Interface to MySQL by Russell J.T. Dyer http://click.unixreview.email-publisher.com/maabITzaa2A6Ea2sdufb/ In the December installment in his MySQL series, Russell reviews the basics of building a MySQL interface with Perl. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: decrease initial extent
You can move it after you convert the long field to LOB. As it is one of the system tables which appears in noexp$, it's not guaranteed that your database will work afterward. OK, let me restate it: it's guaranteed that it will not work. Other then that, it's only exp/imp of the full database, and after editing sql.bsq (not for fainthearted) On 12/03/2003 01:09:28 PM, Yechiel Adar wrote: Is there any way to decrease the initial extent allocated to a table. It is one of the system tables, so I do not want to drop and recreate it. I can not export/import as it appear in noexp$. It has long field so I can not do alter table move. Yechiel Adar Mehish -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: raw traces - EXEC: c=10,000 e=40
The gettimeofday() function obtains the current time, expressed as
seconds and microseconds since 00:00 Coordinated Universal Time
(UTC),
January 1, 1970, and stores it in the timeval structure pointed
to by
tp. The resolution of the system clock is unspecified.
The getrusage() function provides measures of the resources used by
the current process or its terminated and waited-for child
processes.
If the value of the who argument is RUSAGE_SELF, information is
returned about resources used by the current process. If the value
of
the who argument is RUSAGE_CHILDREN, information is returned about
resources used by the terminated and waited-for children of the
current process. If the child is never waited for (for instance,
if
the parent has SA_NOCLDWAIT set or sets SIGCHLD to SIG_IGN), the
resource information for the child process is discarded and not
included in the resource information provided by getrusage(). The
r_usage argument is a pointer to an object of type struct rusage
in
which the returned information is stored
times() fills the structure pointed to by buffer with time-accounting
information. The structure defined in sys/times.h is as
follows:
struct tms {
clock_t tms_utime; /* user time */
clock_t tms_stime; /* system time */
clock_t tms_cutime; /* user time, children */
clock_t tms_cstime; /* system time, children */
};
This information comes from the calling process and each of its
terminated child processes for which it has executed a wait(),
These are from HPUX 11.11. In HPUX and all other unix execute man your
command or system call to get more information.
Allan
-Original Message-
Boris Dali
Sent: Wednesday, December 03, 2003 12:29 PM
To: Multiple recipients of list ORACLE-L
Is this true? strace-ing on linux shows gettimeofday
calls (for e) and getrusage (for c) - just like Cary
describes. On HP however tusc-ing a simple select *
from dual issued from sqlplus I see:
calls sys call
-
1 gettimeofday()
1 getrusage()
15times()
Which sys call is used for what?
Guess I can turn timed_statistics off and see how it
affects the (amount of) sys calls issued
Thanks,
Boris Dali.
--- Niall Litchfield
[EMAIL PROTECTED] wrote: me reads Jonathan's
description and blushes/me
So it'll be a *feature* and not a bug then. IIRC e
comes from POSIX
gettimeofday calls on all platforms except Windows
-- where it looks
like GetTickCount. If this is true then the accuracy
of e will be
limited by the accuracy of gettimeofday.
Niall
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On
Behalf Of Niall Litchfield
Sent: 02 December 2003 22:24
To: Multiple recipients of list ORACLE-L
Subject: RE: raw traces - EXEC: c=10,000 e=40
I'd be highly, highly suspicious of the cpu time
c.
1. You should be able to verify (roughly the
elapsed time) of
the statement, if by no other means than running
in sqlplus
with timing on.
2. 3 statements with *exactly* the same cpu time -
all in
very very round numbers. Seems unlikely to me.
Might be an hp-ux bug but as I don't have HP-UX to
play with
that is speculation of the first order.
Niall
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On
Behalf Of Boris Dali
Sent: 02 December 2003 20:49
To: Multiple recipients of list ORACLE-L
Subject: raw traces - EXEC: c=10,000 e=40
Reading Cary's book I understand that c and e
are
measured via different system calls (haven't
truss'ed
[well tusc'ed] them yet - I am on HP-UX 11.11),
but
would anybody know what the reasonable upper
limit of
c-e might be?
I am looking at the trace file where c is more
than
two orders of magnitude greater than e, which
make me
wonder if I a have some anomaly on my system
Some examples:
EXEC
#98:c=1,e=433,p=0,cr=2,cu=2,mis=0,r=1,dep=1,og=4,tim=1777312113968
EXEC
#110:c=1,e=390,p=0,cr=1,cu=3,mis=0,r=1,dep=1,og=4,tim=1777
312181650
PARSE
#103:c=1,e=40,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1777314524922
Oracle 9.2.0.4.0 on HP-UX 11.11
Thanks,
Boris Dali.
__
Post your free ad now! http://personals.yahoo.ca
--
Please see the official ORACLE-L FAQ:
http://www.orafaq.net
--
Author: Boris Dali
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
http://www.fatcity.com
San Diego, California-- Mailing list and
web
hosting services
-
To REMOVE yourself from this mailing list, send
an
RE: raw traces - EXEC: c=10,000 e=40
You're on the right trail by experimenting with it. I'm surprised that the number of gettimeofday() calls is so small. The times() call is the SVR4 analog of the BSD getrusage() call. I guess I shouldn't be surprised to see both times() and getrusage() being used. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Performance Diagnosis 101: 12/16 Detroit, 1/27 Atlanta - SQL Optimization 101: 12/8 Dallas, 2/16 Dallas - Hotsos Symposium 2004: March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- Boris Dali Sent: Wednesday, December 03, 2003 12:29 PM To: Multiple recipients of list ORACLE-L Is this true? strace-ing on linux shows gettimeofday calls (for e) and getrusage (for c) - just like Cary describes. On HP however tusc-ing a simple select * from dual issued from sqlplus I see: calls sys call - 1 gettimeofday() 1 getrusage() 15times() Which sys call is used for what? Guess I can turn timed_statistics off and see how it affects the (amount of) sys calls issued Thanks, Boris Dali. --- Niall Litchfield [EMAIL PROTECTED] wrote: me reads Jonathan's description and blushes/me So it'll be a *feature* and not a bug then. IIRC e comes from POSIX gettimeofday calls on all platforms except Windows -- where it looks like GetTickCount. If this is true then the accuracy of e will be limited by the accuracy of gettimeofday. Niall -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Niall Litchfield Sent: 02 December 2003 22:24 To: Multiple recipients of list ORACLE-L Subject: RE: raw traces - EXEC: c=10,000 e=40 I'd be highly, highly suspicious of the cpu time c. 1. You should be able to verify (roughly the elapsed time) of the statement, if by no other means than running in sqlplus with timing on. 2. 3 statements with *exactly* the same cpu time - all in very very round numbers. Seems unlikely to me. Might be an hp-ux bug but as I don't have HP-UX to play with that is speculation of the first order. Niall -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Boris Dali Sent: 02 December 2003 20:49 To: Multiple recipients of list ORACLE-L Subject: raw traces - EXEC: c=10,000 e=40 Reading Cary's book I understand that c and e are measured via different system calls (haven't truss'ed [well tusc'ed] them yet - I am on HP-UX 11.11), but would anybody know what the reasonable upper limit of c-e might be? I am looking at the trace file where c is more than two orders of magnitude greater than e, which make me wonder if I a have some anomaly on my system Some examples: EXEC #98:c=1,e=433,p=0,cr=2,cu=2,mis=0,r=1,dep=1,og=4,tim=1777312113968 EXEC #110:c=1,e=390,p=0,cr=1,cu=3,mis=0,r=1,dep=1,og=4,tim=1777 312181650 PARSE #103:c=1,e=40,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1777314524922 Oracle 9.2.0.4.0 on HP-UX 11.11 Thanks, Boris Dali. __ Post your free ad now! http://personals.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boris Dali INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
Re: Oracle 9i on Fedora
Thanks to all who replied. I thought I had installed compat-libstdc++-7.3-2.96.118, but I missed it and it didn't trigger right away in my brain when the error popped out :) Thanks, Joe -- Joe Frohne Rawson Oaks Consulting, Remote Oracle Admins http://www.rawsonoaks.com [EMAIL PROTECTED] or [EMAIL PROTECTED] Oak Creek, WI, USA I haven't tried with Fedora and I don't intend until core 2 is out, but what you need is standard C++ rel 6.1. On RH-9, the required RPM is compat-libstdc++-7.3-2.96.118 On 12/03/2003 11:34:24 AM, Joe Frohne wrote: Hi, I am running into a problem installing Oracle 9i on Fedora. I get the following error when starting the Oracle installer. error while loading shared libraries: libstdc++-libc6.1-1.so.2: cannot open shared object file: No such file or directory I figured I would ask if anybody has worked through a solution before I start pounding away on the same wheel. Thanks much, -- Joe Frohne Rawson Oaks Consulting, Remote Oracle Admins http://www.rawsonoaks.com [EMAIL PROTECTED] or [EMAIL PROTECTED] Oak Creek, WI, USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Frohne INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Joe Frohne Rawson Oaks Consulting, Remote Oracle Admins http://www.rawsonoaks.com [EMAIL PROTECTED] or [EMAIL PROTECTED] Oak Creek, WI, USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Frohne INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 on Fedora
Thanks to all who replied. I thought I had installed compat-libstdc++-7.3-2.96.118, but I missed it and it didn't trigger right away in my brain when the error popped out :) Thanks, Joe -- Joe Frohne Rawson Oaks Consulting, Remote Oracle Admins http://www.rawsonoaks.com [EMAIL PROTECTED] or [EMAIL PROTECTED] Oak Creek, WI, USA I haven't tried with Fedora and I don't intend until core 2 is out, but what you need is standard C++ rel 6.1. On RH-9, the required RPM is compat-libstdc++-7.3-2.96.118 On 12/03/2003 11:34:24 AM, Joe Frohne wrote: Hi, I am running into a problem installing Oracle 9i on Fedora. I get the following error when starting the Oracle installer. error while loading shared libraries: libstdc++-libc6.1-1.so.2: cannot open shared object file: No such file or directory I figured I would ask if anybody has worked through a solution before I start pounding away on the same wheel. Thanks much, -- Joe Frohne Rawson Oaks Consulting, Remote Oracle Admins http://www.rawsonoaks.com [EMAIL PROTECTED] or [EMAIL PROTECTED] Oak Creek, WI, USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Frohne INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Joe Frohne Rawson Oaks Consulting, Remote Oracle Admins http://www.rawsonoaks.com [EMAIL PROTECTED] or [EMAIL PROTECTED] Oak Creek, WI, USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Frohne INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
ORACLE JOINS CERN OPENLAB TO ADVANCE GRID COMPUTING
http://www.interactions.org/cms/?pid=1008211 Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 websites
Hi Jonathan, I bought a new PC sometime back similar to you, xp norton firewall and virus and i had a problem with norton to start with. I found the solution was the built in windows firewall was also turned on. You can check this in the start-control panel-network connections-right click on isp connection-advanced tab == you will see the internet connection firewall. In my case it was on, turning it off fixed it and allowed norton to function correctly. Worth a check kind regards Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: decrease initial extent
Yechiel, I thought that the mantra of oracle sales people was disks are cheap, which i very correct, especially when they don't pay for the disks from their own pockets. What is measly 130M today? My son stores music in GB, not MB. Surely, you company can afford an iPod sized disk? On 12/03/2003 02:39:24 PM, Yechiel Adar wrote: Thank you. OK. Another 130MB down the drain. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 03, 2003 8:49 PM You can move it after you convert the long field to LOB. As it is one of the system tables which appears in noexp$, it's not guaranteed that your database will work afterward. OK, let me restate it: it's guaranteed that it will not work. Other then that, it's only exp/imp of the full database, and after editing sql.bsq (not for fainthearted) On 12/03/2003 01:09:28 PM, Yechiel Adar wrote: Is there any way to decrease the initial extent allocated to a table. It is one of the system tables, so I do not want to drop and recreate it. I can not export/import as it appear in noexp$. It has long field so I can not do alter table move. Yechiel Adar Mehish -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to
Re: ORACLE JOINS CERN OPENLAB TO ADVANCE GRID COMPUTING
are you using a grid at stanford? how much data do they have at CERN? From: MacGregor, Ian A. [EMAIL PROTECTED] Date: 2003/12/03 Wed PM 02:49:32 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: ORACLE JOINS CERN OPENLAB TO ADVANCE GRID COMPUTING http://www.interactions.org/cms/?pid=1008211 Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: decrease initial extent
Title: RE: decrease initial extent alter table tbl_name deallocate unused keep 1; Alex. -Original Message- From: Yechiel Adar [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 03, 2003 10:09 AM To: Multiple recipients of list ORACLE-L Subject: decrease initial extent Is there any way to decrease the initial extent allocated to a table. It is one of the system tables, so I do not want to drop and recreate it. I can not export/import as it appear in noexp$. It has long field so I can not do alter table move. Yechiel Adar Mehish -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
_index_join_enabled in 9i
Title: _index_join_enabled in 9i We have discovered an... opportunity... and Oracle's suggestion is to set _index_join_enabled = false Anyone seen any detrimental effects of setting this parameter to false in 9.2.0.#? April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas /\ / \ / \ \ / \/ \ \ \ \ Few people really enjoy the simple pleasure of flying a kite Adam Wells age 11 The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies. Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment.
Re: Add/Drop partition and CBO statistics
I've got a perfect application for partitioning by date. Each month is a new batch of data and everything is set for the last date of the month. But they asked me today, if we drop a partition of old data, and then add a new partition for the next month, load it, what needs analyzed? Is it enough to simply analyze the new partition? -- 13308 Thornridge Ct Midlothian, VA 23112 804-744-1545 Reply in lines. Zhu Chao - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 03, 2003 7:29 PM Agreed that scanning one big index is faster than many partitions. Then raises the questions - I thought partitioning is for: 1) ease of archiving/dropping off old partitions - drop old and create new partitions in a sliding window. A single large global index negates a lot of this ease - even though it is true that deletes on non-partitioned tables would be even more inconvenient. Yes, that is why we use local index.not Global indexes. 2) efficiencies in partition pruning for queries. If you are querying whole table - why bother with partitioning? The point then becomes you don't need to partition in the first place, or your partitioning scheme is not appropriate? Sometimes it is constrained by complex real applications. A table has tens of columns and you can only partition by one key(or several columns), and to use partition elimination, the SQL must contains the partition key. So only these limited SQL can use partition pruning. While in complex real life application, there will always SQL with different where clause that do not use the partition key at all. The other constraint is business logic.We should partition according to product online time, but we have ten tables to archive and only one table(products) has that key, all other tables do not have that column. Adding such a column to other tables need considrable application rewrite and is denied. So we use product_id(the primary key of most tables) as the partition key. When partitioning key is not a part of the index and you are querying whole table, then it is faster to scan one big index than many smaller ones. The difference is something like log rows to partcount*log (rows/partcount). BTW, local indexes are the only way to go -- I've never understood the point of global indexes on partitioned tables -- maybe someone else can? Global indexes are faster than local index, so if you have schedule down time and need better performance, go to global index. OLTP is more suitable for GLobal index, tomas kyte said in his expert one on one. Regards Zhu Chao. Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Binley Lim INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: zhu chao INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: select via dblink does not use index
What are the Oracle versions, settings for optimizer_mode and full execution plans. Can you clarify Remote table is a view with dblink. Do you mean your query references a local view which is a select from a remote table; or does your query reference a view at a remote site which is a simple select from a table at that site. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk The educated person is not the person who can answer the questions, but the person who can question the answers -- T. Schick Jr One-day tutorials: http://www.jlcomp.demon.co.uk/tutorial.html Three-day seminar: see http://www.jlcomp.demon.co.uk/seminar.html UK___November 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] Sent: Wednesday, December 03, 2003 7:49 PM I did a select like: select name from local_table , remote_table where local_table.account = remote_table.account. Remote table is a view with dblink. I select about 100 records out of about 1M records at the remote db. I found out that oracle does full table scan at the remote site. I will welcome ideas how to make oracle use the index on the remote side. Yechiel Adar Mehish -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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_stats
Yes -- same platform and version. If you look on the list archives
(fatcity.com, for example) for a subject of Burned by DBMS_STATS **AGAIN**
back in April 2003, you may get some insight.
There are also known bugs in GATHER_SCHEMA_STATS in 8i. The recommendation
is to iteratively call GATHER_TABLE_STATS.
GL!
Rich
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA
-Original Message-
Sent: Wednesday, December 03, 2003 3:04 PM
To: Multiple recipients of list ORACLE-L
Hello,
Oracle 8.1.7.4 on HP-UX 11i
A week ago, we replaced 'analyze table ... estimate statistics sample 10
percent' with dbms_stats.gather_schema_stats('x', estimate_percent=10,
cascade=true, degree=4, method_opt=''for all indexed columns size 2')
Performace is good against partitioned tables but not for non-partitioned
tables.
Saw a note in Metalink that its better to do the above with 'cascade=false'
and then do a gather_index_stats separately.
In my tests, I see that 'analyze' makes the CBO use an index while
dbms_stats is making the CBO to use a FTS instead.
Have you faced any similar issues?
TIA
Prakash
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jesse, Rich
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or 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 websites
Did your wonderful XP box download patches from MS Support for you without telling? Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- Sent: Wednesday, December 03, 2003 3:00 PM To: Multiple recipients of list ORACLE-L Thanks to all for their suggestions - but it all started working for no apparent reason (HONEST - I didn't change a thing, reboot, restart the instance, make a cup of coffee, or sacrifice a black cockerel. At 9:23 pm it wasn't working, and 10:25 pm it was !) Don't you hate it when you don't know why it IS working. Regards Jonathan Lewis -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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_stats
I think there are various little (hah!) details that
change with versions, but unless your analyze
command was:
analyze table T estimate statistics sample 10 percent
for table
for indexes
for all indexed columns size 2
;
(I may have the sample clause in the wrong place).
then the two commands will be generating different
things. The default for analyze columns is 'size' 75,
which gives Oracle much better precision on range
scans with literal values than 'size 2' - which may be
a significant part of your problem.
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
The educated person is not the person
who can answer the questions, but the
person who can question the answers -- T. Schick Jr
One-day tutorials:
http://www.jlcomp.demon.co.uk/tutorial.html
Three-day seminar:
see http://www.jlcomp.demon.co.uk/seminar.html
UK___November
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]
Sent: Wednesday, December 03, 2003 9:04 PM
Hello,
Oracle 8.1.7.4 on HP-UX 11i
A week ago, we replaced 'analyze table ... estimate statistics sample 10
percent' with dbms_stats.gather_schema_stats('x', estimate_percent=10,
cascade=true, degree=4, method_opt=''for all indexed columns size 2')
Performace is good against partitioned tables but not for non-partitioned
tables.
Saw a note in Metalink that its better to do the above with 'cascade=false'
and then do a gather_index_stats separately.
In my tests, I see that 'analyze' makes the CBO use an index while
dbms_stats is making the CBO to use a FTS instead.
Have you faced any similar issues?
TIA
Prakash
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jonathan Lewis
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: decrease initial extent
Title: RE: decrease initial extent Since I agreed with Mladen that it wouldn't work, I just had to test this. On 8.1.7.3 on OpenVMS the "deallocate unused keep #" shrinks the initial extent. It shrank a test table from 1m to 8k. I'm not sure why it chose 8k. (db_block_size=4k,default initial_extent for the tablespace=64k) I assume it would work on SYS tables as well. (No sacrificial database that I'm willing to try it on.) Nelson -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Wednesday, December 03, 2003 4:09 PMTo: Multiple recipients of list ORACLE-LSubject: RE: decrease initial extent If you use "keep int" it will. Alex. -Original Message- From: Mladen Gogala [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 03, 2003 12:59 PM To: Multiple recipients of list ORACLE-L Subject: Re: decrease initial extent That will not do anything for the initial extent. You may try with alter table table pray intensely for the desired change; On 12/03/2003 03:34:25 PM, [EMAIL PROTECTED] wrote: alter table tbl_name deallocate unused keep 1; Alex. -Original Message- Sent: Wednesday, December 03, 2003 10:09 AM To: Multiple recipients of list ORACLE-LIs there any way to decrease the initial extent allocated to a table. It is one of the system tables, so I do not want to drop and recreate it. I can not export/import as it appear in noexp$. It has long field so I can not do alter table move. Yechiel Adar Mehish -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
UKOUG get together
In the same spirit that the list organizes a gathering at Openworld, we are planning a get together Sunday evening December 7th, at Jurys Inn, meeting around 7 or 7:30PM. Those list members who are attending UKOUG are more than welcome to join us. We are NOT organizing anything other than the gathering, once everyone is there people can decide what they want to do next. But it's a convenient spot (as many attendees will be staying there) and a sure way to set up a meet. And I'm sure the hotel staff will hate me afterwards but what the heck :) If you're interested, just show up. Listen for the American accents and you'll be sure to find me. Rachel __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: decrease initial extent
For tables/indexes, the minimum initial extent size is 2 blocks (8k = 2* 4k). Block 0 contains the segment header, block 1 contains the data/index entries. Daniel Fink [EMAIL PROTECTED] wrote: Since I agreed with Mladen that it wouldn't work, I just had to test this.On 8.1.7.3 on OpenVMS the "deallocate unused keep # " shrinks the initial extent.It shrank a test table from 1m to 8k. I'm not sure why it chose 8k.(db_block_size=4k, default initial_extentfor the tablespace=64k)I assume it would work on SYS tables as well.(No sacrificial database that I'm willing to try it on.)Nelson
Re: ORACLE JOINS CERN OPENLAB TO ADVANCE GRID COMPUTING
what is an LHC? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 03, 2003 3:44 PM CERN estimates growth about 5-10 petabytes per year when they start their LHC in 2007... Data load rates vary up to 1,5GB per second. I would work there even for free for some time ;) Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 03, 2003 10:09 PM are you using a grid at stanford? how much data do they have at CERN? From: MacGregor, Ian A. [EMAIL PROTECTED] Date: 2003/12/03 Wed PM 02:49:32 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: ORACLE JOINS CERN OPENLAB TO ADVANCE GRID COMPUTING http://www.interactions.org/cms/?pid=1008211 Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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_stats
Title: RE: analyze after truncate
Hello,
Oracle
8.1.7.4 on HP-UX 11i
A week
ago, we replaced 'analyze table ... estimate statistics sample 10 percent' with
dbms_stats.gather_schema_stats('x', estimate_percent=10, cascade=true,
degree=4, method_opt=''for all indexed columns size
2')
Performace is good against partitioned tables but not for non-partitioned
tables.
Saw a
note in Metalink that its better to do the above with 'cascade=false' and
then do a gather_index_stats separately.
In my
tests, I see that 'analyze' makes the CBO use an index while dbms_stats is
making the CBO to use a FTS instead.
Have
you faced any similar issues?
TIA
Prakash
Re: Unix scripts on Windows 2000 after installing MKS tool kit
Carel,
Thank you very much for your response and advise. I have started testing
with little problem so far...
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Wed, 03 Dec 2003 00:59:26 -0800
Hi
Has anybody experience with using unix scripts on Windows 2000 after
installing MKS toolkit?
Are those scripts run without major modification (after changing
path/folder
related info).
My client wants to run their unix shell scripts on their Windows
platform
after installing MKS toolkit version 8.6.
Regards
Rafiq
Hi,
Last week I installed my dataguard scripts with a customer using MKS. I
developed them on Linux and Solaris. No serious problems, except with
dynamic generation of pathnames from database views (replace '\' by '/')
and some colon-related problems when using rcp/scp (e.g.
rcp ${SHOST}:D:\ORACLE\ORADATA\SID\SYSTEM01.ORA \
${DHOST}:D:\ORACLE\ORADATA\SID\SYSTEM01.ORA )
doesn't work. replace D: by D= (and replace backslashes, of course), and
all's fine.
I got ssh to work, although setting passwordless authentication didn't
work. Because the customer has a closed environment, rsh/rcp was
sufficient. Be aware that NTFS is needed to set protection for .rhosts and
rsa/dsa private key files.
Success, Carel-Jan
-- There will allways be another last 10 bugs --
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Carel-Jan Engel
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
_
Get holiday tips for festive fun.
http://special.msn.com/network/happyholidays.armx
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: M Rafiq
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or 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 JOINS CERN OPENLAB TO ADVANCE GRID COMPUTING
If you read the full text of the article pointed to by the URL in the original posting, you learn that 'LHC' is 'Large Hadron Collider', whatever that is. ;-) Mark J. Bobak Oracle DBA ProQuest Company Ann Arbor, MI Imagination was given to man to compensate him for what he is not, and a sense of humor was provided to console him for what he is. --Unknown -Original Message- Sent: Wednesday, December 03, 2003 4:55 PM To: Multiple recipients of list ORACLE-L what is an LHC? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 03, 2003 3:44 PM CERN estimates growth about 5-10 petabytes per year when they start their LHC in 2007... Data load rates vary up to 1,5GB per second. I would work there even for free for some time ;) Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 03, 2003 10:09 PM are you using a grid at stanford? how much data do they have at CERN? From: MacGregor, Ian A. [EMAIL PROTECTED] Date: 2003/12/03 Wed PM 02:49:32 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: ORACLE JOINS CERN OPENLAB TO ADVANCE GRID COMPUTING http://www.interactions.org/cms/?pid=1008211 Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bobak, Mark INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: partitioning option licensing
-Original Message- Sent: Thursday, 4 December 2003 01:25 To: Multiple recipients of list ORACLE-L As of 9iR2, partitioning is still licensed separately as a $10K (retail) extra charge per processor. So, the total retail comes to a painful $50K per processor for 9i + Partitioning. Also, remember that support costs X% of the licensing per year, depending on your support level. You'll have to confirm the exact numbers with your sales rep. You can estimate about 22%, as I recall. We just increased our licensing a few months ago. Get the fastest processors you can. Anyone know how 10g will be licensed? --- Yep, absolutely no change in licensing for 10g - this from the 10g roadshow that just went through town. So you'll be able to visualise and provision yourself all the way to bankruptcy :-) Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 websites
Thanks for that Patrice, i will watch out for it. kind regards Pete In article [EMAIL PROTECTED], Boivin, Patrice J [EMAIL PROTECTED] writes Not sure, but when you patch XP, keep an eye out for this in 2004 -- I heard a rumour that the next Service Pack for XP may turn the XP firewall back on. Patrice. -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 JOINS CERN OPENLAB TO ADVANCE GRID COMPUTING
Oracle was by no means ready to support a database as large as Babar's. When the experiment began, the biggest Oracle databases were around one terabyte. There was also the RD45 project at CERN which weighed heavily on the decision. If we were to do it now, we would probably use Oracle. I know that at least one major telecomunications company uses or use to use objectivity to hold switch information. Ian -Original Message- Sent: Wednesday, December 03, 2003 2:59 PM To: Multiple recipients of list ORACLE-L how many people are using objectivity? seems like object oriented databases are only used in academia? i went to the website and didnt see much documentation. why did you go with that over oracle? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 03, 2003 5:34 PM We currently hist the world's largest database. http://www.slac.stanford.edu/BFROOT/www/Public/Computing/Databases/index.sht ml But LHC will be larger. This experiment preceded the idea of the grid. No doubt, some of the work we have done to share the data among collaborators will be used in grid computing. We also use components which are designed for grid computing. So I gues the answer to your question is yes, in part. Ian -Original Message- Sent: Wednesday, December 03, 2003 12:10 PM To: Multiple recipients of list ORACLE-L are you using a grid at stanford? how much data do they have at CERN? From: MacGregor, Ian A. [EMAIL PROTECTED] Date: 2003/12/03 Wed PM 02:49:32 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: ORACLE JOINS CERN OPENLAB TO ADVANCE GRID COMPUTING http://www.interactions.org/cms/?pid=1008211 Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a
Oracle and JMeter configuration
Hello all, I'm trying to set up JMeter version 1.9.1, http://jakarta.apache.org/jmeter/index.html for some testing on an Oracle 8.1.7.4 database on Solaris 2.8. We're running JDK 1.3, which according to the JMeter website should work with JMeter 1.9. I've unpacked JMeter and copied the Oracle JDBC driver files classes12.zip and nls_charset12.zip into JMeter's lib directory. However, when I try to run a test case the connection fails with the log error of jmeter.protocol.jdbc: java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver The JMeter JDBC URL settings that I am using are: jdbc:oracle:thin:@servername:1521:ORACLE_SID (I've also tried using the IP address) The JMeter Driver Class setting is: oracle.jdbc.driver.OracleDriver Has anyone out there set up JMeter to run against an Oracle database? If so, could you share your setup with me? From what I've read in the JMeter archives, it has been done, but it seems that no one has detailed exactly what needs to be done. Thanks, Lou Avrami -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Louis Avrami INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 JOINS CERN OPENLAB TO ADVANCE GRID COMPUTING
which telecom company? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 03, 2003 6:39 PM Oracle was by no means ready to support a database as large as Babar's. When the experiment began, the biggest Oracle databases were around one terabyte. There was also the RD45 project at CERN which weighed heavily on the decision. If we were to do it now, we would probably use Oracle. I know that at least one major telecomunications company uses or use to use objectivity to hold switch information. Ian -Original Message- Sent: Wednesday, December 03, 2003 2:59 PM To: Multiple recipients of list ORACLE-L how many people are using objectivity? seems like object oriented databases are only used in academia? i went to the website and didnt see much documentation. why did you go with that over oracle? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 03, 2003 5:34 PM We currently hist the world's largest database. http://www.slac.stanford.edu/BFROOT/www/Public/Computing/Databases/index.sht ml But LHC will be larger. This experiment preceded the idea of the grid. No doubt, some of the work we have done to share the data among collaborators will be used in grid computing. We also use components which are designed for grid computing. So I gues the answer to your question is yes, in part. Ian -Original Message- Sent: Wednesday, December 03, 2003 12:10 PM To: Multiple recipients of list ORACLE-L are you using a grid at stanford? how much data do they have at CERN? From: MacGregor, Ian A. [EMAIL PROTECTED] Date: 2003/12/03 Wed PM 02:49:32 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: ORACLE JOINS CERN OPENLAB TO ADVANCE GRID COMPUTING http://www.interactions.org/cms/?pid=1008211 Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting
RE: dbms_stats
Rich, I went thru the archives. Are you using the option 'cascade=true' for
gather_table_stats?
-Original Message-
Jesse, Rich
Sent: Wednesday, December 03, 2003 4:21 PM
To: Multiple recipients of list ORACLE-L
Yes -- same platform and version. If you look on the list archives
(fatcity.com, for example) for a subject of Burned by DBMS_STATS **AGAIN**
back in April 2003, you may get some insight.
There are also known bugs in GATHER_SCHEMA_STATS in 8i. The recommendation
is to iteratively call GATHER_TABLE_STATS.
GL!
Rich
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA
-Original Message-
Sent: Wednesday, December 03, 2003 3:04 PM
To: Multiple recipients of list ORACLE-L
Hello,
Oracle 8.1.7.4 on HP-UX 11i
A week ago, we replaced 'analyze table ... estimate statistics sample 10
percent' with dbms_stats.gather_schema_stats('x', estimate_percent=10,
cascade=true, degree=4, method_opt=''for all indexed columns size 2')
Performace is good against partitioned tables but not for non-partitioned
tables.
Saw a note in Metalink that its better to do the above with 'cascade=false'
and then do a gather_index_stats separately.
In my tests, I see that 'analyze' makes the CBO use an index while
dbms_stats is making the CBO to use a FTS instead.
Have you faced any similar issues?
TIA
Prakash
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jesse, Rich
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Bala, Prakash
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Odd relink problem on Redhat 3.0
I recently installed Oracle 9iR2 9.2.0.1 on Redhat Enterprise 3.0, install went fine. After installing I did a relink of oracle - no problems except standards (OEM and CTX). After applying 9.2.0.4 I am now getting the following error messages from relink: [EMAIL PROTECTED] bin]$ relink all /u02/oracle/product/9.2.0/bin/relink: line 52: [: too many arguments /u02/oracle/product/9.2.0/bin/relink: line 192: unexpected EOF while looking for matching ``' /u02/oracle/product/9.2.0/bin/relink: line 268: syntax error: unexpected end of file Any ideas? Mike -- Mike Bates - 9i OCP Fairbanks, AK PGP Key: http://pgp.mit.edu/ ID 0x528393FA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mike Bates INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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_support on 8i
test - Original Message - From: Yechiel Adar To: Multiple recipients of list ORACLE-L Sent: Wednesday, December 03, 2003 5:59 PM Subject: Re: dbms_support on 8i I checked for 8.1.6.3.4 and 8.1.7.0 on windows. Not there. Yechiel AdarMehish - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Wednesday, December 03, 2003 12:19 AM Subject: dbms_support on 8i Does anyone know which patch level of 8i includes the dbmssupp.sql and .plb files? I have databases here that are at 8.1.7.4, but the files are not there. 9i has them, but none of the 8i databases. Thanks, Jared PS. Metalink was no help for this. Neither was google.
RE: Oracle and JMeter configuration
What's your CLASSPATH? It seems that the classes12.zip isn't on your CLASSPATH. -Original Message- From: Louis Avrami [mailto:[EMAIL PROTECTED] Sent: Wed 12/3/2003 7:44 PM To: Multiple recipients of list ORACLE-L Cc: Subject:Oracle and JMeter configuration Hello all, I'm trying to set up JMeter version 1.9.1, http://jakarta.apache.org/jmeter/index.html for some testing on an Oracle 8.1.7.4 database on Solaris 2.8. We're running JDK 1.3, which according to the JMeter website should work with JMeter 1.9. I've unpacked JMeter and copied the Oracle JDBC driver files classes12.zip and nls_charset12.zip into JMeter's lib directory. However, when I try to run a test case the connection fails with the log error of jmeter.protocol.jdbc: java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver The JMeter JDBC URL settings that I am using are: jdbc:oracle:thin:@servername:1521:ORACLE_SID (I've also tried using the IP address) The JMeter Driver Class setting is: oracle.jdbc.driver.OracleDriver Has anyone out there set up JMeter to run against an Oracle database? If so, could you share your setup with me? From what I've read in the JMeter archives, it has been done, but it seems that no one has detailed exactly what needs to be done. Thanks, Lou Avrami -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Louis Avrami INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 JOINS CERN OPENLAB TO ADVANCE GRID COMPUTING
I think one of the pluses of Objectivity was also the ability to cluster it over lots of small/cheap computers (even without sharing the storage..) Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, December 04, 2003 1:39 AM Oracle was by no means ready to support a database as large as Babar's. When the experiment began, the biggest Oracle databases were around one terabyte. There was also the RD45 project at CERN which weighed heavily on the decision. If we were to do it now, we would probably use Oracle. I know that at least one major telecomunications company uses or use to use objectivity to hold switch information. Ian -Original Message- Sent: Wednesday, December 03, 2003 2:59 PM To: Multiple recipients of list ORACLE-L how many people are using objectivity? seems like object oriented databases are only used in academia? i went to the website and didnt see much documentation. why did you go with that over oracle? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 03, 2003 5:34 PM We currently hist the world's largest database. http://www.slac.stanford.edu/BFROOT/www/Public/Computing/Databases/index.sht ml But LHC will be larger. This experiment preceded the idea of the grid. No doubt, some of the work we have done to share the data among collaborators will be used in grid computing. We also use components which are designed for grid computing. So I gues the answer to your question is yes, in part. Ian -Original Message- Sent: Wednesday, December 03, 2003 12:10 PM To: Multiple recipients of list ORACLE-L are you using a grid at stanford? how much data do they have at CERN? From: MacGregor, Ian A. [EMAIL PROTECTED] Date: 2003/12/03 Wed PM 02:49:32 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: ORACLE JOINS CERN OPENLAB TO ADVANCE GRID COMPUTING http://www.interactions.org/cms/?pid=1008211 Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: MacGregor, Ian A. INET: [EMAIL
RE: dbms_stats
Maybe I didn't make my point clear enough. If you use dbms_stats.gather_table_stats with method_opt=''for all indexed columns size 2' , i.e. any other than size 1, dbms_stats in Oracle 8i will issue an analyze ... command to gather the statistics. Run a sql_trace if you don't believe me. Therefore the results of gathering statistics with dbms_stats are no different than gathering them with the equivalent analyze command. It is different if you use the default method_opt (for all columns size 1). Then gather_table_stats uses its own sql to collect table and column ( num_distinct, min, max, null, avg_col_length) statistics. For index statistics always resorts to the analyze command. That all changes in Oracle 9i. There the gather procedures do their own work and do not use analyze anymore. How did you determine the bucket size of 2? And no, I have not had any issues with analyze for partitioned tables; however, I do not gather histograms blindly on all indexed columns. Only on a few columns with highly skewed data content and some of them are on partitioned tabled. At 09:29 PM 12/3/2003, you wrote: The reason why we switched from 'analyze table .. 10 percent' is because when we partitioned some of the huge tables, the query performance against these tables was really bad. 'Gather_table_stats' with size 2 on indexed columns did a much better job. Have you had issues with 'analyze' against partitioned tables? -Original Message- Wolfgang Breitling Sent: Wednesday, December 03, 2003 5:29 PM To: Multiple recipients of list ORACLE-L In Oracle 8i you may as well stick with analyze since the dbms_stats call you use translates simply into a analyze table ... ESTIMATE statistics sample 10 percent FOR TABLE FOR ALL INDEXES for all indexed columns size 2 Why did you go from a simple analyze to gathering histograms on all indexed columns? I question the rationale of gathering histograms of size 2. Aside from that, I question the rationale of a blanket histogram gathering (regardless of # of buckets) on all indexed or all columns. Histograms are like medicine. In the right (i.e. sparing dose) they are a therapeutic tool. In the wrong, especially too high dose, they become poison. Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
