How will you monitor the space allocation ?

How will you monitor the space allocation ?
by

1 Answer

Answer :

By querying DBA_SEGMENT table/view.
by

Related questions

How does Space allocation table place within a block ?

Description : How does Space allocation table place within a block ?

Last Answer : Each block contains entries as follows Fixed block header Variable block header Row Header,row date (multiple rows may exists) PCTEREE (% of free space for row updation in future)

What are the dictionary tables used to monitor a database space?

Description : What are the dictionary tables used to monitor a database space?

Last Answer : DBA_FREE_SPACE DBA_SEGMENTS DBA_DATA_FILES.

How will you monitor rollback segment status ?

Description : How will you monitor rollback segment status ?

Last Answer : Querying the DBA_ROLLBACK_SEGS view IN USE - Rollback Segment is on-line. AVAILABLE - Rollback Segment available but not on-line. OFF-LINE - Rollback Segment off-line INVALID - Rollback ... corupted. PARTLY AVAILABLE - Contains data from an unresolved transaction involving a distributed database.

What are the ways to monitor the performance of the report?

Description : What are the ways to monitor the performance of the report?

Last Answer : Use reports profile executable statement. Use SQL trace facility.

What are the dictionary tables used to monitor a database spaces ?

Description : What are the dictionary tables used to monitor a database spaces ?

Last Answer : DBA_FREE_SPACE DBA_SEGMENTS DBA_DATA_FILES.

What view would you use to determine free space in a tablespace?

Description : What view would you use to determine free space in a tablespae?

Last Answer : DBA_FREE_SPACE

Is space acquired in blocks or extents ?

Description : Is space acquired in blocks or extents ?

Last Answer : In extents

Table Space,Data Files,Parameter File, Control Files

Description : Table Space,Data Files,Parameter File, Control Files

Last Answer : Table Space :: The table space is useful for storing the data in the database.When a database is created two table spaces are created. a) System Table space :: This data file stores all the tables ... They contain the Db name, name and location of dbs, data files ,redo log files and time stamp.

How will you estimate the space required by a non- clustered tables?

Description : How will you estimate the space required by a non- clustered tables?

Last Answer : Calculate the total header size Calculate the available dataspace per data block Calculate the combined column lengths of the average row Calculate the total average row size. Calculate the average number rows ... add 10 % additional space to calculate the initial extent size for a working table.

How will you swap objects into a different table space for an existing database ?

Description : How will you swap objects into a different table space for an existing database ?

Last Answer : Export the user Perform import using the command imp system/manager file=export.dmp indexfile=newrite.sql. This will create all definitions into newfile.sql. Drop necessary objects. Run the script newfile.sql after altering the tablespaces. Import from the backup for the necessary objects.

