Fuyuncat (Wei Huang) Techinical Blog [HelloDBA.COM]
HelloDBA [中文]
Search Internet Search HelloDBA
  Oracle Technology Site. email: fuyuncat@gmail.com  MSN: fuyuncat@hotmail.com Add to circle  acoug  acoug 
New ArticlesWelcome
Introduce a SQL tuning tool...(2017-10-05) [Doc] bug ORA-00600: internal error code, arguments: [rwoirw: check ret val]...(2017-08-10) [Doc]
Security View Merge in 12c --- Bug or Improvment...(2017-08-09) [Doc] --- SQL_FULLTEXT in v$sql become messy when the length of raw SQL text larger than 131072...(2017-06-26) [Doc]
Oracle 12.2 SQL Parsing bug...(2017-05-25) [Doc]
Oracle 12c new SQL Hints...(2016-05-05) [Doc]
Flashback Snapshot of Schema...(2015-11-03) [Doc]
Consistent Gets may not tell the truth...(2015-10-23) [Doc]
Oracle 12c Hybrid Histogram...(2013-08-27) [Doc]
Oracle 12c TOP-N Frequency Histogram...(2013-08-21) [Doc]
Hello DBA

Welcome to Fuyuncat(Wei Huang)'s personal web site. Built in 2005.
 Introduce a SQL tuning tool

 by fuyuncat

When we tune a SQL, we need to spend a lot of time to analyze the SQL, find out the performance bottleneck first, then utilize the tuning rules or our own experience to take action to tune the SQL. SQL Tuning is complex task. The junior developers or DBAs may even don't know from where to start when they are facing a poor performance SQL. It's also a time-consuming task for those experienced DBA. I ever tuned a ton of SQLs, and I always hope I can get a SQL Tuning tool to help me find out the top SQL quickly, then analyzes the SQL automatically, and eventually gives me tuning suggestions. This will definitely take off those time-consuming steps from me, helps me to tune the SQL efficiently, and gives me more time to do other works. Yes, SQLBooster is what I am looking for!
[Read] bug ORA-00600: internal error code, arguments: [rwoirw: check ret val]

 by fuyuncat

This bug will be hit under special conditions. It's easy to be reproduced.

 Security View Merge in 12c --- Bug or Improvment

 by fuyuncat

After upgraded to 12c, we noted performance degradation in some SQLs. With further investigation, we found it's related to View Merging Security control.

 FyDul: Last chance for saving your oracle data

 by fuyuncat

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.

 One single SQL helps you to analyze the performance of a SQL

 by fuyuncat

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.

 Fy_Recover_Data 2014.03.07 Update -- You can recover truncated table from offline data files now

 by fuyuncat

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.

Products Update Welcome
FyDul: Last chance for saving your oracle data...(2016-04-24) [Prod]
One single SQL helps you to analyze the performance of a SQL...(2016-03-12) [Prod]
Fy_Recover_Data 2014.03.07 Update -- You can recover truncated table from offline data files now...(2016-03-07) [Prod]
Fy_Recover_Data Update (2014-02-20) --- Support ASM now!...(2016-02-19) [Prod]
Erratum of "Oracle SQL Optimizing and Tuning Technologies"...(2013-01-11) [Prod]
Oracle SQL Hints...(2013-01-08) [Prod]
Scripts of "Oracle SQL Optimizing and Tuning Technologies"...(2013-01-07) [Prod]
Fy_Recover_Data --- A PLSQL package to recover (Truncated) data...(2012-08-14) [Prod]
OraTracer Upgrade...(2012-06-29) [Prod]
FyDB becomes an open source project...(2011-08-09) [Prod]
HelloDBA Logo


Copyright ©2005, HelloDBA.Com All reseverd.

by fuyuncat