Pak Andrew, nah! ini masalahnya, blum tahu cara monitoring querynya :) Klo resizenya kekecilan, apa pengaruhnya ? lebih lambat atau apa ? klo resizenya kebesaran, kemungkinannya ngga' ada masalahkan ? atau menurut emailnya P'Doddi Priyambodo, gemana klo di set 10M ? semalam Tablespace UNDO, sudah sy set jd 10M dan sukses. thanks .. Salam/Aly
--- On Tue, 7/4/09, Andrew E.K. <[email protected]> wrote: From: Andrew E.K. <[email protected]> Subject: Re: [indo-oracle] Tablespace To: [email protected] Date: Tuesday, 7 April, 2009, 8:51 AM 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 <aly_...@yahoo. com> To: indo-oracle@ yahoogroups. com 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] 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]
