Improve EXPDP Performance | #dailyDBA 8

In this episode of daily DBA, I pick up 6 important #DBA related questions and give my answers! Do not forget to checkout BONUS QUESTION at the end of the video!

00:00 What are the disadvantage of Oracle Database?
00:50 When must a DBA plan for performing upgrade of database?
02:31 Do we need to take separate license for Real time apply?
04:49 How to improve performance of EXPDP apart from parallel option?
06:40 User has mistakenly dropped a master table which has millions of records. You have only few minutes say 15 to 30 min left for the database to go public. In this scenario, how to bring back the table? Flashback is disabled.
08:57 Which is the most stable version in Oracle for upgrade?
12:21 What will happen if we upgrade from 11.2.0.4 to 18c and keep compatible parameter still 11.2.0.4?
Bonus Question
16:37 In your experience, I would like to know what are the disadvantages of Oracle database!

[tlondi]

I work at Oracle Corporation and my best Oracle version remains Oracle 11.2.0.4. However, like Arun said, best Oracle version is dependent on the application requirement only. We see a lot of performance and data compatibility issues for customers who have upgraded to new version without proper consultation between their application vendor and Oracle development. They end up with a half-baked migration/upgrade that needs to be reverse engineered to work. Thanks for all the informative content Arun, you are truly a gem in our Oracle DBA world!

[nishanthajay]

We could also improve performance by,
1. Using network_link parameter to take expdp remotely on another node
2.exclude statistics if we already have a stats gathered or needs to ne ignored in the new clone setup
3.increase PGA size if required since PGA handles DPR (Direct Path Read) requests to accommodate expdp
4.Increasing UNDO might help exp

Pls correct me if I'm wrong :)

[jaipalgaikwad]

Thanks Arun your r doing great job to help dba round globe.

[sadanb]

Extremely superb..Much thanks for your time to explain each and every comment to be answered....

[mercylane]

Great explanation of what the disadvantages of oracle.

[shivampatel-mvdv]

Q: by mistake someone removed online redo logs and cleanup job has cleaned archives and we do not have any database backup scheduled at the server. what are ways to recover database again ?

[rmahathi]

The archival backup
And about the flashback logs

[shubhamdwivedi]

Hi Arun,
Thanks for taking this initiative of dailyDBA show.
I have to questions to ask.
1:- Can we directly move from 12c to 19c or we have to firstly move to 18c and then 19c.

2:- Suppose I had performed expdp operation and created log files and dump file at particular location, and because of some mistakes log files or dump files was got deleted then it this case the import operation will be processed or not.

Please answer

[rammurthy]

Hi Arun for the question - on recovering the dropped table from recycle bin using flash back option, would like to know what if recycle bin has been flushed off??how can I get back the dropped table??

[RameshKumar-dwfs]

Hi Arun, Any other way to make particular schema in single user mode as we do as database..

[prathapreddy]

Nice explanation, can you please explain what is the difference between local and dictionary tablespace

[rmahathi]

Hi Arun
Could you please explain about FRA and the errors we usually see while initiating backup through FRA.

[MurthyJn]

In 11g R2 able to export dump using encryption by "ENCRYPTION_PASSWORD=test".
exp : expdp dumpfile=emp.dmp
logfile=emp.log directory=data_pump_dir tables=EMP ENCRYPTION_PWD_PROMPT=YES
if like this it will ask for Password.after enter encryption the password export will start.
the same way can I import like "ENCRYPTION_PWD_PROMPT=YES and then it should wait for password prompt.
basically I don't want to specify the password in imp command itself.

[farazmohammed]

Please explain 12c concepts like pdb, cdb .. how to take backup, clone pdb's

[ishanmalik]

Hi Arun, one simple question, what if I the archives generated today and before backing it up, I delete them as the space is limited on filesystem?
Is there any impact during recovery

[matheenahamed]

What is Fal client and Fal server? What's their purpose?

Can we use direct=y in case of taking export of clob tables.?