Oracle Apps R12 Schema Analysis
Continuing on my series on analysis, here is some of the initialĀ analysis I did after installing Oracle applications R12.Ā Much ofĀ the analysis involves queries to the Oracle data dictionary underĀ the covers.Ā This analysis is on the sample “database”, VIS, whichĀ is actually composed of many schemas.
I also did a fair bit of analysis from a DBA standpoint:Ā tablespaces, logs, processes, DBMS_JOBS, etc.Ā And other analysis on the unix and middle tier side.Ā Tuning.Ā I’ll try to keep it allĀ organized in different posts.
When I’ve started a new position, these are the types of queries IĀ might run on the schemas to get a feel for the systems.Ā Just how wasĀ it made? Does it use PK, triggers, or external code to enforceĀ data integrity?Ā What are the most important tables?Ā What areĀ potential performance issues? Any issues?Ā And so on.
Many of these queries you won’t find the GUIs like SQL Developer, orĀ Toad.Ā You have to write them yourself.Ā It pays big dividends toĀ know the data dictionary!
(Sorry for the odd font. WordPress has not made changing the font forĀ select sets of text easy or obvious. If anyone knows the secret,Ā on how to change fonts in WordPress A LA Wordpad, please let me know. )
------------------------------------------------
------------------------------------------------
How many tables are there?
Read the rest of this entry »
You must be logged in to post a comment.