Oracle 11g Release 2 | Generating tablespace details takes long time to complete

Hi guys

Recently we migrated our database from 10gR2 ( to 11GR2 for our EBS environment and got stuck with a new issue, the tablespace details take hours to get generated (Regardless the clients used, SQL Developer/Toad or SQL scripts)

Then we came across a post here about “recyclebin”. At the 1st instance, purging the recyclebin did work(?), yet the delays were significant. Further references landed us to this page

By following the instructions, as sys we purged “dba_recyclebin” which was having approximately 262 objects and voila! The database started generating the tablespace details within a fraction of second.

Hope this helps few others out there!




Windows 7 host network slow after VMware, Oracle/Java VirtualBox installation

If you are on Windows 7 and experiencing degraded performance with HOST network (browsing other computers in the physical network has become dramatically slow, transfering files from or to other computers have become painfully slow and the transfer rate is just KBs while your connection is 100/1000MBPS) then be assured, the virtual adaptors installed by these virtual boxes are playing off.

Detailed explanation from VMWare KB article could be found here (This KB article is pretty old, however the issues handled are same till date, so don’t get confused)

To get over with this issue, you may go ahead and disable the virtual network adaptors installed by VMWare or Oracle/Java VirtualBox application(s).

Edit the virtual appliance network property and selected “Bridged” and optionally “Replicate physical network state” (check image)

Network Settings

Workaround status: Fully checked and confirmed.

For Windows7bugs,