feiflyv / coco Goto Github PK
View Code? Open in Web Editor NEWmy code ! my style!
my code ! my style!
要使用jmx链接到远程机器步骤
1.修改远程机器jdk的配置文件
a.进入JAVA_HOME\jre\lib\management\目录
b.拷贝jmxremote.password.template这个文件到当前目录, 并改名为jmxremote.password
c.打开jmxremote.password文件,去掉 # monitorRole QED 和 # controlRole R&D 这两行前面的注释符号
2.修改远程机器上需要被监控的程序的配置文件
a.添加启动参数
JAVA_OPTS="$JAVA_OPTS -Djava.rmi.server.hostname=192.168.0.237
-Dcom.sun.management.jmxremote.port=18999
-Dcom.sun.management.jmxremote.ssl=false
-Dcom.sun.management.jmxremote.authenticate=false"
查看表空间的用户表信息
select t1.username as "username", t1.default_tablespace as "tablespace", t1.temporary_tablespace as "temporary_tablespace", to_char(t1.created,'YYYY-MM-DD hh24:mi:ss') as "create_time", round((select tt1. bytes from dba_data_files tt1 where tt1.tablespace_name=t1.default_tablespace)/1024/1024) as "tablespace_total(M)", (select round(sum(tt1.bytes)/1024/1024) from dba_free_space tt1 where tt1.TABLESPACE_NAME=t1.default_tablespace) "tablespace_free(M)", (select tt1.file_name from dba_data_files tt1 where tt1.tablespace_name=t1.default_tablespace) as "tablespace_file", (select tt1.file_name from dba_temp_files tt1 where tt1.tablespace_name=t1.temporary_tablespace) as "temporary_tablespace_file" from dba_users t1 where t1.default_tablespace not in ( 'SYSTEM', 'SYSAUX', 'EXAMPLE') --and t1.username like '%WST%' order by t1.default_tablespace asc, t1.username asc;
创建表空间和用户
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google ❤️ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.