2017年初量子号 釜山 长崎邮轮之旅

 

 

 

 

 

 

 

 

 

prm dul 恢复oracle数据库视频教程

1.prm dul恢复oracle数据库最简模式 http://zcdn.parnassusdata.com/prm%20dul%20recover%20oracle%20database%20easiest%20way.mp4
2.prm dul使用数据搭桥传输Oracle表数据 http://zcdn.parnassusdata.com/prm%20dul%20databridge%20transfer%20oracle%20table.mp4
3.prm du在损坏数据库使用exportddl导出建表语句、索引、存储过程、函数等代码 http://zcdn.parnassusdata.com/prm%20dul%20export%20ddl%20from%20corrupted%20oracle%20database.mp4
4.prm dul恢复oracle中被delete的数据 http://zcdn.parnassusdata.com/prm%20dul%20recover%20oracle%20deleted%20rows.mp4
5.prm dul恢复oracle中被truncate的数据 http://zcdn.parnassusdata.com/prm%20dul%20recover%20oracle%20truncated%20table.mp4
6.prm dul用户级别的数据搭桥 http://zcdn.parnassusdata.com/prm%20dul%20schema%20level%20databridge.mp4
7.prm dul在ASM存储情况下的最简模式 http://zcdn.parnassusdata.com/prm%20dul%20easiest%20way%20with%20ASM%20storage.mp4
8.prm dul恢复oracle中被drop掉的表 http://zcdn.parnassusdata.com/prm%20dul%20recover%20oracle%20dropped%20table.mp4
9.prm dul恢复oracle 12c以后可拔插数据库PDB/CDB中的数据 http://zcdn.parnassusdata.com/prm%20dul%20work%20with%20oracle%2012c%20pdb%20pluggable%20database%20container%20database.mp4
10.prm dul恢复被恶意加密的Oracle数据文件 http://zcdn.parnassusdata.com/prm%20dul%20recover%20malware%20ransomware%20corrupted%20oracle%20datafile.mp4

 

1.prm dul recover oracle database easiest way https://youtu.be/mU3uip66DmY
2.prm dul databridge transfer oracle table https://youtu.be/yzvVSBnQ23g
3.prm dul export ddl from corrupted oracle database https://youtu.be/5l2hO5k5-PQ
4.prm dul recover oracle deleted rows https://youtu.be/hIYutqNcVBI
5.prm dul recover oracle truncated table https://youtu.be/KGrCi25sD3c
6.prm dul schema level databridge https://youtu.be/RocbEFlPr3o
7.prm dul easiest way with ASM storage https://youtu.be/EaMsSaCtje4
8.prm dul recover oracle dropped table https://youtu.be/mdPGSjDvX6o
9.prm dul work with oracle 12c pdb pluggable database / container database https://youtu.be/QyDMsdmRfqU
10.prm dul recover malware/ransomware corrupted oracle datafile https://youtu.be/jOT6k-KF8Hg

Oracle 11.2.0.4 LINUX WINDOWS AIX下载

请注意,如果你有support.oracle.com账号,那么严格从官网下载介质。如果实在没有,那么从互联网上下载介质一定要验证SHA1,避免介质被修改。

 

ORACLE 11.2.0.4 Windows 64bit:

链接:https://pan.baidu.com/s/1DtU0rQxEPryxopotN85Icw
提取码:29rx
复制这段内容后打开百度网盘手机App,操作更方便哦

 

11.2.0.4.0 PATCH SET FOR ORACLE DATABASE SERVER (Patchset)
p13390677_112040_MSWIN-x86-64_1of7.zip 1.2 GB (1327046969 bytes) 
SHA-256 9C6E1235D1B0EE6C36E3F82FEBDC74160BB9766900579FC7EBBFACECD6E8F4B2 
SHA-1 893475AFA9C6758FB14E8269EF05F6D485445F28 

p13390677_112040_MSWIN-x86-64_2of7.zip 1.1 GB (1152431908 bytes) 
SHA-1 6EE067D16F80061B03CFD63603B3F5E454B6152D 
SHA-256 6343B2EA4F47C4E85FD4DC1B5C2EA0B86294E48FAD90DE1820C3F9DF906675F3 

