1. Environment WINDOWS2000 Server, Oracle9i In non-invasive mode, if the following statement is performed, the system does not respond to SQL> ALTER SYSTEM ARCHIVE LOG CURRENT; SQL> ALTER SYSTEM SWITCH logfile;
2. Oracle 9i Database default Parameter Fast_Start_IO_TARGET INTEGER 0FAST_START_MTTR_TARGET INTEGER 300LOG_CHECKPOINT_INTERVAL INTEGER 0LOG_CHECKPOINT_TIMEOUT INTEGER 1800 where the second parameter unit is second, which will cause an archive log file to generate a minimum within 5 minutes?
The default rollback 3.Oracle 9i as SYSTEM, but there are 10 such rollback SQL> select segment_name, status from dba_rollback_segs; SYSTEM ONLINE_SYSSMU1 $ ONLINE_SYSSMU2 $ ONLINE_SYSSMU3 $ ONLINE_SYSSMU4 $ ONLINE_SYSSMU5 $ ONLINE_SYSSMU6 $ ONLINE_SYSSMU7 $ ONLINE_SYSSMU8 $ ONLINE_SYSSMU9 $ Online_syssmu10 $ online
4. Is Oracle 9i Rollover segment management adopted a new mode? An error message when creating a non-system returning segment: "ORA-30019: Back section operation in automatic revocation mode illegal" No need to create or manage the rollback segment, and not allowed to create or manage back in Auto Restore mode Roll.
5. Oracle 9irollback_segments This parameter is a list of parameter. If you are a PUBLIC type when you create a rollover, you have nothing to do with this parameter. If it is a private type, you must make the rollback segment appear in the parameter list, otherwise the database starts. These returns will not be online. This is corresponding to the OPS / RAC, the PUBLIC type rollback segment indicates that all instances can use these rolling segments, and the PRIVATE type is set by which instance initialization parameter is set to which instance is used.
