![](https://img-blog.csdnimg.cn/20201014180756926.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
数据库
zjfirehole
这个作者很懒,什么都没留下…
展开
-
oracle基础知识
[size=large]oracle备份命令:[/size] set ph=g:\数据库备份\ exp irdp/123456@orcl_127.0.0.1 owner=(irdp) file=%ph%irdp_bak_%date:~0,10%.dmp log=%ph%irdp_bak_%date:~0,10%.log C:\Progra~1\WinRAR\rar a %ph%irdp...原创 2011-10-11 11:24:10 · 83 阅读 · 0 评论 -
oracle管理性能语句
[size=large]查看用户为user的session[/size] select * from gv$session t where t.USERNAME='user'; [size=large]根据用户来统计session数量[/size] select count(1),username from gv$session t group by username [size=...原创 2011-10-11 11:26:56 · 74 阅读 · 0 评论