Tech Doubts https://www.techdoubts.com/ Technology Blog Sun, 26 Jan 2014 17:18:51 +0000 en-US hourly 1 https://wordpress.org/?v=6.6.2 38105414 What are Google Apps? https://www.techdoubts.com/google-apps/ Tue, 24 Dec 2013 11:15:16 +0000 http://techdoubts.com/?p=1189 Google Apps are web application software developed by Google. Applications are software programs for specific purposes. Thus, Google Apps are software programs developed by Google for specific purposes. Examples of Google Apps include Google Maps and Google Toolbar. About Google Google has emerged as a synonym for Web. The Web …

The post What are Google Apps? appeared first on Tech Doubts.

]]> 1189 How To Transfer Your Domain Name To Another Registrar? https://www.techdoubts.com/how-to-transfer-your-domain-name-to-another-registrar/ Thu, 21 Feb 2013 14:31:15 +0000 http://techdoubts.com/?p=1169 Domain name transfer is the process by which your domain name is transferred from your current registrar (say, Fastdomain) to a new registrar (say, Godaddy). The process might seem a little complicated for beginners. People tend to confuse this process with domain name registration, domain name renewal or at times …

The post How To Transfer Your Domain Name To Another Registrar? appeared first on Tech Doubts.

]]> 1169 Bluehost Servers down for 5 hrs! Websites Back In Action Now! https://www.techdoubts.com/bluehost-servers-down/ Sun, 03 Feb 2013 10:43:50 +0000 http://techdoubts.com/?p=1160 Bluehost – one of the biggest web hosting companies of the world had a day which they would like to forget. Bluehost Data Center experienced a power surge that caused many of Bluehost’s (BH) servers and phone network to be unavailable for nearly 5 hours. Many of our websites including TechDoubts.com …

The post Bluehost Servers down for 5 hrs! Websites Back In Action Now! appeared first on Tech Doubts.

]]> 1160 How To Link AdSense Account To Google Analytics https://www.techdoubts.com/how-to-link-adsense-account-to-google-analytics/ Wed, 30 Jan 2013 18:10:25 +0000 http://techdoubts.com/?p=1137 Webmasters or publishers have the option to integrate Google Adsense Account to Google Analytics. The Google Analytics integration helps to monitor AdSense earnings better. But the important thing to note here is that – You can only link your AdSense account to one Google Analytics account at a time. Inside your …

The post How To Link AdSense Account To Google Analytics appeared first on Tech Doubts.

]]> 1137 Find the CPU intensive SQL Query : UNIX Level Mapping of PID and SPID https://www.techdoubts.com/find-cpu-intensive-sql-query-unix-map-pid-spid/ Sun, 16 Dec 2012 08:16:24 +0000 http://techdoubts.com/?p=1127 The process to find the CPU intensive query requires UNIX as well as Database level mapping. Step 1: The first step is to find the PID of the most CPU consuming process from UNIX level. SQL> ! prstat -s cpu -n 5 PID USERNAME SIZE RSS STATE PRI NICE TIME …

The post Find the CPU intensive SQL Query : UNIX Level Mapping of PID and SPID appeared first on Tech Doubts.

]]> 1127 Online Shopping At Amazon – Best Deals https://www.techdoubts.com/online-shopping-at-amazon-best-deals/ Fri, 23 Nov 2012 14:51:22 +0000 http://techdoubts.com/?p=1114 Looking for the right time to buy from Amazon.com for special discounts? Most gadget lovers take the best out of amazon during special promotional events like Cyber Monday or Black Friday. During these days, products will be available at very low prices. Deals and Bargains at Amazon Deals and Bargains Best …

The post Online Shopping At Amazon – Best Deals appeared first on Tech Doubts.

]]> 1114 Facebook Crosses 100 Crore Users! https://www.techdoubts.com/facebook-crosses-100-crore-users/ Thu, 04 Oct 2012 17:04:34 +0000 http://techdoubts.com/?p=1104 FB Status update : Facebook turns 1 billion user plus. Below lines are updated in Mark Zuckerberg’s FB profile. This morning, there are more than one billion people using Facebook actively each month. If you’re reading this: thank you for giving me and my little team the honor of serving …

The post Facebook Crosses 100 Crore Users! appeared first on Tech Doubts.

]]> 1104 Solar Energy Technologies In A Nutshell https://www.techdoubts.com/solar-energy-technologies-in-a-nutshell/ Sat, 29 Sep 2012 11:41:10 +0000 http://techdoubts.com/?p=1082 Solar Energy Technologies Solar Concentration Photo Voltaic Technology Thin Film Technology

The post Solar Energy Technologies In A Nutshell appeared first on Tech Doubts.

]]> 1082 Defense Technologies In A Nutshell https://www.techdoubts.com/defense-technologies-in-a-nutshell/ Sat, 29 Sep 2012 11:41:10 +0000 http://techdoubts.com/?p=1080 Ballistic Missiles Cruise Missiles Stealth Technology Cryogenics

The post Defense Technologies In A Nutshell appeared first on Tech Doubts.

]]> 1080 What’s Happening In the Space Right Now? https://www.techdoubts.com/whats-happening-in-the-space-right-now/ Sat, 29 Sep 2012 11:41:10 +0000 http://techdoubts.com/?p=1076 Space Bound Telescopes Space Probes Space Stations Space Projects

The post What’s Happening In the Space Right Now? appeared first on Tech Doubts.

]]> 1076 What’s Latest Among Information and Communication Technologies https://www.techdoubts.com/whats-latest-among-information-and-communication-technologies/ Sat, 29 Sep 2012 11:41:10 +0000 http://techdoubts.com/?p=1073 DNA Computing Cloud Computing Super Computers Fiber Optics Super Conductivity RFID Technology Artificial Intelligence Robotics

The post What’s Latest Among Information and Communication Technologies appeared first on Tech Doubts.

]]> 1073 Nanotechnology In A Nutshell https://www.techdoubts.com/nanotechnology-in-a-nutshell/ Sat, 29 Sep 2012 11:41:10 +0000 http://techdoubts.com/?p=1070 Nanotechnology Definition Nano-materials Methods of Preparation of Nano-materials Popular Nanomaterials Applications of Nanomaterials Threats of Nanotechnology  

The post Nanotechnology In A Nutshell appeared first on Tech Doubts.

]]> 1070 Nuclear Technology In A Nutshell https://www.techdoubts.com/nuclear-technology-in-a-nutshell/ Sat, 29 Sep 2012 11:41:10 +0000 http://techdoubts.com/?p=1053 Nuclear Technology Definition Nuclear Particles : Nucleons Radioactivity – Natural and Artificial(Transmutation) Types of Radiations Nuclear Reactions Nuclear Fission Nuclear Fusion Nuclear Reactors Nuclear Projects like ITER, LHC, FAIR, INO Nuclear Technology Definition Nuclear Particles : Nucleons Radioactivity – Natural and Artificial(Transmutation) Types of Radiations Nuclear Reactions Nuclear Fission Nuclear Fusion Nuclear Reactors …

The post Nuclear Technology In A Nutshell appeared first on Tech Doubts.

]]> 1053 Bio Energy Technologies In A Nutshell https://www.techdoubts.com/bio-energy-technologies-in-a-nutshell/ Sat, 29 Sep 2012 11:41:09 +0000 http://techdoubts.com/?p=1084 Bio Energy Technologies In A Nutshell Biomass Bio-fuels Biogas