p13390677_112040_MSWIN-x86-64_3of7.zip 735.0 MB (770723774 bytes) 
SHA-256 EC47CFF4D500BD357982C57D9F84F893293A3DBB79A62FC7AE66E2144BEFFF6C 
SHA-1 AA69BD12E01BECBD249C71F8682D75BB2FA003DB 

p13390677_112040_MSWIN-x86-64_4of7.zip 600.7 MB (629885092 bytes) 
SHA-256 10D708F6C3FA12466486BDBB3B1FB235EEEAF1AAB39B67B86C42648F8F49FB33 
SHA-1 821CD458D76672DD10A3C377196C6CE52CBB1BBF 

p13390677_112040_MSWIN-x86-64_5of7.zip 525.6 MB (551173867 bytes) 
SHA-1 E975AA77E4D79B2A22F0F341CBA97EE696B5ADD1 
SHA-256 25FB15F2031C4C82EC09D001023103A9267BC2D34D0F1731E0EBFCDA0495C72E 

p13390677_112040_MSWIN-x86-64_6of7.zip 484.2 MB (507686306 bytes) 
SHA-1 C899797A782DE2A09EC90C57A1117D3490CEAA65 
SHA-256 4A2EF2B9FB3656009320676B2DDFB13A81777B6F2E70ECCA37606637EF796043 

p13390677_112040_MSWIN-x86-64_7of7.zip 108.3 MB (113590540 bytes) 
SHA-1 DCA23E6583527F7ABC19846D1FD51D56DE4C4111 
SHA-256 4BF2626A281C006331846C174790EF63D744C7A0BAC309CAAB48548596476701 

 

 

ORACLE 11.2.0.4 Linux 64bit:

链接:https://pan.baidu.com/s/1uJt7OrgXU-600U7teZKp-Q
提取码:27ud
复制这段内容后打开百度网盘手机App,操作更方便哦

 

11.2.0.4.0 PATCH SET FOR ORACLE DATABASE SERVER (Patchset)
p13390677_112040_Linux-x86-64_1of7.zip 1.3 GB (1395582860 bytes) 
SHA-256 0B399A6593804C04B4BD65F61E73575341A49F8A273ACABA0DCDA2DFEC4979E0 
SHA-1 983461D6442B0833630475EC4885278588585651 

p13390677_112040_Linux-x86-64_2of7.zip 1.1 GB (1151304589 bytes) 
SHA-1 2E628D8CAC5D1C6FFF15E728B1F227747BF2DED8 
SHA-256 73E04957EE0BF6F3B3E6CFCF659BDF647800FE52A377FB8521BA7E3105CCC8DD 

p13390677_112040_Linux-x86-64_3of7.zip 1.1 GB (1205251894 bytes) 
SHA-1 8C0CD2D7BB2DD73E965A90CD053828D7A52AE7E7 
SHA-256 09C08AD3E1EE03DB1707F01C6221C7E3E75EC295316D0046CC5D82A65C7B928C 

p13390677_112040_Linux-x86-64_4of7.zip 625.6 MB (656026876 bytes) 
SHA-1 1ACF8F785313D3C5CF631A0077416C22348B9DF8 
SHA-256 88B4A4ABB57F7E94941FE21FA99F8481868BADF2E1E0749522BBA53450F880C2 

p13390677_112040_Linux-x86-64_5of7.zip 571.4 MB (599170344 bytes) 
SHA-256 F9C9D077549EFA10689804B3B07E3EFD56C655A4ABA51EC307114B46B8EAFC5F 
SHA-1 8D68764AB38804A9B9C9E80BF5AE0F3D6C397151 

p13390677_112040_Linux-x86-64_6of7.zip 465.7 MB (488372844 bytes) 
SHA-256 B2E08F605D7A4F8ECE2A15636A65C922933C7EF29F7AD8B8F71B23FE1ECBACA8 
SHA-1 79533E2FF40664A4640616BD559903ED616F2633 

