oracle apps dba responsibilities

The daily work and responsibilities of DBAs in Oracle --- [1] The following summary is a summary written in "Deep Oracle", which corresponds to the amount of funds learned. 1. Let's take a look at Oracle's learning route: 2. learning basics: I have learned basic Oracle knowledge and have a general understanding of

xmlns:dc="http://purl.org/dc/elements/1.1/"xmlns:trackback="http://madskills.com/public/xml/rss/module/trackback/">rdf:about="http://www.blogjava.net/cymao/archive/2006/03/30/38289.html"dc:identifier="http://www.blogjava.net/cymao/archive/2006/03/30/38289.html"dc:title="DBA的职责和任务(转自oracle中文技术论坛)"trackback:ping="http://www.blogjava.net/cymao/services/trackbacks/38289.aspx" />--> It is from the

normally and all types of databases are in normal state. 2. Check whether the hard disk space is sufficient. 3. view database logs, trace files, and check for errors 4. Check the backup validity. 5. Monitor the server performance parameters through the system performance monitor to find out whether the database performance is degraded, find the cause and solve the problem. 6. Enter the DBA log Weekly work: 1. Monitor the space expansion of database o

1. What is Oracle R12.2R12.2 DefinitionArchitectureAdvantages of R12.2Limitations of R12.2What the benefit business users would get from R12.2 2. Difference between R12.1 and R12.2 ArchitectureArchitectural difference between R12.1 and R12.2Advantages and disadvantages of R12.1 and R12.23. What's online patchingConcept of Online PatchingADV and disadvantage of Online pathing cycleLimitations of Online Patching4. Installation of R12.2Installation of R1

server is working properly, all kinds of databases are in good condition2 Check if the hard disk space is sufficient3 View database logs, view trace files, check for error messages4 checking the validity of backups5 Monitor the performance of the server through the Performance Monitor of the system to discover whether the performance of the database is degraded, find the cause and resolve6 Completing the DBA logWeekly work1 Monitoring the spatial exp

Label:1. Total Statistical Database capacitySeparate statistics by Table space:Total capacity (unit m):2. Calculate the size of all objects under the user3 Calculating the size of the users table space 4 calculates the users tablespace object size -----------------------------------------------The following excerpt from the network-----------------------------------------------DBA responsibilities and d

Oracle DBA Daily Summary Oracle administrators should regularly monitor the Oracle database system as follows: 1, every day to the Oracle database running status, log files, backup situation, database space usage, system resource usage to check, to identify and resolve t

oracle| Admin | data | database Responsibilities of Oracle Database administrators Oracle database administrators should regularly monitor Oracle database systems as follows: (1). Daily operation Status of Oracle database, log f

I have previously introducedExplain Oracle Database Administrator's weekly responsibilities,Explain the daily task responsibilities of the Oracle Database AdministratorNext, we will introduce the monthly responsibilities and daily management of

PrefaceThis article describes DBA's daily responsibilities in monitoring Oracle databases and how to use shell scripts to perform repeated monitoring. This article first reviews some common DBA Unix Commands and explains how to regularly execute DBA scripts through UNIX cron. The article also introduces eight important

authors not only emphasize the practicality and operability of the case, but also repeat the process and ideas for solving the problem and sum up experience and lessons. They hope to combine the accumulated work methods over the years, the insights on DBA career development are presented for the reference of Oracle DBAs. Directory1st DBA work Note 1DBA work manu

backup method and policy? What is the network file configuration? 19. Check the recent alert logs to obtain useful information. 20. run several performance analysis reports to see how the system is running recently. 21. Run an RDA report to collect the complete system status report. Well, with this basic information (incomplete), you have a general understanding of the system you are new to. Next, you can analyze it in depth, then we will formulate a set of O M specifications that meet the act

Oracle Apps Script to create a new User Login Account: -- CREATE a new user account DECLARE P_user_name VARCHAR2 (200): ='Ptiany'; P_owner VARCHAR2 (200): =NULL; P_unencrypted_password VARCHAR2 (200): ='Welcome'; P_session_number NUMBER: = USERENV ('Sessionid'); P_start_dateDATE: = SYSDATE; P_end_dateDATE: =NULL; P_last_logon_dateDATE: =NULL; P_description VARCHAR2 (200): ='Pan tiany'; P_passwor