windows下cmd命令行登录oracle数据库方法。直接就登录进来了。
C:\Users\Administrator>sqlplusSQL*Plus: Release 11.2.0.4.0 Production on Thu Jun 18 17:25:07 Copyright (c) 1982, , Oracle. All rights reserved.Enter user-name: ncc_auto_0617Enter password:Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL>
linux下命令行登录oracle数据库方法。需要输入用户名密码。
Last login: Thu Jun 18 18:15:36 from 10.11.x.x[root@nctest130 ~]# su - oracle[oracle@nctest130 ~]$ sqlplus /nologSQL*Plus: Release 11.2.0.4.0 Production on Thu Jun 18 18:32:07 Copyright (c) 1982, , Oracle. All rights reserved.SQL> conn ncc_auto_0610/1Connected.SQL>
windows下cmd查询sga参数值语句。
SQL> show parameter sgaNAME TYPE------------------------------------ ---------------------------------VALUE------------------------------lock_sga booleanFALSEpre_page_sgabooleanFALSEsga_max_sizebig integer42Gsga_target big integer0
linux下查询sga参数值语句，下面两种方式都可以。
SQL> show parameter sgaNAME TYPE------------------------------------ ---------------------------------VALUE------------------------------lock_sga booleanFALSEpre_page_sgabooleanFALSEsga_max_sizebig integer46464Msga_target big integer0SQL> show sgaTotal System Global Area 4.8504E+10 bytesFixed Size 2264336 bytesVariable Size 4.4829E+10 bytesDatabase Buffers 3623878656 bytesRedo Buffers49254400 bytes
喜欢的点个赞❤吧！