p13390677_112040_Linux-x86-64_7of7.zip 114.0 MB (119521122 bytes) 
SHA-256 1CB47B7C0B437D7D25D497ED49719167A9FB8F97A434E93E4663CFA07590E2BA 
SHA-1 B23A8CED6D47664F20C116ABA9A2C77D65B2DD6D 


ORACLE 11.2.0.4 AIX  64bit:

链接:https://pan.baidu.com/s/1kY9AozQGCctxiVLJUcqYfQ
提取码:2322
复制这段内容后打开百度网盘手机App,操作更方便哦

 

11.2.0.4.0 PATCH SET FOR ORACLE DATABASE SERVER (Patchset)
p13390677_112040_AIX64-5L_1of7.zip 1.7 GB (1801653734 bytes) 
SHA-256 0F74D947F7B8E7E3B1FB4CCC4CB36506E3D1D2DF68E1526AEB7CCB23798F704F 
SHA-1 6A8A7238A796322C6B6AD584805661BC3C368DD1 

p13390677_112040_AIX64-5L_2of7.zip 1.1 GB (1170882875 bytes) 
SHA-1 AE628A661616887E7BA96A2122FB6C62C9B9B6E0 
SHA-256 BD8AAC4DFAFD84840918CDC655D8328AB96EFE1CEB056F843BC75F11BB7AAEC0 

p13390677_112040_AIX64-5L_3of7.zip 2.0 GB (2127071138 bytes) 
SHA-1 BCEDB9007F768A8701406BFE2465E486AF288D52 
SHA-256 CE95498EB70D264E969C48609E5FD036EFF296994725E35AC8E1458B7C8EE9E0 

p13390677_112040_AIX64-5L_4of7.zip 996.5 MB (1044886145 bytes) 
SHA-256 31DD509123F83D414FF1B299E413EF062E4E6F1B48816156AB78CECAF9EEBC83 
SHA-1 FFD1AE113AD645F7891A9C4EB35BDC4BFCBB0A3A 

p13390677_112040_AIX64-5L_5of7.zip 851.6 MB (892976067 bytes) 
SHA-1 AE89F9F347218A8B5FBEE3BB0279099234E65D1A 
SHA-256 54339444BB29B202AB319AB77F00CBB78DD052D558320139CED9E97EC6ACC0F3 

p13390677_112040_AIX64-5L_6of7.zip 543.3 MB (569688642 bytes) 
SHA-256 E64D165372B17F23F5D756381CAAD3FD057A80EAE0CD786589B91982A6993322 
SHA-1 BA3B3BF26B08ADC7A95B94E4E43044A79113524B 

p13390677_112040_AIX64-5L_7of7.zip 215.4 MB (225860409 bytes) 
SHA-256 5D1364CAB9241B7A71EF286D0E86CAC256878E771E9FDDC8CB1CF0E16FB99EAD 
SHA-1 BA37C387373001DF7F3BDF2725301D45519FC00D 

 

 

 

注意,如果没有特殊要求,没有理由使用32bit版本了!!

 

ORACLE 11.2.0.4 Linux 32bit:

链接:https://pan.baidu.com/s/1IORUFF94mmbbIWnGfsYsng
提取码:aci0
复制这段内容后打开百度网盘手机App,操作更方便哦

11.2.0.4.0 PATCH SET FOR ORACLE DATABASE SERVER (Patchset)
p13390677_112040_LINUX_1of7.zip 1.3 GB (1380374377 bytes) 
SHA-1 A525E17F3C62659AC11ACB39A20711972B1EC22E 
SHA-256 A9D644CA07D043DEB363DC76D385212090527F72B27A802E2FD2965299CD2FF8 

p13390677_112040_LINUX_2of7.zip 1.1 GB (1142436991 bytes) 
SHA-256 BA1D4CB4C186FF3DC40B682AF5134EA7B6FE252A415B61EEA0C42F820C7223EC 
SHA-1 5B8FCE0253EB4549F149DCB9BB9B2646F8755ECD 

p13390677_112040_LINUX_3of7.zip 814.3 MB (853856456 bytes) 
SHA-256 BE9435F8BE3724D2404EBF37150F6B61B45D23970A11CCF661521F29D503B3CF 
SHA-1 50CF20E8C25F3CA723B94699392262F12E090FB9 

