Freaks City

1.1. Checking Tablespace Utilization Use the following query to monitor tablespace storage consumption across the database: SELECT a.tablespace_name, ROUND(a.total_size) "total_size_gb", ROUND(a.total_size) - ROUND(b.free_size, 2) "used_size_gb", ROUND(b.free_size, 2) "free_size_gb", ROU ...

Every PL/SQL block you write defines and manipulates program data. Program data consists of data structures that exist only during the PL/SQL session (physically stored in the session's Program Global Area or PGA). Unlike database tables, program data is not persisted to disk. Program data encompasses: Variables or constants: Variables can cha ...

Performing Date Arithmetic with SYSDATE Oracle's SYSDATE function returns the current date and time. You can add or subtract time intervals directly using arithmetic on date values, or use dedicated functions like ADD_MONTHS. Adding Time Intervals -- Add 1 year SELECT SYSDATE, ADD_MONTHS(SYSDATE, 12) FROM DUAL; -- Add 1 month SELECT SYSDATE, A ...

Overview of RMAN RMAN (Recovery Manager) performs physical backups and supports point-in-time recovery. It operates in two database modes: Archivelog mode: Allows both offfline (cold) and online (hot) backups. Noarchivelog mode: Only offline backups are permitted. Using RMAN Connect to the target database from the server: rman target / # or w ...

Database incarnation represents a distinct version of a database that originates from a specific RESETLOGS operation. Each time a database is opened with RESETLOGS, Oracle creates a new incarnation, which fundamentally changes how recovery operations work across different database versions. Official Documentation Overview According to Oracle's ...

Oracle databases provide several dynamic performance views for monitoring session activity, performance tuning, and troubleshooting. Key views include v$session, v$active_session_history, and dba_hist_active_session_history. For multi-node environments, gv$session and gv$active_session_history offer consolidated information across all instances ...

The db file sequential read wait event represents time spent waiting for single-block I/O operations. Unlike db file scattered read, which fetches multiple blocks into non-contiguous SGA buffers, sequential reads target one block at a time—typically into contiguous memory locations within the process workspace. It commonly arises when accessing ...

Oracle Database Behavior In Oracle databases, the distinction between an empty string ('') and a NULL value is effectively nonexistent; the database engine interprets them identically. This behavior differs significantly from other relational database systems. To demonstrate this, we can create a test table and observe how Oracle processes thes ...

1. MySQL 4. Elasticsearch docker run -d --name=es -p 9200:9200 -p 9300:9300 -e discovery.type=single-node -e ES_JAVA_OPTS="-Xms256m -Xmx512m" -v /es/config/elasticsearch.yml:/usr/share/elasticsearch/config/elasticsearch.yml -v /es/data:/usr/share/elasticsearch/data -v /es/plugins:/usr/share/elasticsearch/plugins ela ...

Oracle Data Pump utilities expdp (export) and impdp (import) facilitate logical backup and migration of database objects using .dmp files. These server-side tools must be executed on the host where the Oracle database resides. Exporting a Schema to a DMP File Begin by logging in as the Oracle softawre owner (e.g., oracle). The general syntax fo ...