Oracle Archives - Page 14 of 30

Linux Administration.

A Linux distribution is a collection of (usually open source) software on top of a Linux kernel. A distribution (or short, distro) can bundle server software, system management tools, documentation…

asrblogger April 26, 2023No Comments

Oracle

Basic Performance and Tuning

As a DBA, you are responsible for the performance of your Oracle database. Typically, performance problems result from unacceptable response time, which is the time to complete a specified workload,…

asrblogger April 20, 2023No Comments

GoldenGate Oracle

Comparison Between Oracle Streams and GoldenGate

Staging Streams: Streams may store or stage changes in a database buffered queue. The benefit is that changes are stored in memory which has a fast access time. GoldenGate: When…

asrblogger April 7, 2023No Comments

Interview Questions Oracle

Transparent Data Encryption in Oracle

Transparent Data Encryption (TDE) enables you to encrypt sensitive data that you store in tables and tablespaces. After the data is encrypted, this data is transparently decrypted for authorized users…

asrblogger April 5, 2023No Comments

Oracle RAC

“ORA-00059: Maximum Number Of DB_FILES Exceeded”

CAUSE ALTER TABLESPACE TB1 add datafile '+WHALE_DG1' size 10g autoextend on next 500M * ERROR at line 1: ORA-00059: maximum number of DB_FILES exceeded We do not have to recreate…

asrblogger April 4, 2023No Comments

Oracle

Undo Tablespace

There are two types of Undo Modes in 12.2 1) Shared Undo - The Undo tablespace is common, it is shared among the entire CDB. The Management of undo tablespace…

asrblogger April 3, 2023No Comments

Oracle

Renaming and Relocating Datafiles Online

Relocating an Online Data File SQL> ALTER DATABASE MOVE DATAFILE '/rman_backup/backup/datafile1' TO '+DATA'; Database altered. Copying an Online Data File This example copies the data file to +DEV_DG and the…

asrblogger April 3, 2023No Comments

Oracle

Oracle Managed Files 11g & 12c

11g When OMF is enabled and If a datafile location is incorrect the file gets created in dbs location SQL> show parameter db_create_file_dest NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_create_file_dest string…

asrblogger April 3, 2023No Comments

Oracle

Managing Tablespace in CDB and PDB

Managing tablespace in container database is similar to non-container database. Provided you are logged in as a privileged user and point to right container. Manage Tablespace in CDB SQL> show…

asrblogger April 3, 2023No Comments

Oracle

Common user password change:

Common user password we can change from only cdb level .container class is optional. CDB container: ==================================== SQL> show con_name CON_NAME ------------------------------ CDB$ROOT SQL> SQL> alter user C##USERTEST identified by…