Technical Notes

We're all on the same page!

Showing posts with label temporary tablespace. Show all posts
Showing posts with label temporary tablespace. Show all posts
Tuesday, 22 August 2017

How to monitor TEMP tablespace resource usage?

›
-> Check Total TEMP usage: SQL> SELECT B.TOTAL_MB,        B.TOTAL_MB - ROUND (A.USED_BLOCKS * 8 / 1024) CURRENT_FREE_MB,        RO...
Sunday, 19 October 2014

How to define and drop temporary tablespace?

›
Please execute the commands as "sys"; SQL> CREATE TEMPORARY TABLESPACE ALPER_TS_TEMP TEMPFILE   'C:\tablespaces\data_01...
›
Home
View web version
Powered by Blogger.