OraFAQ Forum: Server Administration » view the segment temp

Home » RDBMS Server » Server Administration » view the segment temp

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

view the segment temp [message #150483]

Thu, 08 December 2005 02:12

raddisonlee
Messages: 29
Registered: March 2005

Junior Member

hi , i do select DISTINCT TABLESPACE_name from dba_segments ;

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
TABLESPACE_NAME
------------------------------
BLOCK
CWMLITE
DRSYS
EXAMPLE
ODM
RADDISON
SYSTEM
TOOLS
UNDOTBS1
USERS
XDB

11 rows selected.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
but cannot find what i want to ,i want to make it clear that how the temp segment work .
my d.b surely have the temp tablespace as follow ....
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
SQL> select tablespace_name from dba_tablespaces;

TABLESPACE_NAME
------------------------------
SYSTEM
UNDOTBS1
TEMP
CWMLITE
DRSYS
EXAMPLE
INDX
ODM
TOOLS
USERS
XDB

TABLESPACE_NAME
------------------------------
BLOCK
RADDISON

13 rows selected.

>>>>>>>>>>>>>>>>>>>>>>>>>>>
oracle 9.1.0.0 on win2k , thanks u

Report message to a moderator

Re: view the segment temp [message #150485 is a reply to message #150483]

Thu, 08 December 2005 02:25

kengheng
Messages: 5
Registered: July 2005

Junior Member

hi, start from 9i, oracle introduce Oracle-managed files include the temporary tablespace.
you can get more info about your temp data file as below:

select * from dba_temp_files

Report message to a moderator

Re: view the segment temp [message #150500 is a reply to message #150485]

Thu, 08 December 2005 03:43

raddisonlee
Messages: 29
Registered: March 2005

Junior Member

OH , THANKS FOR your replys.
" select * from V_$temp_EXTENT_MAP" that quary show me less .
AND , how can i find more imformations about temp segment on d.b?

Report message to a moderator

Re: view the segment temp [message #150539 is a reply to message #150500]

Thu, 08 December 2005 06:07

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96521/tspaces.htm#6314

Start reading documentation.

Report message to a moderator

Previous Topic:	superset of WE8MSWINI1252
Next Topic:	database from an export

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Feb 04 01:32:39 CST 2025