New Install Oracle – Basic init.ora

2 Jan

Karena terlalu seringnya install oracle database server, maka juga sering juga (lho kok) lupa setting apa saja yang perlu diperhatikan agar oracle database dapat digunakan secara optimal menurut pengalaman saya, paling tidak adalah :
a. sessions
SQL> alter system set sessions = 335 scope=spfile;
b. open_cursors
SQL> alter system set open_cursors = 600 scope=spfile;
c. processes
SQL> alter system set processes = 300 scope=spfile;
d. archive
SQL> alter database archivelog;
SQL> alter system set log_archive_dest_1=’location=/u03′;
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u03
Oldest online log sequence 1124
Next log sequence to archive 1125
Current log sequence 1125
e. memory
SQL> alter system set memory_max_target=3G scope=spfile;
SQL> alter system set memory_target=3G scope=spfile;
SQL> alter system set sga_max_size=3G scope=spfile;
SQL> alter system set sga_target=0 scope=spfile;
f. schedulle backup dmp
$ crontab -e
0 0 * * 1,3,5 /backup/script/back01b
30 0 * * 1,3,5 /backup/script/back01c
0 0 * * 2,4,6 /backup/script/back02b
30 0 * * 2,4,6 /backup/script/back02c
0 0 * * 7 /backup/script/back03b
30 0 * * 7 /backup/script/back03c

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: