Modify Primary Key Using Index (Learning To Fly)

One of the things I love about working with Oracle Database technologies is that there’s just so much one can learn. I make it an active goal of mine to try to learn something new at work each and every day, no matter how big or small. One of these days, I might blog about a presentation I put together […]

Yet Another Elementary SQL Bug

Environment

sokrates@12.1 > select banner from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
PL/SQL Release 12.1.0.1.0 - Production
CORE	12.1.0.1.0	Production
TNS for Linux: Version 12.1.0.1.0 - Production
NLSRTL Version 12.1.0.1.0 - Production

sokrates@12.1 > select value from nls_database_parameters where parameter='NLS_CHARACTERSET';

VALUE
--------------------------------------------------------------------------------
AL32UTF8
sokrates@12.1 > ! (more...)

SQL Developer’s PL/SQL Debugger and Oracle 12c

The PL/SQL Debugger works pretty much out of the box when used with a previous Oracle version. These are the things we needed in place before we could start debugging PL/SQL:

  1. A grant of the DEBUG CONNECT SESSION privilege.
  2. EXECUTE privilege on DBMS_DEBUG_JDWP.
  3. EXECUTE privilege on the stored procedure you want to debug.
  4. Make sure the stored procedure is “Compiled for Debug”.

Jeff Smith talks about it in this post.

But what happens when you (more...)

12c Enhanced Online Index DDL Operations (Lady Godiva’s Operation)

In my last couple of posts, I discussed how table partitions can be moved online since 12c, keeping all indexes in sync as part of the process. 12c also introduced enhancements to a number of index related DDL statements, removing blocking locks and making their use online and far less intrusive. The following commands now have a new ONLINE […]

Oracle 12c VirtualBox VM

Just a quick note to highlight that the Oracle pre-built Developer VMs have been updated for Oracle 12c.

Oracle pre-built Developer VMs


Clusterware 12c and Restricted Service Registration for RAC

Topic: This post is about exploring the mechanisms used by Oracle Clusterware 12.1.0.1 to restrict remote service registration, i.e. the 12c new feature "Restricting Service Registration for Oracle RAC Deployments"

Why is this useful? This improvement of 12c clusterware and listeners over the 11.2 version is useful mainly for security purposes, for example as a measure against TNS poisoning attacks (see also CVE-2012-1675), and it is particularly relevant for (more...)

My Latin American Tour in March

At March I will be presenting my very successful seminar “Mastering Backup and Recovery” in some countries of Latin America for the very first time. Thank you Panama, Chile and Brazil OUGs for inviting me to your amazing countries! Please, use the following links for registration and also to find more information about the seminar: […]

Join me at the next OTN Virtual Developer Day

    Hi All, On February 4, 2014 at 9:30 am PT I will be talking on the next OTN Virtual Developer Day about Oracle VM and Oracle Database. Come and discover the answers for the following questions: Does an Oracle Database perform well on a virtualized environment? What virtualization technology is more stable and […]

12c Online Partitioned Table Reorganisation Part II (Move On)

In Part I, we looked at some of the issues associated with locking and unusable indexes when Moving both tables and table partitions. The Oracle 12c Database has introduced a number of great new capabilities associated with online DDL activities. One of these really useful features is the capability to now move table partitions online while […]

Could Oracle Cloud Trump Amazon Web Services?

OK, we all read or heard it recently in one form or another.  Oracle has told Amazon that it’s “game on” for leadership in the “commodity” Infrastructure as a Service (“IaaS”) market.  In other words, “we’ll beat you on price”.  Lots have folks have called the declaration crazy - Oracle can’t compete with Amazon on the basis of commodity pricing and never will.  Funny thing is, I think Oracle could actually (more...)

Issue with updatable views

It’s sometimes amazing, how many bugs there are still with elementary SQL.

Here is one concerning updatable views:

sokrates@12.1 > create table t ( v varchar2(30) );

Table created.

sokrates@12.1 > create view v as
  2  select v as dontdothatman, v as canbelostwheninserted
  3  from t; 

View created.

sokrates@12.1 > insert /* this is fine */ into v 
  2  values('fine', 'fine');

1 row created.

sokrates@12.1 > select * from v;

DONTDOTHATMAN		        (more...)

12c Online Partitioned Table Reorganisation Part I (Prelude)

First post for 2014 !! Although it’s generally not an overly common activity with Oracle databases, reorganising a table can be somewhat painful, primarily because of the associated locking implications and the impact it has on indexes. If we look at the following example: So we have a table with a couple of indexes. We […]

November/December Highlights

In the Oracle technical universe, it seems that the end of the calendar year is always eventful. First there’s OpenWorld: obviously significant for official announcements and insight into Oracle’s strategy. It’s also the week when many top engineers around the world meet up in San Francisco to catch up over (more...)

Exadata Storage Server Version 12.1.1.1.0 Released

Oracle has released the much-anticipated version of cellsrv compatible with Oracle Database 12.1.0.1 (patch #16980054). Before thinking about upgrading, read MOS note #1571789.1 carefully.  Unless you are planning to run database 12c on your Exadata, it would be advisable to continue down the 11.2 branch (more...)

Memory flushing and PDBs

In a multitenant database environment, PDBs are plugged into a CDB container sharing single SGA.  All the PDB objects are loaded into a single SGA component and there are no ISPDB_MODIFIABLE SGA parameters.  Looking at the V$LATCH_CHILDREN, all the CBC latches defined under CON_ID  1 which is CDB$ROOT.


 (more...)

Multitenant Self-Service Provisioning – BETA 2 – No emails out for ADMIN user

What did I mean? Actually, I thought how to rename "ADMIN" user?or How to rename "Email Address" on  Multitenant Self-Service Provisioning? Why I interested in it?

I created New Database by using "ADMIN" user.
I didn't get email about credentials (Because no email address for ADMIN user). (more...)

Multitenant Self-Service Provisioning – BETA 2 – Connect SQL Developer with pdb_admin

I didn't write about setting SQL Developer to connect PDB. I just tested connection by using SQL Developer with pdb_admin. As you know - The PDB_ADMIN user in newly created PDBs has SYSDBA system privilege so it can fully manage the PDB.
SQL> conn / as sysdba
Connected.
SQL> alter (more...)

Multitenant Self-Service Provisioning – BETA 2 – Role

Last post, I posted about Oracle Multitenant Self-Service Provisioning - BETA 2 and read more about what changes have been made in this Beta 2 release.
Users with the PDBA role in the Oracle Multitenant Self-Service Provisioning application can only view PDBs that they created or have been made an (more...)

Multitenant Self-Service Provisioning – BETA 2 – Started to play

Got news on tweeter about Multitenant Self-Service Provisioning - BETA 2. It's very interesting. You will find something change. For example On Oracle Multitenant Self Service Provisioning - BETA 1 runs in APEX pdb.
(Downloaded pdbss_1030.zip and installed)
This version, the Oracle Multitenant Self-Service Provisioning application now runs in (more...)

12c Improvement in Database Service Management

Removing a service via srvctl has not historically resulted in the service being fully removed from the database and it would still be visible in DBA_SERVICES as show below in an 11.2.0.3 database:

Create the service:

$ srvctl add service -d orcl -s demo -r "ORCL1,ORCL2"

Have (more...)