Tips and recommendations on various Oracle products. Solving day to day challenges with easy operational tasks. Providing ideas on scripting, queries and oracle Patching. Find tricks for numerous ORA-error.
set pagesize 0 feedback off verify off heading off echo off
SELECT decode( nvl( space_used, 0),0, 0, ceil ( ( space_used / space_limit) * 100) ) pct_used FROM v$recovery_file_dest;
If you have any queries/ any suggestion please do comment and let me know.
Check progress on expdp and impdp: In few cases we need to monitor the progress of an export or import job in oracle. below are the steps c...
No comments:
Post a Comment
If you have any queries/ any suggestion please do comment and let me know.