Do you use the ZFS file system for any of your Oracle databases?
No idea or not applicable
Answer and see the results
DBA Top 10
1 M. Cadot 89300
2 T. Boles 39150
3 B. Vroman 37400
4 A. Kavsek 35100
5 P. Wisse 22600
6 J. PĂ©ran 16800
7 A. Khan 14500
8 A. Hudspith 14450
9 K. Subramaniam 13500
10 Y. Naguib 13300
Download PLATO
The free tool for auditing and tuning your database
Version 54 now available

Sep 04, 2014
(recommended update: build 1403)
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered47039
Total active users29566
Act. users last 24h41
Act. users last hour3
Hits last week1796
Hits last month8584
Latest Forum Threads
basicfile to securefile lob conversion using dbms_redefinition SLOOOOOW

One big table (8Tb), no PK.
dbms_redefinition started, using rowId, to convert lobs.
On day 1... (5 repl.)
Corrupt data file - Root cause

Hi all,

We had some issues with corrupt data blocks (fractures) on one of our customer sites rece... (1 repl.)
Full table scan despite of unique index

The following query performs a full table scan causing physical i/o peaks:

SELECT id, uniqueid, b... (11 repl.)
How to improve create foreign key

Hi guys!!

As I can improve the creation of foreign keys I have the following:

parent table: 9... (2 repl.)
how to restore db with excluded TS - SE1

I have a db with several database.
rman is configured to exclude e.g. TS1 from backup, backup ... (5 repl.)
Oracle license details


How to find Oracle Licensing details for a database?

This information is needed for estima... (6 repl.)
identify ASM databases using OEM

Hi All ,

I have 200 databases added in my OEM repository. In that , some of the db's are RAC, ST... (1 repl.)
--> Start a new thread ...
How do you like the ZFS file system?
No experiences yet!!!
No Solaris, so no experience.
We are planning to use it.
We have SPARC T5-4 servers but we are not using ZFS for our file syste...
We have Solaris based servers but ZFS no never used it.
Not even on the horizon.
Haven't used this type of Advanced File System even though we have Sol...