 | | | Oracle List | | Whether or not the SQL*Net message from client wait time is significant is
entirely dependent upon how you collected the trace. The beginning and
ending of the trace need to coincide exactly with t
You have to wonder if there is a past replication client that one day was
turned off and nobody told the source database. Whatever it is it looks
like some kind of disconnect with the source They couldn 't even tell me for sure that it was from Oracle. The "HA
committee " (all sr damagement) said to "investigate it " which I guess
means they heard a sales critter say something. Based on Hi
I pay referral fees if the referral results in a hire. Therefore if the
position
described below is not a match for you (i.e. qualifications location etc)
but you know
of someone who woulHi All
We have several Oracle databases with different versions i.e. Oracle 7.3.4 Oracle 8i and Oracle 9i. We need to keep data in sync between these databases. One way of achieving this is Our developers put an .ear file together but whenever I try to deploy it to
as10g I get java exception errors in an EJB.jar file.
I suspect that when they tell Jdev to produce the .ear file someIf you set query_rewrite_enabled in an 8i or 9i database see tech note
2673659.8 which was last revised in March 2004.
Patrice.
--
http //www.freelists.org/webpage/oracle-l
Hi
I am looking for a free ER-Diagram software for my own personal use. I
have used ER/Studio (a commercial package) heavily before and I liked it.
But I couldn 't afford it now. Is there some kiManoj
I checked and founnd the Cursor_sharing is exact and will use the Force. Actually in the trace which is created with Bind and Waits to true shows that all of the Sql called are having "sqlHi all
the env is oracle 9.2.0.4/Aix 5.2L.
I find something strange with a query.it joins 11 tables .
the predicate part has something like
"AND papr.payroll_name 'AA?QPTEST?QB ' "
Note Hi Guyz
It is working now. I made a mistake in typing the query properly.
Thanx Steve. I got the query as follow.
UPDATE PROFILE_CUSTOMERS SET SP_TYPE_CD ( SELECT SP_TYPE_CD
FROM PROFILE_Comments in-line
On Tue 12 Oct 2004 20 32 17 -0700 Yen Eric <eyen@(protected) > wrote
> I am working with an Oracle8i database.
> Yes I should upgrade and we have plans to in the near futurDear List
We are currently in the market for storage for our production databases (one
batch processing and a data warehouse). Our current storage is a san with 3
tb of raw storage using Sun A5200Except for very small tables extreme rates of dynamic extension and online
drops of dictionary managed objects with large numbers of extents the
number of extents has nearly no impact on performaMethinks that shared memory reloads are a direct consequence of having
zillions of hard-coded queries executing only once. There is no need to
add anything to the shared pool before the other quesI am going to cc my SA and see if he will be able to help.
Ruth
-----Original Message-----
From oracle-l-bounce@(protected)
[mailto oracle-l-bounce@(protected)]On Behalf Of Mohan Ross
JR
I 'm not on SUN so this may be a shot in the dark. Are java and the OUI at
the right versions? I believe the current requirement is 2.2.0.18 for OUI
and at least 1.3.1 for jre/java.
Mike I have an event A that runs on several different databases checking if a
database trigger is disabled. I would like to create a fixit job to run
if the
trigger is disabled that would re-enable theActually it looks as if 1 row is returned per execution 3262 parses 3262
executes 3262 fetches and 3262 rows returned. If it is correct that every
execute of this sql returns 1 row then maybe tThanks! I 'll look into that.
We are running 8.1.7.4.x and would have conditions where a thread was
consuming CPU which Oracle did not know about. Eventually we found
that it was the dead connection detection thread that is crI 'm not able to match ANY of the TIDs in qslice with the SPIDs in
Oracle. I must be doing something terribly wrong.
-----Original Message-----
From oracle-l-bounce@(protected)
[mailto oracWe are going to be migrating from 8i on Sun to 9i on AIX. Anyone have
this experience ideas gotchas docs on how to do this smoothly?
--
Bryan Wells
bunjibry@(protected)
--
http //www.freeliTom
Your answer is one of those "just because we 've always done it that way "
answers. And that is not a good answer - RMAN should be able to restore
a backup from only 5 years ago. Why do you I know that I can get all of this from 10046 traces including the recursive
SQL. I 've been using them for years and thanks to Cary and others I know
how to interpret them pretty well. The issue Typically when someone goes 'never ' its an over simplification and is often wrong. The only time I say 'never ' is when I talk to a non-technical person or someone without database skills since its toOracle 9 client is only cerified on windows xp pro not on home
editition. It is cerified for any 9 client (9.0 or 9.2)
--
http //www.freelists.org/webpage/oracle-l
"With Reduced Precision " simply allows you to place a materialized view
over a prebuilt table that the definition of the prebuilt table does not
match the the precision of columns in the defininHi
I 've written a small Perl program (open source) that manages the
Windows path environment. Its useful for configuring the Windows path
environment prior to running either DOS or WIN32 programAccording to the Oracle9i documentation passwords follow the same
rules applied to naming schema objects. This includes "alphanumeric
characters from your database character set and the underscore |
|
|
