10.94.134.27 ART

[]@ndc3vpaoemdb01:/home/oracle > ssh 10.94.134.
27
Last unsuccessful login: Sun Jun 11 13:12:28 IST 2023 on ssh from 172.19.160.38
Last login: Sat Oct 19 12:42:23 IST 2024 on ssh from 10.94.141.87
###############################################################################
# #
# "This is an Vodafone Idea Ltd system and is meant for official use by #
# authorized users. #
# #
# Accessing and using this system constitutes consent to monitoring, interce #
# ption, retrieval,recording, reading, copying, searching or capturing and #
# disclosure of any information as to any information processed,stored or ma #
# nipulated within the system, including but not limited to information stor #
# ed locally on the hard drive or other media in use with this unit internal #
# ly or externally (e.g., floppy disks, tapes, CD-ROMs, PDA.s etc.) by the #
# company management or law enforcement agencies. #
# #
# Unauthorized or improper use of this system may lead to prosecution result #
# ing in disciplinary, criminal or civil penalties.Suspected access violatio #
# ns or breach of security policy should be reported to Account security #
# SPOC." #
# #
###############################################################################
You are logged :- oracle pts/0 Oct 19 12:59 (10.94.141.87) at Sat Oct 19 12:59:00
IST 2024
oratab file /etc/oratab found.
Alias for CPOSQA environment variables is set to CPOSQA

Alias for +ASM environment variables is set to ASM
oracle 7143720 1 0 Jun 29 - 1:42 asm_pmon_+ASM

oracle 11796862 1 0 Jun 29 - 32:22
/grid_19c/oracle/Grid19CHome/bin/tnslsnr MARS_P -no_crs_notify -inherit
oracle 12190156 1 0 Jun 29 - 1:44
/grid_19c/oracle/Grid19CHome/bin/tnslsnr LISTENER -no_crs_notify -inherit
oracle 32244048 1 0 Jun 30 - 7:00 ora_pmon_CPOSQA
[]@ndc3vqaicpsdb06:/home/oracle > ASM

ORACLE_SID is set to :- +ASM
ORACLE_HOME is set to :- /grid_19c/oracle/Grid19CHome
[+ASM]@ndc3vqaicpsdb06:/home/oracle > uname -a
AIX ndc3vqaicpsdb06 2 7 00C08D184C00
[+ASM]@ndc3vqaicpsdb06:/home/oracle > sqlplus -V
SQL*Plus: Release 19.0.0.0.0 - Production

Version 19.17.0.0.0
[+ASM]@ndc3vqaicpsdb06:/home/oracle > hostname

ndc3vqaicpsdb06
[+ASM]@ndc3vqaicpsdb06:/home/oracle > ifconfig -a
en0:
flags=1e084863,814c0<UP,BROADCAST,NOTRAILERS,RUNNING,SIMPLEX,MULTICAST,GROUPRT,64BI
T,CHECKSUM_OFFLOAD(ACTIVE),LARGESEND,CHAIN>
inet 10.94.134.27 netmask 0xffffff00 broadcast 10.94.134.255
tcp_sendspace 262144 tcp_recvspace 262144 rfc1323 1
lo0:
flags=e08084b,c0<UP,BROADCAST,LOOPBACK,RUNNING,SIMPLEX,MULTICAST,GROUPRT,64BIT,LARG
ESEND,CHAIN>
inet 127.0.0.1 netmask 0xff000000 broadcast 127.255.255.255
inet6 ::1%1/64
tcp_sendspace 131072 tcp_recvspace 131072 rfc1323 1
[+ASM]@ndc3vqaicpsdb06:/home/oracle > cat /etc/hosts
# @(#)47 1.2.1.1 src/bos/usr/sbin/netstart/hosts, cmdnet, bos720 7/14/11
20:16:59
# IBM_PROLOG_BEGIN_TAG
# This is an automatically generated prolog.
#
# bos720 src/bos/usr/sbin/netstart/hosts 1.2.1.1
#
# Licensed Materials - Property of IBM
#
# COPYRIGHT International Business Machines Corp. 1985,1989
# All Rights Reserved
#
# US Government Users Restricted Rights - Use, duplication or
# disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
#
# IBM_PROLOG_END_TAG
#
# COMPONENT_NAME: TCPIP hosts
#
# FUNCTIONS: loopback
#
# ORIGINS: 26 27
#
# (C) COPYRIGHT International Business Machines Corp. 1985, 1989
# All Rights Reserved
# Licensed Materials - Property of IBM
#
# US Government Users Restricted Rights - Use, duplication or
# disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
#
# /etc/hosts
#
# This file contains the hostnames and their address for hosts in the
# network. This file is used to resolve a hostname into an Internet
# address.
#
# At minimum, this file must contain the name and address for each
# device defined for TCP in your /etc/net file. It may also contain
# entries for well-known (reserved) names such as timeserver
# and printserver as well as any other host name and address.
#
# The format of this file is:
# Internet Address Hostname # Comments
# Internet Address can be either IPv4 or IPv6 address.
# Items are separated by any number of blanks and/or tabs. A '#'
# indicates the beginning of a comment; characters up to the end of the
# line are not interpreted by routines which search this file. Blank
# lines are allowed.
# Internet Address Hostname # Comments

