Tablas que pueden tener problemas al crecer
1 view
Skip to first unread message
Wilo
Jan 23, 2007, 9:51:33 AM1/23/07
to Adminitración Oracle
SELECT owner || '.' || segment_name "Object Name", segment_type "Object
Type", next_extent / 1024 "Next Extent KB",
(SELECT MAX (BYTES) FROM SYS.dba_free_space WHERE tablespace_name =
'AMSD')/1024 "Max Extent KB"
FROM SYS.dba_segments
WHERE tablespace_name = 'AMSD'
AND next_extent > (SELECT MAX (BYTES)
FROM SYS.dba_free_space
WHERE tablespace_name = 'AMSD')
ORDER BY 3 DESC
Type", next_extent / 1024 "Next Extent KB",
(SELECT MAX (BYTES) FROM SYS.dba_free_space WHERE tablespace_name =
'AMSD')/1024 "Max Extent KB"
FROM SYS.dba_segments
WHERE tablespace_name = 'AMSD'
AND next_extent > (SELECT MAX (BYTES)
FROM SYS.dba_free_space
WHERE tablespace_name = 'AMSD')
ORDER BY 3 DESC
Reply all
Reply to author
Forward
0 new messages