Oracle DBA Support

ERROR :  SQL> RECOVER DATABASE UNTIL CANCEL; ORA-01034: ORACLE not available Process ID: 0 Session ID: 0 Serial number: 0 SQL> ALTE...

SAN Versus(V/S) DAS SAN (storage area network) is a high-speed network of storage devices that also connects those storage devices with ser...

Network Attached Storage (NAS) V/S Storage Area Network (SAN) Network Attached Storage (NAS) Definition - What does Network Attached Storag...

How to Setup an ArcSDE Trace for API Developers troubleshooting ? The trace corresponds to client API calls, not the calls made inside the ...

How to check the REDO logfile estimation ? How to check that what should be the size of REDO logfile? Use the following command to check ...

Slow ArcSDE Performance Troubleshooting Why is my ArcSDE geodatabase running so slow?  Is it because I have too much data?  Probably no...

$SDEHOME/etc – Understanding SDEHOME and its components Whether it’s $SDEHOME or %SDEHOME% the “etc” folder contains a wealth of informat...

ArcSDE User Permissions ESRI 10.2   The SDE user is responsible for several geodatabase maintenance tasks including compression and vers...

ArcSDE Connection Errors  The link here will provide you detailed information about all the errors in ArcSDE and the important one's...

How to Synchronize users in bulk to a newly created geodatabase in SQL Server There is often the need to create or restore a geodatabase...

Problem:  Poor compress performance http://support.esri.com/en/knowledgebase/techarticles/detail/20428 Thanks.  

A guide to geodatabase replication (Distributed Geodatabase) Creating a replica is a great way to share a part or all of your geodatabas...

Useful Resources for Rebuilding Indexes and Updating Statistics in an SDE Geodatabase for SQL Server and ORACLE : Two tasks found in all E...

HOW TO SETUP SDE INTERCEPT ON DESKTOP SDEINTERCEPT VIDEO ARCSDE ARCGIS ESRI 10.2  https://www.youtube.com/watch?v=y1xK8tzkazQ&feature...

How to create a Batch File for SDE Intercept and read the SDE intercepts. 1.  Open your notepad and paste this: set SDEINTERCEPTLOC=C:\TEMP...

Oracle: bitmap conversion to rowid  One of my colleagues recently have a question about bitmap conversion in Oracle. Here is something ...

SGA VS PGA  --------------------------------------------------------------------------------- SGA (System Global Area) is an area of m...

How to create a geodatabase from post installation wizard in ArcSDE 9.3 geodatabase ARCGIS ARCSDE ESRI and using post installation wizard...

How to check the version and build number of ArcMap/ArcCatalog? https://youtu.be/DLAH52scPXs  

How to check the version of ArcSDE software installed on your machine? https://youtu.be/t890ZS0L1BA  

How to upgrade an ArcSDE Oracle geodatabase? https://youtu.be/EWtdbA4BsD0

How to Compress an Oracle ArcSDE geodatabase? https://youtu.be/rj1G0OOD5nw

How to create an ArcSDE Oracle geodatabase ? Part 1 https://www.youtube.com/watch?v=7O9mAHQoR6A Part 2 https://www.youtube.com/watch?v=xEM3...

How to Perform a non versioned editing in Arc Map ? https://youtu.be/u0G2r4ohVUY

How to Perform a versioned editing in Arc Map ? https://youtu.be/TEaKSSS9phs Thank You.