Recent content by Strife

Hi, thanks for that.. will be looking at the library cache problem next (it is only a small issue).. currently the main problem is with block buffer latches.

nope that's not it.. the hash_buckets by default are set to 2x the number of buffers and that is the case in this db. we are working on finding the hashing algorithm now to understand why a db would need even one more bucket than number of buffers. the problem is with the number of latches...

nope.. thats not it.. buffer cache is already at 100%. if anyone is interested this is my conclusion: Recommend setting _db_block_hash_latches = 4096 # in 8.1.x default for this with 40000 block buffers is 1024 I have found a high number of waits for the latch 'cache buffers chains' and...

more analysis on this is showing 'library cache' and 'cache buffers chains' latches to have the highest waits.. could this possibly mean reducing the block buffers as the buffer cache hit-ratio is at 100%.. anyone have experiance with this type of contention? Thanks

Hi all, have noticed the session allocaion latch is running at 97.7% on a good day! the system is running very slow. Any ideas on how to reduce contention for this type of latch? System is: Oracle81630 Sun OS 4cpus 3Gb Ram. SGA: buffers 320M shared pool 160M OAS 4081. Most connection are...

or if you need to identify the active open database links then try: select * from sys.v_$dblink; -- This will only return rows if the link is active!

Hi, Actually Santhosh, you asked for a list of defined database links in the database and LINK$ is the source table for this.. is this what you need? select 'create public database link ' || name || ' connect to ' || userid || ' identified by ' || password || ' using ''' ||...

select * from sys.link$ -- this shows all including passwords!

yeap that sounds about right and you should consider using export/import to migrate your db.. only look at the migration utility if you don't have enough space for export/import.

Hi all, I would like to know how to declare an array like myvar(100,50) so it can be referrenced in code like: declare temp number; myvar of type ? begin .. do some stuff for i in 1..100 loop temp := myvar(i,10); end loop; .. do more stuff exception end; I am aware of this type...