Häufig werde ich nach „besten Praktiken“ gefragt – eine Frage, die mir unangenehm ist, da die Antwort in der Regel vom Kontext abhängt. Ich kann natürlich verschiedene „Standardpraktiken“ empfehlen, die sinnvoll sind, wenn es keinen besonderen Grund gibt, anders vorzugehen. Meist geht es dem Fragesteller jedoch um einfache, allgemeingültige Regeln, die sich immer und überall anwenden lassen. Wenn es um generelle Emp-fehlungen geht, zähle ich lieber Dinge auf, die unter allen Umständen vermieden werden sollten.
I like IT automation. I believe automation enables the evolution of IT environments. Indeed, automate your repetitive tasks, and you save time to work on jobs that matter, on tasks that increase the value of your IT ecosystem exponentially. It also makes your day-to-day workload more interesting: learn, code, test, automate and learn something new.
Understanding Oracle Database Performance
Article by Jérôme Dubar
You can find numerous sources on Oracle Database Performance and Tuning on the internet and also a lot of books focusing on that. There is a lot of things to talk about, and you can spend days and days to learn how it works and what can be done. But it’s a hard work and when performance troubles occur, you need to be fast and effective. This is my approach to understand why an Oracle Database is not so performant and elaborate an action plan to improve performance.
Thomas Rein, dbi services – The Oracle Cloud Infrastructure (OCI) provides a platform and tools for consolidating applications and database systems quickly and easily. The supported Oracle releases range from 220.127.116.11 to 18.3. Both Standard and Enterprise Editions are available. The Enterprise Edition is available in three different versions: the basic Enterprise Edition, the High Performance Edition and the Extreme Performance Edition. In the following article, we will examine the possible applications of the OCI in a customer project.
As partner to numerous publishers, both proprietary and Open Source, dbi services is frequently asked to provide software solutions. Our list of partnerships includes EnterpriseDB, Severalnines, Cloudera, Red Hat, MariaDB as well as Oracle, Microsoft and Dbvisit, all three of which are proprietary software publishers.
Admin Magazine, issue 48, by David Barbarin: On November 16, 2016, Microsoft announced the beginning of a new story: SQL Server is now supported on Linux and Docker. Of course, Microsoft emerged long ago from its anti-Linux “dark age,” and they have been moving steadily toward more support for open source since releasing the first pieces of .NET to open source in 2006.
Since Satya Nadella took over as CEO in 2014, the pace of change has accelerated. Microsoft is now a Platinum sponsor of several open source foundations, including the famous Linux Foundation and the MariaDB Foundation, and the Azure cloud platform now comes with support for a number of important open source services and tools. Read more
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.
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.