oracle中的 v$database是什么意思啊

oracle中的 v$database是什么意思啊,第1张

desc v$database

名称 是否为空 类型

----------------------------------------------------------------- -------- -------------

DBID NUMBER

NAME VARCHAR2(9)

CREATED DATE

RESETLOGS_CHANGE# NUMBER

RESETLOGS_TIME DATE

PRIOR_RESETLOGS_CHANGE# NUMBER

PRIOR_RESETLOGS_TIME DATE

LOG_MODE VARCHAR2(12)

CHECKPOINT_CHANGE# NUMBER

ARCHIVE_CHANGE# NUMBER

CONTROLFILE_TYPE VARCHAR2(7)

CONTROLFILE_CREATED DATE

CONTROLFILE_SEQUENCE# NUMBER

CONTROLFILE_CHANGE# NUMBER

CONTROLFILE_TIME DATE

OPEN_RESETLOGS VARCHAR2(11)

VERSION_TIME DATE

OPEN_MODE VARCHAR2(10)

PROTECTION_MODE VARCHAR2(20)

PROTECTION_LEVEL VARCHAR2(20)

REMOTE_ARCHIVE VARCHAR2(8)

ACTIVATION# NUMBER

SWITCHOVER# NUMBER

DATABASE_ROLE VARCHAR2(16)

ARCHIVELOG_CHANGE# NUMBER

ARCHIVELOG_COMPRESSION VARCHAR2(8)

SWITCHOVER_STATUS VARCHAR2(20)

DATAGUARD_BROKER VARCHAR2(8)

GUARD_STATUS VARCHAR2(7)

SUPPLEMENTAL_LOG_DATA_MIN VARCHAR2(8)

SUPPLEMENTAL_LOG_DATA_PK VARCHAR2(3)

SUPPLEMENTAL_LOG_DATA_UI VARCHAR2(3)

FORCE_LOGGING VARCHAR2(3)

PLATFORM_ID NUMBER

PLATFORM_NAME VARCHAR2(101)

RECOVERY_TARGET_INCARNATION# NUMBER

LAST_OPEN_INCARNATION# NUMBER

CURRENT_SCN NUMBER

FLASHBACK_ON VARCHAR2(18)

SUPPLEMENTAL_LOG_DATA_FK VARCHAR2(3)

SUPPLEMENTAL_LOG_DATA_ALL VARCHAR2(3)

DB_UNIQUE_NAME VARCHAR2(30)

STANDBY_BECAME_PRIMARY_SCN NUMBER

FS_FAILOVER_STATUS VARCHAR2(21)

FS_FAILOVER_CURRENT_TARGET VARCHAR2(30)

FS_FAILOVER_THRESHOLD NUMBER

FS_FAILOVER_OBSERVER_PRESENT VARCHAR2(7)

FS_FAILOVER_OBSERVER_HOST VARCHAR2(512)

2、字段说明

DBID:数字形式的DB标识,会记录在每个数据文件头,可以根据这个来确定数据文件是属于哪一个数据库

NAME:数据库名称(就是通俗的数据库名)

DB_UNIQUE_NAME:?

RESETLOGS_CHNAGE#:上一次resetlogs时的scn

RESETLOGS_TIME:上一次resetlogs的时间

PRIOR_RESETLOGS_CHANGE#:更早的(最早的?)restlogs时的scn

PRIOR_RESETLOGS_TIME:更早的(最早的?)restlogs时的scn

LOG_MODE:是否是归档模式,有三种可能(noarhivelog|archivelog|manual)

CHECKPOINT_CHANGE#:上一次checkpoint的scn,这个值是从控制文件中来的。

ARCHIVE_CHANGE#:表示在这个scn之前的(比这个scn小)redolog都将会自动强制归档。

CONTROLFILE_TYPE:standby表示这个数据库在standby模式;clone表示这个数据库是个clone的数据库;backup|created表示这个数据库正在从使用备份的控制文件恢复中;current表示数据库是正常模式

CONTROLFILE_CREATED:控制文件创建的时间

CONTROLFILE_SEQUENCE#:控制文件的一个递增的序列号,用途不明

CONTROLFILE_CHANGE#:控制文件中记录的scn

CONTROLFILE_TIME:上一次控制文件更新的时间

OPEN_RESETLOGS:指示下一次打开数据库是是否需要使用resetlogs来打开,可能为(not allowed|allowed|required)

VERSION_TIME:版本时间(意义不明,用途不明)

OPEN_MODE:指示数据库以什么方式打开(read only|read write|mount)

PROTECTION_MODE:数据库的保护模式(似乎在dataguard的情况下有用)

PROTECTION_LEVEL:保护等级

REMOTE_ARCHIVE:是否允许远程归档,就是remote_archive_enable初始化参数的值

ACTIVATION#:?

