Featured
The Latest
-
|
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
-
|
How to change case of text in a file?
There are few ways to change case of text in a file from lower case to upper case or vice-versa.… READ MORE
-
|
How to compare binary files after copying?
When you are copying oracle files (datafiles, archivelogs, controlfiles, etc) or any binary file one can compare if the files… READ MORE
-
|
How to change one’s login shell?
Using chsh one can change their login shell. To show the shells that are available $ chsh -l /bin/sh /bin/bash… READ MORE
-
|
How to schedule a job on unix?
Jobs can be scheduled couple of ways on unix like cron, at. Below is description how jobs can be scheduled… READ MORE
-
|
How to create SQL scripts to recreate grants on a database granted through a role?
DECLARE @role_name VARCHAR(100) DECLARE @member_name VARCHAR(100) DECLARE @rolescur CURSOR DECLARE @rolememberscur CURSOR DECLARE @loginname VARCHAR(100) DECLARE @username VARCHAR(100) DECLARE @logincur… READ MORE
-
How to restore archive logs from backup piece?
If one needs to restore archive logs to disk and not apply them, for example in case when cloning a… READ MORE
-
|
How to list files by their size?
# Using ls and sort one can sort the files by their size, here is what the options means #… READ MORE
-
Internal view for Oracle to track features used
In 10g there is a new view called DBA_FEATURE_USAGE_STATISTICS which keeps features have been used. Here is description of some… READ MORE
-
What is the difference b/w NLS_NCHAR_CHARACTERSET and NLS_NCHAR_CHARACTERSET?
NLS_CHARACTERSET is used for CHAR, VARCHAR2, CLOB columns and NLS_NCHAR_CHARACTERSET is used for NCHAR, NVARCHAR2, NCLOB columns. One can find… 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
