oracledba.in

OracleDba.In - Article for Oracle Community

Share this Page on. Recent Articles - Written by Oracle Experts. DBMS REDEFINITION 12c Enhancement. By Ritesh Raj Singh. Column Drop without downtime using DBMS Redefinition. By Ritesh Raj Singh. Materialized view Refresh - Atomic Refresh False without Unavailability of Data - Part 2. By Ritesh Raj Singh. Materialized view Refresh - Atomic Refresh False without Unavailability of Data - Part 1. By Ritesh Raj Singh. Finding I/O Usage Per Device / Datafile At Oracle. By Ritesh Raj Singh. By Ritesh Raj Singh.

http://www.oracledba.in/

OVERVIEW OF oracledba.in

TRAFFIC RANK

>1,000,000

REVIEWS

0

PAGES IN THIS WEBSITE

6

LINKS TO THIS WEBSITE

CONTACTS

ADDRESSES

SOCIAL LINKS

ONLINE SINCE

WEBSITE DETAILS

SEO

PAGES

SIMILAR SITES

TRAFFIC RANK FOR ORACLEDBA.IN

TODAY'S RATING

>1,000,000

TRAFFIC RANK - AVERAGE PER MONTH

BEST MONTH

January

AVERAGE PER DAY Of THE WEEK

HIGHEST TRAFFIC ON

Sunday

TRAFFIC BY CITY

Sign up

CUSTOMER REVIEWS

Average Rating: 3.5 out of 5 with 13 reviews

5 star

3

4 star

5

3 star

3

2 star

0

1 star

2

Hey there! Start your review of oracledba.in

AVERAGE USER RATING

Write a Review

WEBSITE PREVIEW

LOAD TIME

FAVICON PREVIEW

16x16
32x32
64x64
128x128

CONTACTS AT ORACLEDBA.IN

ADD CONTACT

Login

TO VIEW CONTACTS

Remove Contacts

FOR PRIVACY ISSUES

CONTENT

PAGES IN
THIS WEBSITE

6

SSL

EXTERNAL LINKS

33

SITE IP

0.0.0.0

LOAD TIME

0 sec

SCORE

6.2

PAGE TITLE

OracleDba.In - Article for Oracle Community | oracledba.in Reviews

<META> DESCRIPTION

Share this Page on. Recent Articles - Written by Oracle Experts. DBMS REDEFINITION 12c Enhancement. By Ritesh Raj Singh. Column Drop without downtime using DBMS Redefinition. By Ritesh Raj Singh. Materialized view Refresh - Atomic Refresh False without Unavailability of Data - Part 2. By Ritesh Raj Singh. Materialized view Refresh - Atomic Refresh False without Unavailability of Data - Part 1. By Ritesh Raj Singh. Finding I/O Usage Per Device / Datafile At Oracle. By Ritesh Raj Singh. By Ritesh Raj Singh.

<META> KEYWORDS

1 about us

2 submit article

3 online trainings

4 scripts

5 subject

6 last updated

7 buffer busy waits

8 debugging asmcmd

9 data type mismatched

10 disclaimer

CONTENT

Page content here

KEYWORDS ON PAGE

CONTENT-TYPE

utf-8

GOOGLE PREVIEW

OracleDba.In - Article for Oracle Community | oracledba.in Reviews

https://oracledba.in

Share this Page on. Recent Articles - Written by Oracle Experts. DBMS REDEFINITION 12c Enhancement. By Ritesh Raj Singh. Column Drop without downtime using DBMS Redefinition. By Ritesh Raj Singh. Materialized view Refresh - Atomic Refresh False without Unavailability of Data - Part 2. By Ritesh Raj Singh. Materialized view Refresh - Atomic Refresh False without Unavailability of Data - Part 1. By Ritesh Raj Singh. Finding I/O Usage Per Device / Datafile At Oracle. By Ritesh Raj Singh. By Ritesh Raj Singh.

INTERNAL PAGES

oracledba.in

1

OracleDba.In - Article for Oracle Community

http://www.oracledba.in/AboutUs/AboutUs.aspx

Share this Page on. About Us - OracleDba.In is promoted and Managed by ARC Digital Solutions Private Limited. ARC Digital Solutions Pvt. Ltd. Is promoted by Gameking Industries Pvt Ltd. Professionals at ARC Digital Solutions have varied certification. Oracle Certified Masters (OCMs). Certified Project Management Professionals (PMPs). Oracle Real Application Clusters Administrator Certified Expert (RAC Expert). Oracle Certified Professionals (OCPs). Sun Certified Systems And Network Administrators. Sharad...

