Tag: slow

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

On By windows7bugsIn NOT a DBA, Oracle database 11gLeave a comment

Hi guys

Recently we migrated our database from 10gR2 (10.2.0.3) 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!

regards,

rajesh

 

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

On By windows7bugsIn Windows 7Leave a comment

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,

Admin