Thursday, August 11, 2011

Understanding Oracle Features and Options on Oracle 11.2

About Standard Edition(SE) and SE ONE:
SE (4 sockets max) + RAC option available.
SE ONE(2 sockets max) .
Enterprise edition unlimited(extra costs for options)

Main Enterprise options we don’t get in Standard Edition(SE)
  1. Oracle Standard Management Pack - Pack includes scaled down functionality from Change Management, Diagnostics, and Tuning Packs.
  2. Fine-grained auditing -  This features allows the monitoring of database access based on the content of the data accessed.                           
  3. Oracle Advanced security  -  Security options.
  4. Data compression - This feature provides the ability to compress tables and partitions.
  5. Bitmapped index   -This feature provides an and bitmapped  index type commonly used join index in data warehouses for  columns with low cardinality, such as 'Y' or 'N', to dramatically improve performance gains in a data  warehouse application.
  6. Automated parallel  - Automated parallel query   optimization based on  system utilization.
  7. Database Resource Manager - gives Oracle Database more Manager control over resource management decisions, circumventing problems arising from inefficient operating system management.
  8. Online operations  - Online index maintenance, Online table organization, Online table redefinition.
  9. Function-based in indexes - Oracle SE may allow you to create a function-based index.
  10. Performance - Query Results Cache, PL/SQL Function Result Cache, Client Side Query Cache, SQL Plan Management.
  11. Unused block compression in backups.

How to check what do you use:

--number of users and cpu/processors:

SELECT   * FROM v$license;

--database edition installed:

SELECT   banner
  FROM   v$version
 WHERE   UPPER(banner) LIKE UPPER('%edition%');

--oracle partitioning installed:

SELECT   DECODE (COUNT ( * ), 0, 'no', 'yes') partitioning
  FROM   (SELECT   1
            FROM   dba_part_tables
           WHERE   owner NOT IN ('SYSMAN', 'SH', 'SYS', 'SYSTEM')
                   AND ROWNUM = 1);

--oracle rac installed:

SELECT   DECODE (COUNT ( * ), 0, 'no', 'yes') rac
  FROM   (SELECT   1
            FROM   v$active_instances
           WHERE   ROWNUM = 1);

--options installed/not installed:

col name  format a50 heading "option"
col value format a5  heading "?" justify center wrap
break on value dup skip 1

  SELECT   parameter name, VALUE
    FROM   v$option

--features used/not used:

set feedback off
set linesize 122
col name             format a45     heading "feature"
col version          format a10     heading "version"
col detected_usages  format 999,990 heading "detected|usages"
col currently_used   format a06     heading "curr.|used?"
col first_usage_date format a10     heading "first use"
col last_usage_date  format a10     heading "last use"
col nop noprint
break on nop skip 1 on name

  SELECT   DECODE (detected_usages, 0, 2, 1) nop,
           TO_CHAR (first_usage_date, 'dd/mm/yyyy') first_usage_date,
           TO_CHAR (last_usage_date, 'dd/mm/yyyy') last_usage_date
    FROM   dba_feature_usage_statistics
ORDER BY   nop, 1, 2;



  1. I all the time used to study article in news papers but now as I am a user of internet
    thus from now I am using net for articles, thanks to web.

    My weblog :: cost of dental implants

  2. Thanks for your personal marvelous posting! I quite enjoyed reading it, you might be a
    great author. I will be sure to bookmark your blog and will often come back later in life.

    I want to encourage that you continue your great writing, have a nice day!

    Feel free to visit my website; Root Canal treatment cost

  3. Hey I know this is off topic but I was wondering if you
    knew of any widgets I could add to my blog that automatically tweet my newest twitter updates.

    I've been looking for a plug-in like this for quite some time and was hoping maybe you would have some experience with something like this. Please let me know if you run into anything. I truly enjoy reading your blog and I look forward to your new updates.

    Visit my weblog - dental implants cost

  4. Greetings from Idaho! I'm bored to death at work so I decided to check out your website on my iphone during lunch break. I enjoy the knowledge you provide here and can't
    wait to take a look when I get home. I'm surprised at how quick your blog loaded on my cell phone .. I'm not even using
    WIFI, just 3G .. Anyhow, excellent site!

    Also visit my blog :: costs of dental implants

  5. I'm not sure the place you are getting your information, but good topic. I needs to spend some time learning much more or understanding more. Thank you for fantastic info I used to be looking for this information for my mission.

    My weblog: costs of dental implants

  6. I got this site from my buddy who told me about this web page
    and now this time I am visiting this site and reading very informative
    posts at this place.

    Also visit my webpage ลดน้ำหนัก

  7. Hmm it appears like your website ate my first comment (it
    was super long) so I guess I'll just sum it up what
    I had written and say, I'm thoroughly enjoying your blog.
    I too am an aspiring blog blogger but I'm still new to everything.
    Do you have any points for newbie blog writers? I'd really appreciate it.

    my homepage - Online casino bonus

  8. (Coach Outlet Online) completed their dancing thinks, She or he proceed an discussion message community forums might body of water Highlands graduating college audience B, Beneath the tutelage because pointing to Nancy Poynter.Identically university brought accomplished thespians (Yeezy Boost 350 Cheap) including silver modern world selected Morgan Fairchild, Complete and as a (Cheap Yeezys For Sale) result trap blaze take the leading role Scoot McNairy symbol Salling, The (Ray Ban Outlet) folk aided by the mohawk attached to joy. (Truth Salling is not likely to present themselves your reunientirely directly referring to on the fact he was initially lately indicted porn material child complaints.)The world thinks town's social media is important to all the memories of a CityEngaging with his target audience is important to the (Cheap Jordan Shoes Websites) Observer's voyage. Make a monetary share or register online for a bulletin, And (Jordan Shoes For Sale Online) after that allow us to carry on to remember sharing Dallas's levels and no paywalls.While attending school Acker played at local stores at Undermain movie theater as well level western world in fortification good priced, And he or she came selected to buy a Leon Rabin from a prize on her character output (Michael Kors Outlet Online) of Therese Raquin.

  9. Whether he was acting, working backstage, building sets, or writing checks, it's hard to think of any one person who contributed so much of himself to so many different performing arts organizations. He worked with our biggest playhouses, and with our scrappiest independent troupes. No role was ever too small.

    Humans and rats aren't all that different; thats why they use them to test our drugs. Coach Outlet Clearance Sale All it takes is a more Best Yeezys evolved version of toxoplasmosa, one that could to do us what it does to the rats. So, imagine if half the world suddenly had no instinct for self preservation or rational thought.

    As part of the Service, NDTV may Nike Air Force 1 Cheap Outlet provide you with content Ray Ban Outlet developed by NDTV or its licensors ( NDTV grants you a Jordan Shoes For Sale non exclusive and perpetual license to use Content for the purpose it is intended, unless otherwise defined in Coach Outlet Online the applicable Terms or the Cheap Michael Kors Handbags purchase MK Outlet Online order. You are bound by any restrictions applicable to specific Content you obtain through the Service. Any license acquired to third party Content is a binding agreement between you and the third party Content provider..