1. Finding Volume group
{p0104crmp05}/home/sdtsldba$ lsvg
rootvg
sh_crmp05_vg2
hb_crmp05_vg1
hb_crmp06_vg1
sh_tmspdb_203
altinst_rootvg
2. Finding the file system in which volume group
{p0104crmp05}/home/sdtsldba$ lsvg -l sh_tmspdb_203
3. Size of the file system
{p01102sbap03}/home/oracle$ lslv ssp_jx_data17
LOGICAL VOLUME: ssp_jx_data17 VOLUME GROUP: orascanlive_206
LV IDENTIFIER: 0031f1df00004c00000001122e2daed5.25 PERMISSION: read/write
VG STATE: active/complete LV STATE: opened/syncd
TYPE: raw WRITE VERIFY: off
MAX LPs: 512 PP SIZE: 128 megabyte(s)
COPIES: 2 SCHED POLICY: parallel
LPs: 112 PPs: 224
STALE PPs: 0 BB POLICY: relocatable
INTER-POLICY: minimum RELOCATABLE: yes
INTRA-POLICY: middle UPPER BOUND: 2
MOUNT POINT: N/A LABEL: None
MIRROR WRITE CONSISTENCY: off
EACH LP COPY ON A SEPARATE PV?: yes (superstrict)
Serialize IO? NO
Size: SSP IDX Actual 112x128= 14336M
Random Posts
Blog Archive
ORACLE DBA
Search This Blog
Blog Archive
-
▼
2011
(101)
-
▼
July
(79)
- oracle RAC Commands
- 10g ORACLE
- Thirupal_Boreddy_oracle_DBA: Thirupal_Boreddy_orac...
- To monitor job progress[RMAN]
- systemstate and hang analyse
- Thirupal_Boreddy_oracle_DBA: systemstate and hang ...
- UNIX raw filesystem commands for dba
- Thirupal_Boreddy_oracle_DBA: Thirupal_Boreddy_orac...
- ENQUEUE LOCK:
- Thirupal_Boreddy_oracle_DBA: Thirupal_Boreddy_orac...
- The Archiver hung alerts
- How to register database with RMAN recovery catalog
- Thirupal_Boreddy_oracle_DBA: Procedure to relocate...
- dbms_metadata
- Thirupal_Boreddy_oracle_DBA: systemstate and hang ...
- set date format
- Thirupal_Boreddy_oracle_DBA: systemstate and hang ...
- Static Parameter
- HSMP cluster commands:
- HSMP cluster commands:
- systemstate and hang analyse
- OMS Commands
- Thirupal_Boreddy_oracle_DBA: OMS Commands
- crs commands
- crs commands
- crs commands
- Process for clearing down archivelogs via Rman
- Thiru: Process for clearing down archivelogs via Rman
- Converting to archive log mode in RAC
- Thiru: Converting to archive log mode in RAC
- Steps for VIP Relocation
- Thiru: Converting to archive log mode in RAC
- Add space in RAC DB TABLESPACES:
- Thiru: Process for clearing down archivelogs via Rman
- Chang Archive log destination
- Thiru: Chang Archive log destination
- Manual Archive Backup
- Thiru: Manual Archive Backup
- Thiru: To monitor job progress[RMAN]
- Thiru: Thirupal_Boreddy_oracle_DBA: ENQUEUE LOCK:
- Thiru: Chang Archive log destination
- RMAN Checks
- Thiru: RMAN Checks
- ASM – basic things to look for
- Thiru: RMAN Checks
- Killing a Hanging CRSD Daemon;
- Thiru: ASM – basic things to look for
- Useful CRS Commands
- Thiru: Useful CRS Commands
- Thiru: Useful CRS Commands
- Useful CRS Commands
- Thiru: Useful CRS Commands
- Operating System Commands
- Thiru: Useful CRS Commands
- Tracing a SQL session
- Check cluster name
- The Archiver hung alerts
- Log file locations in RAC
- Thiru: Tracing a SQL session
- System state dump and Hanganalyze
- Thiru: The Archiver hung alerts
- RAC - Healthchecking the Startup of Oracle for a g...
- Thiru: Log file locations in RAC
- RAC - Stopping everything Oracle-related for a giv...
- Thiru: Procedure to relocate services in RAC nodes
- Enabling Archive Logs in a RAC Environment
- Adding a new vote disk
- Thiru: Enabling Archive Logs in a RAC Environment
- Export of table Partition
- Flashback setup in RAC
- Voting Disk
- Post database creation CRS Health check
- RAC Troubleshooting
- Change the parameters for RAC database
- Compressed Export and Import
- Adding the space to tablespace
- Change db_recovery_file_dest_size
- Restarting SSH broker in the event of a hang
- Thiru: Thirupal_Boreddy_oracle_DBA: oracle RAC Com...
-
▼
July
(79)
Thirupal Boreddy. Powered by Blogger.
My Blog List
Followers
Lorem 1
Technology
Circle Gallery
‹
›
Shooting
Racing
News
Lorem 4
Tagged with: UNIX raw filesystem commands for dba
About Oracle DBA World
WePress Theme is officially developed by Templatezy Team. We published High quality Blogger Templates with Awesome Design for blogspot lovers.The very first Blogger Templates Company where you will find Responsive Design Templates.
Subscribe to:
Post Comments (Atom)
QUERY FOR CPU USAGE
select a.target_name as HOST, to_char(a.rollup_timestamp,' dd-Mon-yy::hh24:mi') as "DAY-TIME", sum(c.cpu_count) as ...


No comments