oracledba-unix.blogspot.com

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.

oracledba-vinod.blogspot.com

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.

oracledba-vinod.blogspot.com

Oracle Database Administration: August 2013

http://oracledba-vinod.blogspot.com/2013_08_01_archive.html

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-vinod.blogspot.com

Oracle Database Administration: April 2009

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

Friday, April 10, 2009. To monitor the temporary Segment Usage. SELECT A.tablespace name tablespace, D.mb total,. SUM (A.used blocks * D.block size) / 1024 / 1024 mb used,. Dmb total - SUM (A.used blocks * D.block size) / 1024 / 1024 mb free. FROM v$sort segment A,. SELECT B.name, C.block size, SUM (C.bytes) / 1024 / 1024 mb total. FROM v$tablespace B, v$tempfile C. WHERE B.ts#= C.ts#. GROUP BY B.name, C.block size. WHERE A.tablespace name = D.name. GROUP by A.tablespace name, D.mb total;. Switching undo...

oracledba-vinod.blogspot.com

Oracle Database Administration: February 2010

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

Thursday, February 25, 2010. The following are the commands you can type from the RMAN prompt. Posted by Vinod Dhandapani. Thursday, February 25, 2010. RMAN List Command queries the target control file or the recovery catalog for the historical information on the backups. The various options you can use with List command and their uses are discussed below,. A new incarnation of the database is created when you perform the open resetlogs. Operation. To view the list of database incarnations,. RMAN List Ba...

oracledba-vinod.blogspot.com

Oracle Database Administration: May 2009

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

Thursday, May 28, 2009. OEM dbconsole Start Failed. The dbconsole was working fine before the timezone setting (DST) was changed, but after the timezone was changed it stopped working. To update follow the steps given below. Check the timezone setting in /etc/environment. The setting for TZ must be one of the supported timezone setting listed in the ORACLE HOME/sysman/admin/supportedtzs.lst file. Emctl config agent updateTZ. The output could be a different setting from the TZ in /etc/environment. Even if...

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.

oracledba-vinod.blogspot.com

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.

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.