 | | | Oracle List | |
On 04/06/2004 12 17 10 PM Pete Sharman wrote
> 1. Dangerous to know - incorrect usage may cause even further problems
> 2. Not necessary for you to know - see 1 or
> 3. Provides informatihi friends
I have a database recently reporting latch free waitevent in statspack
report. Load on this server is increasing fast. I am not sure about
1. Do I need to tune this latch free evenJeroen
I guess there a two ways to look at this
1). 2-4 hours log switch during the day is ok. every minute at night is a
bit costly. however if your batch is completing in a timely mannerdrop the statspack user.
-----Original Message-----
From oracle-l-bounce@(protected)
[mailto oracle-l-bounce@(protected)]On Behalf Of Sinardy Xing
Sent Tuesday April 06 2004 1 25 PM
Are 32 bit client libraries available with Oracle 10g
This same are needed by our application software
Thanks
> Since the same SQL statement is executed I would expect it to reuse the > parsed statement but in this case it doesn 't. Is this a expected > behavior with ref cursors?
Yes using ref cursors cau--- "Mihalis I. Tsoukalos " <mtsouk@(protected) > wrote
> On Sat May 08 2004 at 11 30 30PM -0600 Chip
> Did the previous version of Oracle (I think 9i) ran
> on OS X (not the server version)?
> There is an interesting utility to test fastly two differect solutions
1.1 Tom Kyte?s Runstats To compare two solutions
This tool allows you easily to compare two distinct solutions.
What 's the largest shared pool size you 've ever seen?
I 'm doing an evaluation of a company 's Oracle environment and boy is
their shared pool huge. Before I say it 's the largest I 've ever seen
My guess would be that this is a deliberate
heuristic introduced some time around 9
to avoid nested loop full tablescans when
the numbers are small.
If you create a unique key constraint on
t
> Allan L. Nelson
> Oracle DBA
> M-I L.L.C. 20
> (832) 295-2238 office 20
> (832) 351-4180 fax 20
> anelson@(protected) <mailto anelson@(protected) >
> 20
> 20
IIRC the installation is supposed to be forms first and then the
database in order to get the homes set up correctly
-----Original Message-----
From oracle-l-bounce@(protected)
[mailto orHI All
I am supposed to apply the consolidate udate patch 3171663 on Linux
platform. ( vanila 11.5.9 )
The linux box is not yet released to the DBA team and we don 't know which
Linux (Suise/Hi Rajeev
Check whether you have the control files in place as per your spfile.
regards
Senthil.
-----Original Message-----
From oracle-l-bounce@(protected)
[mailto oracle-l-bIMHO you 're right about Forte. But I personally consider Eclipse a viable
alternative to Netbeans (or Forte which is basically the same except for
the fact that you 'll have to pay for it). IBM 's Guys
can you let me know wat is the max active sessions you have encountered.My system has arnd 250 Concurrent user s but I never get more than 18 users active at any given instant.
thanks a mil
Hi List
I got an email that oracle 8i ocp exams retires in the month of June this year. When I surf oracle site I couldn 't find any information regarding this. How true is this? Is oracle 8i ocp go--- "Jesse Rich " <Rich.Jesse@(protected) >
wrote
> Has anyone used Oracle 9iR2 on an AMD Opteron?
> According to MetaLink the
> "supported " status is currently "projected ".
>
> The reasoThomas - Usually ORDER BY causes a sort to occur. A simple check would be to
run EXPLAIN PLAN on both versions of the query.
Dennis Williams
DBA
Lifetouch Inc.
dwilliams@(protected)
-----
Remember It 's never oracle 's fault... always blame the network )
Anyway Oracle Names is similar to DNS. It uses port 1575 by default but is configurable. Check
your sqlnet.ora file.
BTW Randy
You have my sympathy. Given the circumstances whatever works is the
choice. You might want to study ITIL so you can help management understand
how to increase quality.
Dennis Williams
I 'm starting to think you must be a windows 'secret
admirer ' (hahaha like that 's even possible).
Therefore you probably already know about this site
http //www.ss64.com/index.html
Have a goMladen
you are too kind to the customer. I remember a book called 'Satisfaction
guaranteed ' about customer satisfaction which we oracle technical
support
analysts in The Netherlands had to rStephen
So . . . if a lot of these queries are new with evolving queries -- is
it just possible that it really has nothing to do with the 9.2.0.4 patch
but just coincidentally some queries sta > How can I know syntax on Oracle? How can I read data on BLOB fields on > WKT
> format?
>
> I will appreciate your help on this.
Hmm... that 's a hard one.
Do you think by any means would reGreat Manufacturing Company in Ft. Wayne Indiana area needs a Oracle /SQL Server DBA
to join its ' IT staff.
Our client is looking to hire an experienced ORACLE Database Administrator.
You will alSteve can you recommend a nice unix-based Python IDE? I 'm looking
for something better then gvim. The main problem with perl is a lack
of IDE tools. Eclipse is a mess and I don 't like it.
On 04I 'm downloading perl but meanwhile maybe this is a stupid question
Because nobody say something like "use java when... and perl... when "
this is java 50% perl 50% instead it was was java 1% aThanks Jared and everyone for the advice I didn 't knew that
and this advice can save me problems in the future.
Personally if someone puts a personal email I send him in the list now or
in theThanks
Juan Carlos Reyes Pacheco
OCP
Database 9.2 Standard Edition
----- Original Message -----
From "Tim Gorman " <tim@(protected) >
To <oracle-l@(protected) >
Sent Friday April 02 200 |
|
|
