| My boss needs a neutral outside opinion to decide the policy of management for these Databases [message #557979] |
Mon, 18 June 2012 07:22  |
 |
tajmir
Messages: 2
Registered: June 2012
Location: paris
|
Junior Member |
|
|
Hi every one,
BI Developer Team would perform the following listed points ON PRODUCTION Data Marts using Oracle Enterprise Manager. As they have any administration knowledge, I do not want to give them access to Enterprise Manager. So, I have developed procedures that allow them to do these tasks easy and securely. But they would not use my tools and say these are not graphic tools, as if execution of a procedure (execute procedure_name) was difficult from Toad or other tools.
My boss needs a neutral outside opinion to decide the policy of management for these Databases.
Questions to answer are :
1. Do you endorse and approve what ask BI Developer Team?
2. Or want you tell to my boss that they must comply with my tools and use it?
3. If you approve their demand, how to give access them to some part of Oracle Enterprise manager without giving them Full access?
List of tasks Developers would to do:
1. Follow the solicitation of the database.
2. View user's queries.
3. Identify the longest, the most common queries in database.
4. View and delete locks.
5. Managing Tablespaces.
6. Kill user sessions.
7. Execute and/or schedule batch jobs on the database from the OEM interface.
Thinks for your response.
Regards
Some of procedures that I have developped.
1. Show size of the TEST Tablespaces
SQL> exec GES_TBS.show_tbs('TEST');
TABLESPACE_NAME FILE_NAME SIZE_MO AUTOEXTENSIBLE MAX_EXT_MO
---------------- ------------------------------------ -------- -------------- ------------
TEST F:\ORACLE\DATA\PDMRH\TEST01.DBF 10 YES 1024
2. Increase the size of datafile to 20 MO
SQL> exec GES_TBS.RESIZE_DATA_FILE('F:\ORACLE\DATA\PDMRH\TEST01.DBF',20);
3. Add a Datafile to TEST Tablespace
SQL> exec GES_TBS.ADD_DATA_FILE('TEST','F:\ORACLE\DATA\PDMRH\TEST02.DBF', 10);
4. Verify the new datafile and size of TEST Tablespace
SQL> exec GES_TBS.show_tbs('TEST');
TABLESPACE_NAME FILE_NAME SIZE_MO AUTOEXTENSIBLE MAX_EXT_MO
---------------- ----------------------------------- -------- -------------- ------------
TEST F:\ORACLE\DATA\PDMRH\TEST01.DBF 20 YES 1024
TEST F:\ORACLE\DATA\PDMRH\TEST02.DBF 10 YES 32768[Updated on: Mon, 18 June 2012 08:20] by Moderator Report message to a moderator |
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
