Database Tuning (MOSC)

MOSC Banner

Temp segment uses

edited Jul 12, 2010 2:12AM in Database Tuning (MOSC) 1 commentAnswered
 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_US

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center