More 'copy and paste' from someone else's work who you gave no credit to.
Another 'drive-by' post having little value.
That makes no sense; how do the memory structures form data files? There is no magic with Oracle, yet your post indicates there is. 'Drive-by'...
You can copy text from the documentation; why didn't you explain this in your OWN words? THAT would have been much more helpful to others.
It is NOT a 'variable', it's a packaged procedure that may NOT be installed by default. Posting such 'advice' only leads to more confusion....
Please explain that response.
The first 'problem' is expecting a 3+ TB database to back up in less than 8 hours. Most take 8 to 10 hours for a complete backup. If you're not...
Post this as a forum question -- NO ONE reads profile posts.
I've posted temporary tablespace information and queries here:
TEMPORARY (Tablespace) Insanity?
Many of the queries in this document are...
This is your work to do, not ours.
You need a better description of the work that needs to be done. What does 'all filled up' mean?
That's not the error generated when I run it:
Errors for FUNCTION TEXT_FN:
How does this answer the original question?
Where, O Where Has That Table Gone?
You could have found this from the home page to the forums.
You copied this from what document? Who wrote it? Why isn't credit being given?