oracleblog.org

OracleBlog – 天堂向左 DBA向右

Outline的官方网站是 https:/ getoutline.org/en/home out […]. Oracle 18c在2018-02-16 release出来的，还是秉承着Oracle的cloud first理念，18c现在cloud和Engineered Systems上推出，想在传统的机器上安装18c，估计还要等到2018年下半年。 APPLIES TO: MySQL Server – Versio […]. 昨天开发请我建立了一个只读用户abc tmp test用户，并且将mkl rw用户下的32个表授权给只读用户用。 Oracle 12.2 新特性介绍. 计划明年等12.2.0.2出来之后，在公司全面推行oracle 12.2版本数据库。 PDF下载 Oracle 12.2新特性介绍. Mysql和mssql的跨库查询，基本只需要dbname.schema.table name就可以实现，而pg的跨库查询，和oracle一样，需要通过类似dblink的方式来实现。岗位职责 1. 负责内网和云上 aws和阿里云数据库的故障响应。所以，我们不得不采用on com […].

http://www.oracleblog.org/

OVERVIEW OF oracleblog.org

TRAFFIC RANK

>1,000,000

REVIEWS

0

PAGES IN THIS WEBSITE

20

LINKS TO THIS WEBSITE

CONTACTS

ADDRESSES

SOCIAL LINKS

ONLINE SINCE

WEBSITE DETAILS

SEO

PAGES

SIMILAR SITES

TRAFFIC RANK FOR ORACLEBLOG.ORG

TODAY'S RATING

>1,000,000

TRAFFIC RANK - AVERAGE PER MONTH

BEST MONTH

March

AVERAGE PER DAY Of THE WEEK

HIGHEST TRAFFIC ON

Friday

TRAFFIC BY CITY

Sign up

CUSTOMER REVIEWS

Average Rating: 4.6 out of 5 with 10 reviews

5 star

6

4 star

4

3 star

0

2 star

0

1 star

0

Hey there! Start your review of oracleblog.org

AVERAGE USER RATING

Write a Review

WEBSITE PREVIEW

LOAD TIME

1.7 seconds

FAVICON PREVIEW

16x16
32x32
64x64
128x128
160x160
192x192
256x256

CONTACTS AT ORACLEBLOG.ORG

A Happy DreamHost Customer

oracleblog.org Private Registrant

417 Ass●●●●●●●Rd #324

B●a , CA, 92821

US

1.71●●●●4182

or●●●●●●●●●●●●@proxy.dreamhost.com

View this contact

A Happy DreamHost Customer

oracleblog.org Private Registrant

417 Ass●●●●●●●Rd #324

B●a , CA, 92821

US

1.71●●●●4182

or●●●●●●●●●●●●@proxy.dreamhost.com

View this contact

A Happy DreamHost Customer

oracleblog.org Private Registrant

417 Ass●●●●●●●Rd #324

B●a , CA, 92821

US

1.71●●●●4182

or●●●●●●●●●●●●@proxy.dreamhost.com

View this contact

ADD CONTACT

Login

TO VIEW CONTACTS

Remove Contacts

FOR PRIVACY ISSUES

DOMAIN REGISTRATION INFORMATION

REGISTERED: n/a
UPDATED: 2013 November 05
EXPIRATION: EXPIRED REGISTER THIS DOMAIN

BUY YOUR DOMAIN

NAME SERVERS

1: ns1.dreamhost.com
2: ns2.dreamhost.com
3: ns3.dreamhost.com

REGISTRAR

New Dream Network, LLC dba DreamHost Web Hosting (R173-LROR)

WHOIS : whois.publicinterestregistry.net

REFERRED :

CONTENT

PAGES IN
THIS WEBSITE

20

SSL

EXTERNAL LINKS

96

SITE IP

45.76.217.207

LOAD TIME

1.656 sec

SCORE

6.2

PAGE TITLE

OracleBlog – 天堂向左 DBA向右 | oracleblog.org Reviews

<META> DESCRIPTION

Outline的官方网站是 https:/ getoutline.org/en/home out […]. Oracle 18c在2018-02-16 release出来的，还是秉承着Oracle的cloud first理念，18c现在cloud和Engineered Systems上推出，想在传统的机器上安装18c，估计还要等到2018年下半年。 APPLIES TO: MySQL Server – Versio […]. 昨天开发请我建立了一个只读用户abc tmp test用户，并且将mkl rw用户下的32个表授权给只读用户用。 Oracle 12.2 新特性介绍. 计划明年等12.2.0.2出来之后，在公司全面推行oracle 12.2版本数据库。 PDF下载 Oracle 12.2新特性介绍. Mysql和mssql的跨库查询，基本只需要dbname.schema.table name就可以实现，而pg的跨库查询，和oracle一样，需要通过类似dblink的方式来实现。岗位职责 1. 负责内网和云上 aws和阿里云数据库的故障响应。所以，我们不得不采用on com […].

<META> KEYWORDS

1 oracleblog

2 天堂向左 dba向右

3 menu

4 it's my life

5 outline的部署和使用

6 没有评论

7 现在你明白了吧，这是一款google出的工具

8 continue reading

9 study note

10 18c新特性的一些小结

CONTENT

Page content here

KEYWORDS ON PAGE

oracleblog,天堂向左 dba向右,menu,it's my life,outline的部署和使用,没有评论,现在你明白了吧，这是一款google出的工具,continue reading,study note,18c新特性的一些小结,下面，我从我的角度，来快速review一下值得关注的18 …,官方推荐的mysql参数设置值,一条评论,今天，在找mysql补丁的时候，在metalink找到一篇非常好的文章,这oracle官方推荐的在oltp环境下，mysql参数设置的最佳实践,pg的跨库查询

SERVER

nginx/1.10.1

POWERED BY

PHP/5.6.23

CONTENT-TYPE

utf-8

GOOGLE PREVIEW

OracleBlog – 天堂向左 DBA向右 | oracleblog.org Reviews

https://oracleblog.org

Outline的官方网站是 https:/ getoutline.org/en/home out […]. Oracle 18c在2018-02-16 release出来的，还是秉承着Oracle的cloud first理念，18c现在cloud和Engineered Systems上推出，想在传统的机器上安装18c，估计还要等到2018年下半年。 APPLIES TO: MySQL Server – Versio […]. 昨天开发请我建立了一个只读用户abc tmp test用户，并且将mkl rw用户下的32个表授权给只读用户用。 Oracle 12.2 新特性介绍. 计划明年等12.2.0.2出来之后，在公司全面推行oracle 12.2版本数据库。 PDF下载 Oracle 12.2新特性介绍. Mysql和mssql的跨库查询，基本只需要dbname.schema.table name就可以实现，而pg的跨库查询，和oracle一样，需要通过类似dblink的方式来实现。岗位职责 1. 负责内网和云上 aws和阿里云数据库的故障响应。所以，我们不得不采用on com […].

INTERNAL PAGES

oracleblog.org

1

» 另一种找asm disk dir的方法 OracleBlog -天堂向左 DBA向右

https://oracleblog.org/working-case/another-way-to-find-asm-disk-dir

183; 作者小荷. 183; 永久链接: http:/ www.oracleblog.org/working-case/another-way-to-find-asm-disk-dir/. Oracle@rac1 amdu 2015 07 20 10 37 24]$ amdu -dump ALL -diskstring '/dev/asm*'. Amdu 2015 07 20 10 54 35/. AMDU-00204: Disk N0001 is in currently mounted diskgroup ACFS. AMDU-00201: Disk N0001: '/dev/asm-acfs01'. AMDU-00204: Disk N0004 is in currently mounted diskgroup DATA. AMDU-00201: Disk N0004: '/dev/asm-data02'. AMDU-00204: Disk N0007 is in currently mounted diskgroup MYTEST. Rw-r- r- . 1 oracle oinst...

2

» HP平台的asm要求maxfiles_lim参数为32767 OracleBlog -天堂向左 DBA向右

https://oracleblog.org/working-case/asm-require-maxfiles_lim-32767-on-hpux

183; 作者小荷. 183; 永久链接: http:/ www.oracleblog.org/working-case/asm-require-maxfiles lim-32767-on-hpux/. 在169706.1文档上，11gR1之前是设置65536的，在11gR2上要求参考install guide，而install guide上写的是32767. 加asm磁盘的时候，无法加成功，报错disk is not visiable in cluster-wide，同时伴随报错ora-27070。初步怀疑和Bug 17264575 : ORA27070 AND HPUXIA64 ERROR: 15 AND DISKGROUP DISMOUNT AFTER ADDING NEW吻合。根据Bug 17264575和Doc ID 1604055.1，虽然研发说要将maxfiles lim改小到32767。 Asynchronous IO on HP limits the max value of the file descriptor used to. Maxfiles lim 63488 63488.

3

» 11g库shutdown导致10g库的crsd进程重启 OracleBlog -天堂向左 DBA向右

https://oracleblog.org/working-case/11gr2-single-instance-database-shutdown-cause-pre-11gr2-crsd-restart

183; 作者小荷. 183; 永久链接: http:/ www.oracleblog.org/working-case/11gr2-single-instance-database-shutdown-cause-pre-11gr2-crsd-restart/. 2011-10-16 11:35:35.827: [ OCRAPI][267]procr open key: Invalid keyname [CRS.CUR.]. Component too big. 2011-10-16 11:35:35.827: [ CRSOCR][267] OCR api procr open key failed for key CRS.CUR. OCR error code = 8 OCR error msg: PROC-8: Cannot perform cluster registry operation because one of the parameters is invalid. 2011-10-16 11:35:35.828: [ CRSD][267] Done. It's my life.

4

» 配置odbc透明网关实现oracle访问postgres DB OracleBlog -天堂向左 DBA向右

https://oracleblog.org/working-case/config-odbc-gw-to-access-pg-db-from-oracle

183; 作者小荷. 183; 永久链接: http:/ www.oracleblog.org/working-case/config-odbc-gw-to-access-pg-db-from-oracle/. 1 listener.ora和tnsnames.ora的配置. Wsj81@localhost admin]$ cat listener.ora. Listener.ora Network Configuration File: /wsj/oracle/app/product/11.2.0/dbhome 1/network/admin/listener.ora. Generated by Oracle configuration tools. SID LIST ORCL =. SID NAME = pgdb). ORACLE HOME = /wsj/oracle/app/product/11.2.0/dbhome 1). ADDRESS = (PROTOCOL = TCP)(HOST = 19.89.64.111)(PORT = 1531). Protocl = 6.4. Select use...

5

» 高IO下的library cache lock 和cursor pin S wait on X OracleBlog -天堂向左 DBA向右

https://oracleblog.org/working-case/high-io-cause-library-cache-lock-and-cursor-pin-s-wait-on-x

高IO下的library cache lock 和cursor pin S wait on X. 183; 作者小荷. 183; 永久链接: http:/ www.oracleblog.org/working-case/high-io-cause-library-cache-lock-and-cursor-pin-s-wait-on-x/. 今天，客户端某数据库遭遇大量library cache lock 和cursor pin S wait on X的问题，经诊断发现是由于他们底层的ASM存储是多个库共享的，故障时间段别的库占用大量的IO，导致paitsm库的IO响应变慢，db file sequential read从平时的20多毫秒，到了故障时的400多毫秒。且这个库大量的sql使用了SPM，库中有近5000条baseline，连select 1 from dual这样的简单SQL也使用了SPM。在这2个因素的共同作用下，导致了大量library cache lock 和cursor pin S wait on X。 117 'db file sequential read'. 虽然我们从p...

UPGRADE TO PREMIUM TO VIEW 15 MORE

TOTAL PAGES IN THIS WEBSITE

20

LINKS TO THIS WEBSITE

acoug.org

ACOUG会员项目(ACOUG MEMBERSHIP PROGRAM)-中国 Oracle 用户组