# 192.9.200.1 net0sample # ethernet name/address
# 128.100.0.1 token0sample # token ring name/address
# 10.2.0.2 x25sample # x.25 name/address
# 2000:1:1:1:209:6bff:feee:2b7f ipv6sample # ipv6 name/address
127.0.0.1 loopback localhost # loopback (lo0) name/address
::1 loopback localhost # IPv6 loopback (lo0) name/address
10.94.134.27 ndc3vqaicpsdb06
10.94.32.11 NDC3LAITNIM01
10.94.1.162 itambcn.vodafone.co.in
10.94.1.162 itambcn.vodafone.co.in
10.94.108.24 NDC3CWNPTEMP01.internal.vodafone.com
10.94.108.25 NDC3CWNPTEMS01.internal.vodafone.com
10.94.1.162 ITAMbcn.vodafone.co.in
10.94.1.162 ITAMbcn.vodafone.co.in
10.94.136.11 ndc3vpaiappnim
10.94.140.11 ndc3vpaidbnim
10.94.134.11 ndc3vqtestnim
10.94.32.11 NDC3LAITNIM01
[+ASM]@ndc3vqaicpsdb06:/home/oracle > no -a
arpqsize = 1024
arpt_killc = 20
arptab_bsiz = 7
arptab_nb = 149
bcastping = 0
bsd_loglevel = 3
cached_routes = 0
clean_partial_conns = 1
delayack = 0
delayackports = {}
dgd_flush_cached_route = 0
dgd_packets_lost = 3
dgd_ping_time = 5
dgd_retry_time = 5
directed_broadcast = 0
dmxperf = 0
fasttimo = 200
hstcp = 0
icmp6_errmsg_rate = 10
icmpaddressmask = 0
icmptimestamp = 1
ie5_old_multicast_mapping = 0
ifsize = 256
ifstats32 = 0
igmpv2_deliver = 0
init_high_wat = 0
ip6_defttl = 64
ip6_prune = 1
ip6forwarding = 0
ip6srcrouteforward = 0
ip_ifdelete_no_retrans = 0
ip_ifdelete_notify = 0
ip_nfrag = 200
ipforwarding = 0
ipfragttl = 2
ipignoreredirects = 1
ipoutqueues = 0
ipqmaxlen = 512
ipsendredirects = 0
ipsrcrouteforward = 0
ipsrcrouterecv = 0
ipsrcroutesend = 0
limited_ss = 0
llsleep_timeout = 3
lo_perf = 1
lowthresh = 90
main_if6 = 0
main_site6 = 0
maxnip6q = 20
maxttl = 255
medthresh = 95
mpr_policy = 1
multi_homed = 1
nbc_limit = 2621440
nbc_max_cache = 131072
nbc_min_cache = 1
nbc_ofile_hashsz = 12841
nbc_pseg = 0
nbc_pseg_limit = 5242880
ndd_event_name = {all}
ndd_event_tracing = 0
ndogthreads = 0
ndp_mmaxtries = 3
ndp_umaxtries = 3
ndpqsize = 50
ndpt_down = 3
ndpt_keep = 120
ndpt_probe = 5
ndpt_reachable = 30
ndpt_retrans = 1
net_buf_size = {all}
net_buf_type = {all}
net_malloc_frag_mask = {0}
netm_page_promote = 1
nonlocsrcroute = 0
nstrpush = 8
passive_dgd = 0
pmtu_default_age = 10
pmtu_expire = 10
pmtu_rediscover_interval = 30
psebufcalls = 20
psecache = 1
psetimers = 20
rfc1122addrchk = 0
rfc1323 = 1
rfc2414 = 1
route_expire = 1
routerevalidate = 0
rtentry_lock_complex = 1
rto_high = 64
rto_length = 13
rto_limit = 7
rto_low = 1
rtpool_size = 25
sack = 0
sb_max = 1048576
send_file_duration = 300
site6_index = 0
sockthresh = 60
sodebug = 0
sodebug_env = 0
somaxconn = 1024
soreuseport_lb = 0
strctlsz = 1024
strmsgsz = 0
strthresh = 85
strturncnt = 15
subnetsarelocal = 1
tcp_bad_port_limit = 0
tcp_cwnd_modified = 0
tcp_ecn = 0
tcp_ephemeral_high = 65500
tcp_ephemeral_low = 9000
tcp_fastlo = 0
tcp_fastlo_crosswpar = 0
tcp_finwait2 = 120
tcp_icmpsecure = 0
tcp_init_window = 0
tcp_inpcb_hashtab_siz = 24499
tcp_keepcnt = 8
tcp_keepidle = 600
tcp_keepinit = 40
tcp_keepintvl = 10
tcp_limited_transmit = 1
tcp_low_rto = 0
tcp_maxburst = 0
tcp_maxqueuelen = 0
tcp_mssdflt = 1448
tcp_nagle_limit = 65535
tcp_nagleoverride = 0
tcp_ndebug = 100
tcp_newreno = 1
tcp_nodelayack = 1
tcp_pmtu_discover = 0
tcp_recvspace = 262144
tcp_sendspace = 262144
tcp_syn_rto = 0
tcp_tcpsecure = 7
tcp_timewait = 1
tcp_ttl = 60
tcprexmtthresh = 3
tcptr_enable = 0
thewall = 10485760
timer_wheel_tick = 0
tn_filter = 1
udp_bad_port_limit = 0
udp_ephemeral_high = 65500
udp_ephemeral_low = 9000
udp_inpcb_hashtab_siz = 24499
udp_pmtu_discover = 0
udp_recv_perf = 0
udp_recvspace = 655360
udp_send_perf = 0
udp_sendspace = 65536
udp_ttl = 30
udpcksum = 1
use_sndbufpool = 1
[+ASM]@ndc3vqaicpsdb06:/home/oracle > netstat -in
Name Mtu Network Address Ipkts Ierrs Opkts
Oerrs Coll
en0 1500 link#2 d2.15.74.b8.6e.2 59231844 0 53847535
0 0
en0 1500 10.94.134 10.94.134.27 59231844 0 53847535
0 0
lo0 16896 link#1 5840532 0 5840532
0 0
lo0 16896 127 127.0.0.1 5840532 0 5840532
0 0
lo0 16896 ::1%1 5840532 0 5840532
0 0
[+ASM]@ndc3vqaicpsdb06:/home/oracle >
[+ASM]@ndc3vqaicpsdb06:/home/oracle > ps -ef|grep -i pmon
oracle 36241788 24510760 0 12:59:11 pts/0 0:00 grep -i pmon
[+ASM]@ndc3vqaicpsdb06:/home/oracle > ps -ef|grep -i tns
oracle 11796862 1 0 Jun 29 - 32:22
/grid_19c/oracle/Grid19CHome/bin/tnslsnr MARS_P -no_crs_notify -inherit
oracle 12190156 1 0 Jun 29 - 1:44
/grid_19c/oracle/Grid19CHome/bin/tnslsnr LISTENER -no_crs_notify -inherit
[+ASM]@ndc3vqaicpsdb06:/home/oracle > ps -ef|grep -i agent
root 5898734 6095246 0 Jun 29 - 0:00 /opt/ds_agent/ds_agent -b -i -
w /var/opt/ds_agent -e /opt/ds_agent/ext
root 6816230 5898734 11 Jun 29 - 11467:36 /opt/ds_agent/ds_agent -b -
i -w /var/opt/ds_agent -e /opt/ds_agent/ext
oracle 8323374 1 0 Jun 29 - 70:56
/grid_19c/oracle/Grid19CHome/bin/cssdagent
root 9175374 1 0 Jun 29 - 0:00 /opt/ds_agent/ds_am -g ../diag
-v 5 -d /var/opt/ds_agent/am -P 4
root 9372146 9175374 0 Jun 29 - 39:08 /opt/ds_agent/ds_am -g ../diag
-v 5 -d /var/opt/ds_agent/am -P 4
oracle 9699776 1 1 Jun 29 - 572:27
/grid_19c/oracle/Grid19CHome/bin/oraagent.bin
root 9765310 1 0 Jun 29 - 2:40
/opt/IBM/ITM/aix526/ul/bin/kulagent
root 12976634 1 0 Jun 29 - 92:11
/opt/IBM/ITM/aix526/lo/bin/kloagent ndc3vqaicpsdb06_lfa-logstash
oracle 31129864 24510760 0 12:59:11 pts/0 0:00 grep -i agent
root 36307324 1 0 Jul 01 - 89:45
/opt/IBM/ITM/aix526/lo/bin/kloagent ndc3vqaicpsdb06_aix-errpt
[+ASM]@ndc3vqaicpsdb06:/home/oracle > ps -ef|grep -i oem
[+ASM]@ndc3vqaicpsdb06:/home/oracle > ps -ef|grep -i d.bin
oracle 8978748 1 0 Jun 29 - 102:20
/grid_19c/oracle/Grid19CHome/bin/ohasd.bin reboot
oracle 12059020 1 1 Jun 29 - 53:05
/grid_19c/oracle/Grid19CHome/bin/evmd.bin
oracle 12779864 1 0 Jun 29 - 57:04
/grid_19c/oracle/Grid19CHome/bin/ocssd.bin
oracle 36241796 24510760 0 12:59:11 pts/0 0:00 grep -i d.bin
[+ASM]@ndc3vqaicpsdb06:/home/oracle > ps -ef |grep -i mgr
root 12321166 8126782 0 Jun 29 - 0:04 /opt/rsct/bin/trspoolmgr
[+ASM]@ndc3vqaicpsdb06:/home/oracle > crsctl status res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DG_CPOSQA_DATA.dg
ONLINE ONLINE ndc3vqaicpsdb06 STABLE
ora.DG_CPOSQA_REDOCTL01.dg
ora.LISTENER.lsnr
ora.MARS_P.lsnr
ONLINE OFFLINE ndc3vqaicpsdb06 STABLE
ora.asm
ONLINE ONLINE ndc3vqaicpsdb06 Started,STABLE
ora.ons
OFFLINE OFFLINE ndc3vqaicpsdb06 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
1 ONLINE ONLINE ndc3vqaicpsdb06 STABLE
ora.diskmon
1 OFFLINE OFFLINE STABLE
ora.evmd
1 ONLINE ONLINE ndc3vqaicpsdb06 STABLE
--------------------------------------------------------------------------------
[+ASM]@ndc3vqaicpsdb06:/home/oracle > lsnrctl status MARS_P
LSNRCTL for IBM/AIX RISC System/6000: Version 19.0.0.0.0 - Production on 19-OCT-