The post Bio Energy Technologies In A Nutshell appeared first on Tech Doubts.

]]> 1084 Hot and Best at Flipkart – Online Shopping@India https://www.techdoubts.com/hot-and-best-at-flipkart-online-shopping-india/ Sun, 09 Sep 2012 13:45:46 +0000 http://techdoubts.com/?p=1047 Flipkart is on its way to become the Indian Amazon. Starting off as an online book store, the e-commerce portal has now diversified into almost all arenas including gadgets and apparels. A list of links covering the hot selling products at flipkart.com. Hot Smart Phones Hot Cameras Hot Computers Top Selling IT components …

The post Hot and Best at Flipkart – Online Shopping@India appeared first on Tech Doubts.

]]> 1047 ENCODE Project https://www.techdoubts.com/encode-project/ Thu, 06 Sep 2012 18:16:12 +0000 http://techdoubts.com/?p=1026 ENCODE project is the acronym of ENCyclopedia Of DNA Elements. This was a major Bio-technology Project after Human Genome Project. Countries co-operated include US, UK, Spain, Singapore and Japan. Research Results of ENCODE projects were published in 2012. The highlights of the findings were as follows. As a deviation from Human Genome Project, the …

The post ENCODE Project appeared first on Tech Doubts.

]]> 1026 How To Install Oracle 10g Database Software on Windows https://www.techdoubts.com/install-oracle-database-software-windows/ Sat, 14 Jul 2012 19:02:22 +0000 http://techdoubts.com/?p=970 Oracle Database – What is a database? Database, in one of the simplest definitions can be said to be a huge collection of related data like numbers, characters etc. Normally, data will be stored in structures like tables which forms a part of the database. For creating and managing databases there …

The post How To Install Oracle 10g Database Software on Windows appeared first on Tech Doubts.

]]> 970 How To Turn Mobile Phone Into PC Modem – Wi-Fi Hotspot Always Around You! https://www.techdoubts.com/how-to-turn-mobile-phone-into-pc-modem/ Sat, 07 Jul 2012 15:41:31 +0000 http://techdoubts.com/?p=957 No Internet Connection in PC? Turn Mobile Phone Into PC Modem! Wondering how to Turn Mobile Phone into PC Modem? It is quite easy . Accessing internet (GPRS or 3G) over mobile phone is not a new thing now. But with the advent of 3G in mobile phones, the scope of …

The post How To Turn Mobile Phone Into PC Modem – Wi-Fi Hotspot Always Around You! appeared first on Tech Doubts.

]]> 957 Tata DOCOMO Broadband – How To Select The Right USB Modem Device? https://www.techdoubts.com/tata-docomo-broadband-usb-modem/ Sat, 07 Jul 2012 07:17:12 +0000 http://techdoubts.com/?p=950 What is Tata Docomo ? Tata Docomo is one among the high speed wireless broadband providers in India. They have mobile communication option(voice service) too. How can I get a Tata DOCOMO Broadband Connection? Tata DOCOMO broadband service is mainly available with the help of USB Modems, commonly known as Photon Devices …

The post Tata DOCOMO Broadband – How To Select The Right USB Modem Device? appeared first on Tech Doubts.

]]> 950 Why Should You Use Facebook Messenger For Windows Desktop? https://www.techdoubts.com/use-facebook-messenger-windows-desktop/ Mon, 02 Jul 2012 12:09:00 +0000 http://techdoubts.com/?p=872 Facebook Launches Windows Desktop App – Facebook Messenger At a time when people are not so enthusiastic about Desktop Apps, Facebook comes up with Facebook Messenger, a chat service app for Windows. And why should you install this desktop app when you are happy with the web app version? Here …

The post Why Should You Use Facebook Messenger For Windows Desktop? appeared first on Tech Doubts.

]]> 872 7 Easy Tips To Stay Healthy https://www.techdoubts.com/7-easy-tips-to-stay-healthy/ Fri, 24 Feb 2012 04:02:49 +0000 http://techdoubts.com/?p=868 Care in little things makes big difference. Follow these easy tips for better health, and see the difference it can make to your life! Stay Healthy, Stay Happy! 1. Drink lots of water Make it a point to drink 10-20 glasses of water a day. Carry a water bottle or …

The post 7 Easy Tips To Stay Healthy appeared first on Tech Doubts.

]]> 868 30 Must Read Tips For SEO and Blog Traffic https://www.techdoubts.com/30-must-read-tips-for-seo-and-blog-traffic/ Sat, 11 Feb 2012 11:09:04 +0000 http://techdoubts.com/?p=851 What are the must read websites for improving SEO and Blog Traffic? Traffic is the key for the success of any website or blog. And driving traffic to a blog is the science and art of web-marketing.  The product or service you have to market as the webmaster is your …

The post 30 Must Read Tips For SEO and Blog Traffic appeared first on Tech Doubts.

]]> 851 How To Stop Alerts or Subscriptions In Your Mobile Phone? https://www.techdoubts.com/how-to-stop-alerts-or-subscriptions-in-your-mobile-phone/ Sat, 11 Feb 2012 05:40:59 +0000 http://techdoubts.com/?p=846 You might want to un-subscribe from the  services like news, words, health tips etc from your sim(service provider), and wonder what to do to get rid of these unwanted alerts which drains your talk-time amount too? How to Stop Alerts and Subscriptions like news from your Airtel Sim : Here …

The post How To Stop Alerts or Subscriptions In Your Mobile Phone? appeared first on Tech Doubts.

]]> 846 What is SAR Limit of Mobile Phones? https://www.techdoubts.com/what-is-sar-limit-of-mobile-phones/ Tue, 07 Feb 2012 10:42:17 +0000 http://techdoubts.com/?p=841 Specific Absorption rate (SAR) is  the amount of radio frequency energy absorbed by the body when using a phone.  The value should be minimum for a good phone which cause no/minimum health problems. The  Federal Communication Commission (FCC) standard for SAR limit of 1.6 watts per kilogram averaged over a …

The post What is SAR Limit of Mobile Phones? appeared first on Tech Doubts.

]]> 841 Amazon.com starts operations in India as Junglee.com! https://www.techdoubts.com/amazon-com-starts-operations-in-india-as-junglee-com/ Thu, 02 Feb 2012 04:29:15 +0000 http://techdoubts.com/?p=835 Amazon.com goes live today in India as Junglee.com. Offered in the beta version, it offers different catagories of products to shop online including books, mobiles, laptops, gaming consoles etc. But the main difference in the business model is that Junglee uses the service of other sellers for the process. The customers are …

The post Amazon.com starts operations in India as Junglee.com! appeared first on Tech Doubts.

]]> 835 What are RSS Feeds? https://www.techdoubts.com/what-are-rss-feeds/ Sat, 28 Jan 2012 11:33:19 +0000 http://techdoubts.com/?p=828 What are RSS Feeds? What is an RSS Reader? Have you ever felt like you should subscribe to a an interesting website so that you will not miss any posts of that website? What if there are a lot of websites or blogs of your interest and you want to …

