 | | | Oracle List | | I installed Oracle 10g on my RH-9 box everything went well
but things were much hairier with public domain software.
Tora and DBD Oracle 1.15 had no problems with linking against
oracle. PHP-4.3Use the new directory feature of 9i
CREATE OR REPLACE DIRECTORY ROOT
AS
'C \ '
Then pass 'ROOT ' where utl_file needs a location. And remove your offending entries from init.ora
Btw I reallyI think you need to do a static copy...
Try /usr/sbin/static/cp instead of the normal cp command.
HTH
-----Original Message-----
From oracle-l-bounce@(protected)
[mailto oracle-l-bounce@(protected)I 've used it to restrict access to a sequence.
This particular sequence is reset to 0 at midnight
every night.
The code to get the next sequence looks like this
dbms_lock.request
dbm
Your client might be suffering delayed block cleanout.
See Note 40689.1 on MetaLink {or others on this list might be able
to explain it better}
Hemant
At 09 28 AM 14-02-04 -0500 you wrote
Alison
If you are intitled to the ISO 's you can select the ALL button and it
will display the new AS 2.1 upgrade 3 release ISO 's that you can
download. The upgrade is what you need to make it comThanks John in a way you are making me feel better. I just want to be sure
this is not a DB issue and I don 't think it is. All the things you point
out are issues but the mystery is why I see thHi something several people didn 't know at lesat me is about spyware.
Even when norton detect several of them another software like ad-aware or
webroot spyware
detect aditional of them.
For I worked with Siebel Vantive (interactive help & ticket tracking
system) and it worked fine with oracle 8i and CBO. There were no
performance problems. I don 't know any other Siebel app.
On 02/
John / Jonathan
Thank you very much for your assitance and advice. Rightly so it seems
that such behaviour
is not common.
I have been able to identify
1. A Process which is a DBLink conIs there a document somewhere on what would constitute a /minimal/
Oracle installation? Even the most custom installation at least via
the OUI includes a lot of stuff that 's not necessary XML DBYes the post_transaction procedure would use most of the CPU but nmon
shows the CPU is idle almost all the time. So while this procedure uses
most of the cpu when cpu is being used most of the t
Ryan
If your comment about hash maps relates to hash joins
the datablocks are NOT stored in the PGA some
columns from some of the rows in the 'first ' table 's
data blocks are copied into the
I think John covered most of the points but
what you are saying and what statspack is
saying are totally consistent. Statspack reports
about 3 200 seconds of CPU in half an hour
but you haveSorry to waste everybody 's time but I 'm trying to figure out this "quoted-printable " issue from Outlook.
Depuis quatre ans la loi f?d?rale sur le travail fixe l '?ge de protection ? 19 ans pour lesI 'm just starting to research high availability solutions for Oracle and I
wonder if some of the folks with experience using HA could offer a few words
about when to use the various HA options offeThere 's always the tried and true "write a procedure that does all necessary verifications and give execute privilege on the procedure to userA. " e.g.
create procedure truncate_table (table_owner_in Is anyone running Oracle on an Intel based version of Linux?
What is the learning curve like going from HP Unix to Linux?
Hemant
If this was due to some process(es) executing a _very_ large number of
small quickly-completing queries within a very short period of time then
you might be able to trace them down fromI think their membership processing leaves
much to be desired. I signed up for a year
more than a year ago now. I never received
a copy of Select and thus far the only thing
I have received isspam egg bacon spam and spam?
On 02/13/2004 12 40 22 PM Freeman Robert - IL wrote
> spam spam spam spam spam spam!
> wonderful spam!
> Wonderful spam!
>
>
>
> -----Original Message-----On 02/13/2004 12 08 38 PM Carmen Rusu wrote
> ..do I still need to perform on the new db the patchset post-install
> instructions?
>
> Things like recreating the java package etc.
>
> Oracle
Based on the information you 've posted so
far your problem seems to be exclusively
with library cache latches and not row
cache latches or shared pool latches.
Since the load is fairly evenly Or the trigger must invoke a procedure owned by someone having 'ALTER
SESSION ' privilege.
On 02/13/2004 01 29 48 PM Paul Baumgartel wrote
> The user must have ALTER SESSION granted directly not ISM can 't be used for those segments which can 't be locked into memory
because ISM segments can never be paged out. But it 'd be stupid to create a
SGA larger than RAM anyway thus this isn 't really
Jonathan
More information on Latch statistics
SQL > select child# gets misses sleeps
2 from v$latch_children
3 where name 'library cache '
4 order by latch# child#
Chris
Some obvious suggestions
Have your network people monitor network traffic - do simple trace routes to
see if/where the delay is.
Are you using Oracle Multi-Threaded server? I have sHere 's from Sun Tech support. Does it make any sense to you? To me it
doesnt -(
> customer. I wouldset
> shmmax THE_HIGHEST_NUMBER_OF_BYTES_TO_BE_USED_BY_THE_SGA+ some extra
> head room.
As the default value on 9.2.0.4 is already 2000 I don 't think you will
see much difference.
Jared
<ryan.gaffuri@(protected) >
Sent by oracle-l-bounce@(protected)
03/03/2004 03 34 PIts a fact that right after M$ solves the security
issues with w2k3 they are going to implement the next
cool thing Perpetual Motion.
I can 't wait. -)
Regards
Mike Thomas
--- Carel-Ja |
|
|
