This video will give you basic idea about tablespace issue.
Plese find the following important query .
Query to check tablespace usage
group by TABLESPACE_NAME
sum(BYTES) BYTES ,
group by TABLESPACE_NAME
order by ((a.BYTES-b.BYTES)/a.BYTES) desc;
To check datafiles respective to tablespace_name.
col tablespace_name format a30;
col file_name format a40;
SELECT TABLESPACE_NAME, FILE_NAME, BYTES/1024/1024 FROM DBA_DATA_FILES where TABLESPACE_NAME='&tablespace_name';
To check ASM disk group usage
select name, group_number, name, type, state, total_mb, free_mb from v$asm_diskgroup;
Please comment , like, subscribe and reach me if you have any query.
EmailId: [email protected]
I am professional part time oracle dba trainer and having good experience in oracle database administration.
This is the right place to enroll yourself for Oracle DBA real time course.
Please use following email ID for more details. Don’t hesitate to WhatsApp me any time. I will give you the best training and will create path to get DBA job easily.
Enjoy the free YouTube video and connect with me for deep Oracle DBA knowledge.
Mobile No : + 91 9960262955 (WhatsApp Number)
EmailID: an[email protected]
The effective home remedies for baldness and hair loss in men include oil massages and including coconut milk, eggs, avocados, orange juice, aloe vera, neem paste, henna, mayonnaise, honey, black pepper, vinegar, and lemon juice in their diet. The remedies also include cutting back on red meat, eating nuts and brown rice, boosting B-complex vitamin intake, and maintaining good thyroid health.
For millions of men across the world, regardless of culture, class, nationality, religion, or color, hair loss is an unavoidable aspect of growing older. Fortunate are those who do not face hair loss problems even in their old age. However, a majority of men face this issue in their 40s, 50s, or even earlier.
Causes of Baldness or Hair Loss in Men.
There are a number of causes of male hair loss, including:
Male pattern baldness Alopecia Fungal infections Psychological disorders Chemotherapy side effects Nutrient deficiencies Hormonal imbalances Lack of circulation on the scalp Stress.
It is important to note that hair loss occurs in women as well, for some similar reasons, and some different ones. We will cover hair loss in women in a separate article. Men predominantly suffer from this health condition, particularly male pattern baldness and early onset hair loss from age 20-40.
However, there are ways to slow down the rate of male hair loss or baldness, and even stimulating the hair follicles to reproduce hair. A few home remedies for hair loss and baldness issue are discussed below.