Re: type of join in sql

Hi The choice of of whether to use nested loop, hash join, sort-merge join is driven by the cost (logical ios performed ) and cardinality ( count of rows source for given operation ). Optimizer formulates several plan - before the best plan among them is chosen Approach one can take to benefit

Re: Buffer busy waits are 10.96% of non-idle waits

problem ? Regards, prem. On Fri, 12 Jul 2002 Kavitha Muthukumaren wrote : Hi , TOAD gives this alarm often. what does it mean ? which view will give me the wait statistics ? Answer : == Please run STATSPACK to if this is one of the top waitevents to check if the percentage

Re: Buffer busy waits are 10.96% of non-idle waits

bind variables instead of literals -- seperating tables and indexes to diferent tabelspace solve my problem ? Regards, prem. On Fri, 12 Jul 2002 Kavitha Muthukumaren wrote : Hi , TOAD gives this alarm often. what does it mean ? which view will give me the wait

Re: connect as internal

Hi Mitchell, what is different between those 3 login 1. sqlplus system login, connect as internal Answer: when you are doing this you are user 'sys' because you have changed from system to being 'internal' connect internal - technically is user 'sys', and is the way of

Re: Buffer busy waits are 10.96% of non-idle waits

Hi , TOAD gives this alarm often. what does it mean ? which view will give me the wait statistics ? Answer : == Please run STATSPACK to if this is one of the top waitevents to check if the percentage of wait - can be treated as problematic one SELECT p1 File, p2 Block, p3 Reason FROM

Re: Oracle Performance Tuning steps

Please run STATSPACK - which will give systemwide database performance diagnostics - you could check the hitratios, top wait events and resource consuming queries once report taken - upload it to www.oraperf.com - for suggestions check metalink article NOTE.149121.1 Gathering a StatsPack