Question
What do you have for "filesystemio_options" (init.ora) for most of your databases?
none
asynch
directio
setall
No idea or not applicable
Answer and see the results
DBA Top 10
1 M. Cadot 82750
2 A. Kavsek 42100
3 T. Boles 35950
4 B. Vroman 33400
5 J. Schnackenberg 31600
6 P. Wisse 25500
7 H. Shahi 15400
8 K. Subramaniam 14200
9 J. PĂ©ran 14150
10 A. Khan 11300
About
DBA-Village
Download PLATO
The free tool for auditing and tuning your database
Version 55 now available
Apr 07, 2015
(recommended update: build 1462)
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered47328
Total active users29857
Act. users last 24h27
Act. users last hour1
Hits last week1184
Hits last month5206
Tips, Scripts, Papers, Events, Links, ...
Tip:retrieving oracle internal information

vijay kaushik, May 19
Link:Oracle 12c new features summary

Karthick T, Apr 21
Paper:Oracle RAC Upgrade from 11.2.0.3 to 11.2.0.4

Shakti Agarwal, Mar 31
Tip:ORAchk new version is out.

Adam Hudspith, Mar 24
Link:Oracle sgadef file info

Karthick T, Mar 10
Latest Forum Threads
ORA-01031: insufficient privileges

Hi All,

We are receiving below error when we query a table with appsselect user.


SQL> SHOW ... (3 repl.)
Data Guard RAC to nonRAC, ASM to non ASM

My boss wants me to setup Data Guard for basic DR between our two offices. We have a 4 node EE RAC c... (4 repl.)
Udev rules - Do we need it or not ?

Hi all,

I read about udev and more or less it is about to have rules to create persistence naming... (2 repl.)
same question--http://www.dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=77122

As last time i asked on this forum.
http://www.dba-village.com/village/dvp_forum.OpenThread?Thread... (2 repl.)
Sql query help to fetch rows as differentcolumns

create table emp
(empid number(10),empname varchar2(20));
insert into emp values(7369,'ABC');

c... (7 repl.)
Migrating from MS SQL Server to Oracle database.

Hello,

Needs Migrate from MS SQLServer to Oracle database.

Could you please help me out in thi... (5 repl.)
MV refresh issue

Hi,

We are facing issue while refresh MV through concurrent program. I have found some indexes ar... (2 repl.)
--> Start a new thread ...
Imho
How do you use your filesystemio_options?
Currently none. I tested setall and it looked OK.
We have set it to setall
Mostly it is set to default
we have checked in all databases, parameter has set to default
Best practice is to use setall for async io and direct i/o There is n...
We leave it default.
we don't set this parameter much in my project, checked few databases ...

More...