If one of the session is having a slow performance while compared to other sessions, then this is because, this session is waiting for some event. First of all we go to tune the Query using EXPLAIN PLAN / EXECUTION PLAN.If we face the same problem even after that, then we approach it with the stepsmentionedin this article.
In Oracle most DBA will encounter database fragmentation and uses schema refresh frequently. In this article we will see how to do a schema refresh during database downtime.
In the DBA career the most prominent issue we will face is the issueYesterday this database Query is running fine. But today we have observed database query response time is very slow compare as yesterday" raised from Development Team / Client.Here are few things you can do, to find the root cause of this issue and solve it.Note: This article is for someone with basic to intermediateexperience and serves as a checklist for finding solution to SQL "Query Slowness" issue.
Every Friday we have taken the full export backup of one our database.This database is used for reporting purpose.Export dump size is around 25 GB. Backup mount point total space is 32 GB. Every weekend I have taken the backup and transfer the export dump (25 GB) to bridge server.In this article we will see how to quickly perform this action using "mknod".
We have deployed new module in our database. In database side we have executed lot of scripts like create, alter, drop, update & delete scripts. Business functionality wise we have faced lot of issues in application side and also database side. So we planned to revert back & restored the Physical backup.We plan to deploy new module in our database. Pro actively we will ready to revert back in case of failure with help of flashback database.(10G feature)Now we see about flashback database.
As we all know that Microsoft has added new "Create a Hotmail alias" or disposable email address to Hotmail yesterday, we will see how to use the feature to cut down spam in our mailbox.
Amazon.com has planned to launch a video streaming service, which will compete Netflix Inc directly, said Financial Times.Amazon is planning to launch its own streaming service with Amazon Prime, a scheme that offers Amazon customers to unlimited free shopping of books and other itmes sold by the online retailer after paying the fee.
If you are not able to solve your Sudoku puzzle, there's a hope now. New photo recognition software for Android Mobiles Goggles can help the problem now and solves the puzzle for you.
IBM on Wednesday released the latest version of its database management system DB2, version 9.7, with new features that include the ability for the database to run applications written for Oracle and other platforms.
2011 will be the year of cloud computing, mobile applications, media tablets, social communications, 3d entertainment, new gadgets. Here is our list of top 25 technologies that are going to rule 2011 and coming years in the world of personal computing. These technologies varies from cameras, wireless communication, cloud computing to mobile phones and Operating Systems.
A collection of important world events occurred during the year 2010 that has to be remembered while we are stepping into 2011 with lot of dreams, expectations and hope.