Featured
The Latest
-
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
-
RMAN – checksyntax
Starting RMAN with check syntax will check syntax of RMAN command, it will report errors if the syntax is incorrect.… READ MORE
-
Property Owner is not available for Database error message
When clicking on Properties, SQLServer could display the following error message “Property Owner is not available for Database ‘[DatabaseName]’. This… READ MORE
-
|
Movement commands in vi
Move by one character h – Move cursor left j – Move cursor down k – Move cursor up l… READ MORE
-
DATA_PURITY check and DBCC error 2570 in SQL Server 2005
http://support.microsoft.com/kb/923247 Using DBCC CHECKDB (0) WITH ESTIMATEONLY will estimate space needed in tempdb when DBCC CHECKDB is run. Sample Output:… READ MORE
-
|
Managing SQL Server 2000 Transaction Log Growth
Article to manage SQL Server 2000 transaction log growth http://www.mssqltips.com/tip.asp?tip=950 READ MORE
-
ksh – Process
— Get process id of current process $ echo $$ 6113 — shows process id $ ps PID TTY TIME… READ MORE
-
|
Using sp_tableoption to change “text in row”
sp_tableoption is used to turn on/off features on tables like turn on the text in row feature for datatype text,… READ MORE
-
|
How to generate systemdump when the instance is hung?
Using oradebug one can analyze if an instance is hung $ sqlplus “/as sysdba” SQL> oradebug mysetpid Statement processed. —… READ MORE
-
Issue when user couldn’t extract DDL using SQLDeveloper
If using SQLDeveloper from Oracle there was an issue we ran into where the user who were granted read access… READ MORE
-
Offlining a datafile
When one offline a datafile before you online the datafile one has to recover the datafile 1) Offline a datafile… READ MORE
-
Show oracle internally recompiles object in certain cases
We had seen case when the DDL timestamp of a procedure was changed in the middle of the night and… READ MORE
-
Scenario when the controlfile is lost and there was a datafile added
Scenario when the controlfile is lost and there was a datafile added to an existing table space after backup of… READ MORE
-
Restoring controlfile scenario?
Scenario when all control files for some reason have been lost. The following scenario shows how to restore controlfile and… READ MORE
-
Different scenerios on restoring spfile
Restore spfile through RMAN, here are some scenerios/examples. There are some pre-requites, the database would need to be in nomount… READ MORE
-
CONTROLFILE AUTOBACK explained
When AUTOBACKUP is turned on Oracle will create backup of controlfile and spfile. When one runs backup of the database… 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 