Nach Markierungen suchen

Offline Analysis of ASH Data with ASHDUMP

From time to time, it happens to me to carry out offline analyses of ASH data. For that, I mean to analyze the ASH data without having access to the database instance that generated it. For that purpose, Oracle Database provides the possibility to dump...

Veröffentlicht 6 Jul 2017 13:58 von triBLOG

Gespeichert unter: 11gR2, 12cR1, 12cR2, Active Session History

Oracle CPU / PSU Announcement April 2017

Last night Oracle released there new Critical Patch Update. From the DB perspective it is a rather small patch update. It just includes 2 fixes for security vulnerabilities on Oracle database 11.2.0.4 and 12.1.0.2. None of the vulnerabilities are remote...

Veröffentlicht 19 Apr 2017 6:45 von triBLOG

Gespeichert unter: Security, 11gR2, Trivadis, Trivadis Content, 12cR1, Trivadis Security eXperts, Critical Patch Update, Security Patch Update, Patch Set Update

Oracle CPU / PSU Announcement January 2017

Oracle has published the first Critical Patch Update in 2017. It’s quite a huge update with not less than 270 new security vulnerability fixes across the Oracle products. For the Oracle Database itself are 5 security fixes available respectively...

Veröffentlicht 18 Jan 2017 15:34 von triBLOG

Gespeichert unter: Security, 11gR2, Trivadis, Trivadis Content, 12cR1, Trivadis Security eXperts, Critical Patch Update, 12cR2

Ad – Oracle Database 12c Release 1 and 2: New Performance Features

In the past I gave a number of 1-day seminars about the new performance features available in Oracle Database 12c Release 1. On the 23rd of January, for the first time, I’ll give an updated version of that seminar with content about both Release 1 and...

Veröffentlicht 20 Dez 2016 14:24 von triBLOG

Gespeichert unter: Speaking, Query Optimizer, 12cR1, in-memory, 12.1.0.2, Adaptive Query Optimization, 12cR2, Approximate Query Processing

Initialization Parameters Set at the PDB Level Are Not Always Honored

Before describing the issue that lead to this post, let’s shortly review how the handling of initialization parameters works in a multitenant environment. Initialization parameters exist at both the CDB level and the PDB level. This is a critical feature...

Veröffentlicht 11 Nov 2016 9:58 von triBLOG

Gespeichert unter: bug, 12cR1, multitenant, 12cR2

Trace Files Split in Multiple Parts

Last January, in the following tweet, I pointed out that the documentation vaguely mentions that a trace file may be split into several files. Did you successfully tested the new MAX_DUMP_FILE_SIZE behavior? If yes, which version/OS?https://t.co/4F9f9wsT95...

Veröffentlicht 13 Okt 2016 16:56 von triBLOG

Gespeichert unter: SQL Trace, 12cR1, 12cR2

Adaptive Query Optimization Configuration: Parameters, Preferences and Fix Controls

The aim of this post is to summarize the knowledge about the 12.1 and 12.2 adaptive query optimizer configuration that, as far as I know, is spread over a number of (too many) different sources. First of all, let’s shortly review which adaptive query...

Veröffentlicht 7 Okt 2016 17:53 von triBLOG

Gespeichert unter: Uncategorized, Query Optimizer, 12cR1, Adaptive Query Optimization, sql plan directives, Oracle Cloud, 12cR2

Statement-level PARALLEL Hint

From version 11.2 onward, the PARALLEL hint supports two syntaxes: object-level and statement-level. The object-level syntax, which is the only one available up to version 11.1, overrides the DOP associated to a tables. The statement-level syntax can...

Veröffentlicht 17 Sep 2016 2:03 von triBLOG

Gespeichert unter: 11gR2, Query Optimizer, 12cR1, Parallel Processing

Losing the Oracle Wallet for Enterprise User Security

Having a reliable backup solution for your Transparent Data Encryption (TDE) or Enterprise User Security (EUS) Wallets, is beyond discussion. Nevertheless it can happen that you lose or corrupt the Oracle Wallet. With Transparent Data Encryption (TDE...

Veröffentlicht 14 Sep 2016 10:40 von triBLOG

Gespeichert unter: Oracle Database, Troubleshooting, Security, 11gR2, 12cR1, Trivadis Security eXperts, wallet, Enterprise User Security

Oracle CPU / PSU Pre-Release Announcement July 2016

Oracle has published the Pre-Release Announcement for the July 2016 Critical Patch Update. It’s quite a huge update with not less than 276 security vulnerability fixes across the Oracle products. For the Oracle Database itself are 9 security fixes...

Veröffentlicht 15 Jul 2016 11:30 von triBLOG

Gespeichert unter: Oracle Database, Security, 11gR2, 12cR1, Trivadis Security eXperts, Critical Patch Update, Security Patch Update, Patch Set Update

Trivadis Schwaben Gipfel – Top 10 Database Threads and Risk Management

Just finished my second presentation at the Trivadis Schwaben-Gipfel in Stuttgart. It is about Database Threads and Risk assessment and a few considerations on Database classification. The slides are available for download . ...read more...( read more...

Veröffentlicht 14 Jul 2016 19:10 von triBLOG

Gespeichert unter: Security, 11gR2, Presentation, Speaking, 12cR1, Trivadis Security eXperts

Using Kerberos in Oracle Standby Edition

Since the release of Oracle 12cR1 mid 2013 the network encryption and strong authentication services has been removed from the Oracle Advanced Security Option. Both feature are now available for any licensed editions. Corresponding section in the Oracle...

Veröffentlicht 6 Jul 2016 0:16 von triBLOG

Gespeichert unter: Security, 11gR2, Trivadis Content, Kerberos, 12cR1, Trivadis Security eXperts

Using Kerberos in Oracle Standard Edition

Since the release of Oracle 12cR1 mid 2013 the network encryption and strong authentication services has been removed from the Oracle Advanced Security Option. Both feature are now available for any licensed editions. Corresponding section in the Oracle...

Veröffentlicht 6 Jul 2016 0:16 von triBLOG

Gespeichert unter: Security, 11gR2, Trivadis Content, Kerberos, 12cR1, Trivadis Security eXperts

Ad: Der Oracle DBA – Handbuch für die Administration der Oracle Database 12c

The 2nd revised edition of the Der Oracle DBA will finally be released in a couple of days. Pre-Orders are already possible. It took quite a while until the publication of this release. Work on the second edition began as early as a year ago. This edition...

Veröffentlicht 4 Jul 2016 17:49 von triBLOG

Gespeichert unter: Oracle Database, Security, Trivadis Content, 12cR1, Trivadis Security eXperts

WALLET_LOCATION in sqlnet.ora for Container Databases

Recently I’ve setup Oracle Enterprise User Security (EUS) with Oracle Unified Directory (OUD) on my favorite linux test system. Among regular 11.2.0.4 and 12.1.0.2 databases I do also have a 12.1.0.2 Container Database. EUS work like a charm on...

Veröffentlicht 31 Okt 2015 14:00 von triBLOG

Gespeichert unter: Security, 12cR1, Trivadis Security eXperts, wallet, SEPS, Enterprise User Security, EUS, ORA-28305, Oracle Unified Directory, OUD

Blogs

Sponsored by

Syndication

Recent Posts

Tags

Archives