 | | | Oracle List | | Don 't think it is special. It happened to use a couple of times when
migrating livelink 9.1 & 9.5 oracle databases to 10gR2. Sometimes we had to
use "_old_connect_by_enabled " true sometimes we had tI was wondering if anyone has installed 10.2.3 or upgraded to it and found it worth the hassle? I haven 't been able to find a doc that mentions the new features in 10.2.3 OEM.
I am doing a new On 6/25/07 Raj Mareddi <yoursraju007@(protected) > wrote
>
> Well These indexes do exist already. For example there is a column
> called FLAG with values of 'YES ' or 'NO ' and there are 6 Millions of
Ujang
> i 've tried these parameters but don 't help....
> *._gby_hash_aggregation_enabled FALSE
> *._old_connect_by_enabled TRUE
> *._optimizer_cost_based_transformation OFF
>
> but when combined tho2007/6/24 Ujang Jaenudin <ujang.jaenudin@(protected) >
> I usually monitor the progress of long running SQL on that view.
> when set OFE to 9.2.0 or higher i can still monitor through that view.
> butI 've used the stored outline swapping trick (metalink 92202.1) with
great success several times in the past but I 'm having trouble getting
it to work in 10g so I 'm hoping one of you have already encoIs this an ASM managed instance?
--
Ron Reidy
Lead DBA
-----Original Message-----
From oracle-l-bounce@(protected)
[mailto oracle-l-bounce@(protected)] On Behalf Of Harvinder Singh
Sent FridReseved shared pool memory is physically a part of normal shared pool
memory. Oracle spreads the reserved pool evenly across all shared pool
memory extents that way the reserved pool can grow-shrink
Folks
Need STEPs to Setup a 2-Node ASM RAC from Scratch on Solaris 10.
Need to use the RAID Volume provided by the Storage Box (External).
Any Links pointers Docs will help.
(Requisite Hardware ?
Dear List
I am confused about high and low scn.What are they and how are they used?
In addition to this when we refer SCN MinValue and SCN Maxvalue in Flashback Verions Query do they have any liHi Ray
> I understand how dynamic sampling would assist in the
> scenario described in Level 4 but can someone help me
> understand "all tables for which standard selectivity
> estimation used a gueBecome Oracle Apps DBA Independent Oracle Applications DBA
Consultant <http //becomeappsdba.blogspot.com/2007/02/independent-oracle-applications-dba.html >
This site has a fairly structured approach tRequires US Citizenship.
The work site is Washington DC.
Development DBA - You 'll be working with an agile java development team.
Oracle 9i soon to migrate to 10g. Production environment is AIX
Anyone else seeing some strange behaviors with the new Metalink Draft SR?
Whenever we create one and then finally publish it we get a tag-along SR
with bogus data in all the fields. For instance
ProI 've never tried it or even read anything about it but I just searched
the hidden parameters for "monitor " and came up with this one
_dml_monitoring_enabled
Its description is "enable modificatFuad
I my failing memory is to be believed I think that 9.0 was the
first Oracle version when a ' ' (or / in first position) was required
with SQL*Plus after COMMIT or ROLLBACK. In other wordHello
I nedd any paper (document link whatever) with inormation about
snapshotlogs load or triggers load on Oracle database. Of course your
experience and practice is also very usefull.
Can yoI think what causes the redo is this
"Suppose the ITL is still open and the transaction is not yet committed
A reader on finding the ITL will create a consistent read copy of the
block because a vThanks Kyle. I know you advocated Direct SGA access for the same data
but this is different correct?
I have the issue of having to manage older 8i/9i databases so I
adapted 10g 's ASH and Metrics idFirst I would like to thank the folks that offered suggestions on this
problem and I 'd like to give back something here in terms of what I
learned. Part of this was from some excruciating trace fiHi Group
If anybody is running into problems with installing the infrastructure part
of OAS 10g R2 (10.1.2.0) on SuSe Linux 10.1 more specifically with the
'oca ' and an error regarding libnsl.so.1 But make sure you are licensed to use this stuff.
On 6/20/07 kyl elf <kylelf@(protected) > wrote
>
> On 10.2 you could get a lot more info by running
> @?/rdbms/admin/ashrpt.sql
--
BesCompany in the Boulder Colorado area needs an Oracle DBA to join it 's staff.
The Oracle Database Administrator will be responsible for the
maintenance monitoring and tuning of all Oracle database I have been using the External Password Store in 10.2.
I havent tried it out with multiple unix user accounts only the oracle
account but by using different services in our databases I connect as a
diHi Everyone
I 'm upgrading from 9.2.0.8 to 10.2.0.3 on HP-UX 11.11 and I have a
question. The patch notes for 10.2.0.3 contain the following text
7.1.2 Upgrading a Release 9.2 Database Not Using OrWe are currently using Oracle Text to index our full-text documents and
the metadata for those documents. We are finding that this may not be
the solution because of the problems that we are having mHello to you all
I 've a mobile application that uses Oracle Lite 10g (10.2.0.2) as mobile
server and Oracle Database Server 10g release 1 (10.1.0.2) as the repository
database. Both of these componenAt 01 05 AM 6/20/2007 FreeLists Mailing List Manager wrote
>The problem
>A partition of FOO is bulk loaded around 10 times a month. The
>partition is created a few days before it will first be loaToon
Thanks for the update. But I have refined my test and I think the
problems I am seeing have something to do with TDE. The mothraids table
is the local database with TDE enabled and the ssn coluHello Don
Two thoughts that comes immediately into my mind
1. Dynamic Sampling
> The partition is created a few days before it will first be loaded into.
.
> After I gather stats on the table (ta |
|
|
