今天查看了一些oracle的dba相关视图，特别转载至此备查，不过这些视图里的相关字段代表什么意思还不是很清楚，oracle官方手册应该可以查的吧。
oracle维护了一种“虚拟”表的集合记录当前数据库的活动。这些表称为动态性能表。数据库管理员可以基于这些表执行查询和创建视图等操作。不能被数据库管理员修改和删除。
最有用的DBA视图
DBA_DATA_FILES 关于数据库的信息
DBA_DB_LINKS 数据库中的所有数据库链路
DBA_EXTENTS 数据库中包括的所有分区
DBA_FREE_SPACE 所有表空间中自由分区
DBA_INDEXES 数据库中所有索引的描述
DBA_IND_COLUMNS 在所有表及聚集上压缩索引的列
DBA_OBJECTS 数据库中所有的对象
DBA_ROLLBACK_SEGS 回滚段的描述
DBA_SEGMENTS 为所有数据库段分配的存储空间
DBA_SEQUENCES 数据库中所有序列数的描述
DBA_SYNONYMS 数据库中所有同义词
DBA_TABLES 数据库中所有表的描述
DBA_TABLESPACES 数据库中所有表空间的描述
DBA_TAB_COLUMNS 所有表描述、视图以及聚集的列
DBA_TAB_GRANTS 数据库中的对象所授予的权限
DBA_TAB_PRIVS 数据库中的对象所授予的权限
DBA_TS_QUOTAS 所有用户表空间限额
DBA_USERS 关于数据库的所有用户信息
DBA_VIEWS 数据库中所有视图的文本
最有用的V$视图
V$datafile 数据库使用的数据文件信息，如控制文件信息
V$librarycache 共享池中SQL语句的管理信息
V$lock 通过访问数据库会话设置对象锁的有关信息。当某个用户修改数据库中的数据时，使用加锁以防止另一个用户做同样的修改。
V$log 从控制文件中提取有关重做日志组的信息
V$logfile 有关实例重做日志组文件名及其位置的信息
V$parameter 初始化参数文件中所有项的值
V$process 当前进程的信息
V$rollname 回滚段信息
V$rollstat 联机回滚段统计信息
V$rowcache 内存中数据字典活动/性能信息
V$session 有关活动会话的信息
V$sesstat 在V$session中报告当前会话的统计信息
V$sqlarea 共享池中使用当前光标的统计信息，光标是一块内存区域，由oracle处理SQL语句时打开
V$statname 在V$sesstat中报告的各个统计的含义
V$sysstat 基于当前操作会话进行的系统统计
V$waitstat 出现一个以上会话访问数据库的数据时的详细情况。当有一个以上的会话同时访问相同的信息时，可能出现等待的情况。
the roads are torn up by construction,…
or you find your self seeing some new parts of the country that is no way related to where you are suppose to be going. well your worries are over, new technology is here to help us destination challenged individuals. having…
Sites We Like…
[...]just below, are some totally unrelated sites to ours, however, they are definitely worth checking out[...]…
dutasteride might aid in hair loss by…
blocking the production or binding of a natural substance inside the scalp hair follicles. although not fda approved in females, it has been used “off-label” in females with androgenic hair loss who are not pregnant or planning to become pregnant alt…
is this game’s strength. you have 90…
playable levels that can keep you playing for hours. you have an level editor thats surprisingly pretty deep. you can put many hours into soccer bashi.soccer bashi is an old school style block smasher game with a nice amount of content….
supplement with food will eliminate the problem….
research of dim’s safety has shown no harmful effects, even when the doses were at hundreds of times the amount provided in the supplements. a common side effect of dim is a harmless changing of the color of your urine. because…
you can always use coupons to start…
a positive change and take care of your money better. with their use, you can get all the items that you want and need around the house at a discounted price. you can find lots of supermarket coupons on toiletries, laundry…
unevenly. this could be an indication of…
being out of balance, worn shocks, or another issue.please drive safe and cautiously. happy driving! since i was a kid i loved the fresh, crisp taste of lobster. i am sure you do as well or you would not be here….
the oven broiler. using a very sharp…
knife, cut each tail in half lengthwise. stop when you reach the back end of the tail. peel the lobster meat back off the shells. place the lobster tails in a broiler pan and set aside for now. melt the butter…
syrup. abstain from consuming antibiotics since it…
eliminates the good bacteria which stop yeast infection. likewise, the hormonal contraceptives can also disturb the ph level of the vagina making it difficult on how to treat a yeast infection correctly.holistic treatment – going natural is the only wa…
a number of very effective natural ways…
to treat candida in men. some of these include the use of natural yogurt, tea tree oil or even garlic which is prepared in a number of ways. these natural solutions will treat the root cause of candida in men and…
importance of high-resolution cannot be overrated. in…
a standard lcd laptop screen, for example, the standard resolution is 60 hz where this is fine. however, when you increase the size of the screen by almost 300 percent the resolution is important. as screen size increases, lcd-based flat screen…
competitors.3) shipping costs on the risethe united…
states postal service continues to shut down branches all the time while raising prices. but many sites have a way around this unfortunate development: they offer free shipping with the purchase of more product. so, in effect, consumers will continue t…
options and your needs. find out what…
solutions are available in your particular case. there may be more than you realize. the worst thing you can do is to do nothing. an attorney will offer guidance to you throughout this process and help ensure that you are making…
radiation, the amount used in the smoke…
alarm is tiny. it won’t hurt you. simply follow the manufacturer’s directions for use. when you replace your smoke alarm, make sure to dispose of it properly.photoelectric detectors smoky fires can occur when, for example, a couch is smoldering insid…
the bowels to remove fatty material, which…
stores toxins and impurities.burdock root: burdock root has multiple purposes within the body for a powerful detox. it is an excellent blood purifier, stimulates bile secretion in the liver, and facilitates digestive processes. burdock root decreases t…
yes today i’m going to give you…
a very good reason to stop and the solution for how to stop. you may say you don’t care what anybody thinks, but come on, down deep we both know better. let’s talk about love and how smoking affects your love…
a pcl driver is the same colour…
as your background if you use a ps driver.the image on screen may not look like much (as often the eps graphic may only have a 1 bit preview or a very low grade black and white image) but the printed…
all the interaction with the outside world…
even with the nearest ones. lacks of appetite or high appetite, low self esteem, sleeplessness, weakness, fatigue are the symptoms that follow depression.herbal remedies for depressionantidepressants are the most commonly prescribed drugs to treat pers…
you might end up selling your property…
at lower market price.not too much time and money is involved when you list as for sale by owner in flat fee mls. for listing in mls you just need to populate enough information for your property and click some images…
at a longer duration (jogging at 10km/hr…
for 30 minutes), your body will burn a higher percentage of body fat as opposed to if you are working out at higher intensities (running at 15km/hr for 10 minutes). while it is true that lower intensities help you burn more…
a folding action and stretches the connective…
tissues under the skin. endermologie reduces the appearance of cellulite.another massage technique is acoustic wave therapy. this technique uses pressure waves to penetrate the skin and underlying fat. it improves the skin’s elasticity and thickens th…
and things were very easy. those days…
are now long gone and you will not have a business unless you put in the time and effort. there are a number of tasks involved in internet marketing. one of them is link building and it will do wonders for…
also boasts of avenues lined with magnificent…
and awesome oak trees.the driveways and etched herons on the front doors are another trademark characteristic of the houses. one can also enjoy panoramic views of the marshes and the river. the beautiful oak point golf course isn’t too far away….
the world for websites that carries advertisements.through…
adwords, google has successfully created the most effective and targeted forms of marketing and advertising in the history. by the use of google adwords you can access millions of audience within a few seconds and get the attention of an appropriate…
services to provide products for a variety…
of extreme environments; road maintenance: to provide road maintenance program, increased by extending the tire life and reduce tire purchases to help customers reduce overall operating costs of tires. statistics show that good road tire maintenance ca…
included in the release is newsworthy and…
not too much of a sales pitch.• reel the reader in. you need to make sure that the reader is hooked from the beginning so include the interesting information at the start. let the reader know right from the start why…
that you refer to both before and…
after you write your plan.easy to readto be effective in communicating your message to interested parties your plan should be easy to read. it must be able to be understood by anyone who has to read it. keep your writing style…
some former patients that have had some…
concerns going through metal detection devices that the machines can possibly cause some loosening of the prosthesis feeling that there is some magnetic component involved. there is absolutely no evidence of this at this time and really should not be a…
a size chart allowing you to see…
if they have the shoes you want in the right size. while looking fashionable is important if you can avoid hurting yourself in the process then this is ideal.it is worth checking the product descriptions as they give you an idea…
tip that is an allowable deduction on…
the amount received. however, the tax return form does not have a place to capture these deductions that are relating to the amounts on the 1099k form.irs to release further instructionshowever, even as the irs released the new tax return form…
of problems while shopping for wedding ring…
then you do not need to worry at all. here are provided a few things that should be kept in mind while shopping for one of the best rings available in the market.firstly, you should set your budget that can be…
chance your license is going to get…
suspended for refusing to submit to the test.so it seems as though the decision is between keeping your license and having it suspended? that makes the choice easy, right? not so fast, my friend. there are many factors to consider when…
is unique, it is difficult to judge…
precisely what the new interest rate will become. generally speaking, the new rate will be the weighted average of the current loan rates. for example, if a borrower has two loans with a seven percent interest rate and three loans with…
case the problem gets worse.you might have…
a hearing problem if you do some of the following:you avoid social settingsif you’ve been avoiding social outings because of your hearing, you must visit a hearing centre. a hearing aid audiologist will ask you about your hearing problems and will…
amenities along with residence appointments you would…
expect pricing to be prohibitive, but with open air floor plans running around 1,500 square feet, price points are around the $380,000 to $450,000 range.opportunities to own longboat key real estate are out there and portobello offers tremendous value …
your case will be heard. as every…
state in the united states is responsible for their own laws and legislation, you need a lawyer who is familiar with that state’s law in regards to dui.ask around friends and family for recommendations or search online through the many legal…
and more efficient food preparation and cleaning….
these faucets also have high reach sprouts. this makes washing large and deep kitchenware easier. some models also come with the ceramic cartridge technology. this allows exact temperature adjustment of the water. the temperature ranges from cold to wa…