Question
Do you use locally managed tablespaces of uniform size extents for data?
No, all tablespaces have autoallocate
Yes, I have uniform size extents
No idea or not applicable
Answer and see the results
DBA Top 10
1 B. Vroman 105200
2 A. Kavsek 71600
3 M. Cadot 66400
4 T. Boles 52750
5 F. Pachot 44000
6 P. Wisse 36700
7 Z. Hudec 33950
8 M. Khokhar 28650
9 A. Chavan 26900
10 A. Preston 22500
About
DBA-Village
Download PLATO
The free tool for auditing and tuning your database
Version 52 now available
Jul 12, 2010
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered44393
Total active users27833
Act. users last 24h41
Act. users last hour3
Hits last week3612
Hits last month16639
Tips, Scripts, Papers, Events, Links, ...
Link:'Use The Index' a guide to database performance

Franck Pachot, Jan 29
Link:Capacity Planning

Denis N, Jan 29
Tip:EM or Oracle Fail Safe

Volim Zagreb, Jan 29
Link:All about the SCN number

Geert De Paep, Jan 22
Paper:Diary on OTN - Developer Day Event (The Claridges, New Delhi)

Vijay Mahawar, Jan 22
Latest Forum Threads
Materialized View error on commit in HR schema

I created materialized view in muser schema based on hr.emps table of hr schema:=>

Muser schema:=... (0 repl.)
Possible to create table to consist of one block only (or is 8 default)

While I was busy doing block dumps of a table,
to check somehting.

noticed that , that Oracle (i... (4 repl.)
DataPump Multiple file in multiple storate volume

Hi All,

I have storage volume of 100GB each for exp or data pump backup. My export file will be h... (2 repl.)
Internal Server Error

While Running the Diagnostic tests for Payables and Geneeal ledger I got the following error.


... (0 repl.)
expdp failed with parallel and query together

Dear Guru's

For performance purpose we have added parallel parameter while taking expdp.

1) I... (4 repl.)
solaries patch update6 for oracle db

i have a Solaris patch update6 to be done for my db,

what are the pre-requisites steps to be tak... (1 repl.)
deleting large amount of data without shutdown db

hi guys,

I need to remove large chunk of data from a table keeping only data that i wanted.

I... (2 repl.)
--> Start a new thread ...
Imho
Do you still have uniform size extent tablespaces?
I use Auto allocate tablespace
We use uniform extent sizes.
In all our implementations we use locally managed tablespaces with aut...
Automatic all the way.
for TS other than TEMP we autoallocate, for TEMP its uniform size manu...
All tablespaces have autoallocate. Regards, Rakesh.V.C
autoallocate

More...