Activity That is Always Logged

Home | Previous Page | Next Page Logging and Log Administration > Logging > Logging of SQL Statements and Database Server Activity >

Activity That is Always Logged

Some database operations always generate logical-log records, even if you turn off transaction logging or use nonlogging tables.

The following operations are always logged for permanent tables:

Certain SQL statements, including SQL data definition statements
Storage-space backups
Checkpoints
Administrative changes to the database server configuration such as adding a chunk or dbspace
Allocation of new extents to tables
A change to the logging status of a database
Smart-large-object operations:
- Creating
- Deleting
- Allocating and deallocating extents
- Truncating
- Combining and splitting chunk free list pages
- Changing the LO header and the LO reference count
Sbspace metadata
Blobspaces

The table below lists statements that generate operations that are logged.

ALTER ACCESS_METHOD
ALTER FRAGMENT
ALTER FUNCTION
ALTER INDEX
ALTER PROCEDURE
ALTER ROUTINE
ALTER SEQUENCE
ALTER TABLE
CLOSE DATABASE
CREATE ACCESS_METHOD
CREATE AGGREGATE
CREATE CAST
CREATE DATABASE
CREATE DISTINCT TYPE
CREATE EXTERNAL TABLE
CREATE FUNCTION
CREATE FUNCTION FROM
CREATE INDEX
CREATE OPAQUE TYPE
CREATE OPCLASS
CREATE PROCEDURE
CREATE PROCEDURE FROM
CREATE ROLE

CREATE ROUTINE
CREATE ROUTINE FROM
CREATE ROW TYPE
CREATE SCHEMA
CREATE SEQUENCE
CREATE SYNONYM
CREATE TABLE
CREATE Temporary TABLE
CREATE TRIGGER
CREATE VIEW
CREATE XADATASOURCE
CREATE XADATASOURCE TYPE
DROP ACCESS_METHOD
DROP AGGREGATE
DROP CAST
DROP DATABASE
DROP FUNCTION
DROP INDEX
DROP OPCLASS
DROP PROCEDURE
DROP ROLE
DROP ROUTINE
DROP ROW TYPE

DROP SEQUENCE
DROP SYNONYM
DROP TABLE
DROP TRIGGER
DROP TYPE
DROP VIEW
CREATE XADATASOURCE
DROP XADATASOURCE TYPE
GRANT
RENAME COLUMN
RENAME DATABASE
RENAME INDEX
RENAME SEQUENCE
RENAME TABLE
REVOKE
REVOKE FRAGMENT