Featured
The Latest
-
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
-
How to generate execution plan created from AWR snapshot?
Using $ORACLE_HOME/rdbms/admin/awrsqrpt.sql one can generate execution plan from AWR by passing start snap id, end snap id and SQL ID.… READ MORE
-
How to reboot CentOS in single user mode to reset root password?
If you have forgotten the root password and you need to reset it on CentOS, one can reset it by… READ MORE
-
Example of bulk collect and performance using different values of limit
Sample code that shows using BULK COLLECT and performance of using different values for LIMIT. declare cursor l_cur is select… READ MORE
-
|
How to set vim/gvim on windows?
Using the following steps one can setup vim/gvim to run on windows. 1) Add the following new variable VIM on… READ MORE
-
|
Example of using tracefile_identifier
Using “tracefile_identifier” Oracle will add that to the name of the user’s trace filename so the file can easily be… READ MORE
-
How to add a comment when changing a parameter?
In “ALTER SYSTEM” one can include a comment which gets recorded in the spfile and also in v$parameter as shown… READ MORE
-
|
How to use dbms_xplan to display execution plan?
Using dbms_xplan.display_cursor one can see the execution plan of a SQL statement. The function takes following 3 parameters. SQL_ID (VARCHAR2)… READ MORE
-
How to add a new not null column in a table without providing a default value?
The following shows how to add in a table a new column that is NOT NULL when a table already… READ MORE
-
How to check if auditing is turned on and privilege auditing is turned on?
If AUDIT_TRAIL is not set to NONE then using the following SQL one can find the statements that have auditing… READ MORE
-
How to find and enable/disable parallel DML, DDL, Query?
In the view v$session there are columns that can tell if parallel DDL, DML, Query is enabled/disabled. PDML_ENABLED and PDML_STATUS… READ MORE
-
|
How to use PRAGMA EXCEPTION_INIT?
PRAGMA EXCEPTION_INIT – allows one to map ORA- error and it can be raised in PL/SQL code. The SQL Error… READ MORE
-
How to schedule a snap for STATSPACK?
One can automate taking of snapshots of STATSPACK by executing DBMS_JOB or by scheduling it through crontab. Schedule automatic STATSPACK… 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 