Featured
The Latest
-
|
Install sqlplus instant client on macOS
Download Instant Client for macOS http://www.oracle.com/technetwork/topics/intel-macsoft-096467.html#ic_osx_inst This file contains hidden or bidirectional Unicode text that may be interpreted or compiled… READ MORE
-
Install Chrome on Oracle Linux 7 (REHL7)
Today I had it with Firefox on Linux and wanted to install Chrome, here are the steps I followed and… READ MORE
-
GoldenGate numeric data validation with REGEXP
Here is a simple validation mapping to verify if the value in the trail file is numeric. I had to… READ MORE
-
Install and Configure Oracle GoldenGate 12.3 Microservices Architecture
The objective of this document is to demonstrate how to install and configure the new Oracle 12.3 GoldenGate Microservices Architecture.… READ MORE
-
How to avoid resetting expired passwords in Oracle
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To… READ MORE
-
Replicat abending with database error 1403
Replicat abending with database error 1403() during the initial startup during a compressed update. This error can be seen very… READ MORE
-
ORA-00257: archiver error – FRA Clean Up emergency
A quick emergency FRA clean up when archived logs are full. This file contains hidden or bidirectional Unicode text… READ MORE
-
Extract Index DDL from expdp
I recently wanted to drop the indexes during a load and recreate after. There are several ways to do that,… READ MORE
-
SQLcl to view DDL
Today I ran into a scenario where I need to check if a table had an UNIQUE index. Instead of writing… READ MORE
-
Oracle Database 12.2 – Lifetime Support Policy updated
The Oracle Lifetime Support Policy brochure for tech products has… READ MORE
-
Purge DDL tables in GoldenGate for multiple instances
When setting up a DDL replication in Integrated Capture there are couple tables that gets populated on a regular basis,… READ MORE
-
|
How to disable parallel query at a session level?
One can disable parallel query at a session level by running the following ALTER SESSION statement. You can use this… READ MORE
-
Oracle Default Users
‘ANONYMOUS’ — HTTP access to XDB ‘APPQOSSYS’ — QOS system user ‘AUDSYS’ — audit super user ‘BI’ — Business Intelligence… READ MORE
-
Script to add trandata for GoldenGate
Here is a simple script to check which tables are missing trandata and generate the GG (so call DDL) to… READ MORE
-
GGSCI Commands
Commands ggsci> HELP [command] [object] ggsci> help GGSCI Command Summary: Object: Command: SUBDIRS … READ MORE
-
How to change properties/attributes of partition table?
At times one would want to change properties/attributes of a table so new partitions are affected by change not the… READ MORE
-
|
How to get dump or list parameters set at session level?
Using oradebug one can get a dump of sessions parameters that are modified at session level, like optimization parameters. SQL>… READ MORE
-
How to see current utilization of processes/sessions and max utilization?
Using the following SQL one can find the current number of processes and sessions connected and also max utilization so… READ MORE
-
Example of using sql profile to use switch to a different execution plan
Below are the 2 SQL statements, the first one uses the index AAA_IDX and then second one does a full… READ MORE
-
Example shows how “DISABLE TABLE LOCK” works
Following example shows what happens when locks are disabled on the TABLE. -- disable lock on a table SQL> alter… READ MORE
-
How to trace a running process?
Using strace one can trace the system calls being executed by a running process. To stop the strace press control-C… READ MORE
-
ORA-00353: during startup of instance from archiver process
When starting one of the databases we received the ORA-00353 error. It indicates that archiver process couldn’t archive one of… READ MORE
-
How to see the oldest flashback available?
Using the following query one can see the flashback data available. SELECT to_char(sysdate,'YYYY-MM-DD HH24:MI') current_time, to_char(f.oldest_flashback_time, 'YYYY-MM-DD HH24:MI') OLDEST_FLASHBACK_TIME, (sysdate… 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 