Technical Oracle Articles
Submitted by John Watson on Wed, 2013-12-04 03:41
I have seen articles that misrepresent a Flex Cluster, even this book Expert Oracle RAC 12c which is written by people who know better (Oracle ACE directors, an OCM, an Oak Table member) gets it wrong, because of a reliance on beta documentation.
Submitted by John Watson on Sat, 2013-10-05 11:40
One often sees requests for test cases, typically when a user has a SQL performance issue. So many users appear to have problems with producing a suitable test case that Uncle Oracle provides routine to automate this. There are no longer any excuses for not providing a test case. Here is an intro to how to do it (code tested on 220.127.116.11 and 18.104.22.168).
Submitted by anjugarg66 on Sun, 2013-07-28 03:42
In this post, I will demonstrate a new feature introduced in 12c : In database archiving. It enables you to archive rows within a table by marking them as invisible. This is accomplshed by means of a hidden column ORA_ARCHIVE_STATE. These invisible rows are not visible to the queries but if needed, can be viewed , by setting a session parameter ROW ARCHIVAL VISIBILITY.
-- Create test user uilm, tablespace ilmtbs
-- Connect as user uilm
-- create and populate test table (5 rows) ilmtab with row archival clause
Submitted by anjugarg66 on Sun, 2013-07-28 03:37
When you create a PDB, the database automatically creates and starts a service inside the CDB.The service has the same name as the PDB. It is possible that the name of the service will collide with an existing service name which is registered with the same listener. For example if two or more CDBs on the same computer system use the same listener, and the newly established PDB has the same service name as another PDB in these CDBs, then a collision occurs.
You must not attempt to operate a PDB that causes a collision with an existing service name.
Submitted by pradip.tk on Sun, 2013-07-14 02:29
Top 12 Features of Oracle 12C Summarized. This article is also available at www.ondemanddb.com
Summary: The Oracle 12C means different things to different people. It all depends on which areas you are looking at, as there are improvements in many areas. Summarized below is the list of Top 12 Features of Oracle 12C as I see it. I have summarized below, the top 12 which I found interesting.
Submitted by saibalguha on Thu, 2013-03-21 06:56
Apps clone is like cloning a human being. Please read the detail below.
1) Run adpreclone on DB/CM/AP tiers
This is pre-requisite step of cloning 11i prod and will not change anything in any system. This script will only create on $COMMON_TOP, a directory called "clone", with a basic structure of executable, scripts, templates and java files. Later to the creation of the clone directory, the process picks up important information of your source system with which upgrades the necessary templates for the process adcfgclone that was carried out in the target server.
Submitted by John Watson on Sun, 2012-09-16 02:48
The COST column cannot be used to compare execution plans. Punkt.
Submitted by csm.dba on Tue, 2012-09-04 05:47
Hi Oracle geeks,
Last Friday, I’ve noticed a strange thing happening in my 22.214.171.124 Database: I’m able to create objects in a tablespace which is marked READ ONLY !!!
Don’t believe this?? See the below
SQL> create tablespace ro datafile ‘/xxx/RO.DBF’ size 10M AUTOEXTEND ON;
SQL> alter tablespace ro read only;
SQL> select status from dba_tablespaces where tablespace_name=’RO’;
SQL> sho user
USER is “CSM“
Submitted by andy huang on Wed, 2012-06-06 09:05
OS:Red Hat Linux As 5
Submitted by John Watson on Tue, 2012-05-15 03:26
I've been asked by the publishers to review "Oracle Database 11g Release 2: Performance Tuning Tips and Techniques" by Richard Niemiec of TUSC. Conclusion: it is good but not perfect. This is an extended version of the review I put up on Amazon.