How free extents are managed in Ver 6.0 and Ver 7.0 ?

How free extents are managed in Ver 6.0 and Ver 7.0 ?
by

1 Answer

Answer :

Free extents cannot be merged together in Ver 6.0.
Free extents are periodically coalesces with the neighboring free
extent in Ver 7.0
by

Related questions

What is the use of CONSISTENT (Ver 7) option in EXP command ?

Description : What is the use of CONSISTENT (Ver 7) option in EXP command ?

Last Answer : A flag to indicate whether a read consistent version of all the exported objects should be maintained.

What is the use of ANALYSE ( Ver 7) option in EXP command ?

Description : What is the use of ANALYSE ( Ver 7) option in EXP command ?

Last Answer : A flag to indicate whether statistical information about the exported objects should be written to export dump file.

Can you import objects from Oracle ver. 7.3 to 9i?

Description : Can you import objects from Oracle ver. 7.3 to 9i?

Last Answer : Different versions of the import utility are upwards compatible. This means that one can take an export file created from an old export version, and import it using a later version of the import utility. ... 8 database to allow the Oracle 7.3 exp/imp utilities to run against an Oracle 8 database.

Is space acquired in blocks or extents ?

Description : Is space acquired in blocks or extents ?

Last Answer : In extents

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 a Locally Managed Tablespace?

Description : What is a Locally Managed Tablespace?

Last Answer : Locally Managed Tablespace is a tablespace that record extent allocation in the tablespace header. Each tablespace manages its own free and used space within a bitmap structure stored in one of the ... tracks adjacent free space) ▪ Changes to the extent bitmaps do not generate rollback information

What are the min. extents allocated to a rollback extent ?

Description : What are the min. extents allocated to a rollback extent ?

Last Answer : Two

Is space acquired in blocks or extents ?

Description : Is space acquired in blocks or extents ?

Last Answer : In extents .

Have any of you ever heard the phrase "um ver"?

Description : Have any of you ever heard the phrase "um ver"?

Last Answer : I never heard of it, but I did find this

Pattern ERG (PERG): a. tests the function of the ganglion cells b. uses a checkered board pattern that changes in luminance c. gives the same information as visual evoked response (VER) d. is abnormal in glaucoma

Description : Pattern ERG (PERG): a. tests the function of the ganglion cells b. uses a checkered board pattern that changes in luminance c. gives the same information as visual evoked response (VER) d. is abnormal in glaucoma

Last Answer : is abnormal in glaucoma

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

What are the Pct Free and Pct Used

Description : What are the Pct Free and Pct Used

Last Answer : Pct Free is used to denote the percentage of the free space that is to be left when creating a table. Similarly Pct Used is used to denote the percentage of the used space that is to be used when creating a table eg.:: Pctfree 20, Pctused 40

What is meant by free extent ?

Description : What is meant by free extent ?

Last Answer : A free extent is a collection of continuous free blocks in tablespace. When a segment is dropped its extents are reallocated and are marked as free.

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

If free-market capitalism always beats top-down managed states and socialism, why are Republicans so terrified of big, mean China?

Description : If free-market capitalism always beats top-down managed states and socialism, why are Republicans so terrified of big, mean China?

Last Answer : Nice essay. Really.

Has anyone managed to get a free xbox live gold membership?

Description : Has anyone managed to get a free xbox live gold membership?

Last Answer : Generally speaking, unless the offer is from Microsoft… I would put them down to mostly if not fully fraudulent in nature.

How can you execute the user defined triggers in forms 3.0 ?

Description : How can you execute the user defined triggers in forms 3.0 ?

Last Answer : Execute Trigger (trigger-name)

What is the main diff. bet. Reports 2.0 & Reports 2.5?

Description : What is the main diff. bet. Reports 2.0 & Reports 2.5?

Last Answer : Report 2.5 is object oriented.

There is a string 120000 12 0 .125 , how you will find the position of the decimal place?

Description : There is a string 120000 12 0 .125 , how you will find the position of the decimal place?

Last Answer : INSTR('120000 12 0 .125',1,'.') output 13

How image_items can be populate to field in forms 4.0?

Description : How image_items can be populate to field in forms 4.0?

Last Answer : A fetch from a long raw database column PL/Sql assignment to executing the read_image_file built_in procedure to get an image from the file system.

What is a library in Forms 4.0?

Description : What is a library in Forms 4.0?

Last Answer : A library is a collection of Pl/SQL program units, including user named procedures, functions & packages

What are the built-in routines is available in forms 4.0 to create and manipulate a parameter list?

Description : What are the built-in routines is available in forms 4.0 to create and manipulate a parameter list?

Last Answer : Add_parameter Create_Parameter_list Delete_parameter Destroy_parameter_list Get_parameter_attr Get_parameter_list set_parameter_attr

Explain types of Block in forms4.0?

Description : Explain types of Block in forms4.0?

Last Answer : Base table Blocks. Control Blocks. 1. A base table block is one that is associated with a specific database table or view. 2. A control block is a block that is not associated with a database table. ITEMS

What are the design facilities available in forms 4.0?

Description : What are the design facilities available in forms 4.0?

Last Answer : Default Block facility. Layout Editor. Menu Editor. Object Lists. Property Sheets. PL/SQL Editor. Tables Columns Browser. Built-ins Browser.

List the editors availables in forms 4.0?

Description : List the editors availables in forms 4.0?

Last Answer : Default editor User_defined editors system editors.

Give the equivalent term in forms 4.0 for the following. Page, Page 0?

Description : Give the equivalent term in forms 4.0 for the following. Page, Page 0?

Last Answer : Page - Canvas-View Page 0 - Canvas-view null.

