Category Archives: Oracle Database

All from my experiences or readings…

1Z0-054 Oracle Database 11g performance tuning Advertisements

Posted in Oracle Database | Leave a comment

Check Local Listener and Scan Listener Status 11R2

cluster-scan is scan name which is registered to DNS record. For high avaliability and scalability,oracle recommend that you configure in DNS to use round robin issue. Check the scan name IP’s nslookup Check status ıf scan_listener and scan: cd … Continue reading

Posted in Oracle Database | 2 Comments

Go back to previous PL/SQL code with using Flashback Features

Be sure your database is enabled  FLASHBACK DATABASE. grant flashback on user_source to <user_name>; During the Flashbackback Retention Time,you can easily reach your previous code. select *  from user_source as of scn timestamp_to_scn(systimestamp – 15/1440)   where name = ‘<MY_PROCEDURE_NAME>’;

Posted in Oracle Database | Leave a comment