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

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

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

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

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

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

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

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

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

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

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

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],

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

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

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 . !!!

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 @

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

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

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,

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

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

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]

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,

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

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

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.

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

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

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

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...

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 !

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:

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

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

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,

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

_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

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

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

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

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:

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

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

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

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

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

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')

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

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

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.

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.

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

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

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

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

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

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

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

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

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.