oracle-dba-scripts.blogspot.com

Oracle DBA Stuff

A blog for Oracle DBAs.

http://oracle-dba-scripts.blogspot.com/

OVERVIEW OF oracle-dba-scripts.blogspot.com

TRAFFIC RANK

>1,000,000

REVIEWS

0

PAGES IN THIS WEBSITE

15

LINKS TO THIS WEBSITE

CONTACTS

ADDRESSES

SOCIAL LINKS

ONLINE SINCE

WEBSITE DETAILS

SEO

PAGES

SIMILAR SITES

TRAFFIC RANK FOR ORACLE-DBA-SCRIPTS.BLOGSPOT.COM

TODAY'S RATING

>1,000,000

TRAFFIC RANK - AVERAGE PER MONTH

BEST MONTH

March

AVERAGE PER DAY Of THE WEEK

HIGHEST TRAFFIC ON

Tuesday

TRAFFIC BY CITY

Sign up

CUSTOMER REVIEWS

Average Rating: 3.8 out of 5 with 15 reviews

5 star

7

4 star

2

3 star

4

2 star

0

1 star

2

Hey there! Start your review of oracle-dba-scripts.blogspot.com

AVERAGE USER RATING

Write a Review

WEBSITE PREVIEW

LOAD TIME

0.3 seconds

FAVICON PREVIEW

16x16
32x32

CONTACTS AT ORACLE-DBA-SCRIPTS.BLOGSPOT.COM

ADD CONTACT

Login

TO VIEW CONTACTS

Remove Contacts

FOR PRIVACY ISSUES

CONTENT

PAGES IN
THIS WEBSITE

15

SSL

EXTERNAL LINKS

0

SITE IP

172.217.11.33

LOAD TIME

0.266 sec

SCORE

6.2

PAGE TITLE

Oracle DBA Stuff | oracle-dba-scripts.blogspot.com Reviews

<META> DESCRIPTION

A blog for Oracle DBAs.

<META> KEYWORDS

1 oracle dba stuff

2 register mview log

3 mlog$ sales int

4 posted by

5 richard armstrong finnerty

6 no comments

7 older posts

8 followers

9 coupons

10 reviews

CONTENT

Page content here

KEYWORDS ON PAGE

oracle dba stuff,register mview log,mlog$ sales int,posted by,richard armstrong finnerty,no comments,older posts,followers

SERVER

GSE

CONTENT-TYPE

utf-8

GOOGLE PREVIEW

Oracle DBA Stuff | oracle-dba-scripts.blogspot.com Reviews

https://oracle-dba-scripts.blogspot.com

A blog for Oracle DBAs.

INTERNAL PAGES

oracle-dba-scripts.blogspot.com

1

Oracle DBA Stuff: February 2012

http://oracle-dba-scripts.blogspot.com/2012_02_01_archive.html

A dumping ground for various Oracle DBA scripts, fixes, findings, and other stuff. Wednesday, 1 February 2012. Replication: Archive Destination in Error. Replication, even with Data Guard Broker, can be a challenge sometimes, especially if replication stops, and everything looks OK, leading to the Big Question: What's wrong with the #@! If all else fails, it may be worth taking a look at Archive Dest status on the Primary instances. Will not, necessarily, show in-error archive dest. Col DEST NAME form A25.

2

Oracle DBA Stuff: June 2015

http://oracle-dba-scripts.blogspot.com/2015_06_01_archive.html

