Oracle has released the much-anticipated version of cellsrv compatible with Oracle Database 220.127.116.11 (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 18.104.22.168 database:
Create the service:
$ srvctl add service -d orcl -s demo -r "ORCL1,ORCL2"
This is the third and final post on follow up questions from the Redgate webinar I did on 12c Adaptive Optimization (the link goes to a recording of the webcast by the way).
Also, here are links to the 2 earlier posts:
12c Adaptive Optimization – Part 1.
12c Adaptive (more...)
This is the second post on follow up questions from the Redgate webinar I did on 12c Adaptive Optimization. The first post is here: 12c Adaptive Optimization – Part 1. Since there were several comments and questions about hints and how they interact with Adaptive Plans, I decided to limit (more...)
If you are working with JDeveloper 12c (12.1.2), you will probably have experienced quite a few crashes – I had several during my the live demos in my presentations at the UKOUG Tech 2013 conference in Manchester this week.
A few things that help:
- Increase memory (google “JDeveloper (more...)
Since PL/SQL now is closely integrated into SQL, we hence can happily state
email@example.com > with function bestpractice return varchar2
4 return 'Do not use PL/SQL when it can be done with SQL alone !';
5 end bestpractice;
Today at the UKOUG I showed a new plug-in for JDeveloper 12c together with Wilfred
, the ADF EMG Audit Rules. You can find it through JDevelopers Check for Updates in the Help menu. This plug-in is a starting point for creating rules out of the code guidelines document you (more...)
Since JDeveloper 12c it’s possible to uninstall extension from your JDeveloper, without deleting jar files and cache directories manually. However, the feature is a little bit hidden, it’s not in your preferences, but in the feature section. You get there through the Tools menu.
Here you can manage your features, (more...)
Last week I did a webinar on 12c Adaptive Optimization. The talk was recorded. The slides are here: 12c Adaptive Optimization V2 PDF. The recording can be found here: 12c Adaptive Optimization Recording. There were a number of follow up questions and emails so I thought I’d summarize here. Since (more...)
I just uploaded my DOAG 2013 presentation “Best of Oracle Security 2013“.
This presentation shows how to bypass Oracle Data Redaction, become DBA using CREATE ANY INDEX, Hide information from Oracle Auding using VPD and more…
SQL> select * from scott.credit_card where 1=ordsys.ord_dicom.getmappingxpath((card_id),user,user);
Oracle 12c introduced the ability to make user specified columns “Invisible” such that they’re invisible by default and have to be explicitly referenced to be accessed. So a simple SELECT * won’t display columns defined as invisible, but they will be displayed if explicitly referenced in the SELECT column list. (more...)
-- it's just for fun:
SQL> alter system set "_scalar_type_lob_storage_threshold"=32000;
SQL> create table t_varchar32000(v varchar2(32000 byte));
SQL> insert into t_varchar32000
2 select rpad(rownum,31999,'x' ) || 'y' from dual connect by level<=1000;
1000 rows created.
SQL> create index ix_t_varchar32000 on t_varchar32000(v) tablespace users;
Finally, at long long last, I have a spare 30 minutes in my life to complete this blog entry !! As discussed previously, Oracle has extended the maximum length of varchar2, nvarchar and raw columns to 32K, but this comes with some challenges when it comes to indexing such columns due (more...)
Here are two interesting enhancements in Oracle database 12c PL/SQL. PL/SQL subprogram defined using WITH clause of a subquery – Oracle database 12c allows PL/SQL declaration section in the WITH clause. One can define PL/SQL function or procedure into a WITH clause. Functions declared in the PL/SQL declaration section can (more...)