2024 12:59:20
Copyright (c) 1991, 2022, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ndc3vqaicpsdb06)
(PORT=1526)))
STATUS of the LISTENER
------------------------
Alias MARS_P
Version TNSLSNR for IBM/AIX RISC System/6000: Version 19.0.0.0.0
- Production
Start Date 29-JUN-2024 23:56:31
Uptime 111 days 13 hr. 2 min. 48 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /grid_19c/oracle/Grid19CHome/network/admin/listener.ora
Listener Log File
/grid_19c/oracle/ora_base/diag/tnslsnr/ndc3vqaicpsdb06/mars_p/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ndc3vqaicpsdb06)(PORT=1526)))
Services Summary...
Service "CPOSQA" has 1 instance(s).
Instance "CPOSQA", status READY, has 1 handler(s) for this service...
The command completed successfully
[+ASM]@ndc3vqaicpsdb06:/home/oracle > lsnrctl status LISTENER
LSNRCTL for IBM/AIX RISC System/6000: Version 19.0.0.0.0 - Production on 19-OCT-

2024 13:00:15

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ndc3vqaicpsdb06)
(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for IBM/AIX RISC System/6000: Version 19.0.0.0.0
- Production
Start Date 29-JUN-2024 23:56:31
Uptime 111 days 13 hr. 3 min. 44 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /grid_19c/oracle/Grid19CHome/network/admin/listener.ora
Listener Log File
/grid_19c/oracle/ora_base/diag/tnslsnr/ndc3vqaicpsdb06/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ndc3vqaicpsdb06)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM", status READY, has 1 handler(s) for this service...
Service "+ASM_DG_CPOSQA_DATA" has 1 instance(s).
Service "+ASM_DG_CPOSQA_REDOCTL01" has 1 instance(s).
The command completed successfully
[+ASM]@ndc3vqaicpsdb06:/home/oracle > df -gt
Filesystem GB blocks Used Free %Used Mounted on
/dev/hd4 5.00 0.80 4.20 17% /
/dev/hd2 10.00 7.10 2.90 71% /usr
/dev/hd9var 10.00 1.77 8.23 18% /var
/dev/hd3 11.00 2.69 8.31 25% /tmp
/dev/hd1 5.00 0.12 4.88 3% /home
/dev/hd11admin 0.50 0.00 0.50 1% /admin
/proc - - - - /proc
/dev/hd10opt 5.00 2.28 2.72 46% /opt
/dev/livedump 0.50 0.00 0.50 1% /var/adm/ras/livedump
/dev/openv_lv 15.00 0.00 15.00 1% /usr/openv
/dev/Grid12c_lv 100.00 37.76 62.24 38% /Grid_12c
/dev/oracle_lv 100.00 28.49 71.51 29% /oracle
/dev/oracleadmdmp 100.00 1.02 98.98 2% /oracleadmindump
/dev/archive_lv 200.00 40.49 159.51 21% /archive
/dev/agent13c_lv 10.00 0.04 9.96 1% /agent13c
/dev/grid_19c_lv 150.00 37.60 112.40 26% /grid_19c
/dev/oracle_19c_lv 150.00 58.01 91.99 39% /oracle_19c
[+ASM]@ndc3vqaicpsdb06:/home/oracle > cd /archive
[+ASM]@ndc3vqaicpsdb06:/archive >
[+ASM]@ndc3vqaicpsdb06:/archive > mkdir ART_OCT2024
[+ASM]@ndc3vqaicpsdb06:/archive > cd ART_OCT2024
[+ASM]@ndc3vqaicpsdb06:/archive/ART_OCT2024 > pwd
/archive/ART_OCT2024
[+ASM]@ndc3vqaicpsdb06:/archive/ART_OCT2024 > cd
[+ASM]@ndc3vqaicpsdb06:/home/oracle > cd scripts
[+ASM]@ndc3vqaicpsdb06:/home/oracle/scripts >
[+ASM]@ndc3vqaicpsdb06:/home/oracle/scripts > sqlplus / as sysasm
SQL*Plus: Release 19.0.0.0.0 - Production on Sat Oct 19 13:03:12 2024

Version 19.17.0.0.0
@asm_dg
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.17.0.0.0
SQL> @asm_disk
GROUP_NUMBER NAME STATE TYPE TOTAL_MB

