Sadan's Oracle dba Blog

After installing OLE 7.9, install below things at OS level , then create Oracle Database 19c and Apply 19.26 or later patch.  .. [oracle@oemrepo soft]$ /u01/app/oracle/product/19.3.0/dbhome_1/OPatch/opatch version OPatch Version: 12.2.0.1.49 OPatch succeeded. [oracle@oemrepo soft]$ [oracle@oemrepo soft]$ [oracle@oemrepo soft]$ [oracle@oemrepo soft]$ ps -ef|grep smon oracle    3750     1  0 13:13 ?        00:00:00 ora_smon_orcl oracle    5258  4890  0 13:27 pts/1    00:00:00 grep --color=auto smon [oracle@oemrepo soft]$ . oraenv ORACLE_SID = [oracle] ? orcl The Oracle base has been set to /u01/app/oboseracle [oracle@oemrepo soft]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Sat Feb 7 13:27:32 2026 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle.  All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.3.0.0.0 SQL...

  1. Architecture & Storage Explain Snowflake’s unique architecture. * Answer: It is a hybrid of shared-disk and shared-nothing architectures. It consists of three layers: Database Storage (columnar format, micro-partitions), Query Processing (Virtual Warehouses), and Cloud Services (metadata, security, optimization). What are Micro-partitions and how do they benefit the DBA? Answer: All data in Snowflake is automatically divided into micro-partitions (50MB to 500MB of uncompressed data). This eliminates the need for manual partitioning and enables "Pruning," where the engine only scans relevant partitions. What is the difference between Time Travel and Fail-safe? Answer: Time Travel allows you to access historical data (up to 90 days for Enterprise) for recovery or querying. Fail-safe is a non-configurable 7-day period after Time Travel expires where Snowflake Support can recover data in case of extreme failure. 2. Virtual Warehouses & Performance Tuning How...

 1. Identify the SID/Session Running the UPDATE                                                                                                                                                                                                                                                          ...