Oracle管理课程课件PPT推荐.ppt
- 文档编号:14317100
- 上传时间:2022-10-22
- 格式:PPT
- 页数:123
- 大小:4.07MB
Oracle管理课程课件PPT推荐.ppt
《Oracle管理课程课件PPT推荐.ppt》由会员分享,可在线阅读,更多相关《Oracle管理课程课件PPT推荐.ppt(123页珍藏版)》请在冰豆网上搜索。
,$sqlplussysassysdbaPassword:
SQL*Plus:
Release11.1.0.6.0-ProductiononTueAug502:
39:
202008Copyright(c)1982,2007,Oracle.Allrightsreserved.Connectedto:
OracleDatabase11gEnterpriseEditionRelease11.1.0.6.0-ProductionWiththePartitioning,OLAP,DataMiningandRealApplicationTestingoptionsSQLselectenamefromscott.emp;
ENAME-AbelAndeAtkinson,UsingSQL*PlustoViewData,UsingSQL*PlustoViewParameters,SQLshowparameter;
NAMEVALUE-lock_name_space2processes150sessions247timed_statisticsTRUEtimed_os_statistics0SQLSHOWPARAMETERsga_targetNAMETYPEVALUE-Sga_targetinteger500MSQLshowparametersgaNAMETYPEVALUE-Lock_sgabooleanFALSEPre_page_sgabooleanFALSEsga_max_sizeinteger500Msga_targetinteger500M,InitializationParameterFiles,$lsl$ORACLE_HOME/dbs/spfileora12.ora$lsl$ORACLE_HOME/dbs/initora12.oraSQLcreatepfilefromspfile;
SQLcreatespfilefrompfile;
ChangingParameterValues:
Examples,SQLaltersessionsetsga_target=450M;
SQLaltersystemsetsga_target=450M;
SQLshowparametersga_targetSQLaltersystemsetsga_target=550m;
SQLaltersystemsetsga_max_size=550mscope=spfile;
SQLshutdownimmediate;
SQLstartupSQLshowparametersga_max_sizeSQLaltersystemsetsga_target=550m;
SQLselectsysdatefromdual;
SQLaltersessionsetnls_date_format=YYYY-MM-DD;
SQLselectsysdatefromdual;
DataDictionary:
Overview,Tables,Indexes,Views,Users,Schemas,Procedures,andsoon,SystemTablespace,Metadata,$sqlplussys/yijian123assysdbaSQLselecttable_namefromdba_tables;
SQLselectuser_namefromdba_users;
SQLselectfile_namefromdba_data_files;
UseOracleClientsoftwareinWindowsOS,UseOracleClientsoftwareinWindowsOS,UseOracleClientsoftwareinWindowsOS,UseOracleClientsoftwareinWindowsOS,UseOracleClientsoftwareinWindowsOS,UseOracleClientsoftwareinWindowsOS,UseOracleClientsoftwareinWindowsOS,ListenerManagement,$lsnrctlstatusLSNRCTLforLinux:
Version11.2.0.1.0Productionon30-DEC-201223:
04:
12Copyright(c)1991,2009,Oracle.Allrightsreserved.Connectingto(ADDRESS=(PROTOCOL=tcp)(HOST=AS5)(PORT=1521)STATUSoftheLISTENER-AliasLISTENERVersionTNSLSNRforLinux:
Version11.2.0.1.0ProductionStartDate29-DEC-201216:
49:
20Uptime1days6hr.14min.52secTraceLeveloffSecurityON:
LocalOSAuthenticationSNMPOFFListenerParaFile/u01/app/oracle/product/11.2.0/db_1/network/admin/listener.oraListenerLogFile/u01/app/oracle/diag/tnslsnr/AS5/listener/alert/log.xmlListeningEndpointsSummary(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=AS5)(PORT=1521)ServicesSummary.Service“ora11”has1instance(s),Instance“ora11”,statusREADY,has1handler(s)forthisservice.Service“ora11XDB”has1instance(s),Instance“ora11”,statusREADY,has1handler(s)forthisserivce.Thecommandcompletedsuccessfully$lsnrctlstop$lsnrctlstart,UseDeveloperClientTools,UseOracleClientsoftwarei
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- Oracle 管理 课程 课件