FREE_MB OFFLINE_DISKS
------------ ------------------------------ ----------- ------ ----------
---------- -------------
1 DG_CPOSQA_DATA MOUNTED EXTERN 1607544
171132 0
2 DG_CPOSQA_REDOCTL01 MOUNTED EXTERN 49152
47779 0
47779 0
49069 0
SQL>
GROUP_NUMBER DISK_NUMBER NAME MOUNT_S HEADER_STATU MODE_ST STATE
TOTAL_MB FREE_MB PATH
------------ ----------- -------------------- ------- ------------ ------- --------
---------- ---------- -------------------------
1 0 DG_CPOSQA_DATA_0000 CACHED MEMBER ONLINE NORMAL
267924 28516 /dev/ndc3vqaicpsdb06_CPOS
QA_ASM_data01

QA_ASM_data02

QA_ASM_data03

QA_ASM_data04

QA_ASM_data05
QA_ASM_data06
2 0 DG_CPOSQA_REDOCTL01_ CACHED MEMBER ONLINE NORMAL

0000
QA_ASM_redoctl01

0000
QA_ASM_redoctl02

0000
QA_ASM_redoctl03
9 rows selected.
SQL>
SQL>
SQL>
SQL> show parameter spfile
NAME TYPE VALUE

------------------------------------ ----------- ------------------------------
spfile string +DG_CPOSQA_DATA/ASM/ASMPARAMET
ERFILE/registry.253.968500545
SQL>
SQL>
SQL> create pfile='/archive/ART_OCT2024/initasm.ora' from spfile;
File created.
SQL> SQL>
SQL>
SQL>
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 -
Production
Version 19.17.0.0.0
[+ASM]@ndc3vqaicpsdb06:/home/oracle/scripts > ps -ef | grep pmon
oracle 18022806 24510760 0 13:03:32 pts/0 0:00 grep pmon
[+ASM]@ndc3vqaicpsdb06:/home/oracle/scripts > CPOSQA
ORACLE_SID is set to :- CPOSQA
ORACLE_HOME is set to :- /oracle_19c/oracle/ora_base/Ora19CHome
[CPOSQA]@ndc3vqaicpsdb06:/home/oracle/scripts > gg
ksh: gg: not found.
[CPOSQA]@ndc3vqaicpsdb06:/home/oracle/scripts > sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Sat Oct 19 13:03:43 2024

Version 19.20.0.0.0
@
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.20.0.0.0
SQL> name
NAME OPEN_MODE CONTROL

------------------------------ -------------------- -------
CPOSQA READ WRITE CURRENT
SQL>
SQL>
SQL>
SQL> @au
Enter value for username:
INST_ID DB User Logon Time Status SESS Program

OS User Machine Name EVENT MINS SQL_ID
---------- -------------------- -------------- ---------- ------------
--------------- ---------- --------------- -------------------- ----------
-------------
1 SYS 13:03 Oct/19 Active 4516,56515
SQLPLUS@NDC3VQA oracle Ndc3vqaicpsdb06 SQL*Net message to 0
3njz1uhxumypc
1 row selected.
SQL>
SQL>
SQL>
SQL>
SQL> @event
INST_ID EVENT COUNT(*)

---------- -------------------------------------------------- ----------
1 Streams AQ: qmn slave idle wait 1
1 Streams AQ: qmn coordinator idle wait 1
1 ASM cluster membership changes 1
1 PGA memory operation 1
1 heartbeat redo informer 1
1 smon timer 1
1 Data Guard: Timer 1
1 VKTM Logical Idle Wait 1
1 lreg timer 1
1 Streams AQ: waiting for time management or cleanup 1
tasks
1 AQPC idle 1
1 Data Guard: Gap Manager 1
1 VKRM Idle 1
1 ASM background timer 1
1 watchdog main loop 1
1 pman timer 1
1 DIAG idle wait 2
1 wait for unread message on broadcast channel 2
1 LGWR worker group idle 2
1 class slave wait 4
1 jobq slave wait 5
1 pmon timer 7
1 SQL*Net message from client 9
1 rdbms ipc message 23
1 Space Manager: slave idle wait 62
25 rows selected.
Enter value for event:
INST_ID SID USERNAME EVENT MACHINE

STATE SQL_ID SQL MINS SECS
------- ---------- -------------------- ------------------------- ------------
---------- ------------- ----------------------------------- ------- -----
1 4516 SYS SQL*Net message to client ndc3vqaicpsd
WAITED SHO 61jvnuzwct7g8 select distinct w.inst_id,w.sid,s 0 0
1 row selected.
SQL>
SQL>
SQL> @iu
Enter value for username:
DB User Logon Time Status SESS Program

OS User EVENT
-------------------- -------------- ---------- ------------
------------------------------ ---------- ----------------------
CPOSPROD 12:20 Oct/19 Inactive 294,37794 JDBC THIN CLIENT
webspher SQL*Net message from c
SQL*Net message from c
PREPDCRS 12:30 Oct/19 Inactive 4521,38410 JDBC THIN CLIENT
9 rows selected.
SQL> set pagesize 0

