Skip to content

Home
About Me
Toggle search form
Search for:

AWR settings- MMON is not taking snapshot. Oracle
Good Doc 28-JUN-2006 Oracle
SAN Linux/Unix
alter database backup controlfile to trace Oracle
find_open_cur.sql Find open cursorts per session Oracle
Zip and unzip with tar Linux/Unix
cache buffer chain latch Oracle
TRUNCATE Privs Oracle
When error comes for temporary tablespace with version <= 9i Oracle
First Entry in RAC Oracle
DB Console Mainenance. Oracle
Process Map for CPU and Memory for OS processes Linux/Unix
find_string_in_database.sql Oracle
272332.1 CRS 10g Diagnostic Collection Guide Oracle
How to know current SID Oracle

findobj.sql

Posted on 02-Aug-2005 By Admin No Comments on findobj.sql

select * from user_objects where object_name = upper(‘&objnm’);

Oracle, SQL scripts

Post navigation

Previous Post: find_cons.sql

Next Post: create database syntax

Related Posts

TRUNCATE Privs Oracle
Oracle 10g Installation/Applying Patches Tips Oracle
Jai Shree Ram Oracle
crtgr.sql /* For creating trigger from data dictionary */ Oracle
How to choose Driver table in SQL statement Oracle
dbinv.sql Oracle

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

Ansible (0)
AWS (2)
Azure (1)
Linux/Unix (149)
MYSQL (5)
Oracle (393)
PHP/MYSQL/Wordpress (10)
POSTGRESQL (0)
Power-BI (0)
Python/PySpark (7)
RAC (17)
rman-dataguard (26)
shell (149)
SQL scripts (342)
SQL Server (6)
Uncategorized (0)
Videos (0)

Recent Posts

Trace a SQL session from another session using ORADEBUG30-Sep-2025
SQL Server Vs Oracle Architecture difference25-Jul-2025
SQL Server: How to see historical transactions25-Jul-2025
SQL Server: How to see current transactions or requests25-Jul-2025
T-SQL Vs PL/SQL Syntax25-Jul-2025
Check SQL Server edition25-Jul-2025
Checking SQL Server Version25-Jul-2025
Oracle vs MYSQL Architecture differences (For DBAs)24-Jul-2025
V$INSTANCE of Oracle in MYSQL24-Jul-2025
Day to day MYSQL DBA operations (Compared with Oracle DBA)24-Jul-2025

Archives

2025
2024
2023
2010
2009
2008
2007
2006
2005

UNderstand and eliminate Latch contention. Oracle
OPENING A STANDBY DATABASE IN READ-ONLY MODE Oracle
Oracle Standby Database Library Index from Metalink Oracle
How to find who is using which Rollback segment and how many rows or blocks in that rollback segments, Oracle
Test Case for Inserting Multiple (2.3 Million rows in 26 Seconds) Oracle
Oracle Recommended Patches — Oracle Database ID 756671.1 Oracle
Important Solaris Commands Linux/Unix
get_vmstat_solaris Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme