Search results

I'm just rerunning the idxcompact now to get timings via a script so i can persuade the powers to allow me to run this in live although the timings may not be as accurate as they've been compacted once, but then again the box isn't as powerful as live so maybe they will equal themselves out...

The AI file in question is 150mb. The AI rolls every 15 minutes. I think it must be the sheer amount of transactions. I did wonder about compression and why i hadnt seen it, didnt know you meant via o/s. I've queried the hardware on DR. The BI and DB are on the same disk, so i'm addressing...

No, at least i think not. Is there a param i can check? This is one of the latest entries in the DR database: Mon Jan 25 13:06:31 2016 [2016/01/25@13:06:31.024+0000] P-7084 T-6628 I RFUTIL : (451) Roll forward session begin for AI_Processing on CON...

And the results are in;

Thanks TheMadDBA. You are right and i'm having flashbacks of pointing this out to management! [2016/01/22@15:17:38.260+0000] P-5456 T-5808 I RFUTIL : (5326) Begin Physical Redo Phase at 917448 . [2016/01/22@15:23:27.184+0000] P-5456 T-5808 I RFUTIL : (7161) Physical Redo...

Thanks Rob - I did think that would be the case. I saw something which suggested to reduce the bibufs but i wasnt too sure about the implications. The issue we are getting is that the AI files are taking >15 mins to roll forward every now and again. This causes a backlog and i'm not too happy...

OE10.2BSp07 64-bit Windows 64-bit. Hi all, I have a question regarding after-image file sizes; basically i'd essentially like to reduce the size of the AI files that we transport to DR. Is this at all possible? Our process runs every 15 minutes and over a course of a 24hour period the total...

All benefits then! I didnt specify any index compaction in test so it would have defaulted to 80. Although idxbuild would probably be quicker, i think the business would be happier if it can be done online at off-peak times. But its something i will look into. Currently we are on 10.2BSP07...

Maybe on a bank holiday we could take 2 / 2.5 days. Usually downtime is a Sunday only job.

Yes 4k. I'm hoping to move us to 8k in the future. Stumbling block is the size of the database though. Thanks for the info!

Size in GB of the indexes, although blocks have reduced and utilization has improved. The size has been maintained. This will require a dump and reload, right?

Just an update as index compacting on the test box is taking an age: This is the most up to date dbanalys before any index compacting: PUB.Customer idxCustomerCode 619 1 4 3149652 6.8G 57.3 1.9 idxRecordModified 976 1 4...

hello, The table and index names are masked! 618 (idxOrder) is primary unique 626 (idxType) is unique. Thanks

Hi Both, This is a recent dbanalysis file: ------------------------------------------------------- -Record Size (B)- ---Fragments--- Scatter Table Records Size Min Max Mean...

Hi Tom, The clarity surrounding 'Delete' is the numbers involved, why has index idxCost racked up over 7000 hits and the rest 4 or 5. Does this mean the idxCost index was used as the delete, therefore removing this index would break the delete process? Thanks for the info on splits :) I have...

Hi Tom, The clarity surrounding 'Delete' is the numbers involved, why has index idxCost racked up over 7000 hits and the rest 4 or 5. Does this mean the idxCost index was used as the delete, therefore removing this index would break the delete process? Thanks for the info on splits :) I have...

Hi All, We're looking at doing some spring cleaning on our database and want to look at removing some indexes. We plan to monitor the _IndexStat over the next month or so and see what Indexes are being used and which aren't. Currently i've run a few tests and wanted to check what the fields...

Ah no worries. I've just read a few documents and they've cleared it up slightly: -red 5 Creates one error-correction block for every five blocks that are backed up.

Thanks Cringer. I know what you mean. I'm just running a prorest -vp against the backup file now to see if that brings anything back. Do you happen to know about the -red command, i've found that its set at 0 by default and 1 would duplicat the backup block for block, are there others...

A bit more info on this; the backup file finished at 00:30: [2015/11/16@00:30:14.017+0000] P-43188 T-2696 I BACKUP339: (1364) Full backup successfully completed. and the transfer of the backup file happened at 01:00 That, to me, indicates that it cannot be writing to the backup file...