SQL> show user;
USER is "SYS"
SQL> select count(*) from v$fixed_table;

  COUNT(*)
----------
      1383

SQL> select count(*) from dict;

  COUNT(*)
----------
      1870

SQL> select * from v$sgainfo;

NAME                                  BYTES RES
-------------------------------- ---------- ---
Fixed SGA Size                      1218316 No
Redo Buffers                        2973696 No
Buffer Cache Size                  75497472 Yes
Shared Pool Size                   71303168 Yes
Large Pool Size                     4194304 Yes
Java Pool Size                      4194304 Yes
Streams Pool Size                   8388608 Yes
Granule Size                        4194304 No
Maximum SGA Size                  167772160 No
Startup overhead in Shared Pool    33554432 No
Free SGA Memory Available                 0

11 rows selected.

SQL> create table hr.big as select * from dba_objects;

Table created.

SQL> select table_name,blocks from dba_tables where table_name='BIG' and wner='HR';

TABLE_NAME                         BLOCKS
------------------------------ ----------
BIG

SQL> analyze table hr.big compute statistics;

Table analyzed.

SQL> select table_name,blocks from dba_tables where table_name='BIG' and wner='HR';

TABLE_NAME                         BLOCKS
------------------------------ ----------
BIG                                   704

SQL> desc v$statistics_level;
 Name                                                                                Null?    Type
 ----------------------------------------------------------------------------------- -------- --------------------------------------------------------
 STATISTICS_NAME                                                                              VARCHAR2(64)
 DESCRIPTION                                                                                  VARCHAR2(4000)
 SESSION_STATUS                                                                               VARCHAR2(8)
 SYSTEM_STATUS                                                                                VARCHAR2(8)
 ACTIVATION_LEVEL                                                                             VARCHAR2(7)
 STATISTICS_VIEW_NAME                                                                         VARCHAR2(64)
 SESSION_SETTABLE                                                                             VARCHAR2(3)

SQL> select name from v$tablespace;

NAME
------------------------------
SYSTEM
UNDOTBS1
SYSAUX
TEMP
USERS

SQL> select  statistics_name,activation_level from v$statistics_level;

STATISTICS_NAME                                                  ACTIVAT
---------------------------------------------------------------- -------
Buffer Cache Advice                                              TYPICAL
MTTR Advice                                                      TYPICAL
Timed Statistics                                                 TYPICAL
Timed OS Statistics                                              ALL
Segment Level Statistics                                         TYPICAL
PGA Advice                                                       TYPICAL
Plan Execution Statistics                                        ALL
Shared Pool Advice                                               TYPICAL
Modification Monitoring                                          TYPICAL
Longops Statistics                                               TYPICAL
Bind Data Capture                                                TYPICAL

STATISTICS_NAME                                                  ACTIVAT
---------------------------------------------------------------- -------
Ultrafast Latch Statistics                                       TYPICAL
Threshold-based Alerts                                           TYPICAL
Global Cache Statistics                                          TYPICAL
Active Session History                                           TYPICAL
Undo Advisor, Alerts and Fast Ramp up                            TYPICAL

16 rows selected.

SQL> alter system set cursor_sharing='similar';

System altered.

SQL> alter system set cursor_sharing='force';

System altered.

SQL> commit;

Commit complete.

SQL> alter database backup controlfile to trace;

Database altered.

SQL> show user;
USER is "SYS"

SQL> create pfile='/home/oracle/pfile.ora' from spfile;

File created.

SQL> alter database backup controlfile to trace;

Database altered.

SQL> alter database backup controlfile to trace;

Database altered.

SQL> show parameter db_block;

NAME                                 TYPE                             VALUE
------------------------------------ -------------------------------- ------------------------------
db_block_buffers                     integer                          0
db_block_checking                    string                           FALSE
db_block_checksum                    string                           TRUE
db_block_size                        integer                          8192
SQL> show paramter db_block_ch;
SP2-0158: unknown SHOW option "paramter"
SP2-0735: unknown SHOW option beginning "db_block_c..."
SQL> show parameter db_block_ch;

NAME                                 TYPE                             VALUE
------------------------------------ -------------------------------- ------------------------------
db_block_checking                    string                           FALSE
db_block_checksum                    string                           TRUE
SQL> alter session set sql_trace=TRUE;

Session altered.

SQL> show parameter log_check;

NAME                                 TYPE                             VALUE
------------------------------------ -------------------------------- ------------------------------
log_checkpoint_interval              integer                          0
log_checkpoint_timeout               integer                          1800
log_checkpoints_to_alert             boolean                          FALSE


SQL> alter system set log_checkpoints_to_alert=TRUE;

System altered.

SQL> alter system checkpoint;

System altered.

SQL> @?/rdbms/admin/catproc.sql
DOC>######################################################################
DOC>######################################################################
DOC>    The following PL/SQL block will cause an ORA-20000 error and
DOC>    terminate the current SQLPLUS session if the user is not SYS.
DOC>    Disconnect and reconnect with AS SYSDBA.
DOC>######################################################################
DOC>######################################################################
DOC>#

PL/SQL procedure successfully completed.