..oracle service – OracleBlog

Bug Issues Known to cause Wrong Results

2017-02-02 没有评论

LAST UPDATE:

Dec 15, 2016

1	Dec 15, 2016

APPLIES TO:

Oracle Database - Enterprise Edition - Version 7.0.16.0 and later
Oracle Database - Standard Edition - Version 7.0.16.0 and later
Oracle Database - Personal Edition - Version 7.1.4.0 and later
Information in this document applies to any platform.

1

2

3

4

Oracle Database - Enterprise Edition - Version 7.0.16.0 and later

Oracle Database - Standard Edition - Version 7.0.16.0 and later

Oracle Database - Personal Edition - Version 7.1.4.0 and later

Information in this document applies to any platform.

PURPOSE:

This document provides information on bugs known to cause "wrong results". "Wrong results" in this context has quite a broad classification - it may be a performance monitoring view giving slightly misleading information, or may be completely wrong rows returned (or missing) from a query result set. 
These issues can be particularly difficult to match to a known bug as the symptom often depend on the query. The aim here is to provide a list of bugs known to cause wrong results and to provide both version affected and radio options to trim the list.

1

2

This document provides information on bugs known to cause "wrong results". "Wrong results" in this context has quite a broad classification - it may be a performance monitoring view giving slightly misleading information, or may be completely wrong rows returned (or missing) from a query result set.

These issues can be particularly difficult to match to a known bug as the symptom often depend on the query. The aim here is to provide a list of bugs known to cause wrong results and to provide both version affected and radio options to trim the list.

KNOWN BUGS: NB Pr […]

..oracle service, Working case

Common X$ dictionary table queries for ORA-4031 investigation

2017-02-02 没有评论

LAST UPDATE:

Jun 15, 2011

1	Jun 15, 2011

APPLIES TO:

Oracle Server - Enterprise Edition - Version: 9.2.0.1 to 11.1.0.8 - Release: 9.2 to 11.1
Information in this document applies to any platform.
Customers should have limited access to these scripts. There can be database hangs and impacts to performance running these too often.

1

2

3

Oracle Server - Enterprise Edition - Version: 9.2.0.1 to 11.1.0.8 - Release: 9.2 to 11.1

Information in this document applies to any platform.

Customers should have limited access to these scripts. There can be database hangs and impacts to performance running these too often.

PURPOSE: There are a number of x$ queries in various notes […]

..oracle service, Study note, Working case

Documented Database Bugs With High “Solved SR” Count

2017-02-02 没有评论

APPLIES TO:

Oracle Database - Enterprise Edition - Version 9.2.0.8 and later

1	Oracle Database - Enterprise Edition - Version 9.2.0.8 and later

PURPOSE:

This note lists "documented" database bugs that have been marked as the solution to a "high number of Service Requests".
For the purpose of this listing:
A "documented" bug means one with a bugno.8 KM document created from BugTag data.
A "high number of Service Requests" means that there are more than 50 "Solved SR" entries for the bug - ie: all bugs in this doc have > 50 "Solved SR" entries from the SR closure data.
It is suggested to restrict the list based on the version of interest, and then use the radio buttons to check on particular features / symptoms / facts linked to the bug descriptions.

The list includes some bugs with a "D" in the "NB" column - this is used to denote a bug fix that is DISABLED by default and so a customer may encounter that issue in DB versions where the bug is marked as fixed.

1

2

3

4

5

6

7

This note lists "documented" database bugs that have been marked as the solution to a "high number of Service Requests".

For the purpose of this listing:

A "documented" bug means one with a bugno.8 KM document created from BugTag data.

A "high number of Service Requests" means that there are more than 50 "Solved SR" entries for the bug - ie: all bugs in this doc have > 50 "Solved SR" entries from the SR closure data.

It is suggested to restrict the list based on the version of interest, and then use the radio buttons to check on particular features / symptoms / facts linked to the bug descriptions.

The list includes some bugs with a "D" in the "NB" column - this is used to denote a bug fix that is DISABLED by default and so a customer may encounter that issue in DB versions where the bug is marked as fixed.

KNOWN BUGS: NB Prob Bug Fixed Description P IIII 7272646 Linux- […]

..oracle service, Working case

Known Issues for Database and Query Performance Reported in 12C

2017-01-28 没有评论

LAST UPDATE:

Dec 13, 2016

1	Dec 13, 2016

APPLIES TO:

Oracle Database - Enterprise Edition - Version 12.1.0.1 to 12.1.0.2 [Release 12.1]
Information in this document applies to any platform.

