Senior Applications Engineer
Are you facing performance issues by running reporting queries in the OLTP database? Do you have big and complex queries in the Data warehouse which are taking a long time to run? Do you feel there is no scope of further SQL tuning or modifying queries or code changes? If your answer is YES, Join me in the conversation; And I will speak about Optimizer insight, Database In-Memory and some Tips & Techniques which helps you to boost your query performance overnight with Live Demo.
From Oracle 19c onwards you can have 3 user-created pluggable databases without a Multitenant license. And Non-CDB architecture will be de-supported from Oracle 20c onwards. Now a days it is mandatory for all DBAs to learn Multitenant Architecture and it's use in real world scenarios. Multi-Tenant Architecture will give you most benefits, not only consolidation of databases but also managing different databases as one. There are various use cases to adopt this New Multitenant Architecture i.e. Development and Test Env consolidation, Sharding, Microservices, adopting SaaS, DBaaS and many more. In this session, I will go deep dive in Multi-Tenant Architecture. And also give Live Demo on, 1) Monitoring of CDB/PDBs 2) Hot Clone PDB databases 3) Plug-Unplug PDBs from one CDB to another and non-CDB to CDB 4) Refreshable PDBs 5) Snapshot caurasol features. Join me and learn Multi-Tenant features and administration.