Articles populaires – Oracle and MS SQL SERVER Tips by EL GHERIYESSE AHMED

Canalblog

Suivre ce blog

Administration + Créer mon blog

Publicité

17 mai 2018

How to estimate flashback destination space

Sometimes application team will ask you as a DBA to enable fashback for x number of days. In such case,you needs to estimate the fashback space required for x number of days in order to store the fashback logs. The flashback log size is same as archive...

Posté par EL_AHMED à 15:21 - Commentaires […] - Permalien [#]

Partager cet article

Vous aimez ?

1 vote

Publicité

Publicité

17 mai 2018

Monitoring TEMP tablespace activity

Question: How do I see the temp space used by a specific Oracle session? Is there a way to see the TEMP space used by a SQL statement, or is it only temporary space used by the session?How-to find the SQL that using lots of temp tablespace in Oracle ?...

Posté par EL_AHMED à 14:48 - Commentaires […] - Permalien [#]

Partager cet article

Vous aimez ?

1 vote

17 mai 2018

How to manage lost Datapump jobs

We’re running an export (full, for example) and that takes a very long time but then our connection to the server is closed for some reason. It can be a server policy or it can be that we did it by mistake but my most common reason is just loosing the...

Posté par EL_AHMED à 17:47 - Commentaires […] - Permalien [#]

Partager cet article

Vous aimez ?

1 vote

17 mai 2018

Monitor Data Pump Import/Export

After working with Data Pump for some years, I devised my own ways of monitoring the progress of imports and exports that seemed stalled based on the built-in Oracle views as well as the OS level commands. A simple way to gain insight into the status...

Posté par EL_AHMED à 17:07 - Commentaires […] - Permalien [#]

Partager cet article

Vous aimez ?

1 vote

17 mai 2018

How to check datapump export progress

Sometimes when you run datapump export, it might take a lot of time. Meanwhile client might ask you for the % of export completed. You can use below query to get the details of how much % export is done. SELECT SID, SERIAL#, USERNAME, CONTEXT, SOFAR,...

Posté par EL_AHMED à 15:42 - Commentaires […] - Permalien [#]

Partager cet article

Vous aimez ?

1 vote

Publicité

Publicité

Publicité

Publicité