Activity that is not logged

Some SQL statements are not logged.

The following SQL statements do not produce log records, regardless of the database logging mode.
  • ALLOCATE COLLECTION
  • ALLOCATE DESCRIPTOR
  • ALLOCATE ROW
  • CLOSE
  • CONNECT
  • DATABASE
  • DEALLOCATE COLLECTION
  • DEALLOCATE DESCRIPTOR
  • DEALLOCATE ROW
  • DECLARE
  • DESCRIBE
  • DISCONNECT
  • FETCH
  • FREE
  • GET DESCRIPTOR
  • GET DIAGNOSTICS
  • INFO
  • LOCK TABLE
  • OPEN
  • OUTPUT
  • PREPARE
  • RELEASE SAVEPOINT
  • SAVEPOINT
  • SELECT
  • SET AUTOFREE
  • SET COLLATION
  • SET CONNECTION
  • SET DATASKIP
  • SET DEBUG FILE
  • SET DEFERRED_PREPARE
  • SET DESCRIPTOR
  • SET ENCRYPTION PASSWORD
  • SET ISOLATION
  • SET LOCK MODE
  • SET LOG
  • SET OPTIMIZATION
  • SET PDQPRIORITY
  • SET ROLE
  • SET SESSION AUTHORIZATION
  • SET STATEMENT CACHE
  • SET TRANSACTION
  • SET Transaction Mode
  • SET USER PASSWORD
  • UNLOCK TABLE
  • WHENEVER
  • SET ENVIRONMENT
  • SET EXPLAIN

For temporary tables in temporary dbspaces, nothing is logged, not even the SQL statements that are always logged for other types of tables. If you include temporary (nonlogging) dbspaces in the value of the DBSPACETEMP configuration parameter, the database server places nonlogging tables in these temporary dbspaces first.


Copyright© 2019 HCL Technologies Limited