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 82250
2 A. Kavsek 42100
3 T. Boles 35750
4 B. Vroman 32400
5 J. Schnackenberg 31600
6 P. Wisse 25500
7 H. Shahi 15400
8 K. Subramaniam 14200
9 J. PĂ©ran 13950
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 registered47329
Total active users29859
Act. users last 24h23
Act. users last hour1
Hits last week1017
Hits last month5155
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
slow performance - outer join - OR query

hi,
I have tables
a(id RAW(16), modifiedAt timpestamp(4), ...),
b(id RAW(16), aID RAW(16), mod... (0 repl.)
Passing all input param issue to a Trigger which calling a procedure

Dear Team,
Kindly check following example and DDL statements.

CREATE TABLE USERS (USERID INT, US... (0 repl.)
Execute SQL script in 12c OEM

Hi All,

Could you please provide me link/document to create a user define matrix in OEM to execut... (0 repl.)
ORA-01031: insufficient privileges

Hi All,

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


SQL> SHOW ... (4 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.)
--> Start a new thread ...
Imho
How do you use your filesystemio_options?
setall work's best for us !
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.

More...