The post What are RSS Feeds? appeared first on Tech Doubts.

]]> 828 10 Must Use Tools To Increase Blog Traffic https://www.techdoubts.com/10-must-use-tools-to-increase-blog-traffic/ Sun, 15 Jan 2012 03:08:46 +0000 http://techdoubts.com/?p=802 Listing out a few service and tools to increase traffic to your blog or website. Google Analytics – Helps to get you an idea about daily traffic. Google Webmaster Tools – Helps Webmasters to check the fundamentals, submit site-map etc. Google Adwords – Submit Ads of your website to Google …

The post 10 Must Use Tools To Increase Blog Traffic appeared first on Tech Doubts.

]]> 802 Will The World End in 2012? https://www.techdoubts.com/will-the-world-end-in-2012/ Thu, 05 Jan 2012 08:10:40 +0000 http://techdoubts.com/?p=798 World End in 2012? NASA rejects the claim that the World will end in 2012 naming it as another internet hoax. World will not end in 2012, and there are no treats from the so called planet Nibiru, magnetic reversal of poles or solar storms , says the NASA scholars. …

The post Will The World End in 2012? appeared first on Tech Doubts.

]]> 798 Aakash tablets – 14 lakh booked in 14 days https://www.techdoubts.com/aakash-tablets-14-lakh-booked-in-14-days/ Wed, 04 Jan 2012 07:23:56 +0000 http://techdoubts.com/?p=794 Sales bookings for Aakash, world’s cheapest tablet have soared to 14 lakh units within just two weeks after it was put up for sale online for Rs 2,500 a piece.Aakash has received about 1 lakh orders a day since online launch last month. In comparison, Apple sold about 10 lakh iPads …

The post Aakash tablets – 14 lakh booked in 14 days appeared first on Tech Doubts.

]]> 794 How to Read Run Time Variables in UNIX? https://www.techdoubts.com/how-to-read-run-time-variables-in-unix/ Sun, 01 Jan 2012 07:13:07 +0000 http://techdoubts.com/?p=786 We may need to read run time variables, during the execution of a unix script. It is done with the help of read command. A few examples as below: server501:# echo “Enter Name: ” Enter Name: server501:# read name Angelina server501:# echo $name Angelina Some  other examples 1. server501:# #!/bin/sh server501:# …

The post How to Read Run Time Variables in UNIX? appeared first on Tech Doubts.

]]> 786 Shell Scripting Examples – Learn Shell Scripting the fastest way! https://www.techdoubts.com/shell-scripting-examples/ Sun, 01 Jan 2012 07:03:12 +0000 http://techdoubts.com/?p=780 Shell Scripting can be used for creating various scripts which help in complex  mathematical calculations or for UNIX operations. A few examples are given below: 1. To Compute square of n: 1. First open a file. server501:# vi square.sh Then ESC i, to go to insert mode Paste the code. n=1 while [ ${n} …

The post Shell Scripting Examples – Learn Shell Scripting the fastest way! appeared first on Tech Doubts.

]]> 780 YouTube’s 100 Most Viewed Videos https://www.techdoubts.com/youtube-100-most-viewed-videos/ Fri, 30 Dec 2011 11:22:36 +0000 http://techdoubts.com/?p=773 A list prepared by MewLists based on YouTube Charts. 1. Justin Bieber – Baby ft. Ludacris 2. Lady Gaga – Bad Romance 3. Waka Waka (This Time for Africa) (The Official 2010 FIFA… 4. Eminem – Love The Way You Lie ft. Rihanna 5. Charlie bit my finger – again …

The post YouTube’s 100 Most Viewed Videos appeared first on Tech Doubts.

]]> 773 SED Command https://www.techdoubts.com/sed-command/ Fri, 30 Dec 2011 10:48:15 +0000 http://techdoubts.com/?p=768 SED ( Stream editor) : A special editor for modifying files automatically. It has similarity with the “Find” and “Replace” command available in windows notepad/wordpad. sed command can be used to search and manipulate input text in many ways. Though mainly used for substitution, it can also do numerous other …

The post SED Command appeared first on Tech Doubts.

]]> 768 Classification of UNIX Commands https://www.techdoubts.com/classification-of-unix-commands/ Fri, 30 Dec 2011 09:04:33 +0000 http://techdoubts.com/?p=763 There are more than 200 UNIX level commands. The important ones are classified below: General Purpose Utilities passwd who whoami uname tty stty info Working With Directories mkdir rmdir ls File Handling Commands cat cp rm mv more wc cmp diff dos2unix tar gzip AND gunzip compress AND uncompress zip …

The post Classification of UNIX Commands appeared first on Tech Doubts.

]]> 763 AWK Command https://www.techdoubts.com/awk-command/ Fri, 30 Dec 2011 08:43:53 +0000 http://techdoubts.com/?p=758 Awk actually stands for the names of its authors: “Aho, Weinberger, & Kernighan”. Used for pattern scanning / filtering Command syntax :   awk  <search pattern> { action } Example : Consider the file test.log with the below data server501:[DATA001] /home/oracle -> cat test.log ANJELINA IS A GOOD GIRL RAMU …

The post AWK Command appeared first on Tech Doubts.

]]> 758 UNIX Architecture https://www.techdoubts.com/unix-architecture/ Fri, 30 Dec 2011 08:24:09 +0000 http://techdoubts.com/?p=753 UNIX Architecture can be best understood if we know the components in UNIX. The important components of UNIX OS can be classified as below. 1. Kernel – small program written i n C which interacts with hardware 2.Shell (Command Interpretor) – One shell is generated for each user for running commands. Bourne shell(sh) is …

The post UNIX Architecture appeared first on Tech Doubts.

]]> 753 Aakash Tablet – Why Should You Buy It? https://www.techdoubts.com/aakash-tablet-why-should-you-buy-it/ Thu, 29 Dec 2011 11:44:53 +0000 http://techdoubts.com/?p=734 The new sector of Tablet PCs has emerged, and masses are showing great enthusiasm at these new size gadgets. A range of gadgets are now available in the market ranging from iPad 2 to the  cheapest Aakash Tablets. iPad 2 without 3G costs around $499(Rs.25000) but the Aakash Tablet from …

The post Aakash Tablet – Why Should You Buy It? appeared first on Tech Doubts.

]]> 734 How Many Indexes Can Be Created Per Oracle Table? https://www.techdoubts.com/how-many-indexes-can-be-created-per-oracle-table/ Thu, 29 Dec 2011 07:54:27 +0000 http://techdoubts.com/?p=725 Unlimited Indexes can be created per Oracle Table. But Total number of columns per table that can be indexed is 32 for B-Tree index and 30 for Bit Map index. You can create many indexes for a table as long as the combination of columns differs for each index. You …

The post How Many Indexes Can Be Created Per Oracle Table? appeared first on Tech Doubts.

]]> 725 What is BioTechnology? Products, Effects and Jobs https://www.techdoubts.com/what-is-bio-technology/ Wed, 28 Dec 2011 08:31:59 +0000 http://techdoubts.com/?p=718 What is Biotechnology? How will you define Biotechnology? Biotechnology can be defined as a technology applied on living organisms (mainly at the cellular or molecular level) to alter their normal life processes to produce useful products or effects which has industrial, commercial or medical relevance. Useful Products of Biotechnology: Pharmaceutical products …

The post What is BioTechnology? Products, Effects and Jobs appeared first on Tech Doubts.

]]> 718 Lancer – Recommended Service Schedule https://www.techdoubts.com/lancer-recommended-service-schedule/ Sun, 25 Dec 2011 10:15:02 +0000 http://techdoubts.com/?p=713 When should you change Oil Filter, Fuel Filter, Engine Oil etc.?

The post Lancer – Recommended Service Schedule appeared first on Tech Doubts.

]]> 713 Important Specifications for Mitsubishi Lancer https://www.techdoubts.com/important-specifications-for-mitsubishi-lancer/ Sun, 25 Dec 2011 10:03:55 +0000 http://techdoubts.com/?p=707 Important Specifications for customer guidance – Lancer Spark Plug Gap – Valve Clearance – Emission etc Courtesy – Company/Service Publishing

The post Important Specifications for Mitsubishi Lancer appeared first on Tech Doubts.

]]> 707 What Are The Basic UNIX Ulilities / Commands? https://www.techdoubts.com/what-are-the-basic-unix-ulilities-commands/ Sat, 24 Dec 2011 17:12:32 +0000 http://techdoubts.com/?p=701 pwd                                       print working directory cd                                           change directory mkdir                                    make directory rmdir                                     remove directory ls                                             list contents of directory cat                                          display contents of files cp                                           copy one file to another rm                                          remove files tput clear                           clear screen who                                       …

The post What Are The Basic UNIX Ulilities / Commands? appeared first on Tech Doubts.

]]> 701 UNIX components – What are they? https://www.techdoubts.com/unix-components-what-are-they/ Sat, 24 Dec 2011 17:03:23 +0000 http://techdoubts.com/?p=698 The main divisions of UNIX components are: Kernel Shell Utilities External links: UNIX components

The post UNIX components – What are they? appeared first on Tech Doubts.

]]> 698 What is UNIX? https://www.techdoubts.com/what-is-unix/ Sat, 24 Dec 2011 16:20:09 +0000 http://techdoubts.com/?p=693 UNIX is the  trademarked form of Unics (Uniplexed Information and Computing System). UNIX is an important Operating System developed in 1969 by AT &T. Dennis Ritchie and Ken Thompson were the brains behind this OS. Though the  name UNIX is trademarked , UNIX is more like a family name now, …

The post What is UNIX? appeared first on Tech Doubts.

]]> 693 What is Oracle – Meaning of the word Oracle https://www.techdoubts.com/what-is-oracle/ Thu, 22 Dec 2011 12:08:16 +0000 http://techdoubts.com/?p=690 The word “Oracle” means – An authoritative person who divines the future . Oracle is  believed to be infallible. Oracle Corporation is software-hardware company whose main product is Oracle Database Software. Oracle Database Software is used to produce databases. Oracle software is proprietary, but they also owns the MySQL database software, …

The post What is Oracle – Meaning of the word Oracle appeared first on Tech Doubts.

]]> 690 Why Can’t I Access My Gmail Account? https://www.techdoubts.com/why-cant-i-access-my-gmail-account/ https://www.techdoubts.com/why-cant-i-access-my-gmail-account/#comments Sat, 17 Dec 2011 04:31:36 +0000 http://techdoubts.com/?p=686 There can be many reasons for your lack of access to your gmail account. It can be username, password or hacking issues. Date and Time Settings of the system can be another reason too, which we are discussing here. Date and Time Settings of the system: If you have enabled …

The post Why Can’t I Access My Gmail Account? appeared first on Tech Doubts.

]]> https://www.techdoubts.com/why-cant-i-access-my-gmail-account/feed/ 1 686 Find Blocking Session, Locks, Waiting Session of Database https://www.techdoubts.com/find-blocking-session-locks-waiting-session-of-database/ Mon, 05 Dec 2011 12:44:15 +0000 http://techdoubts.com/?p=682 SQL> select l1.sid, ‘ IS BLOCKING ‘, l2.sid from v$lock l1, v$lock l2 where l1.block =1 and l2.request > 0 and l1.id1=l2.id1 and l1.id2=l2.id2; SQL> SELECT SID, DECODE(BLOCK, 0, ‘NO’, ‘YES’ ) BLOCKER, DECODE(REQUEST, 0, ‘NO’,’YES’ ) WAITER FROM V$LOCK WHERE REQUEST > 0 OR BLOCK > 0 ORDER BY …

The post Find Blocking Session, Locks, Waiting Session of Database appeared first on Tech Doubts.

]]> 682 How To Check If Database Got Corrupted? https://www.techdoubts.com/how-to-check-if-database-got-corrupted/ Mon, 05 Dec 2011 11:01:06 +0000 http://techdoubts.com/?p=677 Datablock level Corruption can be found out with the help of the following two queries. SQL> SELECT distinct ‘Data Block# ‘|| block# || ‘ of Data File ‘ || name || ‘ is corrupted.’ FROM v$backup_corruption a, v$datafile b WHERE a.file# = b.file#; 2 3 4 no rows selected SQL> …

The post How To Check If Database Got Corrupted? appeared first on Tech Doubts.

]]> 677 How To Enable Audit Options In A Database https://www.techdoubts.com/how-to-enable-audit-options-in-a-database/ Mon, 05 Dec 2011 10:53:21 +0000 http://techdoubts.com/?p=671 SQL> show parameter audit_trail NAME TYPE VALUE ———————————— ———– —— audit_trail string DB SQL> AUDIT ALTER ANY OUTLINE BY ACCESS; Audit succeeded. SQL> AUDIT ALTER ANY ROLE BY ACCESS; Audit succeeded. SQL> AUDIT ALTER DATABASE BY ACCESS; Audit succeeded. SQL> AUDIT ALTER SEQUENCE BY ACCESS; Audit succeeded. SQL> AUDIT ALTER …

The post How To Enable Audit Options In A Database appeared first on Tech Doubts.

]]> 671 SYS.AUD$ Purging https://www.techdoubts.com/sys-aud-purging/ Mon, 05 Dec 2011 10:38:54 +0000 http://techdoubts.com/?p=666 col OS_USERNAME for a10; col USERNAME for a10; col TIMESTAMP for a10; col OWNER for a10; col OBJ_NAME for a10; col ACTION for a20; select OS_USERNAME,USERNAME,TIMESTAMP,OWNER,OBJ_NAME,ACTION from dba_audit_trail order by TIMESTAMP; select Min(NTIMESTAMP#) “Last AUD$ Purge Date ” from sys.aud$ where OBJ$NAME !=’AUD$’; SQL> select min(timestamp#)from sys.aud$; MIN(NTIMESTAMP#) —————————————— 15-SEP-09 …

The post SYS.AUD$ Purging appeared first on Tech Doubts.

]]> 666 Auditing The Database for User Actions https://www.techdoubts.com/auditing-the-database-for-user-actions/ Mon, 05 Dec 2011 10:09:40 +0000 http://techdoubts.com/?p=662 Auditing is the monitoring and recording of selected user database actions. When you use standard auditing, Oracle Database writes the audit records to either to DBA_AUDIT_TRAIL (the SYS.AUD$ Table), the operating system audit trail, or to the DBA_COMMON_AUDIT_TRAIL view, which combines standard and fine-grained audit log records.In addition, the actions …

