Reputation
17,311
Top tag
Next privilege 20,000 Rep.
Access 'trusted user' tools
Badges
9 51 121
Newest
 Yearling
Impact
~2.2m people reached

Nov
5
comment How to filter out the records with the latest date?
What database is this? MYSQL?
Nov
2
awarded  Notable Question
Oct
28
awarded  Necromancer
Oct
26
comment Select performance problems with conditional index vs non-conditional on large volume table
What percentage of the table includes rows with an archived value of N?
Oct
23
comment Automate - recover database using backup controfile
It works, very obvious, and exactly what I was looking for.
Oct
22
comment Automate - recover database using backup controfile
OK, I thought AUTOMATIC was the default, but if that works, it would be awesome.
Oct
20
awarded  Nice Answer
Oct
20
revised Automate - recover database using backup controfile
added 471 characters in body
Oct
20
comment Automate - recover database using backup controfile
That doesn't seem to work. Do I have the syntax wrong? SQL> RECOVER DATABASE UNTIL TIME '2015-10-20:13:54:16' USING BACKUP CONTROLFILE CONTINUE DEFAULT; ORA-00274: illegal recovery option CONTINUE SQL> RECOVER DATABASE UNTIL TIME '2015-10-20:13:54:16' CONTINUE DEFAULT USING BACKUP CONTROLFILE; ORA-00274: illegal recovery option CONTINUE
Oct
19
asked Automate - recover database using backup controfile
Oct
10
awarded  Good Question
Sep
21
awarded  Popular Question
Sep
17
awarded  Necromancer
Sep
15
awarded  Popular Question
Sep
15
awarded  Good Answer
Aug
25
awarded  Famous Question
Aug
21
awarded  Nice Answer
Jul
30
comment Dropping Global Temporary Tables
This is exactly what I was looking for. I generalized your query to look for all locks for GTTs and to do so on RAC. Here is what I am using: SELECT inst_id, sid, username, osuser, machine, terminal, program FROM gv$session WHERE (inst_id, sid) IN (SELECT inst_id, sid FROM gv$lock WHERE type = 'TO');
Jul
30
accepted Dropping Global Temporary Tables
Jul
29
revised Dropping Global Temporary Tables
Shorted SQL