GK's Tech Tips

Query to Monitor IMPDP

2010-12-30T01:32:00.000+05:30

Following query can be used to monitor the progress of impdp. select substr(sql_text,instr(sql_text,'into "'),30) table_name, rows_processed, round((sysdate-to_date(first_load_time,'yyyy-mm-dd hh24:mi:ss'))*24*60,1) minutes, trunc(rows_processed/((sysdate-to_date(first_load_time,'yyyy-mm-dd hh24:mi:ss'))*24*60)) rows_per_minute from sys.v_$sqlarea where sql_text like 'insert %

DDL of Indexes without Storage Parameters

2010-11-29T12:44:00.000+05:30

Taking DDL's of indexes is always a good habit before any export/import activity. But we get lot of parameters along with create statements, like storage parameters etc which we may not need them to run after the completion of import. So we can remove them before running the import by running the following statements. EXECUTE DBMS_METADATA.SET_TRANSFORM_PARAM(DBMS_METADATA.SESSION_TRANSFORM,'

How to check user objects created in SYSTEM tablespace not owned by SYS user

2010-04-13T14:30:00.000+05:30

Query to check objects created in SYSTEM tablespace and not owned by SYS or SYSTEM user. It is very important not to have user related objects in SYSTEM tablespace. select owner, segment_name, segment_type from dba_segments where tablespace_name = 'SYSTEM' and owner not in ('SYS','SYSTEM');

Checking if the database is using pfile or spfile

2010-04-13T13:01:00.000+05:30

Use the following SQL query to see what parameter file is your database using currently. If it is PFILE or SPFILE. SELECT DECODE(value, NULL, 'PFILE', 'SPFILE') "Init File Type" FROM sys.v_$parameter WHERE name = 'spfile';

Determining longest query length in oracle database

2010-04-02T17:10:00.000+05:30

Following is the query to determine the longest query length in oracle database, this query can be very useful in setting up UNDO_RETENTION parameter. SQL> select max(maxquerylen) from V$undostat; Make sure this is atleast equal to the value of UNDO_RETENTION to prevent a famous ORA-01555

Unlimited Broadband at best prices in Hyderabad

2010-03-28T19:52:00.000+05:30

Internet today has become very competitive in our country after launch of BSNL 3G. I have tried almost all ISP's in Hyderabad right from local net, Youtelecom to BSNL EVDO. Of them all Beam Tele which was called as Beam cable before offers high speed internet at a very good price. I have been using it for almost 6 years for my desktop, they service is a bit lethargic but speeds are good at very

BSNL's EVDO In Hyderabad Review

2010-01-17T13:41:00.000+05:30

After a thorough research about BSNL's EVDO card 2 mb/s , I had a horrific experience bringing it home. Here is how it went and my comments on the newly launched internet card by bsnl. I went to the Telephone bhavan (Khairtabad) and enquired about the card, plans and coverage information. I got very little information from them, as they themselves had no knowledge about it lol, suprisingly they

Free call anywhere in the world

2009-08-14T20:13:00.000+05:30

Hi Guys, Call to any phone FREE of cost, from yahoo messenger...Here is how it works: First call +18003733411 in the messenger, its a toll free number...listen to what it says and go for Free phone call option. After few seconds it would ask you to enter the phone number along with country code, thats it!! Enjoy !! :D

How to put google analytics code in SMF

2009-08-12T13:30:00.000+05:30

