oracle培训_XXXX0829

3-1Copyright©2003,Oracle.Allrightsreserved.主要培训内容1、直观概览2、Sql语句种类3、体系结构4、数据库启动与关闭5、数据字典、动态性能视图6、UNDO7、连接8、PGA9、CHECKPIONT10、锁11、事务12、SCN13、移动数据；备份、恢复（见备份与恢复介绍.ppt)14、性能管理Copyright©2003,Oracle.Allrightsreserved.1、直观概览3-3Copyright©2003,Oracle.Allrightsreserved.oracle_base/product/admin/inst_name/pfile/release_number/bin/dbs/rdbms/sqlplusSoftwareoradata/db01/system01.dbfcontrol01.ctlredo0101.log...db02/system01.dbfcontrol01.ctlredo0101.log...FilesOracleSoftwareandFileLocations3-4Copyright©2003,Oracle.Allrightsreserved.-bash-3.00$ps-ef|grepora_|grep-vgreporacle13665106月18?36:56ora_smon_ora10goracle14576106月18?5:08ora_qmnc_ora10goracle277061009:22:43?0:38ora_j000_ora10goracle15023106月18?5:41ora_q000_ora10goracle13711106月18?59:52ora_mmon_ora10goracle13551106月18?311:29ora_pmon_ora10goracle24501010:07:55?0:00ora_j002_ora10goracle13697106月18?93:06ora_cjq0_ora10goracle13569106月18?5:59ora_psp0_ora10goracle13585106月18?7:52ora_mman_ora10goracle15147106月18?3:55ora_q001_ora10goracle13729106月18?417:36ora_mmnl_ora10goracle68181006:00:02?0:12ora_j001_ora10goracle13656106月18?185:26ora_ckpt_ora10goracle13617106月18?1835:19ora_dbw1_ora10goracle13786106月18?0:17ora_s000_ora10goracle13684106月18?0:46ora_reco_ora10goracle13744106月18?0:09ora_d000_ora10goracle13637106月18?3305:06ora_lgwr_ora10goracle13604106月18?3037:33ora_dbw0_ora10g3-5Copyright©2003,Oracle.Allrightsreserved.SQLshowparameterdumpNAMETYPEVALUE-----------------------------------------------------------------------------background_core_dumpstringpartialbackground_dump_deststring/export/home/oracle/admin/ora10g/bdumpcore_dump_deststring/export/home/oracle/admin/ora10g/cdumpmax_dump_file_sizestringUNLIMITEDshadow_core_dumpstringPARTIALuser_dump_deststring/export/home/oracle/admin/ora10g/udumpSQLselectnamefromv$datafile;NAME--------------------------------------------------------------------------------/data2/oradata/system01.dbf/data2/oradata/undotbs01.dbf/data2/oradata/sysaux01.dbf/data2/oradata/users01.dbf/data1/userdata/tbs_dninmsv30.dbf/data1/userdata/tbs_dninms_report.dbf/data1/userdata/tbs_dninmsv30_02.dbf/data1/userdata/tbs_nmsv3_Table128M_02.dbf/data1/userdata/tbs_nmsv3_Table128M_01.dbf/export/home2/userdata/tbs_nmsv3_IDX_128M_02.dbf/export/home2/userdata/tbs_nmsv3_IDX_128M_01.dbf3-6Copyright©2003,Oracle.Allrightsreserved.SQLshowparametercontrolNAMETYPEVALUE-----------------------------------------------------------------------------control_file_record_keep_timeinteger7control_filesstring/data2/oradata/control01.ctl,/data2/oradata/control02.ctl,/data2/oradata/control03.ctlSQLcolmemberformata30SQLselect*fromv$logfile;GROUP#STATUSTYPEMEMBERIS_---------------------------------------------------------1ONLINE/data2/oradata/redo01.logNO2ONLINE/data2/oradata/redo02.logNO3ONLINE/data2/oradata/redo03.logNO4ONLINE/data2/oradata/redo04.logNOSQLarchiveloglistDatabaselogmodeNoArchiveModeAutomaticarchivalDisabledArchivedestinationUSE_DB_RECOVERY_FILE_DESTOldestonlinelogsequence50455Currentlogsequence504583-7Copyright©2003,Oracle.Allrightsreserved.-bash-3.00$stringsspfileora10g.ora+l阓ora10g.__db_cache_size=19360907264ora10g.__java_pool_size=33554432ora10g.__large_pool_size=16777216ora10g.__shared_pool_size=1040187392ora10g.__streams_pool_size=0*._awr_flush_threshold_metrics=TRUE*._kgl_large_heap_warning_threshold=50000000*.audit_file_dest='/export/home/oracle/admin/ora10g/adump'*.background_dump_dest='/export/home/oracle/admin/ora10g/bdump'*.compatible='10.2.0.1.0'*.control_files='/data2/oradata/control01.ctl','/data2/oradata/control02.ctl','/data2/oradata/control03.ctl'*.core_dump_dest='/export/home/oracle/admin/ora10g/cdump'*.db_32k_cache_size=117440512*.db_block_size=8192*.db_domain=''*.db_file_multiblock_read_count=16*.db_name='ora10g'*.db_recovery_file_dest='/export/home/oracle/flash_recovery_area'*.db_recovery_file_dest_size=2147483648*.dispatchers='(PROTOCOL=TCP)(SERVICE=ora10gXDB)'*.job_queue_processes=30*.nls_language='SIMPLIFIEDCHINESE'*.nls_territory='CHINA'*.open_cursors=300*.open_links=10*.pga_aggregate_target=6860832768*.processes=2500*.remote_login_passwordfile='EXCLUSIVE'*.sessions=1105*.sga_target=20583546880*.undo_management='AUTO'*.undo_retention=10800*.undo_tablespace='UNDOTBS1'*.user_dump_dest='/export/home/oracle/admin/ora10g/udump'3-8Copyright©2003,Oracle.Allrightsreserved.-bash-3.00$pwd/export/home/oracle/product/ora10g/dbs-bash-3.00$cd../network/admin/-bash-3.00$lslistener.orasamplessqlnet.logtnsnames.oratnsnames.ora.bak0812lzshrept.lstsqlnet.oratnsnames.ora.bak0721-bash-3.00$morelistener.ora#listener.oraNetworkConfigurationFile:/export/home/oracle/product/ora10g/network/admin/listener.ora#GeneratedbyOracleconfigurationtools.SID_LIST_ORA10G=(SID_LIST=(SID_DESC=(GLOBAL_DBNAME=ora10g)(ORACLE_HOME=/export/home/oracle/product/ora10g)(SID_NAME=ora10g)))ORA10G=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.224.0.9)(PORT=1521)))#----ADDEDBYTNSLSNR09-JAN-200900:12:39---INBOUND_CONNECT_TIMEOUT_LISTENER=0#--------------------------------------------SUBSCRIBE_FOR_NO