| shahul |
Posted: Feb 18, 2008 08:17:43 AM |
Total Post: 17
Joined: Sep, 2007
|
Hi guys,
Is that possible to find out individual user's temporary space, who currently occupied space in database?
we have 30gb temporary space, when a user issue a particular query its get filled throws error, unable to extend
Can you please help me?
Regards,
shahul
|
|
|
 dd |
| Posted: Feb 18, 2008 11:20:04 PM |  |
|
Total Post: 14
Joined: Jan, 2007
|
Dear Friends:
It is not possible to know the individual users temporary table space, because we can assign a temporary table space to the database but not to the user.
We can have multiple temporary tablespace in a database but we assign a particular temporary table space to the database.
Please some body correct me if I am wrong
|
|
|
|
|
| Murtuja |
| Posted: Feb 19, 2008 12:28:14 AM | |
|
Total Post: 814
Joined: Jan, 2006
|
Hi,
http://www.jlcomp.demon.co.uk/faq/sort_user.html
HTH
|
|
|
|
|
| Kumar_Boss_APAC |
| Posted: Feb 19, 2008 05:44:20 AM | |
|
Total Post: 1
Joined: Feb, 2008
|
You go snd check in v$sort_usage
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
