Answer / chandrasekaran

What is tablespace?
It is a logical partition of a database. As the database
are OS datafiles residing in filesystem, to access that we
need a logical definition. That is tablespace

Difference between Offline redolog files and Online redolog
files?
Online redolog file
1. Has the current changes happend in database
2. Used for Instance recovery and database recovery

Offline redolog file
1. It is backup of Online redolog file when online redolog
file is full. Online redolog file are taken backup via
ARCn archive process
2. It is also used for recovery the database when crashed

Datafiles
1. Which carries the actual data
2. Three main types of datafiles are
1. System data files - meta data of entire database
objects
2. Undo data files - Carries un-commited data's
3. User data files - Carries the customized data's
4. Temporary data files - Carries temporary data. used
for sorting

Rezising Tablespace
Three ways to do
1. Extend the current data file in the tablespace
2. Add new datafile to tablesapce
3. set AUTOEXTEND parameter ON

What are the different types of rfc?

0 Answers  

---

suppose in the landscape there is development, quality, pre-production and production system is there. what is the route(transport route) between pre-production to production? and why?

0 Answers  

---

Where are t-code name and program values stored? How can I find a list of all the t-codes in the SAP system?

3 Answers  

---

what are the prerequisite for before applying support packs? Shall I apply sap basis patch to all the system, like BW, ABAP, HR, etc.

3 Answers   Terrenos,

---

how to know the port number of message server?

6 Answers  

---

Explain what is business kpis ?

0 Answers  

---

suppose all the background jobs are running under a background user with a user name. now the user regin the job how can we run the background jobs without him pls anyone help me thanks in advance

2 Answers   Cap Gemini, Infosys,

---

If a user wants to execute a background job immediately but there is no Background work process available. How u will do?

8 Answers  

---

if 100 users are accessing perticular table how to know the users who are acessing table.

3 Answers   CTS,

---

What is the relevance of the Deletion Flag/Indicator in the archiving process?

1 Answers  

---

What will you do when you cannot login to a dialog server?

5 Answers  

---

what is single role and composite role diffrence ?

4 Answers   IBM,

---