Featured
The Latest
-
How to view and change STATS retention?
Way of changing retention SQL> select dbms_stats.get_stats_history_retention from dual; GET_STATS_HISTORY_RETENTION ————————— 31 — value passed is in days — If… READ MORE
-
|
How to find oldest STATS information?
Using dbms_stats.get_stats_history_availability one can find date of oldest STATS information. STATS older than this timestamp cannot be restored. SQL> select… READ MORE
-
|
How to find space used by AWR?
Space used by AWR SQL> select occupant_desc, space_usage_kbytes from v$sysaux_occupants where occupant_name like ‘%AWR%’; OCCUPANT_DESC SPACE_USAGE_KBYTES —————————————————————- —————— Server Manageability… READ MORE
-
|
How to find SQL running for a user/sid?
Using the SQL below in which joining with V$session and V$sqlarea one can find the SQL currently running. In this… READ MORE
-
dba_scheduler_running_jobs
Using DBA_SCHEDULER_RUNNING_JOBS one can see jobs currently running. In the example below it shows the oracle session id and corresponding… READ MORE
-
RECYLE BIN
In 10g oracle has introduced the concept of recycle bin one can recover tables that were dropped. When a table… READ MORE
-
Grant access to source (package, procedure, function) without granting execute access
Depending on tool one can grant access to users if they need access to look at code for store procedure,… READ MORE
-
Powershell
Powershell – Powershell is in an interactive shell which supports scripting. You can download this from http://support.microsoft.com/kb/926139 Displays all the… READ MORE
-
ORA-28221: REPLACE not specified
When a user name has a profile that has a password verify function set and the user tries to change… READ MORE
-
How to create cold backup using RMAN?
Using the steps below one take cold backup using RMAN. As it’s a cold backup the database as the database… READ MORE
-
How to find RMAN catalog version?
To find RMAN catalog version log-in to the catalog through SQL*Plus and query the table rcver will print version. SQL>… READ MORE
-
Steps to create rman catalog and register DB
1) Create tablespace for example name catalog_tbs 2) Create user for example user rman_catalog and assign catalog_tbs as default tablespace… READ MORE
-
How to change/clear retention policy for RMAN?
Using CLEAR one can set the retention policy to default and using NONE have no retention policy. The example below… READ MORE
-
How to find what options are available/installed?
— shows what options are enabled SQL> select parameter FROM v$option where value = 'TRUE'; PARAMETER —————————————————————- Partitioning Objects Advanced… READ MORE
-
control_file_record_keep_time
control_file_record_keep_time – the value indicates number of days before reusable record is overwritten, if set to 0 reusable record is… READ MORE
-
How to create backup of control file?
— backup control file in binary format to a file named /tmp/x.ctl, it will preserve the backup information of the… READ MORE
-
Example of using Logminer
LogMiner can be used to recover data and audit database, it has 2 packages one of them named “DBMS_LOGMNR_D” to… READ MORE
-
Using timing in SQL*Plus
Using timing feature on SQL*Plus one can monitor elapsed time. Example: — start timer with the name monitor_timing, name is… READ MORE
-
|
Lessons on writing batch scripts
Lesson on learning how to write batch scripts to automate on Windows http://www.allenware.com/icsw/icswidx.htm READ MORE
-
|
Find locks on a table
Using the step below one can find the locks on the table by looking for object id. Example: Window 1:… READ MORE
-
|
Blocking locks
http://www.orafaq.com/node/854 SQL from the link above URL to find blocking SQL select s1.username || '@' || s1.machine || ' (… READ MORE
-
ORA-01410 – Invalid rowid
One of the reason why invalid rowid can occur is if there is a truncate that occurs in between when… READ MORE
-
Compatibility level
To display compatibility levels that can be set, 60 – 6.0, 65 – 6.5, 70 – 7.0, 80 – SQL… READ MORE
-
Database snapshot
In SQL Server snapshot can be created which creates a point in time read-only copy of any database. The amount… 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 