Oracle

Oracle 11.1.0.6 for linux X86 64 SILENT Installation First, check the system hardware:   Code: [Root @ enterprice64 ~] # Grep MemTotal/proc/meminfo MemTotal: 8178836 kB [Root @ enterprice64 ~] # Grep SwapTotal/proc/meminfo SwapTotal: 8385888

Redhat Linux AS4 install Oracle 10g (10.2)   1. Hardware requirements (1) memory> 1024 MB Memory swap Partition > 1024 MB 2 times memory > 8192 MB 0.75 times memory Display memory commands 2)/tmp> 400 M 3) detection command Memory # Grep

Importing and exporting Oracle Data imp/exp is equivalent to restoring and backing up oracle data. The exp command can export data from the remote database server to the local dmp file, and the imp command can import the dmp file from the local to

Custom Aggregate functionsIntroduction to custom aggregate function InterfacesOracle provides many predefined Aggregate functions, such as Max (), Sum (), AVG (), however, these predefined Aggregate functions are basically applicable to scalar data.

1. Preparation Process   1.1 check and set database roles First, check whether there are CTXSYS users and CTXAPP roles in the database. If you do not have this user or role, it means that the intermedia function is not installed when your database

Recently, my personal requirement is to store files in the database for convenient backup. Therefore, I wrote this class, which is not completely original. I have reference to some online materials, however, through your own tests, you can fully

Oracle used raw via lvm to handle raw usage issues for a production database of another company in the morning. On-site staff said they would use the new lvm space for oracle, and lv had already been made, the ing is also bound, but raw is not

Install ORACLE 11g R2 on CentOS 5.5. Tutorial 1: prerequisites 1. Prepare CentOS. First, what is the most important: partition is the most important. Obviously, the larger the partition, the better, especially the larger the SWAP space, at least 2

Common Oracle performance-related scripts (SQL) are used in the absence of visual tools to monitor database performance, the following provides several scripts related to Oracle performance for your reference. The following scripts are successfully

Simulated recover Oracle restoration test for accidental deletion of dataifle 1: 1. hot Backup tablespace users. 2. a) scott login, B) create table tt (seq number); c) declare I number; begin for I in 1 .. 20 loop insert into tt values (I); end loop;

Concatenate multiple rows of records in the same column in Oracle into a string [SQL] -- raw data -- a 111 -- B 222 -- a 333 -- a 444 -- B 555 -- final result -- a 111*333*444 SELECT L4.L _ TIME, MAX (SUBSTR (L4. group CONTENT, 2) final field value

Oracle Data Guard role conversion experiment environment: OEL + Oracle11.2.0.3 + physical standby as we all know, Data Guard is already the mainstream disaster tolerance solution of today's standards. Due to the strong adaptability of log

Oracle lists all the table names. The column name takes one day. there may be better methods. test environment: oracle xe 11g 1 shows all table names: select table_name from user_tables; 2 shows all column names: select OWNER, TABLE_NAME,

Oracle-hierarchical statements-tree structure-show root nodes-not show root nodes. the tree structure area_id of the Oracle-level statement is that the common primary key ID corresponds to parent_id .. administrative Division table 1. start with t.

Using Reverse indexes to Improve the Performance of order by desc using reverse indexes (index desc) can greatly improve the performance of SQL statements with order by desc clauses. I. Scenario 1. Table Name: test_t, with a field name: object_id2,

When EBS starts Apache, The following error is reported: 0403-6.1 The specified number is not valid for this command. You are running adopmnctl.sh version 120.6.12010000.3Starting Oracle Process Manager (OPMN) ...adopmnctl.sh: exiting with status 153

Plsql developer Tips 1. remember the Logon Password. For ease of work, PL/SQL Developer needs to remember the username and Password for logging on to Oracle. Set options: Tools> Preferences> Oracle> Logon History> Store With Password, "Store history"

When querying the ORACLE v $ view in the Sh script, you need to add the Escape Character "\" before $ DBA. Some sh scripts are often deployed to log on to the ORACLE database to query the v $ dynamic view to get something practical. automated

Common Oracle problems with removing users and tablespaces (for example, a ORA-01940 cannot delete a solution for a currently connected user) at this time enter the sqlplus command window as an administrator. when you delete a user, the following

The following articles about permanently deleting oracle8 \ 9 \ 10 were modified on the basis of oracle8. The ** part of the front edge is only applicable to oracle8, which is unnecessary for oracle9 \ 10. Jia ?? It is applicable to versions 8, 9,