npm install -g npm-check-updates # 安装 npm-check-updates
ncu --loglevel verbose --packageFile package.json # 查看
ncu -u --packageFile package.json # 更新配置
npm install # 删除node_modules目录,重新下载依赖
# help
https://github.com/raineorshine/npm-check-updates/issues/136
-- 查看表空间物理文件的名称及大小
SELECT tablespace_name, file_id, file_name, round(bytes / (1024 * 1024), 2) total_space
FROM dba_data_files ORDER BY tablespace_name;
-- 表空间占用情况
SELECT a.segment_name, b.table_name, sum(a.bytes)/ 1024 / 1024 AS mb
FROM dba_segments a LEFT JOIN dba_lobs b ON a.segment_name = b.segment_name
WHERE a.tablespace_name = 'DSPACE' GROUP BY a.segment_name, b.table_name ORDER BY mb DESC;
-- 查询所有用户所对应的表空间,有dba权限的帐号,如sys,system