A value of "SQ Enqueue" indicates that there is contention for sequences.In almost all cases, executing an Oracle ALTER SEQUENCE command can increase the cache size of sequences used by the application.Prior to Oracle 10g, adjusting optimizer parameters was the only way to compensate for sample size issues with dbms_stats.As of 10g, the use of dbms_stats.gather_system_stats and improved sampling within dbms_stats had made adjustments to these parameters far less important.(Drives' speed varies; you can get the dev numbers when you execute cdrecord -scanbus).
To accomplish this you can use the Oracle ALTER SEQUENCE command.
I was able to get a 10g database up and running on this little PC without a problem.
or disaster occurs, then you can restore your backups and recover lost changes.
Ceteris Parabus, always adjust CBO statistics before adjusting optimizer parms.
For more details on optimizer parameters, see my latest book " desc dba_tab_modifications; Name Type -------------------------------- TABLE_OWNER VARCHAR2(30) TABLE_NAME VARCHAR2(30) PARTITION_NAME VARCHAR2(30) SUBPARTITION_NAME VARCHAR2(30) INSERTS NUMBER UPDATES NUMBER DELETES NUMBER TIMESTAMP DATE TRUNCATED VARCHAR2(3) The better the quality of the statistics, the better the job that the CBO will do when determining your execution plans.