ORADBAINDIA.WORDPRESS.COM
ORACLE WRITES | Technical Articles by Kanchana SelvakumarTechnical Articles by Kanchana Selvakumar
http://oradbaindia.wordpress.com/
Technical Articles by Kanchana Selvakumar
http://oradbaindia.wordpress.com/
TODAY'S RATING
>1,000,000
Date Range
HIGHEST TRAFFIC ON
Tuesday
LOAD TIME
0.4 seconds
16x16
32x32
PAGES IN
THIS WEBSITE
14
SSL
EXTERNAL LINKS
7
SITE IP
192.0.78.13
LOAD TIME
0.422 sec
SCORE
6.2
ORACLE WRITES | Technical Articles by Kanchana Selvakumar | oradbaindia.wordpress.com Reviews
https://oradbaindia.wordpress.com
Technical Articles by Kanchana Selvakumar
oradbaindia.wordpress.com
Client Result Cache -11gr2 | ORACLE WRITES
https://oradbaindia.wordpress.com/2012/04/27/result-cache-11gr2
Technical Articles by Kanchana Selvakumar. Cache Fusion .contd. Client Result Cache -11gr2. Rac On One node. RMAN and block corruption. Client Result Cache -11gr2. On April 27, 2012 by Kanchana Selvakumar Tagged: call interface. The purview of this article is to describe the feature ‘ Client Result Cache’ specific to 11gr2. The idea of client result cache can be related to the example below.When asked to say. The client process’s one result cache is shared among multiple sessions like this. Executes the ...
Index Space Usage | ORACLE WRITES
https://oradbaindia.wordpress.com/2011/03/22/index-space-usage
Technical Articles by Kanchana Selvakumar. Cache Fusion .contd. Client Result Cache -11gr2. Rac On One node. RMAN and block corruption. On March 22, 2011 by Kanchana Selvakumar. Index space usage-shrink and rebuild. 1 To understand a B Tree Index. 2 Analyze, Shrink /Coalesce operation of an index. 3 The need for a rebuild. 1 B tree Index. B tree index fetches the data based on the indexed column. It has the values divided in to ranges and ordered. Ranging from 1-100 (in table Kancys). The branch block si...
Proxy Authentication | ORACLE WRITES
https://oradbaindia.wordpress.com/2011/07/19/proxy-authentication
Technical Articles by Kanchana Selvakumar. Cache Fusion .contd. Client Result Cache -11gr2. Rac On One node. RMAN and block corruption. On July 19, 2011 by Kanchana Selvakumar. Proxy Authentication is a method of authentication where a proxy database user is. Created and used to authenticate against the database on behalf of the real database. In middle tier applications the database users identity and privileges are preserved from. Whatever the real user can! Let s try this. Select user from dual ; and.
Sysresv utility. | ORACLE WRITES
https://oradbaindia.wordpress.com/2011/05/19/sysresv-utility
Technical Articles by Kanchana Selvakumar. Cache Fusion .contd. Client Result Cache -11gr2. Rac On One node. RMAN and block corruption. On May 19, 2011 by Kanchana Selvakumar. Sometimes, when an Oracle instance has crashed or was aborted, shared memory and semaphores related to that Oracle instance do not get cleaned up automatically by operating System. When shared memory and semaphores are not cleaned up, the instance will not start. A) What is SYSRESV utility? B) Usage of the utility. 3: -d [on/off] l...
Kanchana Selvakumar | ORACLE WRITES
https://oradbaindia.wordpress.com/author/oradbaindia
Technical Articles by Kanchana Selvakumar. Cache Fusion .contd. Client Result Cache -11gr2. Rac On One node. RMAN and block corruption. On January 4, 2014 by Kanchana Selvakumar. The WordPress.com stats helper monkeys prepared a 2013 annual report for this blog. Here’s an excerpt:. A San Francisco cable car holds 60 people. This blog was viewed about 1,500. Times in 2013. If it were a cable car, it would take about 25 trips to carry that many people. Click here to see the complete report. In RAC environm...
TOTAL PAGES IN THIS WEBSITE
14
oracle 12c multitenant architecture | nimaidba
https://nimaidba.wordpress.com/2016/04/06/oracle-12c-multitenant-architecture
Welcome to the world of Oracle with me…. Laquo; export/import syntax which may help. Oracle 12c multitenant architecture. April 6, 2016 by nimaidba. Last day I just installed and was thinking to let start with some basics on oracle 12c like what is it? Why we need it? What are the new features available? So after some research on that (although it was not so hard. :) I came to know with some below points. Manage Many Databases As One. Fewer Patches and Upgrades. I only have noted which seems important fo...
2014 in review | nimaidba
https://nimaidba.wordpress.com/2014/12/30/2014-in-review
Welcome to the world of Oracle with me…. Laquo; Oracle 12c Enterprise Manager Installation. Lost Writes with Oracle and Data Guard. December 30, 2014 by nimaidba. The WordPress.com stats helper monkeys prepared a 2014 annual report for this blog. Here’s an excerpt:. The concert hall at the Sydney Opera House holds 2,700 people. This blog was viewed about 10,000. Times in 2014. If it were a concert at Sydney Opera House, it would take about 4 sold-out performances for that many people to see it. Follow Bl...
High Availability | nimaidba
https://nimaidba.wordpress.com/2015/12/22/high-availability
Welcome to the world of Oracle with me…. Laquo; Lost Writes with Oracle and Data Guard. Export/import syntax which may help. December 22, 2015 by nimaidba. Today Hemant Sir have posted a good link that represent some basic for oracle HIGH AVAILABILITY with demonstration. Please click the link…. Oracle High availability demos…. Hope this helps…. Posted in Backup and Recovery. Leave a Reply Cancel reply. Enter your comment here. Fill in your details below or click an icon to log in:. Hits in the world.
Lost Writes with Oracle and Data Guard | nimaidba
https://nimaidba.wordpress.com/2015/12/22/lost-writes-with-oracle-and-data-guard
Welcome to the world of Oracle with me…. Laquo; 2014 in review. Lost Writes with Oracle and Data Guard. December 22, 2015 by nimaidba. This post is about lost writes in Oracle, on techniques for reproducing and investigating the effects of lost writes and on the use of Active Data Guard to protect against lost writes. You are the DBA in charge of fixing this, what would you do? We need to cover some ground first on techniques and how to setup the test. But first a definition. 1 A useful technique that we...
nimaidba | nimaidba
https://nimaidba.wordpress.com/author/nimaidba
Welcome to the world of Oracle with me…. Https:/ nimaidba.wordpress.com. Posts by Nimai Karmakar:. April 6, 2016. Oracle 12c multitenant architecture. January 22, 2016. Export/import syntax which may help. December 22, 2015. December 22, 2015. Lost Writes with Oracle and Data Guard. December 30, 2014. October 14, 2014. Oracle 12c Enterprise Manager Installation. October 13, 2014. Oracle import database [ORA-01435: user does not exist]. Older Posts ». Nimai Karmakar — Oracle 9i,10g,11g DBA. Ivica Arsov�...
export/import syntax which may help | nimaidba
https://nimaidba.wordpress.com/2016/01/22/exportimport-syntax
Welcome to the world of Oracle with me…. Laquo; High Availability. Oracle 12c multitenant architecture. Export/import syntax which may help. January 22, 2016 by nimaidba. Last one year i have work a lot on export and import for small to huge database, from specific objects to schema to and query based backup. Here I am listed some of my syntax which you can note down for your reference. Export objects from specific schema which match the specific criteria. Remap schema= from schema name : to schema name ;.
TOTAL LINKS TO THIS WEBSITE
7
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.
ORACLE DBA
Wednesday, 27 May 2015. Changing NLS CHARACTERSET From WE8MSWIN1252 to UTF8. Before beginning, make sure:-. There is a full backup of the database taken available. There is a backup of the current spfile (especially for RAC databases). STEP 1) INSTALL CSSCAN SCHMEA IF not Install. STEP 2) Record the SCN number,parameters at this point, Incase of restore. Check full database and archivelog back has been completed. Sqlplus '/ as sysdba'. Note the parameters- - - - - - - - - - - - - - - - - - - - - -. Once ...
Neil's Oracle DBA blog
Neil's Oracle DBA blog. Monday, July 26, 2010. Just to show that I do keep this blog up to date I thought I'd announce that the voting for the next Oracle Scene editor will shortly be opening for all UKOUG members. I am standing for this position being the technical editor for the last 3 yrs. Posted by Neil jarvis @ 11:46 AM. Thursday, March 01, 2007. ORA-00821 Specified value of sga target is too small, needs to be at least. Resized your SGA TARGET too small and found you can’t now start your database.
Mayil oracle blog
Importing and Exporting Oracle Database Using Datapump Utility. Posted by Mayilselvan Subramanian on June 11, 2009. Oracle Data pump utility enables very fast bulk data and metadata movement between Oracle databases. It provides parallel Export and Import utilities ( expdp and impdp. And Web-based Oracle Enterprise Manager Interface. Data Pump jobs can be restarted without loss of data, whether or not the stoppage was voluntary or involuntary. 8211; Client interface to the Data Pump Export utility. T...
ORACLE WRITES | Technical Articles by Kanchana Selvakumar
Technical Articles by Kanchana Selvakumar. Cache Fusion .contd. Client Result Cache -11gr2. Rac On One node. RMAN and block corruption. On January 4, 2014 by Kanchana Selvakumar. The WordPress.com stats helper monkeys prepared a 2013 annual report for this blog. Here’s an excerpt:. A San Francisco cable car holds 60 people. This blog was viewed about 1,500. Times in 2013. If it were a cable car, it would take about 25 trips to carry that many people. Click here to see the complete report. In RAC environm...
oradbakar
Thursday, June 30, 2016. How to check SGA resize operations? Initial size/1024/1024 "Initial",. TARGET SIZE/1024/1024 "Target",. FINAL SIZE/1024/1024 "Final",. To char(start time,'dd-mon hh24:mi:ss') start time,. To char(end time,'dd-mon hh24:mi:ss') end time. V$sga resize ops;. Current size/1024/1024 "CURRENT SIZE",. Min size/1024/1024 "MIN SIZE",. User specified size/1024/1024 "USER SPECIFIED SIZE",. Last oper type "TYPE",. To char(LAST OPER TIME,'dd-mon hh24:mi:ss') "LAST OPER TIME". Links to this post.
O R A C L E Database & Applications
O R A C L E Database and Applications. Contribution to Oracle apps and database. Keep visiting for more updates. Wednesday, February 3, 2016. Adfgclone.pl in 12.2 failed while ohsT2PApply process. Adcfgclone.pl failed while performing clone of EBS 12.2 instance. This occurred while ohsT2PApply is in progress. Below are the errors found in logfiles. Tmp/CLONINGCLIENT-1008723463327980977/clone asinstance start process-1337948214.log. 2015-12-02T3:10:04-06:00] [opmn] [ERROR:1] [] [internal]. SEVERE : Dec 2,...
Oracle Adminstration
Jul 16, 2015. How to use opatch auto. OPatch auto automaticaly patch the typical Grid Infrastructure (GI) and RAC home directories with minimal intervention. OPatch auto performs many of the pre-patch checks as well as the post-patch verification. OPatch auto lies in its ability to perform end-to-end configuration patching (patching a GI or RAC home based on its configuration.) By incorporating the configuration information into the patch process. Root@v-box1 ]# $ORACLE HOME/ OPatch. Patch GI home - - - ...
oradbaro | Focusing On Oracle Database Administration
Focusing On Oracle Database Administration. Citate care ma inspira. Etapele de pornire și oprire unei baze de date Oracle. In articolele precedente am menționat de mai multe ori modul în care este deschisă o bază de date Oracle dar nu am explicat ce presupune fiecare dintre aceste etape. Pentru cititorii care au zâmbit la imaginea de mai jos următoarele rânduri s-ar putea sa nu vina cu ceva nou, pentru cei care urmează sa se inițieze în tainele bazelor Oracle va recomanda sa citiți mai departe. 8211;R...
OraDBAs
Converted by Falcon Hive. DB2 Basics Lesson 2 "The DB2 Environment" (Video). This Lesson divided into two parts:. Note: If you experience any difficulties in understanding the accent you can find the transcript below. Lesson 2 Transcript: Part 1 of 2 - The DB2 Environment. Welcome to Lesson 2 of the DB2 on Campus lecture series. Today we're going to talk about the. DB2 environment, and this is part 1 of 2 parts. My name is Raul Chong and I'm the DB2 on. Slide 3: DB2 the big picture. Now is this grey box,...
