{"id":1640,"date":"2017-05-27T12:53:24","date_gmt":"2017-05-27T10:53:24","guid":{"rendered":"http:\/\/clemente.pamplona.name\/dba\/?p=1640"},"modified":"2017-05-26T16:55:56","modified_gmt":"2017-05-26T14:55:56","slug":"parametros-de-inicio-en-los-pdb","status":"publish","type":"post","link":"http:\/\/clemente.pamplona.name\/dba\/parametros-de-inicio-en-los-pdb\/","title":{"rendered":"Par\u00e1metros de inicio en los PDB"},"content":{"rendered":"<p>Hoy vamos a ver una entrada muy breve sobre los par\u00e1metros de inicio en la nueva versi\u00f3n 12c<\/p>\n<p>Los PDBS no tienen un fichero de inicializaci\u00f3n propio, comparten el  spfile \u00fanico del CDB pero algunos de los par\u00e1metros de este spfile son modificables a nivel de PDB<br \/>\nLa manera de ver cuales son es mediante la consulta <\/p>\n<pre>\r\nselect name from v$system_parameter where ispdb_modifiable=\u2018TRUE';\r\n<\/pre>\n<p>Cada uno de estos (185) son heredados del CDB, y pueden ser modificados mediante <i<ALTER_SYSTEM <\/i>.<br \/>\nSi el scoops es <i>SPFILE<\/i> o <\/i>BOTH<\/i> viajar\u00e1n con la PDB cuando se haga una operaci\u00f3n de plug\/unplug<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Hoy vamos a ver una entrada muy breve sobre los par\u00e1metros de inicio en la nueva versi\u00f3n 12c Los PDBS no tienen un fichero de inicializaci\u00f3n propio, comparten el spfile \u00fanico del CDB pero algunos de los par\u00e1metros de este &hellip; <a href=\"http:\/\/clemente.pamplona.name\/dba\/parametros-de-inicio-en-los-pdb\/\">Sigue leyendo <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[60,744,9],"tags":[752,254,756,750,754,28],"class_list":["post-1640","post","type-post","status-publish","format-standard","hentry","category-12c","category-cdbpdb","category-dummie","tag-pluggable-database","tag-12c","tag-cdb","tag-pdb","tag-pluggable","tag-spfile"],"_links":{"self":[{"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts\/1640","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/comments?post=1640"}],"version-history":[{"count":1,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts\/1640\/revisions"}],"predecessor-version":[{"id":1641,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts\/1640\/revisions\/1641"}],"wp:attachment":[{"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/media?parent=1640"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/categories?post=1640"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/tags?post=1640"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}