Why do I not see Oracle database block gets and consistent gets
hi, i have two test scenarios where i’m trying to understand to actual concept of db block gets and consistent gets. SQL> set autotrace on SQL>select * from scott.emp; i get 14 rows then Execution Plan ———————————————————-    0      SELECT STATEMENT Optimizer=ALL_ROWS (Cost=3 Card=14 Bytes=51           8)    1    0   TABLE ACCESS (FULL) OF ‘EMP’ [...]

Answer Question   |  March 31, 2012  4:48 PM
Oracle 10g, Oracle 10g administration, Oracle 10g Database, Oracle 10g performance

How to determine the number of concurrent processes in Oracle 10g
How can I find out the number of concurrent processes at any point of time in 10g database

Answer Question   |  June 9, 2009  10:50 AM
Benchmarking oracle db, Oracle 10g, Oracle 10g administration, Oracle 10g concurrent processes, Oracle 10g performance, Oracle performance