how to run sql script in linux in oracle

', CS ' execution time (seconds) ' From (select Sql_text, elapsed_time/1000000 C_t,executions,ceil (executions/(elapsed_time/1000000)) Cs,buffer_gets, Rank () Over (order by buffer_gets Desc) top_mem From V$sqlarea) where Top_mem --View the Lock table statement Select C.sid, c.serial#, D.name, B.object_name, C.username, C.program, C.osuser From Gv$locked_object A, all_objects B, Gv$session C, audit_actions D where a.object_id = b.object_id and a.inst_id = c.inst_id (+) and a.session_id = C.sid

The author of the article gave great help to elder withered flourish, in order to express my gratitude.This applies to the Oracle DB version number, Oracle 10g, or later.It is important to say that this view is one of the AWRSQRPT reports is not in. is the filter_predicates column.SELECT Plan_hash_value,To_char (Rawtohex (child_address)), To_number (child_number), ID, Lpad (", DEPTH) | | Operation operation

For the traditional large-scale software products using relational database, the continuous development and maintenance of the background database can produce a large number of script files, how to make versioning more convenient for these script files, and how to quickly manage the permissions between the teams. The level of integration between the different database products and the corresponding client m

When the database is used for a period of time, sometimes the table does not have enough space. Generally, the user's quota is full, or the table space and disk space are full. In most cases, the tablespace is full. If you often view the alarm logs of the database (log location $ find/u01-INAME "alert *. log") and OEM information, it is easy to find warning or error messages. However, most of our projects do not have such a condition. We can only look at it in PL/

SQL statement: /* Formatted on 14:51:13 (qp5 v5.185.11230.41888) */select D. tablespace_name, space | 'M' "sum_space (m)", blocks "sum_blocks", space-nvl (free_space, 0) | 'M' "used_space (m )", round (1-nvl (free_space, 0)/space) * 100, 2) | '%' "used_rate (% )", free_space | 'M' "free_space (m)" from (select tablespace_name, round (sum (bytes)/(1024*1024), 2) space, sum (blocks) blocks from dba_data_files group by tablespace_name) d, (select tables

Method 1: You must use the PL/SQL Dev tool.1. Open PL/SQL Dev and select the table to be exported. Right-click the table and select export data from the pop-up menu, as shown in ).2. After you click Export data, the export settings window appears on the right, as shown in:Under the window, select the SQL inserts tab and set the export conditions.3. Click the expo

Basically, the syntax used is as follows:A. Obtain the syntax for creating a single table and an indexSet heading off;Set echo off;Set pages 999;Set long 90000;Spool Dept. SQLSelect dbms_metadata.get_ddl ('table', 'dept', 'Scott ') from dual;Select dbms_metadata.get_ddl ('index', 'dept _ idx', 'Scott ') from dual;Spool off;B. obtain all the table creation and index creation syntaxes in a schema. Take Scott as an example:Set pagesize 0Sets long 90000Set feedback offSet echo offSpool scott_schema.

In many cases of development, for convenience or commonality of consideration, we first consider the SQL Server database for development, but sometimes the customer's production environment is Oracle or other database, then we need to transform the corresponding data structure and data script to the corresponding database, Data structure in general, the syntax fo

Previously obtained Oracle database backups are typically DMP files, creating tablespaces and users directly using IMP or IMPDP import.This time I encountered a special situation, the other side of the data provided to me is the use of Sqlplus exported SQL script file, is exported from the Linux system, because it is difficult to let the other side to provide dat

Oracle SQL Tuning Health Check ScriptWe focus on the performance of database system, the main task of database tuning is to optimize SQL. Good data architecture design, with application system middleware and writing a beautiful SQL, is the future of the system on-line no fatal performance problems of the strong guarant

Inside the Sql_plus execution: sql> @full_path/test.sql; Example:sql>@d:/test.sql;No commit required; Generally in the Test.sql inside the last add a commit;However, it is important to note that ";" must be added to each statement in the Test.sql file to represent the execution of a statement.Common operations:The [email protected] command invokes the current directory, or specifies a full path, or a script

Tags: background database management tool Oracle ClientFor the traditional large-scale software products using relational database, the continuous development and maintenance of the background database can produce a large number of script files, how to make versioning more convenient for these script files, and how to quickly manage the permissions between the te