Featured
The Latest
-
|
Setup PLAN_TABLE for all schema users
Each schema may require a PLAN_TABLE to debug performance so instead of creating the PLAN_TABLE within each schema, one can… READ MORE
-
|
Set default number of bytes to display LONG and CLOB
To change default number of bytes to be displayed when selecting LONG and CLOB columns. SQL> SET LONG 2000 SQL>… READ MORE
-
How to terminate and rollback a SQL script when running in SQL*Plus when an error is encountered?
Adding the following line before running a SQL Script will terminate the SQL script from running and rollback the change… READ MORE
-
View password history
One can view the password change history by querying oracle’s internal table SYS.USER_HISTORY$, note this table gets updated only if… READ MORE
-
|
How to run SQL statements in SQL*Plus if you have ‘&’ as part of your data?
If you have ‘&’ as part of your data that is part of the string and needs to inserted/updated/deleted and… READ MORE
-
|
How to find the process that has a file open on unix?
Using the command it will show the processes that has the file open. E.g: $ fuser /u01/oradata/TEST/system01.dbf /u01/oradata/TEST/system01.dbf: 2650128 2662644… READ MORE
-
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
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 