New answers tagged sqlplus
To get the size of TEMP, in bytes (obviously divide by a few 1024s to get Gigabytes): select sum(bytes) from dba_temp_files where tablespace_name = 'TEMP'; Doc link for the view here.
I took some code snippets from a backup script that I use. You can redirect all output with the exec command, then redirect it back. You can also surround everything with braces and redirect that to a log file. Personally I think bash is a better shell to program in, if you don't have bash ksh works too. #!/bin/bash export MY_LOG_FILE=my_log_file.log ...
Top 50 recent answers are included