The post Auditing The Database for User Actions appeared first on Tech Doubts.

]]> 662 Which Are The Best Technology Blogs? https://www.techdoubts.com/which-are-the-best-technology-blogs/ Tue, 22 Nov 2011 14:04:45 +0000 http://techdoubts.com/?p=657 There many decent Technology Blogs in the web (Not only TechDoubts.com :)) .But are you still facing difficulty in finding the right technology blogs ? Search the website Technorati.com, which contains a large blog directory on Tech Blogs and that will certainly help you. 3NKU4KUR9YGB

The post Which Are The Best Technology Blogs? appeared first on Tech Doubts.

]]> 657 How To Drop and Recreate Temporary Tablespace In Oracle? https://www.techdoubts.com/how-to-drop-and-recreate-temporary-tablespace-in-oracle/ Sun, 09 Oct 2011 06:22:49 +0000 http://techdoubts.com/?p=644 Oracle will not allow to drop the default temporary tablespace from a database. We have to assign a new default temp tablespace for the database to drop the current  tablespace. Suppose we need to drop and recreate the default temporary tablespace TEMP. Step 1: Create a new temporary tablespace temp1 …

The post How To Drop and Recreate Temporary Tablespace In Oracle? appeared first on Tech Doubts.

]]> 644 Oracle SYS_CONTEXT Function https://www.techdoubts.com/oracle-sys_context-function/ Mon, 19 Sep 2011 20:36:03 +0000 http://techdoubts.com/?p=637   How to check the database/instance name without having access to data dictionary views? How to get the client machine details from which I have connected to the Oracle database? How can I know my session details? These questions might have come up in the mind of many oracle database users …

The post Oracle SYS_CONTEXT Function appeared first on Tech Doubts.

]]> 637 How To Get The DDL For An Oracle User With All Roles And Privileges? https://www.techdoubts.com/how-to-get-the-ddl-for-an-oracle-user-with-all-roles-and-privileges/ Mon, 19 Sep 2011 19:08:07 +0000 http://techdoubts.com/?p=625   Sometimes we need to create a user similar to another user or we need to recreate a user in another database.In those situations,Oracle supplied package DBMS_METADATA can be used to generate the user creation DDL. >> To generate the User creation script SQL> SELECT dbms_metadata.get_ddl(‘USER’,’TEST’) FROM dual;   DBMS_METADATA.GET_DDL(‘USER’,’TEST’) …

The post How To Get The DDL For An Oracle User With All Roles And Privileges? appeared first on Tech Doubts.

]]> 625 How To Change Owner Of A Table In Oracle https://www.techdoubts.com/how-to-change-owner-of-a-table-in-oracle/ Sat, 17 Sep 2011 17:13:51 +0000 http://techdoubts.com/?p=620 Oracle provides no direct method to change the owner of a table. But we often face such situations to change the schema owner of the table. We have some work around to satisfy this requirement. Lets see them. 1. Export the table and import it into the new schema using …

The post How To Change Owner Of A Table In Oracle appeared first on Tech Doubts.

]]> 620 How To Monitor Index Usage In Oracle https://www.techdoubts.com/how-to-monitor-index-usage-in-oracle/ Sat, 17 Sep 2011 17:05:11 +0000 http://techdoubts.com/?p=616 Most of the time we are skeptical of the index usage. Though the index is created for the table, we may not be able to determine if it is actually used. Inorder to determine if the index is used, we can use the MONITORING USAGE clause in the alter index …

The post How To Monitor Index Usage In Oracle appeared first on Tech Doubts.

]]> 616 Invisible Index In Oracle 11g https://www.techdoubts.com/invisible-index-in-oracle-11g/ Sat, 17 Sep 2011 16:54:48 +0000 http://techdoubts.com/?p=610 Oracle 11g offers a new feature called Invisible Indexes by which an index can be marked as invisible by the Oracle. Once an index is set as invisible, Oracle optimizer no longer considers it. This is a very useful feature where we do not want the index to take effect …

The post Invisible Index In Oracle 11g appeared first on Tech Doubts.

]]> 610 Active Session History In Oracle https://www.techdoubts.com/active-session-history-in-oracle/ Sat, 17 Sep 2011 16:35:12 +0000 http://techdoubts.com/?p=587 Active Session History (ASH) is a quick solution to do performance analysis of the Oracle session based on time, module, action or SQL_ID and also to identify transient performance problem that lasts for few minutes. Each active session running in the database will be sampled (divided into smaller units) and the …

The post Active Session History In Oracle appeared first on Tech Doubts.

]]> 587 How To Generate ASH Report https://www.techdoubts.com/how-to-generate-ash-report/ https://www.techdoubts.com/how-to-generate-ash-report/#comments Sat, 17 Sep 2011 16:32:16 +0000 http://techdoubts.com/?p=591 Active Session History (ASH) is a very important feature to analyze sessions in Oracle to troubleshoot transient problems that last for just few minutes. ASH reports gives the details needed to analyze the sessions. Below example shows how to generate ASH(Active Session History) reports from SQLPLUS. The same can be done using …

The post How To Generate ASH Report appeared first on Tech Doubts.

]]> https://www.techdoubts.com/how-to-generate-ash-report/feed/ 1 591 How To Schedule A Job In Oracle https://www.techdoubts.com/how-to-schedule-a-job-in-oracle/ Wed, 14 Sep 2011 12:37:09 +0000 http://techdoubts.com/?p=564 DBMS_JOB package is used to manage and schedule job in Oracle. Given below is a simple example with detailed steps which illustrates DBMS_JOB. The requirement is to insert employee details into the table EMPLOYEES. When the job is invoked the details would be inserted. The details needs to passed as …

The post How To Schedule A Job In Oracle appeared first on Tech Doubts.

]]> 564 Different Types Of Joins In Oracle https://www.techdoubts.com/different-types-of-joins-in-oracle/ https://www.techdoubts.com/different-types-of-joins-in-oracle/#comments Wed, 14 Sep 2011 12:36:16 +0000 http://techdoubts.com/?p=566 Join is a method used to combine two or more tables,views or materialized views based on a common condition. There is wide variety of classification. Below given in one such classification. Different types of Joins 1. Cross Join/Cartesian Product 2. Natural Join 3. Inner Join 4. Outer join a.Left Outer …

The post Different Types Of Joins In Oracle appeared first on Tech Doubts.

]]> https://www.techdoubts.com/different-types-of-joins-in-oracle/feed/ 4 566 Auditing By Default In Oracle 11g https://www.techdoubts.com/auditing-by-default-in-oracle-11g/ Wed, 14 Sep 2011 12:35:15 +0000 http://techdoubts.com/?p=572 Among the many enhancements in Oracle 11g, very important one is the default auditing.In Oracle 11g, parameter audit_trail is set to the value DB by default. And many privileges audited by access are enabled by default.See the list below. ALTER ANY PROCEDURE ALTER ANY TABLE ALTER DATABASE ALTER PROFILE AUDIT ROLE …

The post Auditing By Default In Oracle 11g appeared first on Tech Doubts.

]]> 572 Temporary Tablespace – Common Ora Errors https://www.techdoubts.com/temporary-tablespace-common-ora-errors/ Wed, 14 Sep 2011 12:33:43 +0000 http://techdoubts.com/?p=568 Temporary tablepspace is a very dynamic tablespace which gets filled up quickly, due to SQL operations that inludes sorting like CREATE INDEX, ANALYZE, Select DISTINCT, ORDER BY, GROUP BY, UNION, INTERSECT, MINUS. Though this tablespace is not backed up or used for recovery, this is a very important tablespace for …

The post Temporary Tablespace – Common Ora Errors appeared first on Tech Doubts.

]]> 568 Multi-Byte Password Characters In Oracle 11g https://www.techdoubts.com/multi-byte-password-characters-in-oracle-11g/ Wed, 14 Sep 2011 12:31:43 +0000 http://techdoubts.com/?p=560 From Oracle11g onwards, we can include multi-byte characters like $, _, and #  in Oracle passwords without quoting. In earlier versions, we may have to use quotes while using these special characters in passwords, else it may throw error saying password is wrong. This feature needs to tested properly before …

The post Multi-Byte Password Characters In Oracle 11g appeared first on Tech Doubts.

]]> 560 Automatic SQL Tuning In Oracle Database 11g https://www.techdoubts.com/automatic-sql-tuning-in-oracle-database-11g/ Wed, 14 Sep 2011 12:29:56 +0000 http://techdoubts.com/?p=558 In Oracle 11g, we have SQL Tuning Advisor which is run automatically against high resource consuming SQL statements during the maintenance windows. Lets see how to do this. 1. DBMS_AUTO_TASK_ADMIN package is used to enable and disable this Automatic SQL Tuning Advisor. To Enable the advisor SQL> BEGIN DBMS_AUTO_TASK_ADMIN.enable( client_name …

The post Automatic SQL Tuning In Oracle Database 11g appeared first on Tech Doubts.

]]> 558 Password Case Sensitivity In Oracle 11g https://www.techdoubts.com/password-case-sensitivity-in-oracle-11g/ Wed, 14 Sep 2011 12:28:13 +0000 http://techdoubts.com/?p=553 Password case sensitivity is a new Oracle 11g feature. This is an additional password complexity as well as a security feature. sec_case_sensitive_login is an initialization parameter which controls password case sensitivity. This is a dynamic parameter. Default value is TRUE ie, once your 11g upgrade from previous versions is complete …

The post Password Case Sensitivity In Oracle 11g appeared first on Tech Doubts.

]]> 553 ORA-29280: invalid directory path https://www.techdoubts.com/ora-29280-invalid-directory-path/ Wed, 14 Sep 2011 12:25:36 +0000 http://techdoubts.com/?p=548 ORA-29280: invalid directory path This is one common error we get while running PL/SQL procedures. Primary cause of this error is that parameter UTL_FILE_DIR is not specified in initialization file. UTL_FILE_DIR is an initialization parameter where one or more directories are set that Oracle uses for PL/SQL file I/O. This is …

The post ORA-29280: invalid directory path appeared first on Tech Doubts.

]]> 548 How To Drop A Datafile In Oracle? https://www.techdoubts.com/how-to-drop-a-datafile-in-oracle/ Thu, 08 Sep 2011 08:45:02 +0000 http://techdoubts.com/?p=544 There can be situations where we have mistakenly added datafiles to a tablespace and need to remove it. Prior to Oracle 10gR2, Oracle did not support dropping of datafiles. The only workaround was to take a export backup of the existing objects in the tablespace. Re-create the tablespace and import …

The post How To Drop A Datafile In Oracle? appeared first on Tech Doubts.

]]> 544 How To generate Automatic Database Diagnostic Monitor (ADDM) Report In Oracle? https://www.techdoubts.com/how-to-generate-addm-report-in-oracle/ Thu, 08 Sep 2011 08:39:59 +0000 http://techdoubts.com/?p=539 The ADDM accepts AWR snapshots as  input and provides various findings and recommentations to resolve the performance bottlenecks.   ADDM reports include : Top SQL Activities CPU bottlenecks Undersized memory allocations Excessive parsing I/O usage Concurrency issues Object contention RAC and application issues ADDM report can be generated by running addmrpt.sql …

The post How To generate Automatic Database Diagnostic Monitor (ADDM) Report In Oracle? appeared first on Tech Doubts.

]]> 539 ORA-28221: REPLACE not specified https://www.techdoubts.com/ora-28221-replace-not-specified/ Thu, 08 Sep 2011 08:27:40 +0000 http://techdoubts.com/?p=531 Cause : ORA-28221 error occurs when an user tries to reset his own password without specifying the REPLACE keyword, provided the user does not have ALTER USER privilege and the user is having a profile with password verify function. Solution : Provide the current password along with the REPLACE clause …

The post ORA-28221: REPLACE not specified appeared first on Tech Doubts.

]]> 531 How To View Hidden Parameters In Oracle? https://www.techdoubts.com/how-to-view-hidden-parameters-in-oracle/ Thu, 08 Sep 2011 08:13:21 +0000 http://techdoubts.com/?p=522 Oracle initialization parameters which starts with an underscore (_) are called as hidden parameters. These are undocumented parameters. We cannot find them in V$PARAMETER or by using SHOW PARAMETER command. Manipulating these parameters will alter Oracle’s internal mechanisms. It is advised NOT to modify these parameters without the consent of …

The post How To View Hidden Parameters In Oracle? appeared first on Tech Doubts.

]]> 522 How To Track Password Changed Dates Of An Oracle User? https://www.techdoubts.com/how-to-track-password-changed-dates-of-an-oracle-user/ Mon, 05 Sep 2011 12:19:59 +0000 http://techdoubts.com/?p=518 Password change history of an Oracle user can be checked from the SYS tables USER$ and USER_HISTORY$.  SQL> Select name,password_date ” Password Changed date” from sys.user$ A ,sys.user_history$ B where A.user# = B.user# and A.name=’TEST_USER’ order by password_date; NAME                     Password Changed date ——————– ————————– TEST_USER                Jun 19 2010 09:06:27 TEST_USER                …

The post How To Track Password Changed Dates Of An Oracle User? appeared first on Tech Doubts.

]]> 518 How To Rename A Tablespace In Oracle? https://www.techdoubts.com/how-to-rename-a-tablespace-in-oracle/ Fri, 02 Sep 2011 14:48:33 +0000 http://techdoubts.com/?p=512 Prior to Oracle 10g, it was a tedious task to rename a tablespace. We had to follow a series of steps. Lets say, we need to rename tablespace TEST_1 to TEST_2 1. Create a tablespace TEST_2 2. Export all the objects from TEST_1 tablespace 3. Import the data to TEST_2 …

The post How To Rename A Tablespace In Oracle? appeared first on Tech Doubts.

]]> 512 Default Password in Oracle 11g https://www.techdoubts.com/default-password-in-oracle-11g/ Wed, 31 Aug 2011 10:03:03 +0000 http://techdoubts.com/?p=500 We know that Oracle consists of many default user accounts like SCOTT, HR etc. Till Oracle 10g, these accounts had a default password, and we had no option to find if the current password used were default ones or not.This caused a security risk if the accounts were not locked. …

The post Default Password in Oracle 11g appeared first on Tech Doubts.

]]> 500 Password Complexity in Oracle 11g https://www.techdoubts.com/password-complexity-in-oracle-11g/ Wed, 31 Aug 2011 09:57:04 +0000 http://techdoubts.com/?p=496 The default password verification function provided by the Oracle which is kept in location $ORACLE_HOME/rdbms/admin/utlpwdmg.sql. If we have a newly upgraded 11g database, this script is not loaded automatically. Therefore, we have run this script manually for it to take effect. Till then the verify function of the previous version would be in …

