|
|
| Re: basic DBA project [message #568973 is a reply to message #568970] |
Thu, 18 October 2012 04:58   |
John Watson
Messages: 3102 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
Welcome to the forum. Please read our OraFAQ Forum Guide and How to use [code] tags and make your code easier to read
For the first question, run a query to find all the views whose names begin with ALL. Unfortunately, there are quite a few of them:orcl> select count(*) from all_objects where object_type='VIEW' and object_name like 'ALL%';
COUNT(*)
----------
587
orcl> so you need to adjust the search string to select only those views whose name includes some other string as well, such as USER or PRIV or ROLE and so on. Then run queries against those views, joining them as necessary, to build up the picture of how CHRISTIAN's schema is configured.
If you get stuck, post your code here and perhaps someone will give more advice.
|
|
|
|
| Re: basic DBA project [message #568974 is a reply to message #568973] |
Thu, 18 October 2012 05:08   |
 |
Michel Cadot
Messages: 54129 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Another option to list the views related to an issue is to use the DICTIONARY view, for instance:
SQL> select table_name, comments
2 from dictionary
3 where table_name like 'ALL%'
4 and lower(comments) like '%role%'
5 order by 1
6 /
TABLE_NAME COMMENTS
------------------------------ ---------------------------------------------------------------------------
ALL_COL_PRIVS Grants on columns for which the user is the grantor, grantee, owner,
or an enabled role or PUBLIC is the grantee
ALL_COL_PRIVS_RECD Grants on columns for which the user, PUBLIC or enabled role is the grantee
ALL_TAB_PRIVS Grants on objects for which the user is the grantor, grantee, owner,
or an enabled role or PUBLIC is the grantee
ALL_TAB_PRIVS_RECD Grants on objects for which the user, PUBLIC or enabled role is the grantee
Also all catalog views are described in Database Reference.
Regards
Michel
[Edit: wrong edit]
[Updated on: Thu, 18 October 2012 06:17] Report message to a moderator
|
|
|
|
|
|
|
|
|
|
| Re: basic DBA project [message #569510 is a reply to message #569508] |
Sun, 28 October 2012 11:04  |
John Watson
Messages: 3102 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
I would say that you need to re-visit your answer to task 4. Consider the possible use of indexes.
Your task 3 answer is a little disorganized. You have not in fact answered tbe question, which requires a sorted list of possible issues with a guess at estimated probabilities, followed by a suggested architecture (such as ASM mirroring at all sites plus Data Guard plus whatever else) to address those issues. Also, I don't understand the references to Exadata. I don't actually see it's relevance, but perhaps you can work on that.
Nice try - keep at it.
|
|
|
|