- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- How long does the Oracle call_stack stay available...
Operating System - HP-UX
1752274
Members
4680
Online
108786
Solutions
Forums
Categories
Company
Local Language
юдл
back
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
юдл
back
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Blogs
Information
Community
Resources
Community Language
Language
Forums
Blogs
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-05-2003 12:19 PM
тАО05-05-2003 12:19 PM
How long does the Oracle call_stack stay available?
Hi oracle database guru's:
We am investigating and trying to learn more about Oracle's database 'call_stack'. From what we have learned so far is that the call_stack, (when a procedure is executed from PL/SQL), the call_stack lists what is currently being executed in the procedure. So if an error occurs, it can show what was exactly happening at the time.
Our question:
How long is the information in the call_stack available for interegation? Is it only available during the current oracle session or can it be examined even from a non-current session? In other words, if a PL/SQL procedure would have an error, could we examine the data in the call_stack after the session has ended?
Thanks in advance,
Randy
We am investigating and trying to learn more about Oracle's database 'call_stack'. From what we have learned so far is that the call_stack, (when a procedure is executed from PL/SQL), the call_stack lists what is currently being executed in the procedure. So if an error occurs, it can show what was exactly happening at the time.
Our question:
How long is the information in the call_stack available for interegation? Is it only available during the current oracle session or can it be examined even from a non-current session? In other words, if a PL/SQL procedure would have an error, could we examine the data in the call_stack after the session has ended?
Thanks in advance,
Randy
2 REPLIES 2
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-24-2003 07:02 PM
тАО09-24-2003 07:02 PM
Re: How long does the Oracle call_stack stay available?
hi
it depends upon the number of distinct calls to the database. if the database is been bombed with tonnes of ad-hoc queries then chances are there that the call_stack would be empty soon. otherwise you can pin the object in pl/sql with dbms_shared_pool package and have the call_stack of that particular pl/sql always available.
hope this reply to some of your question.
it depends upon the number of distinct calls to the database. if the database is been bombed with tonnes of ad-hoc queries then chances are there that the call_stack would be empty soon. otherwise you can pin the object in pl/sql with dbms_shared_pool package and have the call_stack of that particular pl/sql always available.
hope this reply to some of your question.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-25-2003 10:03 AM
тАО09-25-2003 10:03 AM
Re: How long does the Oracle call_stack stay available?
Sandeep,
Kind of. The call stack is based primarily on the shared pool size (large shared pool, more space for SQL statements). Technically, distinct calls in a slow database can last for quite a while.
However, errors are not shown in the call stack, so while you would see the procedure being run in the v$sqlarea or v$sqltext, you would not necessarily see why it failed. You can get around this by coding in checkpoints in the script (ie: insert a check into a table, etc), or setting up an EXCEPTIONS clause to error out with information on what failed.
Also, whoever is getting the output of the failure (stdout, dbms_job, etc) should receieve a set of error messages defining what failed where.
To summarize, you can view SQL statements from other sessions. You will need to get the SQL_ADDRESS and PREV_SQL_ADDRESS from the v$session view for the session that you want to query, and select that information from the ADDRESS column in the v$sqlarea or v$sqltext views. I prefer v$sqltext for this, however you will want to make sure that you order by the address and piece columns to sort the data.
Hope this helps,
Thanks,
brian
Kind of. The call stack is based primarily on the shared pool size (large shared pool, more space for SQL statements). Technically, distinct calls in a slow database can last for quite a while.
However, errors are not shown in the call stack, so while you would see the procedure being run in the v$sqlarea or v$sqltext, you would not necessarily see why it failed. You can get around this by coding in checkpoints in the script (ie: insert a check into a table, etc), or setting up an EXCEPTIONS clause to error out with information on what failed.
Also, whoever is getting the output of the failure (stdout, dbms_job, etc) should receieve a set of error messages defining what failed where.
To summarize, you can view SQL statements from other sessions. You will need to get the SQL_ADDRESS and PREV_SQL_ADDRESS from the v$session view for the session that you want to query, and select that information from the ADDRESS column in the v$sqlarea or v$sqltext views. I prefer v$sqltext for this, however you will want to make sure that you order by the address and piece columns to sort the data.
Hope this helps,
Thanks,
brian
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.
News and Events
Support
© Copyright 2024 Hewlett Packard Enterprise Development LP