понедельник, 15 апреля 2013 г.

dbv script for ASM datastore


select 'dbv file='''||file_name||''' blocksize='||df2.BLOCK_SIZE||' userid=sys/xxx logfile=dbv-'||tablespace_name||'.log' from dba_data_files df,v$datafile df2
where  df.file_id = df2.FILE#

среда, 10 апреля 2013 г.

minimum size oracle bigfile tablespace


for normal tablespace:
Metalink ID 153869.1
CREATE TABLESPACE minimum_data DATAFILE '/u00/minimum_data.dbf' SIZE 88k LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO


for bigfile tablespace:
CREATE BIGFILE TABLESPACE minimum_data DATAFILE '/u00/minimum_data.dbf' SIZE 145k LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO