Modern Oracle DBA

Basically SPFILE is the binary file View the content is using OS command The strings command returns each string of printable characters in files. Its main uses are to determine the contents of and to extract text from binary files (i.e., non-text files). Characters are the basic symbols that are used to write or print a language strings spfilePROD.ora

Temporary Tablespaces Using for sort operations Cannot contain any permanent objects Locally managed extents recommended. Creating a Temporary Tablespace SQL> Create Temporary Tablespace TEMP_NEW                       Tempfile '/u01/oracle/VIS/data/temp_new01.dbf'                       Size 500M; Altering a Temporary Tablespace You can issue the ALTER TEMPORARY TABLESPACE statement to perform various temporary tablespace management tasks, including adding a tempfile to grow a temporary tablespace. Below is an example showing how you can make the temporary tablespace larger   How to add New temp file in temp tablespace?   SQL> Alter tablespace TEMP_NEW Add Tempfile '/u01/oracle/VIS/data/temp_new02.dbf'  Size 10m; How to resize  tempfile? SQL> Alter Database Tempfile '/u01/oracle/VIS/data/temp_new02.dbf' Resize 100m; How to drop tempfile? SQL> Alter database Tempfile &#