Please find the below steps to enable the same. create audit policy audit_all actions all only toplevel; audit policy audit_all by user1,user2,user3; audit policy audit_all by sys,system; CONNECT /…
Read MorePlease run the below query to get the output. SELECT owner, table_name, column_name, generation_type, identity_options FROM dba_tab_identity_cols ORDER BY owner, table_name; Generation type is below. GENERATED ALWAYS AS IDENTITY…
Read MoreIn Oracle Database 19c, the MAX_STRING_SIZE parameter controls the maximum length for VARCHAR2, NVARCHAR2, and RAW columns. By default, it’s set to STANDARD, which limits columns to 4,000 bytes. Setting…
Read MoreWithin Oracle’s multitenant architecture, cloning a PDB allows you to build a duplicate environment—perfect for testing, patching, or sandboxing—without touching the production system. 1. Setting the Stage: Preparing Your Environment…
Read MoreIntroduction Oracle Cloud Infrastructure (OCI) introduced new Cloud Guard threat detector recipes to help organizations better identify and respond to evolving cloud security risks. While many enterprises already use Cloud…
Read MoreIntroduction There was a requirement to securely exchange application files (such as configuration files, logs, or deployment packages) between internal users and a restricted server location, without giving shell access…
Read MoreIntroduction: In some cases, while configuring or updating Oracle REST Data Services (ORDS), you may need to manage credentials stored in the Oracle Wallet. This is done using the mkstore…
Read MoreObjective: To renew and bind a new TLS certificate to SQL Server to ensure continued secure connections. Frequency: Annually or prior to certificate expiration Prerequisites: Administrative access to the Windows…
Read MoreOverview: When SQL Server runs out of worker threads, it can cause performance degradation, query delays, and even login failures. Understanding the root cause and knowing how to respond quickly…
Read MoreOverview This helps DBAs predict Undo tablespace usage before executing heavy DML operations in Oracle. It uses a combination of shell scripting and SQL to estimate Undo usage. Introduction Undo…
Read More