Managing Redo Logfiles in Oracle database 11gR2 Brief about the Redo logfiles in an Oracle databases it should contain atleast 2 redo logfile group as mandatory & Oracle writes every statement expect the select statement, Example – update etc, The Oracle writes to the datafile in case if there is power failure or any system Read More

Creation of dblink from Oracle to SQL Server Step by step procedure to create a database link from Oracle Database 11g to SQL Server. Database Version: sys@testdb> select INSTANCE_NAME, VERSION from v$instance; INSTANCE_NAME    VERSION —————- ———– testdb          … Read more..

How to move the table from one tablespace to another in Oracle database 11gR2 Fallow the step by step procedure as shown below for testing env: sys@testdb> sho user USER is “SYS” sys@testdb> create user mir identified by mir; User created. sys@testdb> grant connect,resource… Read more..

Resize Redo log files in Oracle database 11gr2  Note: We cannot resize the redo log files in Oracle database as we need to drop them & re-create it, Hence its the only way to resize the redo log files Therefore database require at least 2 groups of redo log files regardless the no of… Read Read More

Set up your own SID name by connecting Sql*Plus in Oracle database Below example will change the Sql*Plus view & display your DB Name (SID) by connecting username instead of word “SQL” By default in all the Oracle database as shown below: SQL> show user; USER is “SYS” You need… Read more..

Monitoring any table operation from your own schema in Oracle database SQL> conn mir/mir123; Connected. SQL> select table_name from user_tables; TABLE_NAME ———— TEST1 SQL> conn sys/sys as sysdba Connected. SQL> alter table mir.test1 monitoring; Table… Read more..