Mohammad Nazmul Huda
Search this site
About Me
Certifications
Employment History
Publications
Study Resources
Training
Technical Docs
Oracle
Managing Database
Backup and Recovery
Performance Tuning
ASM
Security
Replication
Database Change
Data Guard
Cloud Control
LISTENER
Parameters
SQL
SQL Functions
PL/SQL
ORA ERROR
12c Issues
Bugs
Scripts
Tools
OCM
Teradata
MySQL
SQL SERVER
Linux
AWS
Data Science
Other
Contact
Managing Database
Oracle Architecture
Database Creation
PFILE And SPFILE
Archivelog
Control Files
Data Files
Redo Log File
Shared Server
Data Pump
Export and Import
Flashback
Managing Role
LOC Conflict
SQL Loader
Startup and Shutdown Procedure
Setting NLS_LANG_Environment variable for Windows and Unix for Oracle Database
SQL*Plus Customize User Profile
Capture Failed SQL using servererror trigger
Bypass the execution of the AFTER LOGIN trigger
How to lock/unlock statistics on a table
Invisible Index Oracle 11g
Fix Invalid Or Unusable Index
Find users with DBA privilege
Change User Password
Progress status of index rebuild/creation or long operation
How to check last Password Change time for a user in Oracle
Check Materialize View Refresh Schedule
How to check MAXDATAFILES,MAXLOGHISTORY,MAXINSTANCES,MAXLOGFILES,MAXLOGMEMEBERS
How to Flush Single SQL Plan out of Shared Pool
Stop MVIEW auto refresh
ALTER TABLESPACE Add Datafile
Shrink Lob segment
Change SYS password in Data Guard environment
Read Alert log from x$dbgalertext
Dead Connection Detection, Resource Limits, V$SESSION, V$PROCESS and OS processes
Writing data into OS text file from Database Using UTL_FILE
Clone Grid Home and Oracle Home
Create database using dbca
Oracle RDS:
How to Transfer file from AWS RDS for Oracle to Other Oracle Server
Kill All session from a User in Oracle RDS in AWS
Comments