Year: 2005

initUOCIOTTO.ora

29-Jul-2005 Admin No Comments

# # 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.

29-Jul-2005 Admin No Comments

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.

29-Jul-2005 Admin No Comments

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