ORACLE缓存表（国外英文资料）.docVIP

ORACLE缓存表 Database listener stops and starts The user who switches to the Oracle database installed is typically Oracle (installed or not started under root Oracle); # Su Oracle Then start the listener # lsnrctl start Youll see an interface that starts successfully; Stop listener commands Lsnrctl stop You can modify the Oracle ORA file, the database configuration, in the opt/oracle/product/9.2.0/network/admin directory, modify the corresponding ora file can be On the current network on the Oracle cache table questions, Xiao Bian on the Internet to sort out some, and I hope to help you. The Oracle cache table (db_buffer_pool) consists of three parts: Buffer_pool_defualt Buffer_pool_keep Buffer_pool_recycle If you want to pin the table in memory, that is, press the table in the keep area. The relevant commands are: The alter table table name storage (buffer_pool keep); this command indicates the table if the cache is cached in the keep zone. Statements can be passed: Select table_name from dba_tables where buffer_pool=KEEP; the query to this table is in the keep zone. But that doesnt mean the tables have been cached. The following statement caches the table: Alter table table name cache; can pass Select table_name, from, dba_, tables, where, rtrim (CACHE) =Yqueries that the table has been cached. The tables added to the keep do not say they cannot be removed from memory, but are less likely to move out of memory. You can also manually remove memory, as follows: Alter table... Nocache; Cache Connect to Oracle is an option for the Oracle memory database TimesTen, which provides real-time, updatable caching for the Oracle database. The cache table resides at the application layer and unloads the computing cycle from the back-end system, enabling a very responsive and scalable real-time application. (product data sheet) Most of the data in the enterprise database is historical data, and very few people access it. However, the information hidden below these data should be