Featured
The Latest
-
|
How to fix ORA-19571 during running of RMAN?
Received ORA-19571 error when running of archive log process, and found the the parameter control_file_record_keep_time was set to 0 so… READ MORE
-
How to find the NLS_LANG to set for a database?
One can use the following v$nls_parameters view to find the database LANGUAGE, TERRITORY, and CHARACTER SET. READ MORE
-
Export/Import to/from a compressed file
To reduce the amount of space used when exporting one can compress the data as creating export file and also… READ MORE
-
|
How to monitor datapump?
When using datapump one can run the following query to monitor the progress by running the following SQL. select sid,… READ MORE
-
|
How to lock/unlock statistics on a table?
In certain cases you may want to lock statistics in a table in certain cases, for example if you want… READ MORE
-
Information on flashback feature in 10g
One of the features in 10g is flashback which allows to restores tables that were dropped. Note: If an index… READ MORE
-
How to pass host, port, SID/Service name to connect to a database?
Using the following command one can pass hostname, port, servicename and SID and connect to a database without having an… READ MORE
-
How to tell if a parameter can be modified in a session/system?
By querying V$parameter one can find if the parameter can be modified in session and/or system. If isses_modifiable is true… READ MORE
-
How to shrink UNDO tablespace?
The datafile for UNDO tablespace can’t be shrunk as we had issue where the datafile was set to unlimited and… READ MORE
-
10g RAC: How to Clean Up After a Failed CRS Install
Not cleaning up a failed CRS install can cause problems like node reboots. Follow these steps to clean up a… READ MORE
-
Setting NLS_LANG for export/import
Last updated: 17-Nov-2008 When exporting/importing one can minimize risk of losing data during import/export by setting NLS_LANG. – Before starting… READ MORE
-
|
How to find DDL lock on objects?
The following example shows how to find lock on a store procedure, the following store procedure has infinite loop. A… READ MORE
-
How to get client process id and oracle shadow process id in dedicated server?
— note this will work when not logged in as SYS, as the session id is the same for all… READ MORE
-
How to make trace files visible to all users?
To make trace files visible to all users, set the parameter _TRACE_FILES_PUBLIC=TRUE, this is undocumented parameter. This parameter requires a… READ MORE
-
|
How to monitor RMAN progress?
Using the following SQL you can monitor the progress of RMAN process, as channels completes creating the backpiece new sessions… READ MORE
-
Transaction isolation level (Serial and Read-committed)
The following 2 links explains transaction isolation. http://www.acs.ilstu.edu/docs/Oracle/server.101/b10743/consist.htm http://www.oracle.com/technology/oramag/oracle/05-nov/o65asktom.html READ MORE
-
|
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
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
