5. What is the cache hit ratio, what impact does it have on performance of an Oracle database andwhat is involved in tuning it? 6. Other than making use of the statspack utility, what would you check when you ar
ORACLE DBA 面试题集 一:SQL tuning 类 1 列举几种表连接方式 等连接、非等连接、自连接、外连接(左、右、全) 2 不借助第三方工具,怎样查看 sql 的执行计划 I) 使用 Explain Plan,查询 PLAN_TABLE; EXPLAIN PLAN SET STATEMENT_ID='QUERY1' FOR SELECT * FROM a WHERE aa=1; SELECT operation, options...
The tkprof tool is a tuning tool used to determine cpu and execution times for SQL statements. You use it by first setting timed_statistics to true in the initialization file and then turning on tracing for either the entire database via the sql_trace parameter or for the session using the...
Interview Questions 数据文件 数据 数据库 其他 转载 mb5ff4099f0a555 2013-07-15 16:43:00 193阅读 2 Oracle面试题 以下题目,可根据自己情况挑选题目作答,不必全部作答.您也可以就相关问题直接找负责面试人员面述而不笔答……一:SQL tuning 类 1:列举几种表连接方式 2:不借助第三方工具,怎样查看sql的执行...
以下题目,可根据自己情况挑选题目作答,不必全部作答.您也可以就相关问题直接找负责面试人员面述而不笔答……一:SQL tuning 类 1:列举几种表连接方式 2:不借助第三方工具,怎样查看sql的执行计划 I) 使用Explain Plan,查询PLAN_TABLE; &n oracle 职场 ...
OracleDBAInterviewQuestionsByBG 1.Howmanymemorylayersareinthesharedpool? 2.HowdoyoufindoutfromtheRMANcatalogifaparticulararchiveloghasbeen backed-up? 3.Howcanyoutellhowmuchspaceisleftonagivenfilesystemandhowmuchspace eachofthefilesystem'ssubdirectoriestake-up?
Introduction to SQL Tuning Describe what attributes of a SQL statement can make it perform poorly Describe the Oracle tools that can be used to tune SQL Explain the tuning tasks Introduction to the Optimizer Describe the execution steps of a SQL statement Explain the need for an optimiz...
100% Placement– ISQL Global mock interviews will effectively prepare you to face your real job interviews. Oracle Authorized Training in Chennai ISQL Global provide services like resume preparation, placement assistance, and Oracle interview questions to sharpen your skills. ...
Oracle HCM Techno Functional Interview Questions. Posted on October 9, 2019 by Administrator (Interview Questions for Oracle HR Payroll Job) Following are the sample interview questions which you can expect during interview for Continue reading Others Leave a comment ...
Protected: Oracle Interview Questions and Answers Unable to drop Tables and the Schema Oracle always uses Wrong Execution Plan for a given SQL Protected: OUD Installation and Configuration Oracle 12c – Name and Address Requirements for Manual Configuration of Cluster Oracle Database 12c: Fine...