Featured
The Latest
-
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
-
|
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
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
- 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
Alex Lima 