The post Password Complexity in Oracle 11g appeared first on Tech Doubts.

]]> 496 Default Profile In Oracle 11g https://www.techdoubts.com/default-profile-in-oracle-11g/ Wed, 31 Aug 2011 09:53:17 +0000 http://techdoubts.com/?p=485 Most of our Oracle applications are being upgraded to 11g version nowadays. At this time it is important to discuss some features in the Oracle 11g Default Profile: We know that any user created in a database needs to be assigned to a profile. If not, the user will be assigned …

The post Default Profile In Oracle 11g appeared first on Tech Doubts.

]]> 485 Index Range Scan And Fast Full Index Scan https://www.techdoubts.com/index-range-scan-and-fast-full-index-scan/ Wed, 31 Aug 2011 09:49:43 +0000 http://techdoubts.com/?p=489 INDEX RANGE SCAN An index range scan is used to access a selected range of data. In this case not only the index but also the data from actual table is also fetched. Here, Oracle traverses through the branches of the index tree to reach the leaf block where it …

The post Index Range Scan And Fast Full Index Scan appeared first on Tech Doubts.

]]> 489 How To Export Oracle Tables Specifying Conditions? https://www.techdoubts.com/how-to-export-oracle-tables-specifying-conditions/ Mon, 29 Aug 2011 15:10:46 +0000 http://techdoubts.com/?p=479 The Query parameter of exp/expdp utility allows to export the subset of a table based on any condition. The value for the parameter should be specified as a string with a WHERE clause. Consider that we have to export data from employee table where salary > 5000. exp scott/tiger TABLES=employee …

The post How To Export Oracle Tables Specifying Conditions? appeared first on Tech Doubts.

]]> 479 How To Rename A User/Schema In Oracle? https://www.techdoubts.com/how-to-rename-a-user-schema-in-oracle/ Mon, 29 Aug 2011 07:28:56 +0000 http://techdoubts.com/?p=473 We don’t have a single command in Oracle by which we can alter the name of a user. But,  there is a workaround which serve the purpose. Say, we have to rename user A to B. Take an export of user A. Create the user B. Import the dump file taken in step …

The post How To Rename A User/Schema In Oracle? appeared first on Tech Doubts.

]]> 473 Install or Update Multiple Softwares At Once – Ninite https://www.techdoubts.com/install-or-update-multiple-softwares-at-once/ Mon, 29 Aug 2011 06:20:52 +0000 http://techdoubts.com/?p=467 Ninite- A Useful website to install or update multiple softwares at once. With Ninite Updater it’s one step to download and install all your updates in the background at once. Check : https://ninite.com/

The post Install or Update Multiple Softwares At Once – Ninite appeared first on Tech Doubts.

]]> 467 Useful UNIX Commands For Oracle DBAs https://www.techdoubts.com/useful-unix-commands-for-oracle-dbas/ Sun, 28 Aug 2011 17:13:31 +0000 http://techdoubts.com/?p=456 Basic knowledge in UNIX is very essential for any DBA. Given below are some few useful UNIX commands for Oracle DBAs in their daily work. 1.  To Cleanup trace files more than n days old $ find $DBA/$ORACLE_SID/bdump/*.trc -mtime +n -exec rm {} \; 2. To get the value of all environment variables. …

The post Useful UNIX Commands For Oracle DBAs appeared first on Tech Doubts.

]]> 456 How To Resolve Database Blocking In Oracle ? https://www.techdoubts.com/how-to-resolve-database-blocking-in-oracle/ Sun, 28 Aug 2011 17:04:19 +0000 http://techdoubts.com/?p=448 Database blocking is a situation where the statement run by one user locks a record or set of records and another statement run by the same user or different user requires a conflicting lock type on the record or records, locked by the first user. Database blocking issue is a …

The post How To Resolve Database Blocking In Oracle ? appeared first on Tech Doubts.

]]> 448 Why V$PARAMETER And V$SPPARAMETER Gives Different Parameter Values? https://www.techdoubts.com/why-vparameter-and-vspparameter-gives-different-parameter-values/ Sun, 28 Aug 2011 16:56:40 +0000 http://techdoubts.com/?p=444 We may sometimes face a situation where we get two different values for the same initialization  parameter from the views v$PARAMETER and V$SPPARAMETER. Lets see an example here: The parameter processes gives two different values 150 and 200 when queried from v$PARAMETER and V$SPPARAMETER respectively. SQL> show parameter processes NAME                    …

The post Why V$PARAMETER And V$SPPARAMETER Gives Different Parameter Values? appeared first on Tech Doubts.

]]> 444 Can We Read Export Dump File Without Actually Importing It ? https://www.techdoubts.com/can-we-read-export-dump-file-without-actually-importing-it/ Sun, 28 Aug 2011 12:30:31 +0000 http://techdoubts.com/?p=428 Most of the times, we would have the export dump file in hand. And would be required to import it to another database or schema. But before actually importing, we would like to just have a look at the contents of the dump file, to make sure we are importing …

The post Can We Read Export Dump File Without Actually Importing It ? appeared first on Tech Doubts.

]]> 428 Managing UNDO Tablespace – Optimal UNDO SIZE And UNDO_RETENTION https://www.techdoubts.com/managing-undo-tablespace-optimal-undo-size-and-undo-retention/ Sun, 28 Aug 2011 11:47:44 +0000 http://techdoubts.com/?p=419 Managing UNDO Tablespace by properly setting the size of UNDO tablespace and UNDO retention is a very important DBA task. To avoid the head ache of doing this manually, AUTOMATIC UNDO MANAGEMENT can be turned on, so that Oracle itself would manage this task. To do this, initialization parameter UNDO_MANAGEMENT …

The post Managing UNDO Tablespace – Optimal UNDO SIZE And UNDO_RETENTION appeared first on Tech Doubts.

]]> 419 What Is Row Migration And Row Chaining? https://www.techdoubts.com/what-is-row-migration-and-row-chaining/ Sun, 28 Aug 2011 10:54:51 +0000 http://techdoubts.com/?p=387 Row migration and row chaining are two known problems in Oracle that can degrade the database performance. Row migration refers to the scenario where an entire row moves from one block to another, as it becomes unfit to the present block. Usually UPDATE statements results in row migration. Let’s see …

The post What Is Row Migration And Row Chaining? appeared first on Tech Doubts.

]]> 387 How To Compare Two AWR Reports? https://www.techdoubts.com/how-to-compare-two-awr-reports/ Sun, 28 Aug 2011 10:50:23 +0000 http://techdoubts.com/?p=362 Often we generate AWR reports for performance tuning our system. Mostly we have a baseline AWR when the system was performing fine and an AWR when the system was showing degraded performance. Comparing these two reports would give us an idea of where the problem could be and we can …

The post How To Compare Two AWR Reports? appeared first on Tech Doubts.

]]> 362 What Is DUAL Table In Oracle? https://www.techdoubts.com/what-is-dual-table-in-oracle/ Sun, 28 Aug 2011 06:18:10 +0000 http://techdoubts.com/?p=369 Most of us might have at least once queried the DUAL table of our Oracle database. But, what is this DUAL table? Who owns it? What privilege is required to select from dual table?  Well . This article explains the concept of dual table. Dual is a one row table …

