oracle中常用到的sql

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. -->