oracledba-vinod.blogspot.com

Oracle Database Administration

Thursday, August 1, 2013. What is a Latch. Oracle SGA consists of numerous data structures such as Buffer Cache, Shared pool, Library cache, Dictionary cache, redo log buffer etc. Many oracle processes need to access these SGA data structures concurrently. Though these SGA components are shared, only one process must be able to modify it at any particular point in time. Oracle achieves this by protecting the SGA data structures with latches. When do Oracle Process obtain a latch? A process acquires a lat...

http://oracledba-vinod.blogspot.com/

OVERVIEW OF oracledba-vinod.blogspot.com

TRAFFIC RANK

>1,000,000

REVIEWS

0

PAGES IN THIS WEBSITE

18

LINKS TO THIS WEBSITE

CONTACTS

ADDRESSES

SOCIAL LINKS

ONLINE SINCE

WEBSITE DETAILS

SEO

PAGES

SIMILAR SITES

TRAFFIC RANK FOR ORACLEDBA-VINOD.BLOGSPOT.COM

TODAY'S RATING

>1,000,000

TRAFFIC RANK - AVERAGE PER MONTH

BEST MONTH

December

AVERAGE PER DAY Of THE WEEK

HIGHEST TRAFFIC ON

Saturday

TRAFFIC BY CITY

Sign up

CUSTOMER REVIEWS

Average Rating: 4.2 out of 5 with 12 reviews

5 star

9

4 star

0

3 star

1

2 star

0

1 star

2

Hey there! Start your review of oracledba-vinod.blogspot.com

AVERAGE USER RATING

Write a Review

WEBSITE PREVIEW

LOAD TIME

0.5 seconds

FAVICON PREVIEW

16x16
32x32

CONTACTS AT ORACLEDBA-VINOD.BLOGSPOT.COM

ADD CONTACT

Login

TO VIEW CONTACTS

Remove Contacts

FOR PRIVACY ISSUES

CONTENT

PAGES IN
THIS WEBSITE

18

SSL

EXTERNAL LINKS

20

SITE IP

172.217.11.33

LOAD TIME

0.484 sec

SCORE

6.2

PAGE TITLE

Oracle Database Administration | oracledba-vinod.blogspot.com Reviews

<META> DESCRIPTION

Thursday, August 1, 2013. What is a Latch. Oracle SGA consists of numerous data structures such as Buffer Cache, Shared pool, Library cache, Dictionary cache, redo log buffer etc. Many oracle processes need to access these SGA data structures concurrently. Though these SGA components are shared, only one process must be able to modify it at any particular point in time. Oracle achieves this by protecting the SGA data structures with latches. When do Oracle Process obtain a latch? A process acquires a lat...

<META> KEYWORDS

1 posts

2 oracle database administration

3 unix

4 interview questions

5 latch

6 latches vs locks

7 request queuing

8 management

9 thanks

10 5 comments

CONTENT

Page content here

KEYWORDS ON PAGE

posts,oracle database administration,unix,interview questions,latch,latches vs locks,request queuing,management,thanks,5 comments,labels latch,note,labels 10g features,performance tuning,shrink,rman archivelogs lost,problem,solution,6 comments,rman,visits

SERVER

GSE

CONTENT-TYPE

utf-8

GOOGLE PREVIEW

Oracle Database Administration | oracledba-vinod.blogspot.com Reviews

https://oracledba-vinod.blogspot.com

Thursday, August 1, 2013. What is a Latch. Oracle SGA consists of numerous data structures such as Buffer Cache, Shared pool, Library cache, Dictionary cache, redo log buffer etc. Many oracle processes need to access these SGA data structures concurrently. Though these SGA components are shared, only one process must be able to modify it at any particular point in time. Oracle achieves this by protecting the SGA data structures with latches. When do Oracle Process obtain a latch? A process acquires a lat...

INTERNAL PAGES

oracledba-vinod.blogspot.com

1

Oracle Database Administration: June 2009

http://oracledba-vinod.blogspot.com/2009_06_01_archive.html

