|
||||
|
Hello, I am speaking at ODevC Yatra about Docker : Oracle Container Registry. This tour spans 7 major cities for 9 days with great speakers around the world.
Dates & Registration Link for all Cities:- http://odevcyatra.in/register/ Don't miss it and register here (early bird offer until 17-Jun-2018) :- http://odevcyatra.in/hyderabad-registration/ Sessions Agenda in Hyderabad :- http://odevcyatra.in/hyderabad/ See you there !!! -Thanks Suresh The following three options introduced in 18c are very useful for DBA's. I am sure how many of you find hard to limit the rows in Oracle and also finding sql_id for the statement executed. Now that has been solved. SET FEEDBACK ON SQL_ID You can find the sql_id for the executed statement in the sqlplus without querying v$sql or dbms_xplan.display_cursor. Here is how
SET ROWLIMIT n Limit the Number of rows in the sql prompt, without using rownum
SET LINESIZE WINDOW Setting Columns to adjust to the windows is no more required, you can use WINDOW option
-Thanks Suresh In the event of gap or lot of archive pending we generally do a rollfoward recovery of standby using backup incremental from that SCN. This is simplified in 18c and we can use service with RMAN command.
That's it ... Suresh Some important enhancements to Oracle Sharding. Now Supports CDB with a single PDB attached to it
User Defined Sharding methods
Consistency Levels for Multi Shard Queries –
Thanks Suresh In 18c, the sequences can be scalable. Means the sequences will have an append of extra numbers with following formula.
This will help to relieve the index contention and sequence cache problems in RAC since the value has large difference in values, this sequences are useful in typical loads where non primary /unique based key constraint data is not there.
As you see the ID column value of next val is showing as 101274001, instead of 1. So if we interpret the above formula
You can also have extend, no extend option with scale when you create scalable sequences. -Suresh In 18c, we can use RMAN command DUPLICATE to copy the PDB into an existing CDB. In previous releases we need to clone that to a new CDB and unplug and plug into a current CDB. Only active database based duplication is allowed and only one PDB is supported. Log file name convert and spfile parameters also not supported.
-Thanks Suresh
In previous releases of Oracle, the database links and scheduler links password are stored in password column in sys.link$ and sys.scheduler$_link table, however the passwords are obfuscated not encrypted. We can encrypt the obfuscated password in 18c using "alter database dictionary" command. Create a keystore and define encryption method
Alter dictionary to encrypt the credentials
For all in a container database use
Now the password columns in the link$ and scheduler$_link passwords are encrypted. When you do export and import you must provide the encryption password for wallet to ensure the passwords are decrypted while expdp/impdp -Suresh Starting 18c, you can integrate the oracle database with Microsoft active directory services which will be a great feature and long awaiting one, Until now many of us using open ldap or third party ldap services to configure the same which is a overhead to the sys admins to manage two different directory services for user management and authentication for oracle databases. This will be same like as configuring LDAP services with proper domain and user name and using ldap.ora file only, but if you have already a ldap in use, you can create a file called dsi.ora appending DSI_ prefix to the parameters. That means you can have ldap and ad both working as authentication mechanisms for database. The high level steps involved in this are:- Sysadmin:
DBA: On the database host. and edit ldap.ora or dsi.ora file
Create certificates for secure connections
Configure the database with AD authentication
-Thanks Suresh Hi AIOUG Hyderabad chapter conducting free half day seminar on 18c Database and I am speaking on 18c New Features. Please register for free either click on image or below link and seats are limited.
I am speaking too Starting 18c, the software zip file from Oracle contains the Oracle Home itself, means its already extracted and you can unzip it in the required folder where the intended folder to be a oracle home. The installation process just Relinks it. This facilitates the faster Oracle Home provisioning and rapid deployments. Two Important changes in terms of Installation procedure. Firstly, I have uncompressed the software mistakenly into /home/oracle and that became my home, In installation process the oracle home was never asked.
Installation process does not contain extracting software or copying Oracle Home step, just contain relink step
Secondly, Unlike we run runInstaller from extracted folder we should run dbsetup.sh and gridSetup.sh so it invoke the Installer.
In next post I will cover the Installation of 18c grid infrastructure software. -Thanks Suresh
|
||||
Oracle 23c New Features for DBA's
Follow Me!!!