2017. 2. 28. 23:13 오라클
'분류 전체보기'에 해당되는 글 1023건
- 2017.02.28 oracle 12cR2(12.2.0.1) 출시 - 2017년 3월 1일
- 2017.02.19 oracle 12.2.0.1 Release 되다. (For Exadata)
- 2017.01.25 linux 7 rac 설치시 에러
- 2017.01.04 오라클 Backgroud Process 확인하는 쿼리
- 2016.12.27 lenovo x250 16G 메모리 업그레이드 완료 1
- 2016.12.05 dbca database drop
- 2016.10.28 빠른 vip failover 를 위한 IPC address의 배치 1
- 2016.10.27 Nuno 의 "Midnight express"
- 2016.10.21 MySQL vs Oracle Data Type 비교 1
- 2016.10.20 oracle recyclebin 기간별로 지우기
2017. 2. 19. 20:57 오라클
oracle 12.2.0.1 Release 되다. (For Exadata)
Oracle 12cR2 vesion 이 Exadata Version 용으로 1주일전에 조용하게 Release 되었다.
현재 Oracle Database Enterprise Edition 12.2.0.1 For Linux x86-64 만 가능한듯 하다. (Standard 도 별도 다운 가능한듯)
Non Exadata 환경에서도 테스트는 가능할듯 싶은데 이래저래 시간이 없네..
2017.2.10 Release 되었고 Oracle 계정만 있다면 edelivery.oracle.com 에서 다운로드 사용가능하다.
- Non Exadata 환경에서 실행시켜 본 모습
- edelivery.oracle.com 에 올라온 모습
2017. 1. 25. 16:59 오라클
linux 7 rac 설치시 에러
linux 7.x 에서 11.2.0.4 RAC 설치시 root.sh 실행후 에러 발생 할때...
------------------------------------------------------------------
Creating /etc/oratab file...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Using configuration parameter file: /oragrid/product/11.2.0.4/crs/install/crsconfig_params
Creating trace directory
User ignored Prerequisites during installation
Installing Trace File Analyzer
OLR initialization - successful
root wallet
root wallet cert
root cert export
peer wallet
profile reader wallet
pa wallet
peer wallet keys
pa wallet keys
peer cert request
pa cert request
peer cert
pa cert
peer root cert TP
profile reader root cert TP
pa root cert TP
peer pa cert TP
pa peer cert TP
profile reader pa cert TP
profile reader peer cert TP
peer user cert
pa user cert
Adding Clusterware entries to inittab
ohasd failed to start
Failed to start the Clusterware. Last 20 lines of the alert log follow:
2016-06-23 12:45:29.782:
> CRS-4530: Communications failure contacting Cluster Synchronization Services daemon
>End Command output
2016-06-23 16:25:13: Starting CSS in exclusive mode
2016-06-23 16:25:13: Executing cmd: /oragrid/product/11.2.0.4/bin/crsctl start resource ora.cssd -init -env CSSD_MODE=-X
2016-06-23 16:25:34: Command output:
해결책 : root.sh 실행전 patch 18370031 먼저 적용 !!
압축풀고 opatch napply -oh $GRID_HOME -local ./18370031
적용되면 root.sh 실행 !! 끝
2017. 1. 4. 15:21 오라클
오라클 Backgroud Process 확인하는 쿼리
ora_nsa2 Process 에 대해서 찾아보다가..Online redo log를 standby server 로 전송하는 역할이고..
오라클의 X$ 뷰를 통해서 Background 프로세스의 이름 및 용도를 확인하는 방법까지..
11.2.0.4 기준 (297개 확인가능, 내가 만든 TEST instance 포함)
--------------------------------------------------------------------------------
set lines 120
column EXTERNAL_NAME format a13
column INTERNAL_NAME format a13
column DESCRIPTION format a50
SELECT x$ksbdd.ksbddidn AS external_name,
x$ksmfsv.ksmfsnam AS internal_name, x$ksbdd.ksbdddsc AS description
FROM x$ksbdd, x$ksbdp, x$ksmfsv
WHERE x$ksbdd.indx = x$ksbdp.indx AND x$ksbdp.addr = x$ksmfsv.ksmfsadr
ORDER BY 1;
EXTERNAL_NAME INTERNAL_NAME DESCRIPTION
------------- ------------- --------------------------------------------------
ABMR krbabrBgProc_ Auto BMR Background Process
ACFS kfofsbg_ ACFS CSS
ACMS ksacms_ Atomic Controlfile to Memory Server
ARB0 kfgbr0_ ASM Rebalance 0
ARB1 kfgbr1_ ASM Rebalance 1
ARB2 kfgbr2_ ASM Rebalance 2
ARB3 kfgbr3_ ASM Rebalance 3
ARB4 kfgbr4_ ASM Rebalance 4
ARB5 kfgbr5_ ASM Rebalance 5
ARB6 kfgbr6_ ASM Rebalance 6
ARB7 kfgbr7_ ASM Rebalance 7
ARB8 kfgbr8_ ASM Rebalance 8
ARB9 kfgbr9_ ASM Rebalance 9
ARBA kfgbrA_ ASM Rebalance 10
ARC0 kcrrd0_ Archival Process 0
ARC1 kcrrd1_ Archival Process 1
ARC2 kcrrd2_ Archival Process 2
ARC3 kcrrd3_ Archival Process 3
ARC4 kcrrd4_ Archival Process 4
ARC5 kcrrd5_ Archival Process 5
ARC6 kcrrd6_ Archival Process 6
ARC7 kcrrd7_ Archival Process 7
ARC8 kcrrd8_ Archival Process 8
ARC9 kcrrd9_ Archival Process 9
ARCa kcrrdxa_ Archival Process 10
ARCb kcrrdxb_ Archival Process 11
ARCc kcrrdxc_ Archival Process 12
ARCd kcrrdxd_ Archival Process 13
ARCe kcrrdxe_ Archival Process 14
ARCf kcrrdxf_ Archival Process 15
ARCg kcrrdxg_ Archival Process 16
ARCh kcrrdxh_ Archival Process 17
ARCi kcrrdxi_ Archival Process 18
ARCj kcrrdxj_ Archival Process 19
ARCk kcrrdxk_ Archival Process 20
ARCl kcrrdxl_ Archival Process 21
ARCm kcrrdxm_ Archival Process 22
ARCn kcrrdxn_ Archival Process 23
ARCo kcrrdxo_ Archival Process 24
ARCp kcrrdxp_ Archival Process 25
ARCq kcrrdxq_ Archival Process 26
ARCr kcrrdxr_ Archival Process 27
ARCs kcrrdxs_ Archival Process 28
ARCt kcrrdxt_ Archival Process 29
ASMB kfnbgd_ ASM Background
CJQ0 kkjcjq0_ Job Queue Coordinator
CKPT kcvcdp_ checkpoint
CTWR krcbgp_ Change Tracking Writer
DBRM kskdbrm_ DataBase Resource Manager
DBW0 kcbdw0_ db writer process 0
DBW1 kcbdw1_ db writer process 1
DBW2 kcbdw2_ db writer process 2
DBW3 kcbdw3_ db writer process 3
DBW4 kcbdw4_ db writer process 4
DBW5 kcbdw5_ db writer process 5
DBW6 kcbdw6_ db writer process 6
DBW7 kcbdw7_ db writer process 7
DBW8 kcbdw8_ db writer process 8
DBW9 kcbdw9_ db writer process 9
DBWa kcbdw10_ db writer process 10 (a)
DBWb kcbdw11_ db writer process 11 (b)
DBWc kcbdw12_ db writer process 12 (c)
DBWd kcbdw13_ db writer process 13 (d)
DBWe kcbdw14_ db writer process 14 (e)
DBWf kcbdw15_ db writer process 15 (f)
DBWg kcbdw16_ db writer process 16 (g)
DBWh kcbdw17_ db writer process 17 (h)
DBWi kcbdw18_ db writer process 18 (i)
DBWj kcbdw19_ db writer process 19 (j)
DBWk kcbdw20_ db writer process 20 (k)
DBWl kcbdw21_ db writer process 21 (l)
DBWm kcbdw22_ db writer process 22 (m)
DBWn kcbdw23_ db writer process 23 (n)
DBWo kcbdw24_ db writer process 24 (o)
DBWp kcbdw25_ db writer process 25 (p)
DBWq kcbdw26_ db writer process 26 (q)
DBWr kcbdw27_ db writer process 27 (r)
DBWs kcbdw28_ db writer process 28 (s)
DBWt kcbdw29_ db writer process 29 (t)
DBWu kcbdw30_ db writer process 30 (u)
DBWv kcbdw31_ db writer process 31 (v)
DBWw kcbdw32_ db writer process 32 (w)
DBWx kcbdw33_ db writer process 33 (x)
DBWy kcbdw34_ db writer process 34 (y)
DBWz kcbdw35_ db writer process 35 (z)
DIA0 kjzdtp0_ diagnosibility process 0
DIA1 kjzdtp1_ diagnosibility process 1
DIA2 kjzdtp2_ diagnosibility process 2
DIA3 kjzdtp3_ diagnosibility process 3
DIA4 kjzdtp4_ diagnosibility process 4
DIA5 kjzdtp5_ diagnosibility process 5
DIA6 kjzdtp6_ diagnosibility process 6
DIA7 kjzdtp7_ diagnosibility process 7
DIA8 kjzdtp8_ diagnosibility process 8
DIA9 kjzdtp9_ diagnosibility process 9
DIAG kstdtp_ diagnosibility process
DMON rfm_dmon_proc DG Broker Monitor Process
_
DSKM kszdskmp_ slave DiSKMon process
EMNC kponc_ EMON Coordinator
FBDA ktfaarch_ Flashback Data Archiver Process
FMON ksfmfmon_ File Mapping Monitor Process
FSFP rfi_fsfp_ Data Guard Broker FSFO Pinger
GEN0 ksbgen0_ generic0
GMON kfdp_gmon_ diskgroup monitor
GTX0 k2qgtx0_ Global Txn process 0
GTX1 k2qgtx1_ Global Txn process 1
GTX2 k2qgtx2_ Global Txn process 2
GTX3 k2qgtx3_ Global Txn process 3
GTX4 k2qgtx4_ Global Txn process 4
GTX5 k2qgtx5_ Global Txn process 5
GTX6 k2qgtx6_ Global Txn process 6
GTX7 k2qgtx7_ Global Txn process 7
GTX8 k2qgtx8_ Global Txn process 8
GTX9 k2qgtx9_ Global Txn process 9
GTXa k2qgtx10_ Global Txn process 10
GTXb k2qgtx11_ Global Txn process 11
GTXc k2qgtx12_ Global Txn process 12
GTXd k2qgtx13_ Global Txn process 13
GTXe k2qgtx14_ Global Txn process 14
GTXf k2qgtx15_ Global Txn process 15
GTXg k2qgtx16_ Global Txn process 16
GTXh k2qgtx17_ Global Txn process 17
GTXi k2qgtx18_ Global Txn process 18
GTXj k2qgtx19_ Global Txn process 19
INSV rfi_insv_ Data Guard Broker INstance SlaVe Process
LCK0 kclck0_ Lock Process 0
LGWR kcrprc_ Redo etc.
LMD0 kjid0_ global enqueue service daemon 0
LMHB kjfmhdm_ lm heartbeat monitor
LMON kjidm_ global enqueue service monitor
LMS0 kjmlms0_ global cache service process 0
LMS1 kjmlms1_ global cache service process 1
LMS2 kjmlms2_ global cache service process 2
LMS3 kjmlms3_ global cache service process 3
LMS4 kjmlms4_ global cache service process 4
LMS5 kjmlms5_ global cache service process 5
LMS6 kjmlms6_ global cache service process 6
LMS7 kjmlms7_ global cache service process 7
LMS8 kjmlms8_ global cache service process 8
LMS9 kjmlms9_ global cache service process 9
LMSa kjmlmsa_ global cache service process 10
LMSb kjmlmsb_ global cache service process 11
LMSc kjmlmsc_ global cache service process 12
LMSd kjmlmsd_ global cache service process 13
LMSe kjmlmse_ global cache service process 14
LMSf kjmlmsf_ global cache service process 15
LMSg kjmlmsg_ global cache service process 16
LMSh kjmlmsh_ global cache service process 17
LMSi kjmlmsi_ global cache service process 18
LMSj kjmlmsj_ global cache service process 19
LMSk kjmlmsk_ global cache service process 20
LMSl kjmlmsl_ global cache service process 21
LMSm kjmlmsm_ global cache service process 22
LMSn kjmlmsn_ global cache service process 23
LMSo kjmlmso_ global cache service process 24
LMSp kjmlmsp_ global cache service process 25
LMSq kjmlmsq_ global cache service process 26
LMSr kjmlmsr_ global cache service process 27
LMSs kjmlmss_ global cache service process 28
LMSt kjmlmst_ global cache service process 29
LMSu kjmlmsu_ global cache service process 30
LMSv kjmlmsv_ global cache service process 31
LMSw kjmlmsw_ global cache service process 32
LMSx kjmlmsx_ global cache service process 33
LMSy kjmlmsy_ global cache service process 34
LSP0 dgllsp_ Logical Standby
LSP1 dgldbp_ Dictionary build process for Logical Standby
LSP2 dglsgsp_ Set Guard Standby Information for Logical Standby
MARK kfioSr_markp_ mark AU for resync koordinator
MMAN kmgsdp_ Memory Manager
MMNL kebmmnl_ Manageability Monitor Process 2
MMON kebmmon_ Manageability Monitor Process
MRP0 krsmmrp_ Managed Standby Recovery
NSA1 krswnsa1_ Redo transport NSA1
NSA2 krswnsa2_ Redo transport NSA2
NSA3 krswnsa3_ Redo transport NSA3
NSA4 krswnsa4_ Redo transport NSA4
NSA5 krswnsa5_ Redo transport NSA5
NSA6 krswnsa6_ Redo transport NSA6
NSA7 krswnsa7_ Redo transport NSA7
NSA8 krswnsa8_ Redo transport NSA8
NSA9 krswnsa9_ Redo transport NSA9
NSAA krswnsa10_ Redo transport NSAA
NSAB krswnsa11_ Redo transport NSAB
NSAC krswnsa12_ Redo transport NSAC
NSAD krswnsa13_ Redo transport NSAD
NSAE krswnsa14_ Redo transport NSAE
NSAF krswnsa15_ Redo transport NSAF
NSAG krswnsa16_ Redo transport NSAG
NSAH krswnsa17_ Redo transport NSAH
NSAI krswnsa18_ Redo transport NSAI
NSAJ krswnsa19_ Redo transport NSAJ
NSAK krswnsa20_ Redo transport NSAK
NSAL krswnsa21_ Redo transport NSAL
NSAM krswnsa22_ Redo transport NSAM
NSAN krswnsa23_ Redo transport NSAN
NSAO krswnsa24_ Redo transport NSAO
NSAP krswnsa25_ Redo transport NSAP
NSAQ krswnsa26_ Redo transport NSAQ
NSAR krswnsa27_ Redo transport NSAR
NSAS krswnsa28_ Redo transport NSAS
NSAT krswnsa29_ Redo transport NSAT
NSAU krswnsa30_ Redo transport NSAU
NSAV krswnsa31_ Redo transport NSAV
NSS1 krswnss1_ Redo transport NSS1
NSS2 krswnss2_ Redo transport NSS2
NSS3 krswnss3_ Redo transport NSS3
NSS4 krswnss4_ Redo transport NSS4
NSS5 krswnss5_ Redo transport NSS5
NSS6 krswnss6_ Redo transport NSS6
NSS7 krswnss7_ Redo transport NSS7
NSS8 krswnss8_ Redo transport NSS8
NSS9 krswnss9_ Redo transport NSS9
NSSA krswnss10_ Redo transport NSSA
NSSB krswnss11_ Redo transport NSSB
NSSC krswnss12_ Redo transport NSSC
NSSD krswnss13_ Redo transport NSSD
NSSE krswnss14_ Redo transport NSSE
NSSF krswnss15_ Redo transport NSSF
NSSG krswnss16_ Redo transport NSSG
NSSH krswnss17_ Redo transport NSSH
NSSI krswnss18_ Redo transport NSSI
NSSJ krswnss19_ Redo transport NSSJ
NSSK krswnss20_ Redo transport NSSK
NSSL krswnss21_ Redo transport NSSL
NSSM krswnss22_ Redo transport NSSM
NSSN krswnss23_ Redo transport NSSN
NSSO krswnss24_ Redo transport NSSO
NSSP krswnss25_ Redo transport NSSP
NSSQ krswnss26_ Redo transport NSSQ
NSSR krswnss27_ Redo transport NSSR
NSSS krswnss28_ Redo transport NSSS
NSST krswnss29_ Redo transport NSST
NSSU krswnss30_ Redo transport NSSU
NSSV krswnss31_ Redo transport NSSV
NSV0 rfins0_ Data Guard Broker NetSlave Process 0
NSV1 rfins1_ Data Guard Broker NetSlave Process 1
NSV2 rfins2_ Data Guard Broker NetSlave Process 2
NSV3 rfins3_ Data Guard Broker NetSlave Process 3
NSV4 rfins4_ Data Guard Broker NetSlave Process 4
NSV5 rfins5_ Data Guard Broker NetSlave Process 5
NSV6 rfins6_ Data Guard Broker NetSlave Process 6
NSV7 rfins7_ Data Guard Broker NetSlave Process 7
NSV8 rfins8_ Data Guard Broker NetSlave Process 8
NSV9 rfins9_ Data Guard Broker NetSlave Process 9
NSVA rfinsa_ Data Guard Broker NetSlave Process A
NSVB rfinsb_ Data Guard Broker NetSlave Process B
NSVC rfinsc_ Data Guard Broker NetSlave Process C
NSVD rfinsd_ Data Guard Broker NetSlave Process D
NSVE rfinse_ Data Guard Broker NetSlave Process E
NSVF rfinsf_ Data Guard Broker NetSlave Process F
NSVG rfinsg_ Data Guard Broker NetSlave Process G
NSVH rfinsh_ Data Guard Broker NetSlave Process H
NSVI rfinsi_ Data Guard Broker NetSlave Process I
NSVJ rfinsj_ Data Guard Broker NetSlave Process J
NSVK rfinsk_ Data Guard Broker NetSlave Process K
NSVL rfinsl_ Data Guard Broker NetSlave Process L
NSVM rfinsm_ Data Guard Broker NetSlave Process M
NSVN rfinsn_ Data Guard Broker NetSlave Process N
NSVO rfinso_ Data Guard Broker NetSlave Process O
NSVP rfinsp_ Data Guard Broker NetSlave Process P
NSVQ rfinsq_ Data Guard Broker NetSlave Process Q
NSVR rfinsr_ Data Guard Broker NetSlave Process R
NSVS rfinss_ Data Guard Broker NetSlave Process S
NSVT rfinst_ Data Guard Broker NetSlave Process T
NSVU rfinsu_ Data Guard Broker NetSlave Process U
PING ksxp_ping_ interconnect latency measurement
PMON ksuclp_ process cleanup
PSP0 kso_spawner0_ process spawner 0
QMNC kwqmnc_ AQ Coordinator
RBAL kfgbrm_ ASM Rebalance master
RCBG qesrcbg_ Result Cache: Background
RECO k2vbkg_ distributed recovery
RMS0 kjmrms0_ rac management server
RPOP ksfdss_repop_ instant restore repopulation daemon
RSM0 rfrmp0_ Data Guard Broker Resource Guard Process 0
RSMN ksvrrp_ Remote Slave Monitor
RVWR krfwrp_ Recovery Writer
SMCO ktsjsmco_ Space Manager Process
SMON ktmprc_ System Monitor Process
TEST ksbtstp_ test background process
VBG0 kfvbg0_ Volume BG 0
VBG1 kfvbg1_ Volume BG 1
VBG2 kfvbg2_ Volume BG 2
VBG3 kfvbg3_ Volume BG 3
VBG4 kfvbg4_ Volume BG 4
VBG5 kfvbg5_ Volume BG 5
VBG6 kfvbg6_ Volume BG 6
VBG7 kfvbg7_ Volume BG 7
VBG8 kfvbg8_ Volume BG 8
VBG9 kfvbg9_ Volume BG 9
VDBG kfvdbg_ Volume Driver BG
VKRM kskvkrm_ Virtual sKeduler for Resource Manager
VKTM kstmvktm_ Virtual Keeper of TiMe process
VMB0 kfvmb0_ Volume Membership 0
XDMG kxdam_mgr_ cell automation manager
XDWK kxdam_slvbg_ cell automation worker actions
297 rows selected.
2016. 12. 27. 00:45 아무거나
lenovo x250 16G 메모리 업그레이드 완료
지금 쓰는 노트북이 레노버 X250 이란 모델이다.
VM 환경을 많이 쓰다보니 슬슬 메모리가 딸려서 불만이였는데..
이게 거지 같은게 비교적 최신 모델임에도 메모리 슬롯이 하나에 8G 짜리 한개만 꼽을수 있다.
걔다가 요즘 많이 쓰는 DDR4 Type이 아니라 DDR3 Type 이다.
폭풍검색해보니 DDR4 와 DDR3 는 소켓규격이 다르다. 슬슬 짜증
검색해보니 가격도 비싼데다가 DDR3 16G는 국내 쇼핑몰에서 파는 곳이 없음. 귀찮아..
할수 없이 해외구매로 이베이에서 파는 업자를 찾았다. 콕 찝어서 X250 전용이라고 써 있다.
http://www.ebay.com/itm/191609325156?ssPageName=STRK:MESINDXX:IT&_trksid=p3984.m1436.l2649
아..근데 이베이를 가입해야 되서...가입하기 귀찮아...미친척 하고 guest 로 그냥 주문했다..
다행히 멀리 미국에서 뱅기 타고 1주일 만에 우체국 Express 로 무사히 도착..^^
메모리가 99$ 인데 배송료가 54$..환율보소...눙물이 T.T
어찌됐건 노트북 분해하고 업글 시작..
전체 뒷판을 다 뜯어야 한다. 귀찮아..왜 이따구로 만들었어
나사 몇개 풀면 오른쪽 중간에 하이닉스 8G 메모가 있다.
이 녀석은 이제 버리고 16G 로 갈아끼움
얜 USA 라고만 나와있지 어디 회사껀지는 모르겠다.
어쨌든 뚜껑 덮고 조립해서 부팅 후 F1 눌러서 16G 인식되는거 확인 !!
업그레이드 완료~
X250 메모리 업그레이드 고민하시는 분들에게 조금이나마 도움이 되었으면 합니다.
2016. 12. 5. 11:46 오라클
dbca database drop
2016. 10. 28. 11:15 오라클
빠른 vip failover 를 위한 IPC address의 배치
가끔씩 Listener 를 셋팅할때 아무생각없이 이렇게 셋팅할 때가 있는데..Fail-over 환경시 문제가 될수 있다.
- 수정 전-
LISTENER_RAC1 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac1)(PORT = 1521)(IP = FIRST))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac2)(PORT = 1521)(IP = FIRST))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
)
)
Public Network 장애로 VIP 가 Fail-over 될때 listener stop 을 시도하게 된다. (PROTOCAL=IPC)를 첫 address 위치로
변경하면 lsnrctl 이 IPC address 를 통하여 접속하므로 그 다음 설정되어 있는 IP를 찾는 작업에 시간을 소모하지 않고 (TCP timeout 동안 기다리지 않고) 바로 listener stop 을 할 수가 있다.
- 수정 후 -
LISTENER_RAC1 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac1)(PORT = 1521)(IP = FIRST))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac2)(PORT = 1521)(IP = FIRST))
)
)
2016. 10. 27. 22:06 좋아하는 음악
Nuno 의 "Midnight express"
2016. 10. 21. 10:06 Mysql
MySQL vs Oracle Data Type 비교
MySQL vs Oracle Data Type 비교
- Numeric Types
MySQL
|
Size
|
Oracle
|
|
BIGINT |
8 Bytes |
NUMBER (19,0) |
|
BIT |
approximately (M+7)/8 Bytes |
RAW |
|
DECIMAL(M,D) |
M+2 bytes if D > 0, M+1 bytes if D = 0 (D+2, if M < D) |
FLOAT(24), BINARY_FLOAT |
|
DOUBLE |
8 Bytes |
FLOAT(24), BINARY_FLOAT, BINARY_DOUBLE |
|
DOUBLE PRECION |
8 Bytes |
FLOAT(24), BINARY_DOUBLE |
|
FLOAT(25<=X <=53) |
8 Bytes |
FLOAT(24), BINARY_FLOAT |
|
FLOAT(X<=24) |
4 Bytes |
FLOAT, BINARY_FLOAT |
|
INT |
4 Bytes |
NUMBER (10,0) |
|
INTEGER |
4 Bytes |
NUMBER (10,0) |
|
MEDIUMINT |
3 Bytes |
NUMBER (7,0) |
|
NUMERIC |
M+2 bytes if D > 0, M+1 bytes if D = 0 (D+2, if M < D) |
NUMBER |
|
REAL |
8 Bytes |
FLOAT(24), BINARY_FLOAT |
|
SMALLINT |
2 Bytes |
NUMBER(5,0) |
|
TINYINT |
1 Byte |
NUMBER(3,0) |
- Date and Time Types
|
MySQL |
Size |
Oracle |
|
|
DATE |
3 Bytes |
DATE |
|
|
DATETIME |
8 Bytes |
DATE |
|
|
TIMESTAMP |
4 Bytes |
DATE |
|
|
TIME |
3 Bytes |
DATE |
|
|
YEAR |
1 Byte |
NUMBER |
|
- String Types
|
MySQL |
Size |
Oracle |
|
BLOB |
L + 2 Bytes whereas L<2^16 |
RAW, BLOB |
|
CHAR(m) |
M Bytes, 0<=M<=255 |
CHAR |
|
ENUM (VALUE1, VALUE2, ...) |
1 or 2 Bytes depending on the number of enum. values (65535 values max) |
|
|
LONGBLOB |
L + 4 Bytes whereas L < 2 ^ 32 |
RAW, BLOB |
|
LONGTEXT |
L + 4 Bytes whereas L < 2 ^ 32 |
RAW, CLOB |
|
MEDIUMBLOB |
L + 3 Bytes whereas L < 2^ 24 |
RAW, BLOB |
|
MEDIUMTEXT |
L + 3 Bytes whereas L < 2^ 24 |
RAW, CLOB |
|
SET (VALUE1, VALUE2, ...) |
1, 2, 3, 4 or 8 Bytes depending on the number of set members (64 members maximum) |
|
|
TEXT |
L + 2 Bytes whereas L<2^16 |
VARCHAR2, CLOB |
|
TINYBLOB |
L + 1 Bytes whereas L<2 ^8 |
RAW, BLOB |
|
TINYTEXT |
L + 1 Bytes whereas L<2 ^8 |
VARCHAR2 |
|
VARCHAR(m) |
L+1 Bytes whereas L<=M and0<=M<=255 before MySQL 5.0.3 (0 <= M <= 65535 in MySQL 5.0.3 and later; effective maximum length is 65,532 bytes) |
VARCHAR2, CLOB |
2016. 10. 20. 17:00 오라클
oracle recyclebin 기간별로 지우기
어떠한 이유로 인해 Recylebin 으로 drop 된 (실제로는 rename만 된것이지만) 객체들을 일정한 기간 만큼만 지우고자 하는 경우가 있을 것이다.
해당 경우 아래와 같이 하면 된다.
보기 예 1 )
- 7일이 경과한 Table 을 삭제하고자 할때
select 'purge table '||owner||'."'||OBJECT_NAME||'";'
from dba_recyclebin where type='TABLE' and to_date(droptime,'YYYY-MM-DD:HH24:MI:SS')<sysdate-7;
'PURGETABLE'||OWNER||'."'||OBJECT_NAME||'";'
------------------------------------------------------------------------------------------------------------------------
purge table WMSYS."BIN$PgNXeTuLWoPgU24AEKyH3g==$0";
purge table WMSYS."BIN$PgRouDktJGngU24AEKx4sg==$0";
purge table WMSYS."BIN$PgTrksKrSP3gU24AEKzvyw==$0";
Elapsed: 00:00:00.02
보기 예 2 )
- 5분이 경과한 Table 을 삭제하고자 할때
select 'purge table '||owner||'."'||OBJECT_NAME||'";'
from dba_recyclebin where type='TABLE' and to_date(droptime,'YYYY-MM-DD:HH24:MI:SS')<sysdate-(5/(24*60));
끝.
