FIELD NOTESTHE ORA-600 BLOGSearch /THE LATEST DISPATCHES
119 field notes / page 7 of 10
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
One of the new CBO features in database 12c is "sql plan directives". The main purpose of this functionality is to deliver better adaptive plans if object statistics does not reflect the reality. Quoting after
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:
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 increas
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
Procedure to convert a standalone database to RAC 11gR2 I have a single-instance database and I want to convert it to RAC with minimum downtime. 1 select * 2 from v$option 3* where lower(parameter) like ‘%real
Add a new node to RAC Check the network configuration for both nodes On the with active cluster, check the network configuration