Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Read Statistics

Status
Not open for further replies.
Palmero

Palmero

Technical User
Mar 31, 2001
53
0
0
FR
Hi all,

When analyzing statistics for an Oracle 8i request, what is the significance of following parameters :
- physical reads
- block get
- consistent gets
- blocks changes
- consistent changes
- buffers get in trace optimisations

How are the following parameters used :
- block buffers = 12288
- block size = 8K

How can we interpret the result "number of db_files too high"?

Thanks in advance for your help.

Palmero.
 
Status
Not open for further replies.

Similar threads

BJoy
  • Locked
  • Question
How can I read XML data in Oracle.
Replies
0
Views
38
BJoy
BJoy
ettienne
  • Locked
  • Question
ORA-16000: database open for read-only access
Replies
7
Views
150
ettienne
ettienne
Gonfer
  • Locked
  • Question
How to Detect old tables not currently read
Replies
4
Views
28
stefanhei
stefanhei
Andrzejek
  • Locked
  • Question
Read xml file into SP 1
Replies
2
Views
44
Andrzejek
Andrzejek
dtoronto
  • Locked
  • Question
XML stored in CLOB - repeating Nodes - how to read?
Replies
1
Views
37
taupirho
taupirho

Part and Inventory Search

Sponsor

Back
Top