GENERATING AN ENVIROMENT FILE FROM PL/SQL
REQUEST I want to generate the current Oracle database environment file by querying a database. RELATED GETTING THE VALUE OF AN ENVIRONMENT VARIABLE THROGHT PL/SQL BLOCK SOLUTION ——————————————————- — Victor Khalturin — $Header 14:22 30.01.2018 — — Script generates the current environment…
QUERYING THE ORACLE_HOME PATH FROM A DATABASE
REQUEST I want to get the ORACLE_HOME path by querying the database. RELATED GETTING THE VALUE OF AN ENVIRONMENT VARIABLE THROGHT PL/SQL BLOCK SOLUTION DBMS_SYSTEM COL ORACLE_HOME FOR A30 VARIABLE ORACLE_HOME VARCHAR2(100); EXEC DBMS_SYSTEM.GET_ENV(‘ORACLE_HOME’,:ORACLE_HOME); PRINT ORACLE_HOME ORACLE_HOME —————————— /oracle/product/12.2.0.1 DBA_LIBRARIES…
GETTING THE VALUE OF AN ENVIRONMENT VARIABLE THROGHT PL/SQL BLOCK
REQUEST I want to get a value of the specific environment variable by querying a database. SOLUTION First, define a variable oracle@dbpilot.net: export MYVAR=”My Variable” oracle@dbpilot.net: echo $MYVAR My Variable A value of any variable can be retrieved through DBMS_SYSTEM.GET_ENV procedure COL OS_VAR…
Categories
- Linux (8)
- Iptables (2)
- Memory Usage (1)
- Postfix (1)
- Yum (4)
- Networker (2)
- Oracle (65)
- Account (2)
- AWR (2)
- Database Errors (6)
- Database Performance (9)
- Datapump (4)
- Enterprise Manager (24)
- Enterprise Manager Metrics (4)
- Environments (4)
- High CPU Usage (2)
- High IO Load (4)
- Initialization Parameters (5)
- job_queue_processes (1)
- Processes (3)
- NLS (1)
- Objects (1)
- Objects DDL (2)
- OJVM/PSU/DRU Patches (1)
- PL/SQL (5)
- UTL_FILE (4)
- Prerequisites (1)
- Privileges (1)
- Profile (1)
- Queries (2)
- Redologs (1)
- Resource Limits (1)
- Segment Shrink (1)
- Session (6)
- Spfile (3)
- SQL PLUS (1)
- Spooling (1)
- Standard Queries (7)
- Statistics (2)
- Tablespaces (1)
- Temporary Tablespace (2)