HelloDBA [中文]
Search Internet Search HelloDBA
  Oracle Technology Site. email: fuyuncat@gmail.com  MSN: fuyuncat@hotmail.com Add to circle  acoug  acoug 
New ArticlesWelcome
12.1.0.2 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]
12.1.0.2Bug --- 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]
Rescue data in the worst situation (2)...(2013-03-20) [Doc]
 
 
Hello DBA

Welcome to Fuyuncat(Wei Huang)'s personal web site. Built in 2005.
 
 
 12.1.0.2 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.
[Read]


 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.
[Read]


 12.1.0.2Bug --- SQL_FULLTEXT in v$sql become messy when the length of raw SQL text larger than 131072

 by fuyuncat

12.1.0.2Bug --- SQL_FULLTEXT in v$sql become messy when the length of raw SQL text larger than 131072
[Read]



 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.
[Read]


 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.
[Read]


 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.
[Read]




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]
 
Logo:
HelloDBA Logo

Top

Copyright ©2005, HelloDBA.Com All reseverd.

Declaration
by fuyuncat