p13390677_112040_LINUX_4of7.zip 613.5 MB (643298224 bytes) 
SHA-256 C4ACE48647B045D831516DEE3805BA1F9A40A50E357D6AE5D8E8D141A91410BF 
SHA-1 7657A2DE446D8F016DDC9CE985948F22A66F61F7 

p13390677_112040_LINUX_5of7.zip 560.2 MB (587370432 bytes) 
SHA-256 5BB47B213C8D239133C8E147A6601C4E0EE45C0D6CAD842042F1168640870FA0 
SHA-1 B2F6DF0624DE740B3684383F3CDE25E4D7741F7C 

p13390677_112040_LINUX_6of7.zip 465.1 MB (487722197 bytes) 
SHA-1 FC8E0AC37CED34F0270D36AB4DFF994E2FB3E4BA 
SHA-256 3BAA0F29DA8E1D1E6D70CE6CD4659CD7E0F60F3ADD0C142FEACE816BD0E5F756 

p13390677_112040_LINUX_7of7.zip 113.3 MB (118788536 bytes) 
SHA-1 8E556FC5A5A624CDBA5EF05A47EC10BE607172E9 
SHA-256 5C99E47D01AE4379A63F9DA7BA5F03BCFEF0BD1F80E0C2D4D4142184BB0060C4 

 

 

ORACLE 11.2.0.4 WINDOWS 32bit:

链接:https://pan.baidu.com/s/1mtVVX7cVfFuYRqD8qjbVng
提取码:b3mj
复制这段内容后打开百度网盘手机App,操作更方便哦

11.2.0.4.0 PATCH SET FOR ORACLE DATABASE SERVER (Patchset)
p13390677_112040_WINNT_1of6.zip 1.2 GB (1303780058 bytes) 
SHA-256 1F1CBB0FCD230CD4E78162A652B2777430B622EA39DE74AD2D67F8E5046DE5A0 
SHA-1 6A0BEB102E2326DE6C0EEB84818FC89AEA1F6518 

p13390677_112040_WINNT_2of6.zip 1.1 GB (1137477960 bytes) 
SHA-256 D12BD4C070A094154FCBDB34F05A7EC0FA7D45B69F6BC7FF0B2DEFEECE1E0873 
SHA-1 821D0B636D4055138CD9B3D4FCA1BA521EA3009B 

p13390677_112040_WINNT_3of6.zip 578.6 MB (606695219 bytes) 
SHA-1 D47447F5FFA46C524B09A635071D3684DC96DA52 
SHA-256 90AAD65DEBFB36A72EF9F515707A0353E38F4ED0F441AFA795D25D82273DCDFE 

p13390677_112040_WINNT_4of6.zip 504.4 MB (528911211 bytes) 
SHA-256 A36FBB370C3A6718611033FDD048BF1155559A9725AFB8D7D5ADD6265EEE0362 
SHA-1 F5C153542F4322B90A92AC47A4EEB732055E0FEA 

p13390677_112040_WINNT_5of6.zip 475.4 MB (498466574 bytes) 
SHA-1 A6F25F4DC426CED3F53C38E584AC2705FD516138 
SHA-256 36ED3410E296F53656ABA6E0FE4BAB69A8059488B5751F9BFD8D2F7F4BDE10A2 

p13390677_112040_WINNT_6of6.zip 105.0 MB (110100340 bytes) 
SHA-1 0A8046C4970B0AAFBFA9A77905EC81B04021F93A 
SHA-256 06093886948C9F7EA33B4E4A73CB7115EBA5B05E924F3A4C2B44B84C74ECB06D 

 

dbDao.com数据岛学习平台整体迁移到小密圈的公告

数据岛Oracle/MySQL学习平台将整体迁移到微信小密圈ORACLE,可以通过微信扫码加入小密圈来获得所有数据岛学习资料,加入小密圈的费用为300元/人。

扫码加入微信Oracle小密圈,了解Oracle最新技术下载分享资源

 

 

 

 

Solix优化Oracle E-Business Suite性能

Solix优化Oracle E-Business Suite性能

12c vs 11g x$messages

