Featured
The Latest
-
|
Set title of a window
Using the script one can set the title of a window, one of the reason for doing would be distinguish… READ MORE
-
|
How to view table of contents of a compress tar file?
Using the example below one can view the contents a compress tar file without un-compressing the file. # if the… READ MORE
-
How to find blocking session?
In 10g, there is a column in V$session called blocking_session to find the session id that is blocking. Session 1)… READ MORE
-
How to find oracle bit size?
Using the following SQL one can find the oracle bit version installed: SQL> SELECT length(addr)*4 || ‘-bit’ word_length FROM v$process… READ MORE
-
How to delete archive logs already archived to backup device?
If one is keeping archive logs available on disk and also have them archived to tape and would like to… READ MORE
-
How to keep 2 days of archive log on disk and still have back to tape?
Using the following rman command one can setup to keep 2 days of archive log on disk and also archive… READ MORE
-
How to extract start and end time of a job in SQL Server?
In Query analyzer — prints job name, step name, start time and end time of each step in the job… READ MORE
-
|
How to truncate time in date field?
In Oracle: SQL> ALTER SESSION SET nls_date_format = ‘YYYY-MON-DD HH24:MI:SS’; Session altered. SQL> SELECT TRUNC(sysdate) FROM DUAL; TRUNC(SYSDATE) ——————– 2009-MAY-10… READ MORE
-
|
How to calculate end of day?
There are few ways to calculate end of day i.e when the time is 23:59:59. In the example below it… READ MORE
-
How to shrink transaction log file for a database?
The following article gives some background on how to stop the transaction log from growing Using the steps below one… READ MORE
-
How to find objects that are performing unrecoverable/nologgging option?
Using the steps below one can find the object that is unrecoverable from UNRECOVERABLE_CHANGE# in the v$datafile, one would use… READ MORE
-
How to flush shared pool?
One can flush the shared pool using the following DDL. SQL> ALTER SYSTEM FLUSH SHARED_POOL; System altered. Using the following… READ MORE
-
|
sqlplus: error while loading shared libraries: /u01/app/oracle/product/11.1.0/db_1/lib/libnnz11.so: cannot restore segment prot after reloc: Permission denied
Immediately after a successful RDBMS installation (perhaps even including a sample DB instance creation), sqlplus will not start: [oracle@test ~]$… READ MORE
-
How to find if there are datafiles that have objects that are not recoverable since last backup?
Using the following query one can find the datafiles that had nologging turned on, direct load or unrecoverable option was… READ MORE
-
|
Automatic Shared Memory Management (ASMM)
To use automatic shared memory management, the value of statistics_level must be set to “typical” or “all”. The parameter can… READ MORE
-
|
How to set keys (backspace, interrupt, suspend, kill)?
Using stty one can set some of keys like backsapce, interrupt, suspend and kill. $ stty -a # shows the… READ MORE
-
|
How to trace system calls?
Using strace (linux)/truss (AIX) one can trace the system calls as program executes. It can be useful in identifying where… READ MORE
-
|
v$session osuser/program issue when sqldeveloper and oracle client installed
In v$session osuser, program are not set when oracle client 10.2.0.1 is used when SQLDeveloper and oracle client are installed… READ MORE
-
|
Oracle – JDBC v$session osuser/program issue
When an java app connects to oracle depending on the driver such as osuser, program in v$session will not be… READ MORE
-
|
Commands to change cursor position in vi
h – Left l – Right k – Up j – Down w – Move forward to beginning of next… READ MORE
-
ORA-01031: insufficient privileges
Here are some of the scenarios when one gets ORA-01031: 1) Insufficient privileges error is when “oracle” user is not… 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 