Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • How to Use DBMS_STATS to Move Statistics to a Different Database Oracle
  • Removing first line Linux/Unix
  • DBA_HIST_SQLSTAT contents Oracle
  • Jai Shree Ram Oracle
  • How to find where datafile is created dbf_info.sql Oracle
  • _B_TREE_BITMAP_PLANS issue during 8.1.7 to 9.2.0.8 upgrade Oracle
  • Adding addidional hard drive and attach it to a linux box. Linux/Unix
  • replacing ^M character when passing files from Windows to Unix Linux/Unix
  • Check Oracle installed products using one command Oracle
  • Search and replace editor command in vi Linux/Unix
  • Another Tuning Article for subheap of shared pool Oracle
  • Oracle Connections expire_time and firewall Oracle
  • To see mem usage and CPU usage system wide. Linux/Unix
  • grep multuple patterns Linux/Unix
  • How to stop OCSSD Daemon Oracle

configUOCIOTTO.ora

Posted on 29-Jul-2005 By Admin No Comments on configUOCIOTTO.ora

# # File – configUOCIOTTO.ora # # Modification History – # control_files=(/uocdb1/oradata/UOCIOTTO/controlUOCIOTTO_01.ctl, /uocdb2/oradata/UOCIOTTO/controlUOCIOTTO_02.ctl, /uocdb3/oradata/UOCIOTTO/controlUOCIOTTO_03.ctl) background_dump_dest=/opt/app/oracle/admin/UOCIOTTO/bdump core_dump_dest=/opt/app/oracle/admin/UOCIOTTO/cdump user_dump_dest=/opt/app/oracle/admin/UOCIOTTO/udump db_block_size = 8192 db_name = UOCIOTTO

Oracle, SQL scripts

initUOCIOTTO.ora

Posted on 29-Jul-2005 By Admin No Comments on initUOCIOTTO.ora

# # File – initUOCIOTTO.ora # Modification History – # ifile =/opt/app/oracle/admin/UOCIOTTO/pfile/configUOCIOTTO.ora ifile =/opt/app/oracle/admin/UOCIOTTO/pfile/arch_configUOCIOTTO.ora cursor_sharing=SIMILAR open_cursors=3000 session_cached_cursors=10 sga_target=1610612736 #sga_max_size=3145728000 db_cache_advice=OFF db_file_multiblock_read_count=8 db_files=500 db_writer_processes=1 disk_asynch_io=TRUE fast_start_mttr_target=0 pga_aggregate_target=848297984 log_buffer=5120000 open_links=10 optimizer_mode=FIRST_ROWS optimizer_dynamic_sampling=0 processes=2000 undo_management=AUTO undo_tablespace=UNDOTBS1 remote_login_passwordfile=EXCLUSIVE compatible=10.1.0.2.0 db_domain=” job_queue_processes=10 #—————————————————————

Oracle, SQL scripts

For Search and replace unix command.

Posted on 29-Jul-2005 By Admin No Comments on For Search and replace unix command.

To remove any text becore patterrn “pvm” in all lines of file, you need to apply following vi editor command. %s/^.*pvm/pvm/g 🙂 “.” represend any single chanracter occurance.

Linux/Unix, shell

Search and Replace vi editor command.

Posted on 29-Jul-2005 By Admin No Comments on Search and Replace vi editor command.

Changing Case To change all the lower case characters to UPPER case characters, starting from the current line, and going for 5 lines, type :s/^.*$/U&/5 To change from UPPER to lower, type :s/^.*$/L&/5 Deleting characters To delete the first 5 characters off of every line in the current file, type :%s/^…..//g

Linux/Unix, shell

newupload.html

Posted on 29-Jul-2005 By Admin No Comments on newupload.html

Photo to Upload: Your Email Address:

PHP/MYSQL/Wordpress

upload.html

Posted on 29-Jul-2005 By Admin No Comments on upload.html

Photo to Upload: Your Email Address:

PHP/MYSQL/Wordpress

Jai Shree Ram

Posted on 29-Jul-2005 By Admin No Comments on Jai Shree Ram

God Bless All………..

PHP/MYSQL/Wordpress

Jai Shree Ram

Posted on 29-Jul-2005 By Admin No Comments on Jai Shree Ram

God Bless All………..

Linux/Unix, shell

Jai Shree Ram

Posted on 29-Jul-2005 By Admin No Comments on Jai Shree Ram

God Bless All………..

Linux/Unix, shell

Jai Shree Ram

Posted on 29-Jul-2005 By Admin No Comments on Jai Shree Ram

God Bless All………..

Oracle, SQL scripts

Posts pagination

Previous 1 … 57 58 59 Next

Categories

  • AMC10 (0)
  • Ansible (0)
  • AWS (2)
  • Azure (1)
  • Django (0)
  • GIT (1)
  • Linux/Unix (150)
  • MYSQL (5)
  • Oracle (403)
  • PHP/MYSQL/Wordpress (10)
  • POSTGRESQL (1)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (18)
  • rman-dataguard (26)
  • shell (151)
  • SQL scripts (349)
  • SQL Server (6)
  • Uncategorized (6)
  • Videos (0)

Recent Posts

  • AMC1020-Sep-2026
  • Key Management in Oracle: The Core Issue: Missing Master Key12-May-2026
  • SAT Mathematics 10 questions and answer at the end.30-Apr-2026
  • top 10 AI news today30-Apr-2026
  • runon_allpdbs_show_conname.sh23-Apr-2026
  • runon_allcdbs_find_pdbs.sh23-Apr-2026
  • Running PDB on single node in RAC09-Apr-2026
  • find_arc.sql09-Apr-2026
  • pvm_pre_change.sql08-Apr-2026
  • find_encr_wallet.sql08-Apr-2026

Archives

  • 2026
  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • Exadata Basics Oracle
  • Creating a Container Database using dbaascli Uncategorized
  • Sending SQLPLUS output in HTML format Oracle
  • Check SQL Server edition SQL Server
  • Drop tempfiles from database Oracle
  • SYSOPER Mystery Oracle
  • 284785.1 How to check RAC Option is currently linked into the Oracle Binary Oracle
  • All Hints for Oracle Databases Oracle

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme