Logging and nologging on Oracle table and index segments

Source: Internet
Author: User
Tags oracle database

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/

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.