-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
Today, due to a network issue the host (Solaries) lost contact with the NetApp filer and it corrupted some datafiles… READ MORE
Here is a simple script to extract the DB Links DDL with the encripted password. SET LONG 9000 — to… READ MORE
|
The following can be used to create a script for DB Links with work on 8i/9i and will contain the… READ MORE
SQL> SELECT le.leseq “Current log sequence No”, 100*cp.cpodr_bno/le.lesiz “Percent Full”, cp.cpodr_bno “Current Block No”, le.lesiz “Size of Log in Blocks”… READ MORE
|
One can’t move the temp tablespace during mount stage like other datafiles using “ALTER DATABASE RENAME FILE..” so a workaround… READ MORE
|
Using Oracle SID and SERIAL# can turn trace on/off a Oracle session that has already started. The values of SID… READ MORE
Get current total TEMP tablespace currently allocated, used and free: SELECT A.tablespace_name tablespace, D.mb_total, SUM (A.used_blocks * D.block_size) / 1024… READ MORE
Nice way to extract the DDL for all tablepaces.. This also can be used for other objects as well. SQL>set… READ MORE
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
“Control what I can control”
~ Alex Lima
Alex Lima 