Memory2Me

About Oracle and For DBA

Wednesday, May 12, 2010

hang analyze

sqlplus /nolog
connect / as sysdba
oradebug setospid forground_pid
oradebug unlimit
oradebug hanganalyze 3
wait 90 seconds
oradebug hanganalyze 3
exit

Posted by Henry's Blog at 7:50 AM

Labels: SQL command

Newer Post Older Post Home

Search This Blog

Labels

SQL command (15) sample (15) PBT (5) monitoring (4) Error Code (3) configuration (3) oracle11g newfeature (2) EM (1) dataguard (1)

Subscribe Now

Subscribe in a reader

FeedBurner FeedCount

My Oracle Blog List

The Oracle Instructor

Pickleball Trends - Es gibt eine Reihe von bemerkenswerten Entwicklungen und Veränderungen beim Pickleball, die ich hier mal kurz aus meiner Sicht aufzeigen und zur Diskussion...
3 days ago
Hemant's Oracle DBA Blog

Testing DEFAULT ON NULL FOR UPDATE in 23ai - Testing a new feature in 23ai that allows you to define a DEFAULT value for a column if a user/front-end/application sends a NULL : [oracle@oel9 ~]$ s...
3 days ago
Oradori

Oracle Database 23ai : Where to find information - Oracle Database 23ai : Where to find information http://www.koreaoug.org/ai23/13183 #koreaoug #한국오라클사용자그룹 #오라클 #oracle #23ai #릴리즈 #23c #ai #findinformation
5 days ago
Ardent Performance Computing

Major Developments in Postgres Extension Discovery and Distribution - PostgreSQL “extensions” are a big part of what makes this database special. The developers building the core Postgres database are amazing. But many people...
1 month ago
Martin Widlake's Yet Another Oracle Blog

When is an Oracle ACE not an Oracle ACE? - As of this week (11th March 2024) I am no longer a proper Oracle ACE – and this is exactly as it should be. I am now an ACE Alum (I would prefer Alumnus bu...
2 months ago
Tanel Poder's blog: Core IT for Geeks and Pros

Oracle Shared Pool Internals: Allocated Chunk Status Indicators in Heap Dumps - Over time, Oracle has been adding more contextual information into each allocated heap memory chunk, to make it easier to see what for your heap memory is ...
2 months ago
Online Apps DBA

Power BI in Marketing: Transforming Strategies for Success - Hello Data Enthusiasts!👨‍💻 Explore Power BI for marketing mastery. Uncover data consolidation, interactive dashboards, and predictive analytics. 🌐✨ 📚...
4 months ago
Kevin Closson's Oracle Blog: Platform, Storage & Clustering Topics Related to Oracle Databases

PGIO Update - PGIO is the SLOB method for PostreSQL. An old friend of mine, Bart Sjerps, has implemented a modified PGIO in Python and posted it on Github: https://githu...
5 months ago
Oracle related stuff

Oracle 19c RU Release Update 19.19 nice little enhancement: DBA_HIST_SQL_PLAN ACCESS_PREDICATES and FILTER_PREDICATES columns populated - I've recently found out by coincidence a nice little enhancement that apparently was introduced with the 19.19 Release Update - a backport of the fix tha...
7 months ago
pdvfirstblog

A Community needs to grow New Speakers, new members #JoelKallmanDay - TL;DR: We should encourage more new speakers (and bloggers and writers...) to come mix with "the elders" and share findings and opinions. That is how "th...
7 months ago
Kerry Osborne's Oracle Blog

HTAP: Well, How Did We Get Here? - I’m speaking at an HTAP Conference put on by PingCap, (the folks responsible for TiDB). As usual, I’m the only one with a cap. 🙂 By now the event is s...
7 months ago
Laurent Schneider

oem cpu jul 23 - this blog is no longer maintained. go there : OEM patch | LaurentSchneider.Com (wordpress.com)
7 months ago
Cary Millsap

How Slow Programs Are Like Christmas: a Sales Pitch - My company, Method R Corporation, makes systems faster. And we make people who make systems faster, faster. We train people to become performance optimiz...
8 months ago
Richard Foote's Oracle Blog

The End Of Richard Foote’s Oracle Blog (“Rock ‘n’ Roll Suicide”) - Of all my many Oracle blog posts, this particular post will remain with me the longest, for not only is it the last blog post I’ve done in a while, but i...
9 months ago
blog.gralike.com

Pluggable databases ignores SAVE STATE / is always opened in READ WRITE - I noticed a new “feature” on my managed DBAAS Oracle OCI environments, that whatever I…
10 months ago
Oracle Enterprise Manager Grid Control

A New Kind of DBaaS – Fully Managed, Multi-Database-Engine, Multi-Cloud to boot - *(A thought leadership/opinion piece)* *Author: Porus Homi HavewalaCloud Database Consultant, Didgenet* When I was an Oracle Enterprise Manager SME work...
11 months ago
Striving for Optimal Performance

Creating a SQL Patch with Many Hints Requires a Hack - In the past, when I created a SQL patch, I always specified a small number of hints. Last week, for the first time, I created one with more than 100 of the...
2 years ago
H.Tonguc Yılmaz - Oracle Blog

Surpriseeee : ) - Let’s make yet another fresh start here, sharing platform became Linkedin for me for the last years but I really missed writing my experiences in detail, l...
2 years ago
Database RAC DataGaurd and APPS

