oracle有用资料VIP免费

第一章:日志管理1.forcinglogswitchessql>altersystemswitchlogfile;2.forcingcheckpointssql>altersystemcheckpoint;3.addingonlineredologgroupssql>alterdatabaseaddlogfile[group4]sql>('/disk3/log4a.rdo','/disk4/log4b.rdo')size1m;4.addingonlineredologmemberssql>alterdatabaseaddlogfilemembersql>'/disk3/log1b.rdo'togroup1,sql>'/disk4/log2b.rdo'togroup2;5.changesthenameoftheonlineredologfilesql>alterdatabaserenamefile'c:/oracle/oradata/oradb/redo01.log'sql>to'c:/oracle/oradata/redo01.log';6.droponlineredologgroupssql>alterdatabasedroplogfilegroup3;7.droponlineredologmemberssql>alterdatabasedroplogfilemember'c:/oracle/oradata/redo01.log';8.clearingonlineredologfilessql>alterdatabaseclear[unarchived]logfile'c:/oracle/log2a.rdo';9.usinglogmineranalyzingredologfilesa.intheinit.oraspecifyutl_file_dir=''b.sql>executedbms_logmnr_d.build('oradb.ora','c:\oracle\oradb\log');c.sql>executedbms_logmnr_add_logfile('c:\oracle\oradata\oradb\redo01.log',sql>dbms_logmnr.new);d.sql>executedbms_logmnr.add_logfile('c:\oracle\oradata\oradb\redo02.log',sql>dbms_logmnr.addfile);e.sql>executedbms_logmnr.start_logmnr(dictfilename=>'c:\oracle\oradb\log\oradb.ora');f.sql>select*fromv$logmnr_contents(v$logmnr_dictionary,v$logmnr_parameterssql>v$logmnr_logs);g.sql>executedbms_logmnr.end_logmnr;第二章:表空间管理1.createtablespacessql>createtablespacetablespace_namedatafile'c:\oracle\oradata\file1.dbf'size100m,sql>'c:\oracle\oradata\file2.dbf'size100mminimumextent550k[logging/nologging]sql>defaultstorage(initial500knext500kmaxextents500pctinccease0)sql>[online/offline][permanent/temporary][extent_management_clause]2.locallymanagedtablespacesql>createtablespaceuser_datadatafile'c:\oracle\oradata\user_data01.dbf'sql>size500mextentmanagementlocaluniformsize10m;3.temporarytablespacesql>createtemporarytablespacetemptempfile'c:\oracle\oradata\temp01.dbf'sql>size500mextentmanagementlocaluniformsize10m;4.changethestoragesettingsql>altertablespaceapp_dataminimumextent2m;sql>altertablespaceapp_datadefaultstorage(initial2mnext2mmaxextents999);5.takingtablespaceofflineoronlinesql>altertablespaceapp_dataoffline;sql>altertablespaceapp_dataonline;6.read_onlytablespacesql>altertablespaceapp_datareadonly|write;7.dropingtablespacesql>droptablespaceapp_dataincludingcontents;8.enableingautomaticextensionofdatafilessql>altertablespaceapp_dataadddatafile'c:\oracle\oradata\app_data01.dbf'size200msql>autoextendonnext10mmaxsize500m;9.changethesizefodatafilesmanuallysql>alterdatabasedatafile'c:\oracle\oradata\app_data.dbf'resize200m;10.Movingdatafiles:altertablespacesql>altertablespaceapp_datarenamedatafile'c:\oracle\oradata\app_data.dbf'sql>to'c:\oracle\app_data.dbf';11.movingdatafiles:alterdatabasesql>alterdatabaserenamefile'c:\oracle\oradata\app_data.dbf'sql>to'c:\oracle\app_data.dbf';第三章:表1.createatablesql>createtabletable_name(columndatatype,columndatatype]....)sql>tablespacetablespace_name[pctfreeinteger][pctusedinteger]sql>[initransinteger][maxtransinteger]sql>storage(initial200knext200kpctincrease0maxextents50)sql>[logging|nologging][cache|nocache]2.copyanexistingtablesql>createtabletable_name[logging|nologging]assubquery3.createtemporarytablesql>createglobaltemporarytablexay_tempasselect*fromxay;oncommitpreserverows/oncommitdeleterows4.pctfree=(averagerowsize-initialrowsize)*100/averagerowsizepctused=100-pctfree-(avera...