AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Free pascal asm db2/19/2023 Oracle ASM Diskgroups : Oracle ASM uses disk groups to store data files an Oracle ASM disk group is a collection of disks that Oracle ASM manages as a unit. Oracle ASM disks : Check out how to prepare the OS disks for ASM and how to add them to ASM Senior Software Engineer and Database Developer. Oracle ASM : Learn about Oracle Automatic Storage Management Concepts and Implementation Arc helps you find and hire top Pascal developers, coders, and consultants. SQLdb Tutorial4: Fourth part of the DB tutorial series, showing how to use data modules. SQLdb Tutorial2: Second part of the DB tutorial series, showing editing, inserting etc. Finally, there are a number of Pascal books available via stores like Amazon, here are a couple of Lazarus related books which can help you get going: Getting Started with Lazarus and Free Pascal: A beginners and intermediate guide to Free Pascal using Lazarus IDE, see here. SQLdb Tutorial1: First part of the DB tutorial series, showing how to set up a grid that shows database data. Hope you like this article on Oracle ASM queries. Youtube has a number of Pascal and Lazarus videos available, see here. SELECT D.NAME, D.PATH, D.MOUNT_STATUS, D.HEADER_STATUS, D.MODE_STATUS, D.STATE FROM V$ASM_DISK D, V$ASM_DISKGROUP G WHERE G.NAME = '&1'AND D.GROUP_NUMBER = G.GROUP_NUMBER Expert Free Pascal programmer in Unix environment (3-4 years of experience) Understands database internals and complex data structures used in database. QUERY TO DETERMINE THE STATE OF THE DISKS WITHIN A DISKGROUP SELECT NAME,STATE,UNBALANCED FROM V$ASM_DISKGROUP QUERY TO DETERMINE THE STATE AND BALANCE OF DISKGROUPS Starting in 10.2 this can be easily done with one query QUERY TO DETERMINE WHAT DISKGROUPS EXIST AND HOW FULL THEY ARE SELECT NAME,TOTAL_MB,USABLE_FILE_MB FROM V$ASM_DISKGROUP SELECT concat('+'||gname, sys_connect_by_path(aname, '/')) full_alias_pathįROM (SELECT g.name gname, a.parent_index pindex, a.name aname,a.reference_index rindexĪND gname = 'MDDX1')START WITH (mod(pindex, power(2, 24))) = 0 QUERY TO DETECT FILES IN AN ASM DISKGROUP BEFORE DROPPING col full_path format a50 REBALANCE INFORMATION select GROUP_NUMBER, OPERATION, STATE, ACTUAL, SOFAR, EST_MINUTES from v$asm_operation Select dg.name dg_name, dg.state dg_state, dg.type, d.disk_number dsk_no,d.path, d.mount_status, d.FAILGROUP, d.statefrom v$asm_diskgroup dg, v$asm_disk dwhere dg.group_number=d.group_numberorder by dg_name, dsk_no Select DISK_NUMBER,MOUNT_STATUS,HEADER_STATUS,MODE_STATUS,STATE,PATH FROM V$ASM_DISK FYI: the emulator is written in Borland Pascal/Free Pascal and the source is GPL. Select GROUP_NUMBER DG#, name, ALLOCATION_UNIT_SIZE AU_SZ, STATE,TYPE, TOTAL_MB, FREE_MB, OFFLINE_DISKS from v$asm_diskgroup With this emulator, you can also code in assembly. The below queries list down various ways to add the disks in the diskgroup ALTER DISKGROUP DATA ADD DISK'/devices/hdisk ' ALTER DISKGROUP DATA ADD DISK'/devices/hdisk4' ĪLTER DISKGROUP DATA ADD DISK'/devices/hdisk*'REBALANCE POWER 5 WAIT ĪLTER DISKGROUP DATA ADD DISK'/devices/hdisk5' NAME DATA5,'/devices/hdisk6' NAME DATA6,'/devices/hdisk7' NAME DATA7,'/devices/hdisk8' NAME DATA8,ĪSM DISK INFORMATION set pages 40000 lines 120
0 Comments
Read More
Leave a Reply. |