I was given the following project and I have a few questions.
First here was the project
1) Create and ODBC Data Source Connection called "Siebsrvr_Siebel"
2) Create a SQL*Net Connect String called SiebelProd
3) Create a table owner username/password of "Siebel"/"Siebel"
4) Create an index Tablespace area for Siebel called "SiebelIndex". The
Tablespace should be 200 MB in size with an initial extent of 2 blocks or 8
KB and a next extent of 100 KB.
5) Create a data Tablespace area for Siebel called "SiebelData". The
Tablespace should be 200 MB in size with an initial extent of 2 blocks or 8
KB and a next extent of 100 KB.
6) Please make the following changes to init.ora
a) Optimizer_Mode should be set to rule based optimization
b) DB_BLOCK_BUFFERS should be set to 10,000
c) SHARED_POOL_SIZE should be set to 20 MB
d) DB_FILE_MULTIBLOCK_READ_COUNT should be set to 32
e) SORT_AREA_SIZE should be set to 512,000
f) SORT_AREA_RETAINED_SIZE should be set to 65,536
g) OPEN_CURSURS should be set to 2,000
h) DB_BLOCK_SIZE should be set to 4 KB
i) NLS_DATE_FORMAT should be set to DD-MON-RR
j) PROCESSES should be set to 150
k) SESSIONS should be set to a number greater than 1 if it is
not already
7) Temporary tablespaces should have INITIAL and NEXT EXTENT parameters
set to 14 KB
8) Create 4 Rollback Segments with an initial extent set to 100 KB, and
next set to 100 KB in a dedicated Rollback Segment Tablespace.
9) Create 1 Large Rollback segment called BigRollback with an initial
extent of 51200 KB and a next extent of 51200 KB in the Rollback Segment
Tablespace created above.
10) Remove all other Rollback segments.
Here are my questions
1) How do you create Create a SQL*Net Connect String called SiebelProd
2) I went into DBA studio and created user siebel, but what do you have to do to make them a table owner or is that a tablespace owner.
3)4 on the rollback segments, should I make them for the SIEBELDATA table space or the Default Rollback tablespace.
Thanks in advance
mark
mark@acsconsult.com
First here was the project
1) Create and ODBC Data Source Connection called "Siebsrvr_Siebel"
2) Create a SQL*Net Connect String called SiebelProd
3) Create a table owner username/password of "Siebel"/"Siebel"
4) Create an index Tablespace area for Siebel called "SiebelIndex". The
Tablespace should be 200 MB in size with an initial extent of 2 blocks or 8
KB and a next extent of 100 KB.
5) Create a data Tablespace area for Siebel called "SiebelData". The
Tablespace should be 200 MB in size with an initial extent of 2 blocks or 8
KB and a next extent of 100 KB.
6) Please make the following changes to init.ora
a) Optimizer_Mode should be set to rule based optimization
b) DB_BLOCK_BUFFERS should be set to 10,000
c) SHARED_POOL_SIZE should be set to 20 MB
d) DB_FILE_MULTIBLOCK_READ_COUNT should be set to 32
e) SORT_AREA_SIZE should be set to 512,000
f) SORT_AREA_RETAINED_SIZE should be set to 65,536
g) OPEN_CURSURS should be set to 2,000
h) DB_BLOCK_SIZE should be set to 4 KB
i) NLS_DATE_FORMAT should be set to DD-MON-RR
j) PROCESSES should be set to 150
k) SESSIONS should be set to a number greater than 1 if it is
not already
7) Temporary tablespaces should have INITIAL and NEXT EXTENT parameters
set to 14 KB
8) Create 4 Rollback Segments with an initial extent set to 100 KB, and
next set to 100 KB in a dedicated Rollback Segment Tablespace.
9) Create 1 Large Rollback segment called BigRollback with an initial
extent of 51200 KB and a next extent of 51200 KB in the Rollback Segment
Tablespace created above.
10) Remove all other Rollback segments.
Here are my questions
1) How do you create Create a SQL*Net Connect String called SiebelProd
2) I went into DBA studio and created user siebel, but what do you have to do to make them a table owner or is that a tablespace owner.
3)4 on the rollback segments, should I make them for the SIEBELDATA table space or the Default Rollback tablespace.
Thanks in advance
mark
mark@acsconsult.com