Abstract
 ArcSDE Database Administration: Configuration, Storage, Tuning, Monitoring, Management, and Maintenance Track: Database Design, Automation, and Management Author(s): Greg Tudor The Washington Department of Natural Resources (DNR) implemented SDE 3 (Spatial Database Engine) in 1997. Since that time, many changes and improvements have been made to the ArcSDE enterprise database and the geodatabase (GDB) extensions. When did we last review our SDE configuration? As part of the DNR's GIS migration project, database administrators (DBAs) reevaluated the ArcSDE/GDB environment focusing on configuration, storage, tuning, monitoring, management, and maintenance. DBAs evaluated and modified the operating system, Oracle database, and SDE configuration parameters. DBAs improved storage portability and revised the sdedbtune keyword definitions. Spatial reference definitions, spatial indexes, and spatial view were tuned. SQL views of common orphan SDE/GDB objects and monitoring scripts were developed to assist with identifying problems and tracking usage trends. Several developing ArcSDE management and productivity tools were reviewed. The ArcSDE evaluation findings, recommendations, and results of implementation revisions are presented. Greg Tudor WA DNR ITD, GIS PO Box 47020 Olympia , WA 98504-7020 US Phone: 360-902-1542 Fax: 360-902-1790 E-mail: Greg.Tudor@wadnr.gov |
|||||
