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
RMAN
15.09.2014

Restore all versions of the spfiles

A few months ago I showed how to restore a controlfile, when you have no idea in which backupset is the newest file http://blog.ora-600.pl/2014/04/26/oracle-myth-you-need-dbid-to-restore-the-controlfile/ On last training one of my students asked me, how to locate an appropriate spfile backup after using this trick (the restored database has a different DBID). Well, you can just […]


Czytaj
TOOLS
10.09.2014

Script for metadata export in SQL*Plus

Sometimes you have to export all metadata for a schema but you have no access to data pump or other tools. SQL Developer can cause a lot of problems with referential constraints. But there is always a good old SQL*Plus 🙂 http://ora-600.pl/oinstall/metadata.sql


Czytaj
INTERVIEW
26.08.2014

Interview for "IT Certification Master"

http://www.itcertificationmaster.com/become-oracle-certified-master-fun-profit-kamil-stawiarski/


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
RAC
16.06.2014

HOWTO: Install Oracle RAC 11gR2 on VirtualBox (OEL6.4)

Install Oracle RAC 11gR2 on VirtualBox: http://www.youtube.com/playlist?list=PLqQNL6H71xCygSF_VqwM8j-Hhft4XoEEx VM templates can be found here: https://mega.co.nz/#!esp1kQQA!CUr8SlErdPppk-GkxedTUAdMpVQPrrrSI3c1ouquAhk Prezi: Route to install simple RAC


Czytaj
RAC
16.06.2014

Oracle RAC 11.2.0.4 – add another ethernet to interconnect

Instead of bonding you can use Oracle cluster interconnect HAIP for using multiple ethernets. And here is how its done 🙂 At the begining I have one interconnect – eth1: To add another one (eth3), I will use an oifcfg tool: Now the restart of the CRS on all nodes is required for changes to […]


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
1 5 6 7 8 9

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