Difference between adding a data file and resizing the data
file?
Answer Posted / bhuvesh jindal
By Adding a datafile we mean that we are creating a new Datafile and Resizing is just, resizing your existing datafile. e.g we are datafiles at different drives/mount points, if we want to add datafile of 500m but that mount has just space less than that then instead of going for adding a data-file, we will resize the existing datafile in that mount to consume that available space and then will re allocate the quota to users, and thus resizing and adding matters upon the condition.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain domain controller?
TMS Configuration?
Transport request types and its syntax?
describe how SAP handles Memory Management?
What is XI3.0? Explain XI
How you connect ECC to EP?
Briefly explain a recent problem you faced, which u felt proud by solving that? And how will u solved?
What is the use of patches in sap system? Could you name few common patch types?
Have you done any parameter changes using configtool and visual admin tool?
What is an ‘ok’ code? What are the differences an ‘ok’ code to a ‘t-code’?
If you have a long-running Job, how do you analyse?
Explain the system trace?
How database extend?
Can you change the profile parameter in the os level? Which one is advisable why?
How to check CPU usage in EP? If java path is down the how to do trouble shoot? What is the transport group? What is the SLD system in PI? How to take back up in EP? How to create logical system? Is it possible to change the name logical system in SSC4? How you will take the online Backup and incremental Backup? What is the backup strategy? How many application servers you have in Production System? Difference between oracle 9i and oracle 10g? What is EHP4? What is your enhancement package and support package? how to find RAM size on Unix? How to find OS level at command Prompt? While doing kernel upgrade what is exe files? What is client comparison? How to apply job on Os level? What are the recent challenges faced? How to apply support package in solution manager? Difference between SPDD/SPAU If SAP* is not working ? If job is slow? how you will trouble shoot? What are software files required for SAP 4.7?