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

Sign in|Recent Site Activity|Report Abuse|Print Page|Powered By Google Sites