oracle dba tables

After ORACLE is installed in LINUX, you cannot log on to iSQL * Plus as a DBA -- Linux general technology-Linux technology and application information. For more information, see the following. After ORACLE is installed in LINUX, you cannot log on to iSQL * Plus as a DBA. Why? To log on to isqlplus as a

Mainly for Oracle DBA in the growth stage of the positioning, learning methods and other aspects of the classic discussion, the details please refer to the following.First, positioningOracle is divided into two chunks, one for development and one for management. Development is mainly about writing stored procedures, triggers and so on, and using Oracle's develop tool as a form. A bit similar to the programm

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

ORACLE11G is a more generic version, trying to install Oracle 12c unfortunately failed, there is no wayThe following is the collation of information 1. Attached to the installation file Http://download.oracle.com/otn/linux/oracle11g/R2/linux.x64_11gR2_database_1of2.zip? authparam=1407205871_4259949f8bacf912168631692563a693Http://download.oracle.com/otn/linux/oracle11g/R2/linux.x64_11gR2_database_2of2.zip? Authparam=1407205876_ec394cc017d1815a8cce7cc

The solution is as follows:1-From the command prompt, stop isqlplus:C: \> isqlplusctl stop2-Assuming that you install oracle under C drive, run the following comands: C: \> set oracle_home = c: \ oracle \ product \ 10.2.0 \ db_1C: \> set java_home = % ORACLE_HOME % \ jdk3-Change directory: Cd % ORACLE_HOME % \ Solaris \ j2ee \ isqlplus \ application-deployments \ isqlplus4-Suppose you need to create a new u

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

, the hope from the system construction and the professional quality of engineers to start, to prevent the DBA of this random dangerous operation.But, after all, the management system is "soft", the hope rests on the engineer consciously abide by the system and "self-cultivation" on, and can not guarantee foolproof.The security components provided by Oracle can be used to limit, block, and prevent such rand

-level recovery with flashback. Things are destined to be together, in front of the unlucky egg rocky, the telephone rang. The phone is from the finance department, meaning that because of the mistake, he changed the financial software to the salary scale of a salary increase of a wrong number, you find that your monthly salary has become million (jokes). In fact, everyone is so expected! It needs you to save his mistakes! Using flashback can also help you solve problems quickly.8. Be a good hab

Tags: Oracle video tutorialOracle DBA Database Senior Engineer Training course is the wind brother alone research and development of the fine combat courses, the road map is mainly to let everyone fast employment, high-paying employment. The course focuses on Oracle company profile, Oracle Database Introduction, why do

The Oracle Database Administrator should perform regular monitoring on the Oracle database system as follows: (1) daily running status, log files, backups, and data of Oracle databases 　　 Library space usage, system resource usage check, find and solve the problem. 　　 (2) Monitor the space expansion and data growth of database objects every week, check the databa

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

Maintenance instructionsValidate backupset instructions for 22.18.1 Rman22.18.2 Rman Restore ... Validate directives22.18.3 Rman Restore ... Preview directives22.18.4 Rman's List command22.18.5 Rman's command22.19 Summary of this chapter23rd Chapter Oracle Flash back Technology23.1 Understanding the Flash back level23.2 Flash back to database23.2.1 Flash-Back Database overview23.2.2 Enable flash back database23.2.3 Shutdown Flash Back database23.2.4

This is a sophomore time in the QQ space of an article, I remember that this problem took me the whole day to deal with it, so at that time to feel quite deep, So at that time deliberately recorded the process of this settlement, and today suddenly have the interest to find a few college writing in the space of the article and share with you, in case similar to what happened to me, but also spend a lot of time, the following is the entire contents of the record: Log in today with user Scott log

Tags: Oracle Video Tutorials Oracle Tutorial Oracle Database teach Oracle Getting Started learning Oracle Learning GuideOracle DBA Database Senior Engineer Training course is the wind brother alone research and development of the

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

During the Oracle database operation, the DBA should monitor the database's running log and table space usage, and discover the problems in the database as early as possible. Oracle Warning log file monitoring Oracle will log some of the database operations in the warning log file (alert_sid.log) during the run: The

DBA _ view returns information about all objects in the database, regardless of the object owner. Only the database administrator can access this view. For example, a query of DBA_TABLES returns a list of tables related to the database. Sometimes the database administrator can authorize developers to access the DBA view. Synonyms are not created for these views,

Previous:Oracle DBA Study Notes-start and close DatabasesNext article: Oracle DBA Study Notes-log files (using logminer to analyze logs) 1Control File Control File Information:The size of the control file is related to the settings when the database is created. (1)Database creation time information (2)Database Name, table space name (3)Related data file,

Label:The differences between Oracle DBA and SYSDBA are as follows:1. A DBA is a role that corresponds to the set of operations permissions on an object in an Oracle instance, and SYSDBA is a conceptual role that is a sign-in authentication identity. Moreover, the DBA is an