 | | | Oracle List | | Everyone
I have found out that when I set the _optimized_cost_model parameter to CPU
the same SQL (with no changes)
completes in under 10sec. Thanks to all who replied - Igor Terry
Wolfgang MladWe get the following error when using parallel query
across schemas and a logon trigger that alters the
session to enable resumable.
Any ideas why we would be getting this error?
The user running th
integer overflow
Hi
I have an application written in C++ running on HP11i machine. The
application uses OCI calls to retrieve data from Oracle database.
The setup is as below CliGood day everyone
Can anyone give me any link or good docs. for Oracle database
performance (9i) on HP-SUPERDOM (Itanimum) OS?
IBM have few really good performance docs. for AIX does HP has the samJefferey
I had a problem with my first install of OEM 10g r1 and was told to do a
reinstall by an Oracle tech. To do this I had to do the following. Maybe
you can do sonething similar with r2
- I checked my disks for windows there is a separate client disk.
Adar Yechiel
Rechovot Israel
Maxim wrote
> That was true for previous releases it seems for 10gR2 there is a
> regular clienI have what I hope is a simple question. We had a production issue where
SQL that had been peforming well stopped performing well. The execution
plans were all of a sudden different. We went to ouhas this tool been tested with databases inside ASM?
Maybe because it generates a lot more redo and your redo logs (i.e. the underlying disk system) are not fast enough to keep up. Do you see it waiting on 'log file sync '?
-----Original Message-----
Some of you know Joe Testa a long time Oracle DBA.
You may also know that he wanted to pursue some other
career goals and it looks like he 's made it.
Jared
List
Here is a recent paper on how hackers can use the SQL injection technique.
http //www.ngssoftware.com/papers/sqlinference.pdf
The SQL Server example appears quite appaling with a hacker beinOn 3/22/06 Nilo Segura <nilosegura@(protected) > wrote
>
>
> Does anybody know if this "very useful " feature will be "exposed " to us
> mortals in the next version (11g) ? Anybody using it in "productioI think you can 't restart an RMAN backup. When was
your last full backup with RMAN? and can 't you just do
an incremental backup?
Eddy
--- Wolfson Larry - lwolfs
<lawrence.wolfson@(protected) > wrote Hi All
My procedure must list only tables where max(length (formula)) >150. I have about 100 schemas and each has FIELDCUSTOM table.
CREATE OR REPLACE PROCEDURE data_count is
owner varchar2 (4All
Just when things are stable
We have Oracle General Ledger application installed on an NT machine.
The database app server & application itself are all installed on the
one machine. ThiHi Paul
you are right using the prepared statement the hard parse does not
occur every time the statement is executed. If you open and close the
prepared statement a soft parse will occur every pPaul
Try the following queries to check on Propagation (those are from some
Matalink doc)
PROMPT PROPAGATION JOBS IN DATABASE
COLUMN 'Source Queue ' FORMAT A39
COLUMN 'Destination Queue ' FORMAT A3 <html > <div style 'background-color ' > <DIV class RTE >
<P >My requirements is also similar where I have to refresh the lower regions (databases - development system acceptance etc.) from production data List
Can anyone tell me the index selectivity formula for a column when
there are histograms on the column.
I know that the index selectivity without histograms is
num_distinct/num_rows and also On 3/21/06 Coleman Kelley (HAC) <Kelley.Coleman@(protected) > wrote
>
> I have a 3rd part app that collects message strings from various external
> sites turns each string into an Oracle insert statemeFirst what are you hoping to accomplish by rewriting it? Is there an
index on 'COLUMN ' that is not being used because of the expression in
the WHERE clause? Is there another factor that you are tryI have a task to compare two large tables on different databases. All
columns need to be compared for changes. Would a hash value reduce the
amount of data to compare?
Dennis Williams
On 3/21/06 J10.2.0.1 on Solaris 9
The clusterware software and databases already exist (I know I could have multiplexed the OCR and Voting disk when I installed the clusterware software but i didn 't)
Use libodm.so and you don 't have to constantly wonder whether
async I/O support is going to dop in and out of the
picture between Linux OS releases. This is partly why Oracle
came up with odm.h
Hello
I 'm new to oracle dba responsibilities and in need of some direction.
I need to implement a process and I 'm not sure which technologies
and/or processes I should investigate.
Our application I can 't help with the 9i but I ran into the 10g issue before. In
fact the sys admin questioned whether or not Oracle was truly 64-bit
or changed just enough to run on a 64-bit (i.e. just a markeMy client in Berkeley is still trying to hire a qualified DBA candidate.
Their small team often reminds me of Amazon 's early DBA team both in style
and size. If you have any interest check out my caman echo
-----Original Message-----
From oracle-l-bounce@(protected)
[mailto oracle-l-bounce@(protected)] On Behalf Of Stankus Paula
Sent Monday March 20 2006 2 40 PM
To ORACLE-L@(protected)I have two Oracle 9.2.0.6 databases on our AIX 5.1 box. One of the
databases starts with a pfile the other one starts with an spfile. If
the database with spfile is down I can start it up manuallywell if you mutiplex at the file level you have prtection against
acidentally deleting a file for example.
With one you are only protected for disk failure
On 3/20/06 Ray Stell <stellr@(protected) |
|
|
