sap basis base on oracle

SELECT file_id, file_name FROM dba_data_files  where file_name like ‘%system%‘ ORDER BY file_id;

ALTER DATABASE MOVE DATAFILE ‘/oracle/D88/sapdata1/system_1/system.data1‘ TO ‘/oracle/D88/sapdata7/system_1/system.data1‘;
SELECT file_id, file_name,STATUS,TABLESPACE_NAME FROM dba_data_files  where file_name like ‘%sysaux%‘  ORDER BY file_id;
ALTER DATABASE MOVE DATAFILE ‘/oracle/D88/sapdata1/sysaux_1/sysaux.data1‘ TO ‘/oracle/D88/sapdata7/sysaux_1/sysaux.data1‘;

sga_max_size           24G ==>39G   39 ==>49
db_cache_size          19G ==>29G   29 ==>39
shared_pool_size      4G==8G        8    ==>10

pga_aggregate_limit    6G ==>12G    12==>18G
pga_aggregate_target    3G ==>6G     6 ==>9G

alter system set sga_max_size= 17408M scope=spfile;
alter system set shared_pool_size=5G scope=spfile;
alter system set db_cache_size=11G  scope=spfile;

alter system set sga_max_size= 14496M scope=spfile;
alter system set shared_pool_size=4G scope=spfile;
alter system set db_cache_size=9728M  scope=spfile;

set linesize 300
col COLUMN_NAME for A50
col  OWNER for A10
col INDEX_NAME for A30
col TABLE_NAME for A30
SQL> select OWNER,INDEX_NAME,TABLE_NAME,UNIQUENESS from dba_indexes where TABLE_NAME=‘SMSCMAID‘;

OWNER      INDEX_NAME                     TABLE_NAME                     UNIQUENES
---------- ------------------------------ ------------------------------ ---------
SAPR3      SMSCMAID~0                     SMSCMAID                       UNIQUE
SAPR3      SMSCMAID~A01                   SMSCMAID                       UNIQUE

SQL> select TABLE_NAME,INDEX_NAME,COLUMN_NAME from dba_ind_columns where TABLE_NAME=‘SMSCMAID‘;

TABLE_NAME                     INDEX_NAME                     COLUMN_NAME
------------------------------ ------------------------------ --------------------------------------------------
SMSCMAID                       SMSCMAID~A01                   MANDT
SMSCMAID                       SMSCMAID~A01                   SCHEDULERID
SMSCMAID                       SMSCMAID~0                     MANDT
SMSCMAID                       SMSCMAID~0                     ID