Oracle

Query statement related to oracle tablespace -- merge tablespace size alter tablespace users coalesce -- query data file select file_name, file_id from dba_data_files -- query database object space size select owner, segment_name, sum (bytes) from

Basic Steps for connecting to a remote Oracle database on Mac 1. Open the terminal and enter ssh to see [plain] chenmatoMacBook-Pro :~ Nono $ ssh usage: ssh [-1246 AaCfgKkMNnqsTtVvXxYy] [-B bind_address] [-c cipher_spec] [-D [bind_address:] port]

The Time Model for oracle performance optimization collects statistics on the time model. The time model counts the time spent in the database according to the operation type. The most important time model is the database time-DB time, which

Oracle recycle BIN manages oracle10g. After you select and delete from pl/SQL, a table similar to BIN $ nJ5JuP9cQmqPaArFei384g ==$ 0 is displayed. 1. view the recycle bin select * from user_recyclebin; 2. Clear the recycle bin purge recyclebin; 3.

Remember how to use the oracle sqlplus logon command. 1, { [/] [@ ] |/} [AS {SYSDBA | SYSOPER | SYSASM}] [EDITION = value] specifies the database account user name, the connection identifier of the password and the database connection. If there is

Oracle archive Mode 1. Check whether archive log list is archived; 2. Enable archive mode shutdown immediate; startup mount; alter database archivelog; alter database open; archive log list; ----- confirm whether archive is enabled 3. The number of

Comparison between LOGMNR mining logs and DUMP logs many people know that LOGMNR is used to analyze logs, but few people use DUMP to analyze logs. This is because the information analyzed by LOGMNR is easy to read and understand. but sometimes we

Run DBCA. NETCA reports Xlib: connection to ": 0.0" refused by server error troubleshooting fault symptom: Fault Analysis: From the fault symptom, it is caused by xhost problem, this error usually occurs when you remotely execute the pop-up window.

Sqlldr Load file, ORA-01722: invalid number solve dos2unix file: convert file into unix mode (internal for text) Case: csv file sqlldr. control File load datainto table totofields terminated by ',' (BALL_No, MAIN_BALL_FREQUENCY,

Database Learning (6) -- basic query operations database Learning (5) -- create and update a data table 2 http://www.bkjia.com/database/201305/207493.html In database operations, a developer or user needs to retrieve information in a data table to

Import and export of a single data table in oracle 10 GB 1. Export tool exp is an executable file in the bin folder under the oracle root directory. The specific directory is/ORACLE_HOME/BIN/exp. This tool can be used to export tables in the

Common Oracle exception types: exception description CURSOR_ALREADY_OPEN tries to "OPEN" an opened cursor DUP_VAL_ON_INDEX tries to insert a duplicate value INVALID_CURSOR to "UNIQUE" and tries to operate on the closed cursor INVALID_NUMBER in the

Count the number of tables in the system and query the field information of all tables -- count the number of tables in the system: -- table description field: -- required field: Name, Code, Commente select lower (. TABLE_NAME) | '-' | B. comments,

The Oracle audit technique is used to track the DML action of the oracle background database create or replace package when is procedure pro_monitor_drop_policy (object_schema in varchar2); procedure when (object_schema in varchar2); procedure when;

Reasons for slow query speed in Database Analysis: 1. No index or no index is used (this is the most common problem of slow query and is a defect in programming) 2. Low I/O throughput, resulting in a bottleneck effect. 3. the query is not optimized

Oracle has a very practical way of implementing summary reports. In the financial system or other report statistics function, I want to have a lot of cases similar to the following report. With the grouping_id function, it will be easy to implement,

[Oracle] Data Guard-Create physical Standby experiment environment Primary: Host: jabdw1241SID: O01DMS0DB_UNIQUE_NAME: O01DMS0Standby: Host: jabdw1242SID: O01DMS0DB_UNIQUE_NAME: O01DMS0DR 1. primary configuration and operations 1) confirm that

Oracle deadlock and database connection problems-query the information of the database lock table select do. object_name, t2.username, t2.sid, t2.serial #, t2.logon _ time, t2.MACHINE, t2.state, t2.STATUSfrom v $ locked_object t1, v $ session t2,

How to recycle and drop the space of a table? Q: oracle will not recycle the data blocks occupied by dropping a table, isn't the data that has been deleted logically backed up by RMAN in vain? Is there any way to recycle the space occupied by the

All running concurrent requests and current Request status on an EBS Single Instance [SQL] --- summary of all concurrent requests running on an instance and their current status and waiting status select w. seconds_in_wait "Secondswait", w. event