set lines 300
col name for a40
col value for a90
select name,value from v$parameter where name not like '\_%' escape '\' union
(select name,value from v$parameter where substr(name, 0,1) ='_');
create table PARAMETER_SEP_2024 as (select name,value from v$parameter where name
not like '\_%' escape '\' ) union (select name,value from v$parameter where
substr(name, 0,1) ='_');SQL> SQL> SQL> SQL> DBFIPS_140
FALSE
_aggregation_optimization_settings 0
_always_anti_join CHOOSE
_always_semi_join CHOOSE
_and_pruning_enabled TRUE
_b_tree_bitmap_plans TRUE
_bloom_filter_enabled TRUE
_bloom_folding_enabled TRUE
_bloom_pruning_enabled TRUE
_complex_view_merging TRUE
_compression_compatibility 11.2.0.0.0
_connect_by_use_union_all TRUE
_convert_set_to_join FALSE
_cost_equality_semi_join TRUE
_cpu_to_io 0
_dimension_skip_null TRUE
_eliminate_common_subexpr TRUE
_enable_type_dep_selectivity TRUE
_fast_full_scan_enabled TRUE
_first_k_rows_dynamic_proration TRUE
_gby_hash_aggregation_enabled TRUE
_generalized_pruning_enabled TRUE
_globalindex_pnum_filter_enabled TRUE
_gs_anti_semi_join_allowed TRUE
_improved_outerjoin_card TRUE
_improved_row_length_enabled TRUE
_index_join_enabled TRUE
_ksb_restart_policy_times 0, 60, 120, 240
_left_nested_loops_random TRUE
_local_communication_costing_enabled TRUE
_minimal_stats_aggregation TRUE
_mmv_query_rewrite_enabled TRUE
_new_initial_join_orders TRUE
_new_sort_cost_estimate TRUE
_nlj_batching_enabled 1
_optim_adjust_for_part_skews TRUE
_optim_enhance_nnull_detection TRUE
_optim_new_default_join_sel TRUE
_optim_peek_user_binds TRUE
_optimizer_adaptive_cursor_sharing TRUE
_optimizer_better_inlist_costing ALL
_optimizer_cbqt_no_size_restriction TRUE
_optimizer_coalesce_subqueries TRUE
_optimizer_complex_pred_selectivity TRUE
_optimizer_compute_index_stats TRUE
_optimizer_connect_by_combine_sw TRUE
_optimizer_connect_by_cost_based TRUE
_optimizer_connect_by_elim_dups TRUE
_optimizer_correct_sq_selectivity TRUE
_optimizer_cost_based_transformation LINEAR
_optimizer_cost_hjsmj_multimatch TRUE
_optimizer_cost_model CHOOSE
_optimizer_dim_subq_join_sel TRUE
_optimizer_distinct_agg_transform TRUE
_optimizer_distinct_elimination TRUE
_optimizer_distinct_placement TRUE
_optimizer_eliminate_filtering_join TRUE
_optimizer_enable_density_improvements TRUE
_optimizer_enable_extended_stats TRUE
_optimizer_enable_table_lookup_by_nl TRUE
_optimizer_enhanced_filter_push TRUE
_optimizer_extend_jppd_view_types TRUE
_optimizer_extended_cursor_sharing UDO
_optimizer_extended_cursor_sharing_rel SIMPLE
_optimizer_extended_stats_usage_control 192
_optimizer_false_filter_pred_pullup TRUE
_optimizer_fast_access_pred_analysis TRUE
_optimizer_fast_pred_transitivity TRUE
_optimizer_filter_pred_pullup TRUE
_optimizer_fkr_index_cost_bias 10
_optimizer_full_outer_join_to_outer TRUE
_optimizer_group_by_placement TRUE
_optimizer_improve_selectivity TRUE
_optimizer_interleave_jppd TRUE
_optimizer_join_elimination_enabled TRUE
_optimizer_join_factorization TRUE
_optimizer_join_order_control 3
_optimizer_join_sel_sanity_check TRUE
_optimizer_max_permutations 2000
_optimizer_mode_force TRUE
_optimizer_multi_level_push_pred TRUE
_optimizer_native_full_outer_join FORCE
_optimizer_new_join_card_computation TRUE
_optimizer_null_aware_antijoin TRUE
_optimizer_or_expansion DEPTH
_optimizer_order_by_elimination_enabled TRUE
_optimizer_outer_join_to_inner TRUE
_optimizer_outer_to_anti_enabled TRUE
_optimizer_push_down_distinct 0
_optimizer_push_pred_cost_based TRUE
_optimizer_rownum_bind_default 10
_optimizer_rownum_pred_based_fkr TRUE
_optimizer_skip_scan_enabled TRUE
_optimizer_sortmerge_join_inequality TRUE
_optimizer_squ_bottomup TRUE
_optimizer_star_tran_in_with_clause TRUE
_optimizer_system_stats_usage TRUE
_optimizer_table_expansion TRUE
_optimizer_transitivity_retain TRUE
_optimizer_try_st_before_jppd TRUE
_optimizer_undo_cost_change 11.2.0.4
_optimizer_unnest_corr_set_subq TRUE
_optimizer_unnest_disjunctive_subq TRUE
_optimizer_use_cbqt_star_transformation TRUE
_optimizer_use_feedback TRUE
_or_expand_nvl_predicate TRUE
_ordered_nested_loop TRUE
_parallel_broadcast_enabled TRUE
_partition_view_enabled TRUE
_pivot_implementation_method CHOOSE
_pre_rewrite_push_pred TRUE
_pred_move_around TRUE
_push_join_predicate TRUE
_push_join_union_view TRUE
_push_join_union_view2 TRUE
_px_minus_intersect TRUE
_px_partition_scan_enabled TRUE
_px_pwg_enabled TRUE
_px_ual_serial_input TRUE
_query_rewrite_setopgrw_enable TRUE
_remove_aggr_subquery TRUE
_replace_virtual_columns TRUE
_right_outer_hash_enable TRUE
_selfjoin_mv_duplicates TRUE
_sql_model_unfold_forloops RUN_TIME
_subquery_pruning_enabled TRUE
_subquery_pruning_mv_enabled FALSE
_table_scan_cost_plus_one TRUE
_trace_files_public TRUE
_union_rewrite_for_gs YES_GSET_MVS
_unnest_subquery TRUE
_use_column_stats_for_function TRUE
active_instance_count
adg_account_info_tracking LOCAL
adg_redirect_dml FALSE
allow_global_dblinks FALSE
allow_group_access_to_sga FALSE
allow_rowid_column_type FALSE
approx_for_aggregation FALSE
approx_for_count_distinct FALSE
approx_for_percentile none
aq_tm_processes 1
archive_lag_target 0
asm_diskstring
asm_preferred_read_failure_groups
audit_file_dest
/oracle_19c/oracle/ora_base/Ora19CHome/rdbms/audit
audit_sys_operations TRUE
audit_syslog_level
audit_trail DB
autotask_max_active_pdbs 2
awr_pdb_autoflush_enabled FALSE
awr_pdb_max_parallel_slaves 10
awr_snapshot_time_offset 0
background_core_dump partial
background_dump_dest
/oracle_19c/oracle/ora_base/Ora19CHome/rdbms/log
backup_tape_io_slaves FALSE
bitmap_merge_area_size 1048576
blank_trimming FALSE
blockchain_table_max_no_drop
buffer_pool_keep
buffer_pool_recycle
cdb_cluster FALSE
cdb_cluster_name
cell_offload_compaction ADAPTIVE
cell_offload_decryption TRUE
cell_offload_parameters
cell_offload_plan_display AUTO
cell_offload_processing TRUE
cell_offloadgroup_name
circuits
client_result_cache_lag 3000
client_result_cache_size 0
client_statistics_level TYPICAL
clonedb FALSE
clonedb_dir
cluster_database FALSE
cluster_database_instances 1
cluster_interconnects
commit_logging
commit_point_strength 1
commit_wait
commit_write
common_user_prefix C##
compatible 11.2.0.0.0
connection_brokers ((TYPE=DEDICATED)(BROKERS=1)),
((TYPE=EMON)(BROKERS=1))
container_data ALL
containers_parallel_degree 65535
control_file_record_keep_time 7
control_files
+DG_CPOSQA_REDOCTL01/cposqa/controlfile/current.256.970154281,
+DG_CPOSQA_REDOCTL02/cposqa
/controlfile/current.256.970154281,
+DG_CPOSQA_REDOCTL03/cposqa/controlfile/current.256.97
0154283
control_management_pack_access DIAGNOSTIC+TUNING
core_dump_dest
/oracleadmindump/CPOSQA/diag/diag/rdbms/cposqa/CPOSQA/cdump
cpu_count 32
cpu_min_count 32
create_bitmap_area_size 8388608
create_stored_outlines
cursor_bind_capture_destination memory+disk
cursor_invalidation IMMEDIATE
cursor_sharing EXACT
cursor_space_for_time FALSE
data_guard_max_io_time 240
data_guard_max_longio_time 240
data_guard_sync_latency 0
data_transfer_cache_size 0
db_16k_cache_size 0
db_2k_cache_size 0
db_32k_cache_size 0
db_4k_cache_size 0
db_8k_cache_size 0
db_big_table_cache_percent_target 0
db_block_buffers 0
db_block_checking FALSE
db_block_checksum TYPICAL
db_block_size 16384
db_cache_advice ON
db_cache_size 1073741824
db_create_file_dest
db_create_online_log_dest_1
db_domain
db_file_multiblock_read_count 64
db_file_name_convert
db_files 2000
db_flash_cache_file
db_flash_cache_size 0
db_flashback_retention_target 1440
db_index_compression_inheritance NONE
db_keep_cache_size 0
db_lost_write_protect NONE
db_name CPOSQA
db_performance_profile
db_recovery_file_dest /archive/FLASH
db_recovery_file_dest_size 107374182400
db_recycle_cache_size 0
db_securefile PERMITTED
db_ultra_safe OFF
db_unique_name CPOSQA
db_unrecoverable_scn_tracking TRUE
db_writer_processes 8
dbwr_io_slaves 0
ddl_lock_timeout 0
default_sharing metadata
deferred_segment_creation TRUE
dg_broker_config_file1
/oracle_19c/oracle/ora_base/Ora19CHome/dbs/dr1CPOSQA.dat
dg_broker_config_file2
/oracle_19c/oracle/ora_base/Ora19CHome/dbs/dr2CPOSQA.dat
dg_broker_start FALSE
diagnostic_dest /oracleadmindump/CPOSQA/diag
disable_pdb_feature 0
disk_asynch_io FALSE
dispatchers
distributed_lock_timeout 60
dml_locks 39704
dnfs_batch_size 4096
drcp_dedicated_opt YES
dst_upgrade_insert_conv TRUE
enable_automatic_maintenance_pdb TRUE
enable_ddl_logging FALSE
enable_dnfs_dispatcher FALSE
enable_goldengate_replication FALSE
enable_imc_with_mira FALSE
enable_pluggable_database FALSE
enabled_PDBs_on_standby *
encrypt_new_tablespaces CLOUD_ONLY
event
external_keystore_credential_location
fal_client
fal_server
fast_start_io_target 0
fast_start_mttr_target 300
fast_start_parallel_rollback LOW
file_mapping FALSE
fileio_network_adapters
filesystemio_options NONE
fixed_date
forward_listener
gcs_server_processes 0
global_names FALSE
global_txn_processes 1
hash_area_size 131072
heat_map OFF
hi_shared_memory_address 0
hs_autoregister TRUE
http_proxy
identity_provider_config
identity_provider_type NONE
ifile
ignore_session_set_param_errors
inmemory_adg_enabled TRUE
inmemory_automatic_level OFF
inmemory_clause_default
inmemory_expressions_usage ENABLE
inmemory_force DEFAULT
inmemory_max_populate_servers 0
inmemory_optimized_arithmetic DISABLE
inmemory_prefer_xmem_memcompress
inmemory_prefer_xmem_priority
inmemory_query ENABLE
inmemory_size 0
inmemory_trickle_repopulate_servers_perc 1
ent
inmemory_virtual_columns MANUAL
inmemory_xmem_size 0
instance_abort_delay_time 0
instance_groups
instance_mode READ-WRITE
instance_name CPOSQA
instance_number 0
instance_type RDBMS
instant_restore FALSE
java_jit_enabled TRUE
java_max_sessionspace_size 0
java_pool_size 318767104
java_restrict none
java_soft_sessionspace_limit 0
job_queue_processes 30
large_pool_size 218103808
ldap_directory_access NONE
ldap_directory_sysauth no
license_max_sessions 0
license_max_users 0
license_sessions_warning 0
listener_networks
lob_signature_enable FALSE
local_listener (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)
(HOST=10.94.134.27)(PORT=1526)))
lock_name_space
lock_sga FALSE
log_archive_config
log_archive_dest
log_archive_dest_1 LOCATION=/archive/CPOSQA
log_archive_dest_10
log_archive_dest_11
log_archive_dest_12
log_archive_dest_13
log_archive_dest_14
log_archive_dest_15
log_archive_dest_16
log_archive_dest_17
log_archive_dest_18
log_archive_dest_19
log_archive_dest_2
log_archive_dest_20
log_archive_dest_21
log_archive_dest_22
log_archive_dest_23
log_archive_dest_24
log_archive_dest_25
log_archive_dest_26
log_archive_dest_27
log_archive_dest_28
log_archive_dest_29
log_archive_dest_3
log_archive_dest_30
log_archive_dest_31
log_archive_dest_4
log_archive_dest_5
log_archive_dest_6
log_archive_dest_7
log_archive_dest_8
log_archive_dest_9
log_archive_dest_state_1 enable
log_archive_duplex_dest
log_archive_format CPOSDISHA_%t_%s_%r.arc
log_archive_max_processes 4
log_archive_min_succeed_dest 1
log_archive_start FALSE
log_archive_trace 0
log_buffer 16384000
log_checkpoint_interval 0
log_checkpoint_timeout 1800
log_checkpoints_to_alert FALSE
log_file_name_convert
long_module_action FALSE
max_auth_servers 25
max_datapump_jobs_per_pdb 100
max_datapump_parallel_per_job 50
max_dispatchers
max_dump_file_size 10240
max_idle_blocker_time 0
max_idle_time 0
max_iops 0
max_mbps 0
max_pdbs 254
max_shared_servers
max_string_size STANDARD
memoptimize_pool_size 0
memory_max_target 0
memory_target 0
min_auth_servers 1
multishard_query_data_consistency strong
multishard_query_partial_results not allowed
nls_calendar
nls_comp BINARY
nls_currency
nls_date_format YYYYMMDD-HH24.MI.SS
nls_date_language
nls_dual_currency
nls_iso_currency
nls_language AMERICAN
nls_length_semantics BYTE
nls_nchar_conv_excp FALSE
nls_numeric_characters .
nls_sort
nls_territory AMERICA
nls_time_format
nls_time_tz_format
nls_timestamp_format
nls_timestamp_tz_format
noncdb_compatible FALSE
object_cache_max_size_percent 10
object_cache_optimal_size 10240000
ofs_threads 4
olap_page_pool_size 0
one_step_plugin_for_pdb_with_tde FALSE
open_cursors 400
open_links 16
open_links_per_instance 4
optimizer_adaptive_plans TRUE
optimizer_adaptive_reporting_only FALSE
optimizer_adaptive_statistics FALSE
optimizer_capture_sql_plan_baselines FALSE
optimizer_dynamic_sampling 2
optimizer_features_enable 19.1.0
optimizer_ignore_hints FALSE
optimizer_ignore_parallel_hints FALSE
optimizer_index_caching 0
optimizer_index_cost_adj 100
optimizer_inmemory_aware TRUE
optimizer_mode choose
optimizer_real_time_statistics FALSE
optimizer_secure_view_merging TRUE
optimizer_session_type NORMAL
optimizer_use_invisible_indexes FALSE
optimizer_use_pending_statistics FALSE
optimizer_use_sql_plan_baselines TRUE
os_authent_prefix
os_roles FALSE
outbound_dblink_protocols ALL
parallel_adaptive_multi_user TRUE
parallel_degree_limit CPU
parallel_degree_policy MANUAL
parallel_execution_message_size 16384
parallel_force_local FALSE
parallel_instance_group
parallel_max_servers 5
parallel_min_degree 1
parallel_min_percent 0
parallel_min_servers 5
parallel_min_time_threshold AUTO
parallel_servers_target 5
parallel_threads_per_cpu 1
pdb_file_name_convert
pdb_lockdown
pdb_os_credential
pdb_template
permit_92_wrap_format TRUE
pga_aggregate_limit 18874368000
pga_aggregate_target 1073741824
plscope_settings IDENTIFIERS:NONE
plsql_ccflags
plsql_code_type INTERPRETED
plsql_debug FALSE
plsql_optimize_level 2
plsql_v2_compatibility FALSE
plsql_warnings DISABLE:ALL
pre_page_sga TRUE
private_temp_table_prefix ORA$PTT_
processes 6000
processor_group_name
query_rewrite_enabled true
query_rewrite_integrity TRUSTED
rdbms_server_dn
read_only_open_delayed FALSE
recovery_parallelism 0
recyclebin on
redo_transport_user
remote_dependencies_mode TIMESTAMP
remote_listener
remote_login_passwordfile EXCLUSIVE
remote_os_authent FALSE
remote_os_roles FALSE
remote_recovery_file_dest
replication_dependency_tracking FALSE
resource_limit TRUE
resource_manage_goldengate FALSE
resource_manager_cpu_allocation 0
resource_manager_plan
SCHEDULER[0xF064F]:DEFAULT_MAINTENANCE_PLAN
result_cache_max_result 5
result_cache_max_size 42958848
result_cache_mode MANUAL
result_cache_remote_expiration 0
resumable_timeout 0
rollback_segments
scheduler_follow_pdbtz FALSE
sec_case_sensitive_logon TRUE
sec_max_failed_login_attempts 5
sec_protocol_error_further_action (DROP,3)
sec_protocol_error_trace_action LOG
sec_return_server_release_banner FALSE
serial_reuse disable
service_names CPOSQA
session_cached_cursors 50
session_max_open_files 20
sessions 9024
sga_max_size 6174015488
sga_min_size 0
sga_target 0
shadow_core_dump partial
shared_memory_address 0
shared_pool_reserved_size 214748364
shared_pool_size 4294967296
shared_server_sessions
shared_servers 0
shrd_dupl_table_refresh_rate 60
skip_unusable_indexes TRUE
smtp_out_server
sort_area_retained_size 5242880
sort_area_size 65536
spatial_vector_acceleration FALSE
spfile
/oracle_19c/oracle/ora_base/Ora19CHome/dbs/spfileCPOSQA.ora
sql92_security TRUE
sql_trace FALSE
sqltune_category DEFAULT
ssl_wallet
standby_db_preserve_states NONE
standby_file_management MANUAL
standby_pdb_source_file_dblink
standby_pdb_source_file_directory
star_transformation_enabled FALSE
statistics_level TYPICAL
streams_pool_size 218103808
tablespace_encryption MANUAL_ENABLE
tape_asynch_io TRUE
target_pdbs 0
tde_configuration
temp_undo_enabled FALSE
thread 0
threaded_execution FALSE
timed_os_statistics 0
timed_statistics TRUE
trace_enabled TRUE
tracefile_identifier
transactions 9926
transactions_per_rollback_segment 10
undo_management AUTO
undo_retention 3600
undo_tablespace UNDO
unified_audit_common_systemlog
unified_audit_sga_queue_size 1048576
unified_audit_systemlog
uniform_log_timestamp_format TRUE
use_dedicated_broker FALSE
use_large_pages TRUE
use_sigio TRUE
user_dump_dest
/oracle_19c/oracle/ora_base/Ora19CHome/rdbms/log
wallet_root
workarea_size_policy AUTO
xml_db_events enable
xml_handling_of_invalid_chars raise_error
589 rows selected.
SQL>
Table created.
SQL>
SQL>
SQL> show parameter spfile
spfile string /oracle_19c/oracle/ora_base/Or
a19CHome/dbs/spfileCPOSQA.ora
SQL>
SQL>
SQL> create pfile='/archive/ART_OCT2024/initCPOSQA.ora' from spfile;
File created.
SQL>
SQL>
SQL> show parameter control
_optimizer_extended_stats_usage_cont integer 192
rol
_optimizer_join_order_control integer 3
control_file_record_keep_time integer 7
control_files string +DG_CPOSQA_REDOCTL01/cposqa/co
ntrolfile/current.256.97015428
1, +DG_CPOSQA_REDOCTL02/cposqa
/controlfile/current.256.97015
4281, +DG_CPOSQA_REDOCTL03/cpo
sqa/controlfile/current.256.97
0154283
control_management_pack_access string DIAGNOSTIC+TUNING
SQL>
SQL>
SQL> alter database backup controlfile to trace as
'/archive/ART_OCT2024/CPOSQA.ctl';
Database altered.
SQL>
SQL>
SQL> show parameter back
show parameter DISPATCHERS
show parameter SHARED_SERVERS
select * from v$diag_info;_optimizer_use_feedback boolean TRUE

