Carlos Sierra's Tools and Tips

5 Responses

Subscribe to comments with RSS.

1. Hi Carlos,
   When i was trying to unzip the “cscripts-master.zip” on my LINUX server, i’m getting below error. Could you please let me know how can i resolve it?

   [oracle@dbofsaasit4 csscripts]$ ls -lrt
   total 4
   -rwxr-xr-x 1 oracle oinstall 58 Aug 4 06:48 cscripts-master.zip
   [oracle@dbofsaasit4 csscripts]$

   [oracle@dbofsaasit4 csscripts]$ unzip cscripts-master.zip
   Archive: cscripts-master.zip
   End-of-central-directory signature not found. Either this file is not
   a zipfile, or it constitutes one disk of a multi-part archive. In the
   latter case the central directory and zipfile comment will be found on
   the last disk(s) of this archive.
   note: cscripts-master.zip may be a plain executable, not an archive
   unzip: cannot find zipfile directory in one of cscripts-master.zip or
   cscripts-master.zip.zip, and cannot find cscripts-master.zip.ZIP, period.
   [oracle@dbofsaasit4 csscripts]$

   

   myjavaworks

   August 4, 2023 at 12:20 am

   Reply
   • I just tried to download and unzip cscripts-master.zip on my Mac and I see no issues. I suggest you download it again and test unzip on your PC or Mac.

     

     Carlos Sierra

     August 4, 2023 at 6:20 am

     Reply
     • Hi,
       Sure. I will again download and let you know.
       Thank you

       

       myjavaworks

       August 7, 2023 at 2:26 am
2. Hi Carlos

   Im uploading AWR data to a DB to analyze data, when I loaded that data I used 10000000 as DBID, but when I try to run your querys they dont produce output but:

   SQL> select dbid,count(1) from DBA_HIST_SQL_PLAN group by dbid; DBID COUNT(1)

   1000000000 437379
   789930104 18902

   SQL> select dbid,count(1) from dba_hist_snapshot group by dbid; DBID COUNT(1)

   1000000000 1610
   789930104 10

   it means the data is there, do I have a way to filter the data on your script by DBID?

   

   mauricioferia

   April 24, 2024 at 8:13 pm

   Reply
   • You may want to customize the scripts to fit your needs

     

     Carlos Sierra

     April 29, 2024 at 3:17 pm

     Reply