Alo, Bisa diliat disini pak " Select * from v$temp_space_header;"
TEMP tablespace = Temporary tablespace, fungsinya untuk sorting area query singkatnya. Kalo ada aktifitas di database pasti active pak. Kalo ditanya kenapa dia aktif , yah di kudu dibaca dulu deh dokumentasi oracle yg jelasin panjang lebar :) Kalo mau di resize boleh2 aja pak, tp saran saya sesuaikan dengan keperluan dari transaksi di database. Kudu di monitor query2 yg memerlukan sorting yg sangat besar. Karena setelah querynya selesai biasanya space nya akan di release( some cases perlu restart DBnya). Semoga membantu yah :) cheers, Andrew ________________________________ From: aly rmb <[email protected]> To: [email protected] Sent: Monday, 6 April 2009 12:57:07 Subject: [indo-oracle] Tablespace Salam semua, SELECT * from DBA_SEGMENTS WHERE TABLESPACE_NAME = 'TEMP' ; query ini hasilnya : no rows selected. klo di lihat di foldernya, TABLESPACE TEMP ini aktive. kira* kenapa ya ? klo mau di resize, apakah ada masalah ? rencana mau di resize sesuai emailnya P'Doddy beberapa th yg lalu. (termasuk TABLESPACE UNDO) u/ resize sebaiknya berapa ya ? terimakasih sebelumnya. Salam/Ali Get your preferred Email name! Now you can @ymail.com and @rocketmail. com. http://mail. promotions. yahoo.com/ newdomains/ aa/ [Non-text portions of this message have been removed] New Email names for you! Get the Email name you've always wanted on the new @ymail and @rocketmail. Hurry before someone else does! http://mail.promotions.yahoo.com/newdomains/sg/ [Non-text portions of this message have been removed]