SWTICHOVER#:?

DATABASE_ROLE:指示数据库是logical standby|physical standby|primary

ARCHIVELOG_CHNAGE#:上一次归档动作结束时的scn,也就是最新的归档日志的所记录的最后一个SCN(根据文档也就是v$archived_log里最大的next_change#),要注意于archive_change#的区别

ARCHIVELOG_COMPRESSION:归档的压缩状况

SWITCHOVER_STATUS:switch over 的状态

DATAGUARD_BROKER:Indicates whether the Data Guard configuration is being managed by the broker (ENABLED) or not (DISABLED)

GUARD_STATUS:防止数据库修改的状态(可能为all或者none或者standby)

SUPPLEMENTAL_LOG_DATA_MIN:

SUPPLEMENTAL_LOG_DATA_PK:如果为YES则表示当有主键的表更新行时,会将组成主键的所有列也记入redo log

SUPPLEMENTAL_LOG_DATA_UI:如果为YES则表示当有unqiue键的表更新行时,会将组成unique键的所有列也记入redo log

SUPPLEMENTAL_LOG_DATA_FK:同上(记录foreign key)

SUPPLEMENTAL_LOG_DATA_ALL:同上(记录所有fix_width maximun size column)

FORCE_LOGGING:指示数据库是否在force logging模式

PLATFORM_ID: *** 作系统平台ID

PLATFORM_NAME: *** 作系统平台名称

RECOVERY_TARGET_INCARNATION#:恢复时从哪一个场景号进行恢复(每次使用resetlogs打开数据库会创建一个新的场景号)

LAST_OPEN_INCARNATION:最后一次打开的场景号

CURRENT_SCN:数据库当前的SCN

STANDBY_BECAME_PRIMARY_SCN:SCN at which a physical standby database became a primary database

FLASHBACK_ON:是否打开了flashback 功能

FS_FAILOVER_STATUS:

FS_FAILOVER_CURRENT_TARGET:

FS_FAILOVER_THRESHOLD:

FS_FAILOVER_OBSERVER_PRESENT:

FS_FAILOVER_OBSERVER_HOST:

3、可以查询的东西

a、是否是归档模式

b、flashback功能是否打开

c、当前系统的scn

d、当前数据库的DBID、NAME、Unique Name

e、checkpoint的相关信息

f、归档日志的相关信息

g、controlfile的相关信息:创建日期、controlfile里记录的scn,

h、数据库是什么时候创建的

i、数据库所在 *** 作系统平台信息

4、易混淆的列

name和db_unique_name

archive_change#和archivelog_change#

阿努比斯的愤怒[大]

中文名称:阿努比斯的愤怒[大]

英文名称:Incarnation of Anubis' Wrath

数据库文件:records\item\relics\03_act2_anubiswrathdbr

难度:传奇

镶嵌位置:所有武器

需要等级:41

单片属性:

4% 攻击伤害转换为自身生命值增加

完整属性:

12% 攻击伤害转换为自身生命值增加

合成奖励及几率:

14634146% +35% 攻击速度 (records\item\lootmagicalaffixes\suffix\default\character_speedattack_04dbr)

7317073% +50% 伤害对 恶魔 (records\item\lootmagicalaffixes\suffix\default\offensive_+%damage to demons_01dbr)

7317073% +50% 伤害对 亡灵 (records\item\lootmagicalaffixes\suffix\default\offensive_+%damage to undead_01dbr)

21951220% 50% 机率发动 30 秒眩晕 (records\item\lootmagicalaffixes\suffix\default\offensive_stun_03dbr)

7317073% 7 ~ 16 伤害 (records\item\lootmagicalaffixes\relics\bonuses\offensive_damagebonus_05dbr)

7317073% 7 ~ 16 火焰伤害 (records\item\lootmagicalaffixes\relics\bonuses\offensive_damagefire_05dbr)

6097561% 72 法力吸取在30秒内 (records\item\lootmagicalaffixes\prefix\default\offensive_leechmana_03dbr)

21951220% 147 生命值吸取在30秒内 (records\item\lootmagicalaffixes\prefix\default\offensive_leechlife_05dbr)

6097561% 66% 减慢攻击 持续 30 秒 (records\item\lootmagicalaffixes\prefix\default\offensive_reducedattackspeed_03dbr)

特定BOSS或地点掉率(初次):

传奇 阿克提欧斯 ~ 泰肯族(埃及) 12620192%

传奇 曼提克 ~ 传说中的野兽 12620192%

传奇 尼亥泊克 ~ 蝎子王 10007710%

传奇 沙漠圣甲虫之王 9420553%

传奇 均衡之手任务  9420553%

传奇 沙之鬼魂领主 ~ 沙漠的噩梦 9420553%

传奇 堤丰 ~ 神的祸根3652274%

