1.查看各参数配置情况
select * from v$system_parameter;
2.查看数据库文件情况
select name from v$datafile;
3.查看日志文件情况
select member from v$logfile;
4.查看控制文件情况
select name from v$controlfile;
<!-- <rdf:RDF xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:trackback="http://madskills.com/public/xml/rss/module/trackback/"> <rdf:Description rdf:about="http://localhost:8082/pages/viewpage.action?pageId=1507339" dc:identifier="http://localhost:8082/pages/viewpage.action?pageId=1507339" dc:title="oracle中常用到的sql" trackback:ping="http://localhost:8082/rpc/trackback/1507339" /> </rdf:RDF> --><!-- Root decorator: this is a layer of abstraction that Confluence doesn't need. It will be removed eventually. -->