A dumping ground for various Oracle DBA scripts, fixes, findings, and other stuff. Tuesday, 16 June 2015. DBMS REDEFINITION and Materialized View Logs. If you are redefining a table that has a materialized view log, then be careful to use the MView Log table name, rather than the MView Log name, for the registration. EXEC DBMS REDEFINITION.REGISTER DEPENDENT OBJECT('SCOTT','SALES','SALES INT',DBMS REDEFINITION.CONS MVLOG,'SCOTT',' MLOG$ SALES. Links to this post. Subscribe to: Posts (Atom).

3

Oracle DBA Stuff: March 2013

http://oracle-dba-scripts.blogspot.com/2013_03_01_archive.html

A dumping ground for various Oracle DBA scripts, fixes, findings, and other stuff. Saturday, 23 March 2013. V$SESSION LONGOPS Time Remaining. V$SESSION LONGOPS with Time Remaining in day, hour, minute, and second format:. Col ETA form a20. Col TARGET form a30. Col MESSAGE form a70. Col USERNAME form a12. FROM (SELECT INST ID. DECODE(TO CHAR(TRUNC(ROUND(ELAPSED SECONDS*(TOTALWORK-SOFAR)/SOFAR)/(24*60*60) ) 'd ','0d ',NULL,TO CHAR(TRUNC(ROUND(ELAPSED SECONDS*(TOTALWORK-SOFAR)/SOFAR)/(24*60*60) ) 'd ','0d ').

4

Oracle DBA Stuff: July 2012

http://oracle-dba-scripts.blogspot.com/2012_07_01_archive.html

A dumping ground for various Oracle DBA scripts, fixes, findings, and other stuff. Friday, 27 July 2012. Stopping Auditing of Objects. Assume you have set-up auditing of tables in the following 3 schemas:. The purpose of the auditing is to check whether any of the schemas' tables is no longer being used i.e. not queried or changed in any way. Any unused tables in these schemas will be dropped as part of housekeeping. You want to stop AUD$. Where owner in ('FINANCE1','DATAUSER2','REPORTUSER9');. SELECT * ...

5

Oracle DBA Stuff: August 2012

http://oracle-dba-scripts.blogspot.com/2012_08_01_archive.html

A dumping ground for various Oracle DBA scripts, fixes, findings, and other stuff. Sunday, 26 August 2012. DBMS METADATA Valid Object Types. Takes object type parameters that do not always match the object type you'd find in DBA OBJECTS. Eg in the following, which gets DDL for a database link, notice that " DB LINK. Not " DATABASE LINK. Is passed as the object type:. SELECT DBMS METADATA.GET DDL(' DB LINK. And navigate to "Table 57-18 Object Type Path Names for Heterogeneous Object Types". DBMS OUTPUT&#4...

UPGRADE TO PREMIUM TO VIEW 10 MORE

TOTAL PAGES IN THIS WEBSITE

15

OTHER SITES

oracle-dba-quickanswers.blogspot.com

Oracle World

Visit www.free-online-exams.com for a free brain bumps exam preparation. Friday, November 2, 2012. Index Online Rebuild Fails with ORA-08104: this index object. Is being online built or rebuilt". Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE. Http:/ www.free-online-exams.com. Index online rebuild fails with error "ORA-08104: this index object 556463 is being online built or rebuilt". Get Oracle Certifications for all Exams. Wait for l...

oracle-dba-scripts.blogspot.com

Oracle DBA Stuff

A dumping ground for various Oracle DBA scripts, fixes, findings, and other stuff. Tuesday, 16 June 2015. DBMS REDEFINITION and Materialized View Logs. If you are redefining a table that has a materialized view log, then be careful to use the MView Log table name, rather than the MView Log name, for the registration. EXEC DBMS REDEFINITION.REGISTER DEPENDENT OBJECT('SCOTT','SALES','SALES INT',DBMS REDEFINITION.CONS MVLOG,'SCOTT',' MLOG$ SALES. Links to this post. Subscribe to: Posts (Atom).

oracle-dba-support.com

Oracle Database Support

Providing remote Oracle database support since 2005. Thursday, April 12, 2012. Some examples of the VALIDATE command. RMAN restore database validate;. RMAN restore controlfile validate;. RMAN restore spfile validate;. RMAN restore tablespace tablespace name validate;. RMAN validate backupset backupset # ;. Friday, November 11, 2011. Have you tried to backup your database after a recorery and ran into the following error: . RMAN-06059: expected archived log not found. Tuesday, September 20, 2011. A freque...

oracle-dba-tips-sam.blogspot.com

Oracle DBA Tips

Thursday, November 19, 2009. RMAN connect target sys/pwd. Connected to target database:MCDB01 (DBID=2882204056). Possible error without sysdba privilege. To connect to RMAN using a remote connection make the following entry in the tnsnames.ora. This is not needed to connect locally from) so that it is a dedicated connection. ADDRESS = (PROTOCOL = TCP)(HOST = yemsuresh01.maricorp.com)(PORT = 1521). SERVICE NAME = MCDB01). When you use RMAN do not use. Alter database backup control file to trace;. Control ...

oracle-dba-yi.blogspot.com

Oracle Explorer

This blog is to record the steps I take to explore the world of Oracle database. Friday, January 13, 2012. ASM resilvering or how to recover your crashed cluster Test no 3. Http:/ blog.ronnyegner-consulting.de/2009/10/08/asm-resilvering-%E2%80%93-or-%E2%80%93-how-to-recover-your-crashed-cluster-%E2%80%93-test-no-3/. Posted by linyi @ 6:03 PM. Friday, November 4, 2011. Some posts about RAID 5 vs. RAID 10. RAID 10 vs RAID 5: Performance, Cost, Space, and HA. More Spindles Means More IOPS? Posted by linyi @...

oracle-dba.cn

甲骨文Oracle数据库培训|Oracle培训|北京Oracle培训|Oracle培训-数据库专业培训机构

Oracle及RedHat资深讲师、Oracle OCM 认证大师，Unix/Linux 资深专家，精通Oracle9i,10g,11g数据库管理，具有丰富的培训经验。 Oracle 11g高级讲师、Unix/Linux 资深专家，Oracle认证大师，精通Oracle9i,10g,11g数据库管理，具有丰富的培训经验。甲骨文高级讲师- - - 安老师，Oracle及RedHat高级讲师、Unix/Linux 资深专家，Oracle认证大师长期致力于Oracle技术的研究和培训工作，精通Oracle9i,10g,11g数据库管理，具有丰富的培训经验。总部中心地址北京市海淀区北四环中路229号海泰大厦2层电话 010-52776976 邮编 100083. 学院路校区地址北京市海淀区成府路17号学院路邮局7层电话 010-82375957 邮编 100083.