Comments on: DBA SCRIPTS https://dbaclass.com/monitor-your-db/ database administration Tue, 20 Jun 2023 10:13:44 +0000 hourly 1 https://wordpress.org/?v=6.5.5 By: Maryam https://dbaclass.com/monitor-your-db/#comment-203356 Tue, 20 Jun 2023 10:13:44 +0000 http://dbaclass.com/?page_id=1370#comment-203356 can you please upload script for the daily/ weekly/ monthly and one-time activities for a DBA?

]]> By: Maryam https://dbaclass.com/monitor-your-db/#comment-203355 Tue, 20 Jun 2023 10:12:42 +0000 http://dbaclass.com/?page_id=1370#comment-203355 can you please upload script for the daily/ weekly/ monthly and one-time for a DBA?

]]> By: pankaj verma https://dbaclass.com/monitor-your-db/#comment-182247 Tue, 24 Jan 2023 20:28:48 +0000 http://dbaclass.com/?page_id=1370#comment-182247 Awesome collection. found alot of stuff tht i lost. Thanks

]]> By: Nancy https://dbaclass.com/monitor-your-db/#comment-171930 Thu, 10 Nov 2022 11:30:11 +0000 http://dbaclass.com/?page_id=1370#comment-171930 I am trying to create one new schema… I need to give grant insert to that new schema.. can u suggest on the same.
Request is like create schema and grant insert privilege to it.

]]> By: Lingam https://dbaclass.com/monitor-your-db/#comment-158848 Thu, 29 Sep 2022 18:42:40 +0000 http://dbaclass.com/?page_id=1370#comment-158848 Dear Team,

Is there a way we can monitor Tablespace usage and if the Tablespace growth is more than 20 or 30 GB then an alert is triggered

]]> By: Siva https://dbaclass.com/monitor-your-db/#comment-152909 Tue, 06 Sep 2022 02:18:42 +0000 http://dbaclass.com/?page_id=1370#comment-152909 how i can see materilized viwes in oracle database and how i can start/stop that ml views

]]> By: Hamid Afroze https://dbaclass.com/monitor-your-db/#comment-140446 Mon, 23 May 2022 16:03:13 +0000 http://dbaclass.com/?page_id=1370#comment-140446 Very handy , appreciate for sharing , can you plz add some scripts on the table fragmentation and reorg on them.
Moving into same tablespace or different tablespace with online and advance compressions etc.

]]> By: Vrushabh https://dbaclass.com/monitor-your-db/#comment-133047 Thu, 31 Mar 2022 10:59:32 +0000 http://dbaclass.com/?page_id=1370#comment-133047 Can i get query to know how many users are currently using the database?

]]> By: Sai krishna https://dbaclass.com/monitor-your-db/#comment-129636 Thu, 17 Feb 2022 07:08:41 +0000 http://dbaclass.com/?page_id=1370#comment-129636 Hi All

Please provide a script for storing(as procedure) cpu and memory statistic’s for every 15minutes

]]> By: Biswa https://dbaclass.com/monitor-your-db/#comment-122257 Fri, 22 Oct 2021 07:41:26 +0000 http://dbaclass.com/?page_id=1370#comment-122257 Would you please provide a script for daily growth of schemas.

]]>