1 2	Oracle Database - Enterprise Edition - Version 12.1.0.1 to 12.1.0.2 [Release 12.1] Information in this document applies to any platform.

PURPOSE:

In recent quarters, during non-code closure bug review for Performance, it was found that more than 50% of duplicates (36,96) closed by Sustaining Engineering (SE) belonged to version 12.1. As a result this document was created to list most commonly reported and share this with Tier-1 engineers so that they could check this before logging any new bugs. Thus the Goal of this document is to provide a list of known bugs reported in 12C for database & SQL performance for support analysts to check before logging new bugs.

In addition to the bugs listed in this article, there is also a useful list of Documented Database Bugs With High "Solved SR" Count where a high number of Service Requests means that there are more than 50 "Solved SR" entries for the bug - ie: all bugs in this doc have > 50 "Solved SR" entries.” :

Document 2099231.1 Documented Database Bugs With High "Solved SR" Count

1

2

3

4

5

In recent quarters, during non-code closure bug review for Performance, it was found that more than 50% of duplicates (36,96) closed by Sustaining Engineering (SE) belonged to version 12.1. As a result this document was created to list most commonly reported and share this with Tier-1 engineers so that they could check this before logging any new bugs. Thus the Goal of this document is to provide a list of known bugs reported in 12C for database & SQL performance for support analysts to check before logging new bugs.

In addition to the bugs listed in this article, there is also a useful list of Documented Database Bugs With High "Solved SR" Count where a high number of Service Requests means that there are more than 50 "Solved SR" entries for the bug - ie: all bugs in this doc have > 50 "Solved SR" entries.” :

Document 2099231.1 Documented Database Bugs With High "Solved SR" Count

DETAILS: Query Op […]

..oracle service, Working case

Solaris操作系统真的停止开发了吗？

2016-12-23 一条评论

Solaris系统将被停止开发，这个消息，据我所看到的，最初的来源是来自thelayoff网站的消息『Solaris being canned, at least 50% of teams to be RIF’d in short term』 All hands meetings bei […]

..oracle service

12.2 Now Available on Oracle Cloud

2016-11-09 没有评论

根据twitter上 ‏@OracleDatabase 的消息12.2在oracle云上已经可用了。具体的说，是在DBCS(Oracle Database Cloud Service) ，ECS(Exadata Cloud Service)，以及EECS(Exadata Express Cloud […]

..oracle service, Working case

Oracle 11.2.0.3 patchset 发布

2011-09-26 2条评论

上周六，oracle发布了又一个重量级的patch set，11.2.0.3，一个超过5G的大家伙，有7个文件。目前来看，还只有linux x86版本和linux x86-64版本，但是大家不用着急，solaris的版本应该会在国庆前前release，其他的版本，可以参见：Release Sched […]

..oracle service, Working case

oracle将推出Exadata mini版？

2011-09-21 没有评论

早上在twitter上看到@ricky_zhu 和@lewvip 聊到，oracle将推出的exadata mini。据国外的网站报道（ Oracle’s ‘Exadata mini’ would aim for midmarket），oracle正在准备面向中 […]

..oracle service, Working case

OOW 2010中两场Larry Ellison的keynote

2010-10-16 一条评论

在网上看到2场OOW（Oracle Open World）2010中Larry Ellison主讲的keynote，一场是2010年9月19日的，主要讲的是云计算和oracle新推出的Exalogic；另一场是在2010年的9月22日，讲的内容比较多，主要讲了oracle相关的所有内容做的集成。我 […]

..oracle service, Study note

ocm考试-grid control中的job system

2010-05-02 没有评论

grid control中的job system在gc界面中首页的job菜单中，这个job可以建立很多类型的job，用途远远大于db control中的job或者schedual，在这里我们简单模拟几个常用的job的建立。（注意本文多图杀猫）一、写在前面： 1、gc的登录用户，不能用一般的crea […]

..oracle service, Working case

跨平台的DATAGUARD组合列表

2009-06-22 一条评论

oracle允许在同一个oracle platform下安装dataguard，要求尽量的同样的操作系统版本。 oracle platform可以用以下的语句查看（9i的v$database没有PLATFORM_ID和PLATFORM_NAME字段）： [crayon-673ed1ef3017304 […]

..oracle service, Working case

oracle像什么？

2008-11-12 2条评论

oracle不是一个数据库公司，oracle是一个信息化公司。 oracle像一把伞，Database是伞的伞柄，Midware是伞柄上的伞骨，各类的application是伞骨上的伞面。 .