2

OracleDba.In - Article for Oracle Community

http://www.oracledba.in/OnlineTraining/OnlineTraining.aspx

Share this Page on. Current Training Calendar for the Upcoming Oct/ Nov 2013. No Free Trainings are available right now. Commercial Training Scheduled on:. No Commercial Trainings are available right now. No Trainings are available right now.

3

OracleDba.In - Article for Oracle Community

http://www.oracledba.in/Admin_List_Article.aspx

Share this Page on. Remember me next time.

4

OracleDba.In - Article for Oracle Community

http://www.oracledba.in/Home.aspx

Share this Page on. Recent Articles - Written by Oracle Experts. DBMS REDEFINITION 12c Enhancement. By Ritesh Raj Singh. Column Drop without downtime using DBMS Redefinition. By Ritesh Raj Singh. Materialized view Refresh - Atomic Refresh False without Unavailability of Data - Part 2. By Ritesh Raj Singh. Materialized view Refresh - Atomic Refresh False without Unavailability of Data - Part 1. By Ritesh Raj Singh. Finding I/O Usage Per Device / Datafile At Oracle. By Ritesh Raj Singh. By Ritesh Raj Singh.

5

OracleDba.In - Article for Oracle Community

http://www.oracledba.in/Disclaimer.aspx

Share this Page on. Oracledba.in or ARC Digital Solutions Pvt. Ltd. Expressly disclaims all other express or implied warranties. ARC Digital Solutions Pvt. Ltd. Is providing online training and Online Support content on an as is or as available basis without any warranties or representations whatsoever, either express, implied, statutory or otherwise and specifically does not provide warranties with respect to your use of or access to the support content. And its licensor as set forth herein are exclusiv...

UPGRADE TO PREMIUM TO VIEW 1 MORE

TOTAL PAGES IN THIS WEBSITE

6

LINKS TO THIS WEBSITE

oracledba-in.com

OracleDba.In - All Article of OracleDba.In: April 2013

http://www.oracledba-in.com/2013_04_01_archive.html

Wednesday, April 24, 2013. Materialized view Refresh - Atomic Refresh False without Unavailability of Data - Part 2. Materialized view Refresh - Atomic Refresh False without Unavailability of Data - Part 2. First part of this article is here. In this article i will demonstrate how we can let summarized data or mview data available to application even when the refresh is happening via atomic refresh= false, i will use the same table which is created in part 1 of this article. 5 from my base table. 1 creat...

oracledba-in.com

OracleDba.In - All Article of OracleDba.In: Finding out Last DDL and DML Activity on a Table

http://www.oracledba-in.com/2013/09/test.html

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-in.com

OracleDba.In - All Article of OracleDba.In: December 2010

http://www.oracledba-in.com/2010_12_01_archive.html

Friday, December 17, 2010. List All X$ Tables. This will return all the x$ views available on database. Select KQFTANAM fromx$kqfta;. For Original Article Click Here. Articles from www.oracledba.in. Posted by Ritesh Raj Singh. Links to this post. Backup Generating Redo Disable Log Blocks During Backup. One of My Visitor asked following question in the morning today. Please explain the concept of split block in concern of hot backup and. Is true by default. This is what oracle engine will do,. Step 1 : Fr...

oracledba-in.com

OracleDba.In - All Article of OracleDba.In: September 2013

http://www.oracledba-in.com/2013_09_01_archive.html

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-in.com

OracleDba.In - All Article of OracleDba.In: August 2010

http://www.oracledba-in.com/2010_08_01_archive.html

Thursday, August 19, 2010. Shared memory segment parameters in solaris. Kernel.shmall = 2097152. Kernel.shmmax = 536870912. Kernel.shmmni = 4096. Kernel.sem = 250 32000 100 128. Netipv4.ip local port range = 9000 65500. Netcore.rmem default = 262144. Netcore.rmem max = 4194304. Netcore.wmem default = 262144. Netcore.wmem max = 1048586. For Original Article Click Here. Articles from www.oracledba.in. Posted by Ritesh Raj Singh. Links to this post. Subscribe to: Posts (Atom). Oracle Features - Licensing.

oracledba-in.com

