Blog Detail
Recent Posts
Explain Plan in Oracle
Explain plan in Oracle shows execution plan in Oracle which is choose by oracle optimizer for select statements, insert, update and delete statements. Informations we can get from explain plan in Oracle are :Table used for sql statement we want to e...
RMAN setup using catalog database quick guide
To setup RMAN using catalog database follow these steps :1. Create user for catalog database repository in catalogue database-Create tablespace for catalog databasesql>CREATE TABLESPACE RMAN_CATDATAFILE ‘RMAN_CAT’ SIZE 500 M-Create user for catal...
Apache on Solaris 10
Solaris 10 already have Apache in it, in order to use it you just need to start the service. The step to start the Apache server are :1. Go to /usr/apache/bin : #cd /usr/apache/bin2. To start the service : #./apachectl startYou will get error message...
Automate kill inactive user in oracle database
Step by step to automatically kill inactive user in oracle database To see inactive user in oracle database you can use this query “select * from v$session where status=’INACTIVE’ or user=’sys’” 1. Create procedure for killing inactive or...
SQL query for monitoring (next article Oracle Database Monitoring For Beginner)
This article is the sequel of my article Oracle Database Monitoring for Beginner 1. Query for Status MonitoringExamples of Status Monitoring are, check tablespace where it's about to fills up, check segment near their maximum extents.-Tablespace rel...
G stands for GRID (because im curious with 10G)
Grid, the word came from the GRID ELECTRICITY analogy, when we need power electricity to make our tools , server, tv , etc works, we simply connect them to electric outlet without have to know where the electricity came from (without have to know fro...
