FIELD NOTESTHE ORA-600 BLOGSearch /BROWSE THE FIELD NOTES
59 field notes / page 4 of 5
Thanks to Oracle I had a possibility to test the new Sparc M7 with DAX coprocessors to boost In-Memory performance. You can read about it here and here My first thought was – how to check if and when the DAX co
Let’s imagine the following situation – you have a table called EMPLOYEES_TMP which is a global temporary table with a variable number of rows – totally nondeterministic. And there is a query which runs very of
Let’s check, why PRAGMA UDF makes execution faster, then regular function. C function responsible for calling a PL/SQL code from SQL is called "plsql_run":
I’ve already showed you, how to escalate privileges in Oracle Databases. https://blog.ora-600.pl/2013/04/02/privilege-escalation-in-oracle-11gr2-part1/ https://blog.ora-600.pl/2014/12/23/simple-technics-of-priv
I było tak, że 31 dnia miesiąca sierpnia roku 2015, spotkali się entuzjaści Wyroczni w posiadłości AVIVA. I było tak, że dzierżąc kufle – po brzegi browarem wypełnione – zasiadło wielu aby posłuchać kilku, któr
I’ve started the project called RICO – the tool, written in C++ for last resort data recovery. It can be used to extract data from corrupted datafiles and dump them in the form of text files. It is in the early
Recently one of my students asked me if there is any correlation between the AU size in ASM diskgroup and parameter db_file_multiblock_read_count. I made some tests but results are very strange. I have 4 same t
At the beginning we have to prepare parameter file for the new instance *._catalog_foreign_restore=FALSE *.audit_trail=’db’ *.compatible=’12.1.0.2.0′ *.db_block_size=8192 *.db_create_file_dest=’/u01/app/oracle/
Let’s try to migrate database to ASM diskgroup without big maintenance window. I have database and ASM (11.2.0.4) – the database is prepared to migration: SQL> sho parameters db_recovery_file_dest NAME TYPE VAL
I have configured two devices for ASM – one with ASMLib and one with UDEV:
In this article I will show how to change IP address of cluster interconnect. First we have to define new address of the cluster interconnect before we change network settings.
In this article I will show how to reconfigure IP addresses in public network for RAC. ` First we have to close all cluster resources