Leigh Riffel

13,762 reputation

32285

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

Oracle Database Administrator

Oracle Certified Professional (OCP)
Oracle Database SQL Certified Expert

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

summary answers questions tags badges favorites bounties reputation activity

50 Questions

views newest activity votes

votes

answers

kviews

Why is OS authentication considered poor security for Oracle databases?

jan 28 '11 at 11:37 Joe 3,116

votes

answers

kviews

How do you version your Oracle database changes?

oracle oracle-11g-r2 version-control

may 7 at 10:28 popalka 111

votes

answers

kviews

Eliminate duplicates in ListAgg (Oracle)

oracle sql oracle-11g-r2 aggregate

apr 9 at 11:51 RolandoMySQLDBA 41.4k

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

answer

kviews

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

oracle plsql

dec 1 '11 at 17:58 RolandoMySQLDBA 41.4k

votes

answers

kviews

Security for Application Developers doing PL/SQL work in Oracle

oracle security database-design oracle-11g-r2

jan 7 '11 at 8:26 Brian Ballsun-Stanton 3,181

votes

answers

592

views

Oracle Shutdown Method

oracle oracle-11g-r2

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

votes

answers

401

views

LNNVL Justification

oracle sql oracle-11g-r2 oracle-11g

may 13 '11 at 16:24 Kerri Shotts 1,071

votes

answer

282

views

How can a datapump export have its resource usage limited on linux?

oracle oracle-11g-r2 linux datapump export

jan 7 '11 at 15:27 Leigh Riffel 13.8k

votes

answers

109

views

Generate XML using Oracle XML schema

oracle oracle-11g-r2 xml

feb 19 at 14:44 Leigh Riffel 13.8k

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

answers

580

views

Should date formats be specified in SQL statements?

oracle sql-injection

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

votes

answer

219

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.8k

votes

answers

kviews

Tools to monitor Oracle Database Performance on Standard Edition

oracle performance oracle-se

dec 2 '11 at 23:09 RolandoMySQLDBA 41.4k

votes

answers

214

views

Can Oracle be installed on Windows without being an administrator?

oracle windows

jan 5 '11 at 22:33 Leigh Riffel 13.8k

votes

answer

kviews

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

oracle

may 14 at 10:14 Guest 1

votes

answer

115

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.8k

votes

answers

112

views

Product of n Rows

sql oracle oracle-11g-r2

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

votes

answers

381

views

Oracle Advanced Queuing LIFO

oracle oracle-11g-r2 plsql

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

votes

answer

kviews

DBMS_Resource_Manager.Calibrate_IO Usage

oracle oracle-11g-r2

mar 23 '11 at 19:41 ik_zelf 3,254

votes

answer

576

views

Case Behavior Changed Between 11.2.0.1 and 11.2.0.2

oracle sql oracle-11g-r2 windows vendor-support

jan 20 '11 at 15:30 Leigh Riffel 13.8k

votes

answers

643

views

How can a datapump export have its resource usage limited on windows?

oracle oracle-11g-r2 datapump export windows

jan 11 '11 at 0:46 Leigh Riffel 13.8k

votes

answers

194

views

Change Location of VALIDATE RECOVERY FILES work area

oracle backup recovery rman

oct 25 at 18:19 Leigh Riffel 13.8k

votes

answers

577

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,752

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

210

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

answer

122

views

Is Oracle Configuration Manager HIPAA compliant?

oracle vendor-support

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

votes

answers

kviews

Determine Index Compression Candidates Online

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

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

votes

answers

756

views

Detect Index Coalesce

oracle oracle-11g-r2 index

jan 26 '11 at 14:29 Leigh Riffel 13.8k

votes

answers

574

views

Identify which parameters were passed to a procedure (Oracle)

oracle oracle-11g-r2 plsql

jan 19 '11 at 20:56 René Nyffenegger 1,410