Compression Advisor command reference


Compression Advisor command reference
Prev	Using the Compression Advisor tool	Next

The sfae_comp_adm command syntax is illustrated as follows and its options are listed in Table: Compression Advisor command options.

sfae_comp_adm [ -S ORACLE_SID ] [ -H ORACLE_HOME ]
-o compress_archive_logs [ -n N ] [ -d DESTINATION ]

sfae_comp_adm [ -S ORACLE_SID ] [ -H ORACLE_HOME ]
-o { compress_datafiles | uncompress_datafiles }
DATAFILE1 [ DATAFILE2 ... ]

sfae_comp_adm [ -S ORACLE_SID ] [ -H ORACLE_HOME ]
-o { compress_datafiles | uncompress_datafiles }
-f LISTFILE

sfae_comp_adm [ -S ORACLE_SID ] [ -H ORACLE_HOME ]
-o { compress_datafiles | uncompress_datafiles }
-t TIER

sfae_comp_adm [ -S ORACLE_SID ] [ -H ORACLE_HOME ]
-o display [ -n N ] [ -t TABLESPACE ] [ -c ]

Table: Compression Advisor command options

Option	Use
-S ORACLE_SID	Specify the ORACLE_SID, which is the SID of the Oracle database to be used. You can set this value in the environment by using the environment variable *ORACLE_SID*.
-H ORACLE_HOME	Specify the ORACLE_HOME, which is the HOME of the Oracle instance to be used. You can set this value in the environment by using the environment variable *ORACLE_HOME*.
-o compress_archive_logs	Compress the specified archive logs.
-d DESTINATION	Used with -o compress_archive_logs. Compress archive logs generated from the specified destination. If your database is configured to archive to multiple destinations, archive logs on all destinations are compressed, by default.
-o compress_datafiles	Compress the specified data files.
-o uncompress_datafiles	Uncompress the specified data files.
-f LISTFILE	Used with -o compress_datafiles or -o uncompress_datafiles . Specify a file that contains the names of the data files to be compressed or uncompressed, with each data file name on a single line.
-o display	Display the list of candidate data files that can be compressed.
-t TIER -t TABLESPACE	When using with -o compress_datafiles or -o uncompress_datafiles: Specify the storage tier of which all data files are to be compressed or uncompressed. When using with -o display: Specify the tablespace of which all data files that are candidates for compression are to be displayed.
-n N	When using with -o compress_archive_logs: Compress archive logs generated N days ago or older. If you specify N as 0, all archive logs are compressed. The default value is 1. When using with -o display: Specify the number of files that can be displayed. The default value is 10.
-c	Used with -o display. Display the list of compressed data files.

Prev	Up	Next
Uncompressing Oracle data files using Compression Advisor	Home	Section VII. Managing Oracle disaster recovery