http://www.acoug.org/acoug-membership-program

ACOUG Senior Member(ASM) 资深会员. 会员是该项目的入门级，是那些在ACOUG社区中刚刚开始活动但是渴望在更高的层次做出贡献的人士 ASM 则是那些已经在社区中做出卓越贡献的人士。成为 ACOUG Member(AM) 会员有哪些好处. 在ACOUG网站中被标志和推荐为 ACOUG Member 会员. ACOUG Member(AM) 会员的义务. 成为 ACOUG Senior Member(ASM) 资深会员有哪些好处. 在ACOUG网站中被标志和推荐为 ACOUG Senior Member 专家. 可使用ACOUG Senior Member(ASM) logo. 有机会参加每年的ACOUG Borad Member(ABM) 董事成员候选人评选，进入ACOUG董事会. ACOUG Senior Member(ASM) 资深会员的义务. 对于当年没有任何文章、活动贡献的会员，将保留把该会员的ACOUG Member状态修改为 ACOUG Alumnus(ACOUG校友(前会员) 的权力，直至下一次申请通过。 Eygle – 盖国强. 老熊 – 熊军.

laoxiong.net

老熊的三分地-Oracle及数据恢复 » Oracle数据库管理

http://www.laoxiong.net/category/oracle/oraman

Oracle 11g Data Guard环境中的归档管理. 在11g里面，随着ASM、RAC、Data Guard 包括Active Data Guard 的成熟，使用RAC ASM Data Guard越来越成为一种可靠的、维护简单、稳定的高可用性和容灾保护方案。这篇文章谈谈如何管理Oracle 11g Data Guard环境中的归档日志。使用快速恢复区(fast recovery area)，在10g版本的文档中称为闪回恢复区 flash recovery area ，老实说，一直不太明白为什么取名叫闪回恢复区，难道是因为10g有了数据库闪回功能在RAC中，毫无疑问快速恢复区最好是置放在ASM上。最后为快速恢复区指定需要的空间量，比通过参数db recovery file dest size指定快速恢复区的大小。对主库和备份使用RMAN配置归档删除策略 CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY;. 和 delete archivelog all. 和 delete archivelog all.

laoxiong.net

老熊的三分地-Oracle及数据恢复 » 下载

http://www.laoxiong.net/download

Middot; coogee theme.

laoxiong.net

老熊的三分地-Oracle及数据恢复 » ODU

http://www.laoxiong.net/odu

关于ODU的详细情况，请移步访问 http:/ www.oracleodu.com. Middot; coogee theme.

laoxiong.net

老熊的三分地-Oracle及数据恢复 » 仅仅只备份是不够的

http://www.laoxiong.net/backing-up-is-not-enough.html

是不是我们的数据库，加上一套成熟可靠的备份软件比如NBU、DP、TSM等，以及购置了可靠的大容量的带库就足够了或者下面一个案例能够给我们一些启示。 List backup of archivelog sequence 18884 thread 2;. List backup of archivelog all;. 第1种情况，可以从v$archived log视图判断归档日志到底有没有备份通过BACKUP COUNT列。那备份怎么消失了在备份操作的日志目录中，还发现一个日志文件有crosscheck backup然后delete expired backup的记录，而被删除的备份正好有恢复所需要的归档日志所在的备份。只不过这里要注意的是既然crosscheck不能访问不到备份，那么delete操作也应当不会真正删除备份备份都访问不到怎么能物理删除呢，只是把备份信息从catalog里面删除掉而已。 DECLARE v dev varchar2(50); v done boolean:=false; BEGIN v dev:=sys.dbms backup restore&#46...

laoxiong.net

老熊的三分地-Oracle及数据恢复 » jdbc

http://www.laoxiong.net/tag/jdbc

硬解析，过多的硬解析在系统中产生shared pool latch和library cache liatch争用，消耗过多的shared pool，使得系统不具有可伸缩性。 E: JavaCode set CLASSPATH=. ojdbc14.jar E: JavaCode d: works Java jdk1.5.0 21 bin javac TestStmtCache.java E: JavaCode d: works Java jdk1.5.0 21 jre bin java TestStmtCache. OracleConnection)conn).setStatementCacheSize(20); ( OracleConnection)conn).setImplicitCachingEnabled(true);. Pstmt = ( OracleConnection)conn).getStatementWithKey ("cache test1"); if (pstmt= null). 测试环境 Oracle 11.2.0.2 for Windows。 Javasql.SQLExc...

