oracle dba fundamentals

Before the business system stress test, Oracle dba must complete the work in advance. oracledba This article is the original article, reproduced please indicate the source: http://blog.csdn.net/msdnchina/article/details/42376661 Before the business system stress test, the Oracle dba must complete the following work in

Common Oracle DBA operations Modify language environment Change Chinese environment to English environment Alter session set als_language = 'American '; Change the English environment to a Chinese Environment Alter session set nls_language = 'simplified CHINESE '; Queries the tables owned by the user. Select table_name from user_tables; Query the name and purpose of a data dictionary table in

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

; Conn Test/test as Sysoper; is connected. Sql> Show User USER is "public" Sql> Conn Test/test as Sysdba is connected. Sql> Show User USER is "SYS" Sql> 3, the difference between DBA and SYSDBA DBA, Sysdba What's the difference between the two system roles, before I explain this, I need to talk about the Oracle service creation process • Create an inst

What Oracle DBA should do on a daily, weekly, and monthly basis (I) Check alert on a daily basis. log ② check the environment ● check whether the database instance is working properly ▼ ps-ef | grep ora _ explain select status from v $ instance ● whether the listener is working properly ▼ lsnrctl status ● whether the tablespace is faulty ▼ select tablespace_name, status from dba_tablespace; ● control file,

. Oracle returns a warning message and starts database recovery 1 　　Q. 5: Bob tried to shutdown normal, Oracle said it was unavailable, and when he tried to starup, oracle said that it was already started. what is the best mode that bob can use to force a shutdown on the server 1. NORMAL2. ABORT3. IMMEDIATE4. NONE 2 　　Q. 6: Tom issued a command to startup the da

Oracle DBA Common Queries–1. Querying the system for all objectsSelect owner, object_name, Object_type, created, Last_ddl_time, timestamp, statusFrom Dba_objectsWhere Owner=upper (' Scott ')–2. View all system tablesSelect owner, TABLE_NAME, tablespace_name from Dba_tables–3. View all users ' tablesSelect owner, TABLE_NAME, tablespace_name from All_tables–4. View the current User tableSelect table_name, tab

XPROCESSES) + 5 By default, this parameter is automatically calculated and takes effect when PROCESSES is modified. 2. Operating System Dependent Parameters The valid values or value ranges of some parameters depend on or are limited by the operating system, such as the db_cache_size parameter, which sets the memory size used by Oracle. The maximum value of this parameter is limited by the physical memory. This type of parameter is generally not cal

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

Oracle knowledge sorting DBA thoughts and skiesThe Inventory Oracle Installation Tool OUI is used to manage the Oracle parameter files in the Oracle installation directory. After startup, it reads the parameter files in the following order. If reading fails, it fails to star

Oracle dba Pen TestOne: SQL tuning class 1: Enumerate several table connection ways2: How to view SQL execution plan without the help of Third-party tools3: How to use the difference between CBO,CBO and rule4: How to locate the SQL that is important (consumes a lot of resources)5: How to track the SQL of a sessionWhat is the most concerned about 6:sql adjustment7: Talk about your knowledge of indexes (struc

monitoring is necessary 207Thinking on the construction of 6.7 operation and maintenance platform--meta data management 2096.8 Monitoring blind spots and diagnostic cases 210Monitoring blind spots: A potential monitoring problem caused by dual 210Diagnostic Case: Standby CPU Usage Exception Optimization 213Diagnostic Case: Two alarm information combined with analysis of DG Problem 216Diagnostic case: Monitoring anti-monitoring error--an analysis of a Orabbix alarm 222Diagnostic case: Customizin

ORACLE DBA face Test setOne: SQL tuning class1 Enumerate several table connection wayssuch as connection, non-equal connection, self connection, outer connection (left, right, full)2 How to view SQL execution plan without the help of a third-party tool(I) Use explain plan to query plan_table;EXPLAIN PlanSET statement_id= ' QUERY1 'ForSELECT *From aWHERE aa=1;SELECT operation, Options, object_name, object_ty

oracle| Script In a longer period of interaction with Oracle, each DBA, especially some heroes have a variety of scripting tools to complete a variety of purposes, so very convenient and quick to complete the day-to-day work, the following part of my commonly used to show you, this article mainly focused on database management, these scripts have been rigorously

solution　　(3). Seek opportunities for database performance Adjustment　　Compare daily monitoring reports on database performance to determine whether it is necessary to adjust database performance　　(4). database performance Adjustment　　Adjust the performance if necessary　　(5) propose the next space management plan　　Based on weekly monitoring, this paper proposes an improvement method for space management.　　Routine Oracle

previous: oracle DBA Study Notes-control files RedoLog Files Redo log files record the changes made to the database (or changes to transactions) in the form of redo records, including the execution of DMLOrDDLStatement modification to the database,It also includesDBAModify the database structure,Redo log files also need to be reused. Log File writing principles:1.Write order must strictly fol

========================================================== ============================######### Create a database ---- look $ ORACLE_HOME/rdbms/admin/buildall. SQL ############ CREATE DATABASE db01maxlogfiles 10 maxdatafiles 1024 maxinstances 2 logfilegroup 1 ('/u01/oradata/db01/log_01_db01.rdo') size 15 m, group 2 ('/u01/oradata/db01/log_02_db01.rdo') size 15 m, group 3 ('/u01/oradata/db01/log_03_db01.rdo') size 15 m, datafile 'u01/oradata/db01/system_01_db01.dbf') size 100 m, undo tablespace

A lot of the time, do Oracle DBA us, when the application administrator to inform us that the application is now slow, the database is very slow, when we go to the database to do a few examples of select also found the same problem, sometimes we can not start, Because we believe that the various life rates of the database are recommendations for meeting Oracle do

depends on whether you want to be a DBA or a developer? The certificate is sure to be taken, just like having a driver's license to drive a car. Second, there are teachers to get you started. Entering the industry will be quick, otherwise it is difficult to enter the industry role. If you have a friend who knows best, if not, it is also a good choice to attend the training. Choose a company with real training technology is the best, of course, our cen

This article mainly introducesOracle 10g isqlplusUseDBA accountNext, we will introduce them one by one. 1. vi. bash_profile Add Environment Variables exportJAVA_HOME=$ORACLE_HOME/jdk Save and exit. source.bash_profile 2. Switch to the correct directory cd$ORACLE_HOME/oc4j/j2ee/isqlplus/application-deployments/isqlplus 3. Run the JAZN shell. $JAVA_HOME/bin/java-Djava.security.properties=$ORACLE_HOME/sqlplus/admin/iplus/provider -jar$ORACLE_HOME/oc4j/j2ee/hom