Oracle 19c New Features
Ғылым және технология
A list of the #Multitenant new features introduced in #Oracle database 19c. The most significant new features are Auto indexing, SQL Quarantine, ADDM support for Pluggable database etc.
0:38 - Test Mode For Transportable Tablespace
1:47 - Max Data Pump Parallel Per Job
2:16 - Oracle Network Log File Segmentation
3:26 - Automatic Indexing
4:06 - Real-Time Statistics
5:06 - Active Data Guard DML Redirection
6:25 - Flashback Standby On Primary Flashback
7:03 - Propagate Restore Points
8:15 - Auto Upgrade
Website: www.dbagenesis.com/
Facebook: / dbagenesis
Instagram: / dbagenesis
Twitter: / dbagenesis
Пікірлер: 42
I am dba genesis subscriber. Enjoying the learning from Arun...
Great 9min lecture 👌thanks DBA Genesis
@dbagenesis
3 жыл бұрын
Glad you enjoyed it!
Very good explanation with all the 19c imp features.
@dbagenesis
3 жыл бұрын
More videos on new features coming soon
It's been a long time sir. You looks great now. Many thanks for the video. Please bring back the Daily DBA show.
@dbagenesis
3 жыл бұрын
May be something better than Daily DBA.
Nice video Arun!! Very informative in short video.. keep rocking... :)
@dbagenesis
3 жыл бұрын
Thank you, I will
Thank you so much Arun... Really awesome
@dbagenesis
2 жыл бұрын
My pleasure 😊
Hi Sir, we need more videos like previous ones
awsome
After a long time arun sir... Happy to see you and vedio is so helpful always.
@dbagenesis
3 жыл бұрын
Glad to hear that
Is GTT have any changes in 19c. I see lot performance issue with GTt
Keep us updated ..👍
@dbagenesis
3 жыл бұрын
Always!
Nice video Sir! Will flash back to restore point on primary auto flashback on secondary database?
HI Sir / All , can any of me help with the difference between PARALLEL and MAX DATAPUMP PARALLEL PER JOB options that are used in datapump .
Auto indexing feature available at Engineered systems like Exadata &ODA , not for other platforms.. can u pls confirm again..
I'm new to DBMS our sir told us to download 11g can I download it..
And also I'm confusing which to download bcz in 19c even lots of variants are there.. which one to download
Hello...I had a mandate from my management to reduce the no of indexes on all critical big db on critical tables ... I don't have background of such request...do we have any specific drawback to have indexes ..any specific threshold number of indexes or any document from Oracle came up now suggesting to reduce no. Of indexes... Pls suggest how to relate to the ask. I really can't ask management for the reason at this moment so taking your help to understand...
Many features are currently restricted to Enterprise Edition on Engineered Systems, like Exadata and Exadata Cloud Service
Nice explanation
@dbagenesis
3 жыл бұрын
Keep watching
Thank you Sir. It is nice video and very helpful for us . Can you please create a similar video i.e. 19c features for CDB PDB env. How to manage efficiently Multi tenant architecture in 19c as a Dba ? One more question. Is there any option to switchover only pdb ? If we have 4 PDBs in a container . But we need to switchover only 1 PDB to data guard. Is it possible ? If we need to switchover whole CDB , it will impact other PDBs also as well in applications. How to manage this situation? What is your suggestion here ? Shall keep 1 PDB a a single container? mainly in Production env where we need to switchover.
Hi Arun..Good to see you.. I dont know whether you remember or not ,I worked with you in GE project ...I follow your videos and all are very helpful and informative.. keep rocking
@dbagenesis
3 жыл бұрын
Yes, yes, I do remember.. My memory is as sharp as Oracle database ;)
Please make videos regularly
Thank u
@dbagenesis
3 жыл бұрын
Welcome
Hi Sir, This video is very helpful. Thank you.
@dbagenesis
3 жыл бұрын
Glad it was helpful!
Hi Sir , We can speed up export and import with parallel option in expdp/impdp ..How would max datapump parallel per job different compare to parallel option?
@srikanthk266
Жыл бұрын
The Parallel option is specified along with the expdp option in command line where as max_datapump_parallel_per_job can be set in the parameter file. If You observe a full db export with a parallel option still only one worker process would be actively used(which i don't know why ) , but with the new parameter export log indicates exact no of process used, In RAC each instance can have a different value with this new parameter.
2:16 I cannot believe that something as basic as "rotating log files" is a NEW feature in v19 when it should have been there since v1 !
New hair style super
Hi dba gensis can you please share what u explained in that PPT. It's helpful to me to understand the each and every topic of Oracle dba
@dbagenesis
10 ай бұрын
You can find all our course material is freely available on www.support.dbagenesis.com/
Bloopers...