Subscriber Count

    459

Subscribe to Posts by Email

Pages

12.2 New Features : Memory Management at PDB Level

Memory & Guaranteed BufferCache/Shared Pool can be allocated at PDB Level. From the white paper here it is

Well so far I haven’t seen any such need to keep a separate memory settings for each PDB as we […]

Oracle 12.2 New Features : Local UNDO and Flashback PDB Database

Hi,

You can now flashback PDB database exclusively with Local UNDO enabled. In earlier versions, Oracle shares the undo tablespace for CDB and PDB’s and creates a common view for transaction and instance recovery done at all CDB and PDB level. With local undo , Oracle has to change this a bit, it has to […]

Oracle 12.2 New Features : SQLPLUS Enhancements

In 12.2 release, one of the coolest things that every DBA would love is to get history in SQLPLUS :).

Now you can have history ON/OFF with SQLPLUS and see history

SET HISTORY ON|OFF

SHOW HISTORY

Some other features like, FAST OPTION -F flag to set the ARRAYSIZE PAGESIZE STATEMENTCACHE all […]

Oracle 12.2 New Features : Oracle Sharding on its Way

DBA’s , Oracle is coming with Sharding. The one killer feature that No-SQL databases claiming distributed processing with sharding aka a non-shared database storage.

Now with release 12.2 Oracle releasing Sharding feature, with new command “Create Sharded Table” and with a catalog schema, well hold on second , its basically distributed partitioning relied on partitioning […]

Oracle 12.2 New Features : Long Identifiers – What a relief

Oracle 12.2. is out and in Cloud first. 🙂

Out of all features one future must aware and important thing is long identifiers limitation relief , earlier any table or index cannot exceed more than 30 character length.

Not sure how many of you have face issues with character limit, but I was, and many […]

MongoDB for Oracle DBA’s Part 10 : Switchover & Role Transition between Primary and Secondary

In MongoDB as like Oracle Dataguard switchover is possible to but in different way.

You can ask Primary to stepdown and let nodes elect a new primary in replicaset. This can be done using rs.stepDown() method.

Before stepping down primary, one must know the below

The procedure blocks all writes to primary while it runs […]

MongoDB for Oracle DBA’s Part 8 : Understanding Data Distribution between Shards

With previous post, we have configured the two shards with each having replicaset rs0 and rs1.

In this post we will insert some data and observe how the data distribution is happening between shards.

To do the data distributed,

firstly the database must have the sharding enabled secondly, the collection which data need to […]

Independent Australia Oracle Users Group OTN DAYS 2016 – Conferences

Hello All,

IAOUG is back again in Australia for its second year consecutive year OTN Days, with Arup/Tim Hall/Connor around, two conferences being planned, please checkout if you are around Sydney / Goldcoast / or in Australia.

http://www.iaoug.com/home.html

Sydney, October 31st 2016

At […]

Quick Quiz : Find the best way to find how much time a query has taken to execute

Find the best way to find how much time the query (sql_id) has ran in past or current

ASH stores whenever a session is active every second in v$active_session_history for past two hours, In rotation one sample of every 10 seconds will be visible to dba_hist_active_session_history.

From v$active_session_history

select to_char(sample_time,’DD-MON-YY HH24′) Time, sql_id,sql_plan_hash_value,sql_exec_id,round((count(*))/60/60, 2) […]

Cassandra for Oracle DBA’s Part 18 : Change of Replication Factor & Repair Nodes

As like in ASM, when ever a disk is added a rebalance operation takes place between the disks, similarly when the replication factor is changed at keyspace level in the cassandra, the rebalance operation should take place, I have changed the replication factor for Keyspace and you should start the repair of each node so […]