SQL Server
How to display Report Generating user name at the SSRS Report Footer
How to display Report Generating user name at the SSRS Report Footer
If you want to Speed up your Windows 10 OS, take a few minutes to try out these tips to speed up your PC and make it less prone to… Read more »
ERROR OGG-15163 There was a problem sending a message to EXTRACT (Timeout waiting for message) The EXTRACT looks hung, but its status is still showing is “RUNNING”. Restarting the process… Read more »
select b.tablespace_name, tbs_size SizeGb, a.free_space FreeGb from (select tablespace_name, round(sum(bytes)/1024/1024/1024 ,2) as free_space from dba_free_space group by tablespace_name) a, (select tablespace_name, sum(bytes)/1024/1024/1024 as tbs_size from dba_data_files group by tablespace_name UNION… Read more »
set feedback off set pagesize 70; set linesize 2000 set head on COLUMN Tablespace format a25 heading ‘Tablespace Name’ COLUMN autoextensible format a11 heading ‘AutoExtend’ COLUMN files_in_tablespace format 999 heading… Read more »
You can use below script to check how many existing indexes you have in your Mongo database for all collections. this is really helpful when you have one environment working… Read more »
What is MongoDB? MongoDB is an open-source database management system (DBMS) that uses a document-oriented data model. It is considered a NoSQL database, as it doesn’t use the relational model,… Read more »
How to check if tablespaces datafiles are autoextend col FILE_NAME for a60 select TABLESPACE_NAME, FILE_NAME,AUTOEXTENSIBLE,MAXBYTES from dba_Data_files where TABLESPACE_NAME like ‘Tablespace_Name’; _________________________________________________________________________________________________________________________ col FILE_NAME for a60 select TABLESPACE_NAME, FILE_NAME,AUTOEXTENSIBLE,MAXBYTES from… Read more »
Database and server details Report from OEM: Database version and Server Details 1- How do I get the number of databases for each category version? SELECT property_value, COUNT(*) FROM mgmt$target_properties… Read more »