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

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

Auto SGA Management Impacts the Default Value of DB_FILE_MULTIBLOCK_READ_COUNT

The database engine determines the maximum disk I/O size used during multiblock reads (for example, full table scans or index fast full scans) by multiplying the values of the db_block_size and db_file_multiblock_read_count initialization parameters....

Veröffentlicht 10 Okt 2015 11:05 von triBLOG

Gespeichert unter: bug, 11gR2, 11gR1, 10gR2, Top, 12cR1

Foreign Keys and Library Cache Locks

In this post I would like to describe a behavior of Oracle Database that, at least for me, isn’t obvious at all. Actually, it’s something that I can’t explain why it works in that way. Let’s start by setting the scene by describing the schema I’m using...

Veröffentlicht 3 Sep 2015 16:57 von triBLOG

Gespeichert unter: 11gR2, 11gR1, 10gR2, Library Cache, 12cR1, Contention

Oracle CPU / PSU Pre-Release Announcement January 2015

Oracle has published the Pre-Release Announcement for the first Critical Patch Update in 2015. This Critical Patch Update contains 167 new security vulnerability fixes across all Oracle products. It looks like that this CPU does contain a bunch of critical...

Veröffentlicht 20 Jan 2015 7:59 von triBLOG

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

Secure External Password Store for RMAN

The draft version of this blog post is lying around for some time in my inbox. I've never found time to finish it. But due to a task in a project it's about time to finish my notes on Oracle's Secure External Password Store. Ludovico, a work...

Veröffentlicht 22 Jul 2014 12:41 von triBLOG

Gespeichert unter: Oracle Database, How to, Security, 11gR2, Trivadis Content, RMAN, 12cR1, Trivadis Security eXperts

Oracle CPU / PSU Pre-Release Announcement July 2014

Oracle has published the Pre-Release Announcement for the July 2014 Critical Patch Update. It looks like that the next Critical Patch Update is somewhat more extensive from the database point of view. It does contain six bug fix for some major security...

Veröffentlicht 11 Jul 2014 21:19 von triBLOG

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

Oracle passwords and special characters

As commonly known passwords should have a certain complexity. Thereby it is common to use special characters, numbers, lower and uppercase characters. Depending on the type of special characters Oracle require that the password is enclosed in double quotation...

Veröffentlicht 12 Jun 2014 16:00 von triBLOG

Gespeichert unter: Uncategorized, Security, 11gR2, 12cR1, Trivadis Security eXperts

Blogs

Sponsored by

Syndication

Recent Posts

Tags

Archives