Oracle ASM is widely used in the IT industry. Here I have compiled Top 46 Oracle ASM Interview Questions to enhance the knowledge about Oracle ASM instance Question 1 What is ASM in Oracle? Answer Oracle ASM is Oracle’s volume manager specially designed for Oracle database data. It is available since Oracle database version 10g and […]
Oracle Interview questions
This article contains Top 49 Oracle Interview questions and answers: Basics, Oracle SQL asked in various interviews. I hope it should help in interviews Question 1. What is a table Cluster?Answer: A table Cluster is a group of related tables that share common columns are store related data in the same block. Question 2. What is […]
Oracle Performance tuning Glossary
Here is Oracle Performance tuning Glossary. It is quite a complex and interesting topic. Oracle performance tuning needs thorough analysis and knowledge of all the aspects of Oracle database Autotrace Autotrace is a beautiful tool provided by Oracle for getting the explain plan and execution statistics. You need to know the query and its bind […]
How to Drop the index in Oracle
You can drop an index in oracle using the DROP INDEX command. It removes the named index. The general Syntax is drop index <schema name>.<index name> ; Here schema name is the owner of the index and index name is the index name. If you don’t provide the schema name, then it is assumed the […]
How to check RMAN backup details in the sql
We can check RMAN backup details in the sql using the below sql col STATUS format a9 col hrs format 999.99 select SESSION_KEY,SESSION_RECID,SESSION_STAMP, INPUT_TYPE, STATUS, to_char(START_TIME,’mm/dd/yy hh24:mi’) start_time, to_char(END_TIME,’mm/dd/yy hh24:mi’) end_time, elapsed_seconds/3600 hrs from V$RMAN_BACKUP_JOB_DETAILS order by session_key; This is very helpful when you are operating in a DBCS(Database Cloud Service) environment with automated backup. […]
Top Oracle Data guard queries
Here are some of the Top Oracle data guard queries How to check the archive log sequence on Primary Side SELECT THREAD# “Thread”,SEQUENCE# “Last Sequence Generated” FROM V$ARCHIVED_LOG WHERE (THREAD#,FIRST_TIME ) IN (SELECT THREAD#,MAX(FIRST_TIME) FROM V$ARCHIVED_LOG GROUP BY THREAD#) ORDER BY 1; How to check the archive log sequence apply status on Standby Side SELECT […]
