SharePointCommunity

Die deutschsprachige SharePoint Community für SharePoint 2013, 2010 und Office 365

Anmelden | Beitreten | Hilfe

SharePoint Mirror » Alle Tags » Oracle (RSS)

Nach Markierungen suchen

Blogs

SharePoint Mirror

Home

Syndication

RSS
Atom
Kommentar-RSS
E-Mail-Aktualisierungen empfangen
Abonnieren

Archives

Multi-temporal Features in Oracle 12c

Oracle 12c has a feature called Temporal Validity. With Temporal Validity you can add one or more valid time dimensions to a table using existing columns, or using columns automatically… ...read more...( read more ) Mehr…

Veröffentlicht 4 Jan 2014 13:19 von triBLOG

Gespeichert unter: Oracle, Total Recall, Flashback, Transaction Time, Temporal Database, Oracle 12c, Flashback Data Archive, Decision Time, Valid Time
Column-less Table Access

While writing some JUnit tests after fixing bugs in dependency analysis views, I came up with the following query: [crayon-52c5cf2fd9f92199417224/] The first view tvd_object_usage_v contains all table/view usages per object.… ...read more...( read...

Veröffentlicht 2 Jan 2014 21:29 von triBLOG

Gespeichert unter: Oracle, Oracle 11gR2, Dependency Analysis, TVDCA
Playing with Oracle 12c Multitenant Users and Roles

I’ve realized these days that the great list of articles by Oracle Alchemist does not contain any articles describing a little more in depth common roles and Users. I’ve found these ones by Pete Finnigan and Bobby Curtis: http://www.petefinnigan...

Veröffentlicht 10 Nov 2013 21:56 von triBLOG

Gespeichert unter: Oracle, Oracle Database, New Features, Oracle Database 12c, multitenant, Trivadis Blog
How many Oracle instances can be consolidated on a single server?

According to Exadata consolidation guide, this is what you can consolidate on Oracle specialized Hardware: NOTE: The maximum number of database instances per cluster is 512 for Oracle 11g Release 1 and higher. An upper limit of 128 database instances...

Veröffentlicht 6 Nov 2013 10:02 von triBLOG

Gespeichert unter: Server, Oracle, Oracle Database, Oracle RAC, Oracle Database 12c, Trivadis Blog, workload, RAC, Capacity Planning, consolidation
Trivadis PL/SQL & SQL CodeChecker Released

In August 2009 Trivadis – the company I work for – released the first version of their PL/SQL & SQL Coding Guidelines. Back then we made our PL/SQL assessments based… ...read more...( read more ) Mehr…

Veröffentlicht 20 Okt 2013 16:07 von triBLOG

Gespeichert unter: Oracle
TVDCA 0.5.1 Beta Released

A month ago I had a talk about “Extending the Oracle Data Dictionary for Fine-Grained PL/SQL and SQL Analysis” during the ODTUG Kscope13 conference in New Orleans. Oracle data dictionary views as DBA_IDENTIFIERS or DBA_DEPENDENCIES are in...

Veröffentlicht 28 Jul 2013 20:50 von triBLOG

Gespeichert unter: SQL, Oracle, PL/SQL, Oracle 11gR2, Dependency Analysis, Oracle 12cR1
Trivadis PL/SQL & SQL CodeAnalyzer Released

A month ago I had a talk about “Extending the Oracle Data Dictionary for Fine-Grained PL/SQL and SQL Analysis” during the ODTUG Kscope13 conference in New Orleans. Oracle data dictionary views… ...read more...( read more ) Mehr…

Veröffentlicht 28 Jul 2013 20:50 von triBLOG

Gespeichert unter: SQL, Oracle, PL/SQL, Dependency Analysis, Oracle 10g, Oracle 11g, TVDCA, Oracle 12c
Oracle 12c and Easter Bunnies

Most of you will think now: What have easter bunnies to do with Oracle 12c? If you attended the Trivadis course SQL Optimizer and Performance Workshop in the last few years, you probably know what I' writing about. One of the exercises in this course...

Veröffentlicht 13 Jul 2013 15:21 von triBLOG

Gespeichert unter: Oracle, Performance, tc12c, #tc12c
Null Accepting Semi-Joins in 12c

Eine der neuen Optimierungstechniken, die im Query Optimizer 12c Einsatz finden, sind die sogenannten Null accepting semi-joins. Einen Semi-Join sieht man bei “IN” oder “EXISTS”-Subqueries, wenn der Optimizer als Transformation...

Veröffentlicht 13 Jul 2013 15:04 von triBLOG

Gespeichert unter: SQL, Oracle, TrivadisContent, Trivadis, 12c, tc12c, Subquery, SEMI JOIN, null accepting, CBO, optimizer
TechnoCircle Oracle 12c – Termine verfügbar

Die Termine für das TechnoCircle sind nun verfügbar. Nutzt die Chance, um exklusives Expertenwissen zu bekommen. Im September 2013 besuchten ausgesuchten Trivadis-Spezialisten die Beta Test Events im Oracle Headquarter in Redwood Shores. Die...

Veröffentlicht 26 Jun 2013 13:08 von triBLOG

Gespeichert unter: Oracle, Security, TrivadisContent, 12c, tc12c
Oracle Warehouse Builder on an Oracle 12c Database

Oracle Database 12c Release 1 is available since a few hours. One important question for many data warehouse and ETL developers is: What happens to Oracle Warehouse Builder (OWB)? As mentioned earlier in this blog and described in Oracle's Statement...

Veröffentlicht 25 Jun 2013 23:17 von triBLOG

Gespeichert unter: Oracle, ETL, Oracle Warehouse Builder
Moving Archived Redo Logs with RMAN

Some RMAN stuff today. At a customer I was asked how I would handle a specific situation: The backup infrastructure has a problem. Backups to SBT_TAPE do not work. The databases have a problem now as there is a high risk for an archiver stuck as the log...

Veröffentlicht 29 Mai 2013 19:34 von triBLOG

Gespeichert unter: Oracle, RMAN
Loading Historical Data Into Flashback Archive Enabled Tables

Oracle Support provides on request an import solution for FBA (Flashback Data Archive also known as Total Recall). The solution extends the SCN to TIMESTAMP mapping plus provides a wrapper to existing APIs to populate the history. However, issues like...

Veröffentlicht 3 Jan 2013 3:34 von triBLOG

Gespeichert unter: Oracle, Total Recall, Flashback, Oracle 11gR2, Transaction Time, Temporal Database
Joining Temporal Intervals Part 2

The solution I’ve provided in Joining Temporal Intervals produces wrong results if one or more temporal tables have gaps in their history or if disconnected intervals have the same content. In this post I’ll address both problems. Test Data...

Veröffentlicht 28 Dez 2012 19:36 von triBLOG

Gespeichert unter: Oracle
Merging Temporal Intervals with Gaps

In Joining Temporal Intervals I explained how to join multiple temporal tables. The provided solution merges also temporal intervals but – as pointed out in that post – may produce wrong results if the underlying driving table is not gaplessly...

Veröffentlicht 27 Dez 2012 16:05 von triBLOG

Gespeichert unter: Oracle

1 2 3 Weiter >

CC BY-NC-ND - Michael Greth

Mit Community Server (Commercial Edition), von Telligent Systems

3DZL:andrewbelon.com

Nach Markierungen suchen

Blogs

Sponsored by

Syndication

Recent Posts

Tags

Archives

Multi-temporal Features in Oracle 12c

Column-less Table Access

Playing with Oracle 12c Multitenant Users and Roles

How many Oracle instances can be consolidated on a single server?

Trivadis PL/SQL & SQL CodeChecker Released

TVDCA 0.5.1 Beta Released

Trivadis PL/SQL & SQL CodeAnalyzer Released

Oracle 12c and Easter Bunnies

Null Accepting Semi-Joins in 12c

TechnoCircle Oracle 12c – Termine verfügbar

Oracle Warehouse Builder on an Oracle 12c Database

Moving Archived Redo Logs with RMAN

Loading Historical Data Into Flashback Archive Enabled Tables

Joining Temporal Intervals Part 2

Merging Temporal Intervals with Gaps