Conflict - The Subnet ocid1.subnet.oc1... references the VNIC ocid1.vnic.... You must remove the reference to proceed with this operation. - Recently , i was cleaning Oracle OCI Account. I delete / terminated most of things But subnet was giving error Conflict - The Subnet ocid1.subnet.oc1....
2 years ago
jarneil

OCI Bare Metal Pricing - In the same vein as the VM shapes, the available OCI Bare Metal shapes that you can use are hardly a secret and are easily obtainable from the Oracle cloud...
3 years ago
Jaffar Oracle blog

Oracle Cloud & Third party tools - There have been several buzz words and offerings since the invention of Cloud concepts. We have been hearing of Private Cloud, Public Cloud, Hybrid cloud a...
3 years ago
Surachart Opun's Blog

How to create signed url on google cloud storage? - A signed URL is a URL that provides limited permission and time to make a request. It's good to be used by someone who does not have a Google Account. I ca...
4 years ago
TheBest

oracle user object 생성 ddl 추출 - select dbms_metadata.get_ddl( object_type, object_name, object_owner) from dual;
4 years ago
So Many Oracle Manuals, So Little Time

One More Thing: New Oracle Cloud free tier better than AWS free tier - Larry Ellison just concluded his Oracle OpenWorld keynote with the announcement of an Oracle Cloud free tier that is better than the AWS free tier. The Ora...
4 years ago
Marcelo Ochoa's personal blog

We moved to @Medium - Since August 2017 We are moved to Medium, some of the reason are great described into this blog post "3 reasons we moved our startup blog to Medium". You ...
4 years ago
The Arup Nanda Blog

Sangam 18: Presentations, Scripts and More - Many, many thanks to those who came to my three sessions at Sangam 18, the largest meeting of Oracle technologists in South Asia. As I promised, you can do...
5 years ago
Oracle Secure Enterprise Search results for:product:

Businesses Struggle to Protect Sensitive Cloud Data According to New Oracle and KPMG Cloud Threat Report - Press Release Businesses Struggle to Protect Sensitive Cloud Data According to New Oracle and KPMG Cloud Threat Report Despite defined security policies, ...
6 years ago
Packt Book Feed

Implementing 3 Naive Bayes classifiers in scikit-learn : Bernoulli, Multinomial and Gaussian naive Bayes algorithms - Scikit-learn provide three naive Bayes implementations: Bernoulli, multinomial and Gaussian. The only difference is about the probability distribution ad...
6 years ago
The Dutch Prutser's Blog

Oracle Solaris 11.4 Public Beta Released - Yesterday the Oracle Solaris 11.4 Beta was released to the public. You can download it from OTN to have your go with it. Please read the documentation to l...
6 years ago
Oracle database internals by Riyaj

Oracle Open World 2017 presentation - Hi, I will be presenting about ASM internals in Oracle Open World 2017 conference on Sunday October 1st. Following are the details: Session ID: SUN5682 Ses...
6 years ago
Oracle MVA

Online Master Key with Oracle Key Vault on a Consolidated Platform - Seems I am writing a series. In part 2 on Oracle Key Vault (OKV): having 2 databases using the same OKV. In part 1 I mentioned an open item: what happens i...
7 years ago
ORACLENERD

Real World SQL and PL/SQL: Advice from the Experts - *Because my hero is Cary Millsap, I'm going to do what he did and publish my foreword Preface. All joking aside, I consider myself incredibly fortunate ...
7 years ago
Oracle by Madrid

Temporary tablespace takes ages to drop - A simple command like 'DROP TABLESPACE TEMP;' in a regular database can become excessively slow. The reason behind this is quite simple, even if the users...
7 years ago
Alberto Dell'Era's Oracle blog

