tracking temp tablespace use in pl/sql

[Quoted] any suggestions appreciated. if you don't have time to give a full explanation, please list a reference that might be useful. I'll do the legwork.

I need to keep track of how much temp tablespace a program is using, ideally logging max use of each sql statement just after the statement finishes up.

Any of the following would be useful
- a function that returns max temp tablespace used by the most recent SQL

• a wrapper that encapsulates an SQL and provides this same info.

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet