Featured
The Latest
-
French accents character when using SQL*Plus
For SQL*Plus to process french accents characters when using SQL*Plus, you would need to set NLS_LANG On Windows set NLS_LANG=.AL32UTF8… READ MORE
-
How to migrate from single instance to RAC 10gR2
Move from single instance to RAC 1- Install CRS 2- Install new RDBMS binaries rac enable 3- Make sure there… READ MORE
-
How to fix Online redo log corruption?
Today, due to a network issue the host (Solaries) lost contact with the NetApp filer and it corrupted some datafiles… READ MORE
-
How to extract the DB LINKS DDL with the password
Here is a simple script to extract the DB Links DDL with the encripted password. SET LONG 9000 — to… READ MORE
-
|
Creation SQL script for DB Link within a database
The following can be used to create a script for DB Links with work on 8i/9i and will contain the… READ MORE
-
How full is the current redo log file?
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
-
|
How to move datafiles in temp tablespace?
One can’t move the temp tablespace during mount stage like other datafiles using “ALTER DATABASE RENAME FILE..” so a workaround… READ MORE
-
|
Enable trace in a running session from PL/SQL or SQL*Plus
Using Oracle SID and SERIAL# can turn trace on/off a Oracle session that has already started. The values of SID… READ MORE
-
TEMP space usage overall and by session
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
-
Extract all tablespaces DDL
Nice way to extract the DDL for all tablepaces.. This also can be used for other objects as well. SQL>set… READ MORE
-
Clone a database with RMAN
Duplicating a Database using RMAN – (UNIX / Linux) PMMPRD to PMMQA1 Pre-requisites A valid full database backup of the… READ MORE
-
How to create a NetApp FlexClone RAC Database
In the past I used these procedures to create a FlexClone Oracle RAC database. Mainly for refreshing a data-warehouse from… READ MORE
-
|
How to resolve user locking problems
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
-
Enabling Flashback Database
The following are the requirements for enabling Flashback Database: – Your database must be running in ARCHIVELOG mode, because archived… READ MORE
-
Change from Rollback Segments 8i to UNDO in 9i/10g
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
-
DBA_JOBS marked broken after 16 tries
Recently I had issues with materialized view replication and the job was marked broken after 16 tries. After the replication… READ MORE
-
Script to move Oracle Datafiles
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
-
|
Grant Full Access to all tables and views within a Schema
set serveroutput on set serveroutput on size 1000000 DECLARE vcount1 number := 0; vcount2 number := 0; v_tablename varchar2(32); v_viewname… READ MORE
-
|
Check Oracle Password for Expiration
This simple script will check if a user password is expiring in the next 120 days. set pagesize 500 set… READ MORE
-
Killing an Oracle thread on Windows
On Windows for each instance all oracle sessions are thread based and are part of one Oracle process (oracle.exe), so… READ MORE
-
List users who are using permanent tablespace instead of temporary tablespace
— If sorting is performed on permanent tablespace it can affect performance because it’s in nologging mode, reduces backup and… READ MORE
Recent posts
Quote of the week
“Control what I can control”
~ Alex Lima
Categories
- 18c
- 19c
- AIX
- Archivelog
- Auditing
- AWR
- Backup
- Backup & Recovery
- Batch
- Big Data
- Built-in stored procedures
- Connections
- Control file
- Cursor
- Database
- Dataguard
- Dataguard
- Datatypes
- Date
- Docker
- events
- exp
- Export
- Flashback
- General DBA
- Globalization
- GoldenGate
- Grant
- Initialization
- install
- Internal
- JDBC
- Jobs
- Leadership
- Linux
- Listener
- LOB
- Lock
- Log Miner
- mac
- Microservices
- Monitor
- Motocycling
- MySQL
- NetApp for Oracle
- networking
- OCI
- OEM – Grid Control
- OpenWorld 2010
- ORA Errors
- Oracle RAC
- oradebug
- OS
- osql
- Parameters
- partition
- Password
- performance
- PL/SQL
- postgres
- Power Shell
- Primavera
- Product Management
- Profiler
- Project Management
- Python
- REST API
- RMAN
- role
- Scheduler
- Scripts
- Security
- sga
- Shared Pool
- Shell
- snapshot
- SQL – DDL
- SQL Developer
- SQL Server
- SQL*Plus
- SQLcl
- startup
- Statistics
- Statspack
- Table
- tablespace
- trace
- Transaction
- Tuning
- Tuning
- Undo
- Unix
- Upgrade
- vi
- windows
Alex Lima 