oracle pin table in memory 11g

Tags: performing import database table cat save space No data user 11g featuresThere is a new feature in ORACLE 11G that does not allocate segment when the table has no data to save space.The parameter value is true by default, and segment is assigned when false, whether it

Manual hot-Standby must be in the archive mode, read-only table space can not be hot-spare, temporary table space does not need to prepare.[emailprotected]> archive log list;——开启了归档Database log mode Archive ModeAutomatic archival EnabledArchive destination /u01/app/oracle/product/11.2.0/dbhome_1/dbs/archOldest online log sequence 1Next

Tags: compressThe latest set of production library table space has been alarm over 90%, but the disk hardware resources are not enough, the entire library has reached 26T. The library stores nearly 4 years of data, and business communication that historical data is basically not done, but can not be archived, so think of a compressed table to save table space.As

There 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, resulting in segment. When exporting, you can export empty tables.2) Set D

--Initialize datadrop table test Purge;CREATE TABLE Test as SELECT * from Dba_objects;Delete from test where object_id is null;ALTER TABLE TEST ADD constraint pk_test_object_id primary key (OBJECT_ID);CREATE INDEX ind_t_object_name on test (object_name);--Perform a delete operationdrop table test;Select R.object_name,r

11g new Features _ partitioned tables are automatically created by time (Interval partitioning (MONTH, year) Interval Partitioning (MONTH, year) CREATE TABLE Sales6 ( SALES_ID number, Sales_dt Date ) Partition by range (SALES_DT) Interval (numtoyminterval (1, ' MONTH ')) ( Partition p0701 values less than (to_date (' 2007-02-01 ', ' yyyy-mm-dd ')) ); Sql>insert into SALES6 values (1, ' 01-jun-07

Data export:1 The database test is fully exported, user Name System Password Manager exported to D:\daochu.dmp exp System/[email protected] File=d:\daochu.dmp2 Exporting the system user in the database with the SYS user's table exp system/[email protected] file=d:\daochu.dmp owner= (System,sys)3 Exporting Tables Table1, table2 in the databaseEXP System/[email protected] file=d:\daochu.dmp tables= (table1,table2)4 Export the field in

In the project database design process, because of the large amount of data in the single table, we need to partition the table. Because the data in the table is a historical transaction, it is divided by month to improve the query and management. Because of the lack of understanding of the table partition before, in

Label:First check the Oracle parameters: Sql> Show Parameters SGA; NAME TYPE VALUE------------------------------------ ----------- -------LOCK_SGA Boolean TRUEPRE_PAGE_SGA Boolean TRUE If the value of the above two options is false, it needs to be modified to true; Modified: LOCK_SGA: Alter system set LOCK_SGA=TRUE Scope=spfile; Modify PRE_PAGE_SGA: Alter system set PRE_PAGE_SGA=TRUE Scope=spfile; Modify Sga_max_size to a suitable