Oracle

Tkprof is an executable tool used to analyze Oracle trace files and generate clearer and more reasonable output results. This article describes the use of Tkprof from the following aspects.1. Set the parameter fileSet the three parameters

  The restoration process of redo logs in Oracle databases based on user-managed backup and recovery is described in detail. A log member in the log group is damaged as follows:   You have selected 6 rows. -- Use 360 to forcibly Delete the

Environment VariablesORACLE_HOME D: \ oracle \ product \ 10.1.0 \ Db_1 \JAVA_HOME D: \ oracle \ product \ 10.1.0 \ Db_1 \ jdkIn the command prompt lineCd % oracle_home % \ Solaris \ j2ee \ isqlplus \ application-deployments \ isqlplus% Java_home

Keywords: nlssort, Pinyin sorting, strokes, radical Before Oracle9i, Chinese characters were sorted by binary encoding. The sorting by pinyin, radical, and stroke function is added to oracle9i. Set the NLS_SORT Value 1. SCHINESE_RADICAL_M is

1. When you assign values to NAME pinyin codes in batches, the names containing single quotation marks will be shelled.Update the NAME and copy it again.UPDATE BFBHDD8.SPSB set name = concat (SBID, 'duoge invincible ') where name like' %'2. The BFv8.

I have been saving this article for a while and it is very practical. I would like to thank the original author: Angel. John.SQL * Loader is a tool used to import external data from Oracle databases. it is similar to the Load tool of DB2, but has

Import data from oracle10g to oracle9i Database   Generally, imp statements cannot be imported. Because the database versions are inconsistent, data can only be imported from a lower version to a later version. Otherwise, data cannot be imported.

Emca-repos create creates an EM Database Emca-repos recreate re-creates an EM Database Emca-repos drop delete an EM Database Emca-config dbcontrol db ConfigurationDatabaseDatabase Control Emca-deconfig dbcontrol db deletes the Database Control

Check whether indexes need to be reconstructed in Oracle SELECT height, /*Height of the B-Tree*/ blocks, /* Blocks in the index segment */ name, /*index name */ lf_rows, /* number of leaf rows in the index */ lf_blks, /* number of leaf

How to start, disable, and restart oracle listeners in linux is a basic task for DBA to start and close oracle listeners, however, the Linux system administrator or programmer sometimes needs to perform some basic DBA operations in the development

[Oracle] SQL * Loader detailed tutorial (1)-Overview SQL * Loader principle SQL * Loader is a tool provided by Oracle for data loading, it is suitable for business analysis databases (data warehouses) and can process flat files in multiple formats.

Load profiles of oracle war This article gives a glimpse of the oracle database workload activity that occurred within the snapshot interval. for example, the load profile below shows that an average transaction generates about 18 K of redo data,

Forced log archiving archive_lag_target forced archiving forced switch in the Data Guard environment, if the oracle database archiving frequency is too low, resulting in Data loss in the event of a fault, we can use the archive_lag_target parameter

Oracle partition, index, test (2) this select operation, each table is 0.1 billion, and the indexes of all three tables are disable. First test compression. SQL code -- sales_data bitmap is not suitable for alter table sales_data1 compress; --- view

ORA-03113/03114 handle if the database does not set the correct OS core variable during installation, it may be okay when installing the database file, when creating a database, the error 03113 is often returned. Another reason for this is that the

According to the test instance of Mr Jonathan Lewis, The TPCC test of Oracle found that the sort function of the cluster exists completely for the tpcc test. Non-equivalent query statements all follow the wrong plan, get the wrong result. This

Oracle variable statement exercise -- Declare A variable and assign it the value declare v_bonus number (8); beginselect id * 6 into v_bonus from A where Id = 5; DBMS_OUTPUT.PUT_LINE ('bonus '| to_char (v_bonus); end; select * from emp -- copy the

Oracle lock mechanism principle (in-depth analysis)The database uses two types of locks: Shared locks and exclusive locks. Only one exclusive lock can be obtained in a table or table, but the shared lock can be obtained multiple times in a single

Table Design avoids the use of reserved Words in the v $ reserved_words record keywords and reserved words. The reserved field content is Y, indicating that the reserved word is used in the identifier. If the reserved keyword is N, it may also

Oracle basic operations, I personally did -- create a tablespace (where TWC. DBF does not need to be manually created.) ----- a tablespace of 20 mb is created, which automatically increases by 5 MB and can be increased without limit, ------ as long