17,377
社区成员
发帖
与我相关
我的任务
分享
SQL> select * from v$sgastat where name like '%log%';
POOL NAME BYTES
------------ -------------------------- ----------
log_buffer 2945024
shared pool MS alert log 72704
shared pool log_simultaneous_copies 256
shared pool max allowable # log files 253200
shared pool log file size history arr 168
shared pool log_checkpoint_timeout 12360
6 rows selected.
SQL> show parameter log_buffer
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
_log_buffers_corrupt boolean FALSE
_log_buffers_debug boolean FALSE
log_buffer integer 2899456
SQL>
SQL> show user
USER is "SCOTT"
SQL> select * from dept;
DEPTNO DNAME LOC
---------- -------------- -------------
10 ACCOUNTING NEW YORK
20 RESEARCH DALLAS
30 SALES CHICAGO
40 OPERATIONS BOSTON
SQL> show autocommit;
autocommit OFF
SQL> show parameter auto
ORA-00942: table or view does not exist
SQL> insert into dept values(55,'a','a')
2 ;
1 row created.
SQL> select * from dept;
DEPTNO DNAME LOC
---------- -------------- -------------
55 a a
10 ACCOUNTING NEW YORK
20 RESEARCH DALLAS
30 SALES CHICAGO
40 OPERATIONS BOSTON
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.
oduction
With the Partitioning, OLAP and Data Mining options
C:\Documents and Settings\Admin>sqlplus scott/tiger
SQL*Plus: Release 10.2.0.1.0 - Production on Mon Sep 28 10:23:42 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> select * from dept;
DEPTNO DNAME LOC
---------- -------------- -------------
55 a a
10 ACCOUNTING NEW YORK
20 RESEARCH DALLAS
30 SALES CHICAGO
40 OPERATIONS BOSTON
SQL>