Senthil Murugan's Blog

Home » Uncategorized » Oracle Database 11g Some more new features

Oracle Database 11g Some more new features

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

http://www.oracle.com/technology/pub/articles/oracle-database-11g-top-features/11g-pivot.html

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

Advertisements

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

%d bloggers like this: