docker 创建oracle数据库实例
https://www.muzhuangnet.com/show/79311/2.html
创建容器的时候注意要把日志目录挂载到D盘:
docker run -p 1521:1521 -v d:/cdc_logs/oracle:/cdc_logs --name oracle_11g -d --restart=always jaspeen/oracle-xe-11g
配置cdc(x-stream)
https://nightlies.apache.org/flink/flink-cdc-docs-master/zh/docs/connectors/cdc-connectors/oracle-cdc/
PS:
select * from all_users
select count(*) from v$process ; --当前的数据库连接数
select value from v$parameter where name ='processes'; --数据库允许的最大连接数
select count(*) from v$session --当前的session连接数
select * from v$session where status = 'ACTIVE'; --并发连接数
select osuser, a.username, cpu_time/executions/1000000||'s', b.sql_text, machine
from v$session a, v$sqlarea b
where a.sql_address =b.address
order by cpu_time/executions desc; --查看当前有哪些用户正在使用数据