-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
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
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
Most of the Oracle production database require you to enable ARCHIVELOG mode for your database. When you enable this mode… READ MORE
One of the uses of materialized views is replication. Oracle Materialized Views can be used to replicate a table from… READ MORE
“Control what I can control”
~ Alex Lima
Alex Lima 