what you are using? SHUTDOWN immediate or just SHUTDOWN ? Is your temporary tablespace created as temp/permannet ? Check contents in DBA_TABLESPACES view.

If you see your TEMP tablespace usage while database is up and runnig... you can see the size of temp segments increase and decrease...cuz, TEMP will be used for sorting purpose..



[Edited by sreddy on 12-27-2000 at 07:45 PM]