Any-body had any similar experience?
Oh yeahand how. Yours is a Pentium 4 box ? then read on...
It's a well-known problem...
The reason for this is that the P4 architecture has problems with the Java Just
In Time installer.
I'm not going to repeat it here.
The detailed answers are on
Hello folks,
We are looking into the VxFS/UFS snapshot utlities, and I am curious how you can
quiesce an Oracle instance? I would like all changes to the buffer cache to be
flushed
to the file system and checkpoints to occur. What would I need to run to do
this? I
assume this would give the file
Hi,
Does the material from technet.oracle.com sufficient to pass the exam ?
Regds,
New Bee
-Original Message-
From: Ed [mailto:[EMAIL PROTECTED]]
Sent: Saturday, December 08, 2001 12:05 AM
To: Multiple recipients
Hi, DBAs:
I find that one of our database's Shared Pool's memory decreased every day.
It is Oracle 8.1.7 on Windows 2K, with 512M Physical memory.
When I check v$sgastat, I find the miscellaneous part of shared pool increased
every day, it begans with 500K, then, after two days, it
This sound pretty much like the same problem I had with 8.1.7 on HP.
They have a memory leak when you connect/disconnect and it you have
a lot of those you start to see it in your SGA. I had to patch to
8.1.7.1 plus an additional bug fix. Check on Metalink to see if there
is the same problem
try replacing
document_number sequence (max,80,1),
with
document_number sequence (max,1),
sqlloader is taking 80 as your increment...
docs show only 2 arguments for sequence function...
hth
-Original Message-
Sent: Tuesday, December 04, 2001 11:01 AM
To: Multiple
I wouldn't suggest it. That's probably TOO much information to digest.
Best,
Ed
On Sun, 9 Dec 2001, CHAN Chor Ling Catherine (CSC) wrote:
Hi,
Does the material from technet.oracle.com sufficient to pass the exam ?
Regds,
New Bee
-Original Message-
A sort extent pool latch? That's weird. You can get the sid of the guy
holding the latch by joining v$latch.addr (or v$latchchildren if it's a
latch with children - sort extent is not) against v$latchholder.laddr.
something like
select sid from v$latch l, v$latchholder lh where l.addr =
Hi, Kimberly:
Thank you for your guide.
I checked Metalink and find that is a bug. Bug No. 1397603.
I think I will add the parameter _db_handles_cached to 1 later. I will also patch
it to 8.1.7.2 too.
Thank all of you.
B.R.
This sound pretty much like the same problem I had with
Did you check COMPATIBLE ? What is it set to ?
Make a FREE long distance call from your PC!
http://www.eboom.com/free/
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, December 07, 2001 12:05 PM
Oracle
WinterSun,
Hmm, this doesn't sound like bug 1397603. That bug
manifests itself as a memory leak in the 'State
objects' area of the shared pool, not the
'Miscellaneous' area. Bug 1397603 is also fixed in
the 8.1.7.2 patchset, so if you already have that
applied (hint, hint!) you're not
Hi Doug!
It sounds like SMON is busy doing something else, most
likely coalescing free space or deallocating temp
segments. See metalink Note: 61997.1 SMON -
Temporary Segment Cleanup and Free Space Coalescing
While there are events that can be set to prevent smon
from coalescing or cleaning
Ryn,
I know nothing about the VxFS/UFS snapshot utlities,
but from a backup standpoint, other than using RMAN,
the only way a valid backup can be taken with the
database up and running is to put the tablespaces in
backup mode before the datafiles, or the filesystems
on which they reside, are
Hi Robert,
Yea, you got the right point. I was using a server, which had
a P4 processor.
After lots of searches on metalink, I found the problem and
The workarounds ;-))
Great Bug for Great architecture ;-)
Thanks for your response,
Rajesh
-Original Message-
14 matches
Mail list logo