Performance/Internals Wizards!
Anyone ever play with _row_cache_buffer_size?
I am having trouble with a crappy application and out of control
packages ( too big ) and public synonyms out the ying yang.
My 734 instance has DD cache size swells that remind me of
"A Perfect Storm", except I bear zero resemblance to George Clooney.
It may be a derived parameter ( depending on shpool size, processes, etc)
but, if so, I cannot find the root parameter.
I would like to apply an init.ora bandaid to the DD cache without having
to touch the crApplication yet. Yes, it would be an indirect fix at best,
especially given that V$LATCH_MISSES indicates it is the DD "find obj"
that is the problem, not the parse. <sigh> How I despise public synonyms,
developers, and and and <sputtering into silence> .
If you've played with _row_cache_buffer_size, please let me know.
I have done a ROW_CACHE dump via ORADEBUG, but I cannot prove conclusively
that the space/size is due to Public Synonyms. Any guidance there would
be most welcome, as well.
Thanks!
- Ross
p.s. I have set _row_cache_cursors to 200 ( range is 10-3300, default is
10,
and yes i know (a) oracle says the default is fine, and (b) using
undocumented
parameters is bad )
|| -----Original Message-----
|| From: Steve Adams [mailto:[EMAIL PROTECTED]]
|| Sent: Tuesday, May 01, 2001 11:00 AM
|| To: Multiple recipients of list ORACLE-L
|| Subject: RE: Oracle What savepoints are active for a given session?
||
||
|| Hi Venkata,
||
|| There is no V$ view or X$ table that contains this
|| information. The only
|| solution that occurs to me is to dump the savepoints to the
|| process trace file
|| with
||
|| alter session set events 'immediate trace name savepoints';
||
|| and then use UTL_FILE to read and parse the trace file
|| information. Here is an
|| example of what you might get:
||
|| SAVEPOINT FOR CURRENT PROCESS
|| ------------------------------
|| flag: 0x3
|| name: S3
|| dba: 0x831408, sequence #: 964, record #: 12, savepoint #: 19082
|| status: VALID, next: 3822f60
|| name: S2
|| dba: 0x831408, sequence #: 964, record #: 11, savepoint #: 19046
|| status: VALID, next: 37f63ec
|| name: S1
|| dba: 0x831408, sequence #: 964, record #: 10, savepoint #: 18602
|| status: VALID, next: 0
||
|| This process has three savepoints named S1, S2 and S3 respectively.
||
|| @ Regards,
|| @ Steve Adams
|| @ http://www.ixora.com.au/
|| @ http://www.christianity.net.au/
||
||
|| -----Original Message-----
|| Sent: Tuesday, 1 May 2001 18:20
|| To: Multiple recipients of list ORACLE-L
||
||
|| HI PLEASE SEND ME ANSWER
|| Question Title: Oracle What savepoints are active for a
|| given session?
||
|| Detailed Question: Does anybody know IF and HOW can I get a list of
|| active savepoints for the current session? I need a native way, not
|| solutions based on additional application-level
|| housekeeping. Some query
|| on the V$ tables/views would be the kind of answer I'm looking for.
|| Details: Within one stored proc I'd like to obtain a list
|| (in any form)
|| of the savepoints issued currently in the current
|| transaction. Example:
|| Proc A issues savepoint svA; then proc B issues savepoint
|| svB; and then
|| proc C builds and uses a cursor having 'svA' and 'svB' as rows, or
|| something like that. Of course, there are no intervening commits or
|| rollbacks.
||
|| --
|| Please see the official ORACLE-L FAQ: http://www.orafaq.com
|| --
|| Author: Steve Adams
|| INET: [EMAIL PROTECTED]
||
|| Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
|| San Diego, California -- Public Internet access /
|| Mailing Lists
|| --------------------------------------------------------------------
|| To REMOVE yourself from this mailing list, send an E-Mail message
|| to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
|| the message BODY, include a line containing: UNSUB ORACLE-L
|| (or the name of mailing list you want to be removed from). You may
|| also send the HELP command for other information (like subscribing).
||
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mohan, Ross
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
