|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
how can i know host name using sql id or sid oracle 10g rac 10.2.0.4, windows server 2008 64 bit |
19 |
12201 |
Wed, 18 July 2012 13:43 By: alan.kendall@nfl.com ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Oracle process exceed SGA_MAX_TARGET Oracle database 11g R2,Windows 2008 server |
2 |
3601 |
Tue, 17 July 2012 21:21 By: alan.kendall@nfl.com ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
How to Tune my SQL (5 merged) 10.2.0.3.0 |
4 |
3578 |
Mon, 16 July 2012 08:31 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
![icon5.gif](/forum/images/message_icons/icon5.gif) |
Response very slow oracle database 10g By: hielh on Thu, 31 May 2012 |
8 |
7054 |
Fri, 13 July 2012 19:44 By: alan.kendall@nfl.com ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Big database migration |
4 |
3946 |
Fri, 13 July 2012 15:45 By: majstoru ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
The percentage of time spent by sessions waiting on redo operations |
11 |
6300 |
Thu, 12 July 2012 13:01 By: BeefStu ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
DBA performance tools Oracle 10g |
4 |
2802 |
Thu, 12 July 2012 00:57 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Oracle 10g showing problem with index (2 Merged) 10g |
22 |
8245 |
Wed, 11 July 2012 10:11 By: avaquestions ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Elapsed time 11.2.0.2 , Linux |
16 |
9851 |
Wed, 11 July 2012 09:50 By: LNossov ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
DB time in AWR Report - (CPU time,I/O and waits)? Oracle 10.2.0.4 |
3 |
8617 |
Tue, 10 July 2012 01:04 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Force Index Unique Scan Oracle 10g 10.2.0.4 HP-UX |
19 |
19423 |
Sun, 08 July 2012 20:32 By: rleishman ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
where fiter result rows save before join and grop by operation? oracle 10g 10.2.0.1 |
11 |
5764 |
Sun, 08 July 2012 04:53 By: John Watson ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
![icon9.gif](/forum/images/message_icons/icon9.gif) |
DB file sequential read (9 merged) oracle 10g |
5 |
8391 |
Sat, 07 July 2012 01:43 By: John Watson ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
DB_BLOCK_SIZE ORACLE 11GR2 SOLARIS |
14 |
11793 |
Fri, 06 July 2012 03:06 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Query running slow 11.2.0.2.5 , Solaris 10 |
1 |
2742 |
Thu, 05 July 2012 17:08 By: BlackSwan ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
How to find out who is the locking SQL statement? Oracle Database 11g Release 11.2.0.1.0 - 64bit Production |
13 |
5984 |
Wed, 04 July 2012 13:16 By: Andrey_R ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Investigating sudden Temp Tablespace growth from AWR? Oracle 10.2.0.4 |
0 |
3473 |
Wed, 04 July 2012 05:24 By: orapratap ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
use_hash hint without arguments Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit |
3 |
3237 |
Wed, 04 July 2012 01:52 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
partition pruning oracle 10.2 |
2 |
3875 |
Tue, 03 July 2012 06:44 By: guddu_12 ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Slow db performance on Oracle 11.2.0.3 Oracle 11.2.0..3, Linux |
6 |
21585 |
Mon, 02 July 2012 11:28 By: LNossov ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
SGA related queries Oracle 10.1.0.2.0 |
4 |
3592 |
Sat, 30 June 2012 01:50 By: charuamit ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
tools for monitoring the load of the db oracle 10g By: crocuta on Fri, 03 December 2010 |
4 |
3771 |
Fri, 29 June 2012 21:24 By: alan.kendall@nfl.com ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Performance issue Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 ,Windows XP |
6 |
3231 |
Fri, 29 June 2012 02:22 By: John Watson ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
how to reduce dml locks? oracle 11.2.0.1.0,windows server 2008 R2 |
6 |
5005 |
Thu, 28 June 2012 23:22 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Tuning Queries Oracle 10.1.0.2 |
13 |
5534 |
Thu, 28 June 2012 15:44 By: alan.kendall@nfl.com ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
redo size Oracle version 11.2.0.2.0, OS AIX basedSystems(64 bit) |
18 |
10674 |
Thu, 28 June 2012 14:29 By: BlackSwan ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Value for sga_target Oracle 10.2.0.4.0 on AIX 5.3 |
8 |
7883 |
Wed, 27 June 2012 23:15 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
a table deleted or updated frequency issue |
8 |
4591 |
Wed, 27 June 2012 19:09 By: alan.kendall@nfl.com ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Outer join causes much slower performance |
3 |
2898 |
Wed, 27 June 2012 10:00 By: BlackSwan ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
performance improvement of clob data oracle 10.2.0.5 solaris 64 bit |
1 |
2895 |
Tue, 26 June 2012 07:04 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
SGA related queries |
1 |
3094 |
Mon, 25 June 2012 05:12 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
what's the relationship between the number of blocks and consistent gets ? By: lonion on Wed, 20 June 2012 |
4 |
5733 |
Fri, 22 June 2012 20:15 By: BlackSwan ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
SQL Tuning Help oracle 11g |
11 |
21999 |
Fri, 22 June 2012 08:52 By: thalladas ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Reg Awrrpt report in oracle database oracle 10.2.0.2.0 |
1 |
3351 |
Thu, 21 June 2012 07:04 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
How to determine the system memory usage by oracle processes Solaris 10 |
6 |
4090 |
Wed, 20 June 2012 15:26 By: getzeeshan ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Oracle (HP-UX) connection very slow from Windows client Oracle 9.2.0.7 installed on HP-UX |
13 |
6360 |
Wed, 20 June 2012 11:19 By: bobbydurrettdba ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
How can i trace a different from current session with LEVEL 4? Oracle Database 10g Enterprise (RAC) Edition Release 10.2.0.4.0 - 64bit, LINUX |
8 |
3710 |
Wed, 20 June 2012 02:16 By: Andrey_R ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
"px send round-robin " |
1 |
3925 |
Tue, 19 June 2012 17:08 By: BlackSwan ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Creation of Index |
4 |
4338 |
Tue, 19 June 2012 11:27 By: Jack14 ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
PL/SQL Block (LOOP) Comparison Oracle 10gR2 10.2.0.5, AIX 6.1 |
4 |
2988 |
Tue, 19 June 2012 02:01 By: Rektanocrit ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |