Posted by Mir Sayeed Hassan on 31st December 2017
How to release deleted file size without reboot of server Check the size of the disks: [root@DB ~]# df –h Filesystem Size Used Avail Use% Mounted on /dev/mapper/vg_db-root 22G 16G 5.0G 76% / tmpfs 20G … Read more..
Posted in MISCELLANEOUS | Comments Off on How to release deleted file size without reboot of server
Posted by Mir Sayeed Hassan on 25th December 2017
Run SQL Query from Linux command as shown below: Method 1: [oracle@testdb ~]$ echo “select table_name from user_tables;” | sqlplus -s mir/mir123 TABLE_NAME —————————— TEST1 TEST2 [oracle@testdb ~]$ echo “select * from test1;” | sqlplus -s mir/mir123 ENO ———- 1 2
Posted in MISCELLANEOUS | Comments Off on Run SQL Query from Linux command as shown below:
Posted by Mir Sayeed Hassan on 25th December 2017
Copy OS files from one location to another by sql*plus using Oracle function UTL_FILE.FCOPY Overview: Create the sample 2 directories for test & create 1 file in one of the directory therefore create a user for new test or use existing user. Grant the appropriate privilege to the user and copy the files from one Read More
Posted in MISCELLANEOUS | Comments Off on Copy OS files from one location to another by sql*plus using Oracle function UTL_FILE.FCOPY
Posted by Mir Sayeed Hassan on 4th October 2017
Find the Quick General query as per your requirement Find the status of the database SQL> select status from v$instance; STATUS ———— OPEN SQL> select database_status from v$instance; DATABASE_STATUS —————– ACTIVE Or – To get… Read more..
Posted in MISCELLANEOUS | Comments Off on Find the Quick General query as per your requirement