11gr2: it looks like someone is listening, after all...

Some of you folks might recall my 2008 wishlist for Oracle.

The number one pet peeve was the need to create the initial segment of any data object even when it is empty.

A big no-no for products such as Peoplesoft, where in a typical installation one gets 25000 tables and 35000 indexes of which only around 1000 are ever filled with any data.

Well, it appears someone at Oracle is reading this blog, after all:

This is it, right there in fresh 11gr2!

I had given up hope Oracle development would stop adding useless new features and instead give dbas the ones they have been asking for.

It appears at least once, they listened!

Now, if only someone would listen again and give us a way to load Statspack historical information into AWR...

It might make the new AWR functionality mildly useful for us: we have nearly 3 years of Statspack data.

And no way to use it as a source for all the excellent Grid/EM AWR analysis tools!

Who knows, this might actually be heard?


No photos on this one, folks: too busy at the moment.


Blogger Nicolas Gasparotto said...

Thanks for this catch, and yes, it will be very helpfull to reduce dramarically the size of PS databases. Keep it up,

Friday, September 04, 2009 8:50:00 pm  
Anonymous David Aldridge said...

Hah, and when do you think Peoplesoft will start supporting 11gR2? :D

Saturday, September 05, 2009 12:42:00 am  
Blogger Michael Fontana said...

fantasic obscure new feature. I had not seen this listed anywhere. Not only Peoplesoft but Siebel and SAP are notorious for loading JUNK into a database. They also want you to "profile" storage with defaults, which compounds the problems!

Saturday, September 05, 2009 1:11:00 am  
Blogger Noons said...

Thanks, man. Yes, it'll gonna have a direct positive impact on us, for example. But read David's pertinent comment.

There is a saying in my original country that goes more or less like this: "Rome wasn't built in a day".
It gives me hope it'll happen.
Real soon now....

Yeah, I thought about JDEdwards as well. This could really translate into some significant savings in disk space for a lot of folks. How soon will it be picked up, I don't know. But I could use it right now!

It's one of the little things I was really hoping 11gr2 would contain and bingo: it happened! At least, *that* is a start!

Saturday, September 05, 2009 12:13:00 pm  
Anonymous Alessandro said...

Back in the 9i days there is something like create index blah_idx on t(blah) nosegment;

Tuesday, September 08, 2009 12:05:00 pm  
Blogger Noons said...


Yes, but that is a slightly different proposition.

That was used by the tuning pack and was designed to allow the optimiser to establish a plan for a non-existing, never populated virtual index.

Basically, the index was never filled in with any keys even if the table had rows.

This one is a completely different proposition: the index will be populated as normal and use disk space once rows populate the related table. Same for the table.

Until that happens though, no space will be allocated. Hence the usefulness for products that create huge default schemas, mostly unpopulated.

Tuesday, September 08, 2009 3:07:00 pm  
Blogger Nicolas Gasparotto said...

Yes, of course, we can wondering when Peoplesoft will be certified on 11gR2, but hopefully soon with the coming Peopletools 8.50.
It would be nice to start new project with all the latest versions (Peoplesoft/Peopletools/Database).
Wait and see,

Wednesday, September 09, 2009 5:02:00 am  
Blogger Nicolas Gasparotto said...

@David, surprisingly, Peopletools 8.50 is already certified within Oracle 11.2 on OEL/RHEL...

Tuesday, October 27, 2009 12:47:00 am  

Post a Comment

<< Home