The post What Is DUAL Table In Oracle? appeared first on Tech Doubts.

]]> 369 Routine Health Check Up of Your Oracle Database – What to Check? https://www.techdoubts.com/routine-health-check-up-of-your-oracle-database-what-to-check/ https://www.techdoubts.com/routine-health-check-up-of-your-oracle-database-what-to-check/#comments Tue, 23 Aug 2011 13:17:13 +0000 http://techdoubts.com/?p=335 Being the DOCTOR of DATABASES, doing a routine checkup on your databases is mandatory. Here are a few steps and associated queries to check the health of your database. OS Level Checks 1. If the instance and associated background processes are up and running. $ps -ef |grep <instance_name> 2. If …

The post Routine Health Check Up of Your Oracle Database – What to Check? appeared first on Tech Doubts.

]]> https://www.techdoubts.com/routine-health-check-up-of-your-oracle-database-what-to-check/feed/ 2 335 How To Enable Automatic Memory Management (AMM) in Oracle 11g? https://www.techdoubts.com/how-to-enable-automatic-memory-management-in-oracle11g/ Mon, 22 Aug 2011 07:23:16 +0000 http://techdoubts.com/?p=331 Oracle has taken a step ahead in making the memory management simple by introducing Automatic Memory Management (AMM) in 11g , by which Oracle dynamically manages both SGA and PGA. MEMORY_TARGET and MEMORY_MAX_TARGET are the two initialization parameters related to AMM. MEMORY_TARGET refers to the shared memory available to Oracle …

The post How To Enable Automatic Memory Management (AMM) in Oracle 11g? appeared first on Tech Doubts.

]]> 331 Not Able To Truncate Table – Why? What to do then? https://www.techdoubts.com/not-able-to-truncate-table-why-what-to-do-then/ Mon, 22 Aug 2011 07:12:13 +0000 http://techdoubts.com/?p=326 It is a strange fact that Oracle will not permit a user to truncate a table even after having “ Delete any table “ privilege. The privilege required to truncate a table is Drop any table or Drop on that particular table . With respect to the security perspective it …

The post Not Able To Truncate Table – Why? What to do then? appeared first on Tech Doubts.

]]> 326 How To Move OR Rename An Oracle Datafile? https://www.techdoubts.com/how-to-move-or-rename-an-oracle-datafile/ Sun, 21 Aug 2011 15:45:14 +0000 http://techdoubts.com/?p=321 How to move a datafile from one location to another in Oracle: At times , to fix the space crunch in a filesystem or to follow the filesystem standards or proper naming conventions , a DBA might have to move/rename an oracle datafile. The datafile movement can be performed without …

The post How To Move OR Rename An Oracle Datafile? appeared first on Tech Doubts.

]]> 321 15 Basic SQL Queries For A Beginner DBA https://www.techdoubts.com/15-basic-sql-queries-for-a-beginner-dba/ Fri, 19 Aug 2011 12:05:18 +0000 http://techdoubts.com/?p=312 SQL Queries for Dummies! Yes – Some of the basic Oracle queries/commands which might turn out extremely helpful to the beginners of Oracle database. 1. To check the name of the database: SQL> select name from v$database; 2. To check the version of a database: SQL> select * from v$version; 3. …

The post 15 Basic SQL Queries For A Beginner DBA appeared first on Tech Doubts.

]]> 312 How To Make a Table READ ONLY in Oracle 11g? https://www.techdoubts.com/how-to-make-a-table-read-only-in-oracle-11g/ Fri, 19 Aug 2011 11:52:18 +0000 http://techdoubts.com/?p=307 Read Only tables in Oracle 11g: Read-only table is a  good enhancement introduced in Oracle 11g , using which we can safeguard the tables from DML operations. This new feature helps to switch a table to READ ONLY mode by executing a single ALTER TABLE command. SQL > Alter table table_name …

The post How To Make a Table READ ONLY in Oracle 11g? appeared first on Tech Doubts.

]]> 307 Oracle Database Performance Tuning – How to Export/Import Schema Statistics? https://www.techdoubts.com/oracle-database-performance-tuning-how-to-export-or-import-schema-statistics/ Fri, 19 Aug 2011 11:42:55 +0000 http://techdoubts.com/?p=301 Export/Import of schema statistics in Oracle: As database administrators, most of us might have encountered a scenario where the performance of sql queries shows a sudden degradation in our database. But there are no hard and fast rules about how to deal with performance issues. Mostly, it is through trial …

The post Oracle Database Performance Tuning – How to Export/Import Schema Statistics? appeared first on Tech Doubts.

]]> 301 How To Drop A Table Permanently From Oracle Database? https://www.techdoubts.com/how-to-drop-a-table-permanently-from-oracle-database/ Mon, 15 Aug 2011 15:00:28 +0000 http://techdoubts.com/?p=294 Dropping table permanently: SQL> drop table test_tab purge; Table dropped. SQL> select OBJECT_NAME, ORIGINAL_NAME, DROPTIME from recyclebin; no rows selected. Purging of table from recycelbin: SQL> drop table test_tab; Table dropped. SQL> select OBJECT_NAME, ORIGINAL_NAME, DROPTIME from recyclebin; OBJECT_NAME           ORIGINAL_NAME           DROPTIME —————————— —————-     —— BIN$dD1ZsEvnDTHgRAADujKrxQ==$0 TEST_TAB 2010-09-23:12:40:58 SQL> purge table …

The post How To Drop A Table Permanently From Oracle Database? appeared first on Tech Doubts.

]]> 294 Flashback Table in Oracle Database – Query Recyclebin https://www.techdoubts.com/flashback-table-in-oracle-database-query-recyclebin/ Mon, 15 Aug 2011 14:54:23 +0000 http://techdoubts.com/?p=289 What happens when we drop a table in Oracle 10g? Whenever we drop a table in Oracle 10g, internally Oracle will rename the table and all the associated objects like index, constraints etc with a prefix of “BIN$” and stores in the recyclebin. We  can either read the data directly …

The post Flashback Table in Oracle Database – Query Recyclebin appeared first on Tech Doubts.

]]> 289 Restoring a dropped Table in Oracle – The Recyclebin https://www.techdoubts.com/restoring-a-dropped-table-in-oracle-the-recyclebin/ Sun, 14 Aug 2011 16:21:18 +0000 http://techdoubts.com/?p=280 Can we restore the data of a dropped table in Oracle , even if we don’t have a valid backup? If your Oracle database version is 10g or above , then the answer is definitely “YES”. This became possible with the introduction of a new feature in Oracle 10g – …

The post Restoring a dropped Table in Oracle – The Recyclebin appeared first on Tech Doubts.

]]> 280 How To Run ADDM in an Oracle Database? https://www.techdoubts.com/how-to-run-addm-in-an-oracle-database/ Sun, 07 Aug 2011 12:33:03 +0000 http://techdoubts.com/?p=258 ADDM or Automatic Database Diagnostic Monitor is a tool which helps in automatic database performance monitoring. Run the below script to run ADDM. @?/rdbms/admin/addmrpt.sql The following is a sample  output you get if you Run the ADDM  when there is no significant database activity. DETAILED ADDM REPORT FOR TASK ‘TASK_416’ …

The post How To Run ADDM in an Oracle Database? appeared first on Tech Doubts.

]]> 258