오라클 구조 파일보기
Oracle/OracleDB_SQL 2016. 5. 31. 21:46
SYS @ prod > show sga
Total System Global Area 1071333376 bytes
Fixed Size 1375792 bytes
Variable Size 545259984 bytes
Database Buffers 520093696 bytes
Redo Buffers 4603904 bytes
SYS @ prod >
SYS @ prod > show parameter memory_target
NAME TYPE VALUE
------------------------------------ ----------- -------
memory_target big integer 1232M
SYS @ prod > show parameter sga_target
NAME TYPE VALUE
------------------------------------ ----------- ------
sga_target big integer 0
SYS @ prod >
SYS @ prod > show parameter shared_pool_size
NAME TYPE VALUE
------------------------------------ ----------- ------
shared_pool_size big integer 0
***************************************************************
데이터베이스 영역
***************************************************************
SYS @ prod > select name from v$datafile;
NAME
--------------------------------------------------------------
D:\APP\ADMINISTRATOR\ORADATA\PROD\SYSTEM01.DBF
D:\APP\ADMINISTRATOR\ORADATA\PROD\SYSAUX01.DBF
D:\APP\ADMINISTRATOR\ORADATA\PROD\UNDOTBS01.DBF
D:\APP\ADMINISTRATOR\ORADATA\PROD\USERS01.DBF
D:\APP\ADMINISTRATOR\ORADATA\PROD\EXAMPLE01.DBF
SYS @ prod > select name from v$controlfile;
NAME
--------------------------------------------------------------
D:\APP\ADMINISTRATOR\ORADATA\PROD\CONTROL01.CTL
D:\APP\ADMINISTRATOR\FLASH_RECOVERY_AREA\PROD\CONTROL02.CTL
SYS @ prod > select member from v$logfile;
MEMBER
--------------------------------------------------------------
D:\APP\ADMINISTRATOR\ORADATA\PROD\REDO03.LOG
D:\APP\ADMINISTRATOR\ORADATA\PROD\REDO02.LOG
D:\APP\ADMINISTRATOR\ORADATA\PROD\REDO01.LOG
***************************************************************
원격지 접속
***************************************************************
C:\Users\Administrator>sqlplus expert/expert@prod
SQL*Plus: Release 11.2.0.1.0 Production on Tue May 31 17:11:51 2016
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
***************************************************************
리스너 없을때
***************************************************************
C:\Users\Administrator>tnsping prod
TNS Ping Utility for 32-bit Windows: Version 11.2.0.1.0 - Production on 31-MAY-2016 17:14:02
Copyright (c) 1997, 2010, Oracle. All rights reserved.
Used parameter files:
D:\app\Administrator\product\11.2.0\dbhome_1\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = prod)))
TNS-12541: TNS:no listener
C:\Users\Administrator>
C:\Users\Administrator>
C:\Users\Administrator>sqlplus expert/expert@prod
SQL*Plus: Release 11.2.0.1.0 Production on Tue May 31 17:14:25 2016
Copyright (c) 1982, 2010, Oracle. All rights reserved.
ERROR:
