{"id":5431,"date":"2015-09-02T07:00:08","date_gmt":"2015-09-02T05:00:08","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/oracle-standard-edition-two\/"},"modified":"2015-09-02T07:00:08","modified_gmt":"2015-09-02T05:00:08","slug":"oracle-standard-edition-two","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/oracle-standard-edition-two\/","title":{"rendered":"Oracle Standard Edition Two"},"content":{"rendered":"<h2>By Franck Pachot<\/h2>\n<p>.<br \/>\nLook at the <a href=\"http:\/\/www.oracle.com\/technetwork\/database\/in-memory\/downloads\/index.html\" target=\"_blank\" rel=\"noopener noreferrer\">Oracle Download page<\/a>: Standard Edition is there in 12.1.0.2 &#8211; more than one year after the release of the patchset for Enterprise Edition. It&#8217;s a new name &#8211; SE2 in short &#8211; and new rules. Let&#8217;s have a look at it.<br \/>\n<!--more--><br \/>\nWe waited for it after those rumors from July, and as expected we have been notified by from Ann Sj\u00f6kvist, the Standard Edition lady, on her blog <a href=\"http:\/\/www.sejustloveit.com\/\" target=\"_blank\" rel=\"noopener noreferrer\">www.sejustloveit.com<\/a>. And the news are good, as promised by <a href=\"https:\/\/twitter.com\/dominic_giles\/with_replies\" target=\"_blank\" rel=\"noopener noreferrer\">Dominic Giles<\/a> who has to face so many questions currently&#8230;<\/p>\n<h1>Installation<\/h1>\n<p>So we have a new binary distribution, whith only one possible choice for the edition: Standard Edition Two:<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureSE2-001.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureSE2-001.jpg\" alt=\"CaptureSE2-001\" width=\"809\" height=\"291\" class=\"alignnone size-full wp-image-3532\" \/><\/a><\/p>\n<p>Everything else has nothing special.<\/p>\n<h1>Rules<\/h1>\n<p>We&#8217;re waiting for documentation updates at oracle.com but basically SE2 is limited to 2 sockets, which means that:<\/p>\n<ul>\n<li>If you have SE on server with 2 sockets, then you can install SE2 without additional cost<\/li>\n<li>If you have SE on a cluster (RAC) with 2 nodes having 1 socket each, then you an install SE2 without additional cost<\/li>\n<li>If you have SE One then you have to pay additional fee to go to 12.1.0.2 with SE2<\/li>\n<li>If you have SE on a cluster (RAC) with 4 nodes having 1 socket each, then you have to remove 2 nodes before going to 12.1.0.2<\/li>\n<li>If you have SE on a cluster (RAC) with 2 nodes having 2 socket each, then&#8230; you have to change hardware before going to 12.1.0.2, remove one socket (physically), or virtualize with OVM<\/li>\n<\/ul>\n<p>Of course, you can also choose to go to Enterprise Edition and\/or in the Oracle Cloud Services&#8230;<\/p>\n<h1>Apply latest PSU<\/h1>\n<p>In the uncompressed p20831110_121020_Linux-x86-64.zip folder I install the JUL2015 PSU<br \/>\nThe installation binaries is different, but the PSU is the same as Enterprise Edition<\/p>\n<pre><code>\n[oracle@VM115 20831110]$ ..\/..\/OPatch\/opatch apply\nOracle Interim Patch Installer version 12.1.0.1.5\nCopyright (c) 2015, Oracle Corporation.  All rights reserved.\n&nbsp;\nOracle Home       : \/u01\/app\/oracle\/product\/12102SE\nCentral Inventory : \/u01\/app\/oraInventory\n   from           : \/u01\/app\/oracle\/product\/12102SE\/oraInst.loc\nOPatch version    : 12.1.0.1.5\nOUI version       : 12.1.0.2.0\nLog file location : \/u01\/app\/oracle\/product\/12102SE\/cfgtoollogs\/opatch\/opatch2015-09-01_21-13-49PM_1.log\n&nbsp;\nVerifying environment and performing prerequisite checks...\nOPatch continues with these patches:   19769480  20299023  20831110\n&nbsp;\nDo you want to proceed? [y|n]\n<\/code><\/pre>\n<h1>Create Database<\/h1>\n<p>At that point you can upgrade a 12.1.0.1 database or create a new one.<\/p>\n<p>I run DBCA in advanced mode. You remember that non-CDB is deprecated? Then choose container database. Of course you can&#8217;t choose the number of PDBs to create here. You are in Standard Edition: it&#8217;s single tenant. Only one PDB.<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureSE2-002.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureSE2-002.jpg\" alt=\"CaptureSE2-002\" width=\"810\" height=\"436\" class=\"alignnone size-full wp-image-3539\" \/><\/a><\/p>\n<p>The &#8216;database options&#8217; step has been skipped. You don&#8217;t choose. You install a CDB with all options allowed in SE.<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureSE2-003.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureSE2-003.jpg\" alt=\"CaptureSE2-003\" width=\"754\" height=\"282\" class=\"alignnone size-full wp-image-3540\" \/><\/a><\/p>\n<p>and here is my database:<\/p>\n<pre><code>\n$ sqlplus \/ as sysdba\n&nbsp;\nSQL*Plus: Release 12.1.0.2.0 Production on Tue Sep 1 21:06:23 2015\n&nbsp;\nCopyright (c) 1982, 2014, Oracle.  All rights reserved.\n&nbsp;\nConnected to:\nOracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit Production\n&nbsp;\nSQL&gt;\n<\/code><\/pre>\n<h1>datapatch<\/h1>\n<p>If you have read Mike Dietrich post on <a href=\"https:\/\/blogs.oracle.com\/UPGRADE\/entry\/dbca_12c_and_datapatch_pl\">dbca and datapatch<\/a>, you know that you have to run datapatch after DBCA or DBUA. <\/p>\n<pre><code>\n$ $ORACLE_HOME\/OPatch\/datapatch -verbose\nSQL Patching tool version 12.1.0.2.0 on Tue Sep  1 21:21:00 2015\nCopyright (c) 2015, Oracle.  All rights reserved.\n&nbsp;\nLog file for this invocation: \/u01\/app\/oracle\/cfgtoollogs\/sqlpatch\/sqlpatch_5954_2015_09_01_21_21_00\/sqlpatch_invocation.log\n&nbsp;\nConnecting to database...OK\nNote:  Datapatch will only apply or rollback SQL fixes for PDBs\n       that are in an open state, no patches will be applied to closed PDBs.\n       Please refer to Note: Datapatch: Database 12c Post Patch SQL Automation\n       (Doc ID 1585822.1)\nBootstrapping registry and package to current versions...done\nDetermining current state...done\n&nbsp;\nCurrent state of SQL patches:\nBundle series PSU:\n  ID 4 in the binary registry and not installed in any PDB\n&nbsp;\nAdding patches to installation queue and performing prereq checks...\nInstallation queue:\n  For the following PDBs: CDB$ROOT PDB$SEED\n    Nothing to roll back\n    The following patches will be applied:\n      20831110 (Database Patch Set Update : 12.1.0.2.4 (20831110))\n&nbsp;\nInstalling patches...\nPatch installation complete.  Total patches installed: 2\n&nbsp;\nValidating logfiles...\nPatch 20831110 apply (pdb CDB$ROOT): SUCCESS\n  logfile: \/u01\/app\/oracle\/cfgtoollogs\/sqlpatch\/20831110\/18977826\/20831110_apply_SE2_CDBROOT_2015Sep01_21_21_48.log (no errors)\nPatch 20831110 apply (pdb PDB$SEED): SUCCESS\n  logfile: \/u01\/app\/oracle\/cfgtoollogs\/sqlpatch\/20831110\/18977826\/20831110_apply_SE2_PDBSEED_2015Sep01_21_21_55.log (no errors)\nSQL Patching tool complete on Tue Sep  1 21:22:01 2015\n<\/code><\/pre>\n<p>Oh. I forgot that my pluggable database is closed&#8230;<\/p>\n<pre><code>\nSQL&gt; alter pluggable database pdb open;\nWarning: PDB altered with errors.\n<\/code><\/pre>\n<p>then running datapatch again:<\/p>\n<pre><code>\nInstalling patches...\nPatch installation complete.  Total patches installed: 1\n&nbsp;\nValidating logfiles...\nPatch 20831110 apply (pdb PDB): SUCCESS\n  logfile: \/u01\/app\/oracle\/cfgtoollogs\/sqlpatch\/20831110\/18977826\/20831110_apply_SE2_PDB_2015Sep01_21_28_11.log (no errors)\nSQL Patching tool complete on Tue Sep  1 21:28:17 2015\n<\/code><\/pre>\n<h1>Thread limitation<\/h2>\n<p>I&#8217;m on a VM with only 4 cores here. Let&#8217;s run 20 session all in CPU anyway, by running 20 times the following:<\/p>\n<pre><code>\n(\nTWO_TASK=\/\/vm115\/PDB sqlplus sys\/oracle as sysdba &lt;&lt;END\nalter session set plsql_optimize_level=0;\nexec loop null; end loop;\nEND\n)&amp;\n<\/code><\/pre>\n<p>Here is the top screen while running:<\/p>\n<pre><code>\ntop - 21:58:17 up  1:09,  3 users,  load average: 4.34, 4.45, 2.82\nTasks: 199 total,   5 running, 194 sleeping,   0 stopped,   0 zombie\n%Cpu(s): 99.7 us,  0.1 sy,  0.0 ni,  0.0 id,  0.0 wa,  0.0 hi,  0.2 si,  0.0 st\nKiB Mem:   1018372 total,  1008288 used,    10084 free,      568 buffers\nKiB Swap:  1257468 total,    97252 used,  1160216 free.   103572 cached Mem\n&nbsp;\n  PID USER      PR  NI    VIRT    RES    SHR S  %CPU %MEM     TIME+ COMMAND\n 8145 oracle    20   0 1032592   8000   5700 R  21.9  0.8   2:14.05 oracle_8145_se2\n 8118 oracle    20   0 1032596   8004   5704 S  20.6  0.8   2:20.59 oracle_8118_se2\n 8148 oracle    20   0 1032592   8016   5720 S  20.6  0.8   2:13.43 oracle_8148_se2\n 8103 oracle    20   0 1032596   7996   5688 S  20.3  0.8   2:30.29 oracle_8103_se2\n 8112 oracle    20   0 1032596   8168   5868 S  20.3  0.8   2:23.69 oracle_8112_se2\n 8130 oracle    20   0 1032596   8008   5704 S  20.3  0.8   2:16.14 oracle_8130_se2\n 8133 oracle    20   0 1032592   8020   5720 S  20.3  0.8   2:14.40 oracle_8133_se2\n 8151 oracle    20   0 1032596   8008   5708 S  20.3  0.8   2:13.41 oracle_8151_se2\n 8154 oracle    20   0 1032592   8032   5732 S  20.3  0.8   2:11.76 oracle_8154_se2\n 8136 oracle    20   0 1032592   8004   5704 S  19.9  0.8   2:14.70 oracle_8136_se2\n 8139 oracle    20   0 1032596   8008   5704 S  19.9  0.8   2:14.92 oracle_8139_se2\n 8106 oracle    20   0 1032592   7980   5680 R  19.6  0.8   2:28.44 oracle_8106_se2\n 8121 oracle    20   0 1032600   7976   5668 S  19.6  0.8   2:19.45 oracle_8121_se2\n 8142 oracle    20   0 1032596   8016   5716 R  19.6  0.8   2:13.60 oracle_8142_se2\n 8157 oracle    20   0 1032596   8000   5700 R  19.6  0.8   2:12.65 oracle_8157_se2\n 8160 oracle    20   0 1032592   8488   6188 S  19.6  0.8   2:12.62 oracle_8160_se2\n 8115 oracle    20   0 1032596   7980   5676 S  19.3  0.8   2:21.39 oracle_8115_se2\n 8127 oracle    20   0 1032596   7984   5684 S  19.3  0.8   2:18.06 oracle_8127_se2\n 8109 oracle    20   0 1032596   8164   5860 S  18.9  0.8   2:26.49 oracle_8109_se2\n 8124 oracle    20   0 1032596   8008   5708 S  18.9  0.8   2:17.93 oracle_8124_se2\n 5792 oracle    20   0 1041576 109364  99516 S   0.3 10.7   0:07.97 ora_cjq0_se2\n<\/code><\/pre>\n<p>Look at the load average: it&#8217;s 4. It seems that the database itself has limited the number of processes willing to run in CPU.<br \/>\nThat looks like Resource manager instance caging.<\/p>\n<p>We usually think that we need to have a resource manager plan and set explicitely the cpu_count for that, but that&#8217;s not the case here:<\/p>\n<pre><code>\nSQL&gt; show spparameter cpu_count\nSID      NAME                          TYPE        VALUE\n-------- ----------------------------- ----------- ----------------------------\n*        cpu_count                     integer\n&nbsp;\nSQL&gt; show spparameter resource\nSID      NAME                          TYPE        VALUE\n-------- ----------------------------- ----------- ----------------------------\n*        resource_manager_plan         string\n<\/code><\/pre>\n<p>Anyway, in Standard Edition, the resource manager is not usable:<\/p>\n<pre><code>\nSQL&gt; alter system set resource_manager_plan=DEFAULT;\nalter system set resource_manager_plan=DEFAULT\n*\nERROR at line 1:\nORA-02097: parameter cannot be modified because specified value is invalid\nORA-00439: feature not enabled: Database resource manager\n<\/code><\/pre>\n<p>However when I check Statspack report for my 20 sessions run:<\/p>\n<pre><code>\nSnapshot       Snap Id     Snap Time      Sessions Curs\/Sess Comment\n~~~~~~~~    ---------- ------------------ -------- --------- ------------------\nBegin Snap:          3 01-Sep-15 21:47:37       22       1.4\n  End Snap:         11 01-Sep-15 21:54:05       24       2.5\n   Elapsed:       6.47 (mins) Av Act Sess:      19.5\n   DB time:     126.27 (mins)      DB CPU:      24.10 (mins)\n...\nLoad Profile              Per Second    Per Transaction    Per Exec    Per Call\n~~~~~~~~~~~~      ------------------  ----------------- ----------- -----------\n      DB time(s):               19.5              315.7        0.48       25.00\n       DB CPU(s):                3.7               60.3        0.09        4.77\n...\nTop 5 Timed Events                                                    Avg %Total\n~~~~~~~~~~~~~~~~~~                                                   wait   Call\nEvent                                            Waits    Time (s)   (ms)   Time\n----------------------------------------- ------------ ----------- ------ ------\nresmgr:cpu quantum                              14,987       6,114    408   99.7\nCPU time                                                        12            .2\ndb file sequential read                            862           6      7     .1\nlog file sync                                       18           1     57     .0\nDisk file operations I\/O                           204           0      2     .0\n          -------------------------------------------------------------\n<\/code><\/pre>\n<p>I have on average 3.7 sessions in CPU (roughly the load average at OS level), a total of 19.5 average active session (my 20 sessions looping in CPU). And 6,114\/(6.47*60)=15.7 sessions waiting on &#8216;resmgr:cpu quantum&#8217; <\/p>\n<p>What happens then? Like in XE (where limit is 1 thread), the resource manager is used internally. I&#8217;ve not enough cpu here to show it, but the limit for Standard Edition is 16 foreground session active in CPU at maximum. All that will be documented soon. Big thanks to Dominic Giles for <a href=\"https:\/\/twitter.com\/dominic_giles\/status\/638758168428965888\">sharing<\/a> with us.<\/p>\n<p><em>Remark: that 15.7 has nothing to do with the thread limit of 16 &#8211; it&#8217;s just my 20 sessions minus my 4 cpu. We can see the limit of 16 only when we have more than 16 cores<\/em><\/p>\n<p><strong>update:<\/strong> Of course, this 16 threads per database is 8 threads per server when in RAC (remember that you can&#8217;t have more than two nodes).<\/p>\n<h1>Pricing, features and support<\/h1>\n<p>The price and features is the same as the Standard Edition (<a href=\"http:\/\/www.oracle.com\/us\/corporate\/pricing\/technology-price-list-070617.pdf\">pricelist<\/a>, <a href=\"https:\/\/docs.oracle.com\/database\/121\/DBLIC\/editions.htm#DBLIC116\">features<\/a>) that we know.<\/p>\n<p><strong>update:<\/strong> One thing change if you are in NUP. The minimum that was 5 NUP, is now 10 NUP and is per server.<\/p>\n<p>The 12.1.0.1 is supported until August 2016 (MOS Doc ID <a href=\"https:\/\/support.oracle.com\/epmos\/faces\/DocContentDisplay?id=2027072.1\">2027072.1<\/a>) but don&#8217;t wait: 12.1.0.2 has new features even for Standard Edition (more on that soon), and lot of bugs fixed.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>By Franck Pachot . Look at the Oracle Download page: Standard Edition is there in 12.1.0.2 &#8211; more than one year after the release of the patchset for Enterprise Edition. It&#8217;s a new name &#8211; SE2 in short &#8211; and new rules. Let&#8217;s have a look at it.<\/p>\n","protected":false},"author":27,"featured_media":5435,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229,59],"tags":[631,96,632,633,634,68],"type_dbi":[],"class_list":["post-5431","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring","category-oracle","tag-11-2-0-2","tag-oracle","tag-resmgrcpu-quantum","tag-se","tag-se2","tag-standard-edition"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Oracle Standard Edition Two - dbi Blog<\/title>\n<meta name=\"description\" content=\"First info about Standard Edition 12c Patchset 1\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/oracle-standard-edition-two\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle Standard Edition Two\" \/>\n<meta property=\"og:description\" content=\"First info about Standard Edition 12c Patchset 1\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/oracle-standard-edition-two\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2015-09-02T05:00:08+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureSE2-001-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"809\" \/>\n\t<meta property=\"og:image:height\" content=\"291\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Oracle Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Oracle Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-standard-edition-two\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-standard-edition-two\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"Oracle Standard Edition Two\",\"datePublished\":\"2015-09-02T05:00:08+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-standard-edition-two\/\"},\"wordCount\":739,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-standard-edition-two\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureSE2-001-1.jpg\",\"keywords\":[\"11.2.0.2\",\"Oracle\",\"resmgr:cpu quantum\",\"SE\",\"SE2\",\"Standard Edition\"],\"articleSection\":[\"Database Administration &amp; Monitoring\",\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oracle-standard-edition-two\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-standard-edition-two\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/oracle-standard-edition-two\/\",\"name\":\"Oracle Standard Edition Two - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-standard-edition-two\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-standard-edition-two\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureSE2-001-1.jpg\",\"datePublished\":\"2015-09-02T05:00:08+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"description\":\"First info about Standard Edition 12c Patchset 1\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-standard-edition-two\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oracle-standard-edition-two\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-standard-edition-two\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureSE2-001-1.jpg\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureSE2-001-1.jpg\",\"width\":809,\"height\":291},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-standard-edition-two\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle Standard Edition Two\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\",\"name\":\"Oracle Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"caption\":\"Oracle Team\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Oracle Standard Edition Two - dbi Blog","description":"First info about Standard Edition 12c Patchset 1","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/oracle-standard-edition-two\/","og_locale":"en_US","og_type":"article","og_title":"Oracle Standard Edition Two","og_description":"First info about Standard Edition 12c Patchset 1","og_url":"https:\/\/www.dbi-services.com\/blog\/oracle-standard-edition-two\/","og_site_name":"dbi Blog","article_published_time":"2015-09-02T05:00:08+00:00","og_image":[{"width":809,"height":291,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureSE2-001-1.jpg","type":"image\/jpeg"}],"author":"Oracle Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-standard-edition-two\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-standard-edition-two\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"Oracle Standard Edition Two","datePublished":"2015-09-02T05:00:08+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-standard-edition-two\/"},"wordCount":739,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-standard-edition-two\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureSE2-001-1.jpg","keywords":["11.2.0.2","Oracle","resmgr:cpu quantum","SE","SE2","Standard Edition"],"articleSection":["Database Administration &amp; Monitoring","Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/oracle-standard-edition-two\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-standard-edition-two\/","url":"https:\/\/www.dbi-services.com\/blog\/oracle-standard-edition-two\/","name":"Oracle Standard Edition Two - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-standard-edition-two\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-standard-edition-two\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureSE2-001-1.jpg","datePublished":"2015-09-02T05:00:08+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"description":"First info about Standard Edition 12c Patchset 1","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-standard-edition-two\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/oracle-standard-edition-two\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-standard-edition-two\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureSE2-001-1.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureSE2-001-1.jpg","width":809,"height":291},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-standard-edition-two\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Oracle Standard Edition Two"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee","name":"Oracle Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","caption":"Oracle Team"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/5431","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/27"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=5431"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/5431\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/5435"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=5431"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=5431"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=5431"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=5431"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}