Featured
The Latest
-
How to grant view all DDL in an Oracle database to unprivilege user
SQL>grant select on dba_objects to <username>; SQL>conn <username>/<password> SET PAGESIZE 0 SET LONG 100000 SET LONGCHUNKSIZE 10000 SET LINESIZE 1000… READ MORE
-
|
How to find the tapes needed for restore if you are using RMAN catalog to write directly to tape?
If you are using the RMAN and using the RMAN catalog to write directly to tape you can use the… READ MORE
-
How to change SYSMAN password in OEM (OMS)
To change the Sysman password: 1. Stop the OMS instances that are associated with the repository a. opmnctl stopall 2.… READ MORE
-
|
How does one trace a session based on user
CREATE OR REPLACE TRIGGER sys.session_trace_on– to be created by sys userAFTER LOGON ON databaseDECLAREmachinename VARCHAR2(64);osuserid VARCHAR2(30);ora_username VARCHAR2(30) DEFAULT NULL;os_username VARCHAR2(30);v_sid… READ MORE
-
How to modify SQL*Plus prompt
undefine usr db col usr new_value usr col db new_value db set termout off select lower(user) usr, instance_name db from… READ MORE
-
How to view session stats?
To see current stats of your session, one can run the following query. SELECT a.name, b.value FROM v$statname a, v$mystat… READ MORE
-
How to tell if the database was started with spfile or pfile?
There are couple of ways of finding if the database was started with spfile or pfile. One way would be… READ MORE
-
How to identify parameters that has been modified since instance started?
To identify the parameter one can query v$parameter view to find the parameters that were modified. The column ISMODIFIED is… READ MORE
-
Trigger to monitor successful logins in the database
By having a logon trigger in a database one can monitor or audit OS user, programs, DB users, time users… READ MORE
-
How to find files with duplicate names in filesystem?
If you are doing migrating to a new filesystem and moving files, it may be a good idea to check… READ MORE
-
|
How to check physical and logical data corruption using RMAN?
If you are not using RMAN to backup data and use technologies like NetApp snapshot which doesn’t check for physical… READ MORE
-
|
Format for RMAN backup piece file name is unique
Using incorrect format when backing up to tape can cause an issue during recovery if the backup pieces have the… READ MORE
-
Script to generate SQLs to terminate rman sessions
Killing the rman main process from the command line doesn’t immediately kill the rman sessions using the script below which… READ MORE
-
Internal parameters
— view oracle internal parameters, note this can be run by SYS user — name, value, default value, session modifiable,… READ MORE
-
|
ORA-19206 when running export (exp)
On Oracle9i if you get the following error when running export (exp) utility, to fix this issue one would need… READ MORE
-
Setting NLS_LANG for Oracle
NLS_LANG=<language>_<territory>.<character set> Example: export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1 Setting NLS_LANG tells Oracle what characterset the client is using so Oracle can do conversion… READ MORE
-
French accents character when using SQL*Plus
For SQL*Plus to process french accents characters when using SQL*Plus, you would need to set NLS_LANG On Windows set NLS_LANG=.AL32UTF8… READ MORE
-
How to migrate from single instance to RAC 10gR2
Move from single instance to RAC 1- Install CRS 2- Install new RDBMS binaries rac enable 3- Make sure there… READ MORE
-
How to fix Online redo log corruption?
Today, due to a network issue the host (Solaries) lost contact with the NetApp filer and it corrupted some datafiles… READ MORE
-
How to extract the DB LINKS DDL with the password
Here is a simple script to extract the DB Links DDL with the encripted password. SET LONG 9000 — to… READ MORE
-
|
Creation SQL script for DB Link within a database
The following can be used to create a script for DB Links with work on 8i/9i and will contain the… 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
