SQL to find out temp tables created by a session

Posted in 1997

sujata_soman_at_omm-la2-infotech-001@internet.omm.com — 23 Dec 1997 15:28:25 -0500 — source: Informix-list mailing list archive (1991-1998)

Does anybody know of an SQL script that would give me the names, size etc of all the temp tables that a session generates ?? One of our processess is really eating up temp space and I need to weed it out. Thanks Sujata ******************************************************************************** ***** Sujata Soman E-Mail: ssoman@omm.com Database Administrator ( Informix ) O'Melveny & Myers, Los Angeles ******************************************************************************** ******