oracledba-duniya.blogspot.com

oracledb-admin.blogspot.com

ORACLE DBA

Wednesday, April 03, 2013. RMAN-03002: failure of recover command at. ORA-06552: PL/SQL: Compilation unit analysis terminated. ORA-06553: PLS-553: character set name is not recognized. Export NLS LANG=AMERICAN AMERICA.AL32UTF8. Restarted database with above characterset. Monday, October 15, 2012. ORA-27054: NFS file system where the file is created or resides is not mounted with correct options. ORA-19504: failed to create file "/backup/rman/01nmqsmk 1 1". Thursday, July 12, 2012. Clear the agent state.

oracledb-oem-appsserver-etc.blogspot.com

All things Oracle!

Work" that I find worth sharing with other Oracle users! Join me on LinkedIn! Join us on Facebbook! Follow Us on Twitter! Subscribe to our RSS Feed! Migrating optimizer statistics from Prod to Test database's. Create stats table using. SQL EXEC DBMS STATS.CREATE STAT TABLE(ownname= 'PROD SCHEMA', stattab= 'STATS 08JAN2016');. SQL EXEC DBMS STATS.EXPORT SCHEMA STATS(ownname = 'PROD SCHEMA',stattab = 'STATS 08JAN2016');. Export the stats table using. Scp the dump file to the destination server. Disk migrat...

oracledb.com

oracledb.com

Click here to proceed.

oracledb.wordpress.com

Oracle Database Exchanging Experiences | Just another WordPress.com weblog but more technically oriented to Oracle Database

Oracle Database Exchanging Experiences. I’ve created this blog about four months ago. My initial intent was to challenge with english language, to open my possibilities to exchange experiences (from which the blog title) with other persons from all over the world. It is written in my mother-tongue so there i’ve written more information that here. I was inspired also by Jonathan Lewis and his Oracle Scratchpad. To view my posts on this blog you have to go. On this page named “All Postings”. That my sign o...

oracledb101.wordpress.com

Oracle Database 101 | Exploring Whats Possible With Data

Exploring Whats Possible With Data. March 26, 2018. 181c New Features Part I. 181 is now available on Oracle Cloud so going to cover some of the new features. Topics like Multitentant have enough new features to warrant a dedicated post. So with that lets dive in. OCI Timeout – With using the OCI driver applications can set a time out when making DB calls. This prevents a long running call or a call that is being blocked from making it look like the application is hung. Parallel Queue Timeout – Wit...

oracledba-duniya.blogspot.com

Oracle DBA

oracledba-guide.blogspot.com

Oracle DBA Guide

Wednesday, May 12, 2010. DIM-00014: Cannot open the Windows NT Service Control Manager. One of the most common error that user faced in using oradim utility is :. DIM-00014: Cannot open the Windows NT Service Control Manager. O/S-Error: (OS 5) Access is denied. This error is common in Windows Vista and windows 7 . So the solution is very simple ,. Just goto start wirte cmd ,cmd icon appears ,right click on it . Then click on "Run as administrator" and then create your required service . Nter any desired ...

oracledba-in.com

OracleDba.In - All Article of OracleDba.In

Saturday, September 28, 2013. Finding out Last DDL and DML Activity on a Table. I received one of a mail with the query of how could we figure out Last DML and DDL time on a table. Here is a small piece of SQL Commands to get the same info. Create table t (t1 number,t2 varchar2(20),t3 date);. Here is how you could find the same. 2 (select last ddl time from dba objects where object name='T' and owner='SYS') "DDL Time",. 3 decode(maxscn,0,'N/A',scn to timestamp(maxscn) "DML Time". DDL Time DML Time. 2012-...

oracledba-interview.blogspot.com

Oracle DBA Interview

Tuesday, March 30, 2010. Oracle DBA 11g Lesson- 28 Monitoring and Tuning RMAN. Oracle DBA Interview Questions and Answers, CBT, Oracle E-books, Certifications http:/ oracledba-interview.blogspot.com. 1)This is a workshop for 11G complete each ppt in 1 days and 25 days u can become gem in oracle 11g DBA. 2)This below form is PPT so office 2003 or 2007 should be available in system to see it clearly. 3)Each PPT contain 10 to 50 slides so click the next button to see the next side. Les 10 Tune Rman. Oracle ...

oracledba-kuwait.blogspot.com

CORE DBA KNOWLEDGE SOURCE

CORE DBA KNOWLEDGE SOURCE. Thursday, January 3, 2008. Oracle Application Documents Downloadable. Oracle Application release 12 Documents http:/ downloaduk.oracle.com/docs/cd/B34956 01/current/html/docset.html. Releas12 ,12,11i,11i http:/ www.oracle.com/technology/documentation/applications.html. Release 11.5.10.2 Document libraury http:/ download.oracle.com/docs/cd/B25516 18/current/html/docset.html. Tuesday, January 1, 2008. 7 Tips on becoming an ERP consultant. The beauty of this ERP is, it always keep...

oracledba-ocp.blogspot.com

Oracle D.B.A. - O.C.P.

Oracle D.B.A. - O.C.P. Este sitio esta dedicado a todas las personas que dia a dia trabajamos en la ardua tarea de administrar, optimizar y estudiar el RDBMS de ORACLE Corp. EXPLICACION DEL ITL ENQUEUE. Query para verificar que un evento enqueue hace . Cambiar el poder de balanceo de una instancia ASM. Ing Juan Carlos Castro. Ing de Sistemas en la U.D.A., O.C.P. ORACLE 10G. Ver todo mi perfil. Martes, 31 de marzo de 2009. EXPLICACION DEL "ITL ENQUEUE". SID SERIAL# TY OBJECT NAM HELD REQUEST. Una vez que ...