Oracle Scene Winter 2017, issue 66, by Franck Pachot: Transporting data physically is faster and more predictable than a logical export / import. Therefore, it should be preferred for migration of large databases when possible. However, you may need more flexibility than that offered by Data Pump when moving a subset, or changing the version or platform.
Category Archives: dbi services in the press
Oracle Scene Winter 2017, issue 66, by Pascal Brand : WebLogic 12.2.1 provides a new REST management interface with full access to all WebLogic Server resources. This interface offers an alternative to WebLogic Scripting Tool (WLST) scripting or Java Management Extensions (JMX) developments for management and monitoring of WebLogic Domains. Because these RESTful queries are URLs, they can be integrated quickly with little development in all the monitoring tools supporting HTTP requests such as Nagios or others written in Java, for example. The usage of those RESTful HTTP requests simplifies the monitoring of a WebLogic Domain. This article describes the usage of the RESTful interface from the monitoring point of view and describes two monitoring tools and the RESTful implementations.
Oracle Scene Winter 2016, issue 62, by Franck Pachot. The Oracle Database Appliance is not new. The idea comes from early 2002 with the ‘Row Iron’ plan: an appliance with Sun server and Oracle Database. The idea was resurrected in 2011 with ODA V1 and has evolved through capacity and flexibility to X3-2, X4-2 and X5-2. This year the new one, X6-2 has been announced with some major changes. Read more
October 2014, Yann Neuhaus. This article presents how to configure the Oracle*Net encryption with Oracle 11g. It summarizes and consolidates several sources of information found on the web and in Oracle documentation in order to reach easily a successful setup which can be easily tested between an Oracle client and a Server.
1st edition 2016 of the RedStack magazine (formerly called “DOAG/SOUG-News”). Article written by Franck Pachot, about the subject: “What gain would you make with a transition to Exadata? – Part II ” (article in French)
If you wish to read the part l (article in French), please click here.
If you wish to read the part lI (article in French), please click here.
Spring 2015, Franck Pachot. You must have system statistics if you want the optimizer to evaluate correctly the cost of full table scans vs. index access. But you have two options to gather them: NOWORKLOAD and WORKLOAD. The latter seems to be the more accurate one because it fits your workload. But do you really know how they are calculated?