How do I find used/free space in a TEMPORARY tablespace? (for DBA

Description : How do I find used/free space in a TEMPORARY tablespace? (for DBA

Last Answer : Unlike normal tablespaces, true temporary tablespace information is not listed in DBA_FREE_SPACE. Instead use the V$TEMP_SPACE_HEADER view: SELECT tablespace_name, SUM (bytes used), SUM (bytes free) FROM V$temp_space_header GROUP BY tablespace_name;

How does one coalesce free space?(for DBA)

Description : How does one coalesce free space?(for DBA)

Last Answer : SMON coalesces free space (extents) into larger, contiguous extents every 2 hours and even then, only for a short period of time. SMON will not coalesce free space if a tablespace's default storage ... from SELECT TS#, NAME FROM SYS.TS$; You can get status information about this process by se

What is Automatic Management of Segment Space setting?

Description : What is Automatic Management of Segment Space setting?

Last Answer : Oracle9i New Feature Series: Automatic Segment Space Management Automatic Segment Space Management (ASSM) introduced in Oracle9i is an easier way of managing space in a segment using bitmaps. It ... . ASSM can be specified only with the locally managed tablespaces (LMT). Oracle uses bitmaps

How can you reduce the space of TEMP datafile?

Description : How can you reduce the space of TEMP datafile?

Last Answer : Prior to Oracle 11g, you had to recreate the datafile. In Oracle 11g a new feature was introduced and you can shrink the TEMP tablespace.

What computer monitor takes up the least amount of space on a desk?

Description : What computer monitor takes up the least amount of space on a desk?

Last Answer : The best computer monitor for a small amount of space is a flat screen monitor. Flat screens are slim and will take up minimal space on your desk. They also have a better picture than older monitors.

Why do i get a memory allocation error in Joomla 1.5?

Description : Why do i get a memory allocation error in Joomla 1.5?

Last Answer : answer:The error is generated by PHP, so the variables would be there instead. Here's an article for Drupal specifically From that: ------------- That indicates that Drupal needed more memory than PHP was ... root ------------- On your own box, for development, probably go with the top option.

Of which allocation does Gadgil Formula refer to? -Do You Know?

Description : Of which allocation does Gadgil Formula refer to? -Do You Know?

Last Answer : answer:

: Rules of Allocation

Last Answer : Article 55 (6) of the Constitution states that " the President shall make rules for the distribution and conduct of official functions." This is the Rules of Allocation.

When Using the Allocation Rules Engine (ARE) function how can you ensure that all transactions for ABC Office Supplies are divided evenly between cost center 1111 and cost center 2222?

Description : When Using the Allocation Rules Engine (ARE) function how can you ensure that all transactions for ABC Office Supplies are divided evenly between cost center 1111 and cost center 2222?

Last Answer : Need answer

What are the Advantages and disadvantages of algebraic method of allocation?

Description : What are the Advantages and disadvantages of algebraic method of allocation?

Last Answer : What is the answer ?

In a socialist econmoy how are the basic problems of scarcity and allocation of limited resources addressed?

Description : In a socialist econmoy how are the basic problems of scarcity and allocation of limited resources addressed?

Last Answer : What is the answer ?

What best explains why the game of economics is about setting goals as much as it is about making allocation decisions?

Description : What best explains why the game of economics is about setting goals as much as it is about making allocation decisions?

Last Answer : Need answer

Asset Allocation?

Description : Asset Allocation?

Last Answer : Asset AllocationThe asset allocation is designed to help you create a balancedportfolio of investments. Your age, ability to tolerate risk andseveral other factors are used to calculate a desirable mix ... balanced portfolio.Click on the "View Report" button for a detailed look at yourresults.

Asset Allocation or Making a Pie Out of Money?

Description : Asset Allocation or Making a Pie Out of Money?

Last Answer : When you sit down with a financial professional to talk about investments, one of the first terms you may hear when discussing your portfolio is 'asset allocation'. To take some of the mystical feel ... pie. Watch for it and you'll see it. When you start making decisions about portfolio construction

Compare the memory organization schemes of contiguous memory allocation, pure segmentation, and pure paging with respect to the following issues External fragmentation?

Description : Compare the memory organization schemes of contiguous memory allocation, pure segmentation, and pure paging with respect to the following issues External fragmentation?

Last Answer : 1. Compare the memory organization schemes of contiguous memory allocation, pure segmentation, and pure paging with respect to the following issues: a. External fragmentationb. Internal fragmentation

The ability to find an individual item in a file immediately _____ is used. 1) File allocation table 2) Directory 3) Sequential access 4) Direct access 4 5) None of these

Description : The ability to find an individual item in a file immediately _____ is used. 1) File allocation table 2) Directory 3) Sequential access 4) Direct access 4 5) None of these

Last Answer : Answer :1

What does DMA stand for? A) Distinct Memory Access B) Direct Memory Access C) Direct Module Access D) Direct Memory Allocation

Description : What does DMA stand for? A) Distinct Memory Access B) Direct Memory Access C) Direct Module Access D) Direct Memory Allocation

Last Answer : Answer : B

Allocation of treatments to the different experimental units by a random process

Description : Allocation of treatments to the different experimental units by a random process

Last Answer : Ans. Randomization

The Fourth Schedule to the Constitution of India deals with : (1) provisions related to the administration of tribal areas. (2) allocation of seats in the Council of States. (3) the Union List, The State List and the Concurrent List. (4) recognized languages of the Union of India.

Description : The Fourth Schedule to the Constitution of India deals with : (1) provisions related to the administration of tribal areas. (2) allocation of seats in the Council of States. (3) the Union List, The State List and the Concurrent List. (4) recognized languages of the Union of India.

Last Answer : (2) allocation of seats in the Council of States Explanation: The Fourth Schedule [Articles 4(1) and 80(2)] of the Indian Constitution deals with the allocation of seats in the Rajya Sabha (the upper house of Parliament) per State or Union Territory.

Seventh schedule of the Constitution of India deals with: (1) Allocation of Seats in the Council of States (2) Distribution of power between the Union and the States (3) Power and Authority of the Municipalities (4) Powers of the Governor of the State

Description : Seventh schedule of the Constitution of India deals with: (1) Allocation of Seats in the Council of States (2) Distribution of power between the Union and the States (3) Power and Authority of the Municipalities (4) Powers of the Governor of the State

