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