摘要：
1、查看oracle server NLS_LANG参数信息；以SYSDBA身份登录view nls_parametersSQL> select * from v$nls_parameters where parameter='NLS_CHARACTERSET';PARAMETER VALUE------------------------------ ------------------------------NLS_CHARACTERSET AL32UTF82、修改环境变量export NLS_LANG# .bash_... 阅读全文
摘要：
Query dba_tables for IOTDBA_TABLES->IOTSQL> SELECT table_name,iot_name,iot_type FROM dba_tables WHERE table_name LIKE '%IOT%';TABLE_NAME IOT_NAME IOT_TYPE------------------------------ ------------------------------ ------------SYS_IOT_OVER_12334 ... 阅读全文
摘要：
Index-Organized TablesIOT表要求必须有主键.heap表可以没有主键.没有主键的表，不能称之为IOT表.IOT and Heap TablesCompared to heap tables,IOTs have:Faster key-based access to table dataReduced storage requirementsSecondary indexes and logical rowidsIOTs have the following restrictions:-Must have a primary key-Cannot be clusteredCr 阅读全文
摘要：
connection as sysdbaSQL> grant select any dictionary to user_name; 阅读全文
摘要：
Compressed IndexesCREATE INDEX t_idx on t(owner,object_type,object_name);SQL> ANALYZE INDEX t_idx validate structure;Index analyzed.SQL> create table idx_stats 2 as 3 select 'noncompressed' what,a.* from index_stats a;Table created.lab1->dataSQL> drop index t_idx;Index dropped.SQ 阅读全文
摘要：
ObjectivesAfter completing this lesson,you should be able to do the following:Explain the role of the DBA in tuning applications.Move tables using the ALTER TABLE command.Redefine a table onlineCreate different types of indexesBuild and manage index-organized tablesExplain and plan OLTP,DSS,and hybr 阅读全文