Featured
The Latest
-
|
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
-
|
Useful commands in vi to save/quit
There are few commands one can use to save a file n To save and quit: <esc>:wq To save (if… READ MORE
-
|
How to find the date when a role was created?
The view DBA_ROLES doesn’t have the created date column to display when the role was created, but the information is… READ MORE
-
Remove Old Backup Log Files
This script will delete files modified more than 14 days ago and have file name that begin with daily_backup ,… READ MORE
-
|
Useful commands in vi to delete
Useful commands in vi: To delete lines One at a time: <esc>dd n lines at a time: <esc>ndd – where… READ MORE
-
Format for parameter LOG_ARCHIVE_FORMAT?
This parameter controls the format of the archive log file name. This parameter can’t be changed on the fly therefore… READ MORE
-
How to clone a database manually?
Using the following steps one can clone a database manually. In the following example PRD represents the source and DEV… READ MORE
-
MySQL – JDBC connection example
—– Connect.java —- —- To compile c:> javac Connect.java —- Note: Make sure the CLASSPATH env is set. MySQL Connnector/J… READ MORE
-
|
How to create history file for different user?
If you use SSH to login using your own user account and su to oracle or su directly to oracle… READ MORE
-
Tom Kyte’s DBA Resolutions for 2009
Tom Kyte, Oracle DBA and founder of the Ask Tom blog, gave the Oracle Database Insider his resolutions for 2009… READ MORE
-
|
How to find shared libraries needed to run a binary?
Depending on the platform different command may be available, below are the commands for AIX and SUN to find the… READ MORE
-
How to build oracle with RAC off/on?
On 10R2 if the Oracle binaries are installed with the RAC, one can’t use those binaries to start Oracle Instance… READ MORE
-
|
How to tell uptime on windows?
Using one of the following commands one can tell the uptime on windows i.e. the time since the last reboot… READ MORE
-
|
How to grant SELECT access to v$session to other users?
One can’t grant direct access V$session as v$session is a synonym. SQL> GRANT SELECT ON v$session TO scott; grant select… READ MORE
-
What are the different options to shutdown?
shutdown (or shutdown normal) – In this method the database shuts down cleanly and oracle will wait for all users… READ MORE
-
How to enable command line history scrolling on SQL*Plus on unix?
Using the utility rlwrap one can perform command line scrolling on SQL*Plus similar to that is available on windows version… READ MORE
-
How to fix when backup piece is not found when deleting obsolete backup piece?
As part of the RMAN script during backup to disk for example you may have a statement to delete the… 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 