Home » RDBMS Server » Server Administration » temporary tablespace
temporary tablespace [message #179928] Thu, 29 June 2006 05:48 Go to next message
papu
Messages: 27
Registered: March 2005
Location: Dhaka
Junior Member
hello all

im using oracle 9ir1. my application has sepetate temptablespace
named eibstemp. all users are default to this tablespace.
it has 200 MB size, but shows o bytes during the transaction time in the enterprise manager. query is very slow. what may be the cause.

regards


papu

Report message to a moderator

Re: temporary tablespace [message #179941 is a reply to message #179928] Thu, 29 June 2006 06:24 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> all users are default to this tablespace.
default temporary tablespace right?
>> but shows o bytes during the transaction time in the enterprise manager. query is very slow. what may be the cause.
First understand what a temporary tablespace is used for.
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:374218170986

>>query is very slow. what may be the cause
http://www.orafaq.com/forum/t/51267/42800/

Report message to a moderator

Previous Topic: Oracle Not Available
Next Topic: LMT error
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 10:45:42 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.