Do you use the ASR (Automatic Service Request) functionality in any of your Oracle servers?
Yes, it works very well
Yes, but I am not too satisfied with it
No, we don't have Oracle hardware
No idea or not applicable
Answer and see the results
DBA Top 10
1 M. Cadot 78150
2 A. Kavsek 43600
3 T. Boles 40950
4 B. Vroman 37700
5 P. Wisse 26000
6 K. Subramaniam 19300
7 J. Schnackenberg 17800
8 J. PĂ©ran 17550
9 A. Khan 13250
10 F. Pachot 10950
Download PLATO
The free tool for auditing and tuning your database
Version 55 now available

Feb 05, 2015
(recommended update: build 1443)
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered47236
Total active users29758
Act. users last 24h34
Act. users last hour4
Hits last week1272
Hits last month4976
Tips, Scripts, Papers, Events, Links, ...
Tip:ORAchk new version is out.

Adam Hudspith, Mar 24
Link:Oracle sgadef file info

Karthick T, Mar 10
Paper:SYSAUX Tablespace Bloated

Shakti Agarwal, Feb 24
Paper:Oracle 12c install issues and troubleshooting

Karthick T, Jan 27
Paper:Unable to start the database instance due to locks placed on Control & Data Files

Shakti Agarwal, Jan 20
Latest Forum Threads
Replace string in the query

Hi All,

I have table with below structure.

Sl No Name
1 Sathish
2 suresh
3 sur... (6 repl.)
SQL question - lost and confused - some guidance please


I am trying to 'help' some developer do some SQL performance tuning on his SQL and a bit stum... (3 repl.)
Register Listener in Cluster

I have recently created 2-Node ORACLE RAC.But created no listener for Database,as per the dafaul... (1 repl.)
SQL Advisor Report


I trying to take sql advisor report for sql_id but it failed with below error. Please suggest... (4 repl.)
How to delete and add node in oracle 11g r2

Hello Friends,

We have two node( rac database with asm.
we are facing issue with one no... (1 repl.)
awr report analysis

Hi Guys

I experienced a situation where we have high wait average on log file switch (checkpoint ... (12 repl.)
impdp is thorughing error while creating triggers,have around 2000 triggers.So unable to recreate

impdp is thorughing error while creating triggers,have around 2000 triggers.So unable to recreate:
... (2 repl.)
--> Start a new thread ...
What do you think of the Ask Toolbars you can select during Java install?
Never install ask toolbar.
We do not install ask toolbar.
haha. Maybe I should put this on my facebook page: https://www.chan...
I hate to install this. Oracle should remove this kind of toolbars. ...
If you want to be a shady, obscure supplier instead of a respectful on...
I think it's hateful.
I never install toolbars. They claim space on the screen which is very...