The tab system I’ve chose to come up with my blog pages has just got a new section: “My Presos”. Direct Link: http://bit.ly/lmc-presos Filed under: Uncategorized Tagged: LinkedIn
When Oracle transforms a query it will sometimes report an internal view name in the execution plan – and I have seen people asking for help occasionally because they’ve tried to find the view name in dba_views and it hasn’t existed. So, just for reference, here’s a short list of the view names that might [...]
In my previous post, I discussed how Oracle from 11g R2 onwards will automatically drop the segment and associated storage from unusable index objects. Mohamend Houri asked in the comments section the excellent question of just how useful this feature will be in real life cases when typically indexes are not left in an unusuable state for a [...]
Steps to Install profilerpictogram.tff font on OEL5 from command line:
[root@test share]# cd /usr/share/fonts
[root@test fonts]# mkdir ttfonts
[root@test fonts]# cd ttfonts
[root@test ttfonts]# pwd
In a recent discussion I've mentioned that I thought to remember that the DML part of conventional load as select inserts will always be executed serially, even with parallel DML enabled and requesting parallel DML execution. It's important to understand in this context that this is not the same as the parallel query execution of the SELECT part, which is possible independently from the parallel DML part.
After that discussion I realized that it was quite some time ago that I tested this scenario, probably it was back then with some 10.2 version.
February 26, 2011 In a recent OTN thread in the SQL forum I found a SQL statement (see the thread for the original SQL statement) that the original poster (OP) wanted to transform into full outer join syntax, but was unsure how to start the transformation. To get started with helping the OP, you first [...]
Reliable Datagram Sockets (RDS) is a reliable-socket off-load driver and inter-processor communication (IPC) protocol with low overhead, low-latency, high-bandwidth. RDS enables enhanced application performance and cluster scalability.
***Contributor: www.openfabrics.org (Particularly, Oracle)***