OracleDba.In - All Article of OracleDba.In: August 2012

http://www.oracledba-in.com/2012_08_01_archive.html

Friday, August 31, 2012. ORA-00997 Materailized view on Long columns@Oracle 9i. An interesting requirement came today morning, a Materialized view failing with Long column in the input. The long column had less than 4000 character of data, and front end application expects the resultant output in varchar2 (for the long column) out of the materialized view. At first instance, it felt easy, now lets see what were the challenge andlearning. Long column on Materialized view returns. Here is the test case.

appmanagementblog.com

Application Management Blog: The Next Generation of Oracle Enterprise Manager Will Arrive in 7 Days!

http://www.appmanagementblog.com/2010/04/next-generation-of-oracle-enterprise.html

Thursday, April 15, 2010. The Next Generation of Oracle Enterprise Manager Will Arrive in 7 Days! Seven more days to go before we launch Oracle Enterprise Manager 11g. We invite you to join us for this exciting announcement. You may attend the event in person if you are going to be in New York City next Thursday (4/22) or over the web via our webcast. We will also be hosting a live simulcast event at the Collaborate conference in Las Vegas. To register for the live event in New York City.

samsudeenb.blogspot.com

Sam's SQL Server blog: Scripts to Drop and ReCreate Indexes in SQL Server 2005

http://samsudeenb.blogspot.com/2007/11/scripts-to-drop-and-recreate-indexes-in.html

Sam's SQL Server blog. Tips, Design principles, Best practices. Wednesday, 14 November 2007. Scripts to Drop and ReCreate Indexes in SQL Server 2005. SQL Server 2005 “GENERATE SCRIPTS” wizard does not have the option to generate the Index scripts alone from the database. The below script can be used to DROP and recreate the Indexes from the database. Steps to be followed. DECLARE @i int, @thiskey NVARCHAR(131) , @objid BIGINT. SELECT @objid = object id(@objname). SELECT @keys = @keys '(-)'. NONCLUSTERED ...

toreingolf.blogspot.com

TC's Blog: Oracle's Online Documentation

http://toreingolf.blogspot.com/2009/11/oracles-online-documentation.html

Wednesday, November 04, 2009. Oracle publishes its online documentation. Using URLs which contain a version number (e.g. " 01"). If you bookmark such a URL, you will not know if the documentation has been updated (e.g. " 19"). This makes it difficult to maintain personal bookmarks and other links to Oracle's documentation. Back in November 2005. Tore I. Christoffersen. May 8, 2010 at 2:01 PM. Subscribe to: Post Comments (Atom). Tore I. Christoffersen. OCM: I wish to remain uninformed.

UPGRADE TO PREMIUM TO VIEW 24 MORE

TOTAL LINKS TO THIS WEBSITE

33

SOCIAL ENGAGEMENT

pages/OracleDbaIn/174033389274381

oracledbainfo

OTHER SITES

oracledba.com.br

2Com Consulting

Atender as necessidades de nossos clientes, suprindo as expectativas através da qualidade e bom atendimento. Atuamos em diversos segmentos do mercado e estamos prontos para atender as demandas de TI de sua empresa. Nossos especialistas analisam e recomendam os melhores serviços e investimentos. Armazenamento de informações online é uma maneira simples e segura para fazer o backup de todos os dados contidos nos servidores de sua empresa. Permite a rápida coleta de dados, com mais eficiência e precisão&#46...

oracledba.cz

Oracle DBA

Přehled pozic v oblasti databázový adminitrátor (DBA) www.databazovy-administrator.cz. Http:/ docs.oracle.com/cd/B10501 01/server.920/a96521/dba.htm. The job of the DBA seems to be everything that everyone else either doesn't want to do, or doesn't have the ability to do. DBAs get the enviable task of figuring out all of the things no one else can figure out. More seriously though, here is a list of typical DBA responsibilities:. Evaluate Oracle features and Oracle related products. Ability to perform bo...

oracledba.ezpowell.com

OracleDBAExpert.com: Oracle DBA and Web Development Consulting

Internet Marketing for Independent Musicians. Subscribe to Internet Marketing for Musicians by EZPowell. Subscribe to Internet Marketing for Musicians by Email. My Creative Writing Blog. The EZPowell Band: Bedroom Eyes (Amazon) (Nov 2006). Bedroom Eyes CD (Nov 2006). EZPowell's Radio Station Air-Play (Nov 2006). Database Modeling from 0 to 60 in 4 Seconds (Jan 2011). Oracle Enterprise Linux Administrator Certified Associate Exam Guide (Exams 1Z0-402 and 1Z0-403) (May 2009). Access 2007 Bible (Jan 2007).

