转载自Roger Blog:10.2.0.4+版本PSU以及相关bundle patch列表 2013年1月20日 更新 ++++10.2.0.4 Oracle Database Patch Set Update Unix Comments Includes Cpu10.2.0.4.1 8576156 Bash 10.2.0.4.0 includes CPU Jul 200910.2.0.4.2 8833280 Bash 10.2.0.4.
转载自Roger Blog:10.2.0.4+版本PSU以及相关bundle patch列表 2013年1月20日 更新++++10.2.0.4
Oracle Database Patch Set Update Unix Comments Includes Cpu 10.2.0.4.1 8576156 Bash 10.2.0.4.0 includes CPU Jul 2009 10.2.0.4.2 8833280 Bash 10.2.0.4.0 includes CPU Oct 2009 10.2.0.4.3 9119284 Bash 10.2.0.4.0 includes CPU Jan 2010 10.2.0.4.4 9352164 Bash 10.2.0.4.0 includes CPU Apr 2010 10.2.0.4.5 9654991 该psu必须基于10.2.0.4.4 includes CPU Jul 2010 10.2.0.4.6 9952234 该psu必须基于10.2.0.4.4 includes CPU Oct 2010 10.2.0.4.7 10248636 该psu必须基于10.2.0.4.4 includes CPU Jan 2011 10.2.0.4.8 11724977 该psu必须基于10.2.0.4.4 includes CPU Apr 2011 10.2.0.4.9 12419397 该psu必须基于10.2.0.4.4 includes CPU Jul 2011 10.2.0.4.10 12827778 该psu必须基于10.2.0.4.4 includes CPU Oct 2011 10.2.0.4.11 12879929 该psu必须基于10.2.0.4.4 includes CPU Jan 2012 10.2.0.4.12 12879933 该psu必须基于10.2.0.4.4 includes CPU Apr 2012 10.2.0.4.13 13923851 该psu必须基于10.2.0.4.4 includes CPU Jul 2012 10.2.0.4.14 14275630 该psu必须基于10.2.0.4.4 includes CPU Oct 2012 10.2.0.4.15 14736542 该psu必须基于10.2.0.4.4 includes CPU Jan 2013 |
+++++10.2.0.5
Oracle Database Patch Set Update Unix Comments Includes Cpu 10.2.0.5.1 9952230 Bash 10.2.0.5.0 includes CPU Oct 2010 10.2.0.5.2 10248542 Bash 10.2.0.5.0 includes CPU Jan 2011 10.2.0.5.3 11724962 Bash 10.2.0.5.0 includes CPU Apr 2011 10.2.0.5.4 12419392 Bash 10.2.0.5.0 includes CPU Jul 2011 10.2.0.5.5 12827745 Bash 10.2.0.5.0 Includes CPU Oct 2011 10.2.0.5.6 13343471 Bash 10.2.0.5.0 includes CPU Jan 2012 10.2.0.5.7 13632743 Bash 10.2.0.5.0 includes CPU Apr 2012 10.2.0.5.8 13923855 Bash 10.2.0.5.0 includes CPU Jul 2012 10.2.0.5.9 14275629 Bash 10.2.0.5.0 includes CPU Oct 2012 10.2.0.5.10 14727319 Bash 10.2.0.5.0 includes CPU Jan 2013 |
++++++11.1.0.7
Oracle Database Patch Set Update Database CRS Comments Includes Cpu 11.1.0.7.1 8833297 bug: 8287931 Bash 11.1.0.7.0 includes CPU Oct 2009 11.1.0.7.2 9209238 bug: 9207257 Bash 11.1.0.7.0 includes CPU Jan 2010 11.1.0.7.3 9352179 Bash 11.1.0.7.0 includes CPU Apr 2010 11.1.0.7.4 9654987 bug: 9294495 Bash 11.1.0.7.0 includes CPU Jul 2010 11.1.0.7.5 9952228 bug: 9952240 Bash 11.1.0.7.0 includes CPU Oct 2010 11.1.0.7.6 10248531 bug: 10248535 Bash 11.1.0.7.0 includes CPU Jan 2011 11.1.0.7.7 11724936 11724953 Bash 11.1.0.7.0 includes CPU Apr 2011 11.1.0.7.8 12419384 11724953 Bash 11.1.0.7.0 includes CPU Jul 2011 11.1.0.7.9 12827740 11724953 Bash 11.1.0.7.0 includes CPU Oct 2011 11.1.0.7.10 13343461 11724953 Bash 11.1.0.7.0 includes CPU Jan 2012 11.1.0.7.11 13621679 11724953 Bash 11.1.0.7.0 includes CPU Apr 2012 11.1.0.7.12 13923474 11724953 Bash 11.1.0.7.0 includes CPU Jul 2012 11.1.0.7.13 14275623 11724953 Bash 11.1.0.7.0 includes CPU Oct 2012 11.1.0.7.14 14739378 11724953 Bash 11.1.0.7.0 includes CPU Jul 2013 |
+++++11.2.0.1
Oracle Database Patch Set Update Database Grid Infrastructure Comments Includes Cpu 11.2.0.1.1 9352237 9343627 Bash 11.2.0.1.0 includes CPU Apr 2010 11.2.0.1.2 9654983 9343627 Bash 11.2.0.1.0 includes CPU Jul 2010 11.2.0.1.3 9952216 9655006 Bash 11.2.0.1.0 includes CPU Oct 2010 11.2.0.1.4 10248516 9655006 Bash 11.2.0.1.0 includes CPU Jan 2011 11.2.0.1.5 11724930 9655006 Bash 11.2.0.1.0 includes CPU Apr 2011 11.2.0.1.6 12419378 9655006 Bash 11.2.0.1.0 includes CPU Jul 2011 |
+++++11.2.0.2
OracleDatabase PatchSet Update Database Grid Infrastructure Comments Includes Cpu 11.2.0.2.1 10248523 Bundle1 10157506 Bash 11.2.0.2.0 no CPU fixes 11.2.0.2.2 11724916 Bundle2 10425672 Bash 11.2.0.2.0 includes CPU Apr 2011 PSU2 12311357 11.2.0.2.3 12419331 12419353 Bash 11.2.0.2.0 includes CPU Jul 2011 11.2.0.2.4 12827726 12827731 Bash 11.2.0.2.0 includes CPU Oct 2011 11.2.0.2.5 13343424 13343447 Bash 11.2.0.2.0 includes CPU Jan 2012 11.2.0.2.6 13696224 13696242 Bash 11.2.0.2.0 includes CPU Apr 2012 11.2.0.2.7 13923804 14192201 Bash 11.2.0.2.0 includes CPU Jul 2012 11.2.0.2.8 14275621 14390437 Bash 11.2.0.2.0 includes CPU Oct 2012 11.2.0.2.9 14727315 14390437 Bash 11.2.0.2.0 includes CPU Jan 2013 |
++++++11.2.0.3
OracleDatabase PatchSet Update Database Grid Infrastructure Comments Includes Cpu 11.2.0.3.0 10404530 (包含在10404530中) 11.2.0.3.1 13343438 13348650 Bash 11.2.0.3.0 includes CPU Jan 2012 11.2.0.3.2 13696216 13696251 Bash 11.2.0.3.0 includes CPU Apr 2012 11.2.0.3.3 13923374 13919095 Bash 11.2.0.3.0 includes CPU Jul 2012 11.2.0.3.4 14275605 14275572 Bash 11.2.0.3.0 includes CPU Oct 2012 11.2.0.3.5 14727310 14727347 Bash 11.2.0.3.0 includes CPU Jan 2013 |
原文地址:10.2.0.4+版本PSU以及相关bundle patch列表, 感谢原作者分享。