Hi, If you wanna track your website stats with google analytics you have put the code before , which is a piece of cake usually in any html website. But in SMF you have to put it inside the echo '' of php. I have done the tough part, just follow these steps: Find: echo ' </body></html>'; Replace it with: echo ' <div id="ajax_in_progress" style="display: none;', $context['

How to upload a word document in php

2009-05-15T12:34:00.000+05:30

I've taken the basic idea from w3schools on how to upload files in php. I will show you now how to modify the code a bit and upload MS-word documents.Create a php page which contains both upload form (html) and actual php code to load the file. You can have them both separately aswell.upload.php<?phpif(isset($_POST['submit'])){if ((($_FILES["file"]["type"] == "application/msword"))){if ($_FILES["

Free PHP/MYSQL web hosting

2008-12-26T10:48:00.000+05:30

PHP/Mysql still prevails to be one of the best technologies for the web development and other web-related projects, mainly because it is an open-source so obviously cost effective and web development using php is so simple, thanks to cake-php. Back to the topic, if you are planning to start a website or blog or a forum and you wanted to start it with 0% investment. Then here is the best solution

Free e-books

2008-12-16T17:19:00.000+05:30

While I was browsing for some programming books. I found this ftp link which has huge list of e-books on various subjects in computers. I found it very useful, so thought I should share this link to my viewers.Here is the link:ftp://202.96.64.144/pub/books/

How to recover a deleted file in windows (Shift + Del)

2008-12-04T11:27:00.000+05:30

You all might be wondering, how to recover a file when it is permanently deleted (shift + del) from the system. Lemme put it this way, if you clear the files from the Recycle bin in windows, then here is the tip to restore your files.Fact: When a file is deleted from your computer, its contents aren’t immediately destroyed. Its hard drive space is made available for use, but until that space is

Tips To Avoid Virus Attacks

2008-11-22T11:53:00.000+05:30

Computers are always prone to virus attacks through many ways like when we insert USB which is virus infected or by clicking anonymous pop-ups/links..the list goes on. And there are many anti-virus software's available in the market to prevent these virus attacks, I would like to share some of my views on how to prevent virus attacks and important tips that one must remember on how to tackle

How To Cheat Online Yahoo Chess

2008-09-28T10:09:00.001+05:30

Cheating and winning games is a fun way of doing isn't?. Beating world wide opponents needs a real class and brain, yeah!! I am talking about online yahoo chess. There are many tools available on web to cheat Y! chess and outsmart your partners but I am sure they aren't for FREE!. Here's a free and clean way of winning and keeping your rating high!First download a chess game for your O.S. or

How to cheat online flash games

2007-09-28T14:44:00.000+05:30

Here is a good vid tutorialHow to cheat in online flash games.Uploaded by laconix

David Beckham Theme

2007-09-27T12:47:00.000+05:30

Yeahooo! I have created a theme of Beckham atlas!!. Yes you can grab it if you're one of his million fans. Theme is simple with cool icons and You have all rights to edit the template as you wish.Here is the preview of the templateDownlaod.xmlview it live at http://beckhamtheme.blogspot.com/ Please report me if any bugs.

Web site made easy

2007-09-22T18:14:00.000+05:30

Web creation is really made simple with weebly a website editor. It is basically Ajax based web editor where you can create a cool web site with simple drag-n-drop widgets. You can even create a blog and earn some bucks as it supported with Adbrite. Weebly a very good option for those who are looking for a simple personal website. I will rate it higher than Googlepages. Though you don't have the

ʇxǝʇ ǝɥʇ dılɟ

2007-09-21T19:32:00.000+05:30

Follow the link ->http://www.revfad.com/flip.htmlJust another innovative idea to use in orkut's profile name.

Change background of the USB drive

2007-09-14T18:11:00.000+05:30

Change the background of the USB drive in less than 10 secs. You can add any image. Here are the steps to follow:Open a "notepad". (Note: start->run->notepad).Copy the following code into the notepad [.ShellClassInfo]IconFile=%SystemRoot%\system32\SHELL32.dllIconIndex=127ConfirmFileOp=0[{BE098140-A513-11D0-A3A4-00C04FD706EC}]Attributes=1IconArea_Image="

How to get acess to the Members area?

2007-09-09T17:48:00.000+05:30

Finally Im back with a new cool web 2.o template. Doesn't it look sexy?. Now no more breaks, I will be blogging at least 4 days a week!!.Back to the work. Many of us might have a dream. Dream to enter into the Members Area of a site with out a single buck and downloading the videos as we wish say porn :p or anything. Once again our good amigo does the work for us. you will see how.Now for

How to use Peer to Peer softwares for downloading?

2007-07-10T14:29:00.000+05:30

This is a frequent question asked by my fellow bloggers and friends. Though its easy but tricky at times. It is advisible to know about the Peer2Peer network and its consequences. I do not want to go in detail about the softwares coz you will get many peer to peer softwares if you google. I use Ares software for downloading movies and mp3's. Let us see the working of ares and the same applies to

Useful Run Commands

2007-06-20T19:25:00.000+05:30

Here are 101 RUN commands:Accessibility Controlsaccess.cplAdd Hardware Wizardhdwwiz.cplAdd/Remove Programsappwiz.cplAdministrative Toolscontrol.exe admintoolsAutomatic Updateswuaucpl.cplBluetooth Transfer WizardfsquirtCalculatorcalcCertificate Managercertmgr.mscCharacter MapcharmapCheck Disk UtilitychkdskClipboard ViewerclipbrdCommand PromptcmdComponent ServicesdcomcnfgComputer

Some cool wordpress templates

2007-05-30T15:10:00.000+05:30

I am back finally! after spending lots of time with my books and Now I am officially a computer engineer :p. Here are some cool wordpress templates.DownloadDownloadDownloadDownload em before they expire, I mean links.

Hide your secret file in a image

2007-04-29T15:05:00.000+05:30

This is by far the best way to hide your data in a image. This trick works in Windows 2000/xp. Follow the step by step tutorial.You need two images and one file(which you want to bind with the image). Place them all in one folder.Add the files you want to hide into a new winrar archive. (eg: I want to hide sordid.txt)Open the command prompt (start-> run-> cmd). Change the directory to where the