Archiv der Kategorie: General

Flashback in a Data Guard Environment but what are the steps

The Setup of an Data Guard environment with Physical Standby via Data Guard Broker was done including an Switchover. Everything fine and works as expected. (Oracle Release is 12.1.0.2 and PSU Jan 2017). The Dev Team asked for a Flashback … Weiterlesen

Veröffentlicht unter General, Oracle 12.1 | Verschlagwortet mit | Kommentar hinterlassen

Problems with Adaptive Features in 12.1.0.2 What’s to do?

The Adaptive Features is divided in two parts Adaptive Plans the possibility to change plans during execution Adaptive Statistics the statistics allow plans to be built from the results of previous executions Version 12.1  In 12.1 both components  will be … Weiterlesen

Veröffentlicht unter General, Oracle 12.1, Oracle 12.2, Oracle Database | Verschlagwortet mit , | Kommentar hinterlassen

Oracle RU is available

Today Oracle released a very large „monster“ Upgrade. This July 2017 Update includes the first time the new RU „Release Upgrade“ and RUR „Release Update Revision“ Patches. To be up to date read the following My Oracle Support Doc-ID’s MOS … Weiterlesen

Veröffentlicht unter General, Oracle 12.2, Oracle Database | Verschlagwortet mit , , | 1 Kommentar

Oracle ACE

Vor zwei Jahren als Oracle ACE Associate gestartet, wurde ich nun zum Oracle ACE „befördert“.  Vielen Dank Two years ago I started as Oracle ACE Associate and now I was „promoted“ to the Oracle ACE status. Many Thanks     … Weiterlesen

Veröffentlicht unter General | Verschlagwortet mit , | Kommentar hinterlassen

How to fix ‚PLAN_TABLE‘ is old version

During a lot of SQL Performance activities I saw all the time the following message but why? Yes, I did a few days before an Upgrade from 11.2.0.4 -> 12.1.0.2. Now I start to check out some important SQL Queries … Weiterlesen

Veröffentlicht unter General, Oracle 12.1 | Verschlagwortet mit , | Kommentar hinterlassen

rman auxiliary (for duplicate)

I just do some tests with the Oracle 12.2 Release and while doing tests it is all the time better to have a second database and that is the time for rman. So I looked around and found an easy … Weiterlesen

Veröffentlicht unter General, Oracle 12.2, Oracle Database | Verschlagwortet mit , | Kommentar hinterlassen

Oracle Engineered Systems Production

I found a old video concerning the „real“ production of an Oracle Engineered System but it’s really good and cool stuff. https://vimeo.com/46778003 Have fun  

Veröffentlicht unter Engineered Systems, Exadata, General | Kommentar hinterlassen

neue DOAG Webseite ist online

Die neue DOAG Webseite ist Online. https://www.doag.org/de/home/    

Veröffentlicht unter General | Kommentar hinterlassen

Let’s start with Oracle Database 12c Release 2

Yes and now Oracle 12.2 is available (Linux x86_64) for download from OTN. http://www.oracle.com/technetwork/database/enterprise-edition/downloads/oracle12c-linux-12201-3608234.html Let’s start with Installation and Setup ….    

Veröffentlicht unter General, Oracle 12.2, Oracle Database | Verschlagwortet mit | Kommentar hinterlassen

Oracle DBSAT first experience

Last year in October Oracle released the Oracle Database Security Assessment Tool (DBSAT) to analyzes database configurations and security policies to improve the security in your environment. Real benefits quickly identify security configuration errors in the database environment lauch Security … Weiterlesen

Veröffentlicht unter General | Verschlagwortet mit | 1 Kommentar