Oracle introduced many new features in 12c, some of which are related to SQL optimization. Quite a few SQL hints come along with these new features.
[Read]
What if your oracle crashed and can not be recovered? FyDul is the last chance for you to save your data. It's is small program to read the data from data files directly. I wrote this program in 2006, and now I improved it to make it easier be used.
[Read]
This is the script I am using to analyze SQL performance. It major contains one SQL only. It can show most of detail information about the SQL if available. And you can shoose to show parts of them.
[Read]
In case you found that you truncated a table should not be done. You may copy the data files of the tablespace to a local location. And then use Fy_Recover_Data to recover data from those offline files. This will guarantee minimuming data lost.
[Read]