FROM sys.database_files WHERE type_desc = ‘LOG’ Once I have my log file name, I can use the DBCC command to shrink the file. In the following command I try to shrink my log file down to 1GB.

Users are able to perform SYS operations without an audit. Uni­fied Auditing “spill over” files are generated as binary OS files when the Oracle database system is either in mount state or read-only ...