What is Automatic Management of Segment Space setting?

What is Automatic Management of Segment Space setting?
by

1 Answer

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 eliminates the DBA from setting the parameters pctused, freelists, and freelist groups. ASSM can be specified only with the locally managed tablespaces (LMT).
Oracle uses bitmaps
by

Related questions

How can you enable automatic archiving ?

Description : How can you enable automatic archiving ?

Last Answer : Shut the database Backup the database Modify/Include LOG_ARCHIVE_START_TRUE in init.ora file. Start up the database.

Explain the difference between a data block, an extent and a segment.

Description : Explain the difference between a data block, an extent and a segment.

Last Answer : A data block is the smallest unit of logical storage for a database object. As objects grow they take chunks of additional storage that are composed of contiguous data blocks. These groupings ... that an object takes when grouped together are considered the segment of the database object.

What is a temporary segment?

Description : What is a temporary segment?

Last Answer : Temporary segments are created by Oracle when a SQL statement needs a temporary work area to complete execution. When the statement finishes execution, the temporary segment extents are released to the system for future use.

What are the uses of rollback segment?

Description : What are the uses of rollback segment?

Last Answer : A database contains one or more rollback segments to temporarily store "undo" information.

What are the uses of rollback segment?

Description : What are the uses of rollback segment?

Last Answer : A database contains one or more rollback segments to temporarily store "undo" information.

What is rollback segment?

Description : What is rollback segment?

Last Answer : A database contains one or more rollback segments to temporarily store "undo" information.

What is an index segment?

Description : What is an index segment?

Last Answer : Each index has an index segment that stores all of its data.

What is a data segment?

Description : What is a data segment?

Last Answer : Each non-clustered table has a data segment. All of the table's data is stored in the extents of its data segment. Each cluster has a data segment. The data of every table in the cluster is stored in the cluster's data segment.

What is a Segment ?

Description : What is a Segment ?

Last Answer : A segment is a set of extents allocated for a certain logical structure.

What is a Rollback segment entry ?

Description : What is a Rollback segment entry ?

Last Answer : It is the set of before image data blocks that contain rows that are modified by a transaction. Each Rollback Segment entry must be completed within one rollback segment. A single rollback segment can have multiple rollback segment entries.

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.

How will you force database to use particular rollback segment ?

Description : How will you force database to use particular rollback segment ?

Last Answer : SET TRANSACTION USE ROLLBACK SEGMENT rbs_name.

What is a data segment?

Description : What is a data segment?

Last Answer : Data segment are the physical areas within a database block in which the data associated with tables and clusters are stored.

How can one see who is using a temporary segment? (for DBA

Description : How can one see who is using a temporary segment? (for DBA

Last Answer : For every user using temporary space, there is an entry in SYS.V$_LOCK with type 'TS'. All temporary segments are named 'ffff.bbbb' where 'ffff' is the file it is in and 'bbbb' is ... For usage stats, see SYS.V_$SORT_SEGMENT From Oracle 8.0, one can just query SYS.v$sort_usage. Look at these

How are extents allocated to a segment? (for DBA)

Description : How are extents allocated to a segment? (for DBA)

Last Answer : Oracle8 and above rounds off extents to a multiple of 5 blocks when more than 5 blocks are requested. If one requests 16K or 2 blocks (assuming a 8K block size), Oracle doesn't round it up to 5 ... -block size. Oracle doesn't round it up to the multiple of 5 when a tablespace is locally managed.

What is Rollback Segment ?

Description : What is Rollback Segment ?

Last Answer : A Database contains one or more Rollback Segments to temporarily store "undo" information.

What is an Index Segment ?

Description : What is an Index Segment ?

Last Answer : Each Index has an Index segment that stores all of its data.

Explain the use of setting GLOBAL_NAMES equal to TRUE.

Description : Explain the use of setting GLOBAL_NAMES equal to TRUE.

Last Answer : Setting GLOBAL_NAMES dictates how you might connect to a database. This variable is either TRUE or FALSE and if it is set to TRUE it enforces database links to have the same name as the remote database to which they are linking.

What is path setting for DLL?

Description : What is path setting for DLL?

Last Answer : Make sure you include the name of the DLL in the FORMS45_USEREXIT variable of the ORACLE.INI file, or rename the DLL to F45XTB.DLL. If you rename the DLL to F45XTB.DLL, replace the existing F45XTB.DLL in the ORAWINBIN directory with the new F45XTB.DLL.

What are the built-ins that are used for setting the LOV properties at runtime?

Description : What are the built-ins that are used for setting the LOV properties at runtime?

Last Answer : get_lov_property set_lov_property

What is the diff. bet. setting up of parameters in reports 2.0 reports2.5?

Description : What is the diff. bet. setting up of parameters in reports 2.0 reports2.5?

Last Answer : LOVs can be attached to parameters in the reports 2.5 parameter form.

What is the effect of setting the value "CHOOSE" for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command ?

Description : What is the effect of setting the value "CHOOSE" for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command ?

Last Answer : The Optimizer chooses Cost_based approach and optimizes with the goal of best throughput if statistics for atleast one of the tables accessed by the SQL statement exist in the data dictionary. Otherwise the OPTIMIZER chooses RULE_based approach.

What is the effect of setting the value "ALL_ROWS" for OPTIMIZER_GOAL parameter of the ALTER SESSION command ? What are the factors that affect OPTIMIZER in choosing an Optimization approach ?

Description : What is the effect of setting the value "ALL_ROWS" for OPTIMIZER_GOAL parameter of the ALTER SESSION command ? What are the factors that affect OPTIMIZER in choosing an Optimization approach ?

Last Answer : Answer The OPTIMIZER_MODE initialization parameter Statistics in the Data Dictionary the OPTIMIZER_GOAL parameter of the ALTER SESSION command hints in the statement.

What is COMPRESS and CONSISTENT setting in EXPORT utility?

Description : What is COMPRESS and CONSISTENT setting in EXPORT utility?

Last Answer : COMPRESS Simply: COMPRESS=n - Allocated space in database for imported table will be exactly as the space required to hold the data. COMPRESS=y - The INITIAL extent of the table would be ... . To minimize this possibility, export those tables at a time when updates are not being done.

What is PCTFREE and PCTUSED Setting?

Description : What is PCTFREE and PCTUSED Setting?

Last Answer : PCTFREE is a block storage parameter used to specify how much space should be left in a database block for future updates. For example, for PCTFREE=10, Oracle will keep on adding new rows to a block ... SQL> SELECT pct_free FROM user_tables WHERE table_name = 'EMP'; PCT_FREE ---------- 10

What is PCT Increase setting?

Description : What is PCT Increase setting?

Last Answer : PCTINCREASE refers to the percentage by which each next extent (beginning with the third extend) will grow. The size of each subsequent extent is equal to the size of the previous extent plus this ... /O may be required to fetch the additional blocks where extent maps of the segment are stored.

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 monitor the space allocation ?

Description : How will you monitor the space allocation ?

Last Answer : By querying DBA_SEGMENT table/view.

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 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)

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.

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 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

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 are the different plan types available in Fusion Absence Management? Accrual

Description : What are the different plan types available in Fusion Absence Management?

Last Answer : There are three different plan types available in Fusion Absence Management, which are given below: Accrual Use this type to create absence plans that enable workers to accrue time for the ... plan to pay workers if they are not eligible for a standard maternity absence qualification plan.

What are the different absence type patterns available in Fusion Absence Management?

Description : What are the different absence type patterns available in Fusion Absence Management?

Last Answer : An absence pattern contains a predefined set of rules that you can use as a starting point to create an absence type. The pattern that you select determines whether special fields ... patterns available in Fusion Absence Management. ∙Illness or injury ∙Childbirth or placement ∙Generic absence

What is distribution threshold in fusion performance management?

Description : What is distribution threshold in fusion performance management?

Last Answer : create Rating Model for performance management we do define Rating Distribution to tell what is the minimum and maximum percentage of worker should fall in each rating level. This is more commonly ... filed to control Number of eligible workers a manager must have to see distribution target .

What are the primitive operations common to all record management systems?

Description : What are the primitive operations common to all record management systems?s?

Last Answer : Addition, deletion and modification.

Data Management

Description : Data Management

Last Answer : Data Management is a broad field of study, but essentially is the process of managing data as a resource that is valuable to an organization or business. One of the largest ... popular topics include data modeling, data warehousing, data movement, database administration and data mining.

Automatic repeat request error management mechanism is provided by ________ a. logical link control sublayer b. media access control sublayerc. network interface control sublayer d. application access control sublayer

Description : Automatic repeat request error management mechanism is provided by ________ a. logical link control sublayer b. media access control sublayer c. network interface control sublayer d. application access control sublayer

Last Answer : a. logical link control sublayer

Automatic repeat request error management mechanism is provided by ________ A. logical link control sublayer B. media access control sublayer C. network interface control sublayer D. application access control sublayer

Description : Automatic repeat request error management mechanism is provided by ________ A. logical link control sublayer B. media access control sublayer C. network interface control sublayer D. application access control sublayer

Last Answer : A. logical link control sublayer

The following are true about the spinal cord: a. segment T12 lies at the level of vertebral body T9 b. cerebrospinal fluid is found within the subdural space c. two point discrimination is transmitted in the dorsal column d. hemisection results in contralateral loss of pain and temperature sense below the lesio

Description : The following are true about the spinal cord: a. segment T12 lies at the level of vertebral body T9 b. cerebrospinal fluid is found within the subdural space c. two point ... the dorsal column d. hemisection results in contralateral loss of pain and temperature sense below the lesio

Last Answer : segment T12 lies at the level of vertebral body T9

The GPS space segment consists of Navigation Satellite Timing and Ranging whose number is: (A) 8 (B) 12 (C) 16 (D) 24

Description : The GPS space segment consists of Navigation Satellite Timing and Ranging whose number is: (A) 8 (B) 12 (C) 16 (D) 24

Last Answer : Answer: Option D

Which information is stored in a monitoring segment of the alert monitoring infrastructure within the Computing Center Management System (CCMS)? Note: there are 2 corrects answered to this questions A. Current monitoring data of monitored components B. The coding of data collectors C. Open alerts within CCMS D. Monitoring definitions

Description : Which information is stored in a monitoring segment of the alert monitoring infrastructure within the Computing Center Management System (CCMS)? Note: there are 2 corrects answered to this questions A. ... B. The coding of data collectors C. Open alerts within CCMS D. Monitoring definitions

Last Answer : A. Current monitoring data of monitored components B. The coding of data collectors

The Department of Space proposed setting up of Indian Institute of Space Technology on the line of the seven IITs. It will have its independent campus at (1) Chennai (2) Thumba (3) Thiruvananthapuram (4) Sriharikota

Description : The Department of Space proposed setting up of Indian Institute of Space Technology on the line of the seven IITs. It will have its independent campus at (1) Chennai (2) Thumba (3) Thiruvananthapuram (4) Sriharikota

Last Answer : Thiruvananthapuram

Thrombolytic therapy has become a useful adjunct in the management of peripheral arterial occlusion. In this setting, direct intraarterial administration rather than intravenous has been advocated to decrease the risk of systemic bleeding. Which of the following true statement(s) concerning the use of thrombolytic agents for arterial occlusion is/are true? a. A standard technique involves infusing high-dose urokinase, 4000 units per minute for 1–2 hours, directly into the clot by a catheter embedded in the thrombus b. If progress is made, further fibrinolytic therapy is given at 1000 to 2000 units per minute until clot lysis has occurred c. The usual infusion time by the above-stated technique is usually in excess of 24 hours d. Successful clot lysis occurs more frequently in arterial graf

Description : Thrombolytic therapy has become a useful adjunct in the management of peripheral arterial occlusion. In this setting, direct intraarterial administration rather than intravenous has been advocated ... may be indicated for situations where complete clot evacuation cannot be accomplished surgically

Last Answer : Answer: a, b, e The most popular method for intraarterial thrombolytic therapy for arterial occlusion involves passing a guidewire through the thrombus with arteriographic guidance and ... acute arterial occlusion) or when distal vasculative is occluded and precludes appropriate inflow patency

The three steps of project management are _____. a. controlling the project, directing the project, and creating the work plan b. creating the work plan, staffing the project, and controlling and directing the project c. directing the project, creating the work plan, and naming the tasks d. naming the tasks, creating the work plan, and completing the deliverables e. setting the start date, estimating the time, and reading the actual time

Description : The three steps of project management are _____. a. controlling the project, directing the project, and creating the work plan  b. creating the work plan, staffing the project, and controlling ... the deliverables  e. setting the start date, estimating the time, and reading the actual time

Last Answer : b. creating the work plan, staffing the project, and controlling and directing the  project