Featured
The Latest
-
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
-
How to find the session and SQL statement that is not closing the ResultSet?
There was an issue the other day where the application session ran out of open cursors resulting the following error… READ MORE
-
|
How to find the last time a session performed any activity?
In v$session the column last_call_et has value which tells us the last time (seconds) ago when the session performed any… READ MORE
-
|
Explain plan execution plan
Explain plan may not relay the correct execution plan optimizer may run, the following link shows an example Explain Plan… READ MORE
-
How to change unix prompt?
C-shell (csh) Example: set prompt=”[%n@%m %c] \! %” oracle@localhost ~] 39 % In this above example sets prompt to display… READ MORE
-
whereiz – find all version of a command
Using the following script it will find all version of a command in $PATH (from Unix Power Tools) $ cat… READ MORE
-
Run a logout script in k-shell
By setting trap one can run a logout script when a k-shell is being terminated. The built-in command trap in… READ MORE
-
|
How to find permissions granted on user in a database?
Run the following SQL to find permissions granted on users on the database select case when p.protecttype = 205 then… 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
