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:
- A grant of the DEBUG CONNECT SESSION privilege.
- EXECUTE privilege on DBMS_DEBUG_JDWP.
- EXECUTE privilege on the stored procedure you want to debug.
- Make sure the stored procedure is “Compiled for Debug”.
Jeff Smith talks about it in this post.
But what happens when you (more...)
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 […]
We already know that the CBO transformation engine in 12c can unnest scalar subqueries from select-list.
So it’s not very surprising, that CBO is now able to add scalar subqueries costs to total query cost (even if “_optimizer_unnest_scalar_sq” = false):
Interesting, that SYS_OP_MAP_NONNULL appeared in the Oracle 12c documentation: Choosing Indexes for Materialized Views
Lazy tip: By the way, with length limitations, we can also use documented dump function:
2 t(a,b) as (
3 select *
4 from table(ku$_vcnt(null,'FF','A'))
9 ,case when sys_op_map_nonnull(a) = sys_op_map_nonnull(b) then '=' else '!=' end comp1
10 ,case when dump(a,1017) = dump(b,1017) then '=' else '!=' end comp2
Just a quick note to highlight that the Oracle pre-built Developer VMs have been updated for Oracle 12c.
Oracle pre-built Developer VMs
This post is about exploring the mechanisms used by Oracle Clusterware 18.104.22.168 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...)
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: […]
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 […]
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 […]
It’s sometimes amazing, how many bugs there are still with elementary SQL.
Here is one concerning updatable views:
email@example.com > create table t ( v varchar2(30) );
firstname.lastname@example.org > create view v as
2 select v as dontdothatman, v as canbelostwheninserted
3 from t;
email@example.com > insert /* this is fine */ into v
2 values('fine', 'fine');
1 row created.
firstname.lastname@example.org > select * from v;
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 […]
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...)
Oracle has released the much-anticipated version of cellsrv compatible with Oracle Database 22.214.171.124 (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...)
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.
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
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
SQL> alter (more...)
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...)
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...)
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 126.96.36.199 database:
Create the service:
$ srvctl add service -d orcl -s demo -r "ORCL1,ORCL2"