FIELD NOTESTHE ORA-600 BLOGSearch /THE LATEST DISPATCHES
117 field notes / page 7 of 10
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
Change VOTE and OCR location First we have to create new ASMLib binding
There is a great new feature related to the 12c database. The feature that will resolve a lot of problems with migrating databases between endian formats. And thanks to our new partner – Omnitec, who agreed to