asrblogger, Author at ASRblogger

Data Consistency

Data Consistency In Oracle Database, each user must see a consistent view of the data, including visible changes made by a user's own transactions and committed transactions of other users.…

asrblogger February 22, 2022No Comments

SQL

Introduction to Oracle SQL

Structured Query Language (SQL) is the set of statements with which all programs and usersaccess data in an Oracle Database. Application programs and Oracle tools often allow usersaccess to the…

asrblogger February 22, 2022No Comments

SQL

Sample Schemas

In Oracle Database, a database schema is a collection of logical data structures, or schema objects. A database user owns a database schema, which has the same name as the…

asrblogger February 22, 2022No Comments

Oracle

Datafiles in Oracle (Physical Storage)

Overview of Data Files At the operating system level, Oracle Database stores database data in structures called data files. Every Oracle database must have at least one data file. Use…

asrblogger February 18, 2022No Comments

Oracle

Oracle Database 19c – Practical & Assignments

PARAMETER & PASSWORDFILE: * Create pfile from spfile to location '/home/oracle/init<sid.ora>' * Create password file with sys password as oracle1 * Create parameterfile in different location /u01 & start the…

asrblogger February 13, 2022No Comments

Oracle

System Change Numbers (SCNs)

A system change number (SCN) is a logical, internal time stamp used by Oracle Database. SCNs order events that occur within the database, which is necessary to satisfy the ACID…

asrblogger January 17, 2022No Comments

Oracle

Password File management in 12C/19C

Below are the list of additional privileged user in 12c apart from the privileged user SYSOPER, SYSDBA, SYSASM. SYSBACKUP : It will be used to perform all backup and recovery related operations either…

asrblogger December 30, 2021No Comments

Oracle Scripts

Determining the Size of Oracle database tables and indexes

Useful views to get index details: dba_indexes dba_segments dba_ind_columns dba_ind_partitions user_indexes user_segments user_ind_columns user_ind_partitions Query to check Index on a Table in Oracle. set lines 200 col index_name from a30…

asrblogger December 23, 2021No Comments

Oracle

Oracle Instance and Database Shutdown Sequence

In a typical use case, you manually shut down the database, making it unavailable for users while you perform maintenance or other administrative tasks. You can use the SQL*Plus SHUTDOWN…

asrblogger December 12, 2021No Comments

Oracle RAC

ASH (Active Session History) Report in Oracle

Oracle ASH report introduced in Oracle 10g release 2. ASH collects samples of active sessions every second (waiting for non-idle events, or on the CPU working) from v$sessions (inactive sessions…