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
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 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?
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.
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...
I am dba genesis subscriber. Enjoying the learning from Arun...
Thank you so much Arun... Really awesome
My pleasure 😊
Very good explanation with all the 19c imp features.
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.
May be something better than Daily DBA.
Great 9min lecture 👌thanks DBA Genesis
Glad you enjoyed it!
Nice video Arun!! Very informative in short video.. keep rocking... :)
Thank you, I will
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
Yes, yes, I do remember.. My memory is as sharp as Oracle database ;)
Keep us updated ..👍
Always!
After a long time arun sir... Happy to see you and vedio is so helpful always.
Glad to hear that
Hi Sir, we need more videos like previous ones
Nice explanation
Keep watching
Please make videos regularly
awsome
New hair style super
Thank u
Welcome
Is GTT have any changes in 19c. I see lot performance issue with GTt
Hi Sir,
This video is very helpful. Thank you.
Glad it was helpful!
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 !
Many features are currently restricted to Enterprise Edition on Engineered Systems, like Exadata and Exadata Cloud Service
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 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
You can find all our course material is freely available on www.support.dbagenesis.com/
Nice video Sir!
Will flash back to restore point on primary auto flashback on secondary database?
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?
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.
Auto indexing feature available at Engineered systems like Exadata &ODA , not for other platforms.. can u pls confirm again..
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 .
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...
And also I'm confusing which to download bcz in 19c even lots of variants are there.. which one to download
I'm new to DBMS our sir told us to download 11g can I download it..
Bloopers...