查看数据库各种数据文件
系统环境:
1、操作系统:Windows 2000,机器内存128M
2、数据库: Oracle 8i R2 (8.1.6) for NT 企业版
3、安装路径:C:\ORACLE
实现方法:
SQL> set pages 100
SQL> col file_name form a60
SQL> col name form a60
SQL> col member form a50
SQL> col m0 form 99999 heading "Size (Mb)"
SQL>
SQL> spool datafile.lst
SQL>
1、查看数据文件
SQL> select file_name,bytes/(1024*1024) m0 from dba_data_files;
FILE_NAME Size (Mb)
------------------------------------------------------------ ---------
C:\ORACLE\ORADATA\ORADB\USERS01.DBF 20
C:\ORACLE\ORADATA\ORADB\DR01.DBF 20
C:\ORACLE\ORADATA\ORADB\TOOLS01.DBF 10
C:\ORACLE\ORADATA\ORADB\INDX01.DBF 20
C:\ORACLE\ORADATA\ORADB\RBS01.DBF 70
C:\ORACLE\ORADATA\ORADB\TEMP01.DBF 20
C:\ORACLE\ORADATA\ORADB\SYSTEM01.DBF 236
已选择7行。
2、查看控制文件
SQL> select NAME,status from v$controlfile;
NAME STATUS
------------------------------------------------------------ -------
C:\ORACLE\ORADATA\ORADB\CONTROL01.CTL
C:\ORACLE\ORADATA\ORADB\CONTROL02.CTL
C:\ORACLE\ORADATA\ORADB\CONTROL03.CTL
3、查看日志文件
SQL> select group#,member,status from v$logfile;
GROUP# MEMBER STATUS
---------- -------------------------------------------------- -------
1 C:\ORACLE\ORADATA\ORADB\REDO03.LOG STALE
2 C:\ORACLE\ORADATA\ORADB\REDO02.LOG
3 C:\ORACLE\ORADATA\ORADB\REDO01.LOG STALE
查看数据库的字符集
软件环境:
1、Windows NT4.0+ORACLE 8.0.4
2、ORACLE安装路径为:C:\ORANT
实现方法:
SQL> conn sys/change_on_install
SQL> desc props$
SQL> set arraysize 1
SQL> col value$ format a40 --格式化value$的输出为40个字符宽
SQL> select name,value$ from props$ where name='NLS_CHARACTERSET';
SQL> conn system/manager
SQL> select * from nls_database_parameters;
SQL> select * from V$NLS_PARAMETERS;
SQL> select * from nls_database_parameters;
PARAMETER VALUE
---------------------------------------- -------------------
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-YY
NLS_DATE_LANGUAGE AMERICAN
NLS_CHARACTERSET ZHS16GBK
NLS_SORT BINARY
NLS_NCHAR_CHARACTERSET ZHS16GBK
NLS_RDBMS_VERSION 8.0.4.0.0
查询到12记录.
SQL> select * from V$NLS_PARAMETERS;
PARAMETER VALUE
---------------------------------------- -------------------
NLS_LANGUAGE SIMPLIFIED CHINESE
NLS_TERRITORY CHINA
NLS_CURRENCY RMB
NLS_ISO_CURRENCY CHINA
NLS_NUMERIC_CHARACTERS .,
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-YY
NLS_DATE_LANGUAGE SIMPLIFIED CHINESE
NLS_CHARACTERSET ZHS16GBK
NLS_SORT BINARY
NLS_NCHAR_CHARACTERSET ZHS16GBK
查询到11记录.