foalabs

Creating an ACFS file system on OCI DB system In an DB system on OCI if we want to add any file system then we can use the ACFS file system. We can create an ACFS file system using below 1) Login to DB system with grid user 2)  Create a Volume by picking space from DATA disk group. [grid@foa ~]$ asmcmd lsdg State    Type    Rebal  Sector  Logical_Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name MOUNTED  EXTERN  N         512             512   4096  4194304    262144     4372                0            4372              0             Y  DATA/ MOUNTED  EXTERN  N   ...

Storage Space allocated in DB System in OCI OCI DB Systems (both VM and BM shapes) use ASM by default. So, the space selected during instance creation is allocated to ASM. You can check the details by executing "asmcmd lsdg" command as "grid" user When the DB system is created the space given during creation is used to create the 2 DISK group. DATA-->Available Data Storage -256GB RECO--> Recovery area Storage -256GB If we want to create a file system for a DB system then, we can use ACFS file system and use it as required. If you like please follow and comment

OCI Series-2|Architecture|funoracleapps.com If you like please like, share and comment.

OCI Series If you like please share and subscribe

RMAN Commands related to Archive Logs I am sharing handy commands which can be helpful when working with archive logs. Archivelog List Commands: list archivelog all;  list copy of archivelog until time 'SYSDATE-1';  list copy of archivelog from time 'SYSDATE-1';  list copy of archivelog from time 'SYSDATE-1' until time 'SYSDATE-2';  list copy of archivelog from sequence 18600;  list copy of archivelog until sequence 20000;  list copy of archivelog from sequence 18600 until sequence 20000;  Archivelog Delete Commands: delete archivelog all; delete archivelog until time 'SYSDATE-1';  delete archivelog from time 'SYSDATE-1';  delete archivelog from time 'SYSDATE-1' until time 'SYSDATE-2';  delete archivelog from sequence 18600;  delete archivelog until sequence 20000;  delete archivelog from sequence 18600 until sequence 20000;  Use noprompt to avoid being prompted for each file delete noprompt archivelog until time 'SYSD...

Sample Init Parameter file for 19c Oracle DB I am just sharing a sample init file for usage. More parameter can be added as required. Sample *.audit_file_dest='/u01/app/oracle/admin/test/adump' *.audit_sys_operations=TRUE *.audit_trail='db' *.compatible='19.15.0.0.0' *.control_files='/data01/oradata/test/control01.ctl','/data02/app/oracle/control02.ctl' *.db_block_size=8192 *.db_domain='lab' *.db_name='test' *.db_recovery_file_dest='/u01/app/oracle/fast_recovery_area' *.db_recovery_file_dest_size=4560m *.diagnostic_dest='/u01/app/oracle' *.log_archive_format='%t_%s_%r.arc' *.memory_max_target=754974720 *.memory_target=754974720 *.open_cursors=300 *.os_roles=FALSE *.processes=300 *.recyclebin='OFF' *.remote_login_passwordfile='EXCLUSIVE' *.undo_tablespace='UNDOTBS1' If you like please follow and comment

How to increase PROCESSES,SESSIONS and TRANSACTIONS initialization parameter in Oracle Database Sessions : Sessions specify the number of connections that can served by oracle database at a time. This is equivalent to the number of concurrent users of the application. If your application has a lot of concurrent users then you need to increase the sessions in the oracle database. Processes : Processes run in the background of Oracle database to maximize performance and accommodate many users. Transaction : A transaction is a logical, atomic unit of work that contains one or more SQL statements. A transaction groups SQL statements so that they are either all committed, which means they are applied to the database, or all rolled back, which means they are undone from the database Steps: 1.    Login as sysdba     sqlplus / as sysdba     2. Check Current Setting of Parameters     sql> show parameter sessions     sql> show parameter pr...