oracle
PFile and SPFile in oracle
PFile and SPFile in oracle Pfile SPfile init<sid>.ora spfile<sid>.ora …
Showing posts from January, 2025Show all
oracle
PFile and SPFile in oracle
PFile and SPFile in oracle Pfile SPfile init<sid>.ora spfile<sid>.ora Text file Binary file Edited in text editor Edited by using ALT…
https://sureshchowdarysapbasiss.blogspot.com/
oracle
Oracle Files
Oracle Files Data files: Contains all database data Name: *.dbf Location: /$ORACLE_HOME/sapdata(n) Redo logs: Contains change records (change vecto…
https://sureshchowdarysapbasiss.blogspot.com/
oracle
Oracle DB Start and Stop
Oracle DB Start and Stop SQL> startup; //mounts and opens DB (ex. Open MS word and also file) SQL>startup mount; //starts DB…
https://sureshchowdarysapbasiss.blogspot.com/
oracle
Switch on and off Archive logs in oracle
Switch on and off Archive logs in oracle SQL>shutdown immediate; SQL>startup mount; SQL>alter database noarchivelog; // to switch off S…
https://sureshchowdarysapbasiss.blogspot.com/
oracle
Oracle Table spaces
Oracle Table spaces SYSTEM (tablespace for the Oracle dictionary) SYSAUX (additional tablespace as of Oracle database 10g) PSAPTEMP (default tablesp…
https://sureshchowdarysapbasiss.blogspot.com/
oracle
OPS$ and SSFS
SSFS Configuration OPS$: (Till version Oracle 11g and SAP Kernel 7.20) SAP connects to DB using OPS$ user OPS$ users can connect to database without…
https://sureshchowdarysapbasiss.blogspot.com/
oracle
Oracle database Directory Structure
Oracle Directory Structure
https://sureshchowdarysapbasiss.blogspot.com/
HANA
HANA Architecture
SAP HANA Architecture SAP HANA is an in-memory, column-oriented, relational database management system (RDBMS) developed by SAP for handling high v…
https://sureshchowdarysapbasiss.blogspot.com/
oracle
- Suresh Chowdary
- HyderaBad, Nizampet, TELANGANA, India
Social Plugin