Temp segment uses
Hi All,
I want to know the temp segment usage by user's session.How I can know the exact status.
USERNAME ACCOUNT_STATUS DEFAULT_TABLESPACE TEMPORARY_TABLESPACE ----------- -------------------------------- ------------------------------ ------------------------------ SYS OPEN SYSTEM TEMP SYSTEM OPEN SYSTEM TEMP OUTLN OPEN SYSTEM TEMP DECOMP_USER OPEN DATA1 TEMP BFG_PPSR_DB OPEN USERS TEMP LINK PPSR_OWNER OPEN DATA1 TEMP ORACLE OPEN DATA1 TEMP DBAMENU OPEN USERS TEMP BASHEEA OPEN DATA1 TEMP QUOTE_OWNER OPEN DATA1 TEMP PPSR_OWNER_ OPEN DATA1 TEMP ARCH DBSNMP OPEN TOOLS TEMP TMP_IMPL OPEN USERS TEMP PPSR_BULKLO OPEN DATA1 TEMP ADER PPSR_VER2 OPEN DATA1 TEMP PPSR_VER1 OPEN DATA1 TEMP PPSR_VERSIO OPEN DATA1 TEMP N_ADMIN PPSR_READON OPEN USERS TEMP LY PERFSTAT OPEN STATSPACK_DATA TEMP CSDRA_PPSR_ OPEN USERS TEMP DBLINK GSEDW_READ_ OPEN USERS TEMP USER SPORT_USER OPEN USERS TEMP BASEDEF OPEN TOOLS TEMP OSAT_USER OPEN DATA1 TEMP PMS_USER OPEN DATA1 TEMP DERBYDBA OPEN TOOLS TEMP COT_OWNER OPEN DATA1 TEMP PPSR_CPE_US OPEN DATA2 TEMP ER ALPT_OWNER OPEN PRICE_INFO_DATA TEMP PPSR_VIEW_A OPEN DATA1 TEMP LL PPSR_BTQM_U OPEN DATA1 TEMP SER PPSR_PMS_US0