Skip to content

Home
About Me
Toggle search form
Search for:

crtgr.sql /* For creating trigger from data dictionary */ Oracle
Consolidated Reference List Of Notes For Migration / Upgrade Service Requests -ID 762540.1 Oracle
Debugging Shell FIles Linux/Unix
sid_wise_sql.sql Further explaination Oracle
Database logon trigger issue Oracle
Gathering statistics with DBMS_STATS Oracle
column level grant syntax Oracle
ORA-8031 issue and solution if it is occuring due to truncate. Oracle
TRUNCATE table and disabling referential constraints. Oracle
Temporary tablespace explaination Oracle
v$backup.status information Oracle
OEM-Commnds Oracle
longtx.sql with the flag whether session is blocking any DML locks or not. Oracle
Optimizer SORT Operations Oracle
On solaris 10, “S” link is not part of $ORACLE_HOME/bin/oracle as default. ( For 9.2.0.8) Oracle

grep multuple patterns

Posted on 27-Oct-2010 By Admin No Comments on grep multuple patterns

cat test1 | egrep ‘TNS-|Client address’ | sed -e ‘s/^.*HOST/HOST/’

Linux/Unix, shell

Post navigation

Previous Post: fuser to check who is using diretory

Next Post: How To Resolve Stranded DBA_2PC_PENDING Entries ID 401302.1 (Very Good prooven)

Related Posts

check_copy_progress.sh Linux/Unix
.profile Linux/Unix
Useful Solaris Commands on 28-SEP-2005 Linux/Unix
Running some SQL on multiple databases connecting using monitoring userid and password Linux/Unix
catting.sh Linux/Unix
Space padding in korn shell Linux/Unix

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Comment *

Name *

Email *

Website

Save my name, email, and website in this browser for the next time I comment.

Categories

AWS (2)
Azure (1)
Linux/Unix (149)
Oracle (392)
PHP/MYSQL/Wordpress (10)
Power-BI (0)
Python/PySpark (7)
RAC (17)
rman-dataguard (26)
shell (149)
SQL scripts (341)
Uncategorized (0)
Videos (0)

Recent Posts

load SPM baseline from cursor cache05-Jun-2025
Drop all SPM baselines for SQL handle05-Jun-2025
Load SPM baseline from AWR05-Jun-2025
Drop specific SQL plan baseline – spm05-Jun-2025
findinfo.sql (SQL for getting CPU and Active session info)27-May-2025
SQL Tracker by SID sqltrackerbysid.sql22-Apr-2025
How to connect to Oracle Database with Wallet with Python.21-Mar-2025
JSON/XML Types in Oracle18-Mar-2025
CPU Core related projections12-Mar-2025
Exadata Basics10-Dec-2024

Archives

2025
2024
2023
2010
2009
2008
2007
2006
2005

Jai Shree Ram Linux/Unix
Finding Oracle Patches with opatch Oracle
Example of How To Resize the Online Redo Logfiles Note:1035935.6 Oracle
kill all processes from specific user in solaris. Linux/Unix
How to set Processes Parameter Oracle
When to rebuld B-tree index Oracle
To see only files and/or folders using LS command Linux/Unix
sql_plan9i.sql Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme