Well, according to oracle I might be running into a bug one of 4 they gave
me.
One relates to a function index - 2805335 or db link bug 2561115.
but how can I tell if there is a memory leak associated with a leak (I am
suspecting the HS link we have to sql server since we
continue to get core dumps) either of these.
I did provide ORacle support with a hanganalyze but I haven 't had time to
look into these.
I have also seen some of our .net process take alot of resources from
shared_pool and x$bh and not release them right away. They seem to release
resources in chunks. for example by being used count from x$bh goes from
4090 to over 3000 when one process is going them after it completes
it takes almost 40 minutes before the buffers go back to 500 or so. We are
using dispose in some code as we did have a problem with cursors
in some of the code. I test this code and it grabs alot of resource and
again takes a awhile to release them. So I am wondering about this as
well.
I will fix the compatability parameter in the init.ora I didn 't notice that.
I just wasn 't sure why the cursor spaced for time was set in the first
place. Was this way when I got here and I assumed it was set for a reason
but who knows.
Up to my A** in alligators this week... duhvelopers thinking they are dbas
and playing with tables then whining... why doesn 't this stuff work?
Had a strange problems on Friday afternoon. We are on 8.1.7.4 Solaris
Had a ton of Bam - ora_04031 errors.
Tried to flush the shared pool and it would release some space but a large
chuck was not being released and this was strange since we have only acouple
of objects pinned.
When I tried to pin an object that was failing right after I would flush the
shared_pool I couldn 't get space.
Nothing new was put in that week as far as I know.
Put in a tar with Oracle and they suggested to bounce the database - which I
did later, increased the shared_pool and session_cached_cursors
We have pinned some more objects that are being loaded alot.
I looked at the sql area and nothing looked horrible, all the same normal
stuff. In fact there was really no load on the database or machine, no
swapping or paging.
It was very strange. It looked like "something " had memory and wasn 't
releasing it.
Oracle Supportless was of no help.... except to say bounce the database and
told me to set a parameter that isn 't available until 9i.
I tried running quite a few of Steve Adams scripts but really didn 't
enlighten me as to what was causing the problem.
I have since set the event in the init.ora for 4031. I know we don 't use
enough bind variable since the "java " structure with Jbosse doesn 't work
with bind variable ( this is what I am told anyway)
the cursor_spaced_for_time is set to true which I believe was done for the
Jbosse app we are running since they pool connections and can 't/dont use
bind variables. I am wondering
if this should be set to false.
My questions are:
1) Is there a way to tell an object is holding/leaking memory in the
database. Or a way to monitor the shared_pool so I can be proactive if
fragmentation is getting out of hand.
2) This Steve Adams query says to set kgl_bucket_count to 7 the hash table
from growing
-- dynamically, and thus prevents the performance problems
-- associated with hash table growth -
How can I see if I have a problem with this hash table growth?
select
least(8, ceil(log(2, ceil(count(*) / 509)))) "INDEX "
from
sys.x_$kglob o
where
o.inst_id = userenv( 'Instance ') and
o.kglhdadr = o.kglhdpar
/
Any suggestions, welcome.
init.ora - I took out the nls and archive,etc info
This transmission contains information solely for intended recipient and may
be privileged, confidential and/or otherwise protect from disclosure. If
you are not the intended recipient, please contact the sender and delete all
copies of this transmission. This message and/or the materials contained
herein are not an offer to sell, or a solicitation of an offer to buy, any
securities or other instruments. The information has been obtained or
derived from sources believed by us to be reliable, but we do not represent
that it is accurate or complete. Any opinions or estimates contained in
this information constitute our judgment as of this date and are subject to
change without notice. Any information you share with us will be used in
the operation of our business, and we do not request and do not want any
material, nonpublic information. Absent an express prior written agreement,
we are not agreeing to treat any information confidentially and will use any
and all information and reserve the right to publish or disclose any
information you share with us.
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)
put 'unsubscribe ' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
This transmission contains information solely for intended recipient and may
be privileged, confidential and/or otherwise protect from disclosure. If
you are not the intended recipient, please contact the sender and delete all
copies of this transmission. This message and/or the materials contained
herein are not an offer to sell, or a solicitation of an offer to buy, any
securities or other instruments. The information has been obtained or
derived from sources believed by us to be reliable, but we do not represent
that it is accurate or complete. Any opinions or estimates contained in
this information constitute our judgment as of this date and are subject to
change without notice. Any information you share with us will be used in
the operation of our business, and we do not request and do not want any
material, nonpublic information. Absent an express prior written agreement,
we are not agreeing to treat any information confidentially and will use any
and all information and reserve the right to publish or disclose any
information you share with us.
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)
put 'unsubscribe ' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
