oracle dba commands

. 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

patch to prevent memory leaks.3. How to find the session of Oracle with a special resource for the system and the statements it executes.Hp-unix can be used with GLANCE,TOP,IBM Aix topas, and PS commands are also available. By using these programs we can find the process numbers of these processes that are particularly large with system resources, and we can find out which SQL the PID is executing by using

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;

Notes on common Oracle commands and common oracle commands Login without a password: sys as sysdba View all current databases: select */name from v $ database; View the current database connection user: show user View All Tables of the current data: select table_name from all_tables; View Structure: for ex

Summary of Common commands for executing scripts in Oracle databases and common commands in oracle 1. Execute an SQL script file Copy codeThe Code is as follows:Sqlplus user/pass @ servicename Or Copy codeThe Code is as follows:SQL> start file_names Or Copy codeThe Code is as follows:SQL> @ file_name We can save multi

Summary of Common commands used to execute scripts in oracle databases and common commands used in oracle 1. Execute an SQL script file The Code is as follows:Sqlplus user/pass @ servicename OrSQL> start file_namesOrSQL> @ file_name We can save multiple SQL statements in a text file, so that when we want to execute all

Common Oracle commands for creating users, tablespaces, and role commandsThe following articles mainly introduce how to view the table structure in common Oracle commands. If you are interested in the actual operating solution of how to view the table structure in common Oracle