请求报错快照过久 回滚段过小

《请求报错快照过久 回滚段过小》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、问题文档作者:黎法良创建日期:2013-04-01更新日期:2013-04-01文档编号:当前版本:1.0Note:Title,Subject,LastUpdatedDate,ReferenceNumber,andVersionaremarkedbyaWordBookmarksothattheycanbeeasilyreproducedintheheaderandfooterofdocuments.Whenyouchangeanyofthesevalues,becarefulnottoaccidentallydeletethebookmark.Youcanma

2、kebookmarksvisiblebyselectingTools->Options…ViewandcheckingtheBookmarksoptionintheShowregion.Note:Toaddadditionalapprovallines,press[Tab]fromthelastcellinthetableabove.Note:Youcandeleteanyelementsofthiscoverpagethatyoudonotneedforyourdocument.Forexample,CopyNumberisonlyrequiredifthi

3、sisacontrolleddocumentandyouneedtotrackeachcopythatyoudistribute.Note:ThecopynumbersreferencedaboveshouldbewrittenintotheCopyNumberspaceonthecoverofeachdistributedcopy.Ifthedocumentisnotcontrolled,youcandeletethistable,theNoteToHolders,andtheCopyNumberlabelfromthecoverpage.目录问题3Step

4、3解决方案4扩大回滚段4问题PeriodicAcquisitionCostAdjustmentProcessor请求报错回滚段过小Step1.提交请求2.请求报错当前的系统时间为01-04-201309:41:51+---------------------------------------------------------------------------+**Starts**01-04-201309:41:51**Ends**01-04-201311:36:18+--------------------------------------------

5、-------------------------------+FND_FILE中日志消息开始+---------------------------------------------------------------------------+LegalEntity:24283CostType:1001Period:67053ProcessUptodate:31-03-13CostGroup:3001Source:2RunOption:1ReceiptNo:InvoiceNo:ExceptionoccuredinAcquisition_cost_adj_p

6、rocessor:-1555CSTPPACQ.acq_cost_processor(40):ORA-01555:快照过旧:回退段号35(名称为"_SYSSMU35$")过小+---------------------------------------------------------------------------+FND_FILE中日志消息结束解决方案扩大回滚段Lastlogin:MonApr110:45:342013from172.28.3.60[oraprod@shbwdb~]$conn/assysdba;-bash:conn:commandno

7、tfound[oraprod@shbwdb~]$sqlplus/nologSQL*Plus:Release10.2.0.3.0-ProductiononMonApr112:06:352013Copyright(c)1982,2006,Oracle.AllRightsReserved.SQL>conn/assysdba;Connected.SQL>showparameterundoNAMETYPEVALUE-----------------------------------------------------------------------------un

8、do_managementstring