Featured
The Latest
-
|
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
-
Setting NLS_LANG for export/import
Last updated: 17-Nov-2008 When exporting/importing one can minimize risk of losing data during import/export by setting NLS_LANG. – Before starting… READ MORE
-
|
How to find DDL lock on objects?
The following example shows how to find lock on a store procedure, the following store procedure has infinite loop. A… READ MORE
-
How to get client process id and oracle shadow process id in dedicated server?
— note this will work when not logged in as SYS, as the session id is the same for all… READ MORE
-
How to make trace files visible to all users?
To make trace files visible to all users, set the parameter _TRACE_FILES_PUBLIC=TRUE, this is undocumented parameter. This parameter requires a… READ MORE
-
|
How to monitor RMAN progress?
Using the following SQL you can monitor the progress of RMAN process, as channels completes creating the backpiece new sessions… READ MORE
-
Transaction isolation level (Serial and Read-committed)
The following 2 links explains transaction isolation. http://www.acs.ilstu.edu/docs/Oracle/server.101/b10743/consist.htm http://www.oracle.com/technology/oramag/oracle/05-nov/o65asktom.html 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 