-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
Duplicating a Database using RMAN – (UNIX / Linux) PMMPRD to PMMQA1 Pre-requisites A valid full database backup of the… READ MORE
In the past I used these procedures to create a FlexClone Oracle RAC database. Mainly for refreshing a data-warehouse from… READ MORE
|
Method 1: Check and remove session locking other from Database Find the USER locking others Select a.serial#, a.sid, a.username, b.id1,… READ MORE
The following are the requirements for enabling Flashback Database: – Your database must be running in ARCHIVELOG mode, because archived… READ MORE
Created UNDO tablespace CREATE UNDO TABLESPACE undotbs DATAFILE ‘/ora_data_1/GIST/oradata/undotbs_01.dbf’ SIZE 100M REUSE AUTOEXTEND ON; ALTER DATABASE DATAFILE ‘/ora_data_1/GIST/oradata/undotbs_01.dbf’ RESIZE 3000M;… READ MORE
Recently I had issues with materialized view replication and the job was marked broken after 16 tries. After the replication… READ MORE
Here is a nice script if you need to move your datafiles to a new location. SQL>spool rename_datafile.sql set line… READ MORE
|
set serveroutput on set serveroutput on size 1000000 DECLARE vcount1 number := 0; vcount2 number := 0; v_tablename varchar2(32); v_viewname… READ MORE
|
This simple script will check if a user password is expiring in the next 120 days. set pagesize 500 set… READ MORE
On Windows for each instance all oracle sessions are thread based and are part of one Oracle process (oracle.exe), so… READ MORE
— If sorting is performed on permanent tablespace it can affect performance because it’s in nologging mode, reduces backup and… READ MORE
|
— Print # of archive logs for yesterday by the hour — can be used to determine to schedule archive… READ MORE
A few years ago I was introduced to the NetApp storage technology and it’s backup, clone, DR capabilities and etc.… READ MORE
|
We have faced a situation where replication with materialized view needs to be checked before the shutdown outage between source… READ MORE
|
Sometimes you want to check for datafiles with the same name in the database, maybe you are new to the… READ MORE
“Control what I can control”
~ Alex Lima
Alex Lima 