oracle dba books

. 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;