FIELD NOTESTHE ORA-600 BLOGSearch /BROWSE THE FIELD NOTES
116 field notes / page 8 of 10
There is some kind of wrong understanding, regarding what Oracle ASM really is. A lot of people thinks, that this is some kind of file system, provided by Oracle and that Oracle Database reads data "from ASM",
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 DBC
Recently there was a new vulnerability introduced in glibc library: http://www.openwall.com/lists/oss-security/2015/01/27/9 Oracle is using the gethostbyname function in "*skgxp*" libraries: oracle@kokos:~$ fin
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
A lot companies consolidates databases into one appliance – like for example Oracle Exadata. So you can have a lot of different databases in one physical cluster. And what if I tell you that you can execute any
Ludzie z PLUG (http://www.linux.org.pl/) zorganizowali w tym roku pewną wyjątkową konferencję – dBConf (https://www.dbconf.pl/2014/pl/) pod hasłem "Bazodanowcy wszystkich środowisk łączcie się!". Idea zacna i m
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
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/
A few months ago I showed how to restore a controlfile, when you have no idea in which backupset is the newest file https://blog.ora-600.pl/2014/04/26/oracle-myth-you-need-dbid-to-restore-the-controlfile/ On la
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
http://www.itcertificationmaster.com/become-oracle-certified-master-fun-profit-kamil-stawiarski/
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: SQL> create or replace function F_DUMMY(x number) retur