forked from oracle/python-cx_Oracle
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathdrcp_query.sql
More file actions
22 lines (15 loc) · 866 Bytes
/
drcp_query.sql
File metadata and controls
22 lines (15 loc) · 866 Bytes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
-------------------------------------------------------------------------------
-- drcp_query.sql (Section 2.4 and 2.5)
-------------------------------------------------------------------------------
/*-----------------------------------------------------------------------------
* Copyright (c) 2017, 2021, Oracle and/or its affiliates. All rights reserved.
*---------------------------------------------------------------------------*/
set echo off verify off feedback off linesize 80 pagesize 1000
accept pw char prompt 'Enter database password for SYSTEM: ' hide
accept connect_string char prompt 'Enter database connection string: '
-- Connect to the CDB to see pool statistics
connect system/&pw@&connect_string
col cclass_name format a40
-- Some DRCP pool statistics
select cclass_name, num_requests, num_hits, num_misses from v$cpool_cc_stats;
exit