Monthly Archives: novembre 2017

ORACLE 12C – M-T.S. model
  • 22
    Nov

ORACLE 12C – M-T.S. model

Until Oracle Database 12c, Oracle processes did not run as threads on UNIX and Linux systems. Every dedicated connection was represented by an operating system process. In systems where high workload was an issue, the only way to reduce CPU and memory usage was to switch from dedicated connections to shared connections using the multithreaded server (MTS) feature....

Read More
MODIFICA SQLPROMPT CONTAINER E PLUGGABLE DATABASE
  • 8
    Nov

MODIFICA SQLPROMPT CONTAINER E PLUGGABLE DATABASE

Per impostare il nome dell’istanza sul prompt della macchina e contestualmente il nome utente e il nome dell’istanza in sqlplus eseguiamo con le seguenti modifiche: ENV PDB - Modificare l’export dell’istanza nell’env del PDB inserendo il nome del pluggable database export ISTANZA=RELAUP - Cambiare nell’export della variabile PS1 ORACLE_SID con ISTANZA export PS1='\u@${HOSTNAME}:${ISTANZA} # ' - Inserire l’export...

Read More