tag:blogger.com,1999:blog-28434899.post4962423541973629508..comments2023-09-24T07:03:26.382-07:00Comments on el-caro: DBA_HIST_FILEMETRIC_HISTORYFairlie Regohttp://www.blogger.com/profile/12472975937585205288noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-28434899.post-10123057885400818302007-06-26T06:59:00.000-07:002007-06-26T06:59:00.000-07:00moreover the internal insert statement doesn't ins...moreover the internal insert statement doesn't insert anything<BR/><BR/>since r=0 in EXEC statement.<BR/><BR/>interesting thing...<BR/><BR/><BR/>Regards,<BR/>Andrey Goryunovgoryunovhttps://www.blogger.com/profile/06851091789503158667noreply@blogger.comtag:blogger.com,1999:blog-28434899.post-76781197860374600572007-06-25T22:15:00.000-07:002007-06-25T22:15:00.000-07:00I traced the session withexec dbms_workload_reposi...I traced the session with<BR/>exec dbms_workload_repository.create_snapshot('ALL');<BR/>and found the sql that does insert:<BR/>PARSING IN CURSOR #15 len=440 dep=1 uid=0 oct=2 lid=0 tim=23625183113164 hv=1555563702 ad='9ec56bf0'<BR/>insert into wrh$_filemetric_history (snap_id, dbid, instance_number, fileid, creationtime, begin_time, end_time, intsize, group_<BR/>id, avgreadtime, avgwritetime, physicalread, physicalwrite, phyblkread, phyblkwrite) select :snap_id, :dbid, :instance_number,<BR/> fileid, creationtime, begtime, endtime, intsize_csec, groupid, avrdtime, avwrtime, phyread, phywrite, phybkrd, phybkwr f<BR/>rom x$kewmflmv<BR/>END OF STMT<BR/>PARSE #15:c=0,e=78,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=23625183113158<BR/>BINDS #15:<BR/>kkscoacd<BR/> Bind#0<BR/> oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00<BR/> oacflg=00 fl2=0000 frm=00 csi=00 siz=72 off=0<BR/> kxsbbbfp=ffffffff7dbc0700 bln=22 avl=03 flg=05<BR/> value=192<BR/> Bind#1<BR/> oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00<BR/> oacflg=00 fl2=0000 frm=00 csi=00 siz=0 off=24<BR/> kxsbbbfp=ffffffff7dbc0718 bln=22 avl=06 flg=01<BR/> value=2142263721<BR/> Bind#2<BR/> oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00<BR/> oacflg=00 fl2=0000 frm=00 csi=00 siz=0 off=48<BR/> kxsbbbfp=ffffffff7dbc0730 bln=22 avl=02 flg=01<BR/> value=1<BR/>EXEC #15:c=0,e=485,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=23625183113768<BR/>STAT #15 id=1 cnt=0 pid=0 pos=1 obj=0 op='FIXED TABLE FULL X$KEWMFLMV (cr=0 pr=0 pw=0 time=152 us)'<BR/><BR/>but the data did not appear in wrh$_ table even there are some rows in the source table.<BR/>but I was able to insert data to wrh$ table manually under sys (of course it is just test database)<BR/>but for some reason it does not work within a procedure.<BR/><BR/>Regards,<BR/>Andrey Goryunovgoryunovhttps://www.blogger.com/profile/06851091789503158667noreply@blogger.comtag:blogger.com,1999:blog-28434899.post-460488484295381162007-06-22T00:16:00.000-07:002007-06-22T00:16:00.000-07:00Yes ... This bug was logged by me :-)Yes ... This bug was logged by me :-)Fairlie Regohttps://www.blogger.com/profile/12472975937585205288noreply@blogger.comtag:blogger.com,1999:blog-28434899.post-38732905577663226062007-06-21T21:14:00.000-07:002007-06-21T21:14:00.000-07:00Is it a bug 5478351?Regards,Andrey GoryunovIs it a bug 5478351?<BR/><BR/>Regards,<BR/>Andrey Goryunovgoryunovhttps://www.blogger.com/profile/06851091789503158667noreply@blogger.comtag:blogger.com,1999:blog-28434899.post-89306813881022393592007-06-02T12:46:00.000-07:002007-06-02T12:46:00.000-07:00Upcoming 11g feature? ;)Upcoming 11g feature? ;)Peter Khttps://www.blogger.com/profile/14068944101291927006noreply@blogger.com