Database Administration & Monitoring, Oracle Configure the Resource Manager with SQL Developer 23.08.2015 by Oracle Team By Franck Pachot . Yes, the topics for the OCM 12c upgrade are online and I'm already looking at the topics. I'm talking about the 'Configure the Resource Manager' one here. Configuring Resource Manager in commandline(…)
Database Administration & Monitoring, Oracle DataGuard broker properties – Part II: log shipping parameters 23.08.2015 by Oracle Team By Franck Pachot . In the part I we have seen the properties that are imported when you add a database to the configuration, and which are then managed by the(…)
Development & Performance, Oracle OCM 12c preparation: Materialized View explain_rewrite 23.08.2015 by Oracle Team By Franck Pachot . When I passed the OCM 11g exam, I had to prepare the 'Manage Materialized Views to improve rewrite' topic. Now that I'm preparing the 12c upgrade I checked quickly what I've(…)
Database Administration & Monitoring, Oracle DataGuard broker properties – Part I: imported parameters 23.08.2015 by Oracle Team By Franck Pachot . When you are using the DataGuard Broker, you should always use the broker (with DGMGRL or OEM) to change the parameters that are managed, rather than changing them with ALTER SYSTEM. But do you know which(…)
Database management, Oracle RESULT_CACHE hint expiration options 05.07.2015 by Oracle Team By Franck Pachot . The result cache is very nice when base tables are static: get the result without any buffer get, without any join or sorts. But as soon as any DML occurs on one of the tables(…)
Database management, Oracle Multitenant vs. schema based consolidation 30.06.2015 by Oracle Team By Franck Pachot . If you want to install multiple instances of a software, for example you host the ERP for several companies or subsidiaries, you have 3 solutions: have one database and multiple schema have multiple databases have(…)
Database management, Oracle Oracle Log Writer and Write-Ahead-Logging 28.06.2015 by Oracle Team By Franck Pachot . I posted a tweet with a link to a very old document – 20 years old – about ‘internals of recovery’. It’s a gem. All the complexity of the ACID mecanisms of Oracle are(…)
Database management, Oracle Oracle Database Cloud Service – My first trial 27.06.2015 by Oracle Team By Franck Pachot . The cloud has been annouced, I want to try. From the cloud.oracle.com/database website, there is Trial only for the ‘Database Schema Service’ so I asked fot it, received an e-mail with connection info and it(…)
Database management, Oracle RAC buffer states: XCUR, SCUR, PI, CI 25.06.2015 by Oracle Team By Franck Pachot . In RAC, blocks are copied across instances by the Global Cache Service. In single instance, we have only two status: CR for consistent read clones where undo is applied, and CUR for the current version(…)
Database management, Oracle Multithreaded 12c and ‘connect / as sysdba’ 24.06.2015 by Oracle Team By Franck Pachot . In Oracle 12c you can run Oracle processes as operating system threads, lowering the number of OS processes. But you can’t use OS authentification: you need to provide a password. Here is a way to(…)