Featured
The Latest
-
Truncate and data_object_id explained
Shows a way to find if table was truncated, using object_id, data_object_id one can tell possibly if the table was… READ MORE
-
How to find PSU patches installed in ORACLE_HOME?
Using OPatch with lsinventory and bugs_fixed options one can list the PSU patches installed in ORACLE_HOME Example: localhost:/home/oracle $ $ORACLE_HOME/OPatch/opatch… READ MORE
-
How to fix cannot load program when trying to run sqlplus when using local connection?
On AIX ran into the following issue where sqlplus generated the following error when using local connection (bequeath). scott@localhost:/home/scott:$ sqlplus… READ MORE
-
Tom Kyte’s utility to collect statistics
Tom Kyte’s following routine is a utility that can be used to to collect statistics of a session at the… READ MORE
-
DBCC TRACEON
There are 2 types of DBCC TRACEON (session or global). Session trace is turned on that session only and global… READ MORE
-
|
How to execution plan on SQLServer
In SQLServer Managment Studio to the execution plan one can use one of the following SET commands “SET SHOWPLAN_XML ON”… READ MORE
-
How to free buffer cache?
Shows how to flush buffer cache and v$bh, you may only want to do this on Dev or Test enviornment… READ MORE
-
How to view execution plan?
There are various methods of displaying execution plan. Here is few of them. 1) Using EXPLAIN PLAN and setting STATEMENT_ID… READ MORE
-
|
How to enable auditing?
By setting the parameter “AUDIT_TRAIL” to “DB” or “OS”, one can enable auditing in the database. To change the value… READ MORE
-
Materialized view – NOLOGGING
Compares refreshing materialized view with NOLOGGING 1) Refresh Materialized view with NOLOGGING -- Capture redo size before refreshing materialized view… READ MORE
-
How to setup/install StatsPack
Statspack can be installed by executing the following script, it will prompt for password for user PERFSTAT, the tablespace for… READ MORE
-
redo log generation during unrecoverable/nologging
# Capture amount of redo logs generated when table is created in UNRECOVERABLE SQL> select vs.name, vm.value from v$mystat vm,… READ MORE
-
process control
# lists jobs in current session $ jobs # start job 1 (sleeps for 200 seconds) $ sleep 200 #… READ MORE
-
Background process
There are multiple ways to place a program in background mode. Background mode is when the program runs and returns… READ MORE
-
Date manipulation
For SQLServer using arthemetic and DATEADD one can modify date select getdate() -- today , getdate() + 1 -- tomorrow… READ MORE
-
Using AUTONOMOUS_TRANSACTION and setting TRANSACTION ISOLATION
Scenario 1) Default transaction using AUTONOMOUS TRANSACTION and checking records in table called APP_LOG at each step. The store procedure… READ MORE
-
Example of AUTONOMOUS_TRANSACTION
Example of how AUTONOMOUS_TRANSACTION, it allows one to isolate a DML statements, the DML statements with the AUTONOMOUS transaction are… READ MORE
-
Example of SAVEPOINT and “ROLLBACK TO..”
Examples of using “SAVEPOINT” and “ROLLBACK TO” SQL> select * from scott.test; no rows selected SQL> insert into scott.test values… READ MORE
-
Using RMAN to validate backup
When using VALIDATE option, Oracle will validate backup and not create backups and will not restore when this option is… READ MORE
-
How to rename block change tracking file?
To move/rename current block change tracking file, one would need to restart the database. # Get current block change tracking… READ MORE
-
|
“Snap-in failed to initialize” error message when you open Microsoft Management Console
When running Microsoft Management Console if you get the error where it fails to initialize, one possible fix could be… READ MORE
-
How to find/modify SQLServer Agent logfile location?
To get the location of SQLServer Agent log file, the log file is called SQLAGENT.out DECLARE @oem_errorlog nvarchar(255) EXECUTE master.dbo.xp_instance_regread… READ MORE
-
RMAN – to enable compression of backupset
Backup in RMAN can be compressed when they are being created. Using the following command one can compress backup to… 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
