b7dba
asked on
statistics
statistics for a pl/sql objects like procedures and functions how will we know ..
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
David VanZandt
Hi b7, did my answer from last week answer your question?
Hi b7dba,
if you need a more detailed answer, you need to post the OS/db version. PL/SQL objects like procedure, function and packages in turn consists of select and DML statements. if you are experiencing any slowness with one particular procedure, there should be an issue with the underlying SQL statements within the PL/SQL objects. There are some techniques available to diagnose the slowness.
dvz has advised you appropriately on this ?
if you need a more detailed answer, you need to post the OS/db version. PL/SQL objects like procedure, function and packages in turn consists of select and DML statements. if you are experiencing any slowness with one particular procedure, there should be an issue with the underlying SQL statements within the PL/SQL objects. There are some techniques available to diagnose the slowness.
dvz has advised you appropriately on this ?
Further thought -- statistics for PL/SQL breaks down to the statistics for the individual SQL statements. Ensure the tables are appropriately optimized (dbms_stats); the tables and views have appropriate indexes and organization; and that the statements have been worded to run in the least amount of time.