In this article I will go through how to move Oracle DB control files to new location in the production environment.
Google is likely to launch its own social networking site in May this year. According to the technology blog, the search engine giant will unveil Google Circles as its Google I/O conference in San Francisco, reports the Daily mail.
In the official statement issued by Twitter, it asked third-party developers to stop developing clients for Twitter. This was posted on Twitter’s official developer mailing list by Ryan Sarver.
As a DBA you may face issues like “Large number of sessions are opened while accessing the database through front end and these sessions are not closed properly (Database sessions are hanging). In this article we will see how to resolve such issues.
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.