Featured
The Latest
-
|
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
-
|
How to enable/disable block tracking for RMAN?
Using block tracking one can improve performance of the backup time of incremental backup from hours to minutes depending on… READ MORE
-
|
How to check syntax of rman commands/script?
One can check syntax for RMAN commands without running the RMAN. Example: Checking syntax of commands on the command line.… READ MORE
-
How to compile/drop public synonym?
— compile public synonym that are invalid Select ‘alter public synonym ‘||object_name||’ compile;’ From dba_objects Where status <> ‘VALID’ And… READ MORE
-
How to enable/disable a scheduled job?
Using the package DBMS_SCHEDULER one can enable/disable jobs. To disable job: This disables the job from running SQL> exec dbms_scheduler.disable(‘GATHER_STATS_JOB’);… READ MORE
-
How to find jobs currently running or history about the jobs?
In 10g one can find the jobs that are currently running by querying the following view SELECT job_name, session_id, running_instance,… READ MORE
-
|
How to find the trace file name?
— One can use the following query to find the name of the trace filename — To find the name… READ MORE
-
|
How to find your session id (SID)?
Using one of the following you can find your session id (SID). SQL> SELECT sid FROM v$mystat WHERE rownum =… READ MORE
-
How to set/find default tablespace in 10g?
— Set default tablespace for all users, so when users are created without specifying default tablespace it will be user’s… READ MORE
-
How to start/stop an instance on a RAC?
To start the instance: # check status of instance $ $CRS_HOME/bin/crs_stat # seen cases when CRS says OFFLINE but pmon… 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