Last Answer : (2) Distribution of power between the Union and the States Explanation: Seventh schedule of the Constitution deals with distribution of power between the union and the states. It contains three lists (Union, State and Con-current) over which the Union and state governments enjoy authority.

Which one of the following pairs is not correctly matched? (1) Languages : Eighth Schedule (2) The forms of oaths or affirmations: Second Schedule (3) Allocation of seats in the Council of States - Fourth Schedule (4) Provisions as to disqualification on the ground of defection - Tenth Schedule

Description : Which one of the following pairs is not correctly matched? (1) Languages : Eighth Schedule (2) The forms of oaths or affirmations: Second Schedule (3) Allocation of seats in the Council of States - Fourth Schedule (4) Provisions as to disqualification on the ground of defection - Tenth Schedule

Last Answer : (2) The forms of oaths or affirmations: Second Schedule Explanation: Forms of Oaths and Affirmations are the subject of Third Schedule. Salary of President, Governors, Chief Judges, Judges of High Court and Supreme Court, Comptroller and Auditor General are the subject of Second Schedule.

Who among the following determines the authority who shall readjust the allocation of seats in the Lok Sabha to the states and division of each State into territorial constituencies? (1) The President of India (2) The Parliament of India (3) The Chief Election Commissioner of India (4) The Lok Sabha alone

Description : Who among the following determines the authority who shall readjust the allocation of seats in the Lok Sabha to the states and division of each State into territorial constituencies? (1) The President of ... Parliament of India (3) The Chief Election Commissioner of India (4) The Lok Sabha alone

Last Answer : (2) The Parliament of India Explanation: According to article 82 of Indian Constitution, the parliament of India shall readjust the allocation of seats in the Lok Sabha to the states and division of each state into territorial constituencies.

The state wise allocation of seats in Lok Sabha is based on the 1971 census. Up to which year does this remain intact? (1) 2031 (2) 2026 (3) 2021 (4) 2011

Description : The state wise allocation of seats in Lok Sabha is based on the 1971 census. Up to which year does this remain intact? (1) 2031 (2) 2026 (3) 2021 (4) 2011

Last Answer : (2) 2026 Explanation: The state wise allocation of seats in Lok Sabha is based on 1971 census and this remain upto 2026 under article 82.

Which one of the following is not correctly matched? State Allocation of Seats in the Rajya Sabha (1) Andhra Pradesh 18 (2) Odisha 10 (3) Tamil Nadu 18 (4) Maharashtra 19

Description : Which one of the following is not correctly matched? State Allocation of Seats in the Rajya Sabha (1) Andhra Pradesh 18 (2) Odisha 10 (3) Tamil Nadu 18 (4) Maharashtra 19

Last Answer : (1) Andhra Pradesh 18 Explanation: The Fourth Schedule to the Constitution provides for allocation of seats to the States and Union Territories in Rajya Sabha. The allocation of seats is made on the basis of the population of each State.

In a free enterprise economy, resource allocation is determined by - (1) the pattern of consumers' spending (2) the wealth of the entrepreneurs (3) decision of the Government (4) the traditional employment of factors

Description : In a free enterprise economy, resource allocation is determined by - (1) the pattern of consumers' spending (2) the wealth of the entrepreneurs (3) decision of the Government (4) the traditional employment of factors

Last Answer : (1) the pattern of consumers' spending Explanation: In a free market economy, resources are allocated through the interaction of free and self-directed market forces. This means that what to ... is determined by producers, and who gets the products depends upon the purchasing power of consumers.

Consumer's sovereignty means: (1) consumers are free to spend their income as they like. (2) consumers have the power to manage the economy. (3) consumer's expenditures influence the allocation of resources. (4) consumer goods are free from government control,

Description : Consumer's sovereignty means: (1) consumers are free to spend their income as they like. (2) consumers have the power to manage the economy. (3) consumer's expenditures influence the allocation of resources. (4) consumer goods are free from government control,

Last Answer : (1) consumers are free to spend their income as they like. Explanation: Consumer sovereignty means that buyers ultimately determine which goods and services remain in production. In unrestricted markets, ... to motivate producers. So ultimately it means how the consumers want to spend their incomes.

In resource allocation, the resources are allocated to a project in order that the…...............are attained a. Goals b. Objectives c. Both a, b d. None of the above

Description : In resource allocation, the resources are allocated to a project in  order that the…...............are attained a. Goals b. Objectives c. Both a, b d. None of the above

Last Answer : c. Both a, b

Which of the following statements is true of Insured Asset Allocation? A. It is aimed at benefiting from short-term under pricing and over pricing of assets. B. In this strategy the risk tolerance of the investor are ignored. C. In this strategy long-term predictions regarding the capital markets are used. D. In this strategy the asset mix is held constant. E. It is a strategy aimed at achieving the objectives of the investor without depending on market timing.

