ANS: MAKING OPTIMAL USE OF SYSTEM USING EXISTING RESOURCES CALLED PERFORMACE TUNING.
2. TYPES OF TUNINGS?
ANS: 1. CPU TUNING
2. MEMORY TUNING
3. IO TUNING
4. APPLICATION TUNING
5. DATABSE TUNING
3. WHAT MAILNY DATABASE TUNING CONTAINS?
ANS: 1. HIT RATIOS
2. WAIT EVENTS
3. WHAT IS AN OPTIMIZER?
ANS: OPTIMIZER IS A MECHANIZM WHICH WILL MAKE THE EXECUTION PLAN OF AN SQL STATEMENT
4. TYPES OF OPTIMIZERS?
ANS: 1. RBO(RULE BASED OPTIMIZER)
2. CBO(COST BASED OPTIMZER)
5. WHICH INIT PARAMETER IS USED TO MAKE USE OF OPTIMIZER?
ANS: OPTIMIZER_MODE= RULE----RBO
COST---CBO
CHOOSE--------FIRST CBO OTHERWISER RBO
6. WHICH OPTIMIZER IS THE BEST ONE?
ANS: CBO
7. WHAT ARE THE PRE REQUSITED TO MAKE USER OF OPTIMIZER?
ANS: 1. SET THE OPTIMIZER MODE
2. COLLECT THE STATISTICS OF AN OBJECT
8. HOW DO YOU COLLECT STATISTICS OF A TABLE?
ANS: ANALYZE TABLE EMP COMPUTE STATISTICS OR ANALYZE TABLE EMP ESTIMATE STATISTICS
9. WHAT IS THE DIFF BETWEEN COMPUTE AND ESTIMATE?
ANS: IF YOU USE COMPUTE, THE FTS WILL HAPPEN, IF YOU USE ESTIMATE JUST 10% OF THE TABLE WILL BE READ
10. WHAT WLL HAPPEN IF YOU SET THE OPTIMIZER_MODE=CHOOSE?
ANS: IF THE STATISTICS OF AN OBJECT IS AVAILABLE THEN CBO USED. IF NOT RBO WILL BE USED
11. DATA DICTIONAY FOLLOWS WHICH OPTIMZER MODE?
ANS: RBO
12. HOW DO YOU DELETE STATISTICS OF AN OBJECT?
ANS: ANALYZE TABLE EMP DELETE STATISTICS
13. HOW DO YOU COLLECT STATISTICS OF A USER/SCHEMA?
ANS: EXEC DBMS_STATS.GATHER_SCHEMA_STATS(SCOTT)
14. HOW DO YOU SEE THE STATISTICS OF A TABLE?
ANS: SELECT NUM_ROWS,BLOCKS,EMPTY_BLOCKS FROM DBA_TABLES WHERE TAB_NAME='EMP'
15. WHAT ARE CHAINED ROWS?
ANS: THESE ARE ROWS, IT SPANS IN MULTIPLE BLOCKS
16. HOW DO YOU COLLECT STATISTICS OF A USER IN ORACLE APPS?
ANS: FND_STATS PACKAGE
17. HOW DO YOU CREATE A EXECUTION PLAN AND HOW DO YOU SEE?
ANS: 1. @?/RDBMS/ADMIN/UTLXPLAN.SQL --------- IT CREATES A PLAN_TABLE
2. EXPLAIN SET STATEMENT_ID='1' FOR SELECT * FROM EMP;
3. @?/RDBMS/ADMIN/UTLXPLS.SQL -------------IT DISPLAY THE PLAN
18. HOW DO YOU KNOW WHAT SQL IS CURRENTLY BEING USED BY THE SESSION?
ANS: BY GOIND V$SQL
19. WHAT IS A EXECUTION PLAN?
ANS: ITS A ROAD MAP HOW SQL IS BEING EXECUTED BY ORACLE DB
20. HOW DO YOU GET THE INDEX OF A TABLE AND ON WHICH COLUMN THE INDEX IS?
ANS: DBA_INDEXES AND DBA_IND_COLUMNS
21. WHICH INIT PARAMTER YOU HAVE TO SET TO BY PASS PARSING?
ANS: CURSOR_SHARING=FORCE
22. HOW DO YOU KNOW WHICH SESSION IS RUNNING LONG JOBS?
ANS: BY GOING V$SESSION_LONGOPS
23. HOW DO YOU FLUSH THE SHARED POOL?
ANS: ALTER SYSTEM FLUSH SHARED_POOL
24. HOW DO YOU GET THE INFO ABOUT FTS?
ANS: USING V$SYSSTAT
25. HOW DO YOU INCREASE THE DB CACHE?
ANS: ALTER TABLE EMP CACHE
26. WHERE DO YOU GET THE INFO OF LIBRARY CACHE?
ANS: V$LIBRARYCACHE
27. HOW DO YOU GET THE INFORMATION OF SPECIFIC SESSION?
ANS: V$MYSTAT
28. HOW DO YOU SEE THE TRACE FILES?
ANS: USING TKPROF --- USAGE: TKPROF ALLLLLE.TRC LLKLD.TXT
29. TYPES OF HITS?
ANS: BUFFER HIT AND LIBRARY HIT
30. TYPES OF WAIT EVENTS?
ANS: CPU TIME AND DIRECT PATH READ
1. WHAT IS THE UTILITY TO CHANGE THE PASSWORD OF A DBA SCHEMA IN ORACLE APPS?
ANS: FNDCPASS
2. WHAT ARE MANDATORY USERS IN ORACLE APPS?
ANS: APPLSYS,APPLSYSPUB,APPS
3. WHAT SIMPLAY A ORACLE ARCHITECHTURE?
ANS: DESKTOP TIER, APPLICATION TIER, DATABASE TIER
5. WHAT ARE THE COMPONENTS IN THE APPLICATION TIER?
ANS: APACHE(HTTP)
JSERVER(JRE)
FORMS SERVER(F60SRV)
METRIC SERVER(D2LS)
METRIC CLIENT(D2LC)
REPORT SERVER(RWM60)
CONCURRENT SERVER(FNDLIBR)
DISCOVERER
6.WHAT ARE MAIN FILE SYSTEMS IN ORACLE APPS?
ANS: APPL_TOP, COMMON_TOP
7. WHAT ARE THERE IN DESKTOP TIER?
ANS: INTERNET BROWSER, JINITIATOR
8. WHAT IS THE LOCATION OF JINITIATOR IN THE DESKTOP TIER?
ANS: C:\PROGRAM FILES\ORACLE\JINITIATOR
9. WHAT IS THE LOCATION OF CLIENT CACHE?
ANS: C:\DOCUMENTS AND SETTNGS\USER\ORACLE JAR CACHE
10. WHAT IS THE LOCATION OF SERVER CACHE?
ANS: $COMMON_TOP/_PAGES
11. WHICH PACKAGE WILL BE USED FOR THE USER VALIDATION BY PLSQL AGENT?
ANS: ORACLEMYPAGE
12. WHAT ARE ADADMIN UTILITIES? AND ITS LOCATION?
$AD_TOP/BIN
ANS: 1.ADADMIN
2.ADPATCH
3.ADSPLICE
4.ADIDENT
5.ADRELINK
6.
13.WHAT ARE THE LOCATION OF JAVA FILES?
ANS: JAVA_TOP AND ALL PRODUCT_TOP/JAVA/JAR
14. WHAT IS THE NAME OF THE XML FILE OF APPS AND ITS LOCATION
ANS: CONTEXT NAME.XML AND $APPL_TOP/ADMIN
15. WHAT IS THE LOCATION OF APPS ENVIRONMENT FILE? AND ITS NAME?
ANS: CONTEXTNAME.ENV AND $APPL_TOP
16. IN HOW MANY WAY JAR FILES ARE GENERATED?
ANS: NORMAL AND FORCE
17. ONCE JAR FILES ARE GENERATED WHAT FILES GET EFFECTED?
ANS: ALL PRODUCT_TOP/JAVA/JAR FILES AND TWO FILES IN JAVA_TOP THEY ARE APPSBORG.ZIP
APPSBORG2.ZIP
18. HOW DO YOU SEE THE FILES IN ZIP FILE?
ANS: UNZIP -V
19.HOW DO YOU GENERATE JAR FILES?
ANS: USING ADADMIN AND OPTION 5
20. HOW DO YOU START THE APPS SERVICES?
ANS: $COMMON_TOP\ADMIN\SCRIPTS\CONTEXTNAME\ADSTRTAL.SH
21. WHAT IS THE EXECUTABLE TO GENERATE JAR FILES?
ANS: ADJAVA
22. HOW DO YOU RELINK A EXECUTABLE OF A PRODUCT
ANS: BY RELINKING OPTION IN ADADMIN
23. HOW DO YOU RELINK AD PRODUCT EXECUTABLE? AND USAGE?
ANS: ADRELINK.SH AND ADRELINK.SH FORCE=Y "AD ADSPLICE"
24.WHEN DO YOU RELINKING?
ANS: 1. WHEN YOU MISS A EXECUTABLE FILE
2. WHEN THERE IS A PROBLEM WITH ANY EXECUTABLE FILE
25. WHAT IS DAD?
ANS: IT IS A FILE WHICH STORES APPS PASSWORDS IN HARD CODED FORMAT
26.HOW DO YOU RELINK OS FILES AND LIBRARIES?
ANS: USING MAKE COMMAND
27.WHAT IS COMPILE SCHEMAN OPTION IN ADADMIN?
ANS: THIS OPTION IS USED TO RESOLVE THE INVALID OBJECTS
28. WHERE DO YOU GET THE INFO ABOUT INVALID OBJECTS?
ANS: FROM DBA_OBJECTS WHERE STATUS=INVALID
29.HOW DO YOU COMPILE AN OBECT ?
ANS: ALTER TABLE EMP COMPILE
30.HOW DO YOU SEE THE ERRORS OF A TABLE OR VIEW?
ANS: SELECT TEXT FROM DBA_ERRORS WHERE NAME='EMP_VIEW'
31. HOW DO YOU SEE THE ERRORS IN THE DB?
ANS: SHOW ERROR
32. HOW DO YOU COMPILE A SCHEMA?
ANS: USING UTLRP.SQL (LOCATION IS ?/RDBMS/ADMIN/) OR
GOING ADADMIN, COMPILE SCHEMA OPTION
33. HOW DO YOU KNOW HOW MANY INVALID OBJECTS ARE IN SPECIFIC SCHEMA?
ANS: SELECT COUNT(*) FROM DBA_OBJECTS WHERE STATUS='INVALID' GROUP BY OWNER
34. HOW DO YOU KNOW THE PACKAGE VERSION?
ANS: SELECT TEXT FROM DBA_SOURCE WHERE NAME='PACKAGE NAME' AND TYPE='PACKAGE BODY' AND ROWNUM<10
35.WHERE DO YOU FIND PACKAGE LOCKS?
ANS: V$ACCESS
36. WHERE DO YOU FIND OBJECT LOCKS?
ANS: V$LOCKED_OBJECT
37. HOW DO YOU LOGIN DIRECTLY TO THE APPS IN THE BROWSER?
ANS: HTTP://192.168.0.203:8000/DEV60CGI/F60CGI
38.HOW DO YOU ENABLE DIRECT LOING IN ORACLE APPS 11.5.10
ANS: OPEN THE CONTEXTNAME.XML AND CHANGE TO
OR CONNECT TO APPS/APPS CHANGE THE SERVER ID IN THE FND_NODES TO OFF
39.HOW DO YOU SETUP THE JVM IN THE DATABASE?
ANS: INITJVM.SQL (?/RDBMS/ADMIN)
40. HOW DO REMOVE THE JVM FROM THE DATABASE?
ANS: RMJVM.SQL(>/RDBMS/ADMIN)
41. HOW DO YOU LOAD JAVA CLASS TO DATABAE?
ANS: LOADJAVA
42. WHAT ARE RESTART FILES? AND ITS LOCATION?
ANS: THESE FILES CONTAINS THE PREVIOUSE SESSION INFO ABOUT ADADMIN.. LOCATINO IS $APPL_TOP\ADMIN\SID\RESTART\*.RF9
43.HOW DO YOU VALIDATE APPS SCHEMA?
ANS: TO VALIDATE SYNONYMS, MISSING SYSNONYMS AND ALL GRANT. YOU CAN DO IT IN ADADMIN. AFTER VALIDATING IT IWLL PRODUCE
A REPORT IN THE LOCATION $APPL_TOP\ADMIN\SID\OUT\*.OUT
44. HOW DO YOU ENABLE MAINTAINANCE MODE?
ANS: USING ADADMIN OR
RUNNING A SCRIPT CALLED "ADSETMMD.SQL" (AD_TOP/PATCH/115/SQL)
45.WHAT IS APPS_MRC SCHEMA?
ANS: IT IS USED FOR MULTI LANGUAGE SUPPORT. TO SYNCHRONIZE APPS SCHEMA AND APPS_MRC
46. HOW TO SEE THE VERSION OF A SCRIPT OR FORM OR REPORT OR ETC?
ANS: GREP HEADER ADSETMMD.SQL OR ADIDENT HEADER ADSETMMD.SQL
STRINGS -A GLXSTEA.FMX |GREP HEADER OR ADIDENT HEADER GLXSTEA.FMX
47.WHAT IS THE LOCATION OF ADADMIN LOG?
ANS: $APPL_TOP\ADMIN\SID\LOG
48. WHAT ARE THE ORACLE HOMES IN APPS?
ANS: 8.0.6(DEV 6I PRODUCTS) AND IAS_ORACLE_HOME (APACHE)
49. HOW DO YOU CONFIGURE YOU IPADDRESS AT CLIENT SIDE? AND SERVER SIDE?
ANS: C:\WINDOWS\SYSTEM32\DRIVERS\ETC\HOSTS AND \ETC\HOST
50. WHAT IS THE LOCATION OF DATBASE SERVER RELATED SCRIPTS?
ANS: $ORACLE_HOME\APPSUTIL\SCRIPTS\CONTEXTNAME
51. WHAT IS THE UTILITY TO CLEAN THE CONCURRENT MANAGER?
ANS: @CMCLEAN.SQL
52. HOW DO YOU STAGE THE 11.5.10 APPS SOFTWARE?
ANS: USING ADAUTOSTG.PL
53. WHAT IS THE LOCATION OF THE SOURCE FILES OF FORMS?
ANS: AU_TOP/FORMS/US/
54. WHAT IS THE EXECUTABLE TO GENERATE FORMS>
ANS: F60GEN
1. HOW DO YOU KILL A SESSION FROM THE DATABASE?
ANS: ALTER SYSTEM KILL 'SID,SERIAL#'
USAGE : ALTER SYSTEM KILL '9,8'
GET THE INFO FROM V$SESSION
2. HOW DO YOU KNOW WHETHER THE PROCESS IS SERVER SIDE PROCESS?
ANS. BY SEEING THE PROCESS IN PS-EF AS ORACLE+SID
EG: SUPPOSE THE SID IS PROD, THEN THE SERVER PROCESS IS REFERED AS SERVER SIDE PROCESS AND LOCAL=NO
3. DAILY ACTIVITIES OF A ORACLE DBA?
ANS: 1. CHECK THE DATABSE AVAILABILITY
2. CHECK THE LISTERNER AVAILABILITY
3. CHECK THE ALERT LOG FILIE FOR ERRORS
4. MONITORING SPACE AVAILABLILTY IN TABLESPACES
5. MONITORING MOUNT POINT (SEE CAPACITY PLANNING DOCUMENT)
6. VALIDATE DATABASE BACKUP OR ARCHIVE BACKUP
7. FIND OBJECTS WHICH IS GOING TO REACH MAX EXTENTS
8. DATABASE HEALTH CHECK
9. CPU, PROCESSOR, MEMORY USAGE
4. WHERE DO YOU GET ALL HIDDEN PARAMETERS ?
ANS: IN THE TABLE X$KSPPI
5. HOW DO YOU SEE THE NAMES FROM THAT TABLE?
ANS:SELECT KSPPINM,KSPPDESC FROM X$KSPPI WHERE SUBSTR(KSPPINM,1,1)='_'
6. HOW DO INCREASE THE COUNT OF DATAFILES?
ANS: GENERATE THE CONTROL FILE SYNTAX FROM THE EXISTING CONTROL FILE AND RECREATE THE CONTROL FILE BY CHANGING THE PARAMETER MAXDATAFILES = YOURDESIRED SIZE
PROCEDURE:
1. OPEN THE DATABASE
2. GENERATE THE CONTROL FILE CHANGE THE MAXDATAFILES
3. OPEN THE DB IN NOMOUNT
4. EXECUTE THE SYNTAX WITH NORESETLOGS
5. ALTER DATABSE OPEN
7. WHAT IS THE INIT PARAMETER TO MAKE USE OF PROFILE?
ANS: RESOURCE_LIMITS=TRUE
8. HOW DO YOU KNOW WHETHER THE PARAMETER IS DYNAMIC OR STATIC
ANS: BY GOING V$PARAMETER AND CHECK THE FIELDS ISSES_MODIFIABLE AND ISSYS_MODIFIBLE
9. WHAT IS THE PACKAGE AND PROCEDURE NAME TO CONVER DMT TO LMT AND VICE VERSA?
ANS: EXEC DBMS_SPACE_ADMIN.TABLESPACE_MIGRATE_FROM_LOCAL("GTB")
EXEC DBMS_SPACE_ADMIN.TABLESPACE_MIGRATE_TO_LOCAL("GTB1")
10. WHAT IS THE USE OF NOHUP?
ANS: THE EXECUTION OF A SPECIFIC TASK IS PERFORMED IN THE SERVER SIDE WITH OUT ANY INTERUPTING
USAGE : NOHUP CP -R * /TMP/. &
11. WHERE ALERT LOG IS STORED? WHAT IS THE PARAMETER?
ANS: IN BDUMP. PARAMETER IS BACKGROUND_DUMP_DEST
11. WHERE TRACE FILE ARE STORED? WHAT IS THE PARAMETER?
ANS: IN UDUMP. PARAMETER IS USER_DUMP_DEST
12. COMMON ORACLE ERRORS ……
1) ORA-01555 : SNAPSHOT TOO OLD
2) ORA-01109 : DATABASE NOT MOUNTED
3) ORA-01507 : DATABASE NOT OPEN
4) ORA-01801 : DATABASE ALREADY IN STARTUP MODE.
5) ORA-600 : INTERNAL ERROR CODE FOR ORACLE PROGRAM
USAGE : OERR ORA 600
13. HOW DO YOU ENABLE TRACEING WHILE YOU ARE IN THE DATABASE?
ANS : ALTER SESSION SET SQL_TRACE=TRUE;
14. IF YOU WANT TO ENABLE TRACING IN REMOTE SYSTEM? WHAT WILL U DO?
ANS: EXEC DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION(9,3,TRUE);
15. WHICH ROLE YOU GRANT TO RMAN USER WHILE CONFIGURING RMAN USER
ANS: RECOVER_CATALOG_OWNER
16. WHERE DO YOU GET TO KNOW THE VERSION OF YOUR ORACLE SOFTWARE AND WHAT IS YOUR VERSION?
ANS: FROM V$VERSION(FIELD IS BANNER) AND THE VERSION IS 9.2.0.1.0
17. WHAT IS THE PARAMETERS TO SET IN THE INIT.ORA IF YOU CREATE DB USING OMF?
ANS: DB_CREATE_FILE_DEST=
DB_CREATE_ONLINE_LOG_DEST_1=
18. WHAT IS A RUNAWAY SESSION?
ANS: YOU KILLED A SESSION IN THE DATABASE BUT IT STILL REMAINS IN THE OS LEVEL AND VICE VERSA. ITS CALLED RUNAWAY SESSION. IF RUNAWAY SESSION IS THERE CPU CONSUMES MORE USAGE.
19. HOW DO YOU KNOW WHETHER THE SPECIFIC TABLESPACE IS IN BEGIN BACKUP MODE?
ANS: SELECT STATUS FROM V$BACKUP. IF IT IS ACTIVE IT MEANS IT IS IN BEGIN BACKUP MODE
20. IF YOU WANT TO MAINTAIN ONE MORE ARCHIVE DESTINATION WHICH PARAMETER YOU HAVE TO SET
ANS:ITS A DYNAMIC PARAMETER YOU HAVE TO SET LOG_ARCHIVE_DUPLEX_DEST=
USAGE : ALTER SYSTEM SET LOG_ARCHIVE_DUPLEX_DEST=
21. HOW DO YOU KNOW THE CREATE SYNTAX OF YOUR FUNCTION/PROCEDURE/INDEX/SYNONYM
ANS: USING FUNCTION DBMS_METADATA.GET_DDL(OBJECT TYPE,OBJECT NAME,OWNER)
22. WHAT IS THE PASSWORD YOU HAVE TO SET IN THE INIT.ORA TO ENABLE REMOTE LOGIN ?
ANS: REMOTE_LOGIN_PASSWORD_FILE=EXCLUSIVE
23.HOW DO U SET CRONTAB TO DELETE 5 DAYS OLD TRACE FILES AT DAILY 10'0 CLOCK?
ANS: CRONTAB -E
0 10 * * * /USR/BIN/FIND /U001/ADMIN/UDUMP -NAME "*.TRC" -MTIME +5 -EXEC RM -RF {} \;
SAVE AND EXIT (WQ!)
24.HOW DO U KNOW WHEN SYSTEM WAS LAST BOOTED?
ANS: 3 WAYS 1.UPTIME CMD
2.TOP
3.WHO -B
4.W
24.HOW DO U KNOW LOAD ON SYSTEM?
ANS: 1.W
2.TOP
25. HOW DO YOU WHEN THE PROCESS IS STARTED
ANS : USING PS -EF | GREP PROCESS NAME
26. TELL ME THE LOCATION OF UNIX LOG MESSAGES STORED?
ANS:/VAR/LOG/MESSAGES
/VAR/ADM/MESSAGES (SOLARIS)
27.HOW DO YOU TAKE BACKUP OF A CONTROLFILE?
ANS: ALTER DATABASE BACKUP CONTROLFILLE TO DESTINATION (DATABASE SHOULD BE OPEN)
FILE WILL BE SAVE IN THE YOUR DESTINATION
28. WHAT IS THE PARAMETER TO SET THE USER TRACE ENABILING?
ANS: SQL_TRACE = TRUE
29. HOW DO YOU KNOW WHETHER ARCHIVE LOG MODE IS ENABLE OR NOT
ANS: ISSUE COMMAND 'ARCHIVE LOG LIST' IN THE SQLPLUS
30. WHERE DO YOU GET THE INFORMATION OF QUOTAS?
ANS: DBA_TS_QUOTAS VIEW
31. HOW DO YOU KNOW HOW MUCH ARCHIVES ARE GENERATED ?
ANS: USING THE VIEW V$LOG_HISTORY
32. WHAT IS A STALE?
ANS: THE REDOLOG FILE WHICH HAS NOT BEEN USED YET
33. HOW DO YOU READ THE BINARY FILE?
ANS: USING STRINGS -A
USAGE : STRINGS -A FILENAME
34.HOW DO YOU READ CONTROL FILE?
ANS: USING COMMAND TKPROF
USAGE: TKPROF CONTRL.CTL CTROL2.TXT
35. HOW DO YOU SEND THE DATA TO TAPE?
ANS: USING 1. TAR -CVF
2. CPIO
36. HOW DO YOU CONNECT TO DB AND STARTUP AND SHUTDOWN THE DB WITHOUT HAVING DBA GROUP?
ANS: USING REMOTE_LOGIN_PASSWORDFILE
37. WHEN WILL YOU TAKE COLD BACK UP ESPECIALLY?
ANS: DURING UPGRADATION AND MIGRATION
38. HOW DO YOU ENABLE/DISABLE DEBUGGING MODE IN UNIX?
ANS: SET -X AND SET +X
39. HOW DO YOU GET THE CREATE SYNTAX OF A TABLE OR INDEX OR FUNCTION OR PROCEDURE?
ANS: SELECT DBMS_METADATA.GET_DDL('TABLE','EMP','SCOTT') FROM DUAL;
40. HOW DO YOU REPLACE A STRING IN VI EDITOR?
ANS: %S/NAME/NEWNAME
41. WHEN CKPT OCCURS?
ANS: 1. FOR EVERY 3 SECOND
2. WHEN 1/3RD OF DB BUFFER FILLS
3. WHEN LOG SWTICH OCCURS
4. WHEN DATABSE SHUTS DOWN
42. IN WHICH FILE ORACLE INVENTORY INFORMATION IS AVAILABLE?
ANS : /ETC/ORAINST.LOC
42. WHERE ALL ORACLE HOMES AND ORACLE SID INFORMATION AVAILABLE?
ANS: /ETC/ORATAB
43. WHAT IS THE ENVIRONMENT VARIABLE TO SET THE LOCATION OF THE LISTENER.ORA
ANS: TNS_ADMIN
44. HOW DO YOU KNOW WHETHER LISTENER IS RUNNING OR NOT
ANS: PS -EF | GREP TNS
45. WHAT ARE THE TWO STEPS INVOLVED IN INSTACE RECOVERY?
ANS: 1. ROLL FORWARD (REDOFILES DATA TO DATAFILES)
2. ROLL BACKWARD (UNDO FILES TO DATAFILES).
46. IF YOU DELETE THE ALERT LOG FLE WHAT WILL HAPPEN?
ANS: NEW ALERT LOG WILL BE CREATED AUTOMATICALLY
57. HOW DO YOU CREATE A TABLE IN ANOTHER TABLESPACE NAME?
ANS: CREATE TABLE XYZ (A NUMBER) TABLESPACE SYSTEM
58. WHAT ARE THE MODES/OPTIONS IN INCOMPLETE RECOVERY?
ANS: CANCEL BASED, CHANGE BASED, TIME BASED
59. HOW DO YOU CREATE AN ALIAS?
ANS: ALIAS BDUMP='CD $ORACLE_HOME/RDBMS/ADMIN'
60. TYPES OF TRACE FILES?
ANS: 1. TRACE FILES GENERATED BY DATABASE (BDUMP)
2. TRACE FILES GENERATED BY USER(UDUMP)
61. HOW DO YOU FIND THE FILES WHOSE ARE MORE THAN 500K?
ANS : FND . -NAME "*" -SIZE +500K
62. WHERE DO YOU CONFIGURE YOUR HOSTNAME IN LINUX?
ANS: VI /ETC/HOSTS
63. WHAT ARE THE TYPES OF SEGMENTS?
ANS: DATA SEGMENT,UNDO SEGMENT,TEMPORARY SEGMENT,INDEX SEGMENT
64. WHAT IS A SYNONYM AND DIFFERENT TYPES OF SYNONYMS?
ANS: A SYNONYM IS AN ALIAS FOR A TABLE,VIEW, SEQUENCE OR PROGRAM UNIT.
1. PUBLIC SYNONYM
2. PRIVATE SYNONYM
65. WHAT ARE MANDATORY BACKGROUND PROCESSES IN ORACLE DATABASE?
ANS: SMON,PMON,CKPT,DBWR,LGWR
66. HOW DO YOU MAKE YOUR REDOLOG GROUP INACTIVE?
ANS: ALTER SYSTEM SWITCH LOGFILE;
67. HOW DO YOU DROP A TABLESPACE?
ANS: DROP TABLESPACE TS1 INCLUDING CONTENTS AND DATAFILES;
68. WHAT IS THE PARAMETER ALLOWS YOU TO CREATE MAX NO. OF GROUPS?
ANS: MAXLOGFILES=
69. WHAT IS THE PARAMTER ALLOWS TO CREATE MAX NO. OF MEMBERS IN A GROUP?
ANS: MAXLOGNUMBERS=
70. WHAT CONTROLFILE CONTAINS?
ANS: DATABASE NAME
DATABASE CREATION TIME STAMP
ADDRESS OF DATAFILES AND REDOLOG FILES
CHECK POINT INFORMATION
SCN INFORMATION
71. WHAT ARE THE INIT PARAMETERS YOU HAVE TO SET TO MAKE USE OF UNDO MANAGEMENT?
ANS: UNDO_TABLESPACE=
UNDO_MANAGEMENT=
UNDO_RETENTION= TIME IN MINUTES
COMMENT ROLLBACK_SEGMENT
73. HOW DO YOU ENABLE MONITORING OF A TABLE?
ANS: ALTER TABLE TABLENAME MONITORING
74. HOW DO YOU DISABLE MONITORING OF A TABLE?
ANS: ALTER TABLE TABLENAME NO MONITORING
75. HOW DO YOU CHECK THE STATUS OF THE TABLE WHETHER MONITORING OR NOT?
ANS: SELECT TABLE_NAME, MONITORING FROM DBA_TABLE WHERE OWNER='SCOTT;
76. IN WHICH TABLE RECORDS OF MONITOIRG WILL BE STORED?
ANS: DBA_TAB_MODIFICAITONS
77. HOW DO YOU GET YOU DEMO FILES GET CREATED IN YOUR USER?
ANS: ?/SQLPLUS/DEMO/DEMOBLD.SQL EXECUTE THIS SCRIPT ON WHICH USER YOU WANT
78. WHAT IS NETSTAT?
ANS: IT IS A UTILITY TO KNOW THE PORT NUMBERS
79.HOW DO YOU MAKE USE OF STATS PACK?
ANS: 1. SPCREATE.SQL (?/RDBMS/ADMIN/) -- TO CREATE STATSPACK
2. EXECUTE STATSPACK.SNAP -- TO COLLECT DATBASE SNAPS
3. SPREPORT.SQL-- TO GENERATE REPORTS(IN YOUR CURRENT DIRECTO
4. SPAUTO.SQL----TO SCHEDULE A JOB
5. SPPURGE.SQL---TO DELETE STATISTICS
6. SPDROP.SQL----TO DROP THE STATISTICS
1. HOW DO YOU KILL A SESSION FROM THE DATABASE?
ANS: ALTER SYSTEM KILL 'SID,SERIAL#'
USAGE : ALTER SYSTEM KILL '9,8'
GET THE INFO FROM V$SESSION
2. HOW DO YOU KNOW WHETHER THE PROCESS IS SERVER SIDE PROCESS?
ANS. BY SEEING THE PROCESS IN PS-EF AS ORACLE+SID
EG: SUPPOSE THE SID IS PROD, THEN THE SERVER PROCESS IS REFERED AS SERVER SIDE PROCESS AND LOCAL=NO
3. DAILY ACTIVITIES OF A ORACLE DBA?
ANS: 1. CHECK THE DATABSE AVAILABILITY
2. CHECK THE LISTERNER AVAILABILITY
3. CHECK THE ALERT LOG FILIE FOR ERRORS
4. MONITORING SPACE AVAILABLILTY IN TABLESPACES
5. MONITORING MOUNT POINT (SEE CAPACITY PLANNING DOCUMENT)
6. VALIDATE DATABASE BACKUP OR ARCHIVE BACKUP
7. FIND OBJECTS WHICH IS GOING TO REACH MAX EXTENTS
8. DATABASE HEALTH CHECK
9. CPU, PROCESSOR, MEMORY USAGE
4. WHERE DO YOU GET ALL HIDDEN PARAMETERS ?
ANS: IN THE TABLE X$KSPPI
5. HOW DO YOU SEE THE NAMES FROM THAT TABLE?
ANS:SELECT KSPPINM,KSPPDESC FROM X$KSPPI WHERE SUBSTR(KSPPINM,1,1)='_'
6. HOW DO INCREASE THE COUNT OF DATAFILES?
ANS: GENERATE THE CONTROL FILE SYNTAX FROM THE EXISTING CONTROL FILE AND RECREATE THE CONTROL FILE BY CHANGING THE PARAMETER MAXDATAFILES = YOURDESIRED SIZE
PROCEDURE:
1. OPEN THE DATABASE
2. GENERATE THE CONTROL FILE CHANGE THE MAXDATAFILES
3. OPEN THE DB IN NOMOUNT
4. EXECUTE THE SYNTAX WITH NORESETLOGS
5. ALTER DATABSE OPEN
7. WHAT IS THE INIT PARAMETER TO MAKE USE OF PROFILE?
ANS: RESOURCE_LIMITS=TRUE
8. HOW DO YOU KNOW WHETHER THE PARAMETER IS DYNAMIC OR STATIC
ANS: BY GOING V$PARAMETER AND CHECK THE FIELDS ISSES_MODIFIABLE AND ISSYS_MODIFIBLE
9. WHAT IS THE PACKAGE AND PROCEDURE NAME TO CONVER DMT TO LMT AND VICE VERSA?
ANS: EXEC DBMS_SPACE_ADMIN.TABLESPACE_MIGRATE_FROM_LOCAL("GTB")
EXEC DBMS_SPACE_ADMIN.TABLESPACE_MIGRATE_TO_LOCAL("GTB1")
10. WHAT IS THE USE OF NOHUP?
ANS: THE EXECUTION OF A SPECIFIC TASK IS PERFORMED IN THE SERVER SIDE WITH OUT ANY INTERUPTING
USAGE : NOHUP CP -R * /TMP/. &
11. WHERE ALERT LOG IS STORED? WHAT IS THE PARAMETER?
ANS: IN BDUMP. PARAMETER IS BACKGROUND_DUMP_DEST
11. WHERE TRACE FILE ARE STORED? WHAT IS THE PARAMETER?
ANS: IN UDUMP. PARAMETER IS USER_DUMP_DEST
12. COMMON ORACLE ERRORS ……
1) ORA-01555 : SNAPSHOT TOO OLD
2) ORA-01109 : DATABASE NOT MOUNTED
3) ORA-01507 : DATABASE NOT OPEN
4) ORA-01801 : DATABASE ALREADY IN STARTUP MODE.
5) ORA-600 : INTERNAL ERROR CODE FOR ORACLE PROGRAM
USAGE : OERR ORA 600
13. HOW DO YOU ENABLE TRACEING WHILE YOU ARE IN THE DATABASE?
ANS : ALTER SESSION SET SQL_TRACE=TRUE;
14. IF YOU WANT TO ENABLE TRACING IN REMOTE SYSTEM? WHAT WILL U DO?
ANS: EXEC DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION(9,3,TRUE);
15. WHICH ROLE YOU GRANT TO RMAN USER WHILE CONFIGURING RMAN USER
ANS: RECOVER_CATALOG_OWNER
16. WHERE DO YOU GET TO KNOW THE VERSION OF YOUR ORACLE SOFTWARE AND WHAT IS YOUR VERSION?
ANS: FROM V$VERSION(FIELD IS BANNER) AND THE VERSION IS 9.2.0.1.0
17. WHAT IS THE PARAMETERS TO SET IN THE INIT.ORA IF YOU CREATE DB USING OMF?
ANS: DB_CREATE_FILE_DEST=
DB_CREATE_ONLINE_LOG_DEST_1=
18. WHAT IS A RUNAWAY SESSION?
ANS: YOU KILLED A SESSION IN THE DATABASE BUT IT STILL REMAINS IN THE OS LEVEL AND VICE VERSA. ITS CALLED RUNAWAY SESSION. IF RUNAWAY SESSION IS THERE CPU CONSUMES MORE USAGE.
19. HOW DO YOU KNOW WHETHER THE SPECIFIC TABLESPACE IS IN BEGIN BACKUP MODE?
ANS: SELECT STATUS FROM V$BACKUP. IF IT IS ACTIVE IT MEANS IT IS IN BEGIN BACKUP MODE
20. IF YOU WANT TO MAINTAIN ONE MORE ARCHIVE DESTINATION WHICH PARAMETER YOU HAVE TO SET
ANS:ITS A DYNAMIC PARAMETER YOU HAVE TO SET LOG_ARCHIVE_DUPLEX_DEST=
USAGE : ALTER SYSTEM SET LOG_ARCHIVE_DUPLEX_DEST=
21. HOW DO YOU KNOW THE CREATE SYNTAX OF YOUR FUNCTION/PROCEDURE/INDEX/SYNONYM
ANS: USING FUNCTION DBMS_METADATA.GET_DDL(OBJECT TYPE,OBJECT NAME,OWNER)
22. WHAT IS THE PASSWORD YOU HAVE TO SET IN THE INIT.ORA TO ENABLE REMOTE LOGIN ?
ANS: REMOTE_LOGIN_PASSWORD_FILE=EXCLUSIVE
23.HOW DO U SET CRONTAB TO DELETE 5 DAYS OLD TRACE FILES AT DAILY 10'0 CLOCK?
ANS: CRONTAB -E
0 10 * * * /USR/BIN/FIND /U001/ADMIN/UDUMP -NAME "*.TRC" -MTIME +5 -EXEC RM -RF {} \;
SAVE AND EXIT (WQ!)
24.HOW DO U KNOW WHEN SYSTEM WAS LAST BOOTED?
ANS: 3 WAYS 1.UPTIME CMD
2.TOP
3.WHO -B
4.W
24.HOW DO U KNOW LOAD ON SYSTEM?
ANS: 1.W
2.TOP
25. HOW DO YOU WHEN THE PROCESS IS STARTED
ANS : USING PS -EF | GREP PROCESS NAME
26. TELL ME THE LOCATION OF UNIX LOG MESSAGES STORED?
ANS:/VAR/LOG/MESSAGES
/VAR/ADM/MESSAGES (SOLARIS)
27.HOW DO YOU TAKE BACKUP OF A CONTROLFILE?
ANS: ALTER DATABASE BACKUP CONTROLFILLE TO DESTINATION (DATABASE SHOULD BE OPEN)
FILE WILL BE SAVE IN THE YOUR DESTINATION
28. WHAT IS THE PARAMETER TO SET THE USER TRACE ENABILING?
ANS: SQL_TRACE = TRUE
29. HOW DO YOU KNOW WHETHER ARCHIVE LOG MODE IS ENABLE OR NOT
ANS: ISSUE COMMAND 'ARCHIVE LOG LIST' IN THE SQLPLUS
30. WHERE DO YOU GET THE INFORMATION OF QUOTAS?
ANS: DBA_TS_QUOTAS VIEW
31. HOW DO YOU KNOW HOW MUCH ARCHIVES ARE GENERATED ?
ANS: USING THE VIEW V$LOG_HISTORY
32. WHAT IS A STALE?
ANS: THE REDOLOG FILE WHICH HAS NOT BEEN USED YET
33. HOW DO YOU READ THE BINARY FILE?
ANS: USING STRINGS -A
USAGE : STRINGS -A FILENAME
34.HOW DO YOU READ CONTROL FILE?
ANS: USING COMMAND TKPROF
USAGE: TKPROF CONTRL.CTL CTROL2.TXT
35. HOW DO YOU SEND THE DATA TO TAPE?
ANS: USING 1. TAR -CVF
2. CPIO
36. HOW DO YOU CONNECT TO DB AND STARTUP AND SHUTDOWN THE DB WITHOUT HAVING DBA GROUP?
ANS: USING REMOTE_LOGIN_PASSWORDFILE
37. WHEN WILL YOU TAKE COLD BACK UP ESPECIALLY?
ANS: DURING UPGRADATION AND MIGRATION
38. HOW DO YOU ENABLE/DISABLE DEBUGGING MODE IN UNIX?
ANS: SET -X AND SET +X
39. HOW DO YOU GET THE CREATE SYNTAX OF A TABLE OR INDEX OR FUNCTION OR PROCEDURE?
ANS: SELECT DBMS_METADATA.GET_DDL('TABLE','EMP','SCOTT') FROM DUAL;
40. HOW DO YOU REPLACE A STRING IN VI EDITOR?
ANS: %/NAME/NEWNAME
41. WHEN CKPT OCCURS?
ANS: 1. FOR EVERY 3 SECOND
2. WHEN 1/3RD OF DB BUFFER FILLS
3. WHEN LOG SWTICH OCCURS
4. WHEN DATABSE SHUTS DOWN
42. IN WHICH FILE ORACLE INVENTORY INFORMATION IS AVAILABLE?
ANS : /ETC/ORAINST.LOC
42. WHERE ALL ORACLE HOMES AND ORACLE SID INFORMATION AVAILABLE?
ANS: /ETC/ORATAB
43. WHAT IS THE ENVIRONMENT VARIABLE TO SET THE LOCATION OF THE LISTENER.ORA
ANS: TNS_ADMIN
44. HOW DO YOU KNOW WHETHER LISTENER IS RUNNING OR NOT
ANS: PS -EF | GREP TNS
45. WHAT ARE THE TWO STEPS INVOLVED IN INSTACE RECOVERY?
ANS: 1. ROLL FORWARD (REDOFILES DATA TO DATAFILES)
2. ROLL BACKWARD (UNDO FILES TO DATAFILES).
46. IF YOU DELETE THE ALERT LOG FLE WHAT WILL HAPPEN?
ANS: NEW ALERT LOG WILL BE CREATED AUTOMATICALLY
57. HOW DO YOU CREATE A TABLE IN ANOTHER TABLESPACE NAME?
ANS: CREATE TABLE XYZ (A NUMBER) TABLESPACE SYSTEM
58. WHAT ARE THE MODES/OPTIONS IN INCOMPLETE RECOVERY?
ANS: CANCEL BASED, CHANGE BASED, TIME BASED
59. HOW DO YOU CREATE AN ALIAS?
ANS: ALIAS BDUMP='CD $ORACLE_HOME/RDBMS/ADMIN'
60. TYPES OF TRACE FILES?
ANS: 1. TRACE FILES GENERATED BY DATABASE (BDUMP)
2. TRACE FILES GENERATED BY USER(UDUMP)
61. HOW DO YOU FIND THE FILES WHOSE ARE MORE THAN 500K?
ANS : FND . -NAME "*" -SIZE +500K
62. WHERE DO YOU CONFIGURE YOUR HOSTNAME IN LINUX?
ANS: VI /ETC/HOSTS
63. WHAT ARE THE TYPES OF SEGMENTS?
ANS: DATA SEGMENT,UNDO SEGMENT,TEMPORARY SEGMENT,INDEX SEGMENT
64. WHAT IS A SYNONYM AND DIFFERENT TYPES OF SYNONYMS?
ANS: A SYNONYM IS AN ALIAS FOR A TABLE,VIEW, SEQUENCE OR PROGRAM UNIT.
1. PUBLIC SYNONYM
2. PRIVATE SYNONYM
65. WHAT ARE MANDATORY BACKGROUND PROCESSES IN ORACLE DATABASE?
ANS: SMON,PMON,CKPT,
63. WHAT IS THE UTILITY TO CHANGE THE PASSWORD OF A DBA SCHEMA IN ORACLE APPS?
ANS: FNDCPASS
64. WHAT ARE MANDATORY USERS IN ORACLE APPS?
ANS: APPLSYS,APPLSYSPUB,APPS
DAILY ACTIVITIES AS A ORACLE DBA
---------------------------------
1. CHECKING AVAILABILITY OF DB, LISTENER
2. CHECKING ALERT LOG FILE FOR ERRORS(LIKE ORA -600,ORA-7445,ORA-1555)
3. CHECKING THE BACKUPS SUCCESSFULL OR NOT
4. CHECK FOR SPACE AVAILABILITY IN TABLESPACES(DBA_DATA_FILES,DBA_VIEWS)
5. CHECK THE FREE SPACE IN MOUNT POINTS
6. PURGING OLD LOG FILES AND OUT FILES
7. CHECKING THE MEMORY AND CPU USAGE
8. MONITORING ARCHIVES
9. GETTING REQUESTS FROM THE USER
10.CREATING NEW SCHEMAS. TABLESAPCES AND NEW TABLES AND PROVIDING PARAMETERS
11. CLEARING LOGS, RESOLVING LOG ISSUES, CLEAING RUNAWAY SESSINOS, PERFORMING TRACING OF SESSIONS,PERFORMING GRANTS & SYNONYMS
12. REFRESHING SCHEMAS,TABLES OR DB (IMP /EXP)
13. RESOLVING TNS AND LISTENER ISSUES
14. MONITORING DATA LOADS
15. INSTALLATION OF NEW ORACLE HOMES
16. INSTALLATINO OF NEW SOFWARE AT CLIENT SIDE
17. MONITORING UNDO SEGEMENTS
WEEKLY ACTIVITIES AS A DBA
---------------------------------
1. GATHERING STATISTICS
2. PERFORM CLONING
3. GATHERING STORAGE USED FOR DB FOR THAT WEEKLY SELECT SUM(BYTES) FROM DBA_SEGMENTS
DAILY ACTIVITIES AS A APPS DBA
---------------------------------
1. ORACLE DBA ACTIVITIES
2. MONITORING APPS SERVICES
3. PERFORMING PACTCHING AND ANALYZING THE IMPACT
4. TROUBLE SHOOTING USER ISSUES LIKE TNS NAMES , FRONT END CONNECT VITY PROBS
5. PERFORMING CONFIGURATIN CHANGES IF NECESSARY
6. CLONING ON DEMAND OR SCHEDULE
7. BACKUPS
8.CREATING APPS USERS AND ASSIGN RESPONSIBILITIES
No comments:
Post a Comment