Leigh Riffel

13,762 reputation

32285

bio	website	isworthy.wordpress.com
	location	Plantation, FL
	age	35
visits	member for	2 years, 4 months
	seen	7 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	7 hours ago

summary answers questions tags badges favorites bounties reputation activity

50 Questions

views newest activity votes

votes

answers

kviews

Eliminate duplicates in ListAgg (Oracle)

apr 9 at 11:51 RolandoMySQLDBA 41.4k

votes

answers

kviews

Why is OS authentication considered poor security for Oracle databases?

oracle oracle-11g-r2 security

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

vote

answer

kviews

Asynch Descriptor Resize explanation

oracle-11g windows wait

mar 15 '11 at 20:08 Leigh Riffel 13.8k

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

answer

kviews

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

oracle

may 14 at 10:14 Guest 1

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

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

answer

kviews

What are the pros/cons of Oracle's Grid Control compared to DB Control?

oracle oracle-grid-control

apr 19 '11 at 16:22 ik_zelf 3,254

votes

answers

kviews

Information on Oracle MKSTORE utility for creating wallet

oracle wallet

feb 4 '11 at 22:01 Leigh Riffel 13.8k

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

votes

answer

kviews

Optimal value for LOG_BUFFER parameter

oracle oracle-11g-r2

mar 8 '11 at 22:57 Gaius 7,167

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

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

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

kviews

Determine Index Compression Candidates Online

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

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

votes

answer

kviews

DBMS_Resource_Manager.Calibrate_IO Usage

oracle oracle-11g-r2

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

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

vote

answer

880

views

Local package won't compile when remote package recompiles. (Oracle)

oracle

jan 28 '11 at 20:36 Gary 1,414

votes

answers

756

views

Detect Index Coalesce

oracle oracle-11g-r2 index

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

vote

answers

732

views

Does the target for Double-Take replication require an Oracle license?

oracle replication license

apr 14 '11 at 14:51 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

629

views

Piplelined Result Set over Database Link Alternatives

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

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

votes

answers

592

views

Oracle Shutdown Method

oracle oracle-11g-r2

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

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

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

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

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

votes

answer

545

views

Differing results from gv$session

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

dec 7 '11 at 8:33 Atilla Ozgur 879

vote

answer

426

views

Can a Wallet be used with SQL Developer? How?

oracle wallet oracle-11g-r2

jan 5 '11 at 14:54 Leigh Riffel 13.8k

votes

answer

417

views

Oracle query against SQL Server database giving inconsistent results

sql-server oracle sql-server-2008 oracle-11g-r2 query

mar 21 '11 at 22:35 Gary 1,414