传奇 龙骸 ~ 亡灵之王2533955%

传奇 欧迈诺司 ~ 泰肯族(东方)2533955%

传奇 班德瑞 ~兵马俑术士 1989659%

传奇 妖怪 ~ 远古的邪牛 1866783%

传奇 奇美拉 1866783%

传奇 巴布伦 ~ 穴居人的高级督军 1866783%

传奇 巨型雪人  1866783%

传奇 魈 ~ 巨型蝠猴 1073328%

特定BOSS或地点掉率(重复):

传奇 曼提克 ~ 传说中的野兽 12620192%

传奇 阿克提欧斯 ~ 泰肯族(埃及) 12620192%

传奇 堤丰 ~ 神的祸根3652274%

传奇 均衡之手任务  2598244%

传奇 沙漠圣甲虫之王 2598244%

传奇 沙之鬼魂领主 ~ 沙漠的噩梦 2598244%

传奇 龙骸 ~ 亡灵之王2533955%

传奇 欧迈诺司 ~ 泰肯族(东方)2533955%

传奇 尼亥泊克 ~ 蝎子王 1242702%

传奇 奇美拉 0501793%

传奇 巨型雪人  0501793%

传奇 巴布伦 ~ 穴居人的高级督军 0501793%

传奇 妖怪 ~ 远古的邪牛 0501793%

传奇 班德瑞 ~兵马俑术士 0238981%

传奇 魈 ~ 巨型蝠猴 0119562%

普通怪物掉率前十:

传奇 豺狼人 ~ 狂战士0398406%

传奇 豺狼人 ~ 老练的狂战士 0398406%

传奇 沙丘袭击者 ~ 精锐掠夺者0278884%

传奇 沙丘袭击者 ~ 老练的掠夺者 0278884%

传奇 沙丘袭击者 ~ 掠夺者0278884%

传奇 亵渎的死尸 ~ 火焰 *** 纵者0265604%

传奇 杀人蝎 0222045%

传奇 不朽的死者 ~ 守护者0210359%

传奇 豺狼人 ~ 狂战士0210359%

传奇 豺狼人 ~ 老练的狂战士 0210359%

摘自《泰坦多元立方》电子书

"A man is not made for defeat A man can be destroyed, is he" - the old man and the sea

Personal attention-seeking means everyone is longing for his ability to get others to his attention, the mentality

Hemingway 1899 was born in America, his life character, brave, strong combative have a strong tendency of personal heroism In Europe, gun battle In the African jungle to catch ferocious beast, in the ring to master the challenge Also in his fiction is full of war, fighting, love sport, and tourism The author of the character of his works is the old man and the sea ", in this work embodies a confident, daring to challenge the fate of courage, show the fighting spirit This work was huge, even as the church sermons

Actually, Hemingway's works in many so-called "heroics" composition, more is the bursting of the emotion, Hemingway other piece like "the sun also rises," "A farewell to arms", "short fiction works", the "garden of Eden", "A Movable Feast" etc, can say "and" personal attention-seeking "almost touch on edge

You can then consider the topic If the old man and the sea ", the following reference analysis

Outstanding performance:

One is to human life Look! The roar of the shark, aggressive resembles, but not a ChuiMu into the old man! Old man with despair, hunger in battle, heart always in silently thoughtfully: people were not born to overthrow It is one of life's tenacity and strong embody!

2 is the ultimate meaning of life works Consider, old man with hunger, cold, dark, don't say to work by a fishbone empty Man is completely cut off line is easy, but he has no! He is in trouble with the strong competition in battle,! YuSiWangPo rather too obstinate Old man and the sea and in the volatile, completed the people's life force Here is the success in said: "life is born, the brilliance of itself, not in a dead results - - - - - - - - the heel in cardiac alive!

Three QuanZhu work is the concept of "success" The win on the material can be secular sense of success, but not necessarily successful life If the life as a business to succeed, then, the life first should be perfect personality Xiang is a loser, but he is recognized as the hero, Liu, but still seized by one as "surabaya rogue" If the solemn, farewell to the significance of human birth

Four works embodies the spirit of America's western values and Adventure and heroics usually for the beauty of the old man, San Diego small fishing boat to upload the mayflower "in" the same spirit, namely: can I failed, but you destroy me, I always strive for a breakthrough Reason: the nationality of works for the works of a worldwide

5 is the work presents a new dialogue between man and nature "The old man and the sea" dialogue ", is weak and strong, loneliness and noise, winning and losing dialogue, it is different from the dialogue with the island, Crusoe is some life Shark, the sea is spoiled, and the spirit of land for long People in turbulent waves, and in living in the region, is absolutely called

6 is the product of work is personified This course should brush, chicheng frankly As is known to all, Hemingway's life in nature, good adventure Challenge vitality He thought, no power of life He hates to human desires, lust, and love, he often bypass the crowd around, magical place hunting, war, piao sentiment Because of this, he mentally alone in the sea as fighting with the old man of sharks However, he was born, until picked a secular evil theory with empty, only to double fishbone tube rifle issued a warning to the world

limitations

This is a novel, but also can take it as a fable Hemingway sing out here to humans fighting spirit stubborn The novel is optimistic note and the end Through the boy will once again with a new man, to fight and a new hope

But, of course, we should also realize that as a bourgeois individual Hemingway's limitations He neither see, see the way society, the strength of the masses, he is in a weak foothold to personal struggle spirit came Consequently, he failed to hero is only the hero The old man and the sea "optimism is wide dark a glimmer of the air, and throughout the is a melancholy throughout the pain

The old man is a real image, or if the employee is but a critics say a laborer appearance of Hemingway's intellectuals We think that is a - the true image of laborer, though, may be slightly The writer is a true to his characters will simply as his mouthpiece If Santiago only cosmetic of Hemingway, this novel won't have such power of moving Santiago's thoughts and feelings and not beyond him such a laborer of thoughts and feelings He in the boundless sea battle with fish, fish that will both as the enemy and as a brother's mood, should be understood and experience In Hemingway's this old man is not a profound social content, but are faithful and true

But the old man Santiago is a writer Ernest Hemingway's shadow His son Gregory Hemingway wrote in a memoir, "Hemingway's hero is Hemingway himself, or his best" This is right We work in some of the many characters are seen writers of his own shadow But, in the novel "the old man and the sea", we felt in the thoughts and feelings with Hemingway, Santiago is more closely together, he loves him, sing praises to him, he entered the ", "the old man in the sea, feeling and sentiment is he to experience In a sense, and from a certain Angle, the old man is Hemingway incarnation But this is not to say ahead of us is a real art image that conflict

In YiJiuErLiuNian, Hemingway published "the sun also rises," in this novel, he expressed in the first world war, the part of the American young intellectuals deep despair of reality He therefore "lost generation" of the identity of the representative by notice, and some people will this novel as a "lost generation" declaration Since then, he has been in his life and society He attended the struggle against Spain franco His works have exposed in the dark, capitalism had antifascist enthusiasm His sympathy for China's Anti-Japanese War He is a serious, right-minded writer But, he always can not out of the circle, and individualism, never get rid of pessimism Although "lost generation" as a literary genre in in the 1930s has collapsed, after the age from thought, said Hemingway is still a "lost" From the surface, Hemingway is a made great achievements, Fraser shatter his reputation, status, money He is bold and unconstrained, open-minded, generous But another Hemingway that he didn't see the real human way And, as in war, it had a few times impaired his health And he is old, writing more and more difficult His heart is depressed, YiYu, doleful In the boundless hugecrowd struggle, ups The old man and the sea "is his soul essence of certain things He not only in the old Santiago's body to his life on the feeling, also be the heroic man to motivate yourself as the example

42

According to his son, Hemingway later in writing up has less easily "The past is a water Wells, and now have the water pump he is no longer poet, he became a workman, blame your destiny, sigh he's going into entangles! � times first-come-first-served basis of dam Lei if ⊙ based Ge He lie � his genius and back, which gives birth to a masterpiece (refers to the old man and the sea"), although not quite, but the scale, insight, and full of love and truth" Anyway, we can agree on the subject, because love, because of the ground with object close together, is the novel can obtain some achievements and can move one of the important reasons -- but generally he is getting on in writing So he had to say such words: "I wrote the book I can't finish line" "I've been in this damned desk before but I can't write out It's not written You know, I can't" His son say: "he always tries to win He was lost, the" He's an old friend Malcolm, says: "if he can't write, he didn't want to live" In 1961, with a rifle bullets ended his life I'm afraid I can't just explain for disease, it should also praised his old Santiago heroism another expression However, we can also be considered that in the boundless huge crowd to struggle, the individual heroes who toil in a bell, their personal power loss after all, just to see more hope

以上就是关于oracle中的 v$database是什么意思啊全部的内容,包括:oracle中的 v$database是什么意思啊、不朽王座遗物。 我想知道遗物阿努比斯的愤怒遗物碎片在哪里掉落,知道的朋友告诉我下,网上找遍资料都没有、跪求 论《老人与海》英雄主义 英语论文等相关内容解答,如果想了解更多相关内容,可以关注我们,你们的支持是我们更新的动力!

欢迎分享,转载请注明来源:内存溢出

原文地址: http://outofmemory.cn/sjk/9420032.html

(0)
打赏 微信扫一扫 微信扫一扫 支付宝扫一扫 支付宝扫一扫
上一篇 2023-04-28
下一篇 2023-04-28

发表评论

登录后才能评论

评论列表(0条)

保存