 | | | Oracle List | | OVERVIEW
In recent attempts to correlate 10046 extended trace data from Oracle 10.2
with DTrace data collected under Sun Solaris I discovered that the tim
ela and e fields in Oracle trace data areI have discovered while performance tuning that the DBC can take a
significant percentage of the DB server 's CPU - up to 30%. I do not think
it is ever advisable to keep the DBC up and running all Boy do I feel ignorant when it comes to OCI. I am trying to get some timing
data out of oci to compare times at the oci layer to times spent at the
databae (10046) to times measured in our applicatioFolks
Does anyone know how Oracle computes value for the p3 parameter during
direct path reads? It seems that this is not directly governed by the
MRBC setting because in my raw trace file with MRBCHas anyone used SRDF instead of dataguard to manage a failover site? Anyone have any opinions of it?
<html > <body >
<DIV >Has anyone used SRDF instead of dataguard to manage a failover site? Anyone haveFor those who didn?t know it
select to_char(256 'XXX ') from dual
-----
100
Fyrirvari/Disclaimer
http //www.landsbanki.is/disclaimer
--
http //www.freelists.org/webpage/oracle-l
Which database version ?
Stefan
On 3/30/07 edwin devadanam <edwin_kodamala@(protected) > wrote
>
> Hi
>
> Does anyone know how to call unix scripts from oracle database?
> Is it possible........or aHi all
Does anyone know what is the character to be used for break line
when showing message in CUSTOM.pll using FND_MESSAGE.SET_NAME.
<div >Hi all </div >
<div > </div >
<div > &nOn 04/01/2007 09 35 50 PM Jared Still wrote
> On 3/29/07 Ujang Jaenudin <ujang.jaenudin@(protected) > wrote
> >
> > dear all
> >
> > i have read jk still article about locking
> > http //www.jlcompBill
It is possible your Ocr device has been overwritten/wiped out. You can
do a strings on ocr device or run ocrcheck/ocrdump (in
$ORA_CRS_HOME/bin) to check sanity.
To locate ocr device
$ locaHi
My collegue and I was discussing today where should we locate Grid Control
repository at.
We have around 40 production databases where only one at the moment runs on
RAC. We have been thinking toI have been asked to implement 10gR2 RAC on Windows 2003 Server. I 'll
appreciate your 2 cents any gotchas whitepapers bugs/patches that I
need to be aware of.
I went to www.microsoft-oracle.com anI spent only a minute looking at this. So I may be wrong on this.
12 need_complete_refresh exception
13 need_complete_refresh CONSTANT INTEGER -12035
need_complete_refresh is first declar
Hi Joel
> > Anyone have any opinion on the book or author for "Forecasting
Oracle
> > Performance " by Craig Shallahamer
There 's some stuff over at apress.com about it but as yet not much. I
suspecI think I found the one you were talking about -
Doc ID Note 412271.1
Subject ORA-600 [22635] and ORA-600 [KOKEIIX1] Reported While
Upgrading Or Patching Databases To 10.2.0.3
Now it occurs
> -----Original Message-----
> From Rodgers Linda B.
> Sent Thursday March 29 2007 7 03 AM
> To 'bspears@(protected) '
> Cc 'oracle-l@(protected) '
> Subject RE OEM justification...you may use unix sed to modify your script 'on the fly ' and execute
within sqlplus...
On 3/29/07 Uwe K?chler <uwe@(protected) > wrote
>
> Hi all
>
> I 've scanned this list and other forums but hi
we are running a 10node rac and we are seeing the following wait event very frequently compeltely stalling the process .
KJC SEND COMPLETION TIMEOUTS is the wait event.
can some What is the path of least resistance to upgrade an existing 10.1.0.3
database to 10.2.0.1?
The dbua blows up and if it was not so close to being utterly pathetic the
result could end up as someDid you set the oracle user 's limits according to the docs ?
You can verify with ulimit -a
Cheers
stefan
On 3/28/07 William Wagman <wjwagman@(protected) > wrote
>
> Greetings
>
> I just upgradedI am getting this error on trying to install 9.2.0.8.0 patchset (from
9.2.0.7.0) on Sun Solaris 8 64 bit
I am getting this error
Error in invoking target 'install ' of makefile
'opt/oracle/u01/proIf the old tablespace was using dictionary management then depending on
the table/index storage parameters in use and the existing free space
fragmentation status of the target tablespace switching toHey Guys
I am doing a RAC install on an x86_64 RH4 box. We are using 10.2.0.1 and
raw devices. The SAN is a MSA 1500. The issue that I am having is during
the Cluster install. The installer is complHas anybody a work-around for statistics values being too large to display
on the AWR report? In statspack you can hack the SQL to change format masks
etc but in AWR the whole report (via awrrpt1.sq
When the master node looses its private network the surviving node
becomes the master reconfiguration of the cluster takes place - the old
master is ejected from the cluster configuration - andUnfortunately we need the patch for windows which is due in 10203 patch 5.
so we need to do shared_pool flushing for another couple of months ourselves
(or ask DBMS_JOB to do it on our behalf)
imaginHello
just found out about a problem (Bug 5648872 Dump (opidsa) from DESCRIBE of
a cursor) that started in 10.2.0.3 and is still not fixed. It can lead to
client sessions crashing with ORA-7445 errHi
There is a need for a SQL that will report if all conc.managers are up and
running. The SQL should gather information about which concurrent managers
are enabled whether the 'Actual ' and 'TargetDavid
I have indeed worked with some developers with skills I greatly respected.
However I think that operations need to be separation from development.
Many organizations are moving to incororate It doesn 't matter. You can actually have more than one VIP (User VIPs).
On 3/27/07 Naqi Mirza <naqimirza@(protected) > wrote
>
> Hi
> I have a 2 node 10gR2 (10.2.0.2) Installation running on HP-UX (P |
|
|
