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

  • @Devendrasingh-ct8jn
    @Devendrasingh-ct8jn3 жыл бұрын

    I am dba genesis subscriber. Enjoying the learning from Arun...

  • @larwuoharris726
    @larwuoharris7263 жыл бұрын

    Great 9min lecture 👌thanks DBA Genesis

  • @dbagenesis

    @dbagenesis

    3 жыл бұрын

    Glad you enjoyed it!

  • @brlrao468
    @brlrao4683 жыл бұрын

    Very good explanation with all the 19c imp features.

  • @dbagenesis

    @dbagenesis

    3 жыл бұрын

    More videos on new features coming soon

  • @prasadd1324
    @prasadd13243 жыл бұрын

    It's been a long time sir. You looks great now. Many thanks for the video. Please bring back the Daily DBA show.

  • @dbagenesis

    @dbagenesis

    3 жыл бұрын

    May be something better than Daily DBA.

  • @tnkreddy
    @tnkreddy3 жыл бұрын

    Nice video Arun!! Very informative in short video.. keep rocking... :)

  • @dbagenesis

    @dbagenesis

    3 жыл бұрын

    Thank you, I will

  • @sadanandamb8610
    @sadanandamb86102 жыл бұрын

    Thank you so much Arun... Really awesome

  • @dbagenesis

    @dbagenesis

    2 жыл бұрын

    My pleasure 😊

  • @manim3054
    @manim30543 жыл бұрын

    Hi Sir, we need more videos like previous ones

  • @salmanansari2454
    @salmanansari2454 Жыл бұрын

    awsome

  • @nayan8966
    @nayan89663 жыл бұрын

    After a long time arun sir... Happy to see you and vedio is so helpful always.

  • @dbagenesis

    @dbagenesis

    3 жыл бұрын

    Glad to hear that

  • @karthickpasupathy6101
    @karthickpasupathy61012 жыл бұрын

    Is GTT have any changes in 19c. I see lot performance issue with GTt

  • @VineetPundir-humble
    @VineetPundir-humble3 жыл бұрын

    Keep us updated ..👍

  • @dbagenesis

    @dbagenesis

    3 жыл бұрын

    Always!

  • @naveennainegali3345
    @naveennainegali33453 жыл бұрын

    Nice video Sir! Will flash back to restore point on primary auto flashback on secondary database?

  • @swat222
    @swat2222 жыл бұрын

    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 .

  • @arul832
    @arul8323 жыл бұрын

    Auto indexing feature available at Engineered systems like Exadata &ODA , not for other platforms.. can u pls confirm again..

  • @enigma368
    @enigma3683 жыл бұрын

    I'm new to DBMS our sir told us to download 11g can I download it..

  • @enigma368
    @enigma3683 жыл бұрын

    And also I'm confusing which to download bcz in 19c even lots of variants are there.. which one to download

  • @amolcreta913
    @amolcreta9132 жыл бұрын

    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...

  • @coolhanmant
    @coolhanmant3 жыл бұрын

    Many features are currently restricted to Enterprise Edition on Engineered Systems, like Exadata and Exadata Cloud Service

  • @rajarangasamy1831
    @rajarangasamy18313 жыл бұрын

    Nice explanation

  • @dbagenesis

    @dbagenesis

    3 жыл бұрын

    Keep watching

  • @suvranshuadhya7680
    @suvranshuadhya76803 жыл бұрын

    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.

  • @karthikkartheek6244
    @karthikkartheek62443 жыл бұрын

    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

    @dbagenesis

    3 жыл бұрын

    Yes, yes, I do remember.. My memory is as sharp as Oracle database ;)

  • @vinukondakalyan9798
    @vinukondakalyan97983 жыл бұрын

    Please make videos regularly

  • @praveenganesh3782
    @praveenganesh37823 жыл бұрын

    Thank u

  • @dbagenesis

    @dbagenesis

    3 жыл бұрын

    Welcome

  • @satabdibhowmick8903
    @satabdibhowmick89033 жыл бұрын

    Hi Sir, This video is very helpful. Thank you.

  • @dbagenesis

    @dbagenesis

    3 жыл бұрын

    Glad it was helpful!

  • @SR-vu8ik
    @SR-vu8ik2 жыл бұрын

    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

    @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.

  • @vjnt1star
    @vjnt1star2 жыл бұрын

    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 !

  • @ramur226
    @ramur2262 жыл бұрын

    New hair style super

  • @saikrishna-hw8yp
    @saikrishna-hw8yp Жыл бұрын

    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

    @dbagenesis

    10 ай бұрын

    You can find all our course material is freely available on www.support.dbagenesis.com/

  • @nayan8966
    @nayan89663 жыл бұрын

    Bloopers...

Келесі