Thanks, Art. I restarted an instance this week that had left a pair of huge files behind. Removing them didn't release space as they were still open as shown by "lsof". Next time, I'll see if the session is still running. If so, I'll terminate it with "onmode -z". If not, I'll have something better to raise a support case with "onstat -a" output.
------------------------------
Doug Lawry
Oninit Consulting
------------------------------
Original Message:
Sent: Thu March 02, 2023 06:57 AM
From: Art Kagel
Subject: Get session ID of file in $PSORT_DBTEMP
Doug:
Sort file: srt0010527_001 belongs to the session with sqlexec thread # 527
Ordinal sqlexec Ordinal
Sort # Thread # File #
---------- -------- ----------
srt 001 0527 _001
Art
------------------------------
Art S. Kagel, President and Principal Consultant
ASK Database Management Corp.
www.askdbmgt.com
Original Message:
Sent: Thu March 02, 2023 03:02 AM
From: Doug Lawry
Subject: Get session ID of file in $PSORT_DBTEMP
Can someone remind me?!
------------------------------
Doug Lawry
Oninit Consulting
------------------------------