Oracle

The command we met todayIPCsShow SGASelect Component,granule_size from V$sga_dynamic_components;Alter system set shared_pool_size=64m;-->64m can be changed to change the size of the shared pool.The SGA mainly includes the following:Shared

Today's knowledge:What Oracle Server includes: Oracle instance and Oracle databaseWhat Oracle instance includes: SGA and background processPlace the following structures in order of hierarchy beginning with database.A tablespacesb ExtentC segmentD

We often see the following information in trace files produced in 10046. Represents the 8 blocks that the system begins when a block is waiting for a hash to read a file number. wait #6: nam= ' db file scattered read ' ELA = 438472 file#=6 block#=264

7th Chapter OraclePioneer of pure software companyMicrosoft 1975Oracle 1977Company Development1977 SDL1979 RSI Relational software company1982 OracleThe world's second largest software companyIBM took advantage of IBM's non-emphasis on relational

This problem is I just stepped into the job feel the most pit of a problem, find a lot of methods, also asked many people, but still can not solve, accidentally back to the new world ....The specific problem description is this:I can read the

the difference between pfile and SPFilePrior to Pfile:oracle 9i, Oracle has been using Pfile to store initialization parameters, which are text files that can be modified at the operating system level. You can use Pfile file to start a database when

In 11g, the default self-collected statistics for the time is 10 o'clock (Monday to Friday, 4 hours), 6 a.m. (Saturday, Sunday, 20 hours), as seen below:Select A.window_name, a.repeat_interval,a.duration from Dba_scheduler_windows A,

1,case usageselect case when T.flag = 0 ' from xtxmxx T 2,decode usage-- if FLAG equals 1, it is converted to USERID, if 0, then to ORGID, the other 2SELECT DECODE (T.flag,1,t.userid,0,t.orgid,from Xtxmxx T; 3, create sequence-- Create

Once you've developed a feature that requires importing tens of thousands of of data from others,Data in a *.sql file, about 80,000 dataINSERT INTO testtable (id,name) VALUES (1, ' 1 ') -----more than 80,000As usual, all insert into statements are

1. Case-When expressions have two forms--Simple Case function Case Sex When ' 1 ' Then ' men ' When ' 2 ' then ' women ' Else ' other ' END --case search function CaseWhen sex = ' 1 ' Then ' man ' When sex = ' 2 ' Then ' women ' Else ' other

Basic commandsSqlplus/as sysdba--Command line open Oracle (logged in as DBA)Drop User myusers cascade;--delete users (Cascade)Create user myusers identified by 123;--creating users (user name: Myusers. Password: 123)Grant Connect,resource to myusers;

How to obtain oracledbid1. query v $ database to obtainBecause DBID has records in the control file and data file, you can query the v $ database view if you can mount the database.SQL> alter database mount;Database altered.SQL> select dbid from v $

ORA-00942: a low-level error does not exist in a table or view ORA-00942: a low-level error does not exist in a table or view Run the query statement and report a ORA-00942 Error After checking, the user who does not specify the table is found.

ORA-00911: Invalid character Error ORA-00911: Invalid character error -- caused by a minor error in the compilation environment Implementation of a function script statement, compile, there is a ORA-00911 error, at that time some doubts, before

Oracle alter tablespace 1. Find out which tables have incorrect tablespaces. select * from dba_tables where tablespace_name='TDB';2. Move the tablespace in TDB to TDB2009. Syntax: alter table table_name move tablespace tablespace_name; alter table

Oracle11gR2 database flashback function -- Preventing human logic errors Oracle 11gR2 database crash-Prevention of human logic errors 1. What is the role of Flashback on the dji erp system? For some human operation errors, such as batch data

How to initialize Data Synchronization from OracleGoldenGate to non-oracledb SQL Server is used as an example for non-oracle databases: My ideasA: oracle db production B: oracle db intermediate machine C: sqlserver db target end A-> B-> C note:

Oracle column merge In many cases, we need to use oracle column merge. oracle provides some methods to merge multiple rows of data in a column into one row. 1. Use WMSYS. WM_CONCAT before 10 GBWmsys. wm_concat separates the field values.Select id,

Modify the column data type. Author: David _zhang @ sh: [mark the article in hyperlink form when reprinting] Link: http://www.cnblogs.com/david-zhang-index/archive/2012/04/10/2441015.html Field operations Procedure Update field

DRP Oracle_11g Database Installation I don't know if you are confused like this or that when installing the Oracle database. Today, I will take a look at the installation process of the Oracle database as a summary to facilitate future study. First,