Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • checking connectivity between two servers Linux/Unix
  • Convert multiple rows to single column Oracle
  • Oracle Internal Good Websites 1 Oracle
  • Passing from Unix to PLSQL using bind variables Linux/Unix
  • purge_trc.sh Linux/Unix
  • Changing unix system clock when Oracle database is running. Oracle
  • Good notes for shared pool Oracle
  • database trigger failing Oracle
  • Export With Query Another Example. Oracle
  • Handling LOB data in Oracle Oracle
  • Oracle Release Explaination Oracle
  • UTL_FILE test program Oracle
  • Btee and Bitmap Plans in Oracle 9i and higher Oracle
  • Rename Tablespace Oracle
  • temp_use.sql diplays usage of temp ts 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
  • telnet listening Linux/Unix
  • Follwoing korn shell is used to move files from source folder to destination folder and gzip it in destination folder. mv_iotto.ksh Linux/Unix
  • refre.sql for multitenant Oracle
  • Create type and Grant on it. Oracle
  • CTAS with LONG Column for 7.x and 8 and 8i Oracle
  • 276434.1 Modifying the VIP or VIP Hostname of a 10g or 11g Oracle Clusterware Node Oracle
  • DBMS_STATS Metalinks Notes Oracle
  • Unix command for system configuration Linux/Unix

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme