189 8069 5689
用数据字典
网站建设哪家好，找创新互联公司！专注于网页设计、网站建设、微信开发、微信小程序开发、集团企业网站建设等服务项目。为回馈新老客户创新互联还提供了库车免费建站欢迎大家使用！
select
*
from
dba_users;
查看数据库里面所有用户，前提是你是有dba权限的帐号，如sys,system
select
*
from
all_users;
查看你能管理的所有用户！
select
*
from
user_users;
查看当前用户信息
！
Linux查看系统信息的一些命令及查看已安装软件包的命令（转)：
系统
# uname -a # 查看内核/操作系统/CPU信息
磁盘和分区
# mount | column -t # 查看挂接的分区状态
# fdisk -l
服务
# chkconfig --list # 列出所有系统服务
#chkconfig --list | grep on # 列出所有启动的系统服务
oracle 补丁CVE编号怎么查？
任何软件都会有补丁，补丁的作用一般都是 修复bug或者安全问题，对于oracle 11g也不例外。 同时oracle的补丁属于商业软件的一部分，需要购买了oracle ps服务才能下载。
进入ORACLE_HOME下面的OPatch目录，执行opatch lsinventory查看已经应用的补丁
sys@NGACselect * from v$version ;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE 11.2.0.3.0 Production
TNS for Linux: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production
或者
[oracle@svr-ww-ora02 OPatch]$ $ORACLE_HOME/OPatch/opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.0
Copyright (c) 2012, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/11gr2/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11gr2/db_1/oraInst.loc
OPatch version : 11.2.0.3.0
OUI version : 11.2.0.3.0
Log file location : /u01/app/oracle/product/11gr2/db_1/cfgtoollogs/opatch/opatch2014-01-03_16-46-01PM_1.log
Lsinventory Output file location : /u01/app/oracle/product/11gr2/db_1/cfgtoollogs/opatch/lsinv/lsinventory2014-01-03_16-46-01PM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (1):
Oracle Database 11g 11.2.0.3.0
There are 1 products installed in this Oracle Home.
Interim patches (1) :
Patch 14275605 : applied on Tue Oct 30 13:12:42 CST 2012
Unique Patch ID: 15367368
Patch description: "Database Patch Set Update : 11.2.0.3.4 (14275605)"
Created on 3 Oct 2012, 18:38:19 hrs PST8PDT
Sub-patch 13923374; "Database Patch Set Update : 11.2.0.3.3 (13923374)"
Sub-patch 13696216; "Database Patch Set Update : 11.2.0.3.2 (13696216)"
Sub-patch 13343438; "Database Patch Set Update : 11.2.0.3.1 (13343438)"
Bugs fixed:
14480676, 13566938, 13419660, 10350832, 13632717, 14063281, 12919564
13624984, 13430938, 13467683, 13588248, 13420224, 14548763, 13080778
12646784, 13804294, 12861463, 12834027, 13377816, 13036331, 12880299
14664355, 13499128, 14409183, 12998795, 12829021, 13492735, 12794305
13503598, 10133521, 12718090, 13742433, 12905058, 12401111, 13742434
13257247, 12849688, 13362079, 12950644, 13742435, 13464002, 12917230
13923374, 12879027, 14613900, 12585543, 12535346, 14480675, 12588744
11877623, 14480674, 13916709, 12847466, 13773133, 14076523, 13649031
13340388, 13366202, 13528551, 13981051, 12894807, 13343438, 12582664
12748240, 12797765, 13385346, 12923168, 13384182, 13612575, 13466801
13484963, 12971775, 11063191, 13772618, 13070939, 12797420, 13035804
13041324, 12976376, 11708510, 13742437, 13737746, 14062795, 13035360
12693626, 13742438, 13326736, 13332439, 14038787, 14062796, 12913474
13001379, 14390252, 13099577, 13370330, 13059165, 14062797, 14275605
9873405, 13742436, 9858539, 14062794, 13358781, 12960925, 13699124
12662040, 9703627, 12617123, 13338048, 12938841, 12658411, 12620823
12845115, 12656535, 14062793, 12678920, 12764337, 13354082, 13397104
14062792, 13250244, 12594032, 9761357, 12612118, 13742464, 13550185
13457582, 13527323, 12780983, 12583611, 13502183, 12780098, 13705338
13696216, 13476583, 11840910, 13903046, 13572659, 13718279, 13554409
13657605, 13103913, 14063280
--------------------------------------------------------------------------------
OPatch succeeded.
我不记得sql可以直接查询patch，因为补丁一般都是针对oracle数据库软件的。