Oracle Database case Consolidation-oracle system execution failure-sql_trace to true causes Oracle to lack free space in the root folder

1.1Described

Generate a lot of "oracle_w000_9708.trc" and "ORACLE_W000_9708.TRM" under the "$ORACLE _base/diag/rdbms/$ORACLE _sid/$ORACLE _sid/trace" folder File.

These files are generated too quickly. The Oracle root folder is running out of free space.

1.2Possible causes

The possible reason for the "$ORACLE _base/diag/rdbms/$ORACLE _sid/$ORACLE _sid/tracee" folder to produce a large number of files is that the database global Sql_trace switch is set to true.

1.3Process steps

1. Log on to the database machine as an Oracle user.
2. Connect the database to the sysdba user.

% Sqlplus/as SYSDBA

3. View the global sql_trace switch status.

Sql> show parameter Trace;

The system shows samples such as the following information:

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

Log_archive_trace integer 0

Sec_protocol_error_trace_action string Trace

Sql_trace  Boolean TRUE

trace_enabled Boolean TRUE

Tracefile_identifier string

4. Turn off the global sql_trace switch.

sql> ALTER DATABASE Set sql_trace = FALSE;

5. Check whether the problem is resolved.

1.4Reference information

Suppose you want to track a session. Only need to open the session level, after tracking please close.

· turn on session level tracking:

Sql> alter session Set sql_trace = Ture;

· To turn off session level tracking:

Sql> alter session Set Sql_trace = FALSE;

Copyright notice: This article Bo Master original article. Blog, not reproduced without consent.

Oracle Database case Consolidation-oracle system execution failure-sql_trace to true causes Oracle to lack free space in the root folder