|
||||
|
To restrict user operations at PDB levels and even more granular restriction, in 12.2 we can create Lock down profiles using “create lock down profile”. Here are some examples CREATE LOCKDOWN PROFILE test; ALTER LOCKDOWN PROFILE test DISABLE STATEMENT = (‘ALTER SYSTEM’); ALTER LOCKDOWN PROFILE test ENABLE STATEMENT = (‘ALTER SYSTEM’) CLAUSE= (‘flush […] DBA’s often kill the blocking sessions and from 19c (not sure which patch set) we have new parameter called MAX_IDLE_BLOCKER_TIME parameter which helps to specifies the maximum number of minutes that a blocking session can be idle. After that point, the session is automatically terminated. A session is considered to be a blocking […] Oracle’s Simple Oracle Document Store is an interface to manage Document Store type work loads in Oracle Database. Leveraging JSON Object Support with in Oracle Database. SchemaLess & NOSQL access but fully acid complaint. Collection Management through various implementations like Java, Rest, Python, Native SQL etc. Store and manage JSON and XML documents in Oracle […] Some New wait events that I learnt today, acknowledge over PGA limit (12.1) The “Acknowledge Over PGA limit” is a new wait event that was introduced with PGA_AGGREGATE_LIMIT in 12.1, and it will force a process that wants more PGA to wait a bit if the instance is getting close to hitting the limit. Set […] Hi I am one of you scrolling through different metalink and master notes for latest patches for Oracle databases, and now Oracle metalink made it easy or I saw it very late :). A nice Download assistant interactive which provides all links to the relevant patches etc. Watchout this small video. Assistant: Download Reference for […] Thanks to my Colleague Jaipal to introduce me to this Metalink Note: Doc ID 2005729.1 In a 12c and higher environment, to migrate data between systems that have different endian formats, with the least amount of application down time. The first step is to copy a full back up from the source to the destination. […] Yes, Oracle always strive to integrate latest trends in the industry to its Database. Now the new one is Kafka integration with Oracle Database through DBMS_KAFKA package. Where you can publish events and consume or load data into tables. This feature has been discussed in CodeOne 2018 by Melli Annamalai, Senior Principal Product Manager at […] Follow this link for Oracle Hands on Lab to practice certain tasks like upgrades and patching etc which is quicker and nicer. http://www.oracle.com/technetwork/community/developer-vm/vts-hol-2415742.html The lab instructions contains the following activities : Source Oracle The public image for 18c is not available until 18c official release. and it contains 18c instead of 12.2.0.1 Thanks Suresh […] 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 […] As we all aware , that we can have only one instance of Standby running with MRP (redo apply) running in RAC environments. Starting 12.2.0.1, we can have multiple instances on standby side too with following command. Generally, to start the MRP process we use, ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION; Now […] |
||||
Oracle 23c New Features for DBA's
Follow Me!!!