Author: Edward Ramamoorthy

Kill Session Privileges To Users

Kill Session Privileges To Users

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.

Schema Refresh on Same Database

Schema Refresh on Same Database

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.

Query Slowness

Query Slowness

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.

Using mknod during export

Using mknod during export

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".

Flashback Database

Flashback Database

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.

Amazon planned to launch film streaming service

Amazon planned to launch film streaming service

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.

New Google service solves Sudoku

New Google service solves Sudoku

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's latest DB2 woos Oracle customers

IBM's latest DB2 woos Oracle customers

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.