- 浏览: 25998 次
- 性别:
- 来自: 北京
最新评论
FAQS
- 博客分类:
- oracle
1.How can I get the largest amount of physical reads by any query?
select disk_reads, sql_text from v$sqlarea where disk_reads >1000 order by disk_reads desc ;
This view displays all dynamic performance tables, views, and derived tables in the database
3.What is the difference between V$ and GV$ , also V$and V_$,X$?
These “$” views are called dynamic performance views. They are continuously updated while a database is open and in use, and their contents relate primarily to performance.
The actual dynamic performance views are identified by the prefix V_$. Public synonyms for these views have the prefix V$. You should access only the V$ objects, not the V_$ objects.
For almost every V$ view, Oracle has a corresponding GV$ (global V$) view. In addition to the V$ information, each GV$ view contains an extra column named INST_ID of datatype NUMBER. The INST_ID column displays the instance number from which the associated V$ view information was obtained.
X$ is table, is drived table.
4.How do you find out the unix process id of a database session?
Some times you might want to get the unix process details of a database session. You have the Oracle session details. Just map them with paddr column from v$process ! You're done.
e.g.
SQL> select p.spid from v$session s, v$process p where s.sid=16 and s.paddr=p.addr
SPID
---------
16750
5.
发表评论
-
from string get number data using pl/sql or sql
2012-02-16 17:32 853declare @aa varchar(80),--- ... -
SQL
2012-02-15 18:01 6841.select sal salary from emp; ... -
modify ip
2012-02-10 17:45 7561.netconfig 2./etc/sysconfig/n ... -
MULTI dbwr or io slaves
2012-02-10 15:21 848thanks dukope of itpub. ... -
HOW TO STUDY ORACLE FROM Yong Huang
2012-01-18 14:48 767Assuming you want to study orac ... -
RMAN
2012-01-14 17:07 6591.components of the rman ... -
INSTANCE and CRASH RECOVERY
2012-01-12 10:12 7181.type of checkpoint full c ... -
STARTUP PFILE=
2011-12-31 14:11 11221.vi initdbs.ora spfile=&quo ... -
MANAGE TABLE
2011-12-26 16:50 5361.heap table IOT PARTI ... -
MONITOR redo size
2011-12-21 17:48 6181.set autot on stat 2.unsin ... -
What do rollback and commit
2011-12-21 11:21 708When we COMMIT, all that is lef ... -
What is the schema ?
2011-12-20 15:18 557A schema is a collection of dat ... -
MANAGE UNDOTABS
2011-12-19 17:15 6551.manual undo_management=ma ... -
DBA SQL
2011-12-19 15:21 4131.select a.name,b.status from v ... -
SEGMENT EXTENTS ORACLEBLOCK
2011-12-15 16:11 7611.SEGMENT: allocated fo ... -
MANAGE TABLESPACE AND DATAFILES
2011-12-13 15:28 5401. tablespace,segment,extent,bl ... -
ORACLE NET
2011-12-12 09:49 6581.net_service_name: servive ... -
SQLPLUS TIPS
2011-12-09 17:51 8691.SQLPLUS : a tool that execute ... -
ORACLE ENVIRONMENT VARIABLES
2011-12-09 17:15 626ORACLE_HOME ORACLE_SID : or ... -
Exam Test1
2011-12-09 16:18 6101.utl_file_dir: indicate the di ...
相关推荐
C.Programming.FAQs_C语言常见问题集C.Programming.FAQs_C语言常见问题集C.Programming.FAQs_C语言常见问题集C.Programming.FAQs_C语言常见问题集C.Programming.FAQs_C语言常见问题集C.Programming.FAQs_C语言常见...
C+programming+FAQs C+programming+FAQs C+programming+FAQs C+programming+FAQs
借花献佛,推荐一本好书:Marshall P. Cline著的《C++ FAQs》[Cline 1995]。你看了后一定会赞不绝口。
Laravel开发-faqs 常见问题解答
Official Eclipse 3.0 Faqs
C.Programming.FAQs_C语言常见问题集 免费下载
C Programming - Just the FAQS,C语言编程的FAQ,描述C语言编程的注意事项
C++ FAQs [By Marshall Cline, Greg Lomow, Mike Girou] 英文版,很经典的书
款使用CSS3和jQuery来制作的FAQs问答垂直手风琴列表UI设计效果 演示地址:http://www.jq22.com/jquery-info7842
C++ FAQs PDF版,看CSDN中的都是网页版,看着不舒服,上传一个PDF版供大家下载,本身需要该书,所以内容已亲自验证过没问题
C语言相关的经典书籍 《你必须知道的495个C语言问题》/《C 语言常见问题集》/《C Programming FAQs: Frequently Asked Questions》
Addison Wesley的C++ FAQs,写的很不错,可以看看!
Programming FAQs: Frequently Asked Questions'' (Addison-Wesley, 1995, ISBN 0-201-84519-9) is made available here by permission of the author and the publisher as a service to the community. It is ...
这是C++里面一些常见的问题,我对此进行了筛选和整理,希望与大家分享。。。
C语言介绍(英文)作者Paul S. R. Chisholm
The C Language This chapter focuses on some basic elements of the C programming language. When you begin programming in C, you probably will find yourself coming up with basic questions ...
escpos相关的指令和FAQ 官方下的
C++.FAQs.Second.Edition 免费下载,欢迎下载
会编写C++/C 程序,不要因此得意洋洋,这只是程序员基本的技能要求而已。如果把系统分析和系统设计比作“战略决策”,那么编程充其量只是“战术”。英文版