Featured
The Latest
-
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
-
How to turn on debug/trace when running RMAN?
Using the debug option one can turn on trace information, this can be used to troubleshoot an issue. Example: $ORACLE_HOME/bin/rman… READ MORE
-
How to restore and recover tablespace?
Steps if you need to restore all datafiles in a tablespace is corrupted so you would need to restore the… READ MORE
-
How does cascade work in cases of delete/update for foreign key?
The following example shows how to setup and cascade works when deleting record from parent table. 1) Shows how DELETE… READ MORE
-
How to start/stop Oracle Enterprise Manager (OEM)/ Grid Control (GC)?
To start the Oracle Enterprise Manager/Grid Control components in version 11g (11.1.0.1) $ cd /bin; ./emctl start oms $ cd… READ MORE
-
Clear procedure cache (execution plan)
For SQLServer: — Clears all the procedure cache (works on SQLServer 2005 and SQLServer 2008) DBCC FREEPROCCACHE http://msdn.microsoft.com/en-us/library/ms174283%28v=SQL.90%29.aspx — On… READ MORE
-
How to install Oracle Enterprise Manager Grid Control 11GR1?
The following document lists step how to install EM GridControl 11GR1 http://www.whopatooli.com/disquisitivedba/library/Joe_Johnson_Installing_EM_Grid_11gR1_11.1.0.1.pdf READ MORE
-
|
SQL Statement in cache, it’s execution time
— Display SQL statement (SQLServer 2005 and SQLServer 2008), it displays creation time, last exeuction time, max time it ran… READ MORE
-
print_table utility procedure
Found this store procedure on Tom Kyte’s site which can be used to print columns in a table row wise,… 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
