mapletree
an Oracle player in Ottawa
博文
(2007-08-13 17:56:53)
夏天快要过去了，我把肩头晒伤了。我最爱玩那个大漏斗，从高高的管道里滑下来，象一条鱼一样甩到漏斗里，沿着内壁甩几圈，扑通一声大头朝下栽到3米深的池子里，晕头转向，一头雾水地摸出来，岸上站着的人狂笑。回来肩头的轻微灼伤变成了疼痛，在床上烙饼一样地翻过来又翻过去，怎么躺都不舒服，这把骨头还真是欠练啊。[阅读全文]
(2007-08-11 19:59:54)
CPUpatchissecurity-related,applyingitneedsdowntime.
here'sanvulnerabilityfiexedinCPUJul2007:
abugrelatedwithFRAfixedin10.2.0.3patch.
thesymptomis:v$recovery_file_dest.space_reclaimable(0)isnotconsistentwithV$FLASH_RECOVERY_AREA_USAGE.percent_space_reclaimable
so,althoughthere'senoughspaceinFRA,westillgotalarmedthattheFRAisover85%
SQL>selectname,
2round(space_limit...[阅读全文]
here'sanvulnerabilityfiexedinCPUJul2007:
abugrelatedwithFRAfixedin10.2.0.3patch.
thesymptomis:v$recovery_file_dest.space_reclaimable(0)isnotconsistentwithV$FLASH_RECOVERY_AREA_USAGE.percent_space_reclaimable
so,althoughthere'senoughspaceinFRA,westillgotalarmedthattheFRAisover85%
SQL>selectname,
2round(space_limit...[阅读全文]
(2007-08-11 19:22:01)
ORA-00607:Internalerroroccurredwhilemakingachangetoadatablock
ORA-00600:internalerrorcode,arguments:[4193],[674],[558],[],[],[],[],[]
SatAug417:35:322007
Errorsinfile/opt/ora9/admin/ora9i/udump/ora9i_ora_4433.trc:
ORA-00607:Internalerroroccurredwhilemakingachangetoadatablock
ORA-00600:internalerrorcode,arguments:[4193],[544],[542],[],[],[],[],[]
Error607happenedduringdbopen...[阅读全文]
ORA-00600:internalerrorcode,arguments:[4193],[674],[558],[],[],[],[],[]
SatAug417:35:322007
Errorsinfile/opt/ora9/admin/ora9i/udump/ora9i_ora_4433.trc:
ORA-00607:Internalerroroccurredwhilemakingachangetoadatablock
ORA-00600:internalerrorcode,arguments:[4193],[544],[542],[],[],[],[],[]
Error607happenedduringdbopen...[阅读全文]
(2007-08-11 19:09:02)
theoriginalrequestis:
mypcismydesktop(windowsxp),titan(RHELAS4)istheclientgateway,eplse1(RHELAS4)istheclientserver,
there'sanEM(10gdbconsole)runningoneplse1,nowweneedtoaccessEMonmypc.
1>usingportforwardingenableSQL*Netconnection
gateway:tools(216.246.110.4)
targetserver:delphi(10.0.4.2)
mypc:windowsXP
putty-ssh-L90001:10.0.4.2:1521maple@216.246.110.4--connecti...[阅读全文]
mypcismydesktop(windowsxp),titan(RHELAS4)istheclientgateway,eplse1(RHELAS4)istheclientserver,
there'sanEM(10gdbconsole)runningoneplse1,nowweneedtoaccessEMonmypc.
1>usingportforwardingenableSQL*Netconnection
gateway:tools(216.246.110.4)
targetserver:delphi(10.0.4.2)
mypc:windowsXP
putty-ssh-L90001:10.0.4.2:1521maple@216.246.110.4--connecti...[阅读全文]
(2007-08-08 18:01:54)
曼缇莎，听起来象是一个女孩子的名字。
实际上她的意思是：科学计数法的实数那部分。
金山糍粑的解释是越看越懵的那种：尾数。我是怎么遇到这么个变态的词的呢？
看数值型数据(number)在oracle的内部存储方式，它们是以科学计数法的形式存储的。
初看之下，我也不明白，在M-W上搜，
Marc问我在作什么，我说我在学新词儿。他马上拽过一张纸，给我举了一个[阅读全文]
实际上她的意思是：科学计数法的实数那部分。
金山糍粑的解释是越看越懵的那种：尾数。我是怎么遇到这么个变态的词的呢？
看数值型数据(number)在oracle的内部存储方式，它们是以科学计数法的形式存储的。
初看之下，我也不明白，在M-W上搜，
Marc问我在作什么，我说我在学新词儿。他马上拽过一张纸，给我举了一个[阅读全文]
(2007-08-08 18:00:54)
trytorollupapartitiontable,it's300Gintotal,around2000partitions.
theplanistoexportoldpartitions,compressthem,thendroptheoldpartitions.
eg,partitionp20021018,it's500MBindba_segments,whileitsdumpfileis2GB,
thisisodd,normally,thedumpfilesizeissmallerthantheirsegmentsize.asexportdumpfileformatisinternal,foundnorelatedinformation,notsurewhatwaswrittenintothedumpfile.
atfirstIthoughtinde...[阅读全文]
theplanistoexportoldpartitions,compressthem,thendroptheoldpartitions.
eg,partitionp20021018,it's500MBindba_segments,whileitsdumpfileis2GB,
thisisodd,normally,thedumpfilesizeissmallerthantheirsegmentsize.asexportdumpfileformatisinternal,foundnorelatedinformation,notsurewhatwaswrittenintothedumpfile.
atfirstIthoughtinde...[阅读全文]
(2007-08-07 18:09:36)
--automaticallystartupandshutdown,withmultipleORACLE_HOMEs
normallythisisnotaproblem,butthere'sproblemwhen8iand10gco-existinoratab,andthedefaultORACLE_HOMEissetto8i.as$ORACLE_HOME/bin/dbstartupwillpickup'svrmglr'insteadof'sqlplus/assysdba'
$ORACLE_HOME/bin/dbstart|Ensuresacleanstartupofdatabaseinstance(s),evenaftersystemfailure
-------------------------|--------------------------------...[阅读全文]
normallythisisnotaproblem,butthere'sproblemwhen8iand10gco-existinoratab,andthedefaultORACLE_HOMEissetto8i.as$ORACLE_HOME/bin/dbstartupwillpickup'svrmglr'insteadof'sqlplus/assysdba'
$ORACLE_HOME/bin/dbstart|Ensuresacleanstartupofdatabaseinstance(s),evenaftersystemfailure
-------------------------|--------------------------------...[阅读全文]
(2007-08-06 10:23:14)
createaVBinstallationpackage.2errors:
1>system.invalidoperationexception
becausethedatagridocxdidnotgetregistered,butit'snotdbgrid32.ocx,msdatgrid.ocx,
it'sMSCHRT20.OCX,withAxInterop.MSChart20Lib.dll,Interop.MSChart20Lib.dllinthesamedirectoryastheexe.
Itotallyforgotaboutthis,it'sdevelopedbyme18monthsago,nowittookme2weekendstofigureitout!
2>Runtime.InteropServices.COMExcept...[阅读全文]
1>system.invalidoperationexception
becausethedatagridocxdidnotgetregistered,butit'snotdbgrid32.ocx,msdatgrid.ocx,
it'sMSCHRT20.OCX,withAxInterop.MSChart20Lib.dll,Interop.MSChart20Lib.dllinthesamedirectoryastheexe.
Itotallyforgotaboutthis,it'sdevelopedbyme18monthsago,nowittookme2weekendstofigureitout!
2>Runtime.InteropServices.COMExcept...[阅读全文]
