-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
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
|
A lot of people actually ask me why sql*plus doesn’t have a help feature like man in UNIX. Actually it… READ MORE
|
There are some cool SQL*PLUS command to help speed up your typing. Today I am showing the change and append… READ MORE
Most of the Oracle production database require you to enable ARCHIVELOG mode for your database. When you enable this mode… READ MORE
Snapshot and FlexClone Several of the capabilities of NetApp storage contribute to the ease of Oracle data management in NFS… READ MORE
“Control what I can control”
~ Alex Lima
Alex Lima 