background_core_dump string partial
background_dump_dest string /oracle_19c/oracle/ora_base/Or
a19CHome/rdbms/log
backup_tape_io_slaves boolean FALSE
db_flashback_retention_target integer 1440
fast_start_parallel_rollback string LOW
rollback_segments string
transactions_per_rollback_segment integer 10
SQL> dispatchers string
max_dispatchers integer
SQL> max_shared_servers integer
shared_servers integer 0
SQL> SQL>
1 Diag Enabled TRUE
0
1 ADR Base /oracleadmindump/CPOSQA/diag
0
1 ADR Home
/oracleadmindump/CPOSQA/diag/diag/rdbms/cposqa/CPOSQA
0
1 Diag Trace
/oracleadmindump/CPOSQA/diag/diag/rdbms/cposqa/CPOSQA/trace
0
1 Diag Alert
/oracleadmindump/CPOSQA/diag/diag/rdbms/cposqa/CPOSQA/alert
0
1 Diag Incident
/oracleadmindump/CPOSQA/diag/diag/rdbms/cposqa/CPOSQA/incident
0
1 Diag Cdump
/oracleadmindump/CPOSQA/diag/diag/rdbms/cposqa/CPOSQA/cdump
0
1 Health Monitor
/oracleadmindump/CPOSQA/diag/diag/rdbms/cposqa/CPOSQA/hm
0
1 Default Trace File
/oracleadmindump/CPOSQA/diag/diag/rdbms/cposqa/CPOSQA/trace/CPOSQA_ora_18022808.trc
0
1 Active Problem Count 1
0
1 Active Incident Count 2
0
1 ORACLE_HOME
/oracle_19c/oracle/ora_base/Ora19CHome
0
12 rows selected.
SQL>
SQL>
SQL> spool CPOSQA.txt
select name,open_mode from v$database;
select count(*) from dba_objects where status<>'VALID';
select owner,OBJECT_TYPE,count(*) from dba_objects where status<>'VALID' group by

