PSAPSR3 IS 86 %

[Former Member]

Dear Team

I have check my table space .my PSAPSR3 IS 86 %

PSAPSR3 52,288.00 5,864.00 86 YES 240,000.00

PSAPSR3700 95,964.00 21,170.44 83 YES 200,960.00

PSAPSR3USR 20.00 18.06 9 YES 10,000.00

PSAPTEMP 2,000.00 2,000.00 0 YES 10,000.00

PSAPUNDO 8,940.00 8,682.56 3 YES 10,000.00

SYSAUX 440.00 173.63 61 YES 11,024.00

SYSTEM 1,640.00 790.94 50 YES 12,048.00

Plesae suggest . what to do and how

Thanks

manu

[markus_doehr2 · Accepted solution]

start brtools and add a data file.

Markus

[Former Member · Accepted solution]

Thanks Marks for your repply.

Marks Can I add datafile or Extended data file,

Please suggest

Thnaks

manu

[Former Member · Accepted solution]

Depends on you if you want to extend you can or add new datafile.

there are few OS limitation for file size, please check first.

cheers,

-Sunil

[markus_doehr2 · Accepted solution]

As already said it depends on your setup and what you want.

Try to two day Oracle DBA course to understand, what is going on with the database and how Oracle works:

http://www.oracle.com/pls/db102/homepage?remark=tahiti

Markus

[Former Member · Accepted solution]

thanks Sunil, For your repply.

/oracle/PRD/sapdata1 72318976 31010720 40985600 43%

/oracle/PRD/sapdata2 73367552 29033080 43988112 40%

/oracle/PRD/sapdata3 74416128 36411984 37707240 49%

/oracle/PRD/sapdata4 75464704 32602784 42527064 43%

/oracle/PRD/sapdata5 76513280 34622152 41563856 45%

/oracle/PRD/oraarch 40960000 32000082 6595216 84%

In My OS level File system space is there , So now I can simply Extend the Tablespace

Thanks

Manu

[Former Member · Accepted solution]

Thanks marks,

Marks I am using ECC 6.0 with Oracle 10 on HPUX.I should Add or Extend Table space

Thanks

manu

[former_member204746 · Accepted solution]

I would extend an existing datafile this command:

brspace -c -u / -f dfalter

[Former Member · Accepted solution]

how i run this command . In command Prompt?

manu

[Former Member · Accepted solution]

Hi Manu,

If your PSAPSR3 tablespace is 86% it is ok till 90 %. But if still if you have some issue you can extend your tablespace using BRTOOLS.

It will automatically extend your table space. If you have any doubt on extending the tablespace please let me know.

Thanks,

Bhanu Pratap Singh

[former_member204746 · Accepted solution]

yes, Manu Jain,

you run my command at a command prompt.

[Former Member · Accepted solution]

Thanks Bhanu for your reply. I have extend table space by brtools . now i have suffesuient space,

Thanks

manu

[Former Member]

hi manu

if table spaces in ASM no problem.if they are not in ASM u add the datafile through brtools or SQL level (login as sysdba user)

[Former Member]

hi manu

if table spaces in ASM no problem.if they are not in ASM u add the datafile through brtools or SQL level (login as sysdba user)

[Former Member]

Thanks Vasu for your reply.

Vasu what the mean of ASM ?. and I want to ADD datafile via BRTOOLS. Can I ADD ?

Thanks

Manu

[Former Member]

you can add datafile to tablespace, check whether the tablespace is in autoextend mode or not (db02) if the tablespace is in automode then not required to add datafile manually. if not then add datafile using brtools.

ASM is Automatic Storage Management

cheers,

-Sunil

[former_member204746]

to add a datafile, use this command:

brspace -c -u / -f tsextend

[Former Member]

Thanks Sunil for repply . I check with DB02

Tablespace Size Free Used Autoextend

PSAPSR3 52,288.00 5,366.63 90 YES

PSAPSR3700 95,964.00 21,770.38 77 YES

PSAPSR3USR 20.00 18.06 10 YES

PSAPTEMP 2,000.00 2,000.00 0 YES

PSAPUNDO 8,940.00 8,467.56 5 YES

SYSAUX 440.00 170.81 61 YES

SYSTEM 1,640.00 790.94 52 YES

Its Mean my PSAPSR3 is 90% used But it is autoextend . But for performance I want to Add datafile so that PSAPSR3 has more free Space.

So Can I add one more datafile of 2 GB

Thanks

manu

[former_member204746]

check the command I provided, it will enable you to add a 2GB datafile.

brspace -c -u / -f tsextend

[Former Member]

Thanks for your reply,

If I not add datafile . What will happend?

This file is a Autoextend . What will happend?

Thanks

manu