Featured
The Latest
-
How to delete or truncate Statspack data?
One can truncate data in STATSPACK or delete range of snaps stored. To truncate STATSPACK data Using $ORACLE_HOME/rdbms/admin/sptrunc.sql, one can… READ MORE
-
How to gather stats without histograms?
When passing method_opt as 'FOR ALL COLUMNS SIZE 1', it means no histogram is collected for columns on the table(s).… READ MORE
-
A utility to change oracle schema password using Java
The following java standalone program can be used to change Oracle password. It uses the OCI calls to change the… READ MORE
-
|
Script to automate generation AWR for a day
— The following anonymous PL/SQL code can be used to generate a script which can be run to generate AWR… READ MORE
-
How to view/change statistics retention and space used to store stats history?
See the oldest statistics history available SQL> SELECT DBMS_STATS.GET_STATS_HISTORY_AVAILABILITY FROM DUAL; GET_STATS_HISTORY_AVAILABILITY ————————————————————————— 25-OCT-11 10.00.55.093000000 PM -07:00 See the stats… READ MORE
-
How to restore statistics and view statistics history?
Shows in this scenrio there are backup of stats that exists for SCOTT.TEST table SQL> select * FROM DBA_TAB_STATS_HISTORY where… READ MORE
-
How to view 10053 trace?
To view output from 10053 using the following link one can download software which allows one to review the output… READ MORE
-
How to fix a scenerio when the datafile was removed before dropping the tablespace?
Ran into following issue were accidentally the datafile was removed before dropping the tablespace. If not fixed this can cause… READ MORE
-
|
How to find the queue_depth of a lun based filesystem on AIX?
# Displays information of all volume group, in the following example vb_TESTDB_data1 is one of the oracle filesystem /home/oracle $… READ MORE
-
Monitoring AIX
On AIX – nmon on AIX can be used to monitoring a machine (CPU, Memory, Network traffic, I/O, top processes,… READ MORE
-
Why a 99%+ Database Buffer Cache Hit Ratio is Not Ok – by Cary Milsap
The following article by Cary Milsap talks about “Why a 99%+ Database Buffer Cache Hit Ratio is Not Ok” by… READ MORE
-
RMAN – incremental backup
RMAN command to create level 0 backup which is needed before running of incremental backup RMAN> BACKUP INCREMENTAL LEVEL 0… READ MORE
-
How to add or drop online-redo logs?
Below are the steps on how to add a new online redo-group. It could be of the same size as… READ MORE
-
Shirking sharepoint database
We had an issue the other day when one of the Sharepoint database logs became extremely large as the server… READ MORE
-
How to fix issue when the online redo logs are missing?
If for some reason the online redo log were lost or when cloning the copy of shutdown database you don’t… READ MORE
-
Create a database manually on windows in 11g?
-- Step 1) set up environment variables needed (ORACLE_HOME, ORACLE_SID and add ORACLE_HOME\bin to PATH) set ORACLE_HOME=e:\oracle\11g\product\11.2.0.1 set PATH=%ORACLE_HOME%\bin;%PATH% set… READ MORE
-
|
How to create/drop AWR baseline?
To create a baseline of performance of the system, one create a baseline and used for later comparisons. If a… READ MORE
-
How to drop snapshots?
-- drop snapshot, it will not generate an error if the snap id is out of range SQL> EXEC dbms_workload_repository.drop_snapshot_range(low_snap_id=>1,… READ MORE
-
|
SQL by high physical I/O
-- Shows SQL statements currently in shared pool with high physical I/O, it sorts by the high I/O first SELECT… READ MORE
-
Using DBMS_ADVISOR to advice about UNDO tablespace from AWR
declare task_id number; name varchar2(100); descr varchar2(100); obj_id number; -- get the min and max snap id from AWR CURSOR… READ MORE
-
Resumable timeout explained
One can make Oracle suspend a session if it runs out a free space by enabling resumable timeout. This can… READ MORE
-
How to check if RMAN catalog is installed for a database?
There are couple of ways to determine if RMAN database is registered with a catalog. Using RMAN when you connect… READ MORE
-
How to generate a list of exceptions generated due to constraint violations?
The following shows how exceptions can be captured. — Create exceptions table SQL> @?/rdbms/admin/utlexcpt.sql Table created. SQL> desc exceptions; Name… READ MORE
-
|
How to list current active roles for a user in a session?
Using SESSION_ROLES it will retrieve the current roles that are active for a user in a session. Example: SQL> connect… 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 