Oracle

Usually used less, save it and view it later. Select * from v $ sqlarea t where t. PARSING_SCHEMA_NAME in ('username') order by t. LAST_ACTIVE_TIME descThe username must be capitalized.Select * from v $ sqlarea t order by t. LAST_ACTIVE_TIME

  1. View tablespaces Select tablespace_name, file_name from dba_data_files; 2. Create a statspack tablespace Create tablespace perfstat datafile 'd: \ oracle \ oradata \ perfstat. dbf' size 500 m The tablespace should be as big as possible. 3.

What should I do if there are unnecessary services in oracle service items? The following describes how to delete a service that is not used in oracle service items. We hope this will help you learn about oracle service items. Management -->

Purpose:The merge command can be used to modify or insert data from one table to another. The insert or modify operation depends on the conditions of the on clause. This statement can be executed in two steps in the same statement, which can reduce

Oracle has completed its acquisition of SUN and released an integrated plan for Sun's businesses in January 27. In general, Oracle should become the vendor of integrated software and hardware solutions. The following describes the Java-related

Basic StructureCREATE OR REPLACEPROCEDURE(Parameter 1 in number,Parameter 2 IN NUMBER) ISVariable 1 INTEGER: = 0;Variable 2 DATE;BEGINEND stored procedure name --- Query data and return a listDrop procedure mrr. get_risk_assessment_by_status;Create

To write an SQL statement today, You need to retrieve the maximum and minimum values of multiple field columns.The originally thought method is quite troublesome. We need to extract max (one), max (two), and max (three) respectively and put them in

1. First define a method to return the array typeCreate or replace type my_table_type is table of varchar2 (20 ); Create or replace function funcReturn my_table_typeIsI my_table_type: = my_table_type ();BeginSelect name bulk collect into I from emps;

The Bulk Collect feature is introduced in Oracle8i for the first time. This feature allows you to use batch queries in PL/SQL. Batch queries can significantly improve query efficiency in some cases. Now, we will perform some simple tests and

How to query Oracle character setsMany people have encountered data import failures due to different character sets. This involves three character sets: one is the character set on the El server side, the other is the character set on the oracle

Before installation, you must first Enable tcp on port 1521. Linux partition scheme (all file systems are ext3 ):The 9 GB disk on the first controller (/dev/sda) contains the following partitions for storing all Linux and Oracle software:-100

1. exp/imp is equivalent to restoration and backup of the oracle database.2. exp exports data to the local dmp file, and imp imports the local file into the database3. exp/impcan be executed in cmd.exeI. Data export:1. Export the database EDWTEST

We all know that data blocks are the most basic read/write units in oracle, but the data you need is not the whole block, but the rows or columns in the block. when a user issues an SQL statement, the statement is parsed and executed, and the data

An error is reported when deleting a temporary table in plsql:  Summary:Oracle's temporary table design principle is that temporary tables are bound with sessions. the data in the table and related things are bound to the same session. The data

[Oracle] exploring partition-partition pruning refers to partition table or partition index, the optimizer can automatically extract the partitions to be scanned FROM the FROM and WHERE statements based on the partition key. This avoids full table

Oracle Database Export and re-import 1. Export Database 1. Completely export the database TEST, username scott password tiger, and export it to D: \ testDB. in dmp: [plain] exp scott/tiger @ TEST file = d: \ testDB. dmp full = y 2. Export the table

Solution to oracle archive log exceeding the recovery flash_recovery_area limit I. Problem description: The system reports the following error: ORA-16038: Unable to archive ORA-19809: ORA-00312: Online log 2, Problem Analysis: oracle generates a

Restore redo after oracle closes normally [Oracle @ oracle-one RHYS] $ ls-ltrtotal 4898536-rw-r -----. 1 oracle oinstall 52429312 Aug 27 redo02.log-rw-r -----. 1 oracle oinstall 52429312 Aug 27 redo01.log-rw-r -----. 1 oracle oinstall 5251072 Aug 27

Analog ORA-01555 SQL> create undo tablespace undo_temp1 datafile 'd: \ oracle \ product \ 10.2.0 \ oradata \ ordb10 \ undo_temp1.dbf 'size 2 M autoextend OFF; tablespace created. SQL> alter system set undo_tablespace = 'undo _ temp1' scope = both;

SQL _trace causes Database ErrorOracle9i uses the SQL Trace facility to collect performance data on individual SQL statements. the information generated by SQL Trace is stored in SQL trace files. SQL Performance Analyzer consumes the following