ACMS initialization ACMS
ADR PDB Auto Purge Task MMON
ADR Space Management Statistics Flush MMON
ARCH initialization ARC*
ASH Progressive Flusher (KEWA) MMON
ASM Audittrail cleanup MMON
AWR PDB Auto Flush Task MMON
AWR PDB Auto Purge Task MMON
AWR Raw Metrics Capture GEN1
Action-Based process Test GEN0
Archiver disconnect ARCH
Auxilary ipc finish gen0 action GEN0
Auxilary ipc init gen0 action GEN0
Auxilary ipc intr gen0 action GEN0
Auxilary ipc message gen0 action GEN0
Auxilary ipc timedout gen0 action GEN0
BA container GEN0 action GEN0
CLI AutoPartition MMON
CLI Create All Slave Tasks GEN0
CLI Create One Slave Task GEN0
Check for async in-memory job messages CJQ0
Cleanup of unpinned KGL handles MMON
Column-Level Statistics flush MMON
DBRM ADG in-memory state refresh DBRM
DBWO timeout kcbifc DBW0
DBWR write buffers DBW*|BW*
DDE Periodic Dump Scheduler MMON
DMON do critical instance eval and registration DMON
DSKM fini DSKM
DSKM init DSKM
DSKM procures HCA loadavg and computes offloaded write thresh DSKM
DTrace based Kernel IO  Outlier  Processing GEN0
Direct NFSv4 RENEW lease operation GEN0
Execute on-demand tuning task (KESTS) MMON
Free java patching locks LCK0
GEN0 Master Check GEN0
Get java patching locks LCK0
Hang Manager parameters GEN0
ILM check MMON
ILM cleanup MMON
ILM row access flush MMON
ILM segment access flush MMON
IMCO ADO action IMCO
IMCO FastStart Defer Write Scheduler IMCO
IMCO Trickle Repopulate IMCO
IMCO action IMCO
IMCO cycle action IMCO
IMCO global dictionary action IMCO
IMCO worker action IMCO
Inactive Account Time Job GEN0
Index usage tracking statistics flush MMON
Initiate KSBCITST TEST
KEWR SlavePool Test MMON Main MMON
KJBFP PBR logfile scan LMFC
KJBFP PBR recovery LMFC
KJBFP PBR writer main LMFC
KJBFP increment PRI LMFC
KJBFP pbr logFile CLose *
KJFM update process heartbeat LCK*|DIA*|LGWR|CKPT|DBRM|IPC0
KQLM interrupt action LCK1
KQLM invalidation instance lock operation LCK1
KSB GEN1 init GEN1
KSGL initialize service IPC0
KSGL mount in IPC0 IPC0
KSGL node exit IPC0
KSGL node join IPC0
KSGL notify IPC0 IPC0
KSGL timeout IPC0
KSIPC Grp Refresh action IPC0
KSIPC MGA Segment Check IPC0
KSIPC finish action IPC0
KSIPC initialize server IPC0
KSIPC interrupt action IPC0
KSIPC msg action IPC0
KSIPC reconfig action IPC0
KSIPC shutdown action IPC0
KSIPC timeout action IPC0
KSM SGA slaves spawn GEN0
KSRMA RMA OP IPC0
KSRMA Recovery Log Allocation IPC0
KSRMA mount IPC0
KSU GUID MAC Address update GEN0
LGWR flush workers LGWR
LGWR initialization LGWR
MMON request to purge LTXID history table MMON
Monitor initialization TMON
Monitor wakeup TMON
Multi procs per DTP UTMU
Network Server forced NSS*
Network Server shutdown NSS*
PDB SGA init GEN0
PDB close abort GEN0
PMON notify IPC0 of process failure IPC0
PQ: Adjust Slave Pool MMON
Payload action to BG RMON
Process new DBs that join ASM locally DIA*
RMON BG Driver RMON
RMON Init Action RMON
RTTD initialization RTTD
Real-Time ADDM Trigger MMON
Redo writer quiesce IMC on standby LGWR
Refresh active service cache MMON
Report Capture Daemon MMON
Report Capture Test (KERPI) MMON
SGA deferred allocated granules Initialization MMAN
SGA deferred allocated granules move MMAN
SMON_SCN_TIME Copy to PDBs MMON
SQL Memory Management Calculation DBRM
Spawn processes on behalf of someone else GEN0
Standby media recovery info cleanup LGWR
Suspended session cleanup GEN0
Sweep PL/SQL incidents MMON
Switchover/PDB relocate message channel subscribe LGWR
TPZ initialization TPZ*
Test Driver wakeup RTTD
Test Process wakeup TPZ*
Timeout interrupt action RBAL
Triton Session Cleanup MMON
UMF Auto Task Pool Queue Server MMON
UMF Auto Task Pool Scheduler MMON
UTS Async Dump GEN0
Volume Resource Action GEN0
Wait event outlier detection GEN0
XStream timeout action GEN0
acquire enq during pdbopen by HARIM DBW0
action for buddy instance RMS0
action to cleanup buddy instance context RMS0
check for KJCI cross-instance requests *
cleaning up workload information for optimizer MMON
clear the dependent scn DBRM
dblink logon table cleanup MMON
enter / exit graph test specified wait *
event nfy timeout action GEN0
event outlier dump info. GEN0
extend quarantine area GEN0
flushing workload information for optimizer MMON
free PX memory chunks in background PXMN
get/release open thread enqueue DBW*|BW*
init function for LCK1 *
initiate block repair GEN0
kcb DW object cooling GEN0
kcbz background redodump GEN0
kcbz update TSE bh CKPT
kill client GEN0
ksim cache line update LCK0
ksim instance group membership notifier *
kxfp remote slave spawn recv function PXMN
light-weight checks for optimizer statistics advisor MMON
mira CKPT channel CKPT
mount/dismount all db files DBW*|BW*
pdb event stats action GEN0
periodic PDB tasks GEN0
pmon dtp init PMON|CLMN
prespawn clean check GEN0
prespawn init check GEN0
prespawn timeout check GEN0
register to node local process group RBAL
shutdown RMON process RMON
sync PDB DBW0
threshold reloading MMON
unit test DBW0