laoxiong.net

老熊的三分地-Oracle及数据恢复 » Oracle开发

http://www.laoxiong.net/category/oracle/oracle开发

测试环境 Oracle 11.2.0.2 for Windows。 TEST@xj11g create table t1 ( id number primary key,name varchar2(20) ; 表已创建。 TEST@xj11g create table t2 ( id number primary key,name varchar2(20) ; 表已创建。 TEST@xj11g insert into t2 values (1,'a'); 已创建 1 行。 TEST@xj11g commit; 提交完成。 E: JavaCode d: works java jdk1.5.0 21 bin javac TestTimeout.java. TEST@xj11g update t2 set name='y' where id=1; 已更新 1 行。 E: JavaCode set CLASSPATH=ojdbc14.jar;. E: JavaCode d: works java jdk1.5.0 21 jre bin java TestTimeout. Javasql.SQLExcep...

laoxiong.net

老熊的三分地-Oracle及数据恢复 » Oracle性能优化

http://www.laoxiong.net/category/oracle/oraperf

一个省级电信运营商，将核心的CRM系统Oracle数据库进行了升级迁移，成功地从原来运行在IBM 595平台上的双节点10.2.0.5 RAC数据库，迁移并升级到基于x86 vmware平台的双节点11.2.0.3 RAC数据库上。后来我与这套系统的DBA商量，对手工要收集统计信息的表进行了梳理，去掉可能会引起问题的直方图，对某些表上的某些列必须收集直方图，最后将dbms stats.gather table stats中的method opt参数改为for all column size repeat，之后基本上再没出现过统计信息变更导致性能的问题。 2010新数据库随应用的升级同时升级到了10.2.0.5版本。此次升级到11.2.0.3，我们将面临两个问题. 为了保证这个策略是可行的，SPA SQL Performance Analyzer 就派上了用场。硬解析，过多的硬解析在系统中产生shared pool latch和library cache liatch争用，消耗过多的shared pool，使得系统不具有可伸缩性。 Y seg/obj: 0x5f07 csc: 0xb08.1...

UPGRADE TO PREMIUM TO VIEW 88 MORE

TOTAL LINKS TO THIS WEBSITE

96

OTHER SITES

oraclebleu.eu

Didier Doryan

12 Rue du Pré "Le Suquet" 06400 Cannes. Tel: 04.92.59.03.81. Gsm: 06.15.18.17.38. Didier DORYAN avec son don vous éclaire et vous Coach. En cabinet ou par téléphone. Auteur, Conférencier, Sélectionné dans le guide de la voyance, Expert dans besoin de savoir.com. Avec sa clairvoyance, son parcours radio sur RTL2. Découvrez le livre événement :. Les PREDICTIONS 2012 - La révélation. Voir la 4e de couverture. A LA UNE, avec LES PREDICTIONS 2012, la Révélation. De Renom et Auteur des albums Zodiak.

oracleblfoundation.org

Oracle BL Foundation | Passion for God, Compassion for Humanity!

OBLF visits NAFDAC in Abuja. OBLF at Benue State Ministry of Health. ORACLE BUSINESS LTD FOUNDATION. Support us or get support from us.

oracleblog.cn

oracleblog.com

This domain is for sale. You can buy it right now! Buy at Sedo.com. Buy at afternic.com. The Sponsored Listings displayed above are served automatically by a third party. Neither the service provider nor the domain owner maintain any relationship with the advertisers. In case of trademark issues please contact the domain owner directly (contact information can be found in whois).

oracleblog.net

oracleblog.net - This website is for sale! - oracle blog Resources and Information.

The owner of oracleblog.net. Is offering it for sale for an asking price of 149 USD! The owner of oracleblog.net. Is offering it for sale for an asking price of 149 USD! This webpage was generated by the domain owner using Sedo Domain Parking. Disclaimer: Sedo maintains no relationship with third party advertisers. Reference to any specific service or trade mark is not controlled by Sedo nor does it constitute or imply its association, endorsement or recommendation.

oracleblog.org

OracleBlog – 天堂向左 DBA向右

Outline的官方网站是 https:/ getoutline.org/en/home out […]. Oracle 18c在2018-02-16 release出来的，还是秉承着Oracle的cloud first理念，18c现在cloud和Engineered Systems上推出，想在传统的机器上安装18c，估计还要等到2018年下半年。 APPLIES TO: MySQL Server – Versio […]. 昨天开发请我建立了一个只读用户abc tmp test用户，并且将mkl rw用户下的32个表授权给只读用户用。 Oracle 12.2 新特性介绍. 计划明年等12.2.0.2出来之后，在公司全面推行oracle 12.2版本数据库。 PDF下载 Oracle 12.2新特性介绍. Mysql和mssql的跨库查询，基本只需要dbname.schema.table name就可以实现，而pg的跨库查询，和oracle一样，需要通过类似dblink的方式来实现。岗位职责 1. 负责内网和云上 aws和阿里云数据库的故障响应。所以，我们不得不采用on com […].

oracleblog4apps.blogspot.com

oracle apps tech n func

Oracle apps tech n func. Monday, August 4, 2008. Accounting For Oracle Receivables. Flow of Accounting Information:. Whether you are manually entering your receipts or processing them through AutoLockbox, the accounting information is automatically determined by Oracle Receivables when you create and apply the receipts (not when it is still a "QuickCash" batch). The values used are based on the setup values for the bank where the receipts were deposited and the invoices they are paying. 1 Always run the ...

oracleblogau.com

Oracle Blog | Observations on cricket, footy and other things

Australia regain the Ashes. December 18, 2013. So Australia have regained the Ashes; its first Ashes victory in the full social media era. England haven’t just been beaten, they’ve been thrashed. And we all know how social media reacts to a thrashing. Here a some tweets I enjoyed finding after a few horror days for Poms. Pathetic and embarrassing by England #Ashes. Mdash; Mark B (@markbeams) December 15, 2013. Waking up to another England collapse. #theashes. Mdash; Nic W (@niwise) December 15, 2013.

oracleblogger.com

How to get Inspiration and motivated/Inpirational speeches

Benefits of Weight Loss Camps over Fat Camps. Advantages of in vitro fertilization treatments. 6 Characteristics of Good Weight Loss Camp for Adults. California Fertility Center Help Families Become Complete. Wednesday, July 22, 2015. By Redemption you are a god. This is a fundamental, powerful truth that, if for any reason it enters your heart, it will make you unshakable, immovable, triumphant, buoyant and blossoming! It will become a foundation that cannot be shaken! This is the basis for the supernat...

oracleblogging.wordpress.com

Oracle: Bits and Bobs | Oracle: configuration, performance, maintenance and other interesting or unusual things.

Oracle: Bits and Bobs. Oracle: configuration, performance, maintenance and other interesting or unusual things. Bulk Collections and Parallel Processing. September 6, 2011. A way to speed up the ETL cycle. There are many situations when need to carry out something like:. For x in (select * from t1). Process the row;. Insert into t2 values ( …. );. End loop ;. This is a very slow way of processing things. There are 3 ways we can improve this:. 1) use bulk select. In cases where you need to call PL/SQL bet...

oracleblogs.com

Oracle Blogs

An all new Oracle Blog Aggregator, run by DBAs for DBAs! Today at blogs.oracle.com. Just a holding page. Until I start to add some content, don’t expect to see much here. 2015 Oracle Blogs - WordPress Theme by Kadence Themes.