owner,OBJECT_TYPE order by 1;
select status,count(*) from dba_indexes group by status;
select status,count(*) from dba_ind_partitions group by status;
select count(*) from dba_objects where status='INVALID';
create table sys.CPOSQA as select * from dba_objects where status='INVALID';
select OWNER,INDEX_NAME,TABLE_OWNER,TABLE_NAME from dba_indexes where

status='UNUSABLE';
select INDEX_OWNER,INDEX_NAME,PARTITION_NAME from dba_ind_partitions where

STATUS='UNUSABLE';SQL> SQL> CPOSQA READ WRITE
1 row selected.
SQL> SQL> 294
1 row selected.
SQL> SQL> CPOSPROD

MATERIALIZED VIEW 31
CPOSPROD
PROCEDURE 7
DISHADEVDM
PROCEDURE 1
DISHAUAT
PROCEDURE 1
SYS
TDAUDIT01
TDCRS01
TDCRS05
TDPRIM01_CPOSPROD
PACKAGE BODY 2
TDPRIM01_CPOSPROD
PROCEDURE 4
TDPRIM01_CPOSPROD
VIEW 1
TDREPORTS
PACKAGE 2
TDREPORTS
PACKAGE BODY 2
TDREPORT_CPOSPROD
PROCEDURE 1
TDSEC
FUNCTION 1
TDSEC
TDSEC01_CPOSPROD
PROCEDURE 3
TDWPS01_WPRCS
MATERIALIZED VIEW 1
Z2_CRS
Z2_CRS
PROCEDURE 2
Z2_PRIM
Z2_PRIM
PROCEDURE 1
22 rows selected.
SQL> SQL> N/A 1769

