Featured
The Latest
-
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
-
How to stop a job scheduled in DBMS_SCHEDULER?
Using sys.dbms_scheduler.STOP_JOB one can stop scheduled job. SQL> exec sys.dbms_scheduler.STOP_JOB(job_name=>'SYS.ORA$AT_OS_OPT_SY_12856', force=>true); Output: PL/SQL procedure successfully completed. If it can’t find… READ MORE
-
dba_jobs and interval
Few examples of some scenarios of setting intervals for dba_jobs. Note: Updating the interval will not update the NEXT_DATE run… READ MORE
-
Using sys.dbms_iob one can manage jobs in dba_jobs.
DBMS_JOB allows one to create/manage jobs under user who has logged but using sys.dbms_ijob one can manage jobs all jobs… READ MORE
-
How to tell/find if the instance is Primary/Standby?
By querying v$database one can tell if the host is primary or standby For primary testdb> select database_role from v$database;… READ MORE
-
Dataguard ORA-16817
If you have an issue where the server where standby resides had to be restarted and when you try to… READ MORE
-
How to suspend all jobs from executing in dba_jobs?
By setting the value of 0 to the parameter “job_queue_processes” one can suspend all jobs from executing in DBA_JOBS. The… READ MORE
-
How to see the jobs currently being executed?
Using dba_jobs_running it will show the all jobs executing. SQL> select djr.sid, djr.job, djr.failures, djr.this_date, djr.this_sec, dj.what from dba_jobs_running djr,… READ MORE
Recent posts
Quote of the week
“Control what I can control”
~ Alex Lima
Categories
- 18c
- 19c
- AIX
- Archivelog
- Auditing
- 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
- kubernetes
- Leadership
- Linux
- Listener
- LOB
- Lock
- Log Miner
- mac
- Microservices
- Monitor
- Motocycling
- MySQL
- NetApp for Oracle
- networking
- OCI
- OEM – Grid Control
- Open Shift
- 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
