Leigh Riffel

13,712 reputation

32285

bio	website	isworthy.wordpress.com
	location	Plantation, FL
	age	35
visits	member for	2 years, 4 months
	seen	2 days ago
stats	profile views	655

Oracle Database Administrator

Oracle Certified Professional (OCP)
Oracle Database SQL Certified Expert

	13,712 reputation	bio	website	isworthy.wordpress.com	visits	member for	2 years, 4 months
32285 badges		location	Plantation, FL		seen	2 days ago

summary answers questions tags badges favorites bounties reputation activity

50 Questions

views newest activity votes

votes

answer

kviews

What makes an Oracle Applications DBA different from an Oracle DBA?

oracle

may 14 at 10:14 Guest 1

votes

answers

kviews

How do you version your Oracle database changes?

may 7 at 10:28 popalka 111

votes

answer

112

views

What must be in place to validate a XMLTYPE against a schema?

oracle oracle-11g-r2 xml access-control

apr 17 at 14:19 Leigh Riffel 13.7k

votes

answers

kviews

Eliminate duplicates in ListAgg (Oracle)

oracle sql oracle-11g-r2 aggregate

apr 9 at 11:51 RolandoMySQLDBA 41.2k

vote

answer

views

Specify Server for DBMS_Scheduler Job in Policy Managed RAC

oracle oracle-11g-r2 oracle-rac dbms-scheduler

mar 30 at 4:09 Mark Storey-Smith 18.7k

votes

answer

218

views

Package state not re-intialized on raise_application_error

oracle oracle-11g-r2 plsql error-handling

mar 1 at 14:02 Leigh Riffel 13.7k

votes

answer

226

views

Table Statistics Affect Index Only Query?

oracle sql oracle-11g-r2

feb 23 at 8:33 Štefan Oravec 114

votes

answers

105

views

Generate XML using Oracle XML schema

oracle oracle-11g-r2 xml

feb 19 at 14:44 Leigh Riffel 13.7k

votes

answers

kviews

What other databases have a feature similar to Oracle's Flashback Query?

flashback feature-comparison

nov 8 at 11:50 dezso 3,892

votes

answers

194

views

Change Location of VALIDATE RECOVERY FILES work area

oracle backup recovery rman

oct 25 at 18:19 Leigh Riffel 13.7k

votes

answers

574

views

Updating rows conditionally with a gapless ascending value

sql oracle oracle-11g-r2 gaps-and-islands

sep 19 at 23:18 Erwin Brandstetter 8,697

votes

answers

kviews

Execute a script with SQLPlus containing blanks, semi-colons, and forward slashes

oracle sql oracle-11g-r2 sqlplus

aug 24 at 18:16 Bocian 11

votes

answer

359

views

Objects in v$bh but not dba_objects

oracle oracle-11g-r2

jul 4 at 8:53 Phil 10.2k

votes

answers

kviews

Limit redo for materialized view complete refresh or manual equivalent

oracle oracle-11g-r2 indexed-view

jun 6 '12 at 11:18 kaissun 110

votes

answer

208

views

Comments in EXPDB parameter file

oracle oracle-11g-r2 export datapump

may 31 '12 at 18:43 a_horse_with_no_name 8,125

votes

answers

592

views

Oracle Shutdown Method

oracle oracle-11g-r2

apr 12 '12 at 22:34 miracle173 1,308

votes

answers

112

views

Product of n Rows

sql oracle oracle-11g-r2

mar 14 '12 at 21:04 Leigh Riffel 13.7k

votes

answers

573

views

Should date formats be specified in SQL statements?

oracle sql-injection

mar 7 '12 at 11:39 onedaywhen 1,623

votes

answers

122

views

Overhead of DBMS_Profiler

oracle oracle-11g-r2 plsql profiler

feb 28 '12 at 14:56 David Mann 528

votes

answers

247

views

Isssue with Database Links converting OEM Job to DBMS_Scheduler Job

oracle oracle-11g-r2 oracle-10g dbms-scheduler

feb 7 '12 at 19:08 Leigh Riffel 13.7k

votes

answers

239

views

Oracle Enterprise Manager Jobs Failing Initialization

oracle oracle-rac

feb 7 '12 at 18:31 Leigh Riffel 13.7k

votes

answer

kviews

Oracle Wallet Setup ORA-12578

oracle oracle-11g-r2 oracle-11g wallet oracle-se

dec 8 '11 at 22:30 Leigh Riffel 13.7k

votes

answer

122

views

Is Oracle Configuration Manager HIPAA compliant?

oracle vendor-support

dec 8 '11 at 18:06 Leigh Riffel 13.7k

votes

answer

541

views

Differing results from gv$session

oracle sql oracle-11g-r2 oracle-se oracle-rac

dec 7 '11 at 8:33 Atilla Ozgur 879

votes

answers

kviews

Tools to monitor Oracle Database Performance on Standard Edition

oracle performance oracle-se

dec 2 '11 at 23:09 RolandoMySQLDBA 41.2k

votes

answer

kviews

What are the benefits of packages over standalone procedures and functions?

oracle plsql

dec 1 '11 at 17:58 RolandoMySQLDBA 41.2k

votes

answers

157

views

Book for Learning RAC

oracle rac

oct 18 '11 at 20:01 Jack Douglas♦ 12.8k

votes

answers

379

views

Oracle Advanced Queuing LIFO

oracle oracle-11g-r2 plsql

sep 4 '11 at 12:07 Gaius 7,167

votes

answers

626

views

Piplelined Result Set over Database Link Alternatives

oracle oracle-11g-r2 oracle-11g plsql

jul 26 '11 at 10:35 Gary 1,404

votes

answers

kviews

Determine Index Compression Candidates Online

oracle oracle-11g-r2 index oracle-11g

jul 8 '11 at 18:17 Leigh Riffel 13.7k