oracle pin table in memory 11g

Oracle Database 11g performance optimization strategy-optimizing Table PerformanceIntroduction 1-1 Create a database with optimal performance problem description www.2cto.com you realize that when you first create a database, there are some attributes (if enabled) it will have a long-term impact on the performance and availability of tables in the database. Speci

SQL: Oracle 11g create table, function, trigger, sequence, 11 gtrigger -- Place directory drop table BookPlaceList; create table BookPlaceList (BookPlaceID int primary key, -- NUMBERBookPlaceName nvarchar2 (500) not null, BookPlaceCode varchar (100) null, -- location paramet

: \ createsql. SQL. The content is as follows: -----------Set heading off;Set echo off;Set feedback off;Set termout on;Spool C: \ allocate. SQL;Select 'alter table' | table_name | 'allocate extent; 'from user_tables where num_rows = 0;Spool off;----------- Run C: \ createsql. SQL. The command is as follows:-----------SQL> @ C: \ createsql. SQL;----------- After execution, the C: \ allocate. SQL file is obtained. Open the file and you will see that you

1. Open pl_ SQL and log on to the user who needs to export the database Ii. Create an SQL copy Select 'alter table' | table_name | 'allocate extent; 'from user_tables where num_rows = 0 The query result is as follows: 3. Create an SQL window and paste all the information copied and queried in the blank space. For example: 4. After the execution is successful, start-run on the Oracle

In the project database design process, because the data volume of a single table is very large, you need to partition the table. Because the data in the table is a historical transaction, it is partitioned by month to improve query and management. Since we didn't know much about table partitions before, we checked a

L 134217728 134217728 134217728 0 0 STATIC 67108864DEFAULT buffer Cache 2.2817E+10 2.2817E+10 2.2817E+10 0 0 INITIALIZING 67108864KEEP Buffer cache 0 0 0 0 0 STATIC 67108864RECYCLE buffer cache 0 0 0 0 0 STATIC 67108864DEFAULT 2K buffer Cache 0 0 0 0 0 STATIC 67108864DEFAULT 4K Buffer Cache 0 0 0 0 0 STATIC 67108864DEFAULT 8K Buffer Cache 0 0 0 0 0 STATIC 671

Tags: query generates col def resolve insert workaround code NoteThere is a new feature in ORACLE 11G that does not allocate segment when the table has no data to save space. Workaround: 1) Insert a row, and then rollback will produce segment. The method is to insert data into the empty table and then delete it, result

Oracle's 11GR2 version does not make much of a change to the data pump, mainly by adding support for the original version parameters and removing some small restrictions. This article describes the data pump on the table to improve the way to export. In 11gr1 and previous releases, there was a limit to the export of table schemas, all exported tables must be in the same schema, which made it inconvenient

Tags: Oracle systemOracle 11g Settings Memory Auto-management:ALTER SYSTEM SET memory_target = 1024M scope=spfile;ALTER SYSTEM SET memory_max_target = 1500M scope=spfile;ALTER SYSTEM SET sga_target = 0 scope=spfile;ALTER SYSTEM SET sga_max_size=800m scope=spfile;ALTER SYSTEM SET pga_aggregate_target = 0 scope=spfile;Alter system set PRE_PAGE_SGA=FALSE Scope=spfil

Tags: memory parameter get start ORA 2.0 mini LTE SYSFollow the steps below to adjust the memory 1. Sqlplus/nolog2. Conn/as SYSDBA 3. Show parameter target 4. Show Parameter SGAAlter system set SGA_MAX_SIZE=512M Scope=spfile;Alter system set SGA_TARGET=512M Scope=spfile; 5. Show parameter memoryalter system Set Memory_target = 2048M scope=spfile;Alter system set Memory_max_target =2048m scope=spfile; 6. Shu

In oracle11g, when each table is initially created, the default is to not allocate extents to this object.When the data is first inserted, the corresponding extents are assigned.The corresponding control parameter is Deferred_segment_creation=trueIf you want to maintain a property that is consistent with the lower version, you can set this parameter value to FlaseAlter system set DEFERRED_SEGMENT_CREATION=FALSE Scope=both;In the subsequent creation of

Some databases are in use because some operations will lead to a temporary table space is too large, due to the working mechanism of temporary table space, the temporary table space will not be released after the job is completed.This problem can be solved by rebuilding the temporal tablespace, but the operation is a bit cumbersome.In the operation, it is found t

ORACLE11G will encounter such a problem, with the EXP whole library export, you will encounter such a problem, the empty table in the library can not be exportedSELECT * from All_all_tables AA where aa.owner= ' user name uppercase '---View all tables under UserSELECT * from All_tables t where T.owner = ' User name uppercase ' and t.num_rows = 0;--View all empty tables under UserOK, here's the processing method script:Run in the command window:Set head

Oracle's 11GR2 version does not make much of a change to the data pump, mainly by adding support for the original version parameters and removing some small restrictions. This article introduces the improvement of data pump to the table fuzzy matching export. Oracle's data pump supports fuzzy matching of table names, such as: bash-3.00$ EXPDP yangtk/yangtk directory=d_output DUMPFILE=T_TEST.DP tables=t%

/bp_oracle Directory=dump_dir dumpfile=bp_oracle.dmp version=10.2.0.1.0--Remove TablespaceDrop tablespace bp_oracle including CONTENTS and datafiles;--delete the user, and execute the statement carefully, the Cascade deletes all objects under that user.Drop user bp_oracle cascade;--Modify User passwordAlter user bp_oracle identified by bp_oracle; --Export database with no versionEXPDP bp_oracle/bp_oracle schemas=bp_oracle dumpfile=bp_oracle20120221.dmp directory=dump_dir JOB_NAME=full--Export

PL/SQL table (Oracle memory table) --- table () function usage = ================================ Author: zhouwf0726 (http://zhouwf0726.itpub.net) Posted: Category: Oracle Development Source: http://zhouwf0726.itpub.net/post/9689/