Nach Markierungen suchen

Oracle CPU / PSU Advisory July 2019

Recently, just in the middle of the summer holidays, Oracle has released the third Critical Patch Advisory for its products. It seems there’s a lot of work going on in Redwood Shore. Oracle has fixed about 319 security vulnerabilities across their...

Veröffentlicht 17 Jul 2019 1:22 von triBLOG

Gespeichert unter: Security, 11gR2, Trivadis, 12cR1, Trivadis Security eXperts, Critical Patch Update, Security Patch Update, Patch Set Update, 12cR2, 18c, 19c

Oracle CPU / PSU Pre-Release Announcement July 2018

Today Oracle has published the Pre-Release Announcement for the July 2018 Critical Patch Update. It’s quite a heavy update with not less than 334 security vulnerability fixes across the Oracle products. The Oracle database is relatively prominently...

Veröffentlicht 13 Jul 2018 8:37 von triBLOG

Gespeichert unter: Security, 11gR2, 12cR1, Trivadis Security eXperts, Critical Patch Update, Security Patch Update, Patch Set Update, 12cR2, 18c, 12R2

Oracle CPU / PSU April 2018

Oracle recently released the spring Critical Patch Advisory. It is the first critical patch update, which also includes fixes for Oracle 18c. Over all it includes 254 new security fixes across the product families. Overall a rather large update, although...

Veröffentlicht 18 Apr 2018 6:21 von triBLOG

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

DOAG 2017 Oracle 12c Release 2 Datenbank-Sicherheit in a Nutshell

Below you will find a list of the different demo scripts used during the DOAG training day 2017 Oracle 12c Release 2 Datenbank-Sicherheit in a Nutshell. In general the script do need a SCOTT or a HR demo schema. Some of the scripts may have more requirements...

Veröffentlicht 24 Nov 2017 1:37 von triBLOG

Gespeichert unter: Oracle Database, Security, Trivadis, Speaking, DOAG, 12cR1, Trivadis Security eXperts, 12cR2, Demo Scripts

Oracle CPU / PSU Announcement October 2017

The Oracle open world 2017 is over, the dust just settled down. A perfect time for Oracle to release the October critical patch advisory. With not less than 270 new security vulnerability fixes across the Oracle products it seems to be a rather huge update...

Veröffentlicht 18 Okt 2017 11:55 von triBLOG

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

Activating and Deactivating Performance Feedback

Performance feedback is one of the adaptive query optimizer features introduced in Oracle Database 12c. The aim of this short post isn’t to explain how it works, but to simply warn you about a buggy behavior in its configuration. The parameters that control...

Veröffentlicht 26 Sep 2017 18:40 von triBLOG

Gespeichert unter: 12cR1, Parallel Processing, Adaptive Query Optimization, 12cR2, Statistics Feedback

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

Blogs

Sponsored by

Syndication

Recent Posts

Tags

Archives