 | | | Oracle List | | Hi all
We have the cases when 10g generates execution plans differently than
9i. Stats on tables are the same. Is anyone aware of any
changes/improvements in temporary tables handling by CBO in 10.1List
Have a look at this. Some are a little outdated but this is a good one
http //www.columbia.edu/~rtt2101/iaoq/bigfont.html
Regards
John Kanagaraj < > <
DB Soft Inc
Phone 408-970-7002 (W)
CThanks to Pete Finnigan for the following link
http //www.petefinnigan.com/weblog/archives/00000699.htm
http //www.imperva.com/application_defense_center/papers/oracle-dbms-01172006.html
So much forIs it possible to look at the V$SQL - PLAN_HASH_VALUE
for the 2 SQL sessions?
By using the PLAN_HASH_VALUE in the V$SQL view you can
track when new access paths to data have been used.
--- Paul BaumHi
> 10gR2 RHEL4 OCFS2 DL585 AMD Opteron 64bit
Non-RAC on OCFS2?
>
> Im running a benchmark on the above hardware using hammerora (GPL TPC like
> tool I saw a presention on at UK OUG 2005). AlHi
Check these Note on Metalink.
- Oracle Note 61623.1 Resolving shared pool fragmentation.
- Oracle Note 146599.1 Diagnosing and Resolving Error ORA-04031.
there are way too many thingI am trying to install an Oracle Designer 10.1.2.0.2 repository on a
10.2.0.1 Enterprise database on RHEL
During the process of granting access to the repository user role I
get the referenced erro * README for 4751928 * [image Patch
Details] <https //updates.oracle.com/ARULink/PatchDetails/process_form?aru 8050490&patch_password &no_header 0 >
*Oracle Critical Patch Update January 2006
Rel10gR2 RHEL4 OCFS2 DL585 AMD Opteron 64bit
Im running a benchmark on the above hardware using hammerora (GPL TPC like
tool I saw a presention on at UK OUG 2005). All runs very fast to begin with
look
v$mts
v$circuit
v$shared_server
but anyway if you see v$session.server and there are sessions which says
SHARED then obviously your database supports Shared Server
On 1/17/06 Onkar N Tiwary
Hi I 've heard the ODP with instance client is going to be release
something .
Does anyone know if it already been released ?
IMPORTANT The contents of this email and any attachments are coDo you use bind variables?
On 1/17/06 Chris Marquez <marquezemail@(protected) > wrote
>
> Env
> Oracle 9205
> RHEL3
>
> I have situation (another post on this list) where we have severe spikes
> seSigh.....
Ok I 've got OID and Multi-Master Replication working.
Now I 'm trying to get the Oracle client to use DNS to look up an SRV
record to locate the directory server(s).
With a static ldap.
I 'm no longer current with the "theory " of Disaster Recovery but the
last time I worked near it the main rule seemed to be this
*Full Disaster Recovery must be completed within 96 hours of tOracle 9.2 is not due for end of ECS support until (about) July 2007 --
18 months from now. In fact the actual end date has not even been
announced yet.
I think it 's safe to assume that there willYeah a privileged user can drop the constraint but not accidentally.
A "privileged " user can drop the table too.
The idea here (I would think) is to lock a table for a while for
maintenance or Don 't know about anyone else but I would not schedule
any DB changes during these times.
06-JAN-2006
Updated MetaLink Scheduled Weekend Outages have been moved to January 20
and January 27 2006
NOHi Dimitre
Thanks for your reply.
I am going to try your suggestion but looking at the solution in
Metalink I am
a little confused whether it is going to work for my situation.
the dads.conf linI 'm curious what the expected/real SR reponse time is for the various
severity levels. Is this documented somewhere? What has been you 're
experience? My last few SRs went as reported below where "Rhi all
We have a case when adding column to database table caused sessions
hang. Our oracle is 9205 running on solaris.
1. The same code in test 9205 does not report error but in productioAll
We 're testing User-Managed Backups of the Whole Database. Oracle recomends
to make backups of all datafiles as well as all control files but not online
redo log files.
During our testing we bAny team that can make the candy-asses er I mean Patriots self-destruct is
worthy.
Any team that can make the candy-asses er I mean Patriots self-destruct is worthy. <br > <br >
Anyone encountered issue with FB Enqueue (Format Block?). We had 300
sessions waiting on it had to bounce the instance to clear all the
locks. Using Partitioning/Bulk Inserts/GTT/ASSM. We partitioneWay to go Mark!
(Yes I 'm a little late on this)
On 1/13/06 Bobak Mark <Mark.Bobak@(protected) > wrote
>
> Woo-hoo!
>
> Now I can start my weekend on a high note!
>
> -Mark
>
> PS Thanks to
I don 't remember the Install & Config Guide specifying a minimum
number of inodes for the base installation. It follows then that
subsequent runInstaller and opatch sessions also wouldn 't check inoHi all
I have a data warehousing interview coming up. Can some one please point to
FAQs on Data warehousing?
--
Thanks
Ram.
<div >Hi all </div >
<div > </div >
<div >I have a data warehousing intHi Brain
Have a look into Title Heading
Determine the Upgrade Path to the New Oracle Database 10*g *Release
of chapter 2 in 10g Database Upgrade guide. Direct upgrade paths are clearly
mentioned.
Speculation is free and easy.
If any of us could make accurate predictions we would
be retired and no longer pounding a K/B for a living. )
Jared
On 1/13/06 David <thump@(protected) > wrotBjoern
This should be simple.
The whole idea to "testing " is to ensure that the thing you are
testing will actually work when you do it for real. Would you test an
Oracle 9i - > Oracle 10g I don 't think you can tell from an export. This information is usually
kept in the inventory files.
You could try a hex dump of the first few block.
--
Ron Reidy
Lead DBA
Array BioPharma Inc.
--- |
|
|
