mysql> use information_schema; mysql> select file_name,file_type,logfile_group_number,free_extents,total_extents,extra from files where file_type='UNDO LOG'; +------------+-----------+----------------------+--------------+---------------+-------------------------------------------+ | file_name  | file_type | logfile_group_number | free_extents | total_extents | extra                                     | +------------+-----------+----------------------+--------------+---------------+-------------------------------------------+ | undo_2.log | UNDO LOG  |                   10 |         NULL |    2499993600 | CLUSTER_NODE=30;UNDO_BUFFER_SIZE=50003968 | | undo_1.log | UNDO LOG  |                   10 |         NULL |    2499993600 | CLUSTER_NODE=30;UNDO_BUFFER_SIZE=50003968 | | NULL       | UNDO LOG  |                   10 |   4703294591 |          NULL | UNDO_BUFFER_SIZE=50003968                 | +------------+-----------+----------------------+--------------+---------------+-------------------------------------------+ 3 rows in set (0.01 sec) 查询data_file  select file_name,file_type,logfile_group_number,free_extents,total_extents,extra from files where file_type='DATAFILE';

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/28371090/viewspace-1100536/，如需转载，请注明出处，否则将追究法律责任。