oracle dba for beginners

. Import role DataA. First enter the DOS consoleB, enter the exported data directory, such as: CD C:/userdirC, Input command, IMPD, enter user name, password, import this data to the userE, followed by the return, enter key can beF, prompt to enter the user name, password, this is the data from which user to export, is that user's10. Sqlplus Common CommandsA, set Linesize 120 can set the Sqlplus display buffer size;B, set pageSize 20 to set the display size per pageC, edit the current SQL statem

Tags: style color data SP AMP c work AD managementORACLE DBA responsibility is basically equivalent to daily work.0. Database design1. Creation and management of schema Objects (table, index, etc.)2. Management of things, such as concurrency3. SQL Tuning4. User management, Rights Management5. Real-time operational monitoring (with Toad, Statspack), for SQL-related content, tuning------------------------------------------------------------------------

link is not# Sqlnet.ora Network Configuration File:d:\app\user\product\11.2.0\dbhome_3\network\admin\sqlnet.ora# Generated by Oracle configuration tools.# This file was actually generated by NETCA. But if customers choose to# install ' Software only ', this file wont exist and without the native# Authentication, they'll is not being able to connect to the database on NT.Sqlnet. Authentication_services= (NTS)NAMES. Directory_path= (TNSNames, Ezconnect

statistics, calculate */select count (*) from ScheMa.tablename; --Statistics out the total number of rows in the table select DISTINCT (ind_row) from Schema.tablename; --the distinct value of the column in which the index is counted--is then calculated purely by hand?/* Query waits for events */select event, sum (Decode (wait_time, 0, 1, 0)) "Current Wait", Sum (Decode (wai T_time, 0, 0, 1)) "Not currently waiting", COUNT (*) "Total" from v$session_wait GROUP by event ORDER by Count (*) desc;

answers your question, it will make it difficult for you to understand this knowledge point in a short period of time. However, through your own efforts to study it, you will not only gain a deeper understanding of this knowledge point, more importantly, the research process will improve your ability to solve and analyze problems. In general, no matter what you learn, you will not succeed.Of course, beginners often go to the forum to raise questions

Learn Oracle Feelingsjust before contacting Oracle database, I saw a story about Oracle system knowledge from the Internet, called "Sid's House". , reading with interest, did not expect that the story is very good, for beginners to understand the Oracle database system is

Oracle is still quite common, So I studied the Oracle routine and shared it with you here. I hope it will be useful to you. The Oracle system is huge. To learn about it, you must first understand the Oracle framework. Here, we will give a brief introduction to the Oracle arc

Oracle Database beginners opening Preface: For project reasons, I recently started to learn Oracle databases. Oracle is currently one of the most popular databases, with powerful functions and excellent performance. It is relatively difficult to learn. I plan to record my learning process and accumulate it for myself

This is the opening article for Oracle Database beginners. Due to project reasons, I recently started to study Oracle databases. Oracle is currently one of the most popular databases, with powerful functions and excellent performance. It is relatively difficult to learn. I plan to record my learning process and accumul

configuration, Rights Management, database character set, metadata Part IV Network configuration of the database Part V backup and recovery of databases EXP Export and Imp import, cold backup, hot backup, Rman backup and recovery Optimization of Part VI database Acquisition of data, Shared_pool, other memory optimizations, different storage formats, optimization of SQL statements, different access modes of the database 3. Outlook results The expected result, the basic grasp the following conte

configuration, Rights Management, database character set, meta-data The network configuration of the database part V database backup and Recovery EXP Export and imp import, cold backup, hot backup, Rman backup and recovery Part VI of the database optimization data acquisition, Shared_pool, other memory optimization, different storage formats, optimization of SQL statements, different access patterns of the database 3, the expected results of the forecast results, basic knowledge of the followin

computer name was changed, and the listening host name recorded in this configuration file is still the original name, which is no wonder, the oracleorahome90tnslistener service cannot be started. immediately change it to the current computer name. Restart the oracleorahome90tnslistener service again. PL/SQL developer connects to the Oracle database and cannot log on to the server for troubleshooting. Summary: Or