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
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
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
EXADATA
07.05.2014

Exadata – skgxpinfo returns UDP after reconfiguration

We had to change the hostnames on Exadata with one of the customers. It is a well known fact that RAC doesn’t like such changes – we had to reconfigure the cluster and after the whole process I found the funny thing: So let’s try to turn RDS on 🙂 After shutting down all cluster […]


Czytaj
SQL
30.04.2013

SQL For Modeling

Do you realy know SQL? I mean Oracle SQL…. Maybe you should take a closer look: http://ora-600.pl/art/sql-for-modeling.pdf


Czytaj
1 2 3 4

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