Profile cover photo
Profile photo
Adnan Rafi
119 followers
119 followers
About
Adnan's posts

Post has attachment
**
--  measure number of Active Sessions select    round(sample_time,'MI'),    count(*) as active_sessions from    dba_hist_active_sess_history where    sample_time > sysdate - 7 group by    round(sample_time, 'MI');

Post has attachment
**
Find TPS Oracle WITH hist_snaps      AS (SELECT instance_number,                 snap_id,                 round(begin_interval_time,'MI') datetime,                   (  begin_interval_time                    + 0                    - LAG (                   ...

Post has attachment
Changing Database link password without recreating
 I t is
possible to change a database link password without dropping and recreating a
database link. The ALTER DATABASE LINK statement can be used and you do not need to specify the target TNS Service name either. ALTER DATA BASE LINK DB_LINK_NAME connect t...

Post has attachment

Post has attachment
i want to automate the process of executing sql queries on plsql developer and then transfer output in excel format file

Post has attachment

Post has attachment

Post has attachment

Post has attachment

Post has attachment
Wait while more posts are being loaded