table record distribution query.

Paul Hallam

How does oracle distribute records in a table that is in a tablespace
with multiple datafiles.

Very simplisticly Ingres will distribute sequential records evenly
across multiple datafiles for a single table. (Not exact but good
enough for this question.)

How does oracle distribute records for a table that is in a tablespace
with multiple datafiles.

Any pointer to where in the documentation this is explained would also
be appreciated.

Many thanks

Paul

Jul 19 '05 #1

Subscribe Reply

3262

Mark D Powell

pa*********@hot mail.com (Paul Hallam) wrote in message news:<5e******* *************** ****@posting.go ogle.com>...

How does oracle distribute records in a table that is in a tablespace
with multiple datafiles.

Very simplisticly Ingres will distribute sequential records evenly
across multiple datafiles for a single table. (Not exact but good
enough for this question.)

How does oracle distribute records for a table that is in a tablespace
with multiple datafiles.

Any pointer to where in the documentation this is explained would also
be appreciated.

Many thanks

Paul

Paul, Oracle distributes rows based on the free list whose membership
is determined by interaction of the table settings for pctfree and
pctused with DML activity. See the Concepts manual for details.

Oracle distributes extents accross the files in a tablespace based on
a whole slew of factors: tablespace space management scheme, free
space availability, next extent size requested, etc....

But if you load an empty tablespace one table at a time you can watch
Oracle stripe the extents for a large enough object accross the files
that make up the tablespace. Oracle does not attempt to rebalance
objects that are unevenly distributed or when new files are added to
the tablespace (as DB2 does).

Once a tablespace is loaded the availability of free space extents
sufficient to hold the requested allocation is the primary driver of
where an extent is allocated in conjuction with the tablespace space
management scheme: uniform extents, autoallocate, or dictionary
managed.

HTH -- Mark D Powell --

Jul 19 '05 #2

Similar topics

2806

DB2 Optimizer is not using Summary Table (DB2 V 8.1.7)

by: Andrea | last post by:

Hi, I've read the former postings but was not able to solve my problem: I have a Summary Table (or MQT as you like it) and the query optimizer does not seem to use the summary table. I run the following commands: set current query optimization 9;

DB2 Database

14943

MS Access Question / Multiple Find and Replace Based on Another Table

by: Daniel | last post by:

I use an Access database to basically take data exports, import them, manipulate the data, and then turn them into exportable reports. I do this using numerous macros, and queries to get the data in the format that I need it in order to create the reports that we use. So far this has proven to be successful for the reports that I am doing and the data that I am pulling into it. I just have one challenge that may require a lot of work and I...

Microsoft Access / VBA

2284

Updating rows in a table - HELP, I'm beating my head against the wall.

by: Laura | last post by:

Here's the situation: I'm trying to use an update query to copy data from one row to another. Here is the situation: I have 5 companies that are linked to each other. I need to show all 5 companies on a form. 3 of the companies have common employees. I have a table that looks like this:

Microsoft Access / VBA

7021

Normal Distribution Table and Graph

by: atahim | last post by:

I have a query in my database that calculates '# of Days' based on a start and end date and displays it amongst other fields. What i need to do now is develop another query that will give me the following 2 columns: #ofDays Normal Distribution

Microsoft Access / VBA

18819

DAO recordset append single record locks entire table (linked table)

by: RayPower | last post by:

I'm having problem with using DAO recordset to append record into a table and subsequent code to update other tables in a transaction. The MDB is Access 2000 with the latest service pack of JET 4. The system is client/server, multiusers based. The MDBs are using record locking. Here is part of the code: Dim wkSpace As Workspace, db As Database Dim rstTrans As DAO.Recordset Set wkSpace = DBEngine.Workspaces(0)

Microsoft Access / VBA

3118

Distribution Report - Should a pivot table be used?

by: kabradley | last post by:

Hello, Thanks for looking at my post and hopefully having an answer or at least a suggestion to my problem. I currently work at a financial planning office that deals with many clients and accounts. Each client may have multiple accounts such as an individual, IRA, and possibly a joint tenant account. Each one of these accounts for the particular client is contained in a 'Portfolio'. For example, Joe Smith may have 3 accounts: Joe Smith...

Microsoft Access / VBA

4548

Searching in detail table to find master record

by: john | last post by:

In my form I have a master table and a details table linked 1xM. I can search through the whole parent table but I also like to be able to search through the child table fields to find parent records. Should I design a new form for this or can I somehow make this work in the same form. Thanks in advance, john

Microsoft Access / VBA

1766

Getting ID from a presented table

by: Lennart Anderson | last post by:

I'm having a MySQl table wih a lot of information. I want to present some main fields in a table on one page. Each record do, of course, have a unique ID. The presnted table will have one field as a linked field. I want to be able to click this link, retreive the ID information for that record and then present detailed data for that record on the next page. How do I retreive the ID? Any hints are very much appreciated. Thanks

PHP

2566

Update table through form

by: Margie | last post by:

Hello again After getting great help perfecting my little Access 2007 movies database, I've stumbled upon an inconvenience. In my opinion it seems basic, but still I'm not able to solve it. As an example, in my form I have two fields (Production & Distribution). These are linked to 1 table (Companies). Now each time I want to enter a new company, I have to do so manually in the table. What I would like is to be able to enter the new name in...

Microsoft Access / VBA

9730

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

10403

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

9208

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

6893

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

5555

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

5693

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

4341

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

3868

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

3020

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General