- 博客(268)
- 收藏
- 关注
Oracle中的常用权限视图
1.角色的权限视图role_tab_privs:角色的对象权限role_role_privs:角色的所属角色role_sys_privs:角色的系统权限2.用户的权限视图dba_tab_privs:用户的对象权限dba_role_privs:用户的所属角色dba_sys_privs:用户的系统权限3.当前用户的权限视图session_privs:当前用户的所有权限u...
2013-01-30 11:12:00 530
SQL语句中的case when语法以及Oracle中的类似方法
一、基本概念和例子case when是sql语句的语法,而不是属于特定数据库的语言方法一:select num,name,(case classnowhen '1' then '一班'when '2' then '二班'else '其他班级'end) as classnamefrom student方法二:select num,name,(casewhen ...
2013-01-30 10:36:00 300
微软认证考试70-461-Create Database Objects(创建数据库对象)-24%比重
附注:微软认证考试70-461范围Create Database Objects创建数据库对象 (24%)Work with Data数据处理 (27%)Modify Data数据修改 (24%)Troubleshoot & Optimize故障排解及SQL优化 (25%)本文是第一节Create Database Objects创建数据库对象。第一部分:Create ...
2013-01-29 10:42:00 253
Oracel函数收集(笔记)
substring(xx,start_index,end_index) //获取字符串xx从start_index到end_index的子串instr(xx,aa,start_index,end_index)//定位,从字符串xx中查找aa,查找范围从start_index到end_index,如果start_index为-1,表示反向查找定位lower(xx)//变成小写upper(...
2013-01-29 10:25:00 166
js判断file文本域中待上传文件的大小与尺寸
以下直接粘贴到记事本中,给后缀改为html即可运行##################################################<input name="txtImg" type="file" id="txtImg" /><input name="btnUploadImg" type="button" id="btnUplo
2013-01-29 10:17:00 228
SQL Server 存储过程概述
存储过程概述 系统存储过程是SQLServer 2012系统创建的存储过程,它的目的在于能够方便地从系统表中查询信息,或者完成与更新数据库表相关的管理任务或其他的系统管理任务。Transact-SQL语句是SQLServer 2012数据库与应用程序之间的编程接口。在很多情况下,一些代码会被开发者重复编写多次,如果每次都编写相同功能的代码,不但繁琐,容易出错,而且由于SQLServe...
2013-01-29 09:41:00 235
关于生产库上索引碎片收集的问题 <整理 from askmaclean >
问题描述:环境:oracle10.2.0.5 RAC+HP-UX用analyze index <index_name> validate structure这个语句可以验证索引的碎片程度,然后通过index_stats视图来查询,请问这个语句在生产库上对于比较大的索引使用这个语句,对系统的影响有多大?FYI:analyze index <index_name>...
2013-01-28 22:50:00 86
Note 452067.1 &n…
原文地址:Note<wbr>452067.1<wbr><wbr>"How<wbr>to<wbr>Configure<wbr>"kdump"<wbr>on&amp;nb</wbr></wbr>&l
2013-01-28 22:11:00 95
solaris 11 下安装VMwar…
Manually Install or Upgrade VMware Tools in a Solaris VirtualMachine<wbr><br>1.On the host, from the Workstation menu bar, select VM &gt;Install VMware Tools.<br>If an e...
2013-01-28 22:11:00 104
Start/stop Oracle&nbs…
原文地址:Start/stop<wbr>Oracle<wbr>database<wbr>as<wbr>a<wbr>Linux<wbr>Service</wbr></wbr></wbr></wbr></wbr
2013-01-28 22:11:00 129
Linux与Solaris比较 <转载>
Linux与Solaris比较<wbr></wbr>Linux和Solaris的优缺点比较已经被讨论过很多次了…… Linux和Solaris的优缺点比较已经被讨论过很多次了。本文也将涉及到Solaris和Linux的一些优缺点,包括最新的发展趋势,比如OpenSolaris等。回到Solaris还需要付费购买专用版权的时候,那时候关于Li...
2013-01-28 22:11:00 213
一个在win下关于配置监听端口的有…
<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr>&
2013-01-28 22:10:00 94
9i 可选后台进程术语解释
9i 可选后台进程术语解释ARCn: ArchiverCJQ0: Coordinator Job Queue background processDnnn: DispatcherLCKn: RAC Lock Manager–Instance LocksLMDn: RAC DLM Monitor–Remote LocksLMON: RAC DLM Monitor–Global L...
2013-01-28 22:10:00 108
SCAN,VIP,HAIP,etc.
©OraInternals<wbr> Riyaj Shamsudeen<br>SCAN,VIP,HAIP,etc.<br>By<br>Riyaj Shamsudeen<br>Blog:<wbr>orainternals.wordpress.com<wbr><br>©O
2013-01-28 22:10:00 109
(转)ORACLE WITH AS 用法
原文地址:(转)ORACLE<wbr>WITH<wbr>AS<wbr>用法</wbr></wbr></wbr>作者:jingyun先举个例子吧:有两张表,分别为A、B,求得一个字段的值先在表A中寻找,如果A表中存在数据,则输出A表的值;如果A表中不存在,则在B表中寻找,若B表中有相应记录,则输出B表的值...
2013-01-28 22:10:00 109
HP-ux oracle 10.2.0.4&…
from itpub 一个帖子,简要整理;如题oracle目录下产生大量的.trc .trm文件(非常多非常多的),现在oralce目录已经满了100%,-rw-rw---- 1 oracle dba 93 Oct 17 04:09 orcl_j001_9226.trm-rw-rw---- 1 oracle dba 606 Oct 1 03:56 orcl_j001_9227.tr...
2013-01-28 22:10:00 109
Oracle Database …
up!原文地址:Oracle<wbr>Database<wbr>12C<wbr>New<wbr>Feature</wbr></wbr></wbr></wbr>作者:Hello顾问1、Cross-Platform BACKUPand RESTORE ,这个增强很有用
2013-01-28 22:10:00 110
SEC_CASE_SENSITIVE_LOGON 参数
beginning with Oracle Database 11g Release 1, database passwordsare case-sensitive. (You candisable case sensitivity and return to pre–Release 11g<wbr> behavior by setting the<wbr>...
2013-01-28 22:10:00 111
使用adrci查看hm report
[oracle@oracle11g hm]$ adrciADRCI: Release 11.2.0.1.0 - Production on Tue Oct 23 06:59:562012Copyright (c) 1982, 2009, Oracle and/or itsaffiliates.<wbr> All rights reserved.<br><...
2013-01-28 22:10:00 112
Rename RAC Database&lt…
Rename RACDatabasefrom:http://oracleinstance.blogspot.com/2012/01/rename-rac-database.html<wbr></wbr>Here is the document to renameRAC database and next post we c...
2013-01-28 22:10:00 114
ORA-00600: internal er…
Oracle数据库断电后不能打开的解决 数据库突然断电后,不能打开。或者偶尔能打开,但是很快就关闭。 原因可能很多。但是解决问题只有一种办法:看trace日志,alert错误日志 简单写下我的解决过程: 1,在alert日志中: 错误如下两种: ORA-00600: internal error code, arguments: [4193], [1526],[1...
2013-01-28 22:10:00 114
ocp11考纲
Oracle Database 11g: Administration WorkshopI<wbr></wbr><wbr></wbr>(5 days)<wbr></wbr>Description<wbr></wbr>This course is designed t
2013-01-28 22:10:00 122
how to do with a slow oracle dat…
数据库慢一般有三种情况 1.逐渐变慢 2.突然变慢 3.不定时变慢 第一种情况 “逐渐变慢”,要建立一个长期的监控机制。比如,写个shell脚本每天的忙时(通常9~10etc.)定时收集os,network,db的信息, 每个星期出report对收集到的信息进行分析。这些数据的积累,可以决定后期的优化决策,并且可以是DBA说服manager采用自己决策的重要数据。D...
2013-01-28 22:10:00 124
scn 与 timestamp的相互转换
SQL> select * from v$version;BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 -ProductionPL/...
2013-01-28 22:10:00 125
触发DBWn写的条件-from 9i sg
DBWn defers writing to the data files until one of thefollowing events occurs:? Incremental or normalcheckpoint? The number of dirty buffers reaches a threshold value? A process scans a specif...
2013-01-28 22:10:00 128
oracle 11.2.0.3 for&nb…
https://updates.oracle.com/Orion/Services/download/p10404530_112030_Linux-x86-64_1of7.zip?aru=14125322&patch_file=p10404530_112030_Linux-x86-64_1of7.ziphttps://updates.oracle.com/Orion/Servi...
2013-01-28 22:10:00 133
RMAN在非归档模式下的增量备份和恢…
<wbr><h3><span><a href="http://blog.csdn.net/ilovemilk/article/details/4700736">RMAN在非归档模式下的增量备份和恢复</a></span></h3><div><
2013-01-28 22:10:00 138
script for Tablespace&…
Tablespace InformationHere are some scripts related to Tablespace Information .InformationTABLESPACE INFORMATION NOTES:Tablespace Name - Name of the tablespaceInitial Extent - Default init...
2013-01-28 22:10:00 140
oracle11g OMF 特性与添…
22:40:02 SQL> select member from v$logfile;MEMBER--------------------------------------------------------------------------------/u01/app/oracle/oradata/MYNEWDB/onlinelog/o1_mf_3_88745ykl_....
2013-01-28 22:10:00 146
oracle 常见v$视图整理
1.查看备份,恢复性能V$BACKUP_SYNC_IOV$BACKUP_ASYNC_IO2.? V$IR_FAILURE:List of all failures, including closed ones (result of the LISTFAILUREcommand)? V$IR_MANUAL_CHECKLIST:<wbr>List of manual a...
2013-01-28 22:10:00 152
在Eclipse中设置Oracle的JDBC
在Eclipse中设置Oracle的JDBC<wbr> .</wbr>第一步:找到jdbc驱动我用的oracle自带的,ORACLE_HOME]\jdbc\lib\下面有各种jdbc,一定要注意兼容问题,具体看第二步,分别用哪个文件。第二步:把驱动的路径加在环境变量classpath内- Add [ORACLE_HOME]\jdbc\lib\classes...
2013-01-28 22:10:00 191
IBM小机+ORACLE数据库迅猛提升事物…
http://www.itpub.net/thread-1751449-1-1.html<wbr></wbr>环境说明:AIX P740,AIX VERSION 6,16 core 3.55GHZ的CPU,32GMEM,3块千M网卡BOND。V7000中端存储 80G 的CACHE。12块LOG 盘。最够多的数据盘。ORACLE11.2.0.3 单机非R...
2013-01-28 22:10:00 247
ORA-4031 and Shared&nb…
ORA-4031 and Shared Pool<wbr>Duration</wbr>Posted by Riyaj Shamsudeen on August6, 2009After reading my earlier post on shared pool A stroll through shared pool heap , one of my c...
2013-01-28 22:10:00 255
AIX 64 11.0.2.3.0
<wbr><a href="https://updates.oracle.com/Orion/Services/download/p10404530_112030_Linux-x86-64_1of7.zip?aru=14125322&amp;patch_file=p10404530_112030_Linux-x86-64_1of7.zip">https://...
2013-01-28 22:10:00 259
如何在90天内学会一门语言
<wbr><wbr> 如何在90天内学会一门语言</wbr></wbr><wbr><br><wbr><wbr><wbr>“用他人懂的语言与之谈话,只能交流;用他人的母语与之谈话,便可交心。”——纳尔逊·曼德拉</wbr>
2013-01-28 22:10:00 260
impdp将不同路径下的dump文件同时…
-------->>>>from otn made by MacLean.liuSQL> create directory dir1 as 'D:\dir1';<wbr><br>Directory created.<br><wbr><br>SQL&gt; create d
2013-01-28 22:10:00 281
RHEL all versions download
Index of /uingei/http://rhel.ieesee.net/uingei/../ASMLib/ 06-Mar-2012 12:00 -dell/ ...
2013-01-28 22:10:00 347
asm_diskstring 参数的设置使用
<wbr>ASM_DISKSTRINGInitialization Parameter<a name="sthref84"></a><a name="sthref85"></a></wbr>Note:Only Automatic Storage Management instance
2013-01-28 22:10:00 483
hot patching
<wbr><wbr><strong>hotpatching</strong></wbr></wbr><wbr>It does not require database instanceshutdown.<br><wbr>It can detect
2013-01-28 22:09:00 62
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人