Home \ Interview Questions \ SAP Interview Questions \ SAP Basis

SAP Basis

What happens during the shutdown of an Oracle database?

Written by SAP DBA Friday, 19 March 2010 07:25

When you shutdown the database with the NORMAL or IMMEDIATE option, the database system writes a checkpoint before shutting down the database. Shutting down the database with the ABORT option always requires an instance recovery at the next database startup.

Add new comment

Which of the following statements express part of the SAP-recommended strategy for creating and updating the table statistics used by the cost-based optimizer?

SAP Basis

Written by SAP DBA Friday, 19 March 2010 07:25

Statistics are created for all transparent tables that have no statistics.

Add new comment

What happens if a table wants to allocate another extent but there is not enough contiguous free space in the tablespace?

SAP Basis

Written by SAP DBA Friday, 19 March 2010 07:25

The Oracle error message ORA 1653 is sent to the file SYSLOG and to the ABAP short dump.

Add new comment

When the R/3 update task aborts with an Oracle error ORA1653 - failure to allocate an extent for a table in a specific tablespace - what action needs to be taken?

SAP Basis

Written by SAP DBA Friday, 19 March 2010 07:25

he tablespace size should be increased by adding a new data file. After the cause of the error has been removed, the R/3 update task must be reactivated.

Add new comment

Which of the following checks are useful for database performance monitoring?

SAP Basis

Written by SAP DBA Friday, 19 March 2010 07:25

Checking that the CBO statistics are refreshed once a week according to the strategy recommended by SAP. Checking the data buffer quality. Checking the shared cursor cache for expensive SQL statements.

Add new comment

SAP Basis

What happens during the shutdown of an Oracle database?

Which of the following statements express part of the SAP-recommended strategy for creating and updating the table statistics used by the cost-based optimizer?

What happens if a table wants to allocate another extent but there is not enough contiguous free space in the tablespace?

When the R/3 update task aborts with an Oracle error ORA1653 - failure to allocate an extent for a table in a specific tablespace - what action needs to be taken?

Which of the following checks are useful for database performance monitoring?

More Articles...

Search TechHairBall.com

Login Form (Can use your Gmail Acct)

Topics

Latest Comments