Oracle

In oralce, query the lock table records and unlock the tables that are locked first. select B. owner, B. object_name,. session_id,. locked_modefrom v $ locked_object a, dba_objects bwhere B. object_id =. object_id; query the sid and serial of the

Oracle over partition by select * from test data: a B c 1 1 1 1 2 2 3 3 2 5 3 4 6 --- add the corresponding C column values with the same B column values to the total select a, B, c, SUM (C) OVER (partition by B) c_Sumfrom test a B C C_SUM 1 1 1 1 1

Oracle sets SGA Java code SQL> show parameter sga; name type value comment ----------- comment lock_sga boolean FALSE pre_page_sga boolean FALSE sga_max_size big integer 512 M sga_target big integer 200 m SQL> alter system set sga_max_size = 200 M

Oracle Operation Command --- 1. create a database instance CMD> oradim.exe-new-sid TESTCMD> type initTEST. ora db_name = TESTcmd> sqlplus "/as sysdba" -- 2. choose SQLPLUSsql> startup nomount pfile = initTEST. ora (load the data instance and specify

[Oracle] the difference between a stored Procedure (Procedure) and a (custom) Function (Function) the Stored Procedure (custom) Function needs to be executed independently, and there is not necessarily a return value; functions can be called

ORA-00600: internal error code, arguments: [4194] solution found that the alarm log contains the ORA-00600: internal error code, arguments: [4194] error. This error indicates that the undo tablespace has the following solution: SQL> create undo

To modify the linux host name of Oracle, the original host name is centos, change to test 1, modify vim/etc/hosts vim/etc/sysconfig/network service network restart in linux, and modify the Oracle configuration. At this time, the Oracle instance is

Comparative analysis on the effects of no index and no index used in OracleIn Oracle, the comparison and analysis of the effects of not using indexes and using indexes is unnecessary.1. Create a test database and then insert data in batches:SQL>

Common Oracle database query 1. view the SQL code of all users in the current database select username from dba_users; 2. display the SQL code of the current user show user; 3. view the SQL code of all tables in the current database select * from

The oracle process and function process and function process and function are both stored in the database in the form of compilation. The function can have multiple parameters and return values without any parameters. The process has zero or

Example of the change in the initial value when the parameter compress = y in EXP causes imp: Import/Export version, platform: 11.2, windows import/export version, platform: 10.2, linux 1. create a test table: [SQL] SQL> conn scott/xyc is connected.

How to format the output set linesize 180 set pages 999 set long 90000 of the dbms_metadata.get_ddl stored procedure -- set the line feed col a for a200 wrapped word -- select dbms_metadata.get_ddl ('index ', 'I _ dj_nsxx_djjg_dm', 'hx _ dj') a from

The left and right connections in oracle saves the complex join statements (left join and right join) in SQL server, which are represented by a "(+. In the following experiment, query 1 and query 2 are equivalent, and query 3 and query 4 are

Oracle GoldenGate series: Extract process Recovery principles BR applicable to Extract processes (only applicable to Oracle databases) use the BR parameter to control the Bounded Recovery (BR) function of GoldenGate. The Bounded Recovery function

Export excel create or replace directory MY_DIR as 'C:/abc' in oracle; create or replace procedure export_data_out_excel/** use utl_file to write the data to the text file pfile_name: output file name. Pexport_ SQL: The executed SQL statement,

Oracle Database SQL statement exercises-preparationPrefaceI have been learning Oracle SQL statements for some time. I have always determined that the true learning is:It can be used in practice. Otherwise, it can only be explained that it is simple

Oracle tablespace (II)-view tablespace usage SQL code SELECT UPPER (F. TABLESPACE_NAME) "tablespace name", D. TOT_GROOTTE_MB "tablespace size (M)", D. TOT_GROOTTE_MB-F. TOTAL_BYTES "used space (M)", TO_CHAR (ROUND (D. TOT_GROOTTE_MB-F.

Background of a temporary tablespace full problem: in our company, we have a dedicated demonstration environment. During pre-sales, we can use the above system for demonstration. Problem: today, when our manager demonstrated to the customer, the

Oracle deletes, adds, and modifies multiple fields to create a table: SQL> create Table t (a number); table created SQL> desc t; name Type Nullable Default Comments ---- ------ -------- ------- -------- add multiple fields SQL> alter table t add (B

Use of some built-in methods in oracle 1. query a tablespace in a database: Use select * from DBA_INDEXES or DBA_OBJECTS 2. query database connections: select count (*) from V $ SESSION 3. query the maximum number of connections in the database: