oracle系统表1

----用户信息查询 select * from dba_users ----表空间查询 select * from dba_tablespaces ----查询空闲表空间 select tablespace_name,sum(bytes)/1024/1024/1024 as g,sum(blocks) from dba_free_space group by tablespace_name ----表空间对应的数据文件 select * from dba_data_files ----查看数据库对象 select * from dba_objects ----表 select * from dba_tables where table_name = 'DW_CUST_ORDER' ----索引 select * from dba_indexes ----索引列 select * from dba_ind_columns where taBLE_name = 'DW_CUST_ORDER' ----序列 select * from dba_sequences ----视图 select * from dba_views select * from all_views ----聚簇： select * from dba_clusters ----快照 select * from dba_snapshots ----同义词 select * from dba_synonyms ----数据库链接 select * from dba_db_links ----触发器 select * from dba_triggers ----作业 select * from user_jobs select * from dba_jobs ----正在运行的作业 select * from dba_jobs_running