mapletree

an Oracle player in Ottawa
博文
(2007-08-13 17:56:53)
夏天快要过去了,我把肩头晒伤了。我最爱玩那个大漏斗,从高高的管道里滑下来,象一条鱼一样甩到漏斗里,沿着内壁甩几圈,扑通一声大头朝下栽到3米深的池子里,晕头转向,一头雾水地摸出来,岸上站着的人狂笑。回来肩头的轻微灼伤变成了疼痛,在床上烙饼一样地翻过来又翻过去,怎么躺都不舒服,这把骨头还真是欠练啊。[阅读全文]
阅读 ()评论 (0)
(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...[阅读全文]
阅读 ()评论 (1)
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...[阅读全文]
阅读 ()评论 (0)
(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...[阅读全文]
阅读 ()评论 (0)
(2007-08-08 18:01:54)
曼缇莎,听起来象是一个女孩子的名字。
实际上她的意思是:科学计数法的实数那部分。
金山糍粑的解释是越看越懵的那种:尾数。我是怎么遇到这么个变态的词的呢?
看数值型数据(number)在oracle的内部存储方式,它们是以科学计数法的形式存储的。
初看之下,我也不明白,在M-W上搜,
Marc问我在作什么,我说我在学新词儿。他马上拽过一张纸,给我举了一个[阅读全文]
阅读 ()评论 (2)
trytorollupapartitiontable,it's300Gintotal,around2000partitions.
theplanistoexportoldpartitions,compressthem,thendroptheoldpartitions.
eg,partitionp20021018,it's500MBindba_segments,whileitsdumpfileis2GB,
thisisodd,normally,thedumpfilesizeissmallerthantheirsegmentsize.asexportdumpfileformatisinternal,foundnorelatedinformation,notsurewhatwaswrittenintothedumpfile.
atfirstIthoughtinde...[阅读全文]
阅读 ()评论 (1)
--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
-------------------------|--------------------------------...[阅读全文]
阅读 ()评论 (0)
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...[阅读全文]
阅读 ()评论 (0)