-- system-test-sql.txt by philg@mit.edu and jsc@arsdigita.com -- (Philip Greenspun and Jin Choi) -- **** these must be run by a user with DBA privileges **** --- -- system checks -- should return at least 1, for every user who wants to use autotrace select count(*) from all_tables where table_name = 'PLAN_TABLE'; -- should return one if you want i/o statistics -- if not there, run $ORACLE_HOME/sqlplus/admin/plustrce.sql select count(*) from dba_roles where role = 'PLUSTRACE'; -- make sure we have enough rollback segments -- should be > 2 select count(*) from dba_rollback_segs; -- this gives a lower bound on the maximum size in bytes of each -- rollback segment, assuming the pct_increase is 0. should be -- greater than the space needed for the maximum transaction that -- we will ever consider doing select sum(initial_extent * min_extents + next_extent * (max_extents - min_extents)) as lower_bound from dba_rollback_segs;