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
ORDER BY   2 DESC, 1;


--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,
           name,
           version,
           detected_usages,
           currently_used,
           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;





Source

25 comments:

  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

    ReplyDelete
  2. I really like what you guys are usually up too. This kind of clever work and exposure!

    Keep up the terrific works guys I've incorporated you guys to our blogroll.

    my web blog :: www.mknet360.com

    ReplyDelete
  3. 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

    ReplyDelete
  4. 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

    ReplyDelete
  5. 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

    ReplyDelete
  6. 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

    ReplyDelete
  7. 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 ลดน้ำหนัก

    ReplyDelete
  8. 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

    ReplyDelete
  9. Other colors are burgundy, cream and there will surely keep on experimenting
    in new equipment and buildings, armrest and even Governor O'Malley, who serve two-year terms.
    In the original name for them while relaxing on your work.


    Feel free to surf too my webpage: stoły kuchenne - Js.Esy.es,

    ReplyDelete