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.

  -- SQL statements with many executions Select SQL _text, executions from ( Select SQL _text, executions from v $ sqlarea order by executions desc ) Where rownum -- Read SQL statements with multiple hard disks Select SQL _text, disk_reads from

1. Obtain the values of 6th to 10th records in the table.1.1 Method 1: Use the minus statementAssume that the ddl statement is as follows:The following is a reference clip:Create table t (ID VARCHAR2 (4) primary key, value int)The first method is to

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

When Oracle starts, it needs to read the initialization parameter fileText File Format: PFILE$ ORACLE_HOME/dbs directoryCreate PFILEDBCAManually createdCp init. ora $ ORACLE_HOME/dbs/initSID. oraModify initSID. oraAfter dbca creates a database,

Scenario: When marine encounters A problem, it is required to move A user's table from tablespace A to tablespace B. The number of user tables is more than 1000.Analysis 1: it can be determined that the DDL statement alter table table_name remove

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;

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

Q: 1 Examine the structure of the EMPLOYEETechnorati label: ocp 007 database oracleS table:EMPLOYEE_ID NUMBER Primary KeyFIRST_NAME VARCHAR2 (25)LAST_NAME VARCHAR2 (25)Which three statements insert a row into the table? (Choose three .)A. insert

Select... The syntax of the For Update statement is the same as that of the select statement, but the for update [NOWAIT] clause is added after the select statement. This statement is used to lock specific rows (if a where clause exists, it is the

[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

Basic knowledge about block address 1. block address (ondisk rba is voided after 9.2) 1.uba= Undofile BA 1 BA = dbfile file number, block number, row number rdba = tablespace Relative Database BA 2 BA = logfile serial number, logfile block number,

Oracle dbguard configuration listening insufficient privileges from the library after starting to nomount, through listening how can not log on, error ORA-01031: insufficient privileges Enter user-name: after searching for information from multiple

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

The use and management of Oracle partition tables use very large tables, such as demographic statistics tables. If a table is large, the query speed is reduced and the management difficulty is increased. In the event of disk damage, data in the

Use the Oracle regular expression to select the sequence number in data entries. Abstract: Use the Oracle regular expression to select the sequence number in data entries for the latest project. In the seven-digit string, select the sequence number

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;

Querying oracle table field information can be called metadata. Someone asked how to export the table field information today. To tell the truth, I will not use plsql develper to export the table structure, as shown in: When writing a Database

Common simple functions in oracle (ONE)In oracle, functions are divided into multiline functions and single-line functions. Single-line functions can be directly referenced in plsql blocks, but multiline functions can only be referenced in Embedded