 | | | Oracle List | | According to Mohamed Zait 's presentation last year in Zurich at Trivadis CBO Days the CBO does join search space optimizations like
- When number of tables < 5 it performs exhaustive searchHi all
I have a query which has a good plan on one node (node 3) and a bad plan (node 1) caused by a Merge Join Cartesian on another.
Bind variable peeking is disabled and dynamic sampliHi
I have Oracle 9i installed on my PC. When I go to OEM and then to a database and enter a username and password and hit OK it just stays there instead of going ahead and connecting so I can Not a precise answer but you probably can safely assume that it 's
related to resource manager.
On 6/6/07 Hameed Amir <Amir.Hameed@(protected) > wrote
> Folks
> I was seeing a session waiting on theFolks
A developer had me review code today that performed a UNION ALL of 3
very similar 2-table joins. I suggested a rewrite to perform the join
only once (one table is 42 million rows) and instIs there a way to force SMON to dump the most current table statistics to
all_tab_modifications?
Is there a way to force SMON to dump the most current table statistics to all_tab_modifications? <br >
There are number of reasons whe ASM might not be able to discover the
disk - permissions location (after reboot the same disk can change
from sda to sdb in linux terminlogy) storage config issues. THello
Toon Koppelaars among the others is working on this problem for several
years. He has published numerous papers on this topic and part of his
research will be published in the upcoming book Sandra Becker wrote
> Linux RHEL4 Oracle 9.2.0.8
>
> I have a developer who wants to define a column as CHAR(1) in an existing
> table. The only values this will ever hold are zero and one. I askit never did you just need
SELECT_CATALOG_ROLE
GRANT EXECUTE ON DBMS_AQADM
GRANT EXECUTE ON DBMS_CAPTURE_ADM
GRANT EXECUTE ON DBMS_PROPAGATION_ADM
GRANT EXECUTE ON DBMS_STREAMS_ADM
GRANT EXECUTE
Hey All
I had a few questions regarding stored outlines that I was hoping someone
could help me answer.
1) If your application mainly uses packages and procedures for everything
what is I recently took over support of a data warehouse oracle 9.2.0.7 on aix
and I was going over the init.ora and found this parameter
_column_elimination_off TRUE
The oracle documentation says iHi Niall thanks for raising this.
The whole release management of Oracle patches by the vendor is very
confusing even for oracle support analysts. I logged an SR about if we have
to apply patch 6038Hi
Regedit will allow you to do this use a /E parameter along with the key
and a file name to add it to and it will create the oracle key as a text
file. Could be part of your prebackup script if you
On Jun 4 2007 at 4 17 PM Amit Kumar wrote
>
> I am testing dataguard on RHEL4 linux oracle 10.2.0.3. I am able to
> build the environment and perform failover/switchover operations via
> dgm Hi Luc
I had the same issue with MLOG$_* tables (with 10.1.0.4) and I logged an SR a year ago. The support could not find why dbms_stats.gather_schema_stats and dbms_stats.gather_database_stats do
Folks
I 'm trying to work with a developer who is using GCC on an Sun
Solaris server creating an Oracle based executable. Well it sorta
works the problem is that gcc leaves the output file wiGood Morning
Any idea why rows processed is more than executions for dual query?
Taken from from 10gR2 statspack snapshot for 1 hour period.
CPU per backup the logs every x hours. For us x 1.
On 6/4/07 Kanwar Plaha <kanwar.plaha@(protected) > wrote
> Hi
> Due to a backup clashing with one of the automated cloning script for a
> database the retentiTo my knowledge this is not possible.
--
Mark J. Bobak
Senior Oracle Architect
ProQuest/CSA
"There are 10 types of people in the world Those who understand
binary and those who don 't. "
Thank you for your email. I will be out of the office until June 11th with unfortunately no access to email or telephone if your enquiry is urgent please contact Jon Mead on (07747) 604603 or jon.meHello Eriovaldo
Take a look at this excellent library it provides all basic FTP Client
functionality. I 've used in small proof-of-concept application but it did
it job successfully without any prUjang
If I was going to investigate CMAN I would start by purchasing the book
Oracle8i Networking 101 by Marlene Theriault
Even though this book is a little dated I doubt that CMAN has changed I found a couple of references to the statistic "User Calls " in statspack
reports as follows
"Oracle allocates resources to keep track of relevant user call data
structures every time you log in parInteresting situation. Running 10.2.0.2 EE. This situation can be
duplicated on our production and 3 development instances.
We have a table with monthly partitions. I 'm told that "all of a
sudden The 10GR2 documentation says about the DBMS_STATS.AUTO_INVALIDATE param.
"Use DBMS_STATS.AUTO_INVALIDATE. to have Oracle decide when to
invalidate dependent cursors. "
I did noticed it too that 's whtransactions from a business point of view and transactions from a
database point of view are often very different. the more closely they
are aligned the better. there is no way for oracle to trackGodwin
What are those sessions? Are they Application connections? If they are
application connections you can probably kill them if there are no bad
side effects. Not sure of how your applicaHow are folks handling single sign-on with Oracle?
We have implemented Enterprise Users with OID and are trying to migrate
that and Oracle Names to 10g OID and have had a fair amount of difficulty. This is very bad news. What you are in effect saying is that it is just
fine with the database for 60% of the tables to silently accept duplicate
rows. Even if the application running against the da |
|
|