oracle如何判定统计信息陈旧

本文原始地址:http://www.askmaclean.com/?p=18742

注意自动收集统计信息是从10g开始的,10g以前版本默认不自动收集统计信息。

对于自动收集统计信息而言需要知道统计信息是否陈旧stale ,判定陈旧的标准是对应的表上的数据修改超过10%(删除或插入或更新10%或以上数据行)。 这里oracle是如何知道修改超过10%的?

 

SGA的shared pool存有SQL的statistics情况,对应的有SQL处理的行数,SMON进程定期将这些信息刷到表SYS.MON_MODS$基表中(参考拙作: http://www.askmaclean.com/archives/smon-flush-dml-statistics-mon-mods.html):SMON后台进程会每15分钟将SGA中的DML统计信息刷新到SYS.MON_MODS$基表中(SMON flush every 15 minutes to SYS.MON_MODS$),
同时会将SYS.MON_MODS$中符合要求的数据MERGE合并到MON_MODS_ALL$中,并清空原MON_MODS$中的数据。
MON_MODS_ALL$作为dba_tab_modifications视图的数据来源,起到辅助统计信息收集的作用,详见拙作<Does GATHER_STATS_JOB gather all objects’ stats every time?>

这样基于之前的统计信息中的表的行数(dba_tables.num_rows),对比 MON_MODS_ALL$(dba_tab_modifications)中的update、delete、insert、truncate信息就可以知道该表从上一次收集统计信息到现在做了多少百分比的修改,若该百分比超过10%则判定为stale陈旧,否则为不陈旧。陈旧的统计信息会在自动收集统计信息时再次被收集。

 

 

DOP degree of parallelism的设计算法 ​​​​

直击oracle内核代码算法,对于11g以后的自动Parallelism算法一般只能用10053 trace来研究其算法。这里通过直接查看oracle源码设计文档,我们可以得到DOP degree of parallelism的设计算法

 

8358fa4fgy1fcr7ivo81lj20zq0kijwk

沪ICP备14014813号

沪公网安备 31010802001379号

TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569