[oracle@ol8 bin]$ sqlplus / as sysdba
SQL*Plus: Release 21.0.0.0.0 - Production on Sat Aug 14 22:12:48 2021
Version 21.3.0.0.0
Copyright (c) 1982, 2021, Oracle. All rights reserved.
Connected to:
Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production
Version 21.3.0.0.0
SQL> select banner from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production
SQL> select comp_name,version,status from dba_registry;
COMP_NAME VERSION STATUS
----------------------------------- ------------------------------ ---------------
Oracle Database Catalog Views 21.0.0.0.0 VALID
Oracle Database Packages and Types 21.0.0.0.0 VALID
Oracle Real Application Clusters 21.0.0.0.0 OPTION OFF
JServer JAVA Virtual Machine 21.0.0.0.0 VALID
Oracle XDK 21.0.0.0.0 VALID
Oracle Database Java Packages 21.0.0.0.0 VALID
OLAP Analytic Workspace 21.0.0.0.0 VALID
Oracle XML Database 21.0.0.0.0 VALID
Oracle Workspace Manager 21.0.0.0.0 VALID
Oracle Text 21.0.0.0.0 VALID
Oracle Multimedia 21.0.0.0.0 VALID
Oracle OLAP API 21.0.0.0.0 VALID
Spatial 21.0.0.0.0 VALID
Oracle Locator 21.0.0.0.0 VALID
Oracle Label Security 21.0.0.0.0 VALID
Oracle Database Vault 21.0.0.0.0 VALID
16 rows selected.
SQL> select name,description,type,priority from v$bgprocess where paddr<>'00' order by name;
NAME DESCRIPTION TYPE PRIORITY
----- ---------------------------------------- ----- --------
AQPC AQ Process Coord TS
BG00 SLAVE TS
BG00 SLAVE TS
BG00 SLAVE TS
BG01 SLAVE TS
BG01 SLAVE TS
BG01 SLAVE TS
CJQ0 Job Queue Coordinator TS
CKPT checkpoint TS
CL00 process cleanup slave SLAVE TS
CLMN process cleanup TS
D000 Dispatchers SLAVE TS
DBRM DataBase Resource Manager TS
DBW0 db writer process 0 TS
DIA0 diagnosibility process 0 TS
DIAG diagnosibility process TS
FENC IOServer fence monitor TS
GEN0 generic0 TS
GEN1 generic1 TS
GEN2 generic2 TS
LG00 Log Writer Slave SLAVE TS
LG01 Log Writer Slave SLAVE TS
LGWR Redo etc. RT
LREG Listener Registration TS
M000 MMON slave class 1 SLAVE TS
M001 MMON slave class 1 SLAVE TS
M002 MMON slave class 1 SLAVE TS
M003 MMON slave class 1 SLAVE TS
M004 MMON slave class 1 SLAVE TS
MMAN Memory Manager TS
MMNL Manageability Monitor Process 2 TS
MMON Manageability Monitor Process TS
OFSD Oracle File Server BG TS
P000 Parallel query slave SLAVE TS
P001 Parallel query slave SLAVE TS
P002 Parallel query slave SLAVE TS
P003 Parallel query slave SLAVE TS
PMAN process manager TS
PMON process cleanup TS
PSP0 process spawner 0 TS
PXMN PX Monitor TS
Q002 QMON MS SLAVE TS
Q003 QMON MS SLAVE TS
QM02 QMON MS SLAVE TS
RCBG Result Cache: Background TS
RECO distributed recovery TS
S000 Shared servers SLAVE TS
SCMN SLAVE TS
SCMN SLAVE TS
SCMN SLAVE TS
SCMN SLAVE TS
SMCO Space Manager Process TS
SMON System Monitor Process TS
SVCB services background monitor TS
TMON Transport Monitor TS
TT00 Redo Transport SLAVE TS
TT01 Redo Transport SLAVE TS
TT02 Redo Transport SLAVE TS
VKRM Virtual sKeduler for Resource Manager TS
VKTM Virtual Keeper of TiMe process RT
VOSD VOS Daemon TS
W000 space management slave pool SLAVE TS
W001 space management slave pool SLAVE TS
W002 space management slave pool SLAVE TS
W003 space management slave pool SLAVE TS
W004 space management slave pool SLAVE TS
W005 space management slave pool SLAVE TS
W006 space management slave pool SLAVE TS
W007 space management slave pool SLAVE TS
69 rows selected.
No comments:
Post a Comment