Featured
The Latest
-
|
Archive log history by the hour
— Print # of archive logs for yesterday by the hour — can be used to determine to schedule archive… READ MORE
-
NetApp SnapShot Technology
A few years ago I was introduced to the NetApp storage technology and it’s backup, clone, DR capabilities and etc.… READ MORE
-
|
How to find materialized view log entries?
We have faced a situation where replication with materialized view needs to be checked before the shutdown outage between source… READ MORE
-
|
How to find datafiles with same name?
Sometimes you want to check for datafiles with the same name in the database, maybe you are new to the… READ MORE
-
|
How to get Help from SQL*Plus
A lot of people actually ask me why sql*plus doesn’t have a help feature like man in UNIX. Actually it… READ MORE
-
|
SQL*PLUS change buffer command
There are some cool SQL*PLUS command to help speed up your typing. Today I am showing the change and append… READ MORE
-
Enabling ARCHIVELOG Mode
Most of the Oracle production database require you to enable ARCHIVELOG mode for your database. When you enable this mode… READ MORE
-
NetApp Storage Management Tools for Oracle
Snapshot and FlexClone Several of the capabilities of NetApp storage contribute to the ease of Oracle data management in NFS… READ MORE
-
Materialized View Refresh Error
One of the uses of materialized views is replication. Oracle Materialized Views can be used to replicate a table from… 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 