This is a very quick post, because I’m about to log off and take an extended summer holiday (or vacation as my crazy American friends call it… but then they call football “soccer” too). Before I go, I wanted to document my initial findings with the new ASM Filter Driver feature introduced in this week’s 12.1.o.2 patchset.
Pour activer AWR Warehouse, l'administrateur d'Enterprise Manager doit :
- Créer une instance de base de données Oracle Database 188.8.131.52 (recommandé) ou 184.108.40.206+ pour le référentiel AWR
- Découvrir l'instance dans EM12c
- Appliquer le patch sur l'OMS (cela permet d'avoir AWR Warehouse dans le menu)
- Appliquer le (more...)
This is a post about Oracle Automatic Workload Repository (AWR) Reports. If you are an Oracle professional you doubtless know what these are – and if you have to perform any sort of performance tuning as part of your day job it’s likely you spend a lot of time immersed in them. Goodness knows I do – a few weeks ago I had to analyse 2,304 of them in one (long) day. But for anyone (more...)
Oracle is offering a comprehensive set of Database High Availability capabilities that seamlessly work together to help reduce both planned and unplanned downtime. Oracle Maximum Availability Architecture (MAA) provides with a best practices blueprint that can significantly reduce the cost and complexity of database high availability deployments. In our webcast we will provide an overview of the latest technologies for backup and recovery of the Oracle Database, guiding you through Oracle Recovery Manager, common configuration (more...)
本日、Oracle Database 220.127.116.11の提供を開始しました。（プレスリリース資料はこちら）
明日、7月24日(木）｢Oracle DBaaS & Big Data Summit｣が東京・恵比寿で開催されます。
(以下は、米国オラクルのDatabaseテクノロジストMike Dietrichのブログ｢Update your Database-NOW!｣の抄訳です。)
Oracle Database 18.104.22.168が、OTNサイト（US)からダウンロード可能になりました。これまでのビルドで最も広範囲に及ぶパッチセットとなります。
Oracle Database In-Memoryのほか、様々な新機能の追加･機能向上が行われています。是非、最新のOracle Database 12cをお試し下さい。
Point 1) フル・リリースです。前バージョン22.214.171.124を入手する必要はありません。
Point 2) OTNおよびeDeliveryで入手可能です。（126.96.36.199はまもなく削除されます）
Point 3) とりあえず、Enterprise Editionのみです。SEならびにSE Oneは後日リリース予定です。(詳細は、MOS Note:1905806.1(英語）をご覧下さい）
Oracle Database In-Memory
Oracle Big Data SQL
A new customer-facing ACS whitepaper entitled, “Migrating Oracle Databases” featuring (ACS’) Oracle Migration Service is now available. Review it today!
For some time now I have preferred Oracle SLOB as my tool for generating I/O workloads using Oracle databases. I’ve previously blogged some information on how to use SLOB for PIO testing, as well as shared some scripts for running tests and extracting results. I’ve now added a whole new landing page for SLOB and a complete guide to running sustained throughput testing.
Why would you want to run sustained throughput tests? Well, one (more...)
In my recent post I already mentioned it a little bit: Integrating your manual Data Guard Broker configuration in OEM Cloud Control can become a sort of climbing a Mountain. And it doesn’t have to be.
But first a short description of the situation. I have a working Data Guard broker configuration between two Cluster Databases running Oracle 188.8.131.52 on linux x86-64. Both clusters have an Cloud Control agent (184.108.40.206) (more...)
I wrote about the Code Based Access Control (CBAC) stuff in Oracle Database 12c a while back.
- Code Based Access Control (CBAC) : Granting Roles to PL/SQL Program Units in Oracle Database 12 Release 1 (12.1)
I’ve recently “completed the set” by looking at the INHERIT PRIVILEGES and BEQUEATH CURRENT_USER stuff for PL/SQL code and views respectively.
One of my clients has been running an Oracle RDB database on VMS for decades.
This RDB database stores mission critical data and interfaces with COBOL applications and Oracle 8i databases.
(If you wonder what RDB is; it’s a RDBMS created by DEC in 1984 and bought by Oracle in 1994)
While modernizing the IT landscape, the client expressed the desire to reduce complexity and migrate the mission critical data in RDB to an Oracle (more...)
The last few months I’ve been working with Oracle Data Guard, reading lots of manuals and (parts of) books, to make smart decisions and get a solid foundation. I consider myself part of the people who like to work with the command line. That way you really get to understand what you are doing and you won’t have to panic when you don’t have a GUI at your disposal. Once that’s an acquired skill I will (more...)
!The code contained in this post is meant to be used at your own risk!
With any Oracle GoldenGate replication configuration, it is always good to monitor what is going on. One aspect that many people want to know is how can I validate that every record is being transferred to the target system. Once such way is to use Oracle Veridata; however, some times there is not enough time to setup and (more...)
In the past I have been a little critical of Oracle’s support notes and documentation regarding the use of Advanced Format 4k storage devices. I must now take that back, as my new friends in Oracle ASM Development and Product Management very kindly offered to let me write a new support note, which they have just published on My Oracle Support. It’s only supposed to be high level, but it does confirm that the _DISK_SECTOR_SIZE_OVERRIDE (more...)