 | | | Oracle List | | Hi Milen
> Are these so called "Hybrid histograms " ?
No. In the documentation they are called extended statistics. And that
because it 's not only matter of providing histogram but all kind of
objecI think the explanation is that the BACKUP command makes a backup piece
which is an rman-proprietary file that can only be read by RMAN. The
COPY command (and the ALTER DATABASE BACKUP CONTROLFILE cThank you for answer.
1. I use "mount -v " checked and file system are mount
as "ocfs2 "
ocfs2_dlmfs on /dlm type ocfs2_dlmfs (rw)
/dev/sdb1 on /ocfs01 type ocfs2
(rw _netdev heartbeat local)
/dev/sdbIn a logical standby database scenario can you pick and choose the
objects that you want to replicate to the standby instance?
We have auditing tables associated to every table in the OLTP
environwe just installed OCFS 1.2.5 version on CENTOS 4.5.
Two ORACLE RAC servers with shared disk in it. I
create partition on shared disk and make it as OCFS
file
system. After that I mount partion on bHi Jeremy
Even in a single instance installation ASM needs to connect to cssd. If that?s not running you?ll get the 29701 when trying to start your ASM instance. From memory this runs fr
It turns out values of 16 and 32 for "v " keep all the bits in the 20 decimal
digit range. Someone please chime in if there is a better way to formulate
this. I 've got this feeling in the back of mySQL > r
1 select
v*(bitand(trunc(10846370260800065548/v 0) trunc(9368617832122679304/v 0))) +
2 bitand(mod (10846370260800065548 v) mod
(9368617832122679304 v)) value
3* from brHi Stefan
I think the bitand is limited to 2**63 - in SQL Developer
select bitand(10846370260800065548 9368617832122679304) from dual
select power(2 63) from dual
- outputs
BITAND(10846370260
I have been able to use ARRAYSIZE in SQLPlus to fetch more rows
at each call and reduce the number of round-trips between the SQLPlus
Client and the database. [see example below]
However this doeLarry
Bug at play is very likely (change of execution plan) but even
though I presume since you return something that you provide (24548)
that this query is assumed to be an existence check?See Metalink Note 317257.1 "Running Oracle Database in Solaris 10 containers
- Best practices "
Stefan
On 7/19/07 rajendra.pande@(protected) <rajendra.pande@(protected) > wrote
>
> Folks
>
>
>
> Could you I think the wording in that has changed significantly from what was there a
couple years ago. I could be wrong but it seems a lot clearer now than it
used to be.
On 7/20/07 Neil Overend <neiloverendI 'm curious how you 're establishing the value that Oracle is returning.
This could possibly just be a problem with the column format not being wide
enough for a fully expressed displayed answer.
RegHi all
I have weird problem for one SQL query which has
different execution plan before and after restarting
database.
Before restart it use NESTED LOOP (ANTI JOIN) and
never completed (total loI haven 't tried it but can 't think of any reason why it wouldn 't work.
You should just have to take the standby out of managed recovery mode
and open it read only first just like if you were openingall
I want to create report based on statspack about most top table.
for 9i onward we can set statspack level 7 or greater to do that but
not find in oracle 8i (8174). does anyone has the same taIf anyone is interested in some quick first looks at 11g I 've posted the
first of what I hope will be many 11g related blog entires that discuss an
11g New Feature.
You can see it at
http //robeHello all!
We are on ORACLE 9.2.0.6.
We have been on AIX 5.2. We just bought a bigger machine that came
installed with AIX 5.3.
I decided to just tar over the entire oracle install from the old mThis article from Sun about Oracle on T2000 was new to me.
http //www.sun.com/servers/coolthreads/tnb/applications_oracle.jsp
it discusses configuration of Oracle on the T2000.
Job
Joel
It 's difficult to give upfront any advice. It 's easier to add more
questions
- 80% of transactions but what is the transaction rate? Several per
seconds? A couple per hour?
- Do you really Hmmm. I don 't know of any DOS commands to do it (though I 'd imagine
they exist) but you could change the Oracle service with the oradim
command as well. Something like
oradim -edit -sid dbsid -stHi
We are planning to use outlines while upgrading from 9.2.0.6
to 9.2.0.8 due to many SQL plan changes. Solaris 2.9 9.2.0.8 Production
is a busy 3 node RAC cluster Applications versHi all.
We have 2 node RAC machine on HP/UX Itanium (10.1.0.4)
Sometimes we see some queries suffer from *latch cache buffer chain* event.
problem is mostly accessing same block concurrently.
**
WHello All
I 'm working on upgrading our E-Business suite database from 9.2.0.8 to
10.1.0.5 on HP-UX 11.11. I was trying to convert to native plsql
compilation and ran into a problem with extending L
Folks
Can 2 Setups of ASM & Veritas SFRAC Concurrently co-exist on the SAME 2 DB Server Nodes?
If so should the 2 Setups use SAME or DIFFERENT Public Private & Virtual IP Addresses?
NOTE - The 2 Anyone got working Oracle 9i/10g (AIX/Linux/Windows) external
authentication via Windows 2003 AD KDC (MIT Kerberos) ?
Is it worth the effort is it safe in a long run for production
environment?
So Hi all
I have configuration of one primary and one physical standby. the backups
are done on standby and recovery catalog is in use.
if I connect using rman on primary and catalog primary is 'awareOn 7/18/07 Clarke Andrew <andrew.clarke@(protected) > wrote
>
> Oracle FAQs has a list of all the various options with a bonus "sheesh! "
> style comment from Noons )
>
> http //orafaq.com/node/all
on solaris we can create another "virtual IP " at OS level can it be
made for private interconnect in oracle rac 10g?
--
regards
ujang
--
http //www.freelists.org/webpage/oracle-l
|
|
|
