(Hemant K Chitale) There are two different VALIDATE commands for Backups. (These are different from RESTORE VALIDATE which I’d blogged about earlier in 10.2 here)
Tag: Oracle
Managing ORE in-database Data Stores using SQL
(Brendan Tierney) When working with ORE you will end up creating a number of different data stores in the database. Also as your data science team increases the number of data stores can grow to a very large number.
ORA-01034: ORACLE not available
(Natik Ameen) Question: What is the cause of the error “ORA-01034: ORACLE not available” when I log into sqlplus?
RMAN — 10 : VALIDATE
(Hemant K Chitale) There are two different VALIDATE commands for Backups. (These are different from RESTORE VALIDATE which I’d blogged about earlier in 10.2 here)
Using DBMS_PARALLEL_EXECUTE
(John Hallas) We have a number of updates to partitioned tables that are run from within pl/sql blocks which have either an execute immediate ‘alter session enable parallel dml’ or execute immediate ‘alter session force parallel dml’ in the same pl/sql block.
Oracle SOA/BPM 12c: Propagation of Flow Instance Title and Instance Abortion
(Jan Kettenis) Recently I wrote this posting regarding an improvement for setting the title of a flow instance in Oracle BPEL, and BPMN 12c. In this posting I will discuss two related improvements that comes with SOA/BPM Suite 12c, being that the flow instance abortion is automatically propagated fr
Tips on SQL Plan Management and Oracle Database In-Memory Part 1
(nbayliss) If you follow Oracle’s In-Memory blog then you probably came across a post mentioning how you should use SQL Plan Management when you’re upgrading to Oracle Database In-Memory. Whether you have read that post or not, you might be wondering what will happen if you have some SQL plan baseli
Using DBMS_PARALLEL_EXECUTE
(John Hallas) We have a number of updates to partitioned tables that are run from within pl/sql blocks which have either an execute immediate ‘alter session enable parallel dml’ or execute immediate ‘alter session force parallel dml’ in the same pl/sql block.
Oracle SOA/BPM 12c: Propagation of Flow Instance Title and Instance Abortion
(Jan Kettenis) Recently I wrote this posting regarding an improvement for setting the title of a flow instance in Oracle BPEL, and BPMN 12c. In this posting I will discuss two related improvements that comes with SOA/BPM Suite 12c, being that the flow instance abortion is automatically propagated fr
Tips on SQL Plan Management and Oracle Database In-Memory Part 1
(nbayliss) If you follow Oracle’s In-Memory blog then you probably came across a post mentioning how you should use SQL Plan Management when you’re upgrading to Oracle Database In-Memory. Whether you have read that post or not, you might be wondering what will happen if you have some SQL plan baseli