In some cases, you can use the logging mode for the table and index segments, or the mode that does not log logs. If you are using a data pump to import a table segment or index segment, you can
Use the nologging mode, and use the data guard or a scenario that is high in availability to record the log, or even use the force log. This article describes how the index segment in the table segment is used
The redo size of the logging and nologging and how the direct INSERT APPEND is used.
Nologging is related to the operating mode of the database, the default installation of I and I is not in archive mode, and automatic archiving is disabled by default. When G, G is installed, you can choose whether to return
File. Nologgiing will record a small amount of log information to the log file. This option is not valid if the force logging force logging mode is used at the database level or at the table space level.
The situation of logging and nologging when the general ddl,dml is used in the table section and the index section
1. View the archive mode of the database
For questions about setting the log archive mode, refer to:
Oracle Online redo log files (online log file)
Oracle Archive Logs
Sys@orcl> select log_mode,force_logging from V$database;
Log_mode for
------------ ---
Archivelog NO
sys@orcl> archive log list;
Database Log Mode Archive mode
Automatic Archival Enabled
Archive Destination/u01/bk/arch
Oldest online log sequence 50
Next log sequence to archive 51
Current Log Sequence 51
Sys@orcl> select tablespace_name,logging,force_logging from Dba_tablespaces;
Tablespace_name LOGGING for
------------------------------ --------- ---
SYSTEM LOGGING NO
UNDOTBS1 LOGGING NO
Sysaux LOGGING NO
TEMP nologging NO
USERS LOGGING NO
Perfstat LOGGING NO
Scott@orcl> select * from V$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-prod
Pl/sql Release 10.2.0.1.0-production
CORE 10.2.0.1.0 Production
TNS for Linux:version 10.2.0.1.0-production
Nlsrtl Version 10.2.0.1.0-production
2. Create a view to view redo size Redo_size
CREATE OR REPLACE FORCE VIEW "SYS". Redo_size "
As
SELECT A.name,b.value
From V$statname A
JOIN V$mystat b
On a.statistic# = b.statistic#
WHERE a.name = ' redo size ';
sys@orcl> create public synonym redo_size for redo_size;
Sys@orcl> Grant SELECT on Redo_size to Scott;
See more highlights of this column: http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/