Tryst with all things Oracle
Thursday, February 27, 2014
Splitting a huge file? Use Gsplit
›
Absolutely loved this tool. I had to split a 11 million records file into manageable chunks or 'pieces' as Gsplit calls it. It ga...
Friday, February 7, 2014
Sybase to Oracle migration - Step by Step
›
http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/sqldev/r30/SybaseMigration/SybaseMigration.htm
Wednesday, October 2, 2013
Good site to learn DW Data warehousing
›
http://dwhlaureate.blogspot.com/2012/06/difference-between-star-snowflake.html
Tuesday, June 4, 2013
Why index is not used?
›
Tom Kyte describes the 6 main reasons a index may not be used by CBO: Superb article. Lays down the basics beautifully. http://searchor...
Friday, May 24, 2013
No more, no less comparison
›
One of the queries I finally came up today is worth documenting; well at least I thought so. Here is the scenario: An input lis...
Friday, April 5, 2013
INSERT in PL/SQL... can be slow
›
Suggest Way for fast INSERTs Mark indexes unuasble ...
Wednesday, March 27, 2013
TOAD prompt for host variables
›
I was pretty much pleased with the way we were progressing. I was using this method for testing procedures from toad to see responses from ...
›
Home
View web version
