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
This is a 9.2.0.4/Linux bug. Check out Metalink Doc ID 474525.996 for the
specifics.
Sten
-Original Message-
Sent: Wednesday, December 03, 2003 8:39 PM
To: Multiple recipients of list ORACLE-L
I recently installed Oracle 9iR2 9.2.0.1 on Redhat Enterprise 3.0, install
went fine. After
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
> Ora
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
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
--
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
/u
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 p
This is really getting OT, and there have been quite a few mergers, but they were once
called something like Northern Telephone and are based some where in Canada.
Ian
-Original Message-
Sent: Wednesday, December 03, 2003 7:29 PM
To: Multiple recipients of list ORACLE-L
which telecom c
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
(fatci
Folks,
Is there a way to change the authid setting of a package via a simple
procedure, e.g.,
alter package x authid current_user;
I believe this is a compile-time setting, part of the source of the
package (user_source, dbms_metadata output), which leads me to believe
there's no simp
Hi all,
I would like to hear, if you have any experience concering Etagon...
Short review:
Etagon is an Israeli company and their product is Data Center Automation SW focussing initially on Oracle 9i RAC clustering SW. Etagon claims that their SW can produce fundamental savings in 9i RAC inst
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 aro
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 Orac
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 Orac
Yechiel Adar wrote:
>
> 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 ful
If anyone is using Oracle collaboration suite, could you tell me what hardware
you recommend and/or are using? We expect around 1000 users and will probably
use the mail,calendar and files.
Specifically, what type of storage/server are you using for the storage
infrastructure?
Thanks,
-Brian
With no APPS experience as a DBA I wonder what archive log mode can do for
you with all these nologging objects. This does effectively mean that a
recovery operation will fail!
I do not know the amount of transactions these objects are involved in, but
you might try (and test thouroughly before
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
We create a Reporting database nightly
from the hot backups of a Production Financials 11.0.3 database.
The Reporting database is on its own server (UNIX). There is
a full Oracle and Applications environment on the Reporting server. What
I do as part of the hot backup script, is copy over the
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
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: Wed
Kader,
Just a word of caution when considering options. Keep an eye on all the Apps objects
that have NOLOGGING set. Last time I checked there were over a thousand of those
which were mostly indexes but there are some tables among them. These are a real pain
when using redo log refreshing/up
-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
We currently hist the world's largest database.
http://www.slac.stanford.edu/BFROOT/www/Public/Computing/Databases/index.shtml
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
g
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 ind
I don't understand. Here is what manual says:
deallocate_unused_clause
Use the deallocate_unused_clause to explicitly deallocate unused space at the end of
the table,
partition or subpartition, overflow data segment, LOB data segment, or LOB index and
make the
space available for other segment
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
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
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')
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.
>
>
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 "
The DBA_VIEWS view does not include the column names in the view.
If you are really diligent, you could probably tear apart a trace file and
learn how oracle is reassembling the view from the DD. A hard parse
on a view can produce 250k of trace file.
It is easier to recreate by generating the dd
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 gat
Agreed -
It's like the case where I had a wonderful (pure SQL)
workaround to a deficiency in partitioned tables in 8.0.5;
and Oracle decided it was a bug, and fixed it in 8.0.6.
How do explain that the database is now running 120
times more slowly because it's working properly ?
Regards
Jo
At 06:24 3-12-03 -0800, you wrote:
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
imp
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, defaul
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
Yes,
40 MB so far. But it is quite subtle about it,
and it only happens in my 'think time' whilst
I'm online.
Be prepared - the OEM 4.0 demo at IOUG
said that OEM would call Oracle for you with
an ORA-00600 trace, get the analysis done,
download the (probable) patch, and install it
for you auto
It disables index hash joins (hashing a scan of two indexes
on a single table to generate a result without visiting the table).
If you are upgrading, you weren't using that path before, so
won't miss it if you switch it off now.
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
The educate
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:
I find almost as bad the situation where you DO find the problem and it
turns out that it should never have worked in the first place.
At 01:59 PM 12/3/2003, you wrote:
Don't you hate it when you don't know
why it IS working.
Regards
Jonathan Lewis
Wolfgang Breitling
Oracle7, 8, 8i, 9i OCP DBA
C
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_T
At 12:59 3-12-03 -0800, you wrote:
Don't you hate it when you don't know
why it IS working.
Jonathan, give in, and sleep well tonight.
Regards, Carel-Jan
Regards, Carel-Jan
-- There will allwasy be another 10 last bugs --
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
Title: RE: decrease initial extent
If you use "keep " 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 any
That will not do anything for the initial extent.
You may try with
alter table pray intensely for the desired change;
On 12/03/2003 03:34:25 PM, [EMAIL PROTECTED] wrote:
> alter table deallocate unused keep 1;
>
> Alex.
>
>
> -Original Message-
> Sent: Wednesday, December 03, 2003
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 kno
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 simpl
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 en
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
Title: RE: decrease initial extent
Just for note, 10g has alter table shrink opportunity
:)
Tanel.
- Original Message -
From:
[EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, December 03, 2003 10:34
PM
Subject: RE: decrease initia
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: Wednes
Title: RE: decrease initial extent
alter table 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 w
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.
-Original Message-
Sent: Wednesday, December 03, 2003 4:04 PM
To: Multiple recipients of list ORACLE-L
Hi Jonathan,
I bough
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://
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/20
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 is
I found something strange when trying to copy a view from one database to
another. I spooled the text from dba_views and ran the CREATE VIEW AS ...
statement. There was an error because one of the fields needed an alias (it was
SUBSTR(xxx)). I went back to the source database and poked around a bit
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 we
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.
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 w
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 [EM
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 [EM
Yes, turning time_statistics off (at the session
level) gets rid of all the times() calls. Further
turning off timed_os_statistics (from 5 to 0) gets rid
of getrusage() as well, leaving only gettimeofday()
calls
Thanks,
Boris Dali.
--- Boris Dali <[EMAIL PROTECTED]> wrote: > Date:
Wed, 03 Dec 20
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
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
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
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: Per
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
On Wed, 3 Dec 2003, 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 direc
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
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
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
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
> t
Shared-everything is even more tightly-coupled than RAC - shared-everything
is communal memory bus, shared I/O channel, etc - many people list SMP as a
shared-everything cluster, though something like a NUMA cluster is more
appropriate. RAC would be defined as a "Shared-something" cluster - there
Try http://www.baarf.com/
-Mark
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
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
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 com
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,
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
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 as
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: Wednesda
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 !
-
> 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,
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 thr
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
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
e
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.
Yechie
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
Thanks Wolfgang,
That's what I was thinking. I figured a "hack" to one of those less than
intuitive c# columns would neatly do the trick so I thought I'd ask if
anyone had done it before I started down that road myself. Request for
Enhancement to Oracle Corp., add a procedure to the dbms_stats pac
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.1JD
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, O
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 PROTEC
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
> -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 o
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, depe
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
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 MANDA
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
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:
>
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 . !!!
1 - 100 of 117 matches
Mail list logo
