RE: How to find the last execution time of a Procedure.

Thanks John and everyone for their suggestions. Best Regards, Prasad John Kanagaraj

RE: How to find the last execution time of a Procedure.

Thanks for your input, Naveen. But, It is hard to do that since everything is under Production Support Team control. Best Regards, Prasad

How to find the last execution time of a Procedure.

Hi All, Is there anyway to find out from data dictionary views when was a database procedure/function last executed. Would like know the solution for 8i and 9i databases. We have some older code in the databases and do not know if any application is using it or not. I appreciate your help.

RE: How to find the last execution time of a Procedure.

Thanks for input Raj. I was also thinking on the same lines (Querying v$views periodically and store it in some metadata table) if there is no easier way to figure out from DBA_ views. As far as changing the production code, as you know, It has to go thru the dev/test databases first and then

RE: How to find the last execution time of a Procedure.

Thanks Raj. I have confidence on you and hope we will meet in next CTOUG meeting. Best Regards, Prasad 860 843 8377 Jamadagni,

Re: Hiding passwords

There is a good discussion in asktom website on this topic. Here is the link : http://asktom.oracle.com/pls/ask/f?p=4950:8:F4950_P8_DISPLAYID:142212348066 Hth. Best Regards, Prasad

Congratulations Arup (DBA of the Year)

Just came to know from CTOUG news that Oracle has chosen Arup Nanda(our List member) as DBA of the Year. Congratulations Arup. thought I will share this news with the group. CTOUG Board Member, Arup Nanda, Chosen as DBA of the Year Oracle has chosen our very own CTOUG board member, Arup Nanda,

Change Data Capture

I am testing the Change Data Capture and for the most part I am able to get it working. I have the following issues/questions. 1. I published 3 columns out of 9 column table and subscribed those 3 columns. When I make a change to the columns that were not published/subscribed, I see change

DBMS_STATS and CBO

We have a table (monthly fact table) which has 24 partitions and partitioned by month. There is data in only 3 partitions. All the indexes are locally partitioned. In dev db, I analyzed the table and indexes with analyze table..compute statistics. When I query the no. of rows group by month, it

Re: After Logon Trigger and Import

Sorry, I forgot to mention the OS and Oracle Version. It is Hp-UX v11 and Oracle 8.1.7.4 Thanks. Best Regards, Prasad 860 843 8377

RE: DBMS_STATS and CBO

Thanks Govind for your reply and suggestion. Actually, I did 'FOR ALL COLUMNS SIZE 1' only. Here is the SQL I used : EXECUTE DBMS_STATS.GATHER_SCHEMA_STATS ('DISCLM',NULL,FALSE,'FOR ALL COLUMNS SIZE 1',4,'ALL',TRUE); Best Regards, Prasad 860 843 8377

After Logon Trigger and Import

Hi, I put the 'alter session set skip_unusable_indexes=true' in the logon trigger of a particular user and tested it in the sql*plus session. It is working fine there. I tested it by making an index unusable and inserting the data into the table. But, when I tried to import (using the same

RE: IMP-00020: long column too large for column buffer size (22)

I thought I would share this information with the List. When we ftp'ed the file from NT to UNIX in Binary mode, we were able to import the tables we needed with 'tables' option in import. It wasn't working with 'full=y' option. Developer is verifying the data to make sure it looks good.

Re: streams comments

Hi, I also started looking into Oracle streams for change data capture framework. My research is still in the beginning phase. I found that there is nice article (3 part series) on Change data capture using Oracle streams. Here is the link :

RE: DBMS_STATS and CBO

Thanks Govind and Tanel for your replies. Since I was testing both ways (analyze table and dbms_stats) before, I cleared out the stats using analyze table..delete statistics and dbms_stats.delete_table_stats. Then, I generated stats using dbms_stats.gather_table_stats and it is working fine

Re: After Logon Trigger and Import

Thanks very much Arup for your suggestion. Actually, Tables and indexes are already exist in the schema. I just have to copy the data from one environment to other environment. So I thought I will make the indexes unusable, load the data and rebuild the indexes with nologging, parallel and

RE: IMP-00020: long column too large for column buffer size (22)

Thanks for all those who responded my mail. When there was buffer parameter or record length parameter, It did not work. Instead of importing the full dmp file, If I try to import one table, it is working okay. I still have to try couple of alternatives and let the List Group know the outcome.

IMP-00020: long column too large for column buffer size (22)

Hi All, One of our developer ftp'ed the export (dmp) file from UNIX to NT in ASCII mode. He didn't know that it supposed to be done in BINARY mode. Now, he ftp'ed the dmp file back to UNIX in ASCII mode and tried doing the import. Looks like dmp file has been corrupted and Import is giving

Re: Union quries: INTERSECT, MINUS, etc

Jonathan, We use MINUS technique heavily in our DW environment to get the source system changes since we last extracted. We do 2-way minus (src to ods and ods to src). Best Regards, Prasad -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED]