Search results

Thanks TheMadDBA. In regards to the SQL query; I couldn't tell you. That's something I'll have to find out. The alternate buffer pool isn't active, but i have been given sign off to start using it! For this query in particular I was thinking of trying to use private buffers as it's just the...

Yes.

Sorry I wasn't clear at all. The process is a batch process, but the guy that's looks after the reports killed the process and restarted it. I was referring to the report. The database has been up for a good few months now. No, just the one process. I'm not aware of any. Mainly the reason...

Thanks Rob. That clears most things up for me now.

Hi Rob, Thanks for the response. In haven't established if it is the database, but the report hasn't changed and neither have the surroundings. The user is connecting remotely through an SQL connection. Or so is my understanding. No code or propath has changed, it's in house and we have...

Hi all, We have a report that runs on a Live system every 15 minutes and usually takes between 1-2 minutes to run. From Thursday morning it started to take 40+ minutes to complete. Nothing I'm aware of has changed. Apparently this has happened before. The user that has run this report has...

I've written a program which goes through the dbanalys and takes the table and index data and outputs them to a more manageable spreadsheet. Later to be stored in a database :) so help record growth. The program does some calculations based on the info i've kindly been given or read; as shown...

Thanks Rob. Much appreciated. I'll see if we can get to 11.5.1. I'll see how long > 1Tb takes to dump and load or convert.

:rolleyes: Thanks!

Sorry I was talking about System tables / VST's. Should these be left alone?

While i'm on this, what about tables within the Schema Area? Can/Should these be moved to conform with a more comfortable RPB or due to their nature do we leave them alone? Would they benefit from being moved Type 2 storage area?

Yes, that's one of the issues I tried to mention! Thought it was in 11.3 also, maybe i'm just confused, I'll see what the boss says regarding 11.5.1. makes sense to me; they'll be lots of new toys!

Thanks Rob, the only issue is that the powers that be want to Upgrade to 11 (time-scales unknown) Would you recommend this? I've seen an issue with both 11.3 and 11.4 (don't ask as i'll have to dig them out) so is 11.5 the best option?

Looks like SP05. Thanks for the links. Yes, it's 64bit.

Thanks for the advice, greatly appreciated. I'll set off a few practice runs in the coming weeks and see how long it takes!

Agreed. If I were to do a dump and load, I'd get everything done at once. Make a job of it :) Am I right in thinking that you can do a multi-threaded dump, but not a load? From what I remember the dump was way slower than a load, but not since the multi-thread. It's a date; I'll provide the...

Thanks for the reply and the info, all sounds pretty good to me. My next question was going to be regarding the blocksize. I've read everywhere that 4K in the size for windows, but i read something of Tom's recently that kind of suggested that it's the case. I'll happy move to 8K then :)...

Thanks :) That's a starting point. Hopefully my understanding isn't too far away from reality then. My main concern it that our database is > 1TB and is growing rapidly. I'm hoping the majority of this is down to poor structure and too many under utilised or unused indexes.

Thanks Cringer; appreciate the rapid response. I'd like a more hands-on approach though in order to start learning. - I know re-inventing the wheel. But it would be nice to get my head around the outputs and be able to notice issues when presented with such data. Thanks

Hello all, Were using OE10.2B on Windows server 2008 64bit. Firstly, i'm probably going about this the wrong way so a nudge in the right direction would be nice. I'm trying to determine whether a table is sat in the wrong storage area and would benefit by being moved to something a little more...