Blog
Search
Help
Members
Register
Login
Home
Home
»
RDBMS Server
»
Performance Tuning
Show:
Today's Messages
::
Unanswered Messages
::
Polls
::
Message Navigator
Please read the
OraFAQ Forum Guide
before posting.
Please contribute good answers to the
wiki
.
UNION and UNION ALL discrepancy
By:
bijou
on Fri, 01 August 2008 09:47
Re: UNION and UNION ALL discrepancy
By:
Mahesh Rajendran
on Fri, 01 August 2008 09:53
Re: UNION and UNION ALL discrepancy
By:
bijou
on Fri, 01 August 2008 10:07
Re: UNION and UNION ALL discrepancy
By:
Michel Cadot
on Fri, 01 August 2008 10:20
Re: UNION and UNION ALL discrepancy
By:
Michel Cadot
on Fri, 01 August 2008 10:06
Re: UNION and UNION ALL discrepancy
By:
bijou
on Fri, 01 August 2008 10:10
Re: UNION and UNION ALL discrepancy
By:
joy_division
on Fri, 01 August 2008 12:59
Re: UNION and UNION ALL discrepancy
By:
Frank
on Fri, 01 August 2008 14:12
Re: UNION and UNION ALL discrepancy
By:
rleishman
on Sun, 03 August 2008 21:45
Re: UNION and UNION ALL discrepancy
By:
bijou
on Mon, 04 August 2008 03:43
Re: UNION and UNION ALL discrepancy
By:
Michel Cadot
on Mon, 04 August 2008 03:45
Re: UNION and UNION ALL discrepancy
By:
bijou
on Wed, 06 August 2008 06:10
Re: UNION and UNION ALL discrepancy
By:
rleishman
on Thu, 07 August 2008 21:52
Re: UNION and UNION ALL discrepancy
By:
bijou
on Mon, 04 August 2008 03:39
Index is used still problem
By:
bubbly
on Wed, 06 August 2008 17:43
Re: Index is used still problem
By:
BlackSwan
on Wed, 06 August 2008 17:52
Re: Index is used still problem
By:
bubbly
on Wed, 06 August 2008 18:05
Re: Index is used still problem
By:
BlackSwan
on Wed, 06 August 2008 18:12
Re: Index is used still problem
By:
rleishman
on Wed, 06 August 2008 22:27
Re: Index is used still problem
By:
sunil_v_mishra
on Thu, 07 August 2008 03:36
How to estimate query response time and number of rows without executing q...
By:
gkodakalla
on Thu, 07 August 2008 02:08
Re: How to estimate query response time and number of rows without executi...
By:
Michel Cadot
on Thu, 07 August 2008 02:14
Re: How to estimate query response time and number of rows without executi...
By:
gkodakalla
on Thu, 07 August 2008 02:19
Re: How to estimate query response time and number of rows without executi...
By:
Michel Cadot
on Thu, 07 August 2008 02:41
Re: How to estimate query response time and number of rows without executi...
By:
gkodakalla
on Thu, 07 August 2008 02:52
need assist to delete histograms
By:
kumar.joy
on Wed, 06 August 2008 11:49
Re: need assist to delete histograms
By:
BlackSwan
on Wed, 06 August 2008 11:52
Re: need assist to delete histograms
By:
Mahesh Rajendran
on Wed, 06 August 2008 12:09
Help me tune the query
By:
thalladas
on Wed, 06 August 2008 11:17
Re: Help me tune the query
By:
BlackSwan
on Wed, 06 August 2008 11:19
How gathering of stats/ analyze stats work?
By:
beetel
on Wed, 06 August 2008 06:23
Re: How gathering of stats/ analyze stats work?
By:
Michel Cadot
on Wed, 06 August 2008 06:55
Re: How gathering of stats/ analyze stats work?
By:
beetel
on Wed, 06 August 2008 07:11
Re: How gathering of stats/ analyze stats work?
By:
Michel Cadot
on Wed, 06 August 2008 08:40
Re: How gathering of stats/ analyze stats work?
By:
BlackSwan
on Wed, 06 August 2008 08:48
sql consumes more cpu
By:
guyj
on Wed, 06 August 2008 01:21
Re: sql consumes more cpu
By:
guyj
on Wed, 06 August 2008 01:24
Re: sql consumes more cpu
By:
Michel Cadot
on Wed, 06 August 2008 02:04
Re: sql consumes more cpu
By:
rajatratewal
on Wed, 06 August 2008 05:09
Re: sql consumes more cpu
By:
guyj
on Wed, 06 August 2008 05:48
Re: sql consumes more cpu
By:
rajatratewal
on Wed, 06 August 2008 05:56
to decide pctused,pctfree in Oracle8i (merged)
By:
chinmayikkalki
on Wed, 06 August 2008 03:02
Re: Pctused,pctfree
By:
Michel Cadot
on Wed, 06 August 2008 03:07
to decide pctused,pctfree in Oracle8i
By:
chinmayikkalki
on Wed, 06 August 2008 03:57
Re: to decide pctused,pctfree in Oracle8i
By:
Michel Cadot
on Wed, 06 August 2008 04:11
buffer cache handles
By:
holdersav2000
on Tue, 05 August 2008 09:16
Re: buffer cache handles
By:
Michel Cadot
on Tue, 05 August 2008 10:19
Re: buffer cache handles
By:
holdersav2000
on Tue, 05 August 2008 10:26
Re: buffer cache handles
By:
BlackSwan
on Tue, 05 August 2008 10:32
Re: buffer cache handles
By:
holdersav2000
on Tue, 05 August 2008 11:06
Re: buffer cache handles
By:
BlackSwan
on Tue, 05 August 2008 11:40
Re: buffer cache handles
By:
holdersav2000
on Wed, 06 August 2008 02:17
selectivity in index usage
By:
krshnn592
on Tue, 05 August 2008 09:48
Re: selectivity in index usage
By:
Michel Cadot
on Tue, 05 August 2008 10:18
Re: selectivity in index usage
By:
krshnn592
on Tue, 05 August 2008 10:35
Re: selectivity in index usage
By:
Michel Cadot
on Tue, 05 August 2008 10:50
QUERY REWRITING
By:
jayarajkrishna
on Sun, 03 August 2008 04:57
Re: QUERY REWRITING
By:
Michel Cadot
on Sun, 03 August 2008 04:59
Re: QUERY REWRITING
By:
JRowbottom
on Tue, 05 August 2008 08:24
DB link query.
By:
sonumalhi
on Mon, 04 August 2008 16:18
Re: DB link query.
By:
BlackSwan
on Mon, 04 August 2008 16:26
Merging large amounts of data into large tables
By:
zzasteven
on Mon, 04 August 2008 12:49
Re: Merging large amounts of data into large tables
By:
BlackSwan
on Mon, 04 August 2008 13:08
Re: Merging large amounts of data into large tables
By:
zzasteven
on Mon, 04 August 2008 13:54
Re: Merging large amounts of data into large tables
By:
Michel Cadot
on Mon, 04 August 2008 13:47
Re: Merging large amounts of data into large tables
By:
zzasteven
on Mon, 04 August 2008 13:56
Re: Merging large amounts of data into large tables
By:
BlackSwan
on Mon, 04 August 2008 13:59
Re: Merging large amounts of data into large tables
By:
zzasteven
on Mon, 04 August 2008 14:04
Need suggestion for a better query.
By:
pravin3032
on Tue, 22 July 2008 07:39
Re: Need suggestion for a better query.
By:
rleishman
on Wed, 23 July 2008 03:19
Re: Need suggestion for a better query.
By:
pravin3032
on Mon, 28 July 2008 09:01
Re: Need suggestion for a better query.
By:
rleishman
on Mon, 28 July 2008 22:20
Re: Need suggestion for a better query.
By:
pravin3032
on Tue, 29 July 2008 05:53
Re: Need suggestion for a better query.
By:
rleishman
on Tue, 29 July 2008 21:58
Re: Need suggestion for a better query.
By:
pravin3032
on Mon, 04 August 2008 07:27
SQL Tuning Methods & Books
By:
oraclegyaani
on Sun, 03 August 2008 11:17
Re: SQL Tuning Methods & Books
By:
Michel Cadot
on Sun, 03 August 2008 11:51
CREATE TABLE using SEQUENCE
By:
ravashingravi
on Sat, 02 August 2008 02:49
Re: CREATE TABLE using SEQUENCE
By:
Michel Cadot
on Sat, 02 August 2008 02:58
Re: CREATE TABLE using SEQUENCE
By:
sunil_v_mishra
on Sat, 02 August 2008 15:26
Re: CREATE TABLE using SEQUENCE
By:
Michel Cadot
on Sun, 03 August 2008 01:48
statspack report
By:
manoj12
on Thu, 31 July 2008 08:40
Re: statspack report
By:
Michel Cadot
on Thu, 31 July 2008 08:51
Re: statspack report
By:
manoj12
on Thu, 31 July 2008 09:22
Re: statspack report
By:
sunil_v_mishra
on Fri, 01 August 2008 00:45
Re: statspack report
By:
BlackSwan
on Fri, 01 August 2008 00:50
Re: statspack report
By:
manoj12
on Fri, 01 August 2008 01:47
Re: statspack report
By:
manoj12
on Fri, 01 August 2008 03:44
Re: statspack report
By:
sunil_v_mishra
on Sat, 02 August 2008 15:12
Re: statspack report
By:
Michel Cadot
on Sun, 03 August 2008 01:40
HIGH no of LOCKS exclusive in tables for UPDATE Statement
By:
udara
on Mon, 21 July 2008 03:23
Re: HIGH no of LOCKS exclusive in tables for UPDATE Statement
By:
Michel Cadot
on Mon, 21 July 2008 03:48
Re: HIGH no of LOCKS exclusive in tables for UPDATE Statement
By:
sunil_v_mishra
on Sat, 02 August 2008 16:12
Re: HIGH no of LOCKS exclusive in tables for UPDATE Statement
By:
Kevin Meade
on Sat, 02 August 2008 20:59
criteria for partitioning
By:
eaganfox
on Tue, 22 July 2008 23:07
Re: criteria for partitioning
By:
BlackSwan
on Tue, 22 July 2008 23:13
Re: criteria for partitioning
By:
Michel Cadot
on Tue, 22 July 2008 23:34
Re: criteria for partitioning
By:
eaganfox
on Fri, 25 July 2008 09:37
Re: criteria for partitioning
By:
sunil_v_mishra
on Fri, 01 August 2008 00:30
Re: criteria for partitioning
By:
Michel Cadot
on Fri, 01 August 2008 01:24
Adding INDEX_DESC hint slow down the query
By:
shrinika
on Mon, 28 July 2008 10:38
Re: Adding INDEX_DESC hint slow down the query
By:
sunil_v_mishra
on Mon, 28 July 2008 13:11
Re: Adding INDEX_DESC hint slow down the query
By:
rleishman
on Mon, 28 July 2008 22:04
Re: Adding INDEX_DESC hint slow down the query
By:
shrinika
on Thu, 31 July 2008 13:28
Report hangs
By:
srini_thiru
on Thu, 31 July 2008 05:40
Re: Report hangs
By:
BlackSwan
on Thu, 31 July 2008 08:57
Performance issues after Database Hang during backup
By:
virmahi
on Mon, 28 July 2008 07:01
Re: Performance issues after Database Hang during backup
By:
Mahesh Rajendran
on Mon, 28 July 2008 09:00
Re: Performance issues after Database Hang during backup
By:
sunil_v_mishra
on Mon, 28 July 2008 13:38
Re: Performance issues after Database Hang during backup
By:
Mahesh Rajendran
on Mon, 28 July 2008 15:03
Re: Performance issues after Database Hang during backup
By:
sunil_v_mishra
on Mon, 28 July 2008 15:32
Re: Performance issues after Database Hang during backup
By:
Mahesh Rajendran
on Mon, 28 July 2008 17:06
Re: Performance issues after Database Hang during backup
By:
virmahi
on Thu, 31 July 2008 03:33
Re: Performance issues after Database Hang during backup
By:
Mahesh Rajendran
on Thu, 31 July 2008 06:28
ora-04030
By:
srini_thiru
on Fri, 25 July 2008 02:11
Re: ora-04030
By:
Michel Cadot
on Fri, 25 July 2008 02:24
Re: ora-04030
By:
srini_thiru
on Fri, 25 July 2008 03:19
Re: ora-04030
By:
sunil_v_mishra
on Mon, 28 July 2008 14:26
Re: ora-04030
By:
hristo
on Fri, 25 July 2008 02:45
Re: ora-04030
By:
srini_thiru
on Fri, 25 July 2008 02:58
Re: ora-04030
By:
Michel Cadot
on Fri, 25 July 2008 03:18
Re: ora-04030
By:
srini_thiru
on Thu, 31 July 2008 05:35
Re: ora-04030
By:
Michel Cadot
on Thu, 31 July 2008 05:42
Reverse key index
By:
getritesh
on Tue, 29 July 2008 04:07
Re: Reverse key index
By:
Michel Cadot
on Tue, 29 July 2008 04:29
Re: Reverse key index
By:
getritesh
on Tue, 29 July 2008 05:24
Re: Reverse key index
By:
rleishman
on Tue, 29 July 2008 22:03
Re: Reverse key index
By:
getritesh
on Wed, 30 July 2008 03:21
Re: Reverse key index
By:
sunil_v_mishra
on Wed, 30 July 2008 16:45
Re: Reverse key index
By:
getritesh
on Wed, 30 July 2008 21:36
Re: Reverse key index
By:
rleishman
on Wed, 30 July 2008 22:52
Re: Reverse key index
By:
BlackSwan
on Wed, 30 July 2008 22:31
Performance
By:
manoj12
on Thu, 24 July 2008 05:35
Re: Performance
By:
Mahesh Rajendran
on Thu, 24 July 2008 07:04
Re: Performance
By:
manoj12
on Thu, 24 July 2008 07:08
Re: Performance
By:
Mahesh Rajendran
on Thu, 24 July 2008 07:11
Re: Performance
By:
manoj12
on Thu, 24 July 2008 07:17
Re: Performance
By:
manoj12
on Fri, 25 July 2008 04:15
Re: Performance
By:
rleishman
on Fri, 25 July 2008 07:45
Re: Performance
By:
manoj12
on Tue, 29 July 2008 00:02
Re: Performance
By:
rleishman
on Tue, 29 July 2008 22:09
Stale Statisics
By:
rsreddy28
on Tue, 29 July 2008 04:58
Re: Stale Statisics
By:
Michel Cadot
on Tue, 29 July 2008 05:24
gather stats
By:
ArvindBhope
on Tue, 29 July 2008 00:23
Re: gather stats
By:
Michel Cadot
on Tue, 29 July 2008 01:11
Re: gather stats
By:
ArvindBhope
on Tue, 29 July 2008 02:37
Re: gather stats
By:
Michel Cadot
on Tue, 29 July 2008 03:19
Tuning 'LIKE' Clause
By:
getritesh
on Mon, 28 July 2008 12:48
Re: Tuning 'LIKE' Clause
By:
sunil_v_mishra
on Mon, 28 July 2008 13:59
Re: Tuning 'LIKE' Clause
By:
Michel Cadot
on Mon, 28 July 2008 14:24
type tables in plsql/ variable IN list
By:
eaganfox
on Fri, 25 July 2008 09:25
Re: type tables in plsql/ variable IN list
By:
szogu
on Fri, 25 July 2008 09:34
Re: type tables in plsql/ variable IN list
By:
eaganfox
on Fri, 25 July 2008 09:36
Re: type tables in plsql/ variable IN list
By:
coleing
on Fri, 25 July 2008 17:54
need help to optimize the query
By:
skumar.dba
on Wed, 23 July 2008 19:16
Re: need help to optimize the query
By:
rleishman
on Thu, 24 July 2008 22:26
need assistance to tune the query
By:
kumar.joy
on Thu, 24 July 2008 11:56
Re: need assistance to tune the query
By:
Michel Cadot
on Thu, 24 July 2008 12:22
Re: need assistance to tune the query
By:
kumar.joy
on Thu, 24 July 2008 12:44
Re: need assistance to tune the query
By:
Michel Cadot
on Thu, 24 July 2008 12:55
Re: need assistance to tune the query
By:
kumar.joy
on Thu, 24 July 2008 13:07
Re: need assistance to tune the query
By:
Michel Cadot
on Thu, 24 July 2008 13:17
Re: need assistance to tune the query
By:
BlackSwan
on Thu, 24 July 2008 12:48
Re: need assistance to tune the query
By:
BlackSwan
on Thu, 24 July 2008 14:48
Re: need assistance to tune the query
By:
rleishman
on Thu, 24 July 2008 22:22
Testing of generated test data from Sequence
By:
sreechaitu
on Thu, 24 July 2008 13:01
Re: Testing of generated test data from Sequence
By:
BlackSwan
on Thu, 24 July 2008 13:08
how find SGA size is sufficient or not?
By:
skumar.dba
on Tue, 22 July 2008 17:46
Re: how find SGA size is sufficient or not?
By:
BlackSwan
on Tue, 22 July 2008 17:50
Re: how find SGA size is sufficient or not?
By:
Michel Cadot
on Tue, 22 July 2008 23:36
Re: how find SGA size is sufficient or not?
By:
sunil_v_mishra
on Wed, 23 July 2008 08:07
Re: how find SGA size is sufficient or not?
By:
Michel Cadot
on Wed, 23 July 2008 08:14
Re: how find SGA size is sufficient or not?
By:
sunil_v_mishra
on Wed, 23 July 2008 13:17
Re: how find SGA size is sufficient or not?
By:
Michel Cadot
on Wed, 23 July 2008 13:31
Re: how find SGA size is sufficient or not?
By:
sunil_v_mishra
on Thu, 24 July 2008 01:11
Re: how find SGA size is sufficient or not?
By:
Michel Cadot
on Thu, 24 July 2008 01:44
Is possible to turn the following into a view
By:
bztom33
on Mon, 21 July 2008 11:53
Re: Is possible to turn the following into a view
By:
BlackSwan
on Mon, 21 July 2008 11:55
Re: Is possible to turn the following into a view
By:
Kevin Meade
on Mon, 21 July 2008 14:51
Re: Is possible to turn the following into a view
By:
bztom33
on Wed, 23 July 2008 16:00
Re: Is possible to turn the following into a view
By:
Kevin Meade
on Wed, 23 July 2008 16:03
high cost
By:
balaji1482
on Thu, 17 July 2008 13:25
Re: high cost
By:
BlackSwan
on Thu, 17 July 2008 13:29
Re: high cost
By:
alanm
on Thu, 17 July 2008 14:18
Re: high cost
By:
balaji1482
on Thu, 17 July 2008 17:22
Re: high cost
By:
rsoma
on Fri, 18 July 2008 01:12
Re: high cost
By:
balaji1482
on Fri, 18 July 2008 17:17
Re: high cost
By:
BlackSwan
on Fri, 18 July 2008 17:22
Re: high cost
By:
balaji1482
on Fri, 18 July 2008 19:10
Re: high cost
By:
BlackSwan
on Fri, 18 July 2008 19:29
Re: high cost
By:
balaji1482
on Sat, 19 July 2008 09:58
Re: high cost
By:
Michel Cadot
on Sat, 19 July 2008 10:00
Re: high cost
By:
JRowbottom
on Mon, 21 July 2008 06:25
Re: high cost
By:
balaji1482
on Wed, 23 July 2008 10:28
Avoiding : ORA-00470: LGWR process terminated with error
By:
Josphat Kioko
on Tue, 12 October 2004 04:56
Re: Avoiding : ORA-00470: LGWR process terminated with error
By:
sunil_v_mishra
on Wed, 23 July 2008 07:54
performance issues in insert stmt
By:
jyothsna1612
on Wed, 23 July 2008 05:09
Re: performance issues in insert stmt
By:
Michel Cadot
on Wed, 23 July 2008 05:28
Slow query with customer data
By:
elmu
on Thu, 17 July 2008 09:03
Re: Slow query with customer data
By:
alanm
on Thu, 17 July 2008 10:15
Re: Slow query with customer data
By:
rleishman
on Sun, 20 July 2008 21:57
Re: Slow query with customer data
By:
elmu
on Mon, 21 July 2008 07:30
Re: Slow query with customer data
By:
Kriptas
on Mon, 21 July 2008 11:22
Re: Slow query with customer data
By:
rleishman
on Mon, 21 July 2008 22:36
Re: Slow query with customer data
By:
MartinMM
on Tue, 22 July 2008 03:35
Re: Slow query with customer data
By:
elmu
on Tue, 22 July 2008 07:07
Re: Slow query with customer data
By:
Kriptas
on Tue, 22 July 2008 13:19
Better way to handle this query?
By:
Olivia
on Tue, 22 July 2008 06:38
Re: Better way to handle this query?
By:
Michel Cadot
on Tue, 22 July 2008 06:45
Re: Better way to handle this query?
By:
Olivia
on Tue, 22 July 2008 06:53
Re: Better way to handle this query?
By:
Olivia
on Tue, 22 July 2008 08:45
Re: Better way to handle this query?
By:
tahpush
on Tue, 22 July 2008 06:46
Re: Better way to handle this query?
By:
BlackSwan
on Tue, 22 July 2008 11:00
optimize queries
By:
acarella
on Fri, 18 July 2008 10:59
Re: optimize queries
By:
BlackSwan
on Fri, 18 July 2008 11:02
Re: optimize queries
By:
Kevin Meade
on Sat, 19 July 2008 01:50
Re: optimize queries
By:
acarella
on Mon, 21 July 2008 07:30
Re: optimize queries
By:
michael_bialik
on Tue, 22 July 2008 08:30
Pages (119): [
«
‹
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
›
»
]
Goto Forum:
- SQL & PL/SQL
SQL & PL/SQL
- RDBMS Server
Server Administration
Backup & Recovery
Performance Tuning
Security
Networking and Gateways
Enterprise Manager
Server Utilities
- Server Options
RAC & Failsafe
Data Guard
Replication
Streams & AQ
Spatial
Text & interMedia
Multitenant
- Developer & Programmer
Application Express, ORDS & MOD_PLSQL
Forms
Reports & Discoverer
Designer
JDeveloper, Java & XML
Data Integration
Precompilers, OCI & OCCI
- Fusion Middleware & Colab Suite
Weblogic & Application Server
Business Intelligence
WebCenter Suite & Portal
Collaboration & Content Management
SOA Suite, BPEL and OWSM
- Applications
Oracle Fusion Apps & E-Business Suite
PeopleSoft, JD Edwards & Siebel
Primavera
Other Application Suites
- Infrastructure
Cloud and Hosting
Hardware
Linux
Unix
Windows
Other Operating Systems
- Open Source
Programming Interfaces
MySQL
NoSQL
- Other
General
Training & Certification
Client Tools
Marketplace
Community Hangout
News & Blogs
Suggestions & Feedback
Test
- Non-English Forums
Arabic
Dutch
French
German
Japanese
Portuguese
Russian
Spanish
[
Syndicate this forum (XML)
] [
]
Legend
New Messages
No New messages
Locked (w/ unread messages)
Locked
Moved to another forum
Current Time:
Fri Jul 05 14:01:34 CDT 2024