Determine the best value for cschedspins
Determine the best value for cschedspins?
Expert
This is crucial to understand that a cschedspins is a tunable parameter (recommended values being between from 1 to 2000) and the optimum value is fully dependent on the customer's environment. It is used by the scheduler only when this finds that there are no runnable tasks. When there are no runnable tasks then the scheduler has two options:
1. Assume the engine go to sleep (that is done by an OS call) for a given interval or until an event occurs. 2. Go and search for a ready task again.
Briefly describe the capabilities and concepts of Business Intelligence?
What do you understand by the term concurrency control in DBMS?
Explain Batches and Session?
When must you seem de-normalization?
Provide a brief differentiation between independent and dependent data warehouse?
Which member function places a new node on the end of the linked list? Answer: appendNode(): This member function places a new node on the end of t
Explain the following term: a) OLAP b) OLTP
Name the areas where data structures are applied broadly?
Define the Fully Functional dependency.
Explain terms Procedure Cache in Sybase. Answer: It is the memory area where compiled query tree run for example: procedure and batch query.
18,76,764
1928796 Asked
3,689
Active Tutors
1428873
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!