oracle-databaseadministration.blogspot.com
Oracle DBA: Questions are asked relating to Unix
http://oracle-databaseadministration.blogspot.com/2008/02/questions-are-asked-relating-to-unix.html
Wednesday, February 27, 2008. Questions are asked relating to Unix. In many Oracle DBA interviews many questions are asked relating to Unix. Here I have collected some common Interviews questions asked to a DBA relating to Unix environment. These questions are mostly asked for senior Oracle DBA positions. I have compiled these questions based upon the feedback I got from many candidates who have attended interviews in various MNC'. 1 How do you see how many instances are running? 4 What is OERR utility?
oracle-databaseadministration.blogspot.com
Oracle DBA: Common Interview Questions for Oracle Database Administrator
http://oracle-databaseadministration.blogspot.com/2008/02/common-interview-questions-for-oracle.html
Wednesday, February 27, 2008. Common Interview Questions for Oracle Database Administrator. 1 What is an Oracle Instance? 2 What information is stored in Control File? 3 When you start an Oracle DB which file is accessed first? 4 What is the Job of SMON, PMON processes? 5 What is Instance Recovery? 6 What is written in Redo Log Files? 7 How do you control number of Datafiles one can have in an Oracle database? 8 How many Maximum Datafiles can there be in an Oracle Database? 9 What is a Tablespace? 23 Wha...
oracle-databaseadministration.blogspot.com
Oracle DBA: Common Backup Recovery Interview Questions
http://oracle-databaseadministration.blogspot.com/2008/02/common-backup-recovery-interview.html
Wednesday, February 27, 2008. Common Backup Recovery Interview Questions. Some of the Common Backup and Recovery Interview Questions for Oracle Database Administrator. These questions are common for both Senior Oracle DBA or Junior DBA. I have compiled these questions based upon the feedback I got from many candidates who have attended interviews in various MNC's. 1 Which types of backups you can take in Oracle? 2 A database is running in NOARCHIVELOG mode then which type of backups you can take? 20 Can ...
oracle-databaseadministration.blogspot.com
Oracle DBA: Oracle Technical Interview Questions Answered - Part1
http://oracle-databaseadministration.blogspot.com/2008/02/oracle-technical-interview-questions.html
Wednesday, February 27, 2008. Oracle Technical Interview Questions Answered - Part1. James F. Koopmann. Database Expert) Posted 10/21/2005. The interview process can be quite stressful. Here is the first part of a two part series on helping you answer those tough questions that you might experience in your quest for an Oracle DBA position. I actually wrote this article a long time ago but it is amazing how many questions I still get every week from this one. Stay tunned for Part II next week. The benefit...
troubleshooot.wordpress.com
Listing database users with default passwords is simple! | my experiences with Oracle!
https://troubleshooot.wordpress.com/2014/07/24/listing-database-users-with-default-passwords-is-simple
My experiences with Oracle! Applications DBA – Useful SQLs. Core DBA – Useful SQLs. Listing database users with default passwords is simple! From 11gR1 onwards view DBA USER WITH DEFPWD shows users with default passwords, simple isn’t it! This just as username column as follows and a simple select * from this view will give us the list. SQL desc dba users with defpwd. USERNAME NOT NULL VARCHAR2(30). For info on it. SQL set def off. EXPIRED and LOCKED';. This entry was posted in Troubleshooting. Listing d...
troubleshooot.wordpress.com
January | 2014 | my experiences with Oracle!
https://troubleshooot.wordpress.com/2014/01
My experiences with Oracle! Applications DBA – Useful SQLs. Core DBA – Useful SQLs. Monthly Archives: January 2014. Http:/ www.oracle.com/technetwork/database/features/availability/rman-fra-snapshot-322251.html. January 10, 2014. Oracle high availability technologies demos link. Http:/ www.oracle.com/technetwork/database/features/availability/demonstrations-092317.html. This entry was posted in Troubleshooting. January 10, 2014. Monitoring Applications login URL. Oracle Database In Memory!
troubleshooot.wordpress.com
Notes on Oracle Applications sizing (R12.x environments) | my experiences with Oracle!
https://troubleshooot.wordpress.com/2014/07/24/notes-on-oracle-applications-sizing-r12-x-environments
My experiences with Oracle! Applications DBA – Useful SQLs. Core DBA – Useful SQLs. Notes on Oracle Applications sizing (R12.x environments). First time I see that Oracle has provided some sizing recommendations in the Apps install guide. Following is the synopsis from the document for easy reference. Memory and CPU recommendation for OAF connections. OAF Connections (Both Apps and DB Tiers). Number of Concurrent Users. Number of Database Machine CPUs. Application Tier Machine Memory. Sizing to be done f...
troubleshooot.wordpress.com
November | 2013 | my experiences with Oracle!
https://troubleshooot.wordpress.com/2013/11
My experiences with Oracle! Applications DBA – Useful SQLs. Core DBA – Useful SQLs. Monthly Archives: November 2013. Oracle’s article on top 10 list for success in cloud. Http:/ www.oracle.com/technetwork/articles/entarch/orgeron-top-10-cloud-1957407.pdf. This entry was posted in Troubleshooting. November 19, 2013. Monitoring Applications login URL. Oracle Database In Memory! Listing database users with default passwords is simple! Notes on Oracle Applications sizing (R12.x environments).
troubleshooot.wordpress.com
R12.2 online patching brief (adop) | my experiences with Oracle!
https://troubleshooot.wordpress.com/2014/07/23/r12-2-online-patching-brief-adop
My experiences with Oracle! Applications DBA – Useful SQLs. Core DBA – Useful SQLs. R122 online patching brief (adop). From 12.2 onwards we can apply patches online causing downtime equivalent to only restarting of apps services. Unlike its predecessor adpatch, running adop constitutes a online patching life cycle of many phases as follows. Meaning we will be running adop with following options (Ex: $ adop phase=prepare) to complete particular phase before proceeding with subsequent phase. Cutover: This ...
troubleshooot.wordpress.com
Applications DBA – Useful SQLs | my experiences with Oracle!
https://troubleshooot.wordpress.com/applications-dba-useful-sqls
My experiences with Oracle! Applications DBA – Useful SQLs. Core DBA – Useful SQLs. Applications DBA – Useful SQLs. To check run times for a concurrent request:. To Check which users have a given responsibility:. Select user name,responsibility name,fu.end date. FND USER RESP GROUPS DIRECT furgd,. Fnd user fu,. Fnd responsibility vl fr. Furgduser id=fu.user id and. Furgdresponsibility id=fr.responsibility id and. RESPONSIBILITY NAME like '%&Resp name%';. Col program format a50. PARENT REQUEST ID,. 8216;P...
