Oracle Install#

블로그 & 커뮤니티#

환경 설정#

select * from nls_database_parameters

Oracle Trace#

oracle init.ora 파일에 sql_trace = true 추가
/oracle/product/8.1.7/bin/tkprof 
/oracle/admin/orcl/udump/ora_2995.trc 
/oracle/admin/orcl/udump/user.txt  
SYS=NO SORT=EXECPU -> 가장나쁜 Execute CPU값을 가진 통계값을 먼저 출력합니다.

Oracle 백업#

오라클 데이터 내려 받기
exp userid=아이디/패스워드 file='파일명' fully=y compress=y

오라클 데이터 올리기
imp userid=아이디/패스워드 file='파일명' fully=y

Add new attachment

Only authorized users are allowed to upload new attachments.

List of attachments

Kind Attachment Name Size Version Date Modified Author Change note
zip
Fedora6_oracle9i.zip 18,192.6 kB 1 17-May-2021 01:16 박동재
zip
Fedora6oracle10g.zip 1,571.4 kB 1 17-May-2021 01:16 박동재
« This page (revision-) was last changed on 17-5월-2021 01:16 by UnknownAuthor