Thursday, June 18, 2009. Top 10 Memory Abusers. The following query will show the top 10 SQL statements using memory as a percentage of the entire system. From ( select rank() over ( order by buffer gets desc ) as rank bufgets,. To char(100 * ratio to report(buffer gets) over (), '999.99') pct bufgets. If the percentage is. 5 - 20% then average performance. 25% then bad performance. Posted by Vinod Dhandapani. Thursday, June 18, 2009. Top 10 Disk-Read Abusers. If the percentage is. Thursday, June 18, 2009.

2

Oracle Database Administration: March 2010

http://oracledba-vinod.blogspot.com/2010_03_01_archive.html

Monday, March 1, 2010. RMAN Incremental Backups backup only the blocks that were changed since the lastest base incremental backups. But RMAN had to scan the whole database to find the changed blocks. Hence the incremental backups read the whole database and writes only the changed blocks. Thus the incremental backups saves space but the reduction in the time is fairly neglegible. BCT File is one per database and in the case RAC, it is shared among all the instances. BCT File is created in the locati...

3

Oracle Database Administration: January 2010

http://oracledba-vinod.blogspot.com/2010_01_01_archive.html

Wednesday, January 20, 2010. Set the following environment variables. Access to privileged OS account or user with Sysdba privilege. Only users with Sysdba privilege can connect to RMAN. Hence no need to specify as sysdba while connecting to RMAN. Recovery Manager: Release 10.2.0.1.0 - Production on Wed Jan 20 03:19:22 2010. Connected to target database: IRIS (DBID=1460454352). If you are using password file, then specify the username and password. The RMAN prompt appears. To connect to the target datbase.

4

Oracle Database Administration: July 2009

http://oracledba-vinod.blogspot.com/2009_07_01_archive.html

Thursday, July 30, 2009. TKPROF (Transient Kernel Profiler) is an utility to translate the trace files in to a readable format. Where variable list include. The name of the trace file in the udump. The name of the output file in the udump. Run Explain plan on user’s SQL in trace file. Sys= Yes or No. Display Recursive SQL statements in output file. Waits= Yes or No. Record summary of for any waits. Aggregate = Yes or No. If no, then SQL text is shown once if executed more than once. And ssid = 149 And s&...

5

Oracle Database Administration: October 2009

http://oracledba-vinod.blogspot.com/2009_10_01_archive.html

Sunday, October 11, 2009. You can force the log switches using the following statements,. SQL Alter System Switch LogFile;. SQL Alter System Archive Log Current;. A number of DBAs also confuse with the following statement,. SQL Alter System Archive Log all;. The above statement will not issue a log switch. It will archive all the non-archived log files. If you have no logfiles that are unarchived, then issuing the above statement returns the error message,. ORA-00271 there are no logs that need archiving.

UPGRADE TO PREMIUM TO VIEW 13 MORE

TOTAL PAGES IN THIS WEBSITE

18

LINKS TO THIS WEBSITE

dbainterviewquestions.blogspot.com

DBA Interview Questions

http://dbainterviewquestions.blogspot.com/2011/11/download-smit-guide-here.html

Sunday, November 27, 2011. Download SMIT Guide here. Posted by Vinod Dhandapani. Subscribe to: Post Comments (Atom). Download SMIT Guide here. Download SMIT Guide here. Converted into Blogger Template by Bloganol dot com.

racadmin.blogspot.com

RAC Database Administration: Find and Replace in Vi editor

http://racadmin.blogspot.com/2013/09/find-and-replace-in-vi-editor.html

Monday, September 2, 2013. Find and Replace in Vi editor. Syntax for Text Substitution inside the vi editor is,. Following are the possible Flags. Replace all occurances in the line. Replace a text with another in the whole file. Where %s indicates all lines in the file. Replace a text within a single line. No range was specified therefore it replaces text in the single line. Where I indicates case insensitive. Replace a text within a range of lines. Replaces text between line 1 and 10.

dbainterviewquestions.blogspot.com

DBA Interview Questions: November 2011

http://dbainterviewquestions.blogspot.com/2011_11_01_archive.html

Sunday, November 27, 2011. Download SMIT Guide here. Posted by Vinod Dhandapani. Subscribe to: Posts (Atom). Download SMIT Guide here. Download SMIT Guide here. Converted into Blogger Template by Bloganol dot com.

racadmin.blogspot.com

RAC Database Administration: April 2011

http://racadmin.blogspot.com/2011_04_01_archive.html

Wednesday, April 27, 2011. Performance Impact of Using Cache and Nocache in Sequences. When Caching is used the data dictionary is updated once till the final cached value is used. If you cache 1000 values then the data dictionary is updated once for every 1000 sequence numbers are used. According to Metalink,. As a consequence of those serialisation mechanisms, the sequence throughput, i.e. the maximum speed at which it is possible to increment a sequence, doesn't scale with the number of RAC no...In su...

racadmin.blogspot.com

RAC Database Administration: September 2009

http://racadmin.blogspot.com/2009_09_01_archive.html

Sunday, September 13, 2009. To compress and uncompress the files in unix you can use the following commands. 1 Compress and uncompress. 2 gzip and gunzip. 3 bzip2 and bunzip2. The output file has the extension as .Z. Compress -v test.txt. Testtxt: Compression: 59.74% This file is replaced with test.txt.Z. To compress file to another directory. Compress -c proddmp.dmp /data back/proddmp.dmp.Z. Uncompress test.txt.Z. To uncompress to another directory. The output file has the extension as .gz.

dbainterviewquestions.blogspot.com

DBA Interview Questions: pp

http://dbainterviewquestions.blogspot.com/2011/09/pp.html

Thursday, September 8, 2011. Your browser does not support iframes. Posted by Vinod Dhandapani. Subscribe to: Post Comments (Atom). Converted into Blogger Template by Bloganol dot com.

dbainterviewquestions.blogspot.com

DBA Interview Questions: May 2011

http://dbainterviewquestions.blogspot.com/2011_05_01_archive.html

Thursday, May 19, 2011. Posted by Vinod Dhandapani. Subscribe to: Posts (Atom). Converted into Blogger Template by Bloganol dot com.

racadmin.blogspot.com

RAC Database Administration: September 2013

http://racadmin.blogspot.com/2013_09_01_archive.html

Monday, September 2, 2013. Find and Replace in Vi editor. Syntax for Text Substitution inside the vi editor is,. Following are the possible Flags. Replace all occurances in the line. Replace a text with another in the whole file. Where %s indicates all lines in the file. Replace a text within a single line. No range was specified therefore it replaces text in the single line. Where I indicates case insensitive. Replace a text within a range of lines. Replaces text between line 1 and 10.

racadmin.blogspot.com

RAC Database Administration: March 2011

http://racadmin.blogspot.com/2011_03_01_archive.html

Thursday, March 31, 2011. Shell Script to FTP. The following is a shell script to transfer file from one server to another server. Bin/ksh HOST='172.16.4.41' - Remote server ip. USER='oracle' - Remote server User. PASSWD='* * * ' - Password ftp -n $HOST EOF. Posted by Vinod Dhandapani. Subscribe to: Posts (Atom). Vinod's Blog on Oracle. Shell Script to FTP. Converted into Blogger Template by Bloganol dot com.

UPGRADE TO PREMIUM TO VIEW 11 MORE

TOTAL LINKS TO THIS WEBSITE

20

OTHER SITES

oracledba-tutorial.blogspot.com

ORACLE DBA TUTORIAL LEARN DBA COURSE- dba course,about oracle dba, oracle dba tutorial, oracle dba topics, oracle dba tutorial pdf for beginners

Skip to left sidebar. Skip to right sidebar. Oracle DBA tutorial and video tutorials for beginners. Oracle Dba Video Tutorials. Backup and Restore a database with RMAN cold. Again let's talk about backups. There are two types of backup:. Saying backups cold. In this case the base is inaccessible to users and it performs a simple file copy appropriate to restore in case of trouble. Again, a bit of thought before acting will save time later and avoid crisis situations. In panic mode, we do not think at all...

oracledba-unix.blogspot.com

oracledba-unix

Subscribe to: Posts (Atom). View my complete profile. Simple theme. Powered by Blogger.

oracledba-valentin.blogspot.com

oracle apps dba

Четверг, 2 декабря 2010 г. Way to connect to APPS or how to bypass default Login screen. Вторник, 9 ноября 2010 г. FAILED: file FNDNLINS.sql on worker 1 for product fnd username APPLSYS. If you use ADADMIN utility and get ERROR. FAILED: file FNDNLINS.sql on worker 1 for product fnd username APPLSYS. PACKAGE=FND LOOKUP VALUES PKG. SQLERRM=ORA-00001: unique constraint(APPLSYS.FND LOOKUP VALUES U2) violated. Redwood Shores, California, USA. Version 11.5.0. Review the README for pre-requisite information.

oracledba-videos.blogspot.com

Oracle DBA Videos

This blog presents Oracle DBA Videos.An Audio visual Demo of some of the operations a DBA encounters in his day to day life. All the videos in this blog are High Definition Videos most with Audio. The videos are best watched in full screen with "HD option enabled". You would also find screenshots and some handy scripts for DBAs. Wednesday, November 22, 2017. This video gives an introduction to Oracle Database patches. Posted by Ritesh Das. Links to this post. Labels: oracle database patches. The current ...

oracledba-vinod.blogspot.com

Oracle Database Administration

Thursday, August 1, 2013. What is a Latch. Oracle SGA consists of numerous data structures such as Buffer Cache, Shared pool, Library cache, Dictionary cache, redo log buffer etc. Many oracle processes need to access these SGA data structures concurrently. Though these SGA components are shared, only one process must be able to modify it at any particular point in time. Oracle achieves this by protecting the SGA data structures with latches. When do Oracle Process obtain a latch? A process acquires a lat...

oracledba.bigresource.com

SQL & PL/SQL :: Reorder The Rows Based On 3 Parameters

SQL and PL/SQL : Reorder The Rows Based On 3 Parameters. Aug 29, 2012. I have a requirement (procedure) to reorder the rows based on 3 parameters. My table looks like:. 1st parameter will be EMPID, 2nd parameter is orderID's (any combination comma separated) and 3rd is Position after. Ie proc call will be like REORDER(101, '1,3', 4);. So that, 1,3 should come after 4th position and everything should get reorder. CREATE TABLE TEST TABLE(EMPID NUMBER, ORDERID NUMBER, ENAME VARCHAR2(20) ;. SQL and PL/SQL : ...

oracledba.blogspot.com

Oracle DBA Place

Skip to main content. Subscribe to this blog. Extract Data Guard Commands on Oracle 12.2. February 08, 2018. Hi, These days I am starting to work on Oracle 12.2, leaving behind the old versions. Since my main domain is Oracle Data Guard, I posted a blog about Oracle 12c Release 2 New Features for Active Data Guard. One of a big new feature I missed is that the internal Data Guard broker configuration was changed dramatically on 12.2. Last week, I tried to Extract Data Guard Commands. January 29, 2018.

oracledba.co.uk

www.oracledba.co.uk

This web page uses frames, but your browser doesn't support them.

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