Featured
The Latest
-
Information on sys.databases
Using sysdatabases one can create script various scripts one of the useful is to create script to backup all databases.… READ MORE
-
How to find sizes of all tables in SQLServer?
By executing the store procedure sp_spaceused ‘<table>’ one can find the space used by a table. The store procedure returns… READ MORE
-
How to backup and restore statistics using dbms_stats?
Using procedures in DBMS_STATS package one can backup statistics and restore them. Assumes the user scott already has access to… READ MORE
-
How to delete/reset a parameter in spfile using ALTER SYSTEM?
Using ALTER SYSTEM RESET one can delete parameter from spfile if the parameter is in the spfile. Example: — shows… READ MORE
-
How to use DBMS_FLASHBACK?
In 10g using dbms_flashback one can flashback using timestamp or SCN. If a user accidentally deletes rows or updates rows… READ MORE
-
|
How to turn trace and set events using dbms_system?
To turn on trace for a specific event. exec dbms_system.set_ev(<SID>, <serial#>, <event>, 8, ''); Example: Enable trace at level 8… READ MORE
-
|
How to set max_dump_file_size on a running session?
Using dbms_system.set_int_param_in_session, one can set max_dump_file_size of a running session. In the example it sets trace file to 100MB exec… READ MORE
-
Regular expression
One can use the regular expressions to match in vi, grep, sed and awk. [a-d] – Match one character with… READ MORE
-
Arrays in ksh
# how to create a array and assign a list of values set -A fruit apples pears oranges banana #… READ MORE
-
How to write a case condition in shell?
In ksh shell – case statement case variable_name in pattern1) statements1 ;; pattern2) statements2 ;; # default (catch all remaining)… READ MORE
-
How ERR trap works?
# Sample script that shows how ERR signal works, when a command returns a non-zero status it triggers to calls… READ MORE
-
How to create a database from command line?
Using the following steps one can create database from command line. Place the following pfile in $ORACLE_HOME/dbs directory and set… READ MORE
-
How to Display a List of All Snapshots from OMS
SQL> set lines 100 pages 999 SQL> select snap_id, snap_level, to_char(begin_interval_time, ‘dd/mm/yy hh24:mi:ss’) starting 2 from dba_hist_snapshot 3 order by… READ MORE
-
How to fix Target Database Incarnation Is Not Current In Recovery Catalog RMAN-20011?
When doing a incomplete recovery (i.e. database is open with resetlogs) and when running RMAN to backup that database after… READ MORE
-
What are the command line options that can be passed to runInstaller?
Here are some of the options that can be passed to runInstaller -slient – Slient mode -debug – To get… READ MORE
-
How to force a trace file to be created when an ORA error occurs?
There was an issue we ran into where one of the users ran out temporary tablespace (TEMP) we had message… READ MORE
-
Deleting top n lines
sed ‘1,10d’ file – doesn’t print the top 10 lines from the file sed ‘5d’ myfile – delete 5th line… READ MORE
-
Job to delete log and trace files from OEM
I use this script to clean up all the log and trace file from each host.. You can schedule a… READ MORE
-
How to find and fix block corruption using RMAN?
One of the scenario we ran into when one of the data file reported there was block corruption as RMAN… READ MORE
-
How to find success/failure status of a command in different shells?
Ksh/Borne/Bash shell $ ls /usr/bin …. # when success value is 0 $ echo $? 0 $ ls /usr/bin/blah ls:… READ MORE
-
How to change logical name of SQL Server database?
To change the logical name of the SQL Server databse one can follow the steps below to change the logical… 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 