halo semua...
saya punya query seperti ini nih :
COL TABLESPACE_NAME FORMAT A15
COL NAME FORMAT A45
COL TOTAL_SIZE FORMAT 9,999,999,999,999.00
COL FREE_SPACE FORMAT 9,999,999,999,999.00
COL USED_SPACE FORMAT 9,999,999,999,999.00
SELECT
A.TABLESPACE_NAME,
B.BYTES TOTAL_SIZE,
A.FREE_SPACE,
B.BYTES - A.FREE_SPACE USED_SPACE,
B.NAME
FROM
(
SELECT
TABLESPACE_NAME,
SUM(BYTES) FREE_SPACE,
RELATIVE_FNO
FROM
DBA_FREE_SPACE
GROUP BY RELATIVE_FNO, TABLESPACE_NAME
) A,
V$DATAFILE B
WHERE
A.RELATIVE_FNO = B.FILE#
kalo dijalanin kok jalannya lambat banget,
baru 1 menitan lebih keluarnya...
aneh banget yah ?
ada yang bisa bantu ?
thanks
Adhika
--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: [EMAIL PROTECTED]
Website: http://indo-oracle.blogspot.com
-----------------------------------------------
Bergabung dengan Indonesia Thin Client User Groups,
Terminal Server, Citrix, New Moon Caneveral, di:
http://indo-thin.vze.com
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/indo-oracle/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