MySQL processes data replication through three modes: asynchronous, semi-synchronous and group replication. 1) Asynchronous replication performance is high but data may be lost. 2) Semi-synchronous replication improves data security but increases latency. 3) Group replication supports multi-master replication and failover, suitable for high availability requirements.

The EXPLAIN statement can be used to analyze and improve SQL query performance. 1. Execute the EXPLAIN statement to view the query plan. 2. Analyze the output results, pay attention to access type, index usage and JOIN order. 3. Create or adjust indexes based on the analysis results, optimize JOIN operations, and avoid full table scanning to improve query efficiency.

Using mysqldump for logical backup and MySQLEnterpriseBackup for hot backup are effective ways to back up MySQL databases. 1. Use mysqldump to back up the database: mysqldump-uroot-pmydatabase>mydatabase_backup.sql. 2. Use MySQLEnterpriseBackup for hot backup: mysqlbackup--user=root-password=password--backup-dir=/path/to/backupbackup. When recovering, use the corresponding life

The main reasons for slow MySQL query include missing or improper use of indexes, query complexity, excessive data volume and insufficient hardware resources. Optimization suggestions include: 1. Create appropriate indexes; 2. Optimize query statements; 3. Use table partitioning technology; 4. Appropriately upgrade hardware.

MySQL view is a virtual table based on SQL query results and does not store data. 1) Views simplify complex queries, 2) Enhance data security, and 3) Maintain data consistency. Views are stored queries in databases that can be used like tables, but data is generated dynamically.

MySQLdiffersfromotherSQLdialectsinsyntaxforLIMIT,auto-increment,stringcomparison,subqueries,andperformanceanalysis.1)MySQLusesLIMIT,whileSQLServerusesTOPandOracleusesROWNUM.2)MySQL'sAUTO_INCREMENTcontrastswithPostgreSQL'sSERIALandOracle'ssequenceandt

MySQL partitioning improves performance and simplifies maintenance. 1) Divide large tables into small pieces by specific criteria (such as date ranges), 2) physically divide data into independent files, 3) MySQL can focus on related partitions when querying, 4) Query optimizer can skip unrelated partitions, 5) Choosing the right partition strategy and maintaining it regularly is key.

How to grant and revoke permissions in MySQL? 1. Use the GRANT statement to grant permissions, such as GRANTALLPRIVILEGESONdatabase_name.TO'username'@'host'; 2. Use the REVOKE statement to revoke permissions, such as REVOKEALLPRIVILEGESONdatabase_name.FROM'username'@'host' to ensure timely communication of permission changes.


Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Hot Tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Zend Studio 13.0.1
Powerful PHP integrated development environment

PhpStorm Mac version
The latest (2018.2.1) professional PHP integrated development tool

SecLists
SecLists is the ultimate security tester's companion. It is a collection of various types of lists that are frequently used during security assessments, all in one place. SecLists helps make security testing more efficient and productive by conveniently providing all the lists a security tester might need. List types include usernames, passwords, URLs, fuzzing payloads, sensitive data patterns, web shells, and more. The tester can simply pull this repository onto a new test machine and he will have access to every type of list he needs.

SublimeText3 English version
Recommended: Win version, supports code prompts!