oracledba.flyingamigos.com

Oracle Database Administration

Oracle on/and UNIX Reference…. How to Apply Oracle Patch 9974223 (Multicast) for 11.2.0.2 Oracle Clustered Grid Infrasture home? November 22, 2011. Tags: 11.2.0.2 grid infrastructure. 11202 real application cluster Installation. How to apply patch 9974223. Root script failed on second node. How to Apply Oracle Patch 9974223 (Multicast) for 11.2.0.2 Oracle Clustered Grid Infrasture home? Why you need to apply this patch? Some relevant information for my demonstration:. Create a directory /. 7 Now security...

oracledba.help

Home | oracledba.help

Basic for Java (B4J). Thanks for making oracledba.help. One of the highest rated Oracle sites on the internet! Stay tuned for changes to this site that will allow it to be fully. Best Practice of the Week. Important Caveat No amount of hardware can overcome an application if it is written badly enough.

oracledba.in

OracleDba.In - Article for Oracle Community

Share this Page on. Recent Articles - Written by Oracle Experts. DBMS REDEFINITION 12c Enhancement. By Ritesh Raj Singh. Column Drop without downtime using DBMS Redefinition. By Ritesh Raj Singh. Materialized view Refresh - Atomic Refresh False without Unavailability of Data - Part 2. By Ritesh Raj Singh. Materialized view Refresh - Atomic Refresh False without Unavailability of Data - Part 1. By Ritesh Raj Singh. Finding I/O Usage Per Device / Datafile At Oracle. By Ritesh Raj Singh. By Ritesh Raj Singh.

oracledba.javabook.org

Mohan's Oracle 11g DBA Concepts

Mohan's Oracle 11g DBA Concepts. Oracle 11g DBA Concepts. Please send your Questions and Answers or Feedback to dvmadhavreddy@javabook.org. Please send your Questions and Answers or Feedback to "dvmadhavreddy@javabook.org". Saturday, October 12, 2013. Sys show parameter spfile;. Sys create pfile from spfile;. Oralce@venu1 dbs mv spfilevenu1.ora spfilevenu1.ora.bkp. Oracle@venu1 dbs vi initvenu1.ora. Oracle@venu1 export ORACLE SID=venu1. Oracle@venu1 sqlplus / as sysdba. Oracle@venu1 ps -ef grep smon.

oracledba.net

Oracle DBA

Docker for Oracle DBA. Oracle DBA Profiles (for HR). On this website I'm planning to collect information about Oracle Administration on English. (Oracle DB, Weblogic, GoldenGate, Oracle Linux etc). OracleDBA.NET - open source project with codes on github. It works on jekyll technologies. People who understand russian language, can read same on oracle-dba.ru. Now I'm working on position Oracle ADF / Oracle JET Developer and we develop application like this. Sorry for my terrible english.

oracledba.oracleonline.info

Oracle DBA

oracledba.org

Install 11g RAC on Linux Install 11gR2 RAC Install 11g R2 RAC install10g RAC ASM DataGuard CRSCTL command Configure Dataguard Install EBS R12 on RACOracle Installation RAC to RAC dataguard Oracle Utilities CC&B V2.5.0.1 FW V4.3.0.1

Bhavin has been working on Oracle technologies for more than 14 years and has worked with Oracle USA, Inc. For 25 years as Sr. Principal Consultant (Performance Tuning and Architecture). During his professional career, he has worked successfully on Architecting/Implementation/managing and Performance Tuning of Multi TB Oracle 11g/10g/9i databases hosting various applications such as Oracle E-Business Suite and other ERPs. Step: Install Multi Node Oracle E-Business Suite R12 (12.1.1) on 11g RAC. Step: Add...

oracledba.ru

OracleDBA.ru

About OracleDBA.ru / про OracleDBA.ru. Notes, tricks, programs about/for Oracle and in particular, for its administration. Access to My Oracle Support site is not required but sometimes is desirable because of appearance of links to http:/ supporthtml.oracle.com. Below the same in Russian ]. Заметки, трики, программы, касающиеся Oracle и, в частности, его администрирования. Сайта можно смотреть в его блоге.