12c (Spatial)
03.05.2015

12c: Spatial Vector Acceleration

There is a new feature in Oracle Spatial 12c, called "Spatial Vector Acceleration". According to Oracle: One of the most notable improvements with Oracle Spatial and Graph 12c can be seen in performance increases in vector data operations. Enabling the Spatial Vector Acceleration feature (available with the Spatial option) dramatically improves the performance of commonly […]


Czytaj
12c & ENDIAN
09.04.2015

12c RMAN: convert between endian formats

There is a great new feature related to the 12c database. The feature that will resolve a lot of problems with migrating databases between endian formats. And thanks to our new partner – Omnitec, who agreed to share with their SPARC resources – I will be able to demonstrate you this powerful solution. Oracle has […]


Czytaj
12c
09.02.2015

12c: New "small" features: DBCA

There are a lot of new powerful features in the 12c database but don’t forget about the little features that can make a DBA happier on the day to day basis 🙂 One of my favourites is a new approach to use a DBCA command line interface to create a database in silent mode: Nice, […]


Czytaj
12c
27.01.2015

Slow TRUNCATE TABLE due to operations on MON_MODS$

One of my customers had a problem with a very slow TRUNCATE TABLE operation on a partitioned table having 22 000 partitions. The problem has raised after a test migration to database 12c. I’ve prepared a little demo to address this issue and show the walkaround for it. Oracle Database 12c (12.1.0.2): Oracle Database 11g […]


Czytaj
TUNING
10.10.2014

Oracle 11g & 12c: tunning the sort and hash operations

Hash and sort operations are perfomed in PGA. Quoting after the documentation: A sort operator uses a work area (the sort area) to perform the in-memory sorting of a set of rows. Similarly, a hash-join operator uses a work area (the hash area) to build a hash table from its left input. If the work […]


Czytaj
12c
27.09.2014

Oracle 12c: Oracle ASM Filter Driver (AFD)

In Oracle 12c (12.1.0.2 to be exact) we can find a cool new feature: Oracle ASM Filter Driver. Quoting after the documentiation: Oracle ASM Filter Driver (Oracle ASMFD) is a kernel module that resides in the I/O path of the Oracle ASM disks. Oracle ASM uses the filter driver to validate write I/O requests to […]


Czytaj
12c
17.06.2014

Oracle 12c – WITH FUNCTION

In Oracle 12c there is a possibility to define a PL/SQL function inside the "WITH" clause, which can reduce the context switching overhead. Short example:


Czytaj
12c
11.06.2014

Oracle Database 12c new features (Data Guard & RMAN)

Moja prezentacji z konferencji COIG http://prezi.com/ov5xbjytuzgw/?utm_campaign=share&utm_medium=copy&rc=ex0share


Czytaj
12c
26.04.2014

Oracle 12c – FETCH FIRST n ROWS ONLY

Oracle 12c offers a lot of fascinating new features – among them (at last) "FETCH FIRST n ROWS ONLY" syntax. http://www.oracle-base.com/articles/12c/row-limiting-clause-for-top-n-queries-12cr1.php Out of curiosity I’ve checked with 10053 event, the following query: And this was the result 🙂


Czytaj
1 2

Kontakt

Database Whisperers sp. z o. o. sp. k.
Al. Jerozolimskie 200
Wejście B, III piętro/ pokój 342
02-486 Warszawa
NIP: 5272744987
REGON:362524978
+48 508 943 051
+48 661 966 009
info@ora-600.pl

Newsletter zapisz się żeby być na bieżąco