Description : Which of the following statements is true of Insured Asset Allocation? A. It is aimed at benefiting from short-term under pricing and over pricing of assets. B. In this strategy the risk ... . It is a strategy aimed at achieving the objectives of the investor without depending on market timing

Last Answer : E. It is a strategy aimed at achieving the objectives of the investor without depending on market timing.

Which are the events concerning RAG can occur in a system: a. Request for a resource b. Allocation of a resource c. Release of resource d. Allof these

Description : Which are the events concerning RAG can occur in a system: a. Request for a resource b. Allocation of a resource c. Release of resource d. Allof these

Last Answer : d. Allof these

The supervisor of a CRC is responsible for a) Timely opening of the set b) Maintaining the master data for the interim dispatch c) Opening bag allocation closing bag allocation d) All the above

Description : The supervisor of a CRC is responsible for a) Timely opening of the set b) Maintaining the master data for the interim dispatch c) Opening bag allocation closing bag allocation d) All the above

Last Answer : d) All the above

What was the fund allocation for the implementation of the ‘Protection from Domestic Violence Act’ in the Eleventh plan? a. Rs. 100 crore b. Rs. 300 crore c. Rs. 500 crore d. Rs. 1000 crore

Description : What was the fund allocation for the implementation of the ‘Protection from Domestic Violence Act’ in the Eleventh plan? a. Rs. 100 crore b. Rs. 300 crore c. Rs. 500 crore d. Rs. 1000 crore

Last Answer : c. Rs. 500 crore

A rolling plan refer to a plan which? (A) Does not change it target every year (B) Changes its allocation every year (C) Changes its allocations and target every year (D) Changes only its target every year

Description : A rolling plan refer to a plan which? (A) Does not change it target every year (B) Changes its allocation every year (C) Changes its allocations and target every year (D) Changes only its target every year

Last Answer : (C) Changes its allocations and target every year

A rolling plan refer to a plan which? (A) Does not change it target every year (B) Changes its allocation every year (C) Changes its allocations and target every year (D) Changes only its target every year

Description : A rolling plan refer to a plan which? (A) Does not change it target every year (B) Changes its allocation every year (C) Changes its allocations and target every year (D) Changes only its target every year

Last Answer : (C) Changes its allocations and target every year

In _________, thereis no resource allocation for a packet. A) datagram switching B) circuit switching C) frame switching D) none of the above

Description : In _________, thereis no resource allocation for a packet. A) datagram switching B) circuit switching C) frame switching D) none of the above

Last Answer : datagram switching

This strategy is an expression of desired strategic direction deliberately formulated & planned in terms of resource allocation, control systems, organizational structure etc. A. Intended strategy B. Realized strategy C. Emergent strategy D. None of these options are valid.

Description : This strategy is an expression of desired strategic direction deliberately formulated & planned in terms of resource allocation, control systems, organizational structure etc. A. Intended strategy B. Realized strategy C. Emergent strategy D. None of these options are valid.

Last Answer : Intended strategy

Resource Allocation is included in Strategy Formulation

Description : Resource Allocation is included in Strategy Formulation

Last Answer : True

This strategy is an expression of desired strategic direction deliberately formulated & planned in terms of resource allocation, control systems, organizational structure etc. A. Intended strategy B. Realized strategy C. Emergent strategy D. None of these options are valid.

Description : This strategy is an expression of desired strategic direction deliberately formulated & planned in terms of resource allocation, control systems, organizational structure etc. A. Intended strategy B. Realized strategy C. Emergent strategy D. None of these options are valid.

Last Answer : Intended strategy

A clothing store that sets their advertising budget by following the major competitor and adding an additional 15 per cent is using the method 1. percentage of sales 2. arbitrary allocation 3. objective and task 4. competitive parity 5. None of these

Description : A clothing store that sets their advertising budget by following the major competitor and adding an additional 15 per cent is using the method 1. percentage of sales 2. arbitrary allocation 3. objective and task 4. competitive parity 5. None of these

Last Answer : competitive parity

Going Concern' concept of business says which of the following 1. Business will continue trading over a long period of time 2. Anticipate no profit and provide for all possible losses 3. The period of allocation f the cost of an asset 4. 1 and 2 5. None of these

Description : Going Concern' concept of business says which of the following 1. Business will continue trading over a long period of time 2. Anticipate no profit and provide for all possible losses 3. The period of allocation f the cost of an asset 4. 1 and 2 5. None of these

Last Answer : Business will continue trading over a long period of time