Oracle Database 11g Some more new features

1. Interesting Pivot & Unpivot feature available for year wise, monthwise ananlysis

2. Deduplication features is immediate requirement for document management, where we are storing same kind of documents in different places like booking, job, payment request etc – this will keep only one copy in the database and pointer in other places to link the source file

3. SQL Result cache – this will be useful like small reference tables like segment_master, service_type, currency_master etc. The same can be used for frequently accessed tables like currency_rate_master, so overhead will not be there like Disk I/O etc. This is like another type of memory area like SGA, buffer cache, PGA

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s