tag:blogger.com,1999:blog-4723148005696200432Thu, 03 Oct 2024 21:20:39 +0000Tips n TricksSoftwaresTop StoriesoracleBloggingScriptsmiscellaneousYahoo messenger toolsBlogger TemplatesCheatsEVDO CardORA-01555ReviewTemplatesWeb HostingYahoo Chess Cheate-bookspfilephpsmfspfileTechnology | Gadgets | Tips & Trickshttp://gktechtips.blogspot.com/noreply@blogger.com (chaitanya.gk)Blogger47125tag:blogger.com,1999:blog-4723148005696200432.post-5985342973114851752Wed, 29 Dec 2010 20:02:00 +00002010-12-30T01:32:41.683+05:30oracleFollowing 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 %http://gktechtips.blogspot.com/2010/12/query-to-monitor-impdp.htmlnoreply@blogger.com (chaitanya.gk)1tag:blogger.com,1999:blog-4723148005696200432.post-3763768388485167781Mon, 29 Nov 2010 07:14:00 +00002010-11-29T12:44:55.607+05:30oracleTaking 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,'http://gktechtips.blogspot.com/2010/11/ddl-of-indexes-without-storage.htmlnoreply@blogger.com (chaitanya.gk)0tag:blogger.com,1999:blog-4723148005696200432.post-3012096071786077411Tue, 13 Apr 2010 09:00:00 +00002010-04-13T14:30:06.503+05:30oracleQuery 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');http://gktechtips.blogspot.com/2010/04/how-to-check-user-objects-created-in.htmlnoreply@blogger.com (chaitanya.gk)0tag:blogger.com,1999:blog-4723148005696200432.post-3762467646712805465Tue, 13 Apr 2010 07:31:00 +00002010-04-13T13:04:09.204+05:30oraclepfilespfileUse 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';http://gktechtips.blogspot.com/2010/04/checking-if-database-is-using-pfile-or.htmlnoreply@blogger.com (chaitanya.gk)0tag:blogger.com,1999:blog-4723148005696200432.post-3555761561819014746Fri, 02 Apr 2010 11:40:00 +00002010-04-02T17:10:30.959+05:30ORA-01555oracleFollowing 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-01555http://gktechtips.blogspot.com/2010/04/determining-longest-query-length-in.htmlnoreply@blogger.com (chaitanya.gk)0tag:blogger.com,1999:blog-4723148005696200432.post-1838738994869373401Sun, 28 Mar 2010 14:22:00 +00002010-03-28T19:52:10.776+05:30Internet 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 veryhttp://gktechtips.blogspot.com/2010/03/unlimited-broadband-at-best-prices-in.htmlnoreply@blogger.com (chaitanya.gk)0tag:blogger.com,1999:blog-4723148005696200432.post-6255949423892646935Sun, 17 Jan 2010 08:11:00 +00002010-01-17T13:41:59.761+05:30EVDO CardReviewAfter 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 theyhttp://gktechtips.blogspot.com/2008/10/bsnls-evdo-in-hyderabad-review.htmlnoreply@blogger.com (chaitanya.gk)52Andhra Pradesh, India17.0477624 80.098186911.8028684 72.6274839 22.2926564 87.5688899tag:blogger.com,1999:blog-4723148005696200432.post-2067144539361980636Fri, 14 Aug 2009 14:43:00 +00002009-11-08T06:47:38.716+05:30Tips n TricksHi 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 !! :Dhttp://gktechtips.blogspot.com/2009/08/free-call-anywhere-in-world.htmlnoreply@blogger.com (chaitanya.gk)0tag:blogger.com,1999:blog-4723148005696200432.post-2442110199777408677Wed, 12 Aug 2009 08:00:00 +00002009-08-12T13:33:37.084+05:30smfHi, 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 ' &http://gktechtips.blogspot.com/2009/08/how-to-put-google-analytics-code-in-smf.htmlnoreply@blogger.com (chaitanya.gk)0tag:blogger.com,1999:blog-4723148005696200432.post-7614496823731321755Fri, 15 May 2009 07:04:00 +00002009-05-15T12:47:35.543+05:30phpI'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 ($http://gktechtips.blogspot.com/2009/05/how-to-upload-word-document-in-php.htmlnoreply@blogger.com (chaitanya.gk)4tag:blogger.com,1999:blog-4723148005696200432.post-2164962406061131515Fri, 26 Dec 2008 05:18:00 +00002008-12-26T12:24:23.924+05:30Web HostingPHP/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 http://gktechtips.blogspot.com/2008/12/free-phpmysql-web-hosting.htmlnoreply@blogger.com (chaitanya.gk)6tag:blogger.com,1999:blog-4723148005696200432.post-5088544191770613424Tue, 16 Dec 2008 11:49:00 +00002008-12-16T17:28:02.353+05:30e-booksWhile 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/http://gktechtips.blogspot.com/2008/12/free-e-books.htmlnoreply@blogger.com (chaitanya.gk)0tag:blogger.com,1999:blog-4723148005696200432.post-6972533906424995437Thu, 04 Dec 2008 05:57:00 +00002008-12-04T12:00:30.177+05:30SoftwaresTips n TricksYou 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 ishttp://gktechtips.blogspot.com/2008/12/how-to-recover-deleted-file-in-windows.htmlnoreply@blogger.com (chaitanya.gk)0tag:blogger.com,1999:blog-4723148005696200432.post-2543812251603014447Sat, 22 Nov 2008 06:23:00 +00002008-11-26T19:48:53.238+05:30Tips n TricksComputers 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 http://gktechtips.blogspot.com/2008/11/tips-to-avoid-virus-attacks.htmlnoreply@blogger.com (chaitanya.gk)1tag:blogger.com,1999:blog-4723148005696200432.post-4396474560889045503Sun, 28 Sep 2008 04:39:00 +00002008-09-28T16:05:04.713+05:30CheatsYahoo Chess CheatCheating 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 http://gktechtips.blogspot.com/2008/09/how-to-cheat-online-yahoo-chess.htmlnoreply@blogger.com (chaitanya.gk)10tag:blogger.com,1999:blog-4723148005696200432.post-5938068877125998218Fri, 28 Sep 2007 09:14:00 +00002007-09-28T14:46:20.580+05:30Tips n TricksHere is a good vid tutorialHow to cheat in online flash games.Uploaded by laconixhttp://gktechtips.blogspot.com/2007/09/how-to-cheat-online-flash-games.htmlnoreply@blogger.com (chaitanya.gk)0tag:blogger.com,1999:blog-4723148005696200432.post-8281972514515923456Thu, 27 Sep 2007 07:17:00 +00002007-09-27T13:15:59.274+05:30Blogger TemplatesTemplatesYeahooo! 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.http://gktechtips.blogspot.com/2007/09/david-beckham-theme.htmlnoreply@blogger.com (chaitanya.gk)0tag:blogger.com,1999:blog-4723148005696200432.post-299608732935398912Sat, 22 Sep 2007 12:44:00 +00002007-09-22T20:51:38.034+05:30miscellaneousTop StoriesWeb 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 http://gktechtips.blogspot.com/2007/09/web-site-made-easy.htmlnoreply@blogger.com (chaitanya.gk)0tag:blogger.com,1999:blog-4723148005696200432.post-1211958226697488379Fri, 21 Sep 2007 14:02:00 +00002007-09-21T19:42:58.429+05:30Tips n TricksFollow the link ->http://www.revfad.com/flip.htmlJust another innovative idea to use in orkut's profile name.http://gktechtips.blogspot.com/2007/09/x-dl.htmlnoreply@blogger.com (chaitanya.gk)0tag:blogger.com,1999:blog-4723148005696200432.post-8288927040464686561Fri, 14 Sep 2007 12:41:00 +00002007-09-14T19:00:58.536+05:30ScriptsTips n TricksChange 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="your_picture.jpg"http://gktechtips.blogspot.com/2007/09/change-background-of-usb-drive.htmlnoreply@blogger.com (chaitanya.gk)0tag:blogger.com,1999:blog-4723148005696200432.post-3919985700256259903Sun, 09 Sep 2007 12:18:00 +00002007-09-09T18:15:25.291+05:30Tips n TricksFinally 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 http://gktechtips.blogspot.com/2007/09/how-to-get-acess-to-members-area.htmlnoreply@blogger.com (chaitanya.gk)2tag:blogger.com,1999:blog-4723148005696200432.post-2064798528895153148Tue, 10 Jul 2007 08:59:00 +00002007-09-07T20:46:47.178+05:30Tips n TricksThis 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 http://gktechtips.blogspot.com/2007/07/how-to-use-peer-two-peer-softwares-for.htmlnoreply@blogger.com (chaitanya.gk)1tag:blogger.com,1999:blog-4723148005696200432.post-5165862208925075674Wed, 20 Jun 2007 13:55:00 +00002007-06-20T19:37:56.579+05:30Here 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 http://gktechtips.blogspot.com/2007/06/useful-run-commands.htmlnoreply@blogger.com (chaitanya.gk)0tag:blogger.com,1999:blog-4723148005696200432.post-2543786862797764352Wed, 30 May 2007 09:40:00 +00002007-05-30T15:21:36.554+05:30miscellaneousI 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.http://gktechtips.blogspot.com/2007/05/some-cool-wordpress-templates.htmlnoreply@blogger.com (chaitanya.gk)0tag:blogger.com,1999:blog-4723148005696200432.post-8980942390748825980Sun, 29 Apr 2007 09:35:00 +00002007-04-29T16:01:36.477+05:30Tips n TricksThis 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 http://gktechtips.blogspot.com/2007/04/hide-your-secret-file-in-image.htmlnoreply@blogger.com (chaitanya.gk)0