European Experts Exchange (EEE.org) :: Free Experts PHP MySql Oracle Microsoft Web SQL Delphi


Databases :: Oracle :: DBA_TEMP_FILES TEMP STATISTICS
By: Nono	Date: 21/09/2005 09:50:18	Points: 20	Status: Answered Quality : Excellent
I'm searching for information about DBA_TEMP_FILES and related STATISTICS
By: VGR	Date: 21/09/2005 10:02:53		Type : Answer
Hi again ;-) You're right, in Oracle 9i+ that "view" shows you useful data : DBA_TEMP_FILES Information about database temp files (you can probably get all similar views by using DICTIONARY or DICT as in select * from dict where table_name like 'DBA%' ) If you want to analyse statistics on a given table or SELECT , then try out dbms_xplan : analyze table toto compute statistics; delete from plan_table; explain plan for select deptno, count() from toto group by deptno; select from table( dbms_xplan.display ); Don't forget also to try tkprof or v$sql_plan, the setting TIMED_STATISTICS in init.ora or the system view V$SYSSTAT. All may be relevant & helpful depending on your real problem. Regards

Do register to be able to answer

page generated in 41.589980 milliseconds