9 Replies Latest reply: Mar 20, 2014 7:28 PM by jgarry RSS

    sqlplus in oem

      Hi all,

       

      11.2.0.1

       

      Can I run a  sqlplus statement in OEM? like > select * from dba_segments;

       

      Thanks

      pK

        • 1. Re: sqlplus in oem
          sb92075

          petra-K wrote:

           

          Hi all,

           

          11.2.0.1

           

          Can I run a  sqlplus statement in OEM? like > select * from hr.emp;

           

          Thanks

          pK

          >> select * from hr.emp;

          above is a SQL  statement & independent of any client that issue it.

          • 2. Re: sqlplus in oem

            So?

            I dont understand what you mean dear.

            • 3. Re: sqlplus in oem
              jgarry

              One way is to create a scheduler job.  There are options in there to do various things if you don't want to execute immediate.  I seem to recall there is a more direct way to create and run a script, but it's been too long, I don't remember how.

              • 4. Re: sqlplus in oem
                BPeaslandDBA

                Which version of EM? Database Control or Grid/Cloud Control?

                 

                In EM12c Cloud Control, I can go to Targets --> Database and then click on the database in question. Then click on Performance --> SQL --> Run SQL.

                 

                Other versions have a slightly different way so your answer is version specific.

                 

                Cheers,
                Brian

                • 5. Re: sqlplus in oem

                  I am using the default/generic OEM.

                  I only want simple select statement, just like in sqldev.

                  I want oem as a one stop shop, so I wont open another window for sqldev or sqlplus to run select statements.

                  For example: Tablespaces, in OEM display it would not show if my tablespace is encrypted or not hence I want to select * from dba_tablespaces to get the info?

                   

                  Thanks all

                  • 6. Re: sqlplus in oem
                    sb92075

                    petra-K wrote:

                     

                    I am using the default/generic OEM.

                    I only want simple select statement, just like in sqldev.

                    I want oem as a one stop shop, so I wont open another window for sqldev or sqlplus to run select statements.

                     

                    Thanks all

                    when your only tool is a hammer, then every problem is viewed to be a nail.

                    a hammer is sub-optimal tool to remove a nut from a bolt or make 2 boards from a single piece of lumber.

                    different tools exist to complete different tasks.

                    • 7. Re: sqlplus in oem

                      Thanks Sb,

                       

                      Yikes How can a simple select statement be difficult for a tool to be accommodated? Or maybe you not not using OEM often, just like me

                       

                      Anyways I see that there is SQL Worksheet inside OEM, but when I run > select * from dba_data_files, it only show limited column display The encrypted column is not there.

                       

                      Helpppp.....

                      • 8. Re: sqlplus in oem

                        Oppps..sorry I just use the wrong sql statement, it should be select * from dba_tablespaces, and not the dba_data_files. I see the encrpyted column now

                        This OEM is really a great  one stop shop . I wish me and you will able to explore every bits of its details.

                         

                        Thanks all

                        • 9. Re: sqlplus in oem
                          jgarry

                          Having multiple windows open is a valuable skill.  Just be sure you have some indication which database you are about to mess up!