Oracle

The official statement of the db_create_file_dest parameter is to enable management based on Oracle-managed files (OMF. OMF Management of Redo, control, temp, undo, and data files My understanding is that it is neither safe nor nice to let Oracle

Although the configuration of physica standby in Oracle's DG solution is relatively simple, it is a little complicated. In the end, DBPhyiscal standby constantly applies redo logs to synchronize with primary.. The so-called advantage is that

Database sorting rules Read the Oracle online document carefully and summarize the ordering rules. The significance of sorting rules is to display meaningful data, orderly, and meaningful. Sorting rules are essentially the requirements of

1. ASM Disk Type Select 1: bare device/dev/raw/, which requires raw service support.Select 2: asmlib management. You need to install the RPM package of asmlib in Linux and create the vol that can be recognized by ASM. 2. ASM disk management

ArticleDirectory Step 1: Step 2: Step 3: Step 4: Step 1: Step 2: Step 3: In ideal cases, all are OK. If any problem occurs, handle the problem one by one. Close sequence: [other nodes]-> [first node]   Operation: Step

This article from: http://hi.baidu.com/plummoon/blog/item/5c3fe9dd025459e376c63839.html       In Windows Server 2008 IIS application process pool configuration-General-enable 32-bit ApplicationProgram-True: The following exception is returned:

Use the scheduled task function provided by the operating system to regularly run the exp command every day to export and compress the specified Oracle database, and then delete the expired compressed export files as needed, to achieve automatic

Oracle provides two authorization Methods: system permission authorization and object permission authorization. For system permission authorization, you must use the DBA permission to log on and then perform authorization. For the following side

1. generate an AWR report Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/--> [Ractest @ Sun880 - 1   / U01 / App / Oracle / Orahome / RDBMS / Admin] $ cd $ ORACLE_HOME / RDBMS /

To_date () and 24-hour notation and display of MM minutes: I. Many JavaProgramThe clerk may directly convert the format in the format of "yyyy-mm-dd hh: mm: SS", but an error occurs in Oracle: "ora 01810 formatCodeAppears twice ". For example:

  1. to_char (sysdate, 'q') quarter 2. to_char (sysdate, 'yyyy') year3. to_char (sysdate, 'mm') month4. to_char (sysdate, 'dd ')5. The day of the week in to_char (sysdate, 'D ')6. to_char (sysdate, 'day') day of the week7. The day of the year in

There are two methods to retrieve the Sys password: 1. Verify with windows (check the oraclebasedir/ora92/Network/admin/sqlnet. ora File Sqlnet. authentication_services = (CNT) this line is not commented), and then typed SQL> connect

1. query table Statistics select. table_name, . num_rows, . blocks, . empty_blocks, . avg_space, . chain_cnt, . avg_row_len, . global_stats, . user_stats, . sample_size, to_char (. last_analyzed, 'yyyy-MM-DD hh24: MI: ss') from dba_tables A

After Oracle Developer tool for Visual Studio 1110621 is installed, it is found that the PL/SQL developer 7.0.x TNS list disappears and the OCI DLL cannot be found during forced logon. The solution is as follows: 1. Modify the connection settings

Ado. net Connect to SQL ServerSQL Server. NET Framework data provisionProgramSupports connection string format similar to ole db (ADO) connection string format.Using (sqlconnection connection = new sqlconnection (connectionstring )){Connection.

Encountered a similar problem: Oracle 11gr2. 0.1 after the RAC grid cluster resource {crs_start listener Resource Name | svrctl start listener} is started, a listener cannot be started, the manual registration of {alter system register} of the DB

-- Create a temporary table to obtain the value of the Long TYPE: high_value Drop Table Syscom_tab_partition_temp purge; Create Table Prm8_user.syscom_tab_partition_temp (table_name Varchar2 ( 30 ), Partition_position Int , Partition_name

  Name Ordinal Value Isdefault Audit_trail 1 DB 2 OS 3 None 4 True 5 False 6

I. Processes (6-OS limit) 40 Determines the number of processes that can be opened by all operating systems on Windows for parallel connection to Oracle (this process should be the number of all sub-processes opened by the Oracle instance process

Dynamic listening: After the Oracle listener runs, the Oracle instance dynamically listens to the listener when it is open.ProgramRegister service_names and instance_name. The default instance_name is:Db_name The default value of service_names is: