Featured
The Latest
-
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
-
ALTER DATABASE BEGIN/END BACKUP
To take backup manually or when cloning a database using the following SQL one can place the database in backup… READ MORE
-
How to fix RMAN-06059/ORA-19625?
If archive logs are missing RMAN will fail with the following error also in cases when the archive logs are… READ MORE
-
How to loop through parameters in batch file?
The following example shows how to loop through parameters in batch file. c:> TYPE script.bat @ECHO OFF :TOP IF (%1)… READ MORE
-
“Step Error Description:Class not registered” error message when executing a job through SQLServer Agent?
After scheduling a task through SQLServer Agent it generated the error below when executing the DTS. The DTS package required… READ MORE
-
|
How to monitor CPU of oracle processes on Windows?
Using QSlice one can monitor CPU usage for individual thread on a windows box. Qslice can be downloaded from the… READ MORE
-
How to find tables that have a specific column name?
Using the following SQL one can find tables that contain a column name. In SQLServer SELECT table_name, column_name FROM INFORMATION_SCHEMA.COLUMNS… READ MORE
-
How to setup Database Mail on SQL Server 2005?
In SQLSever 2005 msdb.dbo.sp_send_dbmail is the new way of sending email and it replaces xp_sendmail. Below are the steps how… READ MORE
-
|
Global Statistics vs. Histograms with DBMS_STATS Package
The following article explains global statistics versus histogram with DBMS_STATS http://www.akadia.com/services/ora_gather_statistics.html READ MORE
-
How to identify the job running through SQLServer Agent using SQL?
— List processes currently running through SQLServer Agent select spid, program_name, blocked from master..sysprocesses where program_name like ‘SQLAgent%’ spid program_name… READ MORE
-
How to restore table statistics (STATS)?
When using DBMS_STATS to gather table statics Oracle backups up the statistics before overwriting it. The following example shows how… READ MORE
-
How to automatically Create Install Scripts for Sql Server?
Using the link below one can create SQL script to create database http://geekswithblogs.net/dotNETPlayground/archive/2008/04/18/121331.aspx READ MORE
-
|
Script to change date on a computer
' ' script to change computer date ' DIM objShell strComputer = "." ' current host ' get current time… READ MORE
-
Flash Tip: Running Profiler on a Busy SQL Server
Flash Tip: Running Profiler on a Busy SQL Server http://www.microsoft.com/technet/abouttn/flash/tips/tips_020205.mspx 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 