[root@redhat8 ~]# ./Py_OracleCheck --host 172.16.108.101 --user system --password oracle --port 1521 --server ncloans_primary
用法
1、客户端安装cx_Oracle、prettytable库
2、命令用法
./Py_OracleCheck
--host IP地址 --user 用户 --password 密码 --port 端口 --server 服务名
3、python3开发
100.退出
数据库用户profile配置信息
| Porfile | Resource_name | Resource_type | Limit |
| DEFAULT | COMPOSITE_LIMIT | KERNEL | UNLIMITED |
| DEFAULT | SESSIONS_PER_USER | KERNEL | UNLIMITED |
| DEFAULT | CPU_PER_SESSION | KERNEL | UNLIMITED |
| DEFAULT | CPU_PER_CALL | KERNEL | UNLIMITED |
| DEFAULT | LOGICAL_READS_PER_SESSION | KERNEL | UNLIMITED |
| DEFAULT | LOGICAL_READS_PER_CALL | KERNEL | UNLIMITED |
| DEFAULT | IDLE_TIME | KERNEL | UNLIMITED |
| DEFAULT | CONNECT_TIME | KERNEL | UNLIMITED |
| DEFAULT | PRIVATE_SGA | KERNEL | UNLIMITED |
| DEFAULT | FAILED_LOGIN_ATTEMPTS | PASSWORD | 10 |
| DEFAULT | PASSWORD_LIFE_TIME | PASSWORD | 180 |
| DEFAULT | PASSWORD_REUSE_TIME | PASSWORD | UNLIMITED |
| DEFAULT | PASSWORD_REUSE_MAX | PASSWORD | UNLIMITED |
| DEFAULT | PASSWORD_VERIFY_FUNCTION | PASSWORD | NULL |
| DEFAULT | PASSWORD_LOCK_TIME | PASSWORD | 1 |
| DEFAULT | PASSWORD_GRACE_TIME | PASSWORD | 7 |
100.退出
数据库scn信息
| Time | SCN | FreeDay_Scn |
| 2020-07-30 18:45:21 | 14609961 | 12251.68 |
100.退出
| lock_user | lock_sid | serial# | sql_id | row_wait_obj# | wait_class | event | p1 | p2 | p3 | seconts_int_wait | blocking_instance |
100.退出
[主机:172.16.108.101 数据库:ncloans_primary]:
如果觉得我的文章对您有用,请点赞。您的支持将鼓励我继续创作!
赞0
添加新评论0 条评论