Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Strife
  • Content: Threads
  • Order by date
  1. Strife

    contention on 'session allocation' latch

    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...
  2. Strife

    A PL/SQL question

    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...

Part and Inventory Search

Back
Top