“ASH math” of time_waited explained with pictures and simulation - As explained by John Beresniewicz, Graham Wood and Uri Shaft in their excellent overview ASH architecture and advanced usage, avg( v$active_session_history...
7 years ago
Doug's Oracle Blog

Moving Sideways - The past two years have seen a lot of change in my life :- - I moved to Singapore thinking it would be for a year or two at least and is now looking ...
8 years ago
The Blog from the DBA Classroom

Become a Master of Oracle 12c - Oracle Database 12c: Administrator Certified Master Technology moves on, and to keep pace with it, so should you. If you are an Oracle Certified profession...
8 years ago
Karen Morton

Find it. Fix it. Real-World SQL Tuning Cases - Jan. 13 Webinar Followup - If you missed my January 13th webinar entitled "Find it. Fix it. Real-World SQL Tuning Cases" you can now access the recording and download the presentatio...
9 years ago
Alejandro Vargas' Blog

How to setup passwordless ssh in Exadata using dcli - Setting passwordless ssh root connection using dcli is fast and simple and will easy later to execute commands on all servers using this utility. In...
9 years ago
Oracle DBA and Apps DBA blog

No Write Permission on ACFS Mount Point - Last night, I managed to create the ACFS Mount Point after resolving the issue *"ACFS-9459: ASVM/ACFS is not supported on this os version"*. But, after c...
9 years ago
Snapshot Too Old

Rolling Out-of-Place patching para Oracle Grid Infrastructure 12c y 11gR2: clonación en esteroides - Mi artículo más reciente para *ToadWorld*, dentro de una serie dedicada a aplicar *patches* con mínima suspensión del servicio. Ahora detallando cómo aplic...
9 years ago
I'm just a simple DBA on a complex production system

On Error Messages - Here’s a pet peeve of mine: Customers who don’t read the error messages. The usual symptom is a belief that there is just on error: “Doesn’t work”, and tha...
10 years ago
The Tom Kyte Blog

Upcoming Events... - I took some time off from the road at the beginning of 2014 - getting ready to get back on the road again, lots of trips scheduled from February till the e...
10 years ago
Science of DataBase

PARTITION WISE JOIN이란 무엇인가? - *부제: Partition Wise Join의 성능* DBA나 튜닝 컨설턴트들에게 PARTITION WISE JOIN(이후 PWJ)를 설명해 보라고 하면, 언제나 PARALLEL과 PQ_DISTRIBUTE 힌트를 언급한다. 이상한 일이다. PWJ는 PARALLEL + ...
10 years ago
The Oracle Sponge

Little Changed - Incredible and depressing to see people still getting Oracle internals as wrong as this.
11 years ago
Miladin Modrakovic's Blog: Oraclue

GoldenGate error OGG-01755 SQL error: OCI Error 26,723 = ORA-26723 - I was trying to register extract OGG v 11.2 on one of my dev servers GGSCI (tpadldb10.gratiscard.com) 1> dblogin userid srvegate password xxxxx Successfu...
11 years ago
iDevelopment.info News

Oracle Database Name Resolution with OpenLDAP - Oracle Database Name Resolution with OpenLDAP Anyone who has ever worked with the Oracle Database is most likely familiar with the tnsnames.ora file. The...
11 years ago
Method R Corporation

Front Page - Method R software measures the *performance experience*. Book PDF for 1 developer or DBA 15 Workbench PDF and software for 1 developer or DBA 2,227 ...
12 years ago
Life After Coffee

S107G Mini Helicopter Review - I’m a long-time fan of radio controlled flight, so when XenonProject.com offered me the chance to review the S107G Mini RC Helicopter I was excited for the...
13 years ago
Dion Cho - Oracle Performance Storyteller

Interesting case of the restriction of global hints - One of my colleagues sent following test case, of which he couldn’t control the join order with hints. 1. Create objects – table t1, t2 and t3 2. Now Let’s...
13 years ago
Mufalani - DBA Oracle

Olá mundo - blah
13 years ago
Inside the Oracle Optimizer - Removing the black magic

We have moved! - You might have been wondering why things had gone so quiet on the Optimizer development team's blog Optimizer Magic over the last few months. Well the blog...
13 years ago
We Do Not Use Blogs

The only thing you should NOT ask Icelanders (and maybe Norwegians) to do... - I love to visit Iceland. Not because of the landscape (We Do Not Use landscapes), but because of the people there. Man, they're funny and good to talk to. ...
13 years ago
Ordinary Oracle Joe

Becoming an Oracle DBA part 2 - In an earlier post I discussed how I believed a framework or apprenticeship should be created to promote the career path of DBA to talented individuals. In...
13 years ago
Oracle is not Magic, it just takes years of experience

OOW 2009 1st report - It’s all about innovation that what Larry Ellison/Oracle and Scott McNealy/Sun said at the opening key note. I arrived to san Francisco for oow 2009 and I ...
14 years ago
Anil Passi Oracle Home

Customization and Development Book - About Oracle Apps Development Book Last few months, I have been extremely busy with writing a book about Oracle E-Business Suite development techniques inc...
15 years ago
SQL> oradeblog

Goodbye ORA-600, hello, Blue Gecko - Things are changing a little around here. I have been running ORA-600 Consulting for five years, and have made the big decision to join Blue Gecko, a remot...
15 years ago
The R. M. Menon blog on Database and J2EE

Dealing with Oracle PL/SQL Error "ORA-04068: existing state of packages has been discarded" Transparently in Java/JDBC - My next article is on how to deal with the infamous "ORA-04068" error that occurs when using PL/SQL packages in your application. I first wrote this articl...
16 years ago
Oracle Databases in Action

-
Structured Data

-
HP's Oracle Blog

-
Oracle DBA - Oracle Apps DBA Instant Solutions

-
The Grumpy DBA blogs . . .

-
Oracle - Tricks of the Trade

-
Frits Hoogland Weblog

-
BLOG RODRIGO ALMEIDA

-
lutz hartmann as sysdba

-
Jiltin's Blog

-
Home

-

Show 5 Show All

Travel theme. Powered by Blogger.