Oracle数据库的配置与结构信息获取

QL> set line 130SQL> select name,created,log_mode,open_mode from v$database; NAME CREATED LOG_MODE OPEN_MODE------------------------------ ------------------------ ----------------------------------------MDSP 30-OCT-10 ARCHIVELOG READ WRITE SQL> col versionfor a20SQL> select host_name,instance_name,version from v$instance; HOST_NAME INSTANCE_NAME VERSION---------------------------------------------------- --------------------mdsps1 mdsp 11.2.0.1.0 SQL> select *from v$version; BANNER----------------------------------------------------------------------------------------------------------------------------------Oracle Database 11gEnterprise Edition Release 11.2.0.1.0 - 64bit ProductionPL/SQL Release11.2.0.1.0 - ProductionCORE 11.2.0.1.0 ProductionTNS for Linux:Version 11.2.0.1.0 - ProductionNLSRTL Version11.2.0.1.0 – Production SQL> / BANNER--------------------------------------------------------------------------------Oracle Database 11gEnterprise Edition Release 11.2.0.1.0 - 64bit ProductionPL/SQL Release11.2.0.1.0 - ProductionCORE 11.2.0.1.0 ProductionTNS for Linux:Version 11.2.0.1.0 - ProductionNLSRTL Version11.2.0.1.0 – ProductionSQL> select *from v$controlfile; STATUS NAME IS_REC BLOCK_SIZE FILE_SIZE_BLKS---------------------------------------------------------------- ------ ------------------------ /home/oracle/oracle/oradata/mdsp/control01.ctl NO 16384 606 /home/oracle/oracle/recovery_area/mdsp/control02.c NO 16384 606 TlSQL> select group#,members,bytes,status,archived from v$log; GROUP# MEMBERS BYTES STATUS ARCHIV-------------------- ---------- -------------------------------- ------ 1 1 524288000 INACTIVE YES 2 1 524288000 CURRENT NO 3 1 524288000 INACTIVE YESSQL> col member for a50SQL> select *from v$logfile; GROUP# STATUS TYPE MEMBER IS_REC------------------------ ---------------------------------------------------------------- ------ 3 ONLINE /home/oracle/oracle/oradata/mdsp/redo03.log NO 2 ONLINE /home/oracle/oracle/oradata/mdsp/redo02.log NO 1 ONLINE /home/oracle/oracle/oradata/mdsp/redo01.log NOSQL> archive loglist;Database logmode Archive ModeAutomaticarchival EnabledArchivedestination /home/oracle/archivelogOldest online logsequence 30Next log sequenceto archive 32Current logsequence 32SQL> coltablespace_name for a15SQL> selecttablespace_name,block_size,status,contents,logging from dba_tablespaces; TABLESPACE_NAMEBLOCK_SIZE STATUS CONTENTS LOGGING------------------------- ------------------ ------------------ ------------------SYSTEM 8192 ONLINE PERMANENT LOGGINGSYSAUX 8192 ONLINE PERMANENT LOGGINGUNDOTBS1 8192 ONLINE UNDO LOGGINGTEMP 8192 ONLINE TEMPORARY NOLOGGINGUSERS 8192 ONLINE PERMANENT LOGGINGZCHBKJ 8192 ONLINE PERMANENT LOGGING 6 rows selected.SQL> col file_name for a50SQL> select file_id,file_name,tablespace_name,status,bytesfrom dba_data_files; FILE_ID FILE_NAME TABLESPACE_NAME STATUS BYTES------------------------------------------------------------ --------------- ---------------------------- 4/home/oracle/oracle/oradata/mdsp/users01.dbf USERS AVAILABLE 36241408000 3/home/oracle/oracle/oradata/mdsp/undotbs01.dbf UNDOTBS1 AVAILABLE 99614720 2 /home/oracle/oracle/oradata/mdsp/sysaux01.dbf SYSAUX AVAILABLE 744488960 1/home/oracle/oracle/oradata/mdsp/system01.dbf SYSTEM AVAILABLE 765460480 5/home/oracle/oracle/oradata/mdsp/ZCHBKJ.dbf ZCHBKJ AVAILABLE 524288000SQL> select username,created from dba_users; USERNAME CREATED------------------------------------------------------------------------MGMT_VIEW 15-AUG-09SYSTEM 15-AUG-09DBSNMP 15-AUG-09SYSMAN 15-AUG-09IMUSE01 30-OCT-10ZCH 10-NOV-10SYS 15-AUG-09OUTLN 15-AUG-09FLOWS_FILES 15-AUG-09MDSYS 15-AUG-09ORDSYSOracle判断数据或字段是否存在处理Linux下MySQL 5.5的Cmake安装以及Sphinx结合相关资讯 Oracle教程

Oracle中纯数字的varchar2类型和（07/29/2015 07:20:43）
Oracle教程：Oracle中查看DBLink密（07/29/2015 07:16:55）
[Oracle] SQL*Loader 详细使用教程（08/11/2013 21:30:36）

Oracle教程：Oracle中kill死锁进程（07/29/2015 07:18:28）
Oracle教程：ORA-25153 临时表空间（07/29/2015 07:13:37）
Oracle教程之管理安全和资源（04/08/2013 11:39:32）

本文评论查看全部评论（0）