ArcerZhang`s Technology Blog

摘要： 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 阅读全文

摘要： ObjectivesAfter completing this lesson,you should be able to do the following:Create materialized viewsRefresh materialized viewsCreate nested materialized viewsCreate UNION ALL materialized viewsExplain the use of query rewritesEnable and control query rewritesMaterialized ViewsInstantiations of a 阅读全文

摘要： 查看SGA参数信息SQL> show sga;Total System Global Area 3256942592 bytesFixed Size 2217752 bytesVariable Size 1795164392 bytesDatabase Buffers 1442840576 bytesRedo Buffers 16719872 bytesSQL> show parameter SGA_MAXNAME TYPE ... 阅读全文

摘要： ObjectivesInstall perfastat schemaperfstat->performance statisticscaptrure snapshotsReportConfigure parametersMaintenance<<参考文档:$ORACLE_HOME/rdbms/admin/spdoc.txt>>Install perfstat schemaPrepair tablespace不能放在system、undo、user、temporatory tablespace里面Execute spcreate.sqlcreate tablespa 阅读全文

摘要： Settting Up Your EnviromentSetting up the SCOTT/TIGER SchemaExecuting the ScriptCreating the Schema without the ScriptSetting Your EnvironmentSetting up Autotrace in SQL*PlusInitial Setupcd [ORACLE_HOME]/rdbms/adminlog into SQL*Plus as SYSTEMrun @utlxplanrun CREATE PUBLIC SYNONYM PLAN_TABLE FOR PLAN 阅读全文

摘要： Compoments of a PL/SQL PackagePackage Specification是必须要有的，Package body是可以没有的（bodyless）；但是如果你在package specification中声明了cursor，subprogram等，那么就必须要有package body,来实现上面的cursor、subprogram声明.Internal and External Visibility of a Package`s ComponentsDeveloping PL/SQL Packages:OverviewCreating the Package Spe 阅读全文

摘要： ObjectivesAfter completing this lesson,you should be able to do the followingDescribe packages and list their componentsCreate a package to group together related variables,cursors,constants,exceptions,procedures,and fuctions.Designate a package construct as either public or privateInvoke a package 阅读全文