VALID 30905
2 rows selected.
SQL> SQL> USABLE 23993

N/A 8709
2 rows selected.
SQL> SQL> 294
1 row selected.
SQL> SQL>
Table created.
SQL> SQL>
no rows selected
SQL> SQL>
no rows selected
SQL>
SQL>
SQL>
SQL>
SQL>
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 -
Production
Version 19.20.0.0.0
[CPOSQA]@ndc3vqaicpsdb06:/home/oracle/scripts >
Connection to 10.94.134.27 closed.

10.94.134.27 ART

Uploaded by

Copyright:

Available Formats

10.94.134.27 ART

Uploaded by

Document Information

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

10.94.134.27 ART

Uploaded by

Copyright:

Available Formats

[]@ndc3vpaoemdb01:/home/oracle > ssh 10.94.134.

oratab file /etc/oratab found.

Alias for CPOSQA environment variables is set to CPOSQA

oracle 7143720 1 0 Jun 29 - 1:42 asm_pmon_+ASM

[]@ndc3vqaicpsdb06:/home/oracle > ASM

SQL*Plus: Release 19.0.0.0.0 - Production

[+ASM]@ndc3vqaicpsdb06:/home/oracle > hostname

# Internet Address Hostname # Comments

LSNRCTL for IBM/AIX RISC System/6000: Version 19.0.0.0.0 - Production on 19-OCT-

Copyright (c) 1991, 2022, Oracle. All rights reserved.

LSNRCTL for IBM/AIX RISC System/6000: Version 19.0.0.0.0 - Production on 19-OCT-

Copyright (c) 1991, 2022, Oracle. All rights reserved.

SQL*Plus: Release 19.0.0.0.0 - Production on Sat Oct 19 13:03:12 2024

Copyright (c) 1982, 2022, Oracle. All rights reserved.

GROUP_NUMBER NAME STATE TYPE TOTAL_MB

1 1 DG_CPOSQA_DATA_0001 CACHED MEMBER ONLINE NORMAL

1 2 DG_CPOSQA_DATA_0002 CACHED MEMBER ONLINE NORMAL

1 3 DG_CPOSQA_DATA_0003 CACHED MEMBER ONLINE NORMAL

1 4 DG_CPOSQA_DATA_0004 CACHED MEMBER ONLINE NORMAL

2 0 DG_CPOSQA_REDOCTL01_ CACHED MEMBER ONLINE NORMAL

3 0 DG_CPOSQA_REDOCTL02_ CACHED MEMBER ONLINE NORMAL

4 0 DG_CPOSQA_REDOCTL03_ CACHED MEMBER ONLINE NORMAL

NAME TYPE VALUE

SQL*Plus: Release 19.0.0.0.0 - Production on Sat Oct 19 13:03:43 2024

Copyright (c) 1982, 2022, Oracle. All rights reserved.

NAME OPEN_MODE CONTROL

INST_ID DB User Logon Time Status SESS Program

INST_ID EVENT COUNT(*)

Enter value for event:

INST_ID SID USERNAME EVENT MACHINE

DB User Logon Time Status SESS Program

SQL> set pagesize 0

589 rows selected.

select * from v$diag_info;_optimizer_use_feedback boolean TRUE

select count(*) from dba_objects where status<>'VALID';

select owner,OBJECT_TYPE,count(*) from dba_objects where status<>'VALID' group by

select status,count(*) from dba_indexes group by status;

select status,count(*) from dba_ind_partitions group by status;

select count(*) from dba_objects where status='INVALID';

create table sys.CPOSQA as select * from dba_objects where status='INVALID';

select OWNER,INDEX_NAME,TABLE_OWNER,TABLE_NAME from dba_indexes where

select INDEX_OWNER,INDEX_NAME,PARTITION_NAME from dba_ind_partitions where

SQL> SQL> 294

SQL> SQL> CPOSPROD

SQL> SQL> N/A 1769

SQL> SQL> USABLE 23993

SQL> SQL> 294

You might also like