What are the menu items that oracle forms 4.0 supports?

Description : What are the menu items that oracle forms 4.0 supports?

Last Answer : Plain, Check,Radio, Separator, Magic

What is a predefined exception available in forms 4.0?

Description : What is a predefined exception available in forms 4.0?

Last Answer : Raise form_trigger_failure

List system variables available in forms 4.0, and not available in forms 3.0?

Description : List system variables available in forms 4.0, and not available in forms 3.0?

Last Answer : System.cordination_operation System Date_threshold System.effective_Date System.event_window System.suppress_working

List the windows event triggers available in Forms 4.0?

Description : List the windows event triggers available in Forms 4.0?

Last Answer : When-window-activated, when-window-closed, when-window-deactivated, when-window-resized

What is the significance of PAGE 0 in forms 3.0 ?

Description : What is the significance of PAGE 0 in forms 3.0 ?

Last Answer : Hide the fields for internal calculation.

Can we create two blocks with the same name in form 3.0 ?

Description : Can we create two blocks with the same name in form 3.0 ?

Last Answer : No

How do you trap the error in forms 3.0 ?

Description : How do you trap the error in forms 3.0 ?

Last Answer : using On-Message or On-Error triggers.

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.

If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied?

Description : If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied?

Last Answer : While both reports 2.0 and 2.5 create the parameter, report 2.5 gives a message that a bind parameter has been created.

The Shopkeeper increased the price of a product by 75% so that customer finds it difficult to purchase the required amount. But somehow the customer managed to purchase only 140% of the required amount. What is the net difference in the expenditure on that product? a) 12.5 b) 26.0 c) 13.5 d) 17.5 e) 19.8

Description : The Shopkeeper increased the price of a product by 75% so that customer finds it difficult to purchase the required amount. But somehow the customer managed to purchase only 140% of the required amount. What is the net difference in the ... on that product? a) 12.5 b) 26.0 c) 13.5 d) 17.5 e) 19.8

Last Answer : Answer: D  Quantity×Rate=Price  1x1=1  1.4x1.75=2.45  Decrease in price = (0.175/1) × 100  = 17.5%

What does "jumps off the screen" mean?

Description : What does "jumps off the screen" mean?

Last Answer : answer:AMD is a relatively small manufacturer but well established in the industry. In this context, AMD jumps off the screen at the guy doing the research into acquiring companies for ... chip manufacturing division, but AMD is the one that really stands out from an acquisition perspective.

How to add conditions in select statement in oracle?

Description : How to add conditions in select statement in oracle?

Last Answer : Just add the decode

How can I dump an oracle schema to a LOCAL file over a network connection from sqlplus?

Description : How can I dump an oracle schema to a LOCAL file over a network connection from sqlplus?

Last Answer : By connecting and spooling are you excluding the exp/imp commands (or expdb/impdb in 10g)?

What are the two ways to incorporate images into a oracle forms application?

Description : What are the two ways to incorporate images into a oracle forms application?

Last Answer : Boilerplate Images Image_items

Can one export a subset of a table? (for DBA

Description : Can one export a subset of a table? (for DBA

Last Answer : From Oracle8i one can use the QUERY= export parameter to selectively unload a subset of the data from a table. Look at this example: exp scott/tiger tables=emp query=\"where deptno=10\"

What are the types of visual attribute settings?

Description : What are the types of visual attribute settings?

Last Answer : Custom Visual attributes Default visual attributes Named Visual attributes. Window

How does one use the import/export utilities? (for DBA

Description : How does one use the import/export utilities? (for DBA

Last Answer : Look for the "imp" and "exp" executables in your $ORACLE_HOME/bin directory. One can run them interactively, using command line parameters, or using parameter files. Look at the imp/exp parameters ... and export data with the "Schema Manager" GUI that ships with Oracle Enterprise Manager (OEM).

what is a display item?

Description : what is a display item?

Last Answer : Display items are similar to text items but store only fetched or assigned values. Operators cannot navigate to a display item or edit the value it contains.

What is import/export and why does one need it? (for DBA

Description : What is import/export and why does one need it? (for DBA

Last Answer : The Oracle export (EXP) and import (IMP) utilities are used to perform logical database backup and recovery. They are also used to move Oracle data from one machine, database or schema to ... corruption. Ensure that all the data can be read. . Transporting tablespaces between databases . Etc.

Are there any troubleshooting tips for OEM? (for DBA

Description : Are there any troubleshooting tips for OEM? (for DBA

Last Answer : . Create the OEM repository with a user (which will manage the OEM) and store it in a tablespace that does not share any data with other database users. It is a bad practice to create ... successfully. Check the log to see the results of the execution rather than relying on this status.

Where can one get more information about TCL? (for DBA

Description : Where can one get more information about TCL? (for DBA

Last Answer : One can write custom event checking routines for OEM using the TCL (Tool Command Language) language. Check the following sites for more information about TCL: . The Tcl Developer Xchange - ... the OraTCL package . Tom Poindexter's Tcl Page - Oratcl was originally written by Tom Poindexter

How does one start the Oracle Intelligent Agent? (for DBA

Description : How does one start the Oracle Intelligent Agent? (for DBA

Last Answer : One needs to start an OIA (Oracle Intelligent Agent) process on all machines that will to be managed via OEM. For OEM 9i and above:

What is the Oracle Intelligent Agent? (for DBA

Description : What is the Oracle Intelligent Agent? (for DBA

Last Answer : The Oracle Intelligent Agent (OIA) is an autonomous process that needs to run on a remote node in the network to make the node OEM manageable. The Oracle Intelligent Agent is ... events registered in Enterprise Manager; and . Executing tasks associated with jobs submitted to Enterprise Manager.