Oracle

Garbled in fact is the main set of Chinese is the default system language, as long as the set back to English to solve the garbled. To prevent garbled during Oracle installation, it is recommended that you use English as your system language to

Everyone hears this word, must think of save hard disk space. Yes, it is used to do this, but to extend it, it can not only save hard disk space, but also can save bandwidth and memory use (CPU has a little bit of loss because of the need for more

Explore the structure of data file header under LMT table space management and the recording mode of bitmap Central The experiment is divided into two steps: 1.LMT locally managed table space, the structure analysis of data files in ASSM automatic

Select To_char (sysdate, ' yyyy-mm-dd hh24:mi:ss '), To_char (Trunc (sysdate), ' Yyyy-mm-dd Hh24:mi:ss ') from dual T;--sysdate and Trunc (sysdate) are not the same sysdate on the day of zero 0 minutes 0 seconds equals trunc (sysdate) Select Trunc

Configuring Hugepage in Linux can improve Oracle performance and reduce the page exchange of Oracle SGA, similar to the Lagepage in Aix. Why use a large page? The default block size for Linux memory is 4K If the SGA is: 128G Select 128*1024*1024/

1. Table structure Sql> desc v$session_event is the name empty? Type ----------------------------------------- -------- ---------------------------- SID number EVENT VARCHAR2 (64) Total_waits number Total_timeouts number time_waited number

A recent series of operations on XML in Oracle Plsql. Combine the knowledge and reference materials used in the work to organize the following related content: How to generate an XML file: 1, using Dbms_xmlquery and Utl_file built-in package

The following error was reported when executing the script to create the control file: Sql> @/orac/controlfile.sql Sp2-0042:unknown command "datafile"-rest of line ignored. Sp2-0734:unknown command Beginning "'/orac/ora ..."-rest of line ignored.

First look at what columns v$session have Sys@orcl>desc v$session Name Null? Type ----------------------------------------- -------- ---------------------------- Saddr RAW (4) SID number serial# number Audsid number Paddr RAW (4) user#

Fault classification one database suspend failure 1 Death of the database due to archive suspend 2 nit file in the SGA area set too large, resulting in insufficient memory, database and system are dead 3 The database was suspended because the

To view the SIDs and serial# for the current session: Sys@orcl>select sid,serial#,status from V$session where sid=userenv (' Sid '); SID serial# STATUS ---------- ---------- -------- 3 ACTIVE To view the SPID corresponding to the current

Not very clear before the role of encryption role, today looked at some data found that the cryptographic role can be granted to a user with a non-default role, and is enabled only when needed. Some of the more sensitive permissions in the ordinary

Normal table online redefinition is an error in the partitioning table, the range of values exceeds the partition limit size, so what steps do you need to redefine the table online? This example records the processing process: Sales@orcl>exec

Remove CRS 1. Stop resource: Turn off CRS resource: crsctl Stop resources Turn off Crs:crsctl stop CRS 2. Use script: Two nodes root.delete.sh, rootdeinstall.sh 3. Delete Startup items: rm/etc/oracle/* Rm-f/etc/init.d/init.cssd

(1) View library information SELECT * FROM V$version (2) View character set SELECT * from sys.props$ wherename= ' Nls_characterset '; 1. Process View L Database Write process: Oracle 2438 1 0 01:39? 00:00:00 ORA_DBW0_EDWPRD L Log Write process:

Steps: (1) Create script file bak_112.sh, as follows (automatically back up the database by current date): #!/bin/sh export oracle_base=/u01/app/oracle; oracle_home=/u01/app/oracle/product/11.2.0/db_home1; Export Oracle_home oracle_sid=xxx export

When you perform a query operation, the row data is displayed by default in the order in which the row data is inserted, but in practice it is often necessary to sort the data to show more intuitive data, with the ORDER BY clause being used to sort

The rapidly changing database market shows that MySQL chief executive Martin Mickos first called Oracle's product "Crippled Software" (Crippleware), and a few minutes later hailed the company as the best partner of the year. Mickos The Oracle in a

Output query content to text Set echo off pagesize 0 heading off feedback out termout off Spool Test.sql Select COUNT (*) from User_tables; Spool off The above script will output the query content to the Test.sql after it has finished executing

Comparison of some simple commands for Oracle and MySQL Sql> Select To_char (sysdate, ' Yyyy-mm-dd ') from dual; Sql> Select To_char (sysdate, ' Hh24-mi-ss ') from dual; Mysql> Select Date_format (now (